

-- Admin history

CREATE TABLE `admin_history` (
  `id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(id),
  `last_date` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL
);

-- Ads
CREATE TABLE `ads` (
  `id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(id),
  `text_ads` text,
  `ads_1` text,
  `ads_2` text
);

INSERT INTO ads (text_ads,ads_1,ads_2) VALUES ('','','');

-- Bans

CREATE TABLE `ban_user` (
  `id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(id),
  `ip` varchar(255) DEFAULT NULL,
  `last_date` varchar(255) DEFAULT NULL
);

-- Interface

CREATE TABLE `interface` (
  `id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(id),
  `theme` text,
  `lang` text
);

INSERT INTO interface (theme,lang) VALUES ('default','en.php');

-- Pages

CREATE TABLE `pages` (
  `id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(id),
  `last_date` varchar(255) DEFAULT NULL,
  `page_name` varchar(255) DEFAULT NULL,
  `page_title` mediumtext,
  `page_content` longtext
);

-- Page views

CREATE TABLE `page_view` (
  `id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(id),
  `date` varchar(255) DEFAULT NULL,
  `tpage` varchar(255) DEFAULT NULL,
  `tvisit` varchar(255) DEFAULT NULL
);

-- Sitemap

CREATE TABLE `sitemap_options` (
  `id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(id),
  `priority` varchar(255) DEFAULT NULL,
  `changefreq` varchar(255) DEFAULT NULL
);

INSERT INTO `sitemap_options` (`id`, `priority`, `changefreq`) VALUES
(1, '0.9', 'daily');

-- Site info

CREATE TABLE `site_info` (
  `id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(id),
  `title` varchar(255) DEFAULT NULL,
  `des` mediumtext,
  `keyword` mediumtext,
  `site_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `twit` varchar(4000) DEFAULT NULL,
  `face` varchar(4000) DEFAULT NULL,
  `gplus` varchar(4000) DEFAULT NULL,
  `ga` varchar(255) DEFAULT NULL,
  `additional_scripts` text,
  `baseurl` text
);

INSERT INTO `site_info` (`id`, `title`, `des`, `keyword`, `site_name`, `email`, `twit`, `face`, `gplus`, `ga`, `additional_scripts`, `baseurl`) VALUES
(1, 'Paste', 'Paste can store text, source code or sensitive data for a set period of time.', 'paste,pastebin.com,pastebin,text,paste,online paste', 'Paste', '', 'https://twitter.com/', 'https://www.facebook.com/', 'https://plus.google.com/', 'UA-', '', 'pastethis.in');

-- Site permissions

CREATE TABLE `site_permissions` (
  `id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(id),
  `disableguest` varchar(255) DEFAULT NULL,
  `siteprivate` varchar(255) DEFAULT NULL
);

INSERT INTO `site_permissions` (`id`, `disableguest`, `siteprivate`) VALUES
(1, '', ''),
(2, 'off', 'off');