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=~~charset~~;


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=~~charset~~;


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=~~charset~~;


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=~~charset~~;



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=~~charset~~;
