dbscript.sql

1、在Eclipse中导入工程

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,'定向'),
 (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','题库类别'),
 ('007','007','q_knowledge','知识点'),
 ('008','008','q_difficulty','题目难度'),
 ('009','009','t_state','考卷状态'),
 ('010','010','operation','业务类别'),
 ('011','011','e_grade','评分方式'),
 ('012','','',''),
 ('013','','',''),
 ('014','','',''),
 ('015','','',''),
 ('016','','',''),
 ('017','','',''),
 ('018','','',''),
 ('019','','',''),
 ('020','','',''),
 ('021','','',''),
 ('022','','',''),
 ('023','','',''),
 ('024','','',''),
 ('025','','',''),
 ('026','','',''),
 ('027','','',''),
 ('028','','',''),
 ('029','','',''),
 ('030','','',''),
 ('031','001','期中考试',''),
 ('032','001','月考',''),
 ('033','001','期末考试',''),
 ('034','','',''),
 ('035','','',''),
 ('036','','','');
INSERT INTO `ex_baseinfo` (`b_id`,`b_type`,`b_value`,`b_comments`) VALUES 
 ('037','','',''),
 ('038','002','已生成未分配',''),
 ('039','002','已分配未进行',''),
 ('040','002','已结束',''),
 ('041','002','进行中',''),
 ('042','','',''),
 ('043','','',''),
 ('044','','',''),
 ('045','','',''),
 ('046','','',''),
 ('047','003','单选题',''),
 ('048','003','多选题',''),
 ('049','003','填空题',''),
 ('050','003','简答题',''),
 ('051','','',''),
 ('052','','',''),
 ('053','','',''),
 ('054','','',''),
 ('055','','',''),
 ('056','004','男',''),
 ('057','004','女',''),
 ('058','','',''),
 ('059','','',''),
 ('060','','',''),
 ('061','','',''),
 ('062','','',''),
 ('063','005','有效',''),
 ('064','005','冻结',''),
 ('065','','',''),
 ('066','','',''),
 ('067','','',''),
 ('068','','',''),
 ('069','','',''),
 ('070','006','技术题库',''),
 ('071','006','知识题库一',''),
 ('072','006','知识题库一',''),
 ('073','006','知识题库一',''),
 ('074','','','');
INSERT INTO `ex_baseinfo` (`b_id`,`b_type`,`b_value`,`b_comments`) VALUES 
 ('075','','',''),
 ('076','','',''),
 ('077','007','综合技能',''),
 ('078','007','基本知识',''),
 ('079','007','水平考试',''),
 ('080','','',''),
 ('081','','',''),
 ('082','','',''),
 ('083','','',''),
 ('084','','',''),
 ('085','008','难',''),
 ('086','008','中',''),
 ('087','008','易',''),
 ('088','','',''),
 ('089','','',''),
 ('090','','',''),
 ('091','','',''),
 ('092','','',''),
 ('093','009','已考完未评分',''),
 ('094','009','未考',''),
 ('095','009','考试中',''),
 ('096','009','待考',''),
 ('097','009','已评分',''),
 ('098','','',''),
 ('099','','',''),
 ('100','','',''),
 ('101','','',''),
 ('102','','',''),
 ('103','010','技术',''),
 ('104','010','服务',''),
 ('105','010','管理',''),
 ('106','','',''),
 ('107','','',''),
 ('108','','',''),
 ('109','','',''),
 ('110','','',''),
 ('111','011','手工',''),
 ('112','011','自动',''),
 ('113','','',''),
 ('114','','',''),
 ('115','','','');
INSERT INTO `ex_baseinfo` (`b_id`,`b_type`,`b_value`,`b_comments`) VALUES 
 ('116','','',''),
 ('117','','',''),
 ('118','','',''),
 ('119','','',''),
 ('120','','',''),
 ('121','','',''),
 ('122','','',''),
 ('123','','',''),
 ('124','','',''),
 ('125','','',''),
 ('126','','',''),
 ('127','','',''),
 ('128','','',''),
 ('129','','',''),
 ('130','','','');
CREATE TABLE `ex_examinationpaper` (
  `e_id` int(10) unsigned NOT NULL auto_increment,
  `e_name` varchar(100) default NULL,
  `e_type` varchar(3) default NULL,
  `e_timer` int(10) unsigned default '0',
  `e_idlist` text,
  `e_begin` datetime NOT NULL default '0000-00-00 00:00:00',
  `e_end` datetime NOT NULL default '0000-00-00 00:00:00',
  `e_examineelist` text,
  `e_grade` varchar(3) default NULL,
  `e_passvalue` int(10) unsigned default '0',
  `e_total` int(10) unsigned default '0',
  `e_state` varchar(3) default NULL,
  PRIMARY KEY  (`e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `ex_examinationpaper` (`e_id`,`e_name`,`e_type`,`e_timer`,`e_idlist`,`e_begin`,`e_end`,`e_examineelist`,`e_grade`,`e_passvalue`,`e_total`,`e_state`) VALUES 
 (2,'06年月考','031',30,'@@##8##7##6##5##4##3@@##14##13##12##11##10##9@@##19##18##16##15@@##21','2006-02-17 00:00:00','2006-02-18 00:00:00','##s0001##s0002##s0003',NULL,60,110,'040'),
 (3,NULL,NULL,0,'@@0@@0@@0@@0','2006-02-17 23:35:19','2006-02-18 23:35:19',NULL,NULL,0,0,'040'),
 (4,'06年终考试','033',30,'@@##22##8##7##23##5@@##12##11##10##9##2@@##18##16##15@@##21##20##17','2006-02-19 00:00:00','2006-02-20 00:00:00','##s0001##s0002##s0003##s0004',NULL,60,103,'041'),
 (5,NULL,NULL,0,'@@0@@0@@0@@0','2006-02-19 16:40:48','2006-02-20 16:40:48',NULL,NULL,0,0,NULL);
CREATE TABLE `ex_examinationpaper_detail` (
  `e_id` int(10) unsigned NOT NULL default '0',
  `q_id` int(10) unsigned NOT NULL default '0',
  `q_seq` int(10) unsigned default NULL,
  `q_type` varchar(3) default NULL,
  `q_value` float default NULL,
  `q_standard` text,
  PRIMARY KEY  (`e_id`,`q_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
INSERT INTO `ex_examinationpaper_detail` (`e_id`,`q_id`,`q_seq`,`q_type`,`q_value`,`q_standard`) VALUES 
 (2,3,NULL,NULL,NULL,NULL),
 (2,4,NULL,NULL,NULL,NULL),
 (2,5,NULL,NULL,NULL,NULL),
 (2,6,NULL,NULL,NULL,NULL),
 (2,7,NULL,NULL,NULL,NULL),
 (2,8,NULL,NULL,NULL,NULL),
 (2,9,NULL,NULL,NULL,NULL),
 (2,10,NULL,NULL,NULL,NULL),
 (2,11,NULL,NULL,NULL,NULL),
 (2,12,NULL,NULL,NULL,NULL),
 (2,13,NULL,NULL,NULL,NULL),
 (2,14,NULL,NULL,NULL,NULL),
 (2,15,NULL,NULL,NULL,NULL),
 (2,16,NULL,NULL,NULL,NULL),