text: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `blocks`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**blocks` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(55) COLLATE utf8_unicode_ci NOT NULL,
    `block` text COLLATE utf8_unicode_ci,
    `priority` int(11) DEFAULT NULL,
    `area` varchar(55) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `blocks_requirements`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**blocks_requirements` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `blocks_id` int(11) NOT NULL,
    `type` varchar(55) COLLATE utf8_unicode_ci NOT NULL,
    `requirement` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `comments`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**comments` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `content_id` int(11) NOT NULL,
    `name` varchar(55) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(55) COLLATE utf8_unicode_ci NOT NULL,
    `comment` text COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `content`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**content` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `header` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `subheader` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `featured` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `body` text COLLATE utf8_unicode_ci,
    `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `type` varchar(55) COLLATE utf8_unicode_ci DEFAULT NULL,
    `published` varchar(55) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
    `published_date` int(11) DEFAULT NULL,
    `author` int(11) COLLATE utf8_unicode_ci DEFAULT NULL,
    `timestamp` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `url` (`url`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `content_extras`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**content_extras` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `content_id` int(11) NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `extra` text COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `content_tags`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**content_tags` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `content_id` int(11) NOT NULL,
    `tag` varchar(55) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `favorites`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**favorites` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `mls` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `files`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**files` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `responsive` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
    `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'image',
    `timestamp` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `menus`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**menus` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(55) COLLATE utf8_unicode_ci NOT NULL,
    `menu` text COLLATE utf8_unicode_ci,
    `area` varchar(55) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `misc`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**misc` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `value` text COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `modules`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**modules` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `module` varchar(55) COLLATE utf8_unicode_ci NOT NULL,
    `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `module` (`module`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `revisions`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**revisions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `content_id` int(11) NOT NULL,
    `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `header` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `subheader` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `featured` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `body` text COLLATE utf8_unicode_ci,
    `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `published` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `published_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `timestamp` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `revisions_extras`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**revisions_extras` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `revisions_id` int(11) NOT NULL,
    `content_id` int(11) DEFAULT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `extra` text COLLATE utf8_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `settings`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**settings` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `site_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `slogan` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `favicon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `theme` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `maintenance_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT '/maintenance',
    `maintenance_mode` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'false',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tokens`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**tokens` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `users_id` int(11) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE IF NOT EXISTS `**prefix**users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `bio` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `facebook` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `twitter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `role` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `username` (`email`),
    UNIQUE KEY `username_2` (`username`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;