newsdb.sql

system1为用户注册模块 system2为在线聊天系统 system3为在线投票系统 system4为在线考试系统 system5为新闻发布模块

CREATE TABLE [newsinfo] (
	[newsid] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[uptime] [datetime] NOT NULL ,
	[newstypeid] [int] NOT NULL ,
	[copyfrom] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[browsenum] [int] NOT NULL CONSTRAINT [DF_newsinfo_browsenum] DEFAULT (0),
	CONSTRAINT [PK_newsinfo] PRIMARY KEY  CLUSTERED 
	(
		[newsid]
	)  ON [PRIMARY] ,
	CONSTRAINT [FK_newsinfo_typeinfo] FOREIGN KEY 
	(
		[newstypeid]
	) REFERENCES [typeinfo] (
		[newstypeid]
	)
) 

CREATE TABLE [typeinfo] (
	[newstypeid] [int] NOT NULL ,
	[newstype] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[description] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_typeinfo] PRIMARY KEY  CLUSTERED 
	(
		[newstypeid]
	)  ON [PRIMARY] 
)