﻿DROP TABLE IF EXISTS `pw_exam_config`;
CREATE TABLE IF NOT EXISTS `pw_exam_config` (
  `key` varchar(20) NOT NULL,
  `value` varchar(255) NOT NULL,
  `descrip` varchar(255) NOT NULL,
  PRIMARY KEY  (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO pw_exam_config (`key`, `value`, `descrip`) VALUES 
('pwversion', '6', ''),
('open', '1', ''),
('koufen', '1', ''),
('baomi', '1', ''),
('duoxuan', '1', ''),
('jianda', '1', ''),
('adms', 'a:1:{i:0;s:5:"hubin";}', ''),
('type', '1', ''),
('fen1', '1', ''),
('fen2', '2', ''),
('fen3', '10', ''),
('group', 'a:2:{i:0;s:1:"8";i:1;s:2:"12";}', ''),
('opengroup', 'a:14:{i:0;s:1:"3";i:1;s:1:"4";i:2;s:1:"5";i:3;s:1:"6";i:4;s:1:"7";i:5;s:1:"8";i:6;s:2:"16";i:7;s:1:"9";i:8;s:2:"10";i:9;s:2:"11";i:10;s:2:"12";i:11;s:2:"13";i:12;s:2:"14";i:13;s:2:"15";}', ''),
('openkey', '1', ''),
('examversion', '1.0', ''),
('author', 'hubin999421@gmail.com', ''),
('admgroup', 'a:2:{i:0;s:1:"3";i:1;s:1:"4";}', ''),
('random', '1', ''),
('force', '1', ''),
('min', '60', ''),
('di', '2', ''),
('pxtime', '60', ''),
('indexpx', '5', ''),
('toppx', '100', '');


DROP TABLE IF EXISTS `pw_exam_kaojuan`;
CREATE TABLE IF NOT EXISTS `pw_exam_kaojuan` (
  `id` int(11) NOT NULL auto_increment,
  `shijuan` int(11) NOT NULL,
  `sjname` varchar(100) NOT NULL,
  `kjname` varchar(60) NOT NULL,
  `userid` int(11) NOT NULL,
  `context` text NOT NULL,
  `stids` varchar(255) NOT NULL,
  `min` smallint(6) NOT NULL,
  `di` smallint(6) NOT NULL,
  `start` int(11) NOT NULL,
  `end` int(11) NOT NULL,
  `score` int(11) NOT NULL,
  `totalscore` smallint(6) NOT NULL,
  `close` tinyint(1) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `pw_exam_shijuan`;
CREATE TABLE IF NOT EXISTS `pw_exam_shijuan` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(200) NOT NULL,
  `num` smallint(6) NOT NULL,
  `min` smallint(6) NOT NULL,
  `di` smallint(6) NOT NULL,
  `num1` smallint(6) NOT NULL,
  `num2` smallint(6) NOT NULL,
  `num3` smallint(6) NOT NULL,
  `open` tinyint(1) NOT NULL,
  `mtuse` varchar(10) NOT NULL,
  `usenum` smallint(6) NOT NULL,
  `mtneed` varchar(10) NOT NULL,
  `neednum` smallint(6) NOT NULL,
  `opengroup` varchar(255) NOT NULL,
  `tiku` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `pw_exam_shijuan` (`id`, `title`, `num`, `min`, `di`, `num1`, `num2`, `num3`, `open`, `mtuse`, `usenum`, `mtneed`, `neednum`, `opengroup`, `tiku`, `time`) VALUES 
(1, '数学进阶测试题', 20, 60, 2, 10, 10, 0, 1, 'money', 1, 'money', 0, ',3,4,5,8,16,9,10,11,12,13,14,15,', 1, 1197699869),
(2, '数学基础题', 10, 60, 2, 10, 0, 0, 1, 'money', 1, 'money', 10, '', 1, 1197699264);


DROP TABLE IF EXISTS `pw_exam_shiti`;
CREATE TABLE IF NOT EXISTS `pw_exam_shiti` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `type` smallint(6) NOT NULL,
  `fen` smallint(6) NOT NULL,
  `xuanxiang` varchar(255) NOT NULL,
  `daan` varchar(255) NOT NULL,
  `koufen` smallint(6) NOT NULL,
  `tiku` int(11) NOT NULL,
  `opengroup` varchar(255) NOT NULL,
  `openkey` smallint(6) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


INSERT INTO `pw_exam_shiti` (`id`, `title`, `type`, `fen`, `xuanxiang`, `daan`, `koufen`, `tiku`, `opengroup`, `openkey`, `time`) VALUES 
(1, '1+1=?', 1, 1, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'B', 0, 1, '', 0, 1197699213),
(2, '1+2=?', 1, 1, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'C', 0, 1, '', 0, 1197699213),
(3, '1+3=?', 1, 1, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'D', 0, 1, '', 0, 1197699213),
(4, '1+4=?', 1, 1, 'a:4:{s:1:"A";s:1:"3";s:1:"B";s:1:"4";s:1:"C";s:1:"5";s:1:"D";s:1:"6";}', 'C', 0, 1, '', 0, 1197699213),
(5, '1+5=?', 1, 1, 'a:4:{s:1:"A";s:1:"4";s:1:"B";s:1:"5";s:1:"C";s:1:"6";s:1:"D";s:1:"7";}', 'C', 0, 1, '', 0, 1197699213),
(6, '1+6=?', 1, 1, 'a:4:{s:1:"A";s:1:"4";s:1:"B";s:1:"5";s:1:"C";s:1:"6";s:1:"D";s:1:"7";}', 'D', 0, 1, '', 0, 1197699213),
(7, '1+7=?', 1, 1, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:1:"8";s:1:"C";s:1:"6";s:1:"D";s:1:"7";}', 'B', 0, 1, '', 0, 1197699213),
(8, '1+8=?', 1, 1, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:1:"8";s:1:"C";s:1:"6";s:1:"D";s:1:"7";}', 'A', 0, 1, '', 0, 1197699213),
(9, '1+9=?', 1, 1, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:1:"8";s:1:"C";s:2:"10";s:1:"D";s:1:"7";}', 'C', 0, 1, '', 0, 1197699213),
(10, '2+1=?', 1, 1, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'C', 0, 1, '', 0, 1197699213),
(11, '2+2=?', 1, 1, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'D', 0, 1, '', 0, 1197699213),
(12, '2+3=?', 1, 1, 'a:4:{s:1:"A";s:1:"5";s:1:"B";s:1:"6";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'A', 0, 1, '', 0, 1197699213),
(13, '2+4=?', 1, 1, 'a:4:{s:1:"A";s:1:"5";s:1:"B";s:1:"6";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'B', 0, 1, '', 0, 1197699213),
(14, '2+8=?', 1, 1, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:1:"8";s:1:"C";s:2:"10";s:1:"D";s:1:"7";}', 'C', 0, 1, '', 0, 1197699213),
(15, '5+5=?', 1, 1, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:2:"10";s:1:"C";s:1:"8";s:1:"D";s:1:"7";}', 'B', 0, 1, '', 0, 1197699213),
(16, '请选择1和2', 2, 2, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'a:2:{i:0;s:1:"A";i:1;s:1:"B";}', 0, 1, '', 0, 1197699795),
(17, '请选择3和2', 2, 2, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'a:2:{i:0;s:1:"B";i:1;s:1:"C";}', 0, 1, '', 0, 1197699795),
(18, '请选择4和2', 2, 2, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'a:2:{i:0;s:1:"B";i:1;s:1:"D";}', 0, 1, '', 0, 1197699795),
(19, '请选择3和5', 2, 2, 'a:4:{s:1:"A";s:1:"3";s:1:"B";s:1:"4";s:1:"C";s:1:"5";s:1:"D";s:1:"6";}', 'a:2:{i:0;s:1:"A";i:1;s:1:"C";}', 0, 1, '', 0, 1197699795),
(20, '请选择4和7', 2, 2, 'a:4:{s:1:"A";s:1:"4";s:1:"B";s:1:"5";s:1:"C";s:1:"6";s:1:"D";s:1:"7";}', 'a:2:{i:0;s:1:"A";i:1;s:1:"D";}', 0, 1, '', 0, 1197699795),
(21, '请选择5和6', 2, 2, 'a:4:{s:1:"A";s:1:"4";s:1:"B";s:1:"5";s:1:"C";s:1:"6";s:1:"D";s:1:"7";}', 'a:2:{i:0;s:1:"B";i:1;s:1:"C";}', 0, 1, '', 0, 1197699795),
(22, '请选择6和7', 2, 2, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:1:"8";s:1:"C";s:1:"6";s:1:"D";s:1:"7";}', 'a:2:{i:0;s:1:"C";i:1;s:1:"D";}', 0, 1, '', 0, 1197699795),
(23, '请选择6,7,8', 2, 2, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:1:"8";s:1:"C";s:1:"6";s:1:"D";s:1:"7";}', 'a:3:{i:0;s:1:"B";i:1;s:1:"C";i:2;s:1:"D";}', 0, 1, '', 0, 1197699795),
(24, '请选择7,8,9', 2, 2, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:1:"8";s:1:"C";s:2:"10";s:1:"D";s:1:"7";}', 'a:3:{i:0;s:1:"A";i:1;s:1:"B";i:2;s:1:"D";}', 0, 1, '', 0, 1197699795),
(25, '请选择1,2,3', 2, 2, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'a:3:{i:0;s:1:"A";i:1;s:1:"B";i:2;s:1:"C";}', 0, 1, '', 0, 1197699795),
(26, '请选择2,3,4', 2, 2, 'a:4:{s:1:"A";s:1:"1";s:1:"B";s:1:"2";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'a:3:{i:0;s:1:"B";i:1;s:1:"C";i:2;s:1:"D";}', 0, 1, '', 0, 1197699795),
(27, '请选择3,4,5', 2, 2, 'a:4:{s:1:"A";s:1:"5";s:1:"B";s:1:"6";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'a:3:{i:0;s:1:"A";i:1;s:1:"C";i:2;s:1:"D";}', 0, 1, '', 0, 1197699795),
(28, '请全选', 2, 2, 'a:4:{s:1:"A";s:1:"5";s:1:"B";s:1:"6";s:1:"C";s:1:"3";s:1:"D";s:1:"4";}', 'a:4:{i:0;s:1:"A";i:1;s:1:"B";i:2;s:1:"C";i:3;s:1:"D";}', 0, 1, '', 0, 1197699795),
(29, '请全选', 2, 2, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:1:"8";s:1:"C";s:2:"10";s:1:"D";s:1:"7";}', 'a:4:{i:0;s:1:"A";i:1;s:1:"B";i:2;s:1:"C";i:3;s:1:"D";}', 0, 1, '', 0, 1197699795),
(30, '请全选', 2, 2, 'a:4:{s:1:"A";s:1:"9";s:1:"B";s:2:"10";s:1:"C";s:1:"8";s:1:"D";s:1:"7";}', 'a:4:{i:0;s:1:"A";i:1;s:1:"B";i:2;s:1:"C";i:3;s:1:"D";}', 0, 1, '', 0, 1197699795);


DROP TABLE IF EXISTS `pw_exam_tiku`;
CREATE TABLE IF NOT EXISTS `pw_exam_tiku` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL,
  `num` int(11) NOT NULL,
  `descrip` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `pw_exam_tiku` (`id`, `name`, `num`, `descrip`) VALUES 
(1, '测试专用题库', 0, '测试题库.\r\n测试题库.');
