sql.sql

一个修改过的ASP学籍管理系统,用javascript+ado写的

create database heihei
go
use heihei
go
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[message]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[message](
	[昵称] [char](100) NOT NULL,
	[主题] [char](700) NOT NULL,
	[写作时间] [char](50) NULL,
	[内容] [char](500) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[teacher]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[teacher](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NOT NULL,
	[password] [nvarchar](50) NOT NULL,
	[quanxian] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_teacher] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[course]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[course](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NOT NULL,
	[teacherId] [int] NULL,
	[xuefen] [int] NOT NULL,
	[professionId] [int] NULL,
 CONSTRAINT [PK_course] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[score]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[score](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[courseId] [int] NOT NULL,
	[studentId] [bigint] NOT NULL,
	[score] [nvarchar](50) NOT NULL,
	[chongxiu] [nvarchar](15) NULL,
 CONSTRAINT [PK_score] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[college]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[college](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NOT NULL,
	[description] [nvarchar](50) NULL,
 CONSTRAINT [PK_college] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[student]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[student](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NOT NULL,
	[password] [nvarchar](50) NOT NULL,
	[sex] [nvarchar](50) NULL,
	[birthday] [nvarchar](50) NULL,
	[minzu] [nvarchar](50) NULL,
	[zhengzhimm] [nvarchar](50) NULL,
	[collegeId] [int] NULL,
	[professionId] [int] NULL,
	[classId] [nvarchar](10) NULL,
	[studentNo] [bigint] NOT NULL,
	[peiyangfs] [nvarchar](10) NULL,
	[xuezhi] [nvarchar](10) NULL,
	[ruxuenianfen] [nvarchar](10) NULL,
	[xueli] [nvarchar](10) NULL,
	[waiyu] [nvarchar](10) NULL,
	[waiyushuiping] [nvarchar](10) NULL,
	[shentizz] [nvarchar](10) NULL,
	[zaiduqk] [nvarchar](10) NULL,
	[address] [nvarchar](50) NULL,
	[phoneNum] [bigint] NULL,
	[email] [nvarchar](50) NULL,
	[homePage] [nvarchar](50) NULL,
	[huojiangqk] [ntext] NULL,
 CONSTRAINT [PK_student] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[profession]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[profession](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nchar](20) NOT NULL,
 CONSTRAINT [PK_profession] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END

insert into dbo.teacher values('admin','admin','admin')
insert into dbo.teacher values('user','user','manage')
go