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=gbk;

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=gbk;


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=gbk;

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=gbk;


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  DEFAULT CHARSET=gbk;

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