exam-master/database/dbscript.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

CREATE DATABASE IF NOT EXISTS `exam`;
USE `exam`;
CREATE TABLE `b_education_type` (
  `education_index` int(10) unsigned NOT NULL auto_increment,
  `education_name` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`education_index`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `b_education_type` (`education_index`,`education_name`) VALUES 
 (1,'高中'),
 (2,'专科'),
 (3,'本科'),
 (4,'研究生'),
 (5,'博士');
CREATE TABLE `b_organization` (
  `organization_id` int(10) unsigned NOT NULL auto_increment,
  `org_name` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`organization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `b_organization` (`organization_id`,`org_name`) VALUES 
 (1,'管理部'),
 (2,'财务部'),
 (3,'技术部'),
 (4,'市场部');
CREATE TABLE `b_post_type` (
  `post_index` int(10) unsigned NOT NULL auto_increment,
  `post_name` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`post_index`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `b_post_type` (`post_index`,`post_name`) VALUES 
 (1,'会计师'),
 (2,'审计师'),
 (3,'Java开发工程师'),
 (4,'数据库工程师'),
 (5,'销售员'),
 (6,'销售支持工程师'),
 (7,'部门经理'),
 (8,'经理助理'),
 (9,'秘书');
CREATE TABLE `ex_adminuser` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `password` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `ex_adminuser` (`id`,`name`,`password`) VALUES 
 (1,'admin','admin');
CREATE TABLE `ex_baseinfo` (
  `b_id` varchar(3) NOT NULL default '',
  `b_type` varchar(3) default '0',
  `b_value` varchar(200) default NULL,
  `b_comments` varchar(200) default NULL,
  PRIMARY KEY  (`b_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `ex_baseinfo` (`b_id`,`b_type`,`b_value`,`b_comments`) VALUES 
 ('001','001','e_type','试卷类型'),
 ('002','002','e_state','试卷状态'),
 ('003','003','q_type','题型'),
 ('004','004','sex','性别'),
 ('005','005','state','用户状态'),
 ('006','006','q_class','题库类别'),