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, 'ƾǶiD', 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, 'ƾǰ¦D', 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, 'п1M2', 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, 'п3M2', 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, 'п4M2', 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, 'п3M5', 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, 'п4M7', 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, 'п5M6', 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, 'п6M7', 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, 'ձMDw', 0, 'Dw.\r\nDw.');
