SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [ShopNavigation](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[Directory] [varchar](50) NULL,
	[Link] [varchar](200) NULL,
	[Model] [int] NULL,
	[Target] [int] NULL CONSTRAINT [DF_ShopNavigation_Target]  DEFAULT ((0)),
	[UserID] [int] NULL,
	[Sequence] [int] NULL CONSTRAINT [DF_ShopNavigation_Sequence]  DEFAULT ((0)),
	[Status] [int] NULL CONSTRAINT [DF_ShopNavigation_Status]  DEFAULT ((1)),
	[Template] [varchar](50) NULL,
	[Editor] [nvarchar](50) NULL,
	[UpdateDate] [datetime] NULL CONSTRAINT [DF_ShopNavigation_UpdateDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_ShopNavigation] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [ShopNavigation] ON 

INSERT [ShopNavigation] ([ID], [Name], [Directory], [Link], [Model], [Target], [UserID], [Sequence], [Status], [Template], [Editor], [UpdateDate]) VALUES (1, N'首页', N'', N'', 1, 0, 6, 1, 1, N'News', NULL, CAST(N'2013-10-20 17:18:10.200' AS DateTime))
INSERT [ShopNavigation] ([ID], [Name], [Directory], [Link], [Model], [Target], [UserID], [Sequence], [Status], [Template], [Editor], [UpdateDate]) VALUES (2, N'关于我们', N'about', N'', 1, 1, 6, 2, 1, N'News', NULL, CAST(N'2013-10-06 22:55:42.663' AS DateTime))
INSERT [ShopNavigation] ([ID], [Name], [Directory], [Link], [Model], [Target], [UserID], [Sequence], [Status], [Template], [Editor], [UpdateDate]) VALUES (4, N'公司动态', N'news', N'', 2, 0, 6, 3, 1, N'News', NULL, CAST(N'2013-10-20 16:58:07.153' AS DateTime))
INSERT [ShopNavigation] ([ID], [Name], [Directory], [Link], [Model], [Target], [UserID], [Sequence], [Status], [Template], [Editor], [UpdateDate]) VALUES (5, N'公司产品', N'Product', N'', 2, 0, 6, 4, 1, N'Product', NULL, CAST(N'2013-10-20 16:58:49.127' AS DateTime))
INSERT [ShopNavigation] ([ID], [Name], [Directory], [Link], [Model], [Target], [UserID], [Sequence], [Status], [Template], [Editor], [UpdateDate]) VALUES (6, N'在线留言', N'Message', N'', 5, 0, 6, 5, 1, N'Message', NULL, CAST(N'2013-10-20 17:00:17.273' AS DateTime))
INSERT [ShopNavigation] ([ID], [Name], [Directory], [Link], [Model], [Target], [UserID], [Sequence], [Status], [Template], [Editor], [UpdateDate]) VALUES (7, N'联系我们', N'Contact', N'', 2, 0, 6, 7, 1, N'News', NULL, CAST(N'2013-10-20 17:01:00.087' AS DateTime))
INSERT [ShopNavigation] ([ID], [Name], [Directory], [Link], [Model], [Target], [UserID], [Sequence], [Status], [Template], [Editor], [UpdateDate]) VALUES (8, N'在线预约', N'Reservation', N'http://demo.bixiu.net', 1, 0, 6, 8, 1, N'Message', NULL, CAST(N'2013-10-20 18:22:20.827' AS DateTime))
SET IDENTITY_INSERT [ShopNavigation] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'导航名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'目录名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'Directory'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接地址,如果不为空,表示跳转' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'Link'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'频道/栏目模型选择' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'Model'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接打开方式,0原窗口,1新窗口' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'Target'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当前导航属于哪个用户下的' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'顺序,默认为0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'Sequence'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态,0隐藏,1显示(默认)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模板名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'Template'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编辑人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'Editor'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ShopNavigation', @level2type=N'COLUMN',@level2name=N'UpdateDate'
GO
