kejian.sql

专为各大学、函授学校以及远程教育中心向学生们发布复习材料、实验素材等课件而设计的一套专用的基于WEB的上传、下载系统

CREATE TABLE [config] (
	[schoolname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sn] [nvarchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[adminpwd] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[strfenlei1] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[strfenlei2] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[contactadmin] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pagesize] [smallint] DEFAULT 0 NOT NULL ,
	[upload_type] [tinyint] DEFAULT 0 NOT NULL ,
	[upload_size] [smallint] DEFAULT 0 NOT NULL ,
	[upload_filetype] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[headads] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[locked] [tinyint] DEFAULT 0 NOT NULL ,
	[gonggao] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[todaydate] [smalldatetime] NULL ,
	[todaytimes] [int] DEFAULT 0 NOT NULL ,
	[times] [int] DEFAULT 0 NOT NULL ,
	[adminmail] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[siteurl] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [main] (
	[mainid] [int] IDENTITY (1, 1) NOT NULL ,
	[fileurl] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[idofteacher] [int] DEFAULT 0 NOT NULL ,
	[course] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateandtime] [smalldatetime] NULL ,
	[content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[times] [int] DEFAULT 0 NOT NULL ,
	[idoftype] [int] DEFAULT 0 NOT NULL ,
	[title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[filesize] [smallint] DEFAULT 0 NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [score] (
	[scoreid] [int] IDENTITY (1, 1) NOT NULL ,
	[idofmain] [int] DEFAULT 0 NOT NULL ,
	[score] [tinyint] DEFAULT 0 NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [teacher] (
	[teacherid] [int] IDENTITY (1, 1) NOT NULL ,
	[teacher] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[password] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[fenlei1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fenlei2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[locked] [tinyint] DEFAULT 0 NOT NULL ,
	[email] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[intro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[photourl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[homepage] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[qq] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ask] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[loginname] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [type] (
	[typeid] [int] IDENTITY (1, 1) NOT NULL ,
	[type] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO