-- version 0.8
-- 
-- Ľṹ `##__exam_admin`
-- 

DROP TABLE IF EXISTS `##__exam_admin`;
CREATE TABLE `##__exam_admin` (
  `uid` int(11) NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL,
  `name` varchar(40) NOT NULL,
  `privkey` text NOT NULL,
  `loginban` tinyint(1) NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------

-- 
-- Ľṹ `##__exam_class`
-- 

DROP TABLE IF EXISTS `##__exam_class`;
CREATE TABLE `##__exam_class` (
  `id` smallint(6) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL,
  `descrip` varchar(250) NOT NULL,
  `istop` tinyint(4) NOT NULL,
  `upid` smallint(6) NOT NULL,
  `ids` varchar(250) NOT NULL,
  `orderkey` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------

-- 
-- Ľṹ `##__exam_filehash`
-- 

DROP TABLE IF EXISTS `##__exam_filehash`;
CREATE TABLE `##__exam_filehash` (
  `hash` varchar(32) NOT NULL,
  `time` int(11) NOT NULL,
  UNIQUE KEY `hash` (`hash`)
) ENGINE=MyISAM;

-- --------------------------------------------------------

-- 
-- Ľṹ `##__exam_kaojuan`
-- 

DROP TABLE IF EXISTS `##__exam_kaojuan`;
CREATE TABLE `##__exam_kaojuan` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL,
  `shijuan` int(11) NOT NULL,
  `author` int(11) NOT NULL,
  `start` int(11) NOT NULL,
  `end` int(11) NOT NULL,
  `content` text NOT NULL,
  `totalsorce` smallint(6) NOT NULL,
  `sorce` smallint(6) NOT NULL,
  `plusorce` smallint(6) NOT NULL,
  `close` tinyint(4) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------

-- 
-- Ľṹ `##__exam_shijuan`
-- 

DROP TABLE IF EXISTS `##__exam_shijuan`;
CREATE TABLE `##__exam_shijuan` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `descrip` varchar(250) NOT NULL,
  `dotime` smallint(6) NOT NULL,
  `limitime` smallint(6) NOT NULL,
  `start` int(11) NOT NULL,
  `end` int(11) NOT NULL,
  `shitimix` text NOT NULL,
  `fenmix` text NOT NULL,
  `money` int(11) NOT NULL,
  `tiku` int(11) NOT NULL,
  `class` int(11) NOT NULL,
  `fix` tinyint(1) NOT NULL,
  `xinli` tinyint(1) NOT NULL,
  `random` tinyint(1) NOT NULL,
  `selfpf` tinyint(1) NOT NULL,
  `open` tinyint(1) NOT NULL,
  `protect` tinyint(1) NOT NULL,
  `protecttime` smallint(6) NOT NULL,
  `ktimes` smallint(6) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------

-- 
-- Ľṹ `##__exam_shiti`
-- 

DROP TABLE IF EXISTS `##__exam_shiti`;
CREATE TABLE `##__exam_shiti` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `type` smallint(6) NOT NULL,
  `xuanxiang` text NOT NULL,
  `daan` text NOT NULL,
  `jieda` text NOT NULL,
  `fen` smallint(6) NOT NULL,
  `tiku` int(11) NOT NULL,
  `tikus` varchar(255) NOT NULL,
  `level` smallint(6) NOT NULL,
  `tag` varchar(250) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------

-- 
-- Ľṹ `##__exam_syslogs`
-- 

DROP TABLE IF EXISTS `##__exam_syslogs`;
CREATE TABLE `##__exam_syslogs` (
  `id` int(11) NOT NULL auto_increment,
  `adminid` int(11) NOT NULL,
  `adminname` varchar(20) NOT NULL,
  `dotype` varchar(60) NOT NULL,
  `doaction` varchar(20) NOT NULL,
  `identifyid` varchar(20) NOT NULL,
  `dourl` varchar(250) NOT NULL,
  `dotime` int(11) NOT NULL,
  `doip` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------

-- 
-- Ľṹ `##__exam_tiku`
-- 

DROP TABLE IF EXISTS `##__exam_tiku`;
CREATE TABLE `##__exam_tiku` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL,
  `descrip` varchar(250) NOT NULL,
  `istop` tinyint(4) NOT NULL,
  `upid` int(11) NOT NULL,
  `storetable` varchar(60) NOT NULL,
  `orderkey` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------

-- 
-- Ľṹ `##__exam_xt`
-- 

DROP TABLE IF EXISTS `##__exam_xt`;
CREATE TABLE `##__exam_xt` (
  `id` int(11) NOT NULL auto_increment,
  `sjid` int(11) NOT NULL,
  `tiku` int(11) NOT NULL,
  `stid` int(11) NOT NULL,
  `type` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------
