【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-database_create.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
#
# 创建用户表
#
DROP TABLE IF EXISTS iuser;
CREATE TABLE iuser (
Id bigint(20) unsigned NOT NULL auto_increment,
type char(1) ,
userId varchar(10) ,
pass
word varchar(20) ,
name varchar(20),
latestOnline datetime,
schoolclass_id bigint(20),
PRIMARY KEY (Id)
)DEFAULT CHARSET=utf8;
#
# 创建班级表
#
DROP TABLE IF EXISTS schoolclass;
CREATE TABLE schoolclass (
Id bigint(20) unsigned NOT NULL auto_increment,
name varchar(20),
grade_id bigint(20),
PRIMARY KEY (Id)
)DEFAULT CHARSET=utf8;
#
# 创建年级表
#
DROP TABLE IF EXISTS grade;
CREATE TABLE grade (
Id bigint(20) unsigned NOT NULL auto_increment,
name varchar(20),
PRIMARY KEY (Id)
)DEFAULT CHARSET=utf8;
#
# 创建课程表
#
DROP TABLE IF EXISTS course;
CREATE TABLE course (
Id bigint(20) unsigned NOT NULL auto_increment,
name varchar(20),
PRIMARY KEY (Id)
)DEFAULT CHARSET=utf8;
#
# 创建老师和
课程的联合表
#
DROP TABLE IF EXISTS iuser_course;
CREATE TABLE iuser_course (
iuser_id bigint(20) unsigned NOT NULL,
course_id bigint(20) unsigned NOT NULL
)DEFAULT CHARSET=utf8;
#
# 创建考试表
#
DROP TABLE IF EXISTS exam;
CREATE TABLE exam (
Id bigint(20) unsigned NOT NULL auto_increment,
name varchar(50),
iuser_id bigint(20) ,
course_id bigint(20) ,
schoolclass_id bigint(20) ,
date datetime,
PRIMARY KEY (Id)
)DEFAULT CHARSET=utf8;
#
# 创建成绩表
#
DROP TABLE IF EXISTS studentscore;
CREATE TABLE studentscore (
Id bigint(20) unsigned NOT NULL auto_increment,
exam_id bigint(20),
iuser_id bigint(20) ,
score float(5,2) ,
PRIMARY KEY (Id)
)DEFAULT CHARSET=utf8;