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;

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;


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;

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;


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, 'ѡ12', 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, 'ѡ32', 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, 'ѡ42', 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, 'ѡ35', 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, 'ѡ47', 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, 'ѡ56', 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, 'ѡ67', 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;

INSERT INTO `pw_exam_tiku` (`id`, `name`, `num`, `descrip`) VALUES 
(1, 'ר', 0, '.\r\n.');
