表名：ZL_IDC_DomainLog












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2CartIDint40   是 购物车ID
3DomNamenvarchar500   是 域名
4Typeint40   是 域名类型
5OwnUserIDint40   是 所属用户
6Detailntext160   是 详情
7CreateDatedatetime83   是getdate创建时间

简要说明：

IDC申请记录表


GO
CREATE TABLE [dbo].[ZL_IDC_DomainLog] (
[ID] [int]  IDENTITY (1, 1)  NOT NULL,
[CartID] [int]  NULL,
[DomName] [nvarchar]  (50) NULL,
[Type] [int]  NULL,
[OwnUserID] [int]  NULL,
[Detail] [ntext]  NULL,
[CreateDate] [datetime]  NULL DEFAULT (getdate()))
ALTER TABLE [ZL_IDC_DomainLog] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_IDC_DomainLog] PRIMARY KEY  NONCLUSTERED ( [ID] )

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

detele from ZL_IDC_DomainLog

--注意：将删除整个表

drop table ZL_IDC_DomainLog

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

TRUNCATE table ZL_IDC_DomainLog