TimeKeeper/timekeeper_sql.php

CREATE TABLE `timekeeper` (
  `timekeeper_username` varchar(255) NOT NULL DEFAULT '',
  `timekeeper_Enabled` bit(1) DEFAULT NULL,
  `timekeeper_Freemins` int(10) unsigned NOT NULL DEFAULT '0',
  `timekeeper_Enable_Time` double(2) NOT NULL DEFAULT '0',
  `timekeeper_Disable_Time` double NOT NULL DEFAULT '0',
  `timekeeper_Min_Question_Count` int(11) DEFAULT '0',
  PRIMARY KEY (`timekeeper_username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `timekeeperPending` (
  `timekeeper_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `timekeeper_username` varchar(255) NOT NULL DEFAULT '',
  `timekeeper_question` int(10) unsigned DEFAULT '0',
  `timekeeper_answereddatestamp` int(10) unsigned DEFAULT '0',
  `timekeeper_answer` text NOT NULL,
  PRIMARY KEY (`timekeeper_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `timekeeperQuestions` (
  `timekeeper_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `timekeeper_subject` varchar(255) NOT NULL DEFAULT '',
  `timekeeper_questiondescription` text NOT NULL,
  `timekeeper_question` longtext NOT NULL,
  `timekeeper_addeddatestamp` int(10) unsigned DEFAULT '0',
  `timekeeper_yearlevel` int(2) unsigned DEFAULT '0',
  `timekeeper_answers` text NOT NULL,
  `timekeeper_correctanswer` int(3) unsigned DEFAULT '0',
  PRIMARY KEY (`timekeeper_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `timekeeperReport` (
  `timekeeper_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `timekeeper_username` varchar(255) NOT NULL DEFAULT '',
  `timekeeper_question` text NOT NULL,
  `timekeeper_answereddatestamp` int(10) unsigned DEFAULT '0',
  `timekeeper_userAnswer` text NOT NULL,
  `timekeeper_answer` text NOT NULL,
  `timekeeper_yearLevel` int(2) unsigned DEFAULT '0',
  `timekeeper_subject` varchar(255) NOT NULL DEFAULT '',
  `timekeeper_correct` int(1) unsigned DEFAULT '0',
  PRIMARY KEY (`timekeeper_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `timekeeperScore` (
  `timekeeper_id` int(10) unsigned AUTO_INCREMENT,
  `timekeeper_username` varchar(255) NOT NULL DEFAULT '',
  `timekeeper_lifetimequestions` int(10) unsigned DEFAULT '0',
  `timekeeper_lifetimecorrect` int(10) unsigned DEFAULT '0',
  `timekeeper_minutes` int(10) unsigned DEFAULT '0',
  `timekeeper_yearlevel` int(2) unsigned DEFAULT '0',
  `timekeeper_lastquestiondatestamp` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`timekeeper_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `timekeeperStats` (
  `timekeeper_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `timekeeper_username` varchar(255) NOT NULL DEFAULT '',
  `timekeeper_subject` varchar(255) NOT NULL DEFAULT '',
  `timekeeper_percent` int(3) unsigned DEFAULT '0',
  `timekeeper_yearLevel` int(2) unsigned DEFAULT '0',
  `timekeeper_quantity` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`timekeeper_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tkLastQuestion` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `user` VARCHAR(100) NULL,
  `LastQuestionHtml` LONGTEXT NULL,
  PRIMARY KEY (`id`));
  
  CREATE TABLE tkPendingAnswer (
  username varchar(100) NOT NULL,
  token char(32) NOT NULL,
  payload text NOT NULL,
  created int(10) unsigned NOT NULL,
  PRIMARY KEY (username)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;