新闻阅读器系统数据库建表语句

新闻阅读器系统数据库建表语句 CREATE TABLE [dbo].[t_admin]( [userId] [int] NOT NULL, [userName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [userPw] [varchar](66) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_t_admin] PRIMARY KEY CLUSTERED ( [userId] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[t_catelog]( [catelog_id] [int] NOT NULL, [catelog_name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [catelog_del] [varchar](66) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_t_catelog] PRIMARY KEY CLUSTERED ( [catelog_id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[t_gonggao]( [gonggao_id] [int] NOT NULL, [gonggao_title] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [gonggao_content] [varchar](4000) COLLATE Chinese_PRC_CI_AS NULL, [gonggao_data] [varchar](66) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_t_gonggao] PRIMARY KEY CLUSTERED ( [gonggao_id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[t_liuyan]( [liuyan_id] [int] NOT NULL, [liuyan_title] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [liuyan_content] [varchar](4000) COLLATE Chinese_PRC_CI_AS NULL, [liuyan_date] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [liuyan_user] [varchar](66) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_t_liuyan] PRIMARY KEY CLUSTERED ( [liuyan_id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[t_news]( [news_id] [int] NOT NULL, [news_title] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [news_content] [varchar](4000) COLLATE Chinese_PRC_CI_AS NULL, [news_date] [varchar](66) COLLATE Chinese_PRC_CI_AS NULL, [catelog_id] [int] NULL, CONSTRAINT [PK_t_news] PRIMARY KEY CLUSTERED ( [news_id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[t_shipin]( [shipin_id] [int] NOT NULL, [shipin_name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [shipin_jianjie] [varchar](4000) COLLATE Chinese_PRC_CI_AS NULL, [fujian] [varchar](66) COLLATE Chinese_PRC_CI_AS NULL, [fujianYuanshiming] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [del] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_t_shipin] PRIMARY KEY CLUSTERED ( [shipin_id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[t_toupiao]( [id] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [title] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [faqishijian] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [del] [varchar](504) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_t_toupiao] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[t_toupiaoxuanxiang]( [id] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [xuanxiangneirong] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [piaoshu] [int] NULL, [toupiao_id] [varchar](44) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_t_toupiaoxuanxiang] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[t_user]( [user_id] [int] NOT NULL, [user_name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [user_pw] [varchar](55) COLLATE Chinese_PRC_CI_AS NULL, [user_realname] [varchar](44) COLLATE Chinese_PRC_CI_AS NULL, [user_sex] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [user_address] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [user_tel] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [user_del] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_t_user] PRIMARY KEY CLUSTERED ( [user_id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]