#
# TABLE STRUCTURE FOR: fuel_archives
#

DROP TABLE IF EXISTS fuel_archives;

CREATE TABLE `fuel_archives` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ref_id` int(10) unsigned NOT NULL,
  `table_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `data` text COLLATE utf8_unicode_ci NOT NULL,
  `version` smallint(5) unsigned NOT NULL,
  `version_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `archived_user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_archives (`id`, `ref_id`, `table_name`, `data`, `version`, `version_timestamp`, `archived_user_id`) VALUES (1, 1, 'fuel_blog_posts', 'a:12:{s:2:\"id\";i:1;s:5:\"title\";s:8:\"Success!\";s:9:\"permalink\";s:7:\"success\";s:7:\"content\";s:411:\"<p>This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah! This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah! This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah!</p>\";s:10:\"formatting\";s:15:\"auto_typography\";s:7:\"excerpt\";s:141:\"<p>This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah!</p>\";s:9:\"author_id\";s:1:\"1\";s:6:\"sticky\";s:3:\"yes\";s:14:\"allow_comments\";s:3:\"yes\";s:10:\"date_added\";s:19:\"2012-01-23 12:36:54\";s:13:\"last_modified\";s:19:\"2012-01-23 12:36:54\";s:9:\"published\";s:3:\"yes\";}', 1, '2012-01-24 09:36:54', 1);


#
# TABLE STRUCTURE FOR: fuel_blocks
#

DROP TABLE IF EXISTS fuel_blocks;

