表名:ZL_Sys_CSSManage












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40   
2Namenvarchar500    别名
3CDatedatetime83     
4AdminIDint40     
5Remindnvarchar5000     
6CSSntext160    CSS名称
7CSSListntext160    CSS详情
8ZStatusint40     

简要说明:

百变微站CSS管理

GO

CREATE TABLE [dbo].[ZL_Sys_CSSManage](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[CDate] [datetime] NULL,
[AdminID] [int] NULL,
[Remind] [nvarchar](500) NULL,
[CSS] [ntext] NULL,
[CSSList] [ntext] NULL,
[ZStatus] [int] NULL,
CONSTRAINT [PK_ZL_SYS_CSSManage] 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] TEXTIMAGE_ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[ZL_Sys_CSSManage] ON
INSERT [dbo].[ZL_Sys_CSSManage] ([ID], [Name], [CDate], [AdminID], [Remind], [CSS], [CSSList],[Zstatus]) VALUES (1, N'微信1号', CAST(N'2017-04-10T16:33:23.000' AS DateTime), 1, NULL, N'.home_top{background-color:#359aea;height:3.5em;width:100%;line-height:3.4em;top:0;left:0;z-index:111;}
.home_header{background-color:#eca528;color:#000000;line-height:3.4em;height:3.4em;background-repeat:repeat;}', N'H4sIAAAAAAAEAH2OQQrCMBRE7xJx15bGWtDkKCIS298mmCYlRhSlKw/gFRRceADRjdep0FsYVERR/Jth/sDMG6xQJqQFgwgKuC5gZHWJPJRoZUFZ9x2zZJIbPVOpn2ipDWlFcZ8BoxxEzi2JghgKOhep5QSHYZtKocB/hV0XukoSUgmZdbL0hUphQTDG1A0xKdjUzdT7Y7M+XLfn+rJBlfeFxYGlzv4ng4TFnR59uvB+P3g+zFuLgRKYJQ95h2t2JweHquENm4jbUC8BAAA=',0)
INSERT [dbo].[ZL_Sys_CSSManage] ([ID], [Name], [CDate], [AdminID], [Remind], [CSS], [CSSList],[Zstatus]) VALUES (2, N'门户引用', CAST(N'2017-05-15T11:15:35.000' AS DateTime), 1, N'用于标准V4门户型首页样式', N'#home_scolls{background-color:#2c2ccc;}
.home_slogin_c{background-color:#25aa7b;}
.home_slogin :nth-child(3).col-lg-3 .home_slogin_c{background-color:#20990a;}
.home_slogin :nth-child(2).col-lg-3 .home_slogin_c{background-color:#257d63;}
.home_slogin :nth-child(4).col-lg-3 .home_slogin_c{background-color:#3b995c;}
', N'H4sIAAAAAAAEAIuuVkrLzClJLVKyUlLOyM9NjS9Ozs/JKVbSUUrOzytJzSsBSiQlJmenF+WX5qXoAiXzi6yUjZKNkpOTrYGqEnMyE4uBap4u2fKyecWzBduf7ulXqtVBMlYPYmxOfnpmXnwyIYNNExPNkzANfrKj+9m0nS86Nz2dO/3pullPdna+39Nh+H5PJ267FKzySjJ0kzMyc1I0jDX1gBbo5qTrGiuQ5h4DS0uDRCLdY0y0e4zIdo+peYqZMZHuMSLaPSbkusc4ydLSFEtCwOoeE7B7YgGWffFCdAIAAA==',-1)
SET IDENTITY_INSERT [dbo].[ZL_Sys_CSSManage] OFF

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

detele from ZL_Sys_CSSManage

--注意:将删除整个表

drop table ZL_Sys_CSSManage

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

TRUNCATE table ZL_Sys_CSSManage