表名：ZL_Design_SiteInfo












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2SiteNamenvarchar1000   是 站点名称
3SiteFlagnvarchar1000   是 站点标识
4UserIDnvarchar5000   是 用户ID,需要支持游客,ID=0的只有管理员可修改
5UserNamenvarchar5000   是 用户名
6Remindnvarchar5000   是 站点备注
7ZStatusint40   是 站点状态
8CDatedatetime83   是 建站时间
9DomainIDint40   是 绑定的域名ID
10Logonvarchar10000   是 LOGO路径
11Scorefloat80   是 站点分数

简要说明：

PC站点表

GO
CREATE TABLE [dbo].[ZL_Design_SiteInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[SiteName] [nvarchar](100) NULL,
[SiteFlag] [nvarchar](100) NULL,
[UserID] [nvarchar](500) NULL,
[UserName] [nvarchar](500) NULL,
[Remind] [nvarchar](500) NULL,
[ZStatus] [int] NULL,
[CDate] [datetime] NULL,
[DomainID] [int] NULL,
[Logo] [nvarchar](1000) NULL,
[Score] [float] NULL, 
CONSTRAINT [PK_ZL_Design_SiteInfo] 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 [ZL_Design_SiteInfo] ON
INSERT [ZL_Design_SiteInfo] ([ID],[SiteName],[SiteFlag],[UserID],[ZStatus],[CDate],[DomainID],[Logo]) VALUES ( 1,N'admin的站点',N'anxtvesa',N'1',1,N'2016/4/18 10:56:38',1,'/Site/1/UploadFiles/logo.jpg')
SET IDENTITY_INSERT [ZL_Design_SiteInfo] OFF

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

detele from ZL_Design_SiteInfo

--注意：将删除整个表

drop table ZL_Design_SiteInfo

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

TRUNCATE table ZL_Design_SiteInfo