-- 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` longtext NOT NULL,
  `ad_status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ad_id`),
  UNIQUE KEY `ad_name` (`ad_name`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

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

INSERT INTO `ot_ads` (`ad_id`, `ad_name`, `ad_code`, `ad_status`) VALUES
(1, 'header_970_90', '', 0),
(2, 'header_320_100', '', 0),
(3, 'desktopfeatured300_one', '', 0),
(4, 'desktopfeatured300_two', '', 0),
(5, 'desktoptrending300_one', '', 0),
(6, 'desktoptrending300_two', '', 0),
(7, 'mobilefeatured300_one', '', 0),
(8, 'mobiletrending300_one', '', 0),
(9, 'sidebar600', '', 0),
(10, 'sidebar300', '', 0),
(11, 'commonfeatured300', '', 0),
(12, 'commontrending300', '', 0);

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

--
-- Table structure for table `ot_comments`
--

CREATE TABLE IF NOT EXISTS `ot_comments` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `comment` longtext NOT NULL,
  `c_user_ip` varchar(100) NOT NULL,
  `admin_reply` longtext,
  `comment_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `comment_seen` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_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_loader`
--

CREATE TABLE IF NOT EXISTS `ot_loader` (
  `loader_id` int(11) NOT NULL AUTO_INCREMENT,
  `loading` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`loader_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ot_loader`
--

INSERT INTO `ot_loader` (`loader_id`, `loading`) VALUES
(1, 4),
(2, 4),
(3, 4),
(4, 4),
(5, 4),
(6, 4),
(7, 4),
(8, 4),
(9, 4);

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

--
-- Table structure for table `ot_secret_love`
--

CREATE TABLE IF NOT EXISTS `ot_secret_love` (
  `love_id` int(11) NOT NULL AUTO_INCREMENT,
  `love_post_id` int(11) NOT NULL,
  `love_user_ip` varchar(100) NOT NULL,
  `love_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`love_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
COMMIT;

