ASP.NET教学管理系统

USE [master] GO /****** Object: Database [StudentDB] Script Date: 05/19/2017 12:06:14 ******/ CREATE DATABASE [StudentDB] ON PRIMARY ( NAME = N'StudentMIS_Data', FILENAME = N'D:\StudentDB_Data.MDF' , SIZE = 2176KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) LOG ON ( NAME = N'StudentMIS_Log', FILENAME = N'D:\StudentDB_Log.LDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) GO ALTER DATABASE [StudentDB] SET COMPATIBILITY_LEVEL = 80 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [StudentDB].[dbo].[sp_fulltext_database] @action = 'disable' end GO ALTER DATABASE [StudentDB] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [StudentDB] SET ANSI_NULLS OFF GO ALTER DATABASE [StudentDB] SET ANSI_PADDING OFF GO ALTER DATABASE [StudentDB] SET ANSI_WARNINGS OFF GO ALTER DATABASE [StudentDB] SET ARITHABORT OFF GO ALTER DATABASE [StudentDB] SET AUTO_CLOSE OFF GO ALTER DATABASE [StudentDB] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [StudentDB] SET AUTO_SHRINK ON GO ALTER DATABASE [StudentDB] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [StudentDB] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [StudentDB] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [StudentDB] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [StudentDB] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [StudentDB] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [StudentDB] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [StudentDB] SET DISABLE_BROKER GO ALTER DATABASE [StudentDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [StudentDB] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [StudentDB] SET TRUSTWORTHY OFF GO ALTER DATABASE [StudentDB] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [StudentDB] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [StudentDB] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [StudentDB] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [StudentDB] SET READ_WRITE GO ALTER DATABASE [StudentDB] SET RECOVERY SIMPLE GO ALTER DATABASE [StudentDB] SET MULTI_USER GO ALTER DATABASE [StudentDB] SET PAGE_VERIFY NONE GO ALTER DATABASE [StudentDB] SET DB_CHAINING OFF GO USE [StudentDB] GO /****** Object: Table [dbo].[StudentCourse] Script Date: 05/19/2017 12:06:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[StudentCourse]( [studentNumber] [varchar](50) NOT NULL, [classId] [varchar](50) NOT NULL, [score] [varchar](50) NULL, CONSTRAINT [PK_Class] PRIMARY KEY CLUSTERED ( [studentNumber] ASC, [classId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Student] Script Date: 05/19/2017 12:06:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Student]( [ID] [int] IDENTITY(1,1) NOT NULL, [password] [varchar](50) NULL, [Number] [varchar](50) NOT NULL, [Name] [varchar](50) NOT NULL, [Sex] [varchar](50) NULL, [ProfessionName] [varchar](50) NOT NULL, [Class] [varchar](50) NULL, [StatusChange] [varchar](50) NULL, [FamilyCircs] [varchar](50) NULL, [EnrollmentAchievement] [int] NULL, [Resume] [varchar](50) NULL, [Ability] [varchar](50) NULL, [Application] [int] NULL, CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED ( [ID] ASC, [Number] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Status] Script Date: 05/19/2017 12:06:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Status]( [ID] [int] IDENTITY(1,1) NOT NULL, [Number] [varchar](50) NOT NULL, [Encouragement] [varchar]