SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Category](
	[CategoryID] [int] IDENTITY(1,1) NOT NULL,
	[CategoryName] [nvarchar](50) NULL,
	[CategoryAliasName] [varchar](50) NULL,
	[ParentNode] [int] NULL,
	[NodePath] [varchar](max) NULL,
	[CategoryOrder] [int] NULL CONSTRAINT [DF_Category_CategoryOrder]  DEFAULT ((0)),
	[SEOTitle] [nvarchar](200) NULL,
	[SEOKeywords] [nvarchar](200) NULL,
	[SEODescription] [nvarchar](500) NULL,
	[IsRecommend] [int] NULL CONSTRAINT [DF_Category_IsRecommend]  DEFAULT ((0)),
	[CategoryStatus] [int] NULL CONSTRAINT [DF_Category_CategoryStatus]  DEFAULT ((1)),
	[Link] [varchar](100) NULL,
	[FormTemplateID] [int] NULL,
 CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED 
(
	[CategoryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET IDENTITY_INSERT [Category] ON 

INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (24, N'冶金钢材', N'gangcai', 0, N'24', 0, N'冶金钢材', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (25, N'螺纹钢', N'luowengang', 24, N'24/25', 0, N'螺纹钢', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (26, N'普通圆钢', N'putongyuangang', 24, N'24/26', 0, N'普通圆钢', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (27, N'模具钢', N'mojugang', 24, N'24/27', 0, N'模具钢', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (28, N'结构钢', N'jiegougang', 24, N'24/28', 0, N'结构钢', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (29, N'铁矿石', N'tiekuangshi', 24, N'24/29', 0, N'铁矿石', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (30, N'橡胶塑料', N'suliao', 0, N'30', 0, N'橡胶塑料', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (31, N'通用塑料', N'tongyongsuliao', 30, N'30/31', 0, N'通用塑料', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (32, N'天然橡胶', N'tianranxiangjiao', 30, N'30/32', 0, N'天然橡胶', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (33, N'合成橡胶', N'hechengsujiao', 30, N'30/33', 0, N'合成橡胶', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (34, N'日用塑胶', N'rirongsujiao', 30, N'30/34', 0, N'日用塑胶', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (35, N'包装材料', N'baozhuangcailiao', 30, N'30/35', 0, N'包装材料', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (36, N'纺织皮革', N'pige', 0, N'36', 0, N'纺织皮革', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (37, N'人棉面料', N'renmiancailiao', 36, N'36/37', 0, N'人棉面料', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (38, N'涤纶面料', N'tiaolunmianliao', 36, N'36/38', 0, N'涤纶面料', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (39, N'针织面料', N'zhenzhimianliao', 36, N'36/39', 0, N'针织面料', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (40, N'棉纱布', N'mianshabu', 36, N'36/40', 0, N'棉纱布', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (41, N'包装', N'baozhuang', 0, N'41', 0, N'包装', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (42, N'纸包装', N'zhibaozhuang', 41, N'41/42', 0, N'纸包装', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (43, N'复合材料', N'fuhecailiao', 41, N'41/43', 0, N'复合材料', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (44, N'包装机', N'baozhuangji', 41, N'41/44', 0, N'包装机', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (45, N'礼品袋', N'lipindai', 41, N'41/45', 0, N'礼品袋', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (46, N'贴标机', N'tiebiaoji', 41, N'41/46', 0, N'贴标机', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (47, N'红酒盒', N'hongjiuhe', 41, N'41/47', 0, N'红酒盒', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (48, N'无纺布袋', N'wufangbudai', 41, N'41/48', 0, N'无纺布袋', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (49, N'数码印花', N'shumayinhua', 41, N'41/49', 0, N'数码印花', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (51, N'五金', N'wujin', 0, N'51', 0, N'五金', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (52, N'轴承', N'zhoucheng', 51, N'51/52', 0, N'轴承', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (53, N'锁具', N'suoju', 51, N'51/53', 0, N'锁具', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (54, N'螺钉', N'luoding', 51, N'51/54', 0, N'螺钉', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (58, N'齿轮', N'chilun', 51, N'51/58', 0, N'齿轮', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (59, N'机械工业', N'jixie', 0, N'59', 0, N'机械工业', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (60, N'机床', N'jichuang', 59, N'59/60', 0, N'机床', N'', N'', 0, 1, NULL, 18)
INSERT [Category] ([CategoryID], [CategoryName], [CategoryAliasName], [ParentNode], [NodePath], [CategoryOrder], [SEOTitle], [SEOKeywords], [SEODescription], [IsRecommend], [CategoryStatus], [Link], [FormTemplateID]) VALUES (61, N'风机', N'fengji', 59, N'59/61', 0, N'风机', N'', N'', 0, 1, NULL, 18)
SET IDENTITY_INSERT [Category] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别表自增长ID,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'CategoryID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别中文名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'CategoryName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别英文名称/别名/拼音字母' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'CategoryAliasName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父节点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'ParentNode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'节点路径,每节点使用/分开' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'NodePath'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别排序,默认值为0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'CategoryOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SEO标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'SEOTitle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SEO关键词' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'SEOKeywords'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SEO描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'SEODescription'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否推荐;0不推荐(默认值),1推荐' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'IsRecommend'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别状态,0无效/禁用,1有效(默认值)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'CategoryStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'跳转链接,如果不为空,则使用指定的链接地址,默认为空' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'Link'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表单模板ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Category', @level2type=N'COLUMN',@level2name=N'FormTemplateID'
GO
