--
-- Table structure for table `jcategory`
--

CREATE TABLE jcategory (
  cid int(11) NOT NULL auto_increment,
  cname varchar(50) NOT NULL default '',
  PRIMARY KEY  (cid)
) TYPE=MyISAM;

--
-- Table structure for table `jprefix`
--

CREATE TABLE jprefix (
  preid int(11) NOT NULL auto_increment,
  prefix varchar(60) NOT NULL default '',
  PRIMARY KEY  (preid)
) TYPE=MyISAM;

--
-- Table structure for table `jquestion`
--

CREATE TABLE jquestion (
  qid int(11) NOT NULL auto_increment,
  answer varchar(255) NOT NULL default '',
  pre int(11) NOT NULL default '0',
  question varchar(60) NOT NULL default '',
  explanation varchar(255) NOT NULL default '',
  cid int(11) NOT NULL default '0',
  correct int(11) NOT NULL default '0',
  incorrect int(11) NOT NULL default '0',
  PRIMARY KEY  (qid)
) TYPE=MyISAM;

--
-- Table structure for table `jscores`
--

CREATE TABLE jscores (
  sid int(11) NOT NULL auto_increment,
  sname varchar(50) NOT NULL default '',
  score int(11) NOT NULL default '0',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;