-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `ot_ads`
--

CREATE TABLE IF NOT EXISTS `ot_ads` (
  `ad_id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_name` varchar(50) NOT NULL,
  `ad_code` text NOT NULL,
  `ad_status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ot_ads`
--

INSERT INTO `ot_ads` (`ad_id`, `ad_name`, `ad_code`, `ad_status`) VALUES
(1, 'header468', '', 0),
(2, 'header320', '', 0),
(3, 'sidebar600', '', 0),
(4, 'sidebar600left', '', 0);

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

--
-- Table structure for table `ot_all_answers`
--

CREATE TABLE IF NOT EXISTS `ot_all_answers` (
  `all_id` int(11) NOT NULL AUTO_INCREMENT,
  `all_answer_id` int(11) NOT NULL,
  `all_slambook_id` int(11) NOT NULL,
  `all_quest_id` int(11) NOT NULL,
  `all_answer` varchar(100) NOT NULL,
  PRIMARY KEY (`all_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_ip_blocked`
--

CREATE TABLE IF NOT EXISTS `ot_ip_blocked` (
  `ip_id` int(11) NOT NULL AUTO_INCREMENT,
  `blocked_ip` varchar(100) NOT NULL,
  `block_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_questions`
--

CREATE TABLE IF NOT EXISTS `ot_questions` (
  `quest_id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(255) NOT NULL,
  `question_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`quest_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_slambook`
--

CREATE TABLE IF NOT EXISTS `ot_slambook` (
  `slambook_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `user_ip` varchar(100) NOT NULL,
  `slambook_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`slambook_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_slambook_answers`
--

CREATE TABLE IF NOT EXISTS `ot_slambook_answers` (
  `answer_id` int(11) NOT NULL AUTO_INCREMENT,
  `ans_user_ip` varchar(100) NOT NULL,
  `ans_slambook_id` int(11) NOT NULL,
  `ans_username` varchar(20) NOT NULL,
  `slamanswer_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`answer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_slambook_quest`
--

CREATE TABLE IF NOT EXISTS `ot_slambook_quest` (
  `sb_quest_id` int(11) NOT NULL AUTO_INCREMENT,
  `sb_slambook_id` int(11) NOT NULL,
  `sb_questions` varchar(100) NOT NULL,
  PRIMARY KEY (`sb_quest_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
COMMIT;

