无标题1.sql

来自「是一个专门用于高校教务管理的源码」· SQL 代码 · 共 62 行

use master
go
if exists(select * from sysdatabases where name='education')
	drop database education
go
create database education
go
use education
go
if exists(select * from sysobjects where name='admin')
	drop table admin
go
if exists(select * from sysobjects where name='student')
	drop table student
go
if exists(select * from sysobjects where name='teacher')
	drop table teacher
go

create table teacher
(
	id varchar(20) primary key not null,
    name varchar(20),
    password varchar(20),
    department varchar(20),
    title varchar(10),
    sex varchar(8),
    age varchar(20),
    jiguan varchar(20),
    tel varchar(20),
    email varchar(20)
)
create table admin
(
	id varchar(20) primary key not null,
    name varchar(20),
    password varchar(20)
)
go
create table student
(
	id varchar(20) primary key not null,
    name varchar(20),
    password varchar(20),
    sex varchar(10),
    age varchar(20),
    jiguan varchar(20),
    tel varchar(20),
    email varchar(40),
    department varchar(20),
    mark int
)
go
insert into admin values('admin','sa')
insert into student values(1,'litang','123456','男','1987-11-13','湖北黄冈','15926477332','[e-mail]','计算机系',8)
insert into teacher values('zhangsan','123456','计算机系','教授','男','1956-02-21','湖北武汉','13045983651','[e-mail]')
go
select * from admin
select * from student
select * from teacher
go