表名：ZL_CreateJS












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2Jsnamenvarchar2550   是 代码名称
3JsReadmenvarchar10000   是 简介
4ContentTypeint40   是 内容代码格式
5JsFileNamenvarchar2550   是 文件名
6JsTypeint40   是 JS类型
7JsXmlContentntext160   是 配置XML内容

简要说明：

内容JS记录表

GO
CREATE TABLE [dbo].[ZL_CreateJS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Jsname] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[JsReadme] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[ContentType] [int] NULL,
[JsFileName] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[JsType] [int] NULL,
[JsXmlContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_ZL_CreateJS] PRIMARY KEY CLUSTERED
(
[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'代码名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_CreateJS', @level2type=N'COLUMN',@level2name=N'Jsname'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'简介' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_CreateJS', @level2type=N'COLUMN',@level2name=N'JsReadme'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'内容代码格式' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_CreateJS', @level2type=N'COLUMN',@level2name=N'ContentType'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'文件名' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_CreateJS', @level2type=N'COLUMN',@level2name=N'JsFileName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'JS类型' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_CreateJS', @level2type=N'COLUMN',@level2name=N'JsType'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'配置XML内容' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_CreateJS', @level2type=N'COLUMN',@level2name=N'JsXmlContent'

--注意：将清空全表数据

detele from ZL_CreateJS

--注意：将删除整个表

drop table ZL_CreateJS

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_CreateJS