传智播客我的SqlServer脚本

 
======================SqlServer大部分知识都在我这脚本里===============
如果你能把数据结构画出来的话，那么你就入门了！！呵呵！！
--查看konwyoumore库是否存在
USE master
IF exists(SELECT * from sysdatabases WHERE name='KnowYouMore')
BEGIN
DROP DATABASE knowyoumore;
END
GO
--创建konwyoumore数据库
CREATE DATABASE KnowYouMore
GO
USE KnowYouMore
GO
--创建角色表
CREATE TABLE roles
(
rno INT PRIMARY KEY IDENTITY(1,1),
rname VARCHAR(12) NOT NULL
);
GO
--创建注册表
CREATE TABLE users
(
uno INT PRIMARY KEY IDENTITY(1,1),
uname VARCHAR(32) NOT NULL UNIQUE,
upwd VARCHAR(32) NOT NULL ,
star INT,
trueName VARCHAR(16) NOT NULL,
rno INT FOREIGN KEY REFERENCES roles(rno)
);
GO
--创建班级表
CREATE TABLE classes
(
cno INT PRIMARY KEY IDENTITY(1,1),
cname VARCHAR(32) NOT NULL UNIQUE,
   cdescribe VARCHAR(100)
);
GO
--创建学生表
CREATE TABLE students
(
sno INT PRIMARY KEY IDENTITY(1,1),
sname VARCHAR(16) NOT NULL UNIQUE,
sex CHAR(2) NOT NULL CHECK(sex='男'or sex='女') DEFAULT('男'),
birth DATETIME NOT NULL DEFAULT getdate(),
nativeplace VARCHAR(16) NOT NULL,
address VARCHAR(100) NOT NULL,
QQNo VARCHAR(32) NOT NULL,
phoneNo VARCHAR(12) NOT NULL,
nowTerm VARCHAR(5) NOT NULL,
selfPic VARCHAR(100) DEFAULT '6666.jpg',
selfDescribe VARCHAR(100) NOT NULL,
cno INT FOREIGN KEY REFERENCES classes(cno)
);
GO
--创建教师表
CREATE TABLE teachers
(
tno INT PRIMARY KEY IDENTITY(1,1),
tname VARCHAR(16) NOT NULL UNIQUE,
sex CHAR(2) NOT NULL CHECK(sex='男'or sex='女') DEFAULT('男'),
birth DATETIME NOT NULL DEFAULT getdate(),
nativeplace VARCHAR(16) NOT NULL,
taddress VARCHAR(100) NOT NULL ,
tQQNo VARCHAR(32) NOT NULL,
tphoneNo VARCHAR(12) NOT NULL,
selfPic VARCHAR(100),
selfDescribe VARCHAR(100) NOT NULL,
nowTerm VARCHAR(5) NOT NULL,
cno INT FOREIGN KEY REFERENCES classes(cno)
);
GO
--创建意见表 每天学习评分
CREATE TABLE stuQuestion
(
sname VARCHAR(16),
cname VARCHAR(32) FOREI