XRtWVsEY

1#
2# TABLE STRUCTURE FOR: fuel_archives
3#
4
5DROP TABLE IF EXISTS fuel_archives;
6
7CREATE TABLE `fuel_archives` (
8  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
9  `ref_id` int(10) unsigned NOT NULL,
10  `table_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
11  `data` text COLLATE utf8_unicode_ci NOT NULL,
12  `version` smallint(5) unsigned NOT NULL,
13  `version_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14  `archived_user_id` int(10) unsigned NOT NULL,
15  PRIMARY KEY (`id`)
16) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
17
18INSERT 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);
19
20
21#
22# TABLE STRUCTURE FOR: fuel_blocks
23#
24
25DROP TABLE IF EXISTS fuel_blocks;
26
27CREATE TABLE `fuel_blocks` (
28  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
29  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
30  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
31  `view` text COLLATE utf8_unicode_ci NOT NULL,
32  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
33  `date_added` datetime DEFAULT NULL,
34  `last_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
35  PRIMARY KEY (`id`),
36  UNIQUE KEY `name` (`name`)
37) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
38
39#
40# TABLE STRUCTURE FOR: fuel_blog_categories
41#
42
43DROP TABLE IF EXISTS fuel_blog_categories;
44
45CREATE TABLE `fuel_blog_categories` (
46  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
47  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
48  `permalink` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'If left blank, the permalink will automatically be created for you.',
49  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
50  PRIMARY KEY (`id`),
51  UNIQUE KEY `permalink` (`permalink`),
52  UNIQUE KEY `name` (`name`)
53) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
54
55INSERT INTO fuel_blog_categories (`id`, `name`, `permalink`, `published`) VALUES (1, 'Uncategorized', 'uncategorized', 'yes');
56
57
58#
59# TABLE STRUCTURE FOR: fuel_blog_comments
60#
61
62DROP TABLE IF EXISTS fuel_blog_comments;
63
64CREATE TABLE `fuel_blog_comments` (
65  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
66  `post_id` int(10) unsigned NOT NULL,
67  `parent_id` int(10) unsigned NOT NULL,
68  `author_id` int(10) unsigned NOT NULL,
69  `author_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
70  `author_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
71  `author_website` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
72  `author_ip` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
73  `is_spam` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
74  `content` text COLLATE utf8_unicode_ci NOT NULL,
75  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
76  `date_added` datetime NOT NULL,
77  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
78  PRIMARY KEY (`id`)
79) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
80
81#
82# TABLE STRUCTURE FOR: fuel_blog_links
83#
84
85DROP TABLE IF EXISTS fuel_blog_links;
86
87CREATE TABLE `fuel_blog_links` (
88  `id` int(11) NOT NULL AUTO_INCREMENT,
89  `name` varchar(255) DEFAULT NULL,
90  `url` varchar(255) DEFAULT NULL,
91  `target` enum('blank','self','parent') DEFAULT 'blank',
92  `description` varchar(100) DEFAULT NULL,
93  `precedence` int(11) NOT NULL DEFAULT '0',
94  `published` enum('yes','no') DEFAULT 'yes',
95  PRIMARY KEY (`id`)
96) ENGINE=MyISAM DEFAULT CHARSET=utf8;
97
98#
99# TABLE STRUCTURE FOR: fuel_blog_posts
100#
101
102DROP TABLE IF EXISTS fuel_blog_posts;
103
104CREATE TABLE `fuel_blog_posts` (
105  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
106  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
107  `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.',
108  `content` text COLLATE utf8_unicode_ci NOT NULL,
109  `content_filtered` text COLLATE utf8_unicode_ci NOT NULL,
110  `formatting` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
111  `excerpt` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'A condensed version of the content',
112  `author_id` int(10) unsigned NOT NULL COMMENT 'If left blank, you will assumed be the author.',
113  `sticky` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
114  `allow_comments` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
115  `date_added` datetime DEFAULT NULL,
116  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
117  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL,
118  PRIMARY KEY (`id`),
119  UNIQUE KEY `permalink` (`permalink`)
120) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
121
122INSERT 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');
123
124
125#
126# TABLE STRUCTURE FOR: fuel_blog_posts_to_categories
127#
128
129DROP TABLE IF EXISTS fuel_blog_posts_to_categories;
130
131CREATE TABLE `fuel_blog_posts_to_categories` (
132  `post_id` int(10) unsigned NOT NULL,
133  `category_id` int(10) unsigned NOT NULL,
134  PRIMARY KEY (`post_id`,`category_id`)
135) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
136
137INSERT INTO fuel_blog_posts_to_categories (`post_id`, `category_id`) VALUES (1, 1);
138
139
140#
141# TABLE STRUCTURE FOR: fuel_blog_settings
142#
143
144DROP TABLE IF EXISTS fuel_blog_settings;
145
146CREATE TABLE `fuel_blog_settings` (
147  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
148  `value` text COLLATE utf8_unicode_ci NOT NULL,
149  PRIMARY KEY (`name`)
150) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
151
152INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('title', 'My Blog');
153INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('uri', 'blog/');
154INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('theme_layout', 'blog');
155INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('theme_path', 'themes/default/');
156INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('theme_module', 'blog');
157INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('use_cache', '0');
158INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('cache_ttl', '3600');
159INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('per_page', '2');
160INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('description', '');
161INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('use_captchas', '1');
162INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('monitor_comments', '1');
163INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('save_spam', '1');
164INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('allow_comments', '1');
165INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('akismet_api_key', '');
166INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('comments_time_limit', '');
167INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('multiple_comment_submission_time_limit', '30');
168INSERT INTO fuel_blog_settings (`name`, `value`) VALUES ('asset_upload_path', 'images/blog/');
169
170
171#
172# TABLE STRUCTURE FOR: fuel_blog_users
173#
174
175DROP TABLE IF EXISTS fuel_blog_users;
176
177CREATE TABLE `fuel_blog_users` (
178  `fuel_user_id` int(10) unsigned NOT NULL,
179  `display_name` varchar(50) NOT NULL,
180  `website` varchar(100) NOT NULL,
181  `about` text NOT NULL,
182  `avatar_image` varchar(255) NOT NULL,
183  `twitter` varchar(255) NOT NULL,
184  `facebook` varchar(255) NOT NULL,
185  `date_added` datetime DEFAULT NULL,
186  `active` enum('yes','no') NOT NULL DEFAULT 'yes',
187  PRIMARY KEY (`fuel_user_id`)
188) ENGINE=MyISAM DEFAULT CHARSET=utf8;
189
190INSERT 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');
191
192
193#
194# TABLE STRUCTURE FOR: fuel_logs
195#
196
197DROP TABLE IF EXISTS fuel_logs;
198
199CREATE TABLE `fuel_logs` (
200  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
201  `entry_date` datetime NOT NULL,
202  `user_id` int(11) NOT NULL,
203  `message` text COLLATE utf8_unicode_ci NOT NULL,
204  PRIMARY KEY (`id`)
205) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
206
207INSERT INTO fuel_logs (`id`, `entry_date`, `user_id`, `message`) VALUES (1, '2012-01-23 12:35:14', 1, 'Site cache cleared explicitly');
208INSERT INTO fuel_logs (`id`, `entry_date`, `user_id`, `message`) VALUES (2, '2012-01-23 12:36:54', 1, 'Posts item <em>Success!</em> edited');
209INSERT 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');
210
211
212#
213# TABLE STRUCTURE FOR: fuel_navigation
214#
215
216DROP TABLE IF EXISTS fuel_navigation;
217
218CREATE TABLE `fuel_navigation` (
219  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
220  `group_id` int(5) unsigned NOT NULL DEFAULT '1',
221  `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)',
222  `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',
223  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The name you want to appear in the menu',
224  `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',
225  `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',
226  `attributes` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Extra attributes that can be used for navigation implementation',
227  `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',
228  `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',
229  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes' COMMENT 'Determines whether the item is displayed or not',
230  PRIMARY KEY (`id`),
231  UNIQUE KEY `group_id` (`group_id`,`location`,`parent_id`)
232) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
233
234#
235# TABLE STRUCTURE FOR: fuel_navigation_groups
236#
237
238DROP TABLE IF EXISTS fuel_navigation_groups;
239
240CREATE TABLE `fuel_navigation_groups` (
241  `id` int(3) unsigned NOT NULL AUTO_INCREMENT,
242  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
243  `published` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
244  PRIMARY KEY (`id`)
245) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
246
247INSERT INTO fuel_navigation_groups (`id`, `name`, `published`) VALUES (1, 'main', 'yes');
248
249
250#
251# TABLE STRUCTURE FOR: fuel_page_variables
252#
253
254DROP TABLE IF EXISTS fuel_page_variables;
255
256CREATE TABLE `fuel_page_variables` (
257  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
258  `page_id` int(10) unsigned NOT NULL,
259  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
260  `scope` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
261  `value` text COLLATE utf8_unicode_ci NOT NULL,
262  `type` enum('string','int','boolean','array','template') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'string',
263  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
264  PRIMARY KEY (`id`),
265  UNIQUE KEY `page_id` (`page_id`,`name`)
266) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
267
268#
269# TABLE STRUCTURE FOR: fuel_pages
270#
271
272DROP TABLE IF EXISTS fuel_pages;
273
274CREATE TABLE `fuel_pages` (
275  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
276  `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''',
277  `layout` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The name of the template to associate with this page',
278  `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',
279  `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''',
280  `date_added` datetime DEFAULT NULL,
281  `last_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
282  `last_modified_by` int(10) unsigned NOT NULL,
283  PRIMARY KEY (`id`),
284  UNIQUE KEY `location` (`location`),
285  KEY `layout` (`layout`)
286) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
287
288#
289# TABLE STRUCTURE FOR: fuel_permissions
290#
291
292DROP TABLE IF EXISTS fuel_permissions;
293
294CREATE TABLE `fuel_permissions` (
295  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
296  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Permissions beginning with ''Manage '' will allow items to appear on the left menu',
297  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
298  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
299  PRIMARY KEY (`id`),
300  UNIQUE KEY `name` (`name`)
301) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
302
303INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (1, 'pages', 'Manage pages', 'yes');
304INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (2, 'pages_publish', 'Publish Pages', 'yes');
305INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (3, 'pages_delete', 'Delete Pages', 'yes');
306INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (4, 'navigation', 'Manage navigation', 'yes');
307INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (5, 'users', 'Manage users', 'yes');
308INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (6, 'tools/backup', 'Manage database backup', 'yes');
309INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (7, 'manage/cache', 'Manage the page cache', 'yes');
310INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (8, 'manage/activity', 'View activity logs', 'yes');
311INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (9, 'myPHPadmin', 'myPHPadmin', 'yes');
312INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (10, 'google_analytics', 'Google Analytics', 'yes');
313INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (11, 'tools/user_guide', 'Access the User Guide', 'yes');
314INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (12, 'manage', 'View the Manage Dashboard Page', 'yes');
315INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (13, 'permissions', 'Manage Permissions', 'yes');
316INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (14, 'tools', 'Manage Tools', 'yes');
317INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (15, 'tools/seo/google_keywords', 'Google Keywords', 'yes');
318INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (16, 'sitevariables', 'Site Variables', 'yes');
319INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (17, 'blog/posts', 'Blog Posts', 'yes');
320INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (18, 'blog/categories', 'Blog Categories', 'yes');
321INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (19, 'blog/comments', 'Blog Comments', 'yes');
322INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (20, 'blog/links', 'Blog Links', 'yes');
323INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (21, 'blog/users', 'Blog Authors', 'yes');
324INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (22, 'blog/settings', 'Blog Settings', 'yes');
325INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (23, 'assets', 'Assets', 'yes');
326INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (24, 'tools/validate', 'Validate', 'yes');
327INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (25, 'tools/seo', 'Page Analysis', 'yes');
328INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (26, 'tools/tester', 'Tester Module', 'yes');
329INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (27, 'blocks', 'Manage Blocks', 'yes');
330INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (28, 'site_docs', 'Site Documentation', 'yes');
331INSERT INTO fuel_permissions (`id`, `name`, `description`, `active`) VALUES (29, 'tools/cronjobs', 'Cronjobs', 'yes');
332
333
334#
335# TABLE STRUCTURE FOR: fuel_site_variables
336#
337
338DROP TABLE IF EXISTS fuel_site_variables;
339
340CREATE TABLE `fuel_site_variables` (
341  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
342  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
343  `value` text COLLATE utf8_unicode_ci NOT NULL,
344  `scope` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'leave blank if you want the variable to be available to all pages',
345  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
346  PRIMARY KEY (`id`),
347  UNIQUE KEY `name` (`name`)
348) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
349
350#
351# TABLE STRUCTURE FOR: fuel_user_to_permissions
352#
353
354DROP TABLE IF EXISTS fuel_user_to_permissions;
355
356CREATE TABLE `fuel_user_to_permissions` (
357  `user_id` int(10) unsigned NOT NULL,
358  `permission_id` int(10) unsigned NOT NULL,
359  PRIMARY KEY (`user_id`,`permission_id`)
360) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
361
362INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 1);
363INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 2);
364INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 3);
365INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 4);
366INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 5);
367INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 6);
368INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 7);
369INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 8);
370INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 9);
371INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 10);
372INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 11);
373INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 12);
374INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 13);
375INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 14);
376INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 15);
377INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 16);
378INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 17);
379INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 18);
380INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 19);
381INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 20);
382INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 21);
383INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 22);
384INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 23);
385INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 24);
386INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 25);
387INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 26);
388INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 27);
389INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 28);
390INSERT INTO fuel_user_to_permissions (`user_id`, `permission_id`) VALUES (3, 29);
391
392
393#
394# TABLE STRUCTURE FOR: fuel_users
395#
396
397DROP TABLE IF EXISTS fuel_users;
398
399CREATE TABLE `fuel_users` (
400  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
401  `user_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
402  `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
403  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
404  `first_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
405  `last_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
406  `language` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'english',
407  `reset_key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
408  `super_admin` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
409  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
410  PRIMARY KEY (`id`),
411  UNIQUE KEY `email` (`email`)
412) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
413
414INSERT 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');
415INSERT 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');