日期:2014-05-17 浏览次数:20770 次
CREATE TABLE [dbo].[ce_article_table](
[id] [int] IDENTITY(1,1) NOT NULL,
[title] [nvarchar](105) COLLATE Chinese_PRC_CI_AS NULL,
[browseurl] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[channel] [nvarchar](30) COLLATE Chinese_PRC_CI_AS NULL,
[flag] [nvarchar](300) COLLATE Chinese_PRC_CI_AS NULL,
[addtime] [datetime] NULL CONSTRAINT [DF_ce_newstable_addtime] DEFAULT (getdate()),
[click] [int] NULL CONSTRAINT [DF_ce_newstable_click] DEFAULT ((0)),
[comment] [int] NULL CONSTRAINT [DF_ce_article_table_comment] DEFAULT ((0)),
[keywords] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[description] [nvarchar](205) COLLATE Chinese_PRC_CI_AS NULL,
[ischeck] [tinyint] NULL CONSTRAINT [DF_ce_newstable_ischeck] DEFAULT ((0)),
[imageurl] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[admin_id] [int] NULL CONSTRAINT [DF_ce_article_table_adminid] DEFAULT ((0)),
CONSTRAINT [PK_article_ID] PRIMARY KEY CLUSTERED
(
[id] DESC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 100) ON [PRIMARY]
) ON [PRIMARY]