-- 
-- Ľṹ `##__exam_admin`
-- 

DROP TABLE IF EXISTS `##__exam_admin`;
CREATE TABLE `##__exam_admin` (
  `uid` int(11) NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL default '',
  `name` varchar(40) NOT NULL default '',
  `privkey` text NOT NULL,
  `loginban` tinyint(1) NOT NULL default '0',
  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 default '',
  `descrip` varchar(250) NOT NULL default '',
  `istop` tinyint(4) NOT NULL default '0',
  `upid` smallint(6) NOT NULL default '0',
  `ids` varchar(250) NOT NULL default '',
  `orderkey` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

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

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

DROP TABLE IF EXISTS `##__exam_filehash`;
CREATE TABLE `##__exam_filehash` (
  `hash` varchar(32) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  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 default '',
  `shijuan` int(11) NOT NULL default '0',
  `author` int(11) NOT NULL default '0',
  `start` int(11) NOT NULL default '0',
  `end` int(11) NOT NULL default '0',
  `content` MEDIUMTEXT NOT NULL,
  `totalsorce` smallint(6) NOT NULL default '0',
  `sorce` smallint(6) NOT NULL default '0',
  `plusorce` smallint(6) NOT NULL default '0',
  `close` tinyint(4) NOT NULL default '0',
  `ip` varchar(30) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

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

-- 
-- Ľṹ `##__exam_passport`
-- 

DROP TABLE IF EXISTS `##__exam_passport`;
CREATE TABLE `##__exam_passport` (
  `uid` int(11) NOT NULL,
  `username` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `username` (`username`)
) 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 default '',
  `descrip` varchar(250) NOT NULL default '',
  `dotime` smallint(6) NOT NULL default '0',
  `limitime` smallint(6) NOT NULL default '0',
  `start` int(11) NOT NULL default '0',
  `end` int(11) NOT NULL default '0',
  `shitimix` text NOT NULL,
  `fenmix` text NOT NULL,
  `timemix` text NOT NULL,
  `lvlmin` smallint(6) NOT NULL default '0',
  `lvlmax` varchar(6) NOT NULL default '0',
  `money` int(11) NOT NULL default '0',
  `tiku` int(11) NOT NULL default '0',
  `class` int(11) NOT NULL default '0',
  `fix` tinyint(1) NOT NULL default '0',
  `xinli` tinyint(1) NOT NULL default '0',
  `random` tinyint(1) NOT NULL default '0',
  `selfpf` tinyint(1) NOT NULL default '0',
  `open` tinyint(1) NOT NULL default '0',
  `protect` tinyint(1) NOT NULL default '0',
  `protecttime` smallint(6) NOT NULL default '0',
  `ktimes` smallint(6) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  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 default '0',
  `xuanxiang` text NOT NULL,
  `daan` text NOT NULL,
  `jieda` text NOT NULL,
  `fen` smallint(6) NOT NULL default '0',
  `tiku` int(11) NOT NULL default '0',
  `tikus` varchar(255) NOT NULL default '',
  `level` smallint(6) NOT NULL default '0',
  `tag` varchar(250) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  `ext1` tinyint(1) NOT NULL default '0',
  `ext2` varchar(250) NOT NULL default '',
  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 default '0',
  `adminname` varchar(20) NOT NULL default '',
  `dotype` varchar(60) NOT NULL default '',
  `doaction` varchar(20) NOT NULL default '',
  `identifyid` varchar(20) NOT NULL default '',
  `dourl` varchar(250) NOT NULL default '',
  `dotime` int(11) NOT NULL default '0',
  `doip` varchar(20) NOT NULL default '',
  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 default '',
  `descrip` varchar(250) NOT NULL default '',
  `istop` tinyint(4) NOT NULL default '0',
  `upid` int(11) NOT NULL default '0',
  `storetable` varchar(60) NOT NULL default '',
  `orderkey` int(11) NOT NULL default '0',
  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 default '0',
  `tiku` int(11) NOT NULL default '0',
  `stid` int(11) NOT NULL default '0',
  `type` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;
