表名：ZL_Model












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1ModelIDint40是是 否 模型ID
2ModelNamenvarchar500   否 模型名称
3Descriptionnvarchar2500   是 模型说明
4TableNamenvarchar500   否 模型关联的表名
5ItemNamenvarchar500   是 项目名称：如文章、新闻
6ItemUnitnvarchar200   是 项目单位：如篇、条
7ItemIconnvarchar2550   是 项目图标
8ContentTemplatenvarchar2550   是 内容模板
9ModelTypeint40   是1模型类别 1-内容模型 2-商品模型 3-会员模型 4-黄页模型
10MultiFlagbit10   是0 
11NodeIDint40   是0节点ID
12SysModelint40   是2识别系统模型字段，1：系统生成模型，2：用户自定义模型
13FromModelint40   是0复制来源模型
14Thumbnailnvarchar5000   是 缩略图URL
15Islotsizebit10   是0 

简要说明：

模型列表

GO
CREATE TABLE [dbo].[ZL_Model](
[ModelID] [int] IDENTITY(1,1) NOT NULL,
[ModelName] [nvarchar](50) NOT NULL,
[Description] [nvarchar](250) NULL,
[TableName] [nvarchar](50) NOT NULL,
[ItemName] [nvarchar](50) NULL,
[ItemUnit] [nvarchar](20) NULL,
[ItemIcon] [nvarchar](255) NULL,
[ContentTemplate] [nvarchar](255) NULL,
[ModelType] [int] NULL CONSTRAINT [DF_ZL_Model_ModelType]  DEFAULT (1),
[MultiFlag] [bit] NULL CONSTRAINT [DF_ZL_Model_MultiFlag]  DEFAULT (0),
[NodeID] [int] NULL CONSTRAINT [DF_ZL_Model_NodeID]  DEFAULT (0),
[SysModel] [int] NULL CONSTRAINT [DF_ZL_Model_SysModel]  DEFAULT (2),
[FromModel] [int] NULL CONSTRAINT [DF_ZL_Model_FromModel]  DEFAULT (0),
[Thumbnail] [nvarchar] (500) NULL ,
[Islotsize][bit]  NULL CONSTRAINT [DF_ZL_Model_Islotsize]  DEFAULT ((0)),
CONSTRAINT [PK_ZL_Model] PRIMARY KEY CLUSTERED
(
[ModelID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

SET IDENTITY_INSERT [ZL_Model] ON
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 1,N'公告',N'发布简明信息',N'ZL_C_Announce',N'公告',N'条',N'fa fa-bullhorn',N'内容页/默认公告内容页.html',1,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 2,N'文章模型',N'用于装载常见的文章信息，如文章、新闻、资讯等。',N'ZL_C_Article',N'文章',N'篇',N'fa fa-file-word-o',N'内容页/两列式标准内容页.html',1,1,0,1,0,1)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 3,N'图库模型',N'可发布图文并茂的信息，并通过丰富的图片展示分享网络的乐趣。',N'ZL_C_Photo',N'图片',N'张',N'fa fa-file-photo-o',N'内容页/默认图库模型内容页.html',1,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 4,N'下载模型',N'基于文件发布与资源共享的功能，并可进行下载收费等二次开发。',N'ZL_C_soft',N'软件',N'个',N'glyphicon glyphicon-save',N'内容页/默认下载模型内容页.html',1,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 5,N'转向链接模型',N'访客点击此模型下信息，则跳入指定第三方链接，便于流量管理。',N'ZL_C_RedirectLink',N'跳转',N'个',N'fa fa-external-link',N'内容页/默认转向链接模型内容页.html',1,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 6,N'商品模型',N'建立起商品模型用于销售，开展网上电子业务。',N'ZL_P_Shop',N'商品',N'件',N'glyphicon glyphicon-shopping-cart',N'内容页/默认商品模型内容页.html',2,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 7,N'视频模型',N'基于FLV等类型的视频发布系统，高速视频抢占信息时代之商机。',N'ZL_C_video',N'视频',N'个',N'glyphicon glyphicon-film',N'内容页/默认视频模型内容页.html',1,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 8,N'友情链接',N'通过与网民交换友情链接，提升网站PR值和友好的互访机制。',N'ZL_C_FriendSite',N'网站',N'个',N'glyphicon glyphicon-link',N'内容页/默认友情链接内容页.html',1,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 9,N'默认申请样式',N'默认申请样式',N'ZL_Reg_Page',10,0,0,0,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize]) VALUES ( 10,N'企业信息',N'用于描述企业的扩展功能',N'ZL_U_comp',N'信息',N'条',N'fa fa-group',3,0,0,0,0,N'0',0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize]) VALUES ( 11,N'招聘信息',N'提供给企业用户发布招聘信息',N'ZL_U_ZP',N'信息',N'条',N'fa fa-paw',3,1,0,0,0,N'0',0)
INSERT [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize]) VALUES ( 12,N'个人简历',N'提供给个人用户录入',N'ZL_U_jl',N'信息',N'条',N'fa fa-paperclip',3,0,0,0,0,N'0',0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 17,N'留言文章投票的模型',N'ZL_Pub_WZTP',N'留言',N'条',N'glyphicon glyphicon-align-center',N'/互动模板/默认留言文章投票模板.html',7,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 18,N'问券在线调查的模型',N'ZL_Pub_ZXDC',N'问券',N'条',N'glyphicon glyphicon-file',N'/互动模板/默认问券在线调查模板.html',7,0,0,0,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 19,N'信息模型',N'ZL_C_Info',N'信息',N'条',N'fa  fa-file-text-o',N'内容页/默认信息模型内容页.html',1,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 20,N'店铺商品',N'ZL_S_shop',N'商品',N'件',N'fa fa-tags',N'店铺模板/默认店铺商品内容页.html',5,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 21,N'留言提问的模型',N'ZL_Pub_TW',N'留言',N'条',N'glyphicon glyphicon-align-center',N'/互动模板/默认留言提问模板.html',7,0,0,0,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 22,N'评论问题回答的模型',N'ZL_Pub_WTHD',N'评论',N'条',N'glyphicon glyphicon-align-center',N'/互动模板/默认评论问题回答模板.html',7,0,0,0,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 23,N'评论最佳答案的模型',N'ZL_Pub_ZJDA',N'评论',N'条',N'glyphicon glyphicon-align-center',N'/互动模板/默认评论最佳答案模板.html',7,0,0,0,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 24,N'店铺申请',N'ZL_Store_reg',N'店铺',N'个',N'glyphicon glyphicon-shopping-cart',N'内容页/默认店铺申请内容页.html',6,1,0,1,0,0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize]) VALUES ( 35,N'收文模型',N'ZL_OAC_swmx',N'文章',N'篇',N'Default.gif',N'内容页/默认收文模型内容页.html',12,1,0,1,0,N'0',0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize]) VALUES ( 36,N'发文模型',N'ZL_OAC_fwmx',N'文章',N'篇',N'Default.gif',N'内容页/默认发文模型内容页.html',12,1,0,1,0,N'0',0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize]) VALUES ( 37,N'请假模型',N'ZL_OAC_qjmx',N'文章',N'篇',N'Default.gif',N'内容页/默认请假模型内容页.html',12,1,0,1,0,N'0',0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize]) VALUES ( 38,N'会议模型',N'ZL_OAC_kymx',N'文章',N'篇',N'Default.gif',N'内容页/默认会议模型内容页.html',12,1,0,1,0,N'0',0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize]) VALUES ( 44,N'企业黄页',N'ZL_Page_mypage',N'文章',N'篇',N'fa fa-pagelines',N'内容页/默认mypage内容页.html',4,1,0,1,0,N'0',0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize]) VALUES ( 48,N'客户模型',N'ZL_CRM_khmx',N'文章',N'篇',N'glyphicon glyphicon-user',N'内容页/默认客户模型内容页.html',11,1,0,1,0,N'0',0)
INSERT [ZL_Model] ([ModelID],[ModelName],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ContentTemplate],[ModelType],[MultiFlag],[NodeID],[SysModel],[FromModel],[Islotsize]) VALUES ( 49,N'快递信息',N'ZL_C_kdxx',N'快递',N'篇',N'fa fa-bicycle',N'内容页/默认快递信息内容页.html',1,1,0,1,0,0)
SET IDENTITY_INSERT [ZL_Model] OFF

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

detele from ZL_Model

--注意：将删除整个表

drop table ZL_Model

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

TRUNCATE table ZL_Model