CREATE TABLE `fuel_blocks` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `view` text COLLATE utf8_unicode_ci NOT NULL,
  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  `date_added` datetime DEFAULT NULL,
  `last_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: fuel_blog_categories
#

DROP TABLE IF EXISTS fuel_blog_categories;

CREATE TABLE `fuel_blog_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `permalink` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'If left blank, the permalink will automatically be created for you.',
  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  UNIQUE KEY `permalink` (`permalink`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_blog_categories (`id`, `name`, `permalink`, `published`) VALUES (1, 'Uncategorized', 'uncategorized', 'yes');


#
# TABLE STRUCTURE FOR: fuel_blog_comments
#

DROP TABLE IF EXISTS fuel_blog_comments;

CREATE TABLE `fuel_blog_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `author_id` int(10) unsigned NOT NULL,
  `author_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `author_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `author_website` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `author_ip` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `is_spam` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  `date_added` datetime NOT NULL,
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: fuel_blog_links
#

DROP TABLE IF EXISTS fuel_blog_links;

CREATE TABLE `fuel_blog_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `target` enum('blank','self','parent') DEFAULT 'blank',
  `description` varchar(100) DEFAULT NULL,
  `precedence` int(11) NOT NULL DEFAULT '0',
  `published` enum('yes','no') DEFAULT 'yes',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# TABLE STRUCTURE FOR: fuel_blog_posts
#

DROP TABLE IF EXISTS fuel_blog_posts;

CREATE TABLE `fuel_blog_posts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `permalink` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'This is the last part of the url string. If left blank, the permalink will automatically be created for you.',
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `content_filtered` text COLLATE utf8_unicode_ci NOT NULL,
  `formatting` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `excerpt` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'A condensed version of the content',
  `author_id` int(10) unsigned NOT NULL COMMENT 'If left blank, you will assumed be the author.',
  `sticky` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `allow_comments` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
  `date_added` datetime DEFAULT NULL,
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permalink` (`permalink`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_blog_posts (`id`, `title`, `permalink`, `content`, `content_filtered`, `formatting`, `excerpt`, `author_id`, `sticky`, `allow_comments`, `date_added`, `last_modified`, `published`) VALUES (1, 'Success!', 'success', '<p>This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah! This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah! This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah!</p>', 'This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah! This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah! This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah!', 'auto_typography', '<p>This is a test! New formatting will be added for CKEditor. This is pulling from the blog module, hopefully it''s working! Blah, hablah!</p>', 1, 'yes', 'yes', '2012-01-23 12:36:54', '2012-01-23 12:36:54', 'yes');


#
# TABLE STRUCTURE FOR: fuel_blog_posts_to_categories
#

DROP TABLE IF EXISTS fuel_blog_posts_to_categories;

CREATE TABLE `fuel_blog_posts_to_categories` (
  `post_id` int(10) unsigned NOT NULL,
  `category_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`post_id`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_blog_posts_to_categories (`post_id`, `category_id`) VALUES (1, 1);


#
# TABLE STRUCTURE FOR: fuel_blog_settings
#

DROP TABLE IF EXISTS fuel_blog_settings;

CREATE TABLE `fuel_blog_settings` (
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('title', 'My Blog');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('uri', 'blog/');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('theme_layout', 'blog');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('theme_path', 'themes/default/');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('theme_module', 'blog');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('use_cache', '0');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('cache_ttl', '3600');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('per_page', '2');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('description', '');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('use_captchas', '1');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('monitor_comments', '1');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('save_spam', '1');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('allow_comments', '1');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('akismet_api_key', '');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('comments_time_limit', '');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('multiple_comment_submission_time_limit', '30');
INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('asset_upload_path', 'images/blog/');


#
# TABLE STRUCTURE FOR: fuel_blog_users
#

DROP TABLE IF EXISTS fuel_blog_users;

CREATE TABLE `fuel_blog_users` (
  `fuel_user_id` int(10) unsigned NOT NULL,
  `display_name` varchar(50) NOT NULL,
  `website` varchar(100) NOT NULL,
  `about` text NOT NULL,
  `avatar_image` varchar(255) NOT NULL,
  `twitter` varchar(255) NOT NULL,
  `facebook` varchar(255) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `active` enum('yes','no') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`fuel_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO fuel_blog_users (`fuel_user_id`, `display_name`, `website`, `about`, `avatar_image`, `twitter`, `facebook`, `date_added`, `active`) VALUES (1, 'Jarrod Mosen', '', '', '', '', '', '2012-01-23 12:36:54', 'yes');


#
# TABLE STRUCTURE FOR: fuel_logs
#

DROP TABLE IF EXISTS fuel_logs;

CREATE TABLE `fuel_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_date` datetime NOT NULL,
  `user_id` int(11) NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_logs (`id`, `entry_date`, `user_id`, `message`) VALUES (1, '2012-01-23 12:35:14', 1, 'Site cache cleared explicitly');
INSERT INTO fuel_logs (`id`, `entry_date`, `user_id`, `message`) VALUES (2, '2012-01-23 12:36:54', 1, 'Posts item <em>Success!</em> edited');
INSERT INTO fuel_logs (`id`, `entry_date`, `user_id`, `message`) VALUES (3, '2012-01-23 14:48:01', 1, 'Users item <em>stellardawnnews@gmail.com</em> edited');


#
# TABLE STRUCTURE FOR: fuel_navigation
#

DROP TABLE IF EXISTS fuel_navigation;

CREATE TABLE `fuel_navigation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(5) unsigned NOT NULL DEFAULT '1',
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The part of the path after the domain name that you want the link to go to (e.g. comany/about)',
  `nav_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The nav key is a friendly ID that you can use for setting the selected state. If left blank, a default value will be set for you',
  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The name you want to appear in the menu',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Used for creating menu hierarchies. No value means it is a root level menu item',
  `precedence` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The higher the number, the greater the precedence and farther up the list the navigational element will appear',
  `attributes` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Extra attributes that can be used for navigation implementation',
  `selected` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The pattern to match for the active state. Most likely you leave this field blank',
  `hidden` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no' COMMENT 'A hidden value can be used in rendering the menu. In some areas, the menu item may not want to be displayed',
  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes' COMMENT 'Determines whether the item is displayed or not',
  PRIMARY KEY (`id`),
  UNIQUE KEY `group_id` (`group_id`,`location`,`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: fuel_navigation_groups
#

DROP TABLE IF EXISTS fuel_navigation_groups;

CREATE TABLE `fuel_navigation_groups` (
  `id` int(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_navigation_groups (`id`, `name`, `published`) VALUES (1, 'main', 'yes');


#
# TABLE STRUCTURE FOR: fuel_page_variables
#

DROP TABLE IF EXISTS fuel_page_variables;

CREATE TABLE `fuel_page_variables` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `page_id` int(10) unsigned NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `scope` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('string','int','boolean','array','template') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'string',
  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_id` (`page_id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: fuel_pages
#

DROP TABLE IF EXISTS fuel_pages;

CREATE TABLE `fuel_pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Add the part of the url after the root of your site (usually after the domain name). For the homepage, just put the word ''home''',
  `layout` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The name of the template to associate with this page',
  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes' COMMENT 'A ''yes'' value will display the page and an ''no'' value will give a 404 error message',
  `cache` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes' COMMENT 'Cache controls whether the page will pull from the database or from a saved file which is more effeicent. If a page has content that is dynamic, it''s best to set cache to ''no''',
  `date_added` datetime DEFAULT NULL,
  `last_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_modified_by` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `location` (`location`),
  KEY `layout` (`layout`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: fuel_permissions
#

DROP TABLE IF EXISTS fuel_permissions;

CREATE TABLE `fuel_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Permissions beginning with ''Manage '' will allow items to appear on the left menu',
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (1, 'pages', 'Manage pages', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (2, 'pages_publish', 'Publish Pages', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (3, 'pages_delete', 'Delete Pages', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (4, 'navigation', 'Manage navigation', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (5, 'users', 'Manage users', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (6, 'tools/backup', 'Manage database backup', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (7, 'manage/cache', 'Manage the page cache', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (8, 'manage/activity', 'View activity logs', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (9, 'myPHPadmin', 'myPHPadmin', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (10, 'google_analytics', 'Google Analytics', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (11, 'tools/user_guide', 'Access the User Guide', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (12, 'manage', 'View the Manage Dashboard Page', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (13, 'permissions', 'Manage Permissions', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (14, 'tools', 'Manage Tools', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (15, 'tools/seo/google_keywords', 'Google Keywords', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (16, 'sitevariables', 'Site Variables', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (17, 'blog/posts', 'Blog Posts', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (18, 'blog/categories', 'Blog Categories', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (19, 'blog/comments', 'Blog Comments', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (20, 'blog/links', 'Blog Links', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (21, 'blog/users', 'Blog Authors', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (22, 'blog/settings', 'Blog Settings', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (23, 'assets', 'Assets', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (24, 'tools/validate', 'Validate', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (25, 'tools/seo', 'Page Analysis', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (26, 'tools/tester', 'Tester Module', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (27, 'blocks', 'Manage Blocks', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (28, 'site_docs', 'Site Documentation', 'yes');
INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (29, 'tools/cronjobs', 'Cronjobs', 'yes');


#
# TABLE STRUCTURE FOR: fuel_site_variables
#

DROP TABLE IF EXISTS fuel_site_variables;

CREATE TABLE `fuel_site_variables` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `scope` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'leave blank if you want the variable to be available to all pages',
  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: fuel_user_to_permissions
#

DROP TABLE IF EXISTS fuel_user_to_permissions;

CREATE TABLE `fuel_user_to_permissions` (
  `user_id` int(10) unsigned NOT NULL,
  `permission_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 1);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 2);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 3);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 4);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 5);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 6);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 7);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 8);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 9);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 10);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 11);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 12);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 13);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 14);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 15);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 16);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 17);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 18);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 19);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 20);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 21);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 22);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 23);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 24);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 25);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 26);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 27);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 28);
INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 29);


#
# TABLE STRUCTURE FOR: fuel_users
#

DROP TABLE IF EXISTS fuel_users;

CREATE TABLE `fuel_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `language` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'english',
  `reset_key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `super_admin` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO fuel_users (`id`, `user_name`, `password`, `email`, `first_name`, `last_name`, `language`, `reset_key`, `super_admin`, `active`) VALUES (1, 'Heist', '0dfbea04719f221f0ac261164d9677ca', 'jarrod.mosen@me.com', 'Jarrod', 'Mosen', 'english', '', 'yes', 'yes');
INSERT INTO fuel_users (`id`, `user_name`, `password`, `email`, `first_name`, `last_name`, `language`, `reset_key`, `super_admin`, `active`) VALUES (3, 'Pliigi', '21232f297a57a5a743894a0e4a801fc3', 'stellardawnnews@gmail.com', 'Pliigi', 'Dawn', 'english', '', 'no', 'yes');