testdb.sql

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

CREATE TABLE [shijuan] (
	[shijuanbianhao] [int] NULL ,
	[timu] [varchar] (800) COLLATE Chinese_PRC_CI_AS NULL ,
	[fenzhi] [int] NULL ,
	[timuleixing] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[kaoshishijian] [int] NULL 
)


CREATE TABLE [xuanzeti] (
	[id] [int] NOT NULL ,
	[tigan] [varchar] (800) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[daan] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[zhang] [int] NOT NULL ,
	[a] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[b] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[c] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[d] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[nandu] [int] NULL ,
	CONSTRAINT [PK_xuanzeti] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
)


CREATE TABLE [panduanti] (
	[id] [int] NOT NULL ,
	[tigan] [varchar] (800) COLLATE Chinese_PRC_CI_AS NULL ,
	[daan] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[zhang] [int] NULL ,
	[nandu] [int] NULL ,
	CONSTRAINT [PK_panduanti] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
)


CREATE TABLE [zhuguanti] (
	[id] [int] NOT NULL ,
	[tigan] [varchar] (800) COLLATE Chinese_PRC_CI_AS NULL ,
	[daan] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[zhang] [int] NULL ,
	[nandu] [int] NULL ,
	CONSTRAINT [PK_zhuguanti] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
)


CREATE TABLE [students_xuanze] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[zhang] [int] NULL ,
	[rightcount] [int] NULL ,
	[dayntime] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL 
)