CREATE TABLE [table2] (
[id] [int] NOT NULL ,
[CallerID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[CalledID] [varchar] (50) NULL ,
[code] [varchar] (50) NULL,
[type] [varchar] (50) NULL,
[addtime] [datetime] null CONSTRAINT [DF_table2_1] DEFAULT (getdate()),
CONSTRAINT [PK_table2] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
[id] [int] NOT NULL ,
[CallerID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[CalledID] [varchar] (50) NULL ,
[code] [varchar] (50) NULL,
[type] [varchar] (50) NULL,
[addtime] [datetime] null CONSTRAINT [DF_table2_1] DEFAULT (getdate()),
CONSTRAINT [PK_table2] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
id int primary key,
callerid varchar(50),
calledid varchar(50),
code varchar(50),
type varchar(50),
addtime datetime default getdate()
)