DROP TABLE IF EXISTS `site_plugin_maintenance_messages`;
CREATE TABLE `site_plugin_maintenance_messages` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_code` varchar(32) DEFAULT NULL,
  `item_file` int(1) DEFAULT NULL,
  `item_file_file` varchar(255) DEFAULT NULL,
  `module_id` int(11) DEFAULT NULL,
  `item_new` int(1) DEFAULT NULL,
  `item_replied` int(1) NOT NULL,
  `item_replied_date` int(11) NOT NULL,
  `item_date` int(11) DEFAULT NULL,
  `item_email` varchar(255) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_subject` varchar(255) DEFAULT NULL,
  `item_message` text,
  `item_anonymous` int(1) NOT NULL,
  `item_spam` int(1) NOT NULL,
  `log_ip` varchar(50) NOT NULL,
  `log_domain` varchar(255) NOT NULL,
  `log_agent` varchar(255) NOT NULL,
  `item_reply` text NOT NULL,
  PRIMARY KEY (`item_id`),
  KEY `item_id` (`item_id`,`module_id`,`item_new`,`item_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `site_plugin_maintenance_texts`;
CREATE TABLE `site_plugin_maintenance_texts` (
  `module_id` int(11) NOT NULL,
  `text_image` int(1) NOT NULL,
  KEY `module_id` (`module_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `site_plugin_maintenance_texts_lang`;
CREATE TABLE `site_plugin_maintenance_texts_lang` (
  `module_id` int(11) NOT NULL,
  `lang_id` int(11) NOT NULL,
  `text_title` varchar(255) NOT NULL,
  `text_header` text NOT NULL,
  `text_footer` text NOT NULL,
  `text_footer_title` varchar(255) NOT NULL,
  `text_footer_header` text NOT NULL,
  `seo_title` varchar(255) NOT NULL,
  `seo_desc` text NOT NULL,
  `text_form_title` varchar(255) NOT NULL,
  `text_form_subtitle` text NOT NULL,
  KEY `module_id` (`module_id`,`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `site_plugin_maintenance_users`;
CREATE TABLE `site_plugin_maintenance_users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_date` int(11) NOT NULL,
  `user_key` varchar(32) NOT NULL,
  `user_login` varchar(50) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_first_name` varchar(100) NOT NULL,
  `user_last_name` varchar(100) NOT NULL,
  `user_last_login` int(11) NOT NULL,
  `user_last_login_ip` varchar(50) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `site_plugin_maintenance_texts` (`module_id`, `text_image`) VALUES
(104,	1);

INSERT INTO `site_plugin_maintenance_texts_lang` (`module_id`, `lang_id`, `text_title`, `text_header`, `text_footer`, `text_footer_title`, `text_footer_header`, `seo_title`, `seo_desc`, `text_form_title`, `text_form_subtitle`) VALUES
(104,	1,	'Howdy',	'We\'re working on great stuff now. Subscribe to our newsletter, let\'s get social or email us to get on board early and win exclusive deals!',	'',	'This is us',	'<blockquote>Nunc partim plagae moles. Nullaque descenderat mortales. Auroram super levius obliquis tegit dissociata onerosior homini diu.</blockquote>\r\n\r\n<ul>\r\n	<li>Sua fidem quia pluviaque traxit nebulas phoebe pontus glomeravit corpore tellus pendebat feras siccis adhuc postquam nova ipsa ensis</li>\r\n	<li>Orbe fuerat matutinis lucis mundi addidit nebulas media fluminaque certis praecipites quarum</li>\r\n</ul>\r\n\r\n<h1>header1</h1>\r\n\r\n<p>[icomoon=icon-envelop] Regio <a href=\"http://devsaverr.com/contact/\">iunctarum</a> melior. Forma naturae conversa haec aurea sectamque obsistitur tellus. Mutatas pondere induit tegit adhuc postquam.</p>\r\n\r\n<h2>Heading2</h2>\r\n\r\n<h4>[icomoon=icon-envelop] Subtitle</h4>\r\n\r\n<p>Nunc partim plagae moles. Nullaque descenderat mortales. Auroram super levius obliquis tegit dissociata onerosior homini diu.</p>\r\n\r\n<h4>Heading4</h4>\r\n\r\n<p>Nunc partim plagae moles. Nullaque descenderat mortales. Auroram super levius obliquis tegit dissociata onerosior homini diu.</p>\r\n\r\n<p>Nunc partim plagae moles. Nullaque descenderat mortales. Auroram super levius obliquis tegit dissociata onerosior homini diu.</p>\r\n\r\n<ol>\r\n	<li>Cura fuerat convexi corpora perpetuum cum ante ensis madescit sed ora contraria fronde umor abscidit feras spectent primaque his nullaque</li>\r\n	<li>Dissaepserat zephyro membra quae ripis bracchia speciem levius siccis ulla</li>\r\n</ol>\r\n\r\n<h3>Heading3</h3>\r\n',	'Placeholder',	'',	'Contact Us',	'');
