infinitas dev sql

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

DROP TABLE IF EXISTS `access_permissions`;
CREATE TABLE `access_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `foreign_id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `gid` int(11) NOT NULL,
  `perms` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `polymorphic_idx` (`model`,`foreign_id`),
  KEY `uid_idx` (`uid`),
  KEY `gid_idx` (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `api_api_classes`;
CREATE TABLE `api_api_classes` (
  `id` varchar(36) NOT NULL,
  `api_package_id` varchar(36) DEFAULT NULL,
  `name` varchar(200) NOT NULL,
  `slug` varchar(200) NOT NULL,
  `file_name` text NOT NULL,
  `method_index` text NOT NULL,
  `property_index` text NOT NULL,
  `flags` int(5) NOT NULL,
  `coverage_cache` float(4,4) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `api_package_id` (`api_package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `api_api_classes` (`id`, `api_package_id`, `name`, `slug`, `file_name`, `method_index`, `property_index`, `flags`, `coverage_cache`, `created`, `modified`) VALUES
('4b600eef-2838-4b94-8ace-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'DATABASE_CONFIG', 'd-a-t-a-b-a-s-e--c-o-n-f-i-g', 'C:\\xampp\\htdocs\\infinitas\\config\\database.php', '', 'default default', 2, 0.0000, '2010-01-27 12:01:19', '2010-01-27 12:01:19'),
('4b600ef0-69c0-42e3-888e-1ccc6318cd70', '4b600ef0-03cc-40c2-8ce7-1ccc6318cd70', 'PostsController', 'posts-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\blog\\controllers\\posts_controller.php', 'beforefilter index view admin_dashboard admin_index admin_add admin_edit admin_view admin_delete beforefilter index view admin_dashboard admin_index admin_add admin_edit admin_view admin_delete', 'name helpers name helpers', 2, 0.0000, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-9988-41ab-b084-1ccc6318cd70', '4b600ef0-0aa0-4d8d-a30a-1ccc6318cd70', 'CommentLayoutHelper', 'comment-layout-helper', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\blog\\views\\helpers\\comment_layout.php', 'setdata unsetdata showcomment addcomment countbox setdata unsetdata showcomment addcomment countbox', 'helpers addcommenturl helpers addcommenturl', 2, 0.0000, '2010-01-27 12:01:20', '2010-01-27 12:01:21'),
('4b600ef0-aec0-4c9a-8e4e-1ccc6318cd70', '4b600ef0-658c-4c38-afc9-1ccc6318cd70', 'BlogAppController', 'blog-app-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\blog\\blog_app_controller.php', 'beforefilter afterfilter beforefilter afterfilter', 'helpers helpers', 2, 0.0000, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-b320-4676-b04b-1ccc6318cd70', '4b600ef0-f438-404d-af3c-1ccc6318cd70', 'Post', 'post', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\blog\\models\\post.php', 'beforedelete getdates getlatest getcounts getpopular getpending beforedelete getdates getlatest getcounts getpopular getpending', 'name order actsas validate hasandbelongstomany hasmany belongsto name order actsas validate hasandbelongstomany hasmany belongsto', 2, 0.0000, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-be80-4eff-8b72-1ccc6318cd70', '4b600ef0-bc68-45c8-a2d0-1ccc6318cd70', 'BlogHelper', 'blog-helper', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\blog\\views\\helpers\\blog.php', 'metadata setdata unsetdata formaturl highlighttags metadata setdata unsetdata formaturl highlighttags', 'helpers dateformat layout errors data showintro helpers dateformat layout errors data showintro', 2, 0.0000, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-c464-4171-918f-1ccc6318cd70', '4b600ef0-83b8-41b0-aab7-1ccc6318cd70', 'Tag', 'tag', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\blog\\models\\tag.php', 'getcount findpostsbytag getcount findpostsbytag', 'name order validate hasandbelongstomany name order validate hasandbelongstomany', 2, 0.0000, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-eadc-4cd2-8e71-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'BlogAppModel', 'blog-app-model', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\blog\\blog_app_model.php', 'beforesave afterdelete __clearcache beforesave afterdelete __clearcache', 'tableprefix tableprefix', 2, 0.0000, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-f6b4-4ff9-ba52-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'BackupsController', 'backups-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\backup\\controllers\\backups_controller.php', 'admin_backup __checkbackups __savebackup admin_backup __checkbackups __savebackup', 'name name', 2, 0.0000, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef1-05e0-40d4-baa9-1ccc6318cd70', NULL, 'FeaturesController', 'features-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\controllers\\features_controller.php', 'index admin_index admin_add index admin_index admin_add', 'name helpers name helpers', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-0d2c-4d4c-8dea-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'Frontpage', 'frontpage', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\models\\frontpage.php', '', 'name actsas order belongsto name actsas order belongsto', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-1d68-4914-b990-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'ContentsController', 'contents-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\controllers\\contents_controller.php', 'beforefilter index view admin_index admin_view admin_add admin_edit beforefilter index view admin_index admin_view admin_add admin_edit', 'name helpers name helpers', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-2f18-442a-9834-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'Feature', 'feature', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\models\\feature.php', '', 'name order actsas belongsto name order actsas belongsto', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-3694-4205-b892-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'CategoriesController', 'categories-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\controllers\\categories_controller.php', 'index view admin_dashboard admin_index admin_view admin_add admin_edit admin_delete index view admin_dashboard admin_index admin_view admin_add admin_edit admin_delete', 'name helpers name helpers', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-3bd0-41e7-9919-1ccc6318cd70', '4b600ef1-34b0-411c-972b-1ccc6318cd70', 'Content', 'content', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\models\\content.php', '', 'name order validate actsas belongsto hasone name order validate actsas belongsto hasone', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-3e54-453d-b638-1ccc6318cd70', NULL, 'LayoutsController', 'layouts-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\controllers\\layouts_controller.php', 'admin_index admin_add admin_edit admin_index admin_add admin_edit', 'name helpers name helpers', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-8ea4-4665-a9ce-1ccc6318cd70', '4b600ef1-7874-4220-8d4e-1ccc6318cd70', 'PostLayoutHelper', 'post-layout-helper', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\blog\\views\\helpers\\post_layout.php', 'indexpoststart indexposthead indexpostcontent indexpostfooter indexpostend viewposthead viewpostbody tags pendingbox mostpopular indexpoststart indexposthead indexpostcontent indexpostfooter indexpostend viewposthead viewpostbody tags pendingbox mostpopular', 'helpers indexconfig helpers indexconfig', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-abf0-442b-b495-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'CmsAppModel', 'cms-app-model', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\cms_app_model.php', '', 'tableprefix tableprefix', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-bc90-4cd1-a3ee-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'FrontpagesController', 'frontpages-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\controllers\\frontpages_controller.php', 'index admin_index admin_add index admin_index admin_add', 'name helpers name helpers', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-c2a8-47b7-814a-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'CmsAppController', 'cms-app-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\cms_app_controller.php', 'beforefilter beforefilter', 'helpers components helpers components', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-e168-4f38-8172-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'Category', 'category', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\models\\category.php', '', 'name actsas order validate belongsto hasmany name actsas order validate belongsto hasmany', 2, 0.0000, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef2-01b4-4ebc-85df-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'InstallController', 'install-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\installer\\controllers\\install_controller.php', 'beforefilter index licence __testconnection database install siteconfig done __executesqlscript beforefilter index licence __testconnection database install siteconfig done __executesqlscript', 'name uses components phpversion sqlversion name uses components phpversion sqlversion', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-09c0-44ab-bc6d-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'ManagementAppController', 'management-app-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\management_app_controller.php', '', 'helpers components helpers components', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-19d0-4b9a-97c2-1ccc6318cd70', NULL, 'FileManagerController', 'file-manager-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\filemanager\\controllers\\file_manager_controller.php', 'admin_index admin_view admin_download admin_delete admin_index admin_view admin_download admin_delete', 'name uses helpers name uses helpers', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-24b4-4437-8665-1ccc6318cd70', NULL, 'Folders', 'folders', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\filemanager\\models\\folders.php', 'beforefind find chmod __read __advancedfolderfind __filestatus __simplefolderfind __relativepath __order beforefind find chmod __read __advancedfolderfind __filestatus __simplefolderfind __relativepath __order', 'name usetable hasmany ignore name usetable hasmany ignore', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-6e8c-4d51-acb3-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'CmsHelper', 'cms-helper', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\views\\helpers\\cms.php', 'homepageitem homepageitem', 'helpers helpers', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-770c-4448-bc23-1ccc6318cd70', NULL, 'Layout', 'layout', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\cms\\models\\layout.php', '', 'name usetable hasmany belongsto name usetable hasmany belongsto', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-9f94-4f3a-af6d-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'Install', 'install', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\installer\\models\\install.php', '', 'name usetable name usetable', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-a080-46fc-93d3-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'InstallerAppModel', 'installer-app-model', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\installer\\installer_app_model.php', '', '', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-a6b0-4f74-91c5-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'ConfigsController', 'configs-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\controllers\\configs_controller.php', 'beforefilter admin_index admin_add admin_edit beforefilter admin_index admin_add admin_edit', 'name helpers configoptions name helpers configoptions', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-abd4-43f8-b2c3-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'ManagementAppModel', 'management-app-model', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\management_app_model.php', '', '', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-b0e0-442c-8035-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'InstallerAppController', 'installer-app-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\installer\\installer_app_controller.php', '', '', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-bbf4-4e47-8ce5-1ccc6318cd70', '4b600ef2-f79c-4047-985e-1ccc6318cd70', 'Comment', 'comment', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\comment\\models\\comment.php', 'getcounts aftersave afterdelete __clearcache getcounts aftersave afterdelete __clearcache', 'name tableprefix validate name tableprefix validate', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-f76c-4beb-b117-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'CommentsController', 'comments-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\comment\\controllers\\comments_controller.php', 'admin_index admin_perge admin_commentpurge admin_index admin_perge admin_commentpurge', 'name helpers name helpers', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef2-f968-4719-b563-1ccc6318cd70', NULL, 'Files', 'files', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\filemanager\\models\\files.php', 'beforefind find chmod __read __advancedfilefind __filestatus __simplefilefind __relativepath __order beforefind find chmod __read __advancedfilefind __filestatus __simplefilefind __relativepath __order', 'name usetable belongsto ignore name usetable belongsto ignore', 2, 0.0000, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef3-06bc-4754-801b-1ccc6318cd70', NULL, 'ModulePosition', 'module-position', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\models\\module_position.php', '', 'name tableprefix name tableprefix', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-0a94-497b-b854-1ccc6318cd70', NULL, 'ModulesController', 'modules-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\controllers\\modules_controller.php', 'beforefilter admin_index admin_add admin_edit beforefilter admin_index admin_add admin_edit', 'name name', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-0b00-4bfa-b32e-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'Theme', 'theme', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\models\\theme.php', 'getcurrnettheme aftersave afterdelete __clearcache getcurrnettheme aftersave afterdelete __clearcache', 'name tableprefix hasmay name tableprefix hasmay', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-3a6c-44f0-b6eb-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'CoreHelper', 'core-helper', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\views\\helpers\\core.php', '', 'helpers helpers', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-77a8-47b7-9b69-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'ManagementController', 'management-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\controllers\\management_controller.php', 'admin_dashboard admin_dashboard', 'name uses name uses', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-78a8-4242-823f-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'ThemesController', 'themes-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\controllers\\themes_controller.php', 'beforefilter admin_index admin_add admin_edit beforefilter admin_index admin_add admin_edit', 'name name', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-80c8-4f03-9c41-1ccc6318cd70', '4b600ef3-99c0-4949-89ff-1ccc6318cd70', 'NewsletterAppController', 'newsletter-app-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\newsletter_app_controller.php', 'beforefilter beforerender afterfilter beforefilter beforerender afterfilter', 'helpers components helpers components', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-8674-4037-84ab-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'RoutesController', 'routes-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\controllers\\routes_controller.php', 'beforefilter admin_index admin_add admin_edit beforefilter admin_index admin_add admin_edit', 'name listthemes name listthemes', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-881c-455b-9ad9-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'Config', 'config', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\models\\config.php', 'getconfig beforefind aftersave afterdelete __clearcache getconfig beforefind aftersave afterdelete __clearcache', 'name tableprefix order configuration name tableprefix order configuration', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-cd38-4510-b1f2-1ccc6318cd70', NULL, 'Group', 'group', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\models\\group.php', '', 'tableprefix actsas tableprefix actsas', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-d0ac-4a24-be56-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'Route', 'route', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\models\\route.php', 'getplugins getroutes _getvalues _getregex _gettype aftersave afterdelete __clearcache getplugins getroutes _getvalues _getregex _gettype aftersave afterdelete __clearcache', 'name tableprefix blockedplugins actsas order belongsto name tableprefix blockedplugins actsas order belongsto', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-d930-4706-bd1e-1ccc6318cd70', NULL, 'Log', 'log', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\models\\log.php', '', 'tableprefix name order tableprefix name order', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-edcc-4f49-bad6-1ccc6318cd70', NULL, 'Module', 'module', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\models\\module.php', 'getmodules getmodules', 'name tableprefix actsas order belongsto hasandbelongstomany name tableprefix actsas order belongsto hasandbelongstomany', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-f85c-45d3-b563-1ccc6318cd70', NULL, 'User', 'user', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\management\\models\\user.php', '', 'name tableprefix name tableprefix', 2, 0.0000, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef4-2634-4c07-852c-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'NewsletterLayoutHelper', 'newsletter-layout-helper', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\views\\helpers\\newsletter_layout.php', '', '', 2, 0.0000, '2010-01-27 12:01:24', '2010-01-27 12:01:24'),
('4b600ef4-3e84-446e-a4db-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'NewslettersController', 'newsletters-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\controllers\\newsletters_controller.php', 'beforefilter track sendnewsletters admin_dashboard admin_report admin_index admin_add admin_edit admin_view admin_preview admin_delte admin_mass __candelete admin_togglesend admin_stopall beforefilter track sendnewsletters admin_dashboard admin_report admin_index admin_add admin_edit admin_view admin_preview admin_delte admin_mass __candelete admin_togglesend admin_stopall', 'name helpers name helpers', 2, 0.0000, '2010-01-27 12:01:24', '2010-01-27 12:01:24'),
('4b600ef4-407c-401a-bb08-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'Campaign', 'campaign', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\models\\campaign.php', '', 'name order hasmany belongsto name order hasmany belongsto', 2, 0.0000, '2010-01-27 12:01:24', '2010-01-27 12:01:24'),
('4b600ef4-4984-4ae4-97b7-1ccc6318cd70', '4b600ef0-21e0-4bf9-a618-1ccc6318cd70', 'Newsletter', 'newsletter', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\models\\newsletter.php', '', 'name order displayfield validate hasandbelongstomany belongsto name order displayfield validate hasandbelongstomany belongsto', 2, 0.0000, '2010-01-27 12:01:24', '2010-01-27 12:01:24'),
('4b600ef4-684c-4796-8aa2-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'TemplatesController', 'templates-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\controllers\\templates_controller.php', 'beforefilter admin_index admin_add admin_edit admin_view admin_export admin_preview admin_delete admin_mass __candelete beforefilter admin_index admin_add admin_edit admin_view admin_export admin_preview admin_delete admin_mass __candelete', 'name version helpers sampletext name version helpers sampletext', 2, 0.0000, '2010-01-27 12:01:24', '2010-01-27 12:01:24'),
('4b600ef4-7420-4ca5-8295-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'NewsletterAppModel', 'newsletter-app-model', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\newsletter_app_model.php', 'beforesave afterdelete __clearcache beforesave afterdelete __clearcache', 'tableprefix tableprefix', 2, 0.0000, '2010-01-27 12:01:24', '2010-01-27 12:01:24'),
('4b600ef4-8dc0-488a-b242-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'CampaignsController', 'campaigns-controller', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\controllers\\campaigns_controller.php', 'admin_index admin_add admin_edit admin_toggle admin_delete admin_mass __candelete admin_index admin_add admin_edit admin_toggle admin_delete admin_mass __candelete', 'name helpers name helpers', 2, 0.0000, '2010-01-27 12:01:24', '2010-01-27 12:01:24'),
('4b600ef4-9d04-4be3-bb45-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'LetterHelper', 'letter-helper', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\views\\helpers\\letter.php', 'toggle preview toggle preview', 'helpers allowedpreviews errors helpers allowedpreviews errors', 2, 0.0000, '2010-01-27 12:01:24', '2010-01-27 12:01:24'),
('4b600ef4-bd40-4c1f-911b-1ccc6318cd70', '4b600eef-c318-43fd-8773-1ccc6318cd70', 'Template', 'template', 'C:\\xampp\\htdocs\\infinitas\\infinitas\\newsletter\\models\\template.php', '', 'name order validation hasmany belongsto name order validation hasmany belongsto', 2, 0.0000, '2010-01-27 12:01:24', '2010-01-27 12:01:24');

DROP TABLE IF EXISTS `api_api_packages`;
CREATE TABLE `api_api_packages` (
  `id` varchar(36) NOT NULL,
  `parent_id` varchar(36) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `lft` int(11) NOT NULL,
  `rght` int(11) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `api_api_packages` (`id`, `parent_id`, `name`, `slug`, `lft`, `rght`, `created`, `modified`) VALUES
('4b600eef-78b4-4a3f-8898-1ccc6318cd70', NULL, 'sort', 'sort', 1, 4, '2010-01-27 12:01:19', '2010-01-27 12:01:19'),
('4b600eef-c318-43fd-8773-1ccc6318cd70', '4b600eef-78b4-4a3f-8898-1ccc6318cd70', 'comments', 'comments', 2, 3, '2010-01-27 12:01:19', '2010-01-27 12:01:19'),
('4b600ef0-03cc-40c2-8ce7-1ccc6318cd70', '4b600ef0-898c-420c-970e-1ccc6318cd70', 'posts', 'posts', 9, 10, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-0aa0-4d8d-a30a-1ccc6318cd70', '4b600ef0-bc68-45c8-a2d0-1ccc6318cd70', 'commentLayout', 'comment-layout', 26, 27, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-18d8-45b4-a13f-1ccc6318cd70', NULL, 'blog', 'blog', 5, 32, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-21e0-4bf9-a618-1ccc6318cd70', '4b600ef0-18d8-45b4-a13f-1ccc6318cd70', 'models', 'models', 14, 23, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-6130-415b-a34b-1ccc6318cd70', '4b600ef0-18d8-45b4-a13f-1ccc6318cd70', 'views', 'views', 24, 31, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-658c-4c38-afc9-1ccc6318cd70', '4b600ef0-898c-420c-970e-1ccc6318cd70', 'blogAppController', 'blog-app-controller', 7, 8, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-83b8-41b0-aab7-1ccc6318cd70', '4b600ef0-21e0-4bf9-a618-1ccc6318cd70', 'tag', 'tag', 17, 18, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-898c-420c-970e-1ccc6318cd70', '4b600ef0-18d8-45b4-a13f-1ccc6318cd70', 'controllers', 'controllers', 6, 13, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-bc68-45c8-a2d0-1ccc6318cd70', '4b600ef0-6130-415b-a34b-1ccc6318cd70', 'helpers', 'helpers', 25, 30, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef0-f438-404d-af3c-1ccc6318cd70', '4b600ef0-21e0-4bf9-a618-1ccc6318cd70', 'post', 'post', 15, 16, '2010-01-27 12:01:20', '2010-01-27 12:01:20'),
('4b600ef1-34b0-411c-972b-1ccc6318cd70', '4b600ef0-21e0-4bf9-a618-1ccc6318cd70', 'content', 'content', 19, 20, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-60a0-4894-b73b-1ccc6318cd70', NULL, 'cms', 'cms', 33, 34, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef1-7874-4220-8d4e-1ccc6318cd70', '4b600ef0-bc68-45c8-a2d0-1ccc6318cd70', 'postLayout', 'post-layout', 28, 29, '2010-01-27 12:01:21', '2010-01-27 12:01:21'),
('4b600ef2-f79c-4047-985e-1ccc6318cd70', '4b600ef0-21e0-4bf9-a618-1ccc6318cd70', 'comment', 'comment', 21, 22, '2010-01-27 12:01:22', '2010-01-27 12:01:22'),
('4b600ef3-99c0-4949-89ff-1ccc6318cd70', '4b600ef0-898c-420c-970e-1ccc6318cd70', 'newsletterAppController', 'newsletter-app-controller', 11, 12, '2010-01-27 12:01:23', '2010-01-27 12:01:23'),
('4b600ef3-d180-490b-bb3b-1ccc6318cd70', NULL, 'newsletter', 'newsletter', 35, 36, '2010-01-27 12:01:23', '2010-01-27 12:01:23');

DROP TABLE IF EXISTS `blog_categories`;
CREATE TABLE `blog_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `group_id` int(11) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modeified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

INSERT INTO `blog_categories` (`id`, `name`, `slug`, `description`, `active`, `group_id`, `created`, `modeified`) VALUES
(1, 'Test', 'test', '<p>\r\n	This is a test category test</p>\r\n', 1, 0, NULL, NULL),
(4, 'Uncategorised', '', '<p>This is the place to put posts when they dont really fit anywere else.</p>', 1, 0, '2010-02-10 22:59:50', NULL);

DROP TABLE IF EXISTS `blog_posts`;
CREATE TABLE `blog_posts` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `slug` varchar(100) NOT NULL,
  `intro` text NOT NULL,
  `body` text,
  `comment_count` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL DEFAULT '0',
  `rating` float NOT NULL DEFAULT '0',
  `rating_count` int(11) NOT NULL DEFAULT '0',
  `category_id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `locked_by` int(11) DEFAULT NULL,
  `locked_since` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

INSERT INTO `blog_posts` (`id`, `title`, `slug`, `intro`, `body`, `comment_count`, `active`, `views`, `rating`, `rating_count`, `category_id`, `parent_id`, `ordering`, `locked`, `locked_by`, `locked_since`, `created`, `modified`) VALUES
(2, 'Infinitas Cms is live', 'infinitas-cms-is-live', '<p>Welcome to our new home</p>', '<p>Everything is up and running, so feel free to browse the site, just try not to break it.&nbsp; If you want to have a look at the admin section click <a href="http://infinitas-cms.org/admin">here</a></p>', 0, 1, 6, 0, 0, 1, NULL, 0, 0, NULL, NULL, '2010-01-20 17:48:26', '2010-01-21 20:41:18'),
(4, 'Infinitas is now at v0.6 alpha', 'infinitas-is-now-at-v0-6-alpha', '<p>With a lot of hard work and over 150 commits Infinitas has reached v0.6 alpha&nbsp;&nbsp;&nbsp;&nbsp;</p>', '<p>0.6 has bought us some neat new functionality and a lot more stable code. Most notably is the addition of the <a href="http://cakedc.com/eng/downloads/view/cakephp_migrations_plugin">CakePHP migrations plug-in</a> that is used for the installer, along with helping keep track of the database additions made during development.</p>\r\n<p>Some of the other functionality made available is the use of modules to insert small bits of code in the site. This can be anything from things like <a href="https://www.google.com/analytics">Google analytics</a> code to popular posts. Those familiar with CakePHP will see modules are just elements, but are managed from the backend allowing you to toggle them and move them around your site with ease.</p>\r\n<p>Another thing Infinitas 0.6alpha brings is menu management. The menus are loaded by the module loader and allows you to create any number of menus for your site.  Creating a new menu is as simple as creating the menu in the menu manager and then adding menu items to it. Once that is done just create a new module in the position of your choice and save.</p>\r\n<p>Our focus now is getting 0.7alpha out the door, this will be mostly focused around authentication and access control. The plans are for a full row based access control system which will include building more code into the existing code base allowing administrators to manage everything from the backend. Current plan is to go with <a href="http://jmcneese.wordpress.com/2010/01/28/rmac-is-dead-long-live-rmac/">jmcneese</a>''s implementation. </p>\r\n<p>Things like setting moderators for comments, and editors for content will become available. This will become a very fine grained system allowing administrators to set the roles based on categories and tags. For example you could set up Bob as the editor for all content in Category-A, and let Sam handle Category-B. Leaving the &quot;Super Admin''s&quot; with full access to everything in the site.</p>\r\n<p>The other main focus of 0.7alpha will be getting the code that is in the repo more stable, and hopefully a lot more work on the themes in the theme repo. Mostly updating them to use the module loader and setting up some more examples so you can see how routes, modules and themes all work together.</p>\r\n<p>Should there be some free time available, some more content pages will be created focusing on using Infinitas and how to set up your site, so check back soon.</p>\r\n<p>&nbsp;</p>', 0, 1, 9, 0, 0, 0, NULL, 0, 1, 1, '2010-02-09 15:40:28', '2010-02-01 18:01:36', '2010-02-09 15:40:28'),
(5, 'Testing multi page posts', 'testing-multi-page-posts', '<p>this is the main page of the multi page post&nbsp;&nbsp;&nbsp;&nbsp;</p>', '<p>this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post    this is the main page of the multi page post</p>', 0, 0, 44, 4, 4, 1, NULL, 0, 0, NULL, NULL, '2010-02-10 14:19:32', '2010-02-10 14:38:42'),
(6, 'Page 2 of the multipage post', 'page-2-of-the-multipage-post', '<p>Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post</p>', '<p>Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post  Page 2 of the multipage post</p>', 0, 1, 17, 0, 0, 1, 5, 0, 0, NULL, NULL, '2010-02-10 14:21:06', '2010-02-10 14:21:06');

DROP TABLE IF EXISTS `blog_posts_tags`;
CREATE TABLE `blog_posts_tags` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=57 ;

INSERT INTO `blog_posts_tags` (`id`, `post_id`, `tag_id`) VALUES
(32, 2, 3),
(33, 2, 4),
(51, 4, 3),
(52, 4, 4),
(53, 4, 6),
(54, 5, 7),
(55, 6, 7);

DROP TABLE IF EXISTS `blog_tags`;
CREATE TABLE `blog_tags` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

INSERT INTO `blog_tags` (`id`, `name`, `created`, `modified`) VALUES
(3, 'Infinitas', '2010-01-20 17:48:26', '2010-01-20 17:48:26'),
(4, 'News', '2010-01-20 17:48:26', '2010-01-20 17:48:26'),
(6, 'Release', '2010-02-01 18:04:20', '2010-02-01 18:04:20'),
(7, 'Testing', '2010-02-10 14:12:13', '2010-02-10 14:12:13');

DROP TABLE IF EXISTS `cms_categories`;
CREATE TABLE `cms_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `locked_since` datetime DEFAULT NULL,
  `locked_by` int(11) DEFAULT NULL,
  `group_id` int(3) NOT NULL DEFAULT '0',
  `content_count` int(11) NOT NULL DEFAULT '0',
  `parent_id` int(11) NOT NULL,
  `lft` int(11) NOT NULL,
  `rght` int(11) NOT NULL,
  `views` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `created_by` datetime NOT NULL,
  `modified_by` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cat_idx` (`active`,`group_id`),
  KEY `idx_access` (`group_id`),
  KEY `idx_checkout` (`locked`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

INSERT INTO `cms_categories` (`id`, `title`, `slug`, `description`, `active`, `locked`, `locked_since`, `locked_by`, `group_id`, `content_count`, `parent_id`, `lft`, `rght`, `views`, `created`, `modified`, `created_by`, `modified_by`) VALUES
(5, 'Infinitas Pages', 'infinitas-pages', '<p>This category contains some information about infinitus, and what you can do when you have infinitus running your website.</p>', 1, 0, NULL, NULL, 1, 4, 0, 1, 6, 0, '2010-01-18 02:47:12', '2010-02-11 23:12:26', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 'test', 'test', '<p>\r\n	test</p>', 0, 0, NULL, NULL, 1, 0, 5, 4, 5, 0, '2010-02-25 12:13:39', '2010-02-25 12:13:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

DROP TABLE IF EXISTS `cms_category_configs`;
CREATE TABLE `cms_category_configs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `main_articles` int(11) NOT NULL DEFAULT '0',
  `columns` int(11) NOT NULL,
  `limit` int(11) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `cms_contents`;
CREATE TABLE `cms_contents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `introduction` text NOT NULL,
  `body` text NOT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `locked_since` datetime DEFAULT NULL,
  `locked_by` int(11) DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `group_id` int(11) NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `start` datetime DEFAULT NULL,
  `end` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `layout_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_access` (`group_id`),
  KEY `idx_checkout` (`locked`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

INSERT INTO `cms_contents` (`id`, `title`, `slug`, `introduction`, `body`, `locked`, `locked_since`, `locked_by`, `ordering`, `group_id`, `views`, `active`, `start`, `end`, `created`, `modified`, `layout_id`, `created_by`, `modified_by`, `category_id`) VALUES
(3, 'What is infinitas', 'what-is-infinitas', '<p>Infinitas is the cumulation of all the great web application rolled into one easy to manage system. All the features that you would expect from top class web based content management systems, with a powerfull e-commerce platform are at your disposal.&nbsp; Infinitas has been designed to be easy enough to use as a small personal blog site, but also powerful enough to be used as corporate level intranet or e-commerce platform.</p>', '<p>Over and above the core of infinitus is an easy to use api so anything that is not included in the core can be added through easy to develop plugins.&nbsp; With infinitas being built using the ever popular CakePHP&nbsp;framework there is countless plugins already developed that can be integrated with little or no modification.</p>\r\n<p>The core of infinitas has been developed using the MVC standard of object orintated design.&nbsp; If you are an amature php deveeloper or a veteran you will find Infinitas easy to follow and even easier to expand on.&nbsp;</p>\r\n<p>Now that you have Infinitas running your web site, you will have time to run your business.</p>', 0, NULL, NULL, 1, 0, 8, 1, NULL, NULL, '2010-01-18 03:37:17', '2010-02-11 12:13:55', 1, 0, 0, 5),
(4, 'Extending Infinitas', 'extending-infinitas', '<p>Its never been easier to extend a web system. With the power of CakePHP''s helpers, components, behaviors, elements and plugins you can have new functionality up and running on your site in no time.&nbsp;&nbsp;&nbsp;&nbsp;</p>', '<p>With infinitas built using the CakePHP&nbsp;framework with the MVC design pattern, adding functionality to your site could not be easier. Even if you are developing a plugin from scratch you have the Infinitas API&nbsp;at your disposal allowing you to create admin pages with copy / delete functionality with out even one line of code for example. Other functionalty like locking records, deleting traking creators, editors and dates content was last updated is all handled for you.</p>\r\n<p>Full logging of create and update actions is done automaticaly and there is also full revisions of all models available.&nbsp; For more information see the development guide.</p>\r\n<p>Future versions of Infinitas have a full plugin installer planed meaning you will not even need to use your ftp program to add plugins. The installer will work in two ways, the first being a normal installer like the one found in other popular cms''s, and the second is a online installer that will display a list of trusted plugins that you can just select from.</p>', 0, NULL, NULL, 3, 0, 4, 1, NULL, NULL, '2010-01-18 04:05:26', '2010-02-11 12:15:13', 1, 0, 0, 5),
(5, 'Contributing to Infinitas', 'contributing-to-infinitas', '<p>Contributing to Infinitus is important as there is only so many hours in the day to get code into the repo. All help is welcome by the core developers and is greatly appreciated.</p>', '<p>Open source software is all about the community around the application, and Infinitas is no different. With out users and developers contributing Infinitas would not get anywere. To help make it as easy as possible, we have the code hosted on <a target="_blank" href="http://github.com/infinitas">git</a> and the issues are being tracked on <a href="http://infinitas.lighthouseapp.com/dashboard">lighthouse</a>.&nbsp; There is a lot of information for developers that are interested in helping with Infinitas on lighthouse.</p>\r\n<p>We have a channel on irc where you can come and chat to us about issues you are having, or if you need some help integrating code / developing an application with Infinitas. We will be more than happy to help you were we can.</p>\r\n<p>If you find an issues and would like to fix it all you need to do is have a look at the details on <a target="_blank" href="http://infinitas.lighthouseapp.com/contributor-guidelines">lighthouse</a>.&nbsp; Once you have submitted a patch or pushed your code fixes, dont forget to send us a pull request or let us know in the irc channel that there is code we need to pull.</p>\r\n<p>&nbsp;</p>', 0, NULL, NULL, 2, 0, 1, 1, NULL, NULL, '2010-01-18 04:17:50', '2010-02-11 12:15:00', 1, 0, 0, 5);

DROP TABLE IF EXISTS `cms_content_configs`;
CREATE TABLE `cms_content_configs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content_id` int(11) NOT NULL,
  `author_alias` varchar(50) DEFAULT NULL,
  `keywords` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

INSERT INTO `cms_content_configs` (`id`, `content_id`, `author_alias`, `keywords`, `description`) VALUES
(1, 1, '', '', ''),
(2, 2, 'bob', '', ''),
(5, 3, '', 'infinitas,core,cms', 'Infinitas is a powerful content management system'),
(6, 4, '', '', ''),
(7, 5, '', '', ''),
(8, 6, '', '', '');

DROP TABLE IF EXISTS `cms_content_frontpages`;
CREATE TABLE `cms_content_frontpages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `content_id` int(11) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `order_id` int(11) NOT NULL DEFAULT '1',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

INSERT INTO `cms_content_frontpages` (`id`, `content_id`, `ordering`, `order_id`, `created`, `modified`, `created_by`, `modified_by`) VALUES
(2, 2, 1, 1, '2010-01-04 22:46:15', '2010-01-04 22:46:15', 0, 0);

DROP TABLE IF EXISTS `cms_content_layouts`;
CREATE TABLE `cms_content_layouts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `css` text NOT NULL,
  `html` text NOT NULL,
  `php` text NOT NULL,
  `locked` int(4) NOT NULL,
  `locked_by` int(11) DEFAULT NULL,
  `locked_since` datetime DEFAULT NULL,
  `content_count` int(11) NOT NULL,
  `active` int(4) NOT NULL DEFAULT '1',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

INSERT INTO `cms_content_layouts` (`id`, `content_id`, `name`, `css`, `html`, `php`, `locked`, `locked_by`, `locked_since`, `content_count`, `active`, `created`, `modified`) VALUES
(1, 1, 'default', '	.cms-content big{\r\n		font-size:120%;\r\n	}\r\n	.cms-content ol,\r\n	.cms-content ul {\r\n		list-style:lower-greek outside none;\r\n	}\r\n\r\n	.cms-content .heading{\r\n		margin-bottom:20px;\r\n	}\r\n\r\n	.cms-content .heading h2{\r\n		font-size:130%;\r\n		color:#1E379C;\r\n		padding-bottom:5px;\r\n	}\r\n\r\n	.cms-content .stats{\r\n		border-top:1px dotted #E4E4E4;\r\n	}\r\n\r\n	.cms-content .stats div{\r\n		float:left;\r\n		padding-right:20px;\r\n		font-size:80%;\r\n		padding-top:3px;\r\n	}\r\n\r\n	.cms-content .introduction{\r\n		font-style: italic;\r\n		color: #8F8F8F;\r\n	}\r\n\r\n	.cms-content p{\r\n		margin-bottom:10px;\r\n	}\r\n\r\n	.cms-content .body{\r\n		color:#535D6F;\r\n		line-height:110%;\r\n	}\r\n		.cms-content .body .stats div{\r\n			float:right;\r\n		}', '<div class="cms-content">\r\n<div class="heading">\r\n<h2>{{Content.title}}</h2>\r\n<div class="stats">\r\n<div class="views">||Viewed|| [[Content.views]] ||times||</div>\r\n</div>\r\n</div>\r\n<div class="introduction quote"><blockquote> 			<span class="bqstart">&ldquo;</span> 			[[Content.introduction]] 			<span class="bqend">&rdquo;</span> 		</blockquote></div>\r\n<div class="body">[[Content.body]]\r\n<div class="stats">\r\n<div class="modified">||Last updated||: [[Content.modified]]</div>\r\n</div>\r\n</div>\r\n</div>', '', 0, NULL, NULL, 4, 1, '2010-01-15 00:46:16', '2010-01-18 02:38:34'),
(2, 2, 'no introduction', '	.quote blockquote{\r\n		line-height:180%;\r\n		margin:45px;\r\n		font-size:130%;\r\n		background-color:#EEEEEE;\r\n	}\r\n	.quote .bqstart,\r\n	.quote .bqend{\r\n		font-family:''Lucida Grande'',Verdana,helvetica,sans-serif;\r\n		font-size:700%;\r\n		font-style:normal;\r\n		color:#FF0000;\r\n	}\r\n	.quote .bqstart{\r\n		padding-top:45px;\r\n		float:left;\r\n		height:45px;\r\n		margin-bottom:-50px;\r\n		margin-top:-20px;\r\n	}\r\n	.quote .bqend{\r\n		padding-top:5px;\r\n		float:right;\r\n		height:25px;\r\n		margin-top:0;\r\n	}\r\n\r\n	.cms-content big{\r\n		font-size:120%;\r\n	}\r\n	.cms-content ol,\r\n	.cms-content ul {\r\n		list-style:lower-greek outside none;\r\n	}\r\n\r\n	.cms-content .heading{\r\n		margin-bottom:20px;\r\n	}\r\n\r\n	.cms-content .heading h2{\r\n		font-size:130%;\r\n		color:#1E379C;\r\n		padding-bottom:5px;\r\n	}\r\n\r\n	.cms-content .stats{\r\n		border-top:1px dotted #E4E4E4;\r\n	}\r\n\r\n	.cms-content .stats div{\r\n		float:left;\r\n		padding-right:20px;\r\n		font-size:80%;\r\n		padding-top:3px;\r\n	}\r\n\r\n	.cms-content .introduction{\r\n		font-style: italic;\r\n		color: #8F8F8F;\r\n	}\r\n\r\n	.cms-content p{\r\n		margin-bottom:10px;\r\n	}\r\n\r\n	.cms-content .body{\r\n		color:#535D6F;\r\n		line-height:110%;\r\n	}\r\n		.cms-content .body .stats div{\r\n			float:right;\r\n		}', '<div class="cms-content">\r\n<div class="heading">\r\n<h2>{{Content.title}}</h2>\r\n<div class="stats">\r\n<div class="views">||Viewed|| [[Content.views]] ||times||</div>\r\n</div>\r\n</div>\r\n<div class="body">[[Content.body]]\r\n<div class="stats">\r\n<div class="modified">||Last updated||: [[Content.modified]]</div>\r\n</div>\r\n</div>\r\n</div>', '', 0, NULL, NULL, 1, 1, '2010-01-15 01:44:10', '2010-01-15 01:45:33');

DROP TABLE IF EXISTS `cms_features`;
CREATE TABLE `cms_features` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `content_id` int(11) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `order_id` int(11) NOT NULL DEFAULT '1',
  `created` datetime DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `cms_features` (`id`, `content_id`, `ordering`, `order_id`, `created`, `created_by`) VALUES
(1, 1, 1, 1, '2010-01-04 21:49:03', 0);

DROP TABLE IF EXISTS `cms_frontpages`;
CREATE TABLE `cms_frontpages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `content_id` int(11) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `order_id` int(11) NOT NULL DEFAULT '1',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

INSERT INTO `cms_frontpages` (`id`, `content_id`, `ordering`, `order_id`, `created`, `modified`, `created_by`, `modified_by`) VALUES
(3, 3, 2, 1, '2010-01-18 03:49:33', '2010-01-18 03:49:33', 0, 0),
(5, 5, 3, 1, '2010-01-18 09:58:10', '2010-02-25 12:15:19', 0, 0),
(6, 4, 0, 1, '2010-02-25 12:15:11', '2010-02-25 12:15:11', 0, 0);

DROP TABLE IF EXISTS `contact_branches`;
CREATE TABLE `contact_branches` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `map` varchar(255) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `address_id` int(11) NOT NULL DEFAULT '0',
  `user_count` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL,
  `time_zone_id` int(11) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `contact_branches` (`id`, `name`, `slug`, `map`, `image`, `email`, `phone`, `fax`, `address_id`, `user_count`, `active`, `ordering`, `time_zone_id`, `created`, `modified`) VALUES
(3, 'Head Office', 'head-office', 'http://osm.org/go/k07zlcCm', 'admin_login.png', 'something@here.com', '3216549875', '', 1, 0, 1, 1, 0, '2010-02-18 08:07:27', '2010-02-18 18:52:16');

DROP TABLE IF EXISTS `contact_contacts`;
CREATE TABLE `contact_contacts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `position` varchar(100) DEFAULT NULL,
  `phone` varchar(20) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `skype` varchar(50) DEFAULT NULL,
  `branch_id` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `configs` text NOT NULL,
  `active` tinyint(1) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

INSERT INTO `contact_contacts` (`id`, `user_id`, `image`, `first_name`, `last_name`, `slug`, `position`, `phone`, `mobile`, `email`, `skype`, `branch_id`, `ordering`, `configs`, `active`, `created`, `modified`) VALUES
(1, 0, 'installer_home.png', 'bob', 'smith', '', 'boss', '3216549875', '', '', 'bobSmith', 3, 1, '', 1, '2010-02-18 08:21:41', '2010-02-18 08:21:41'),
(2, 0, 'installer_home-0.png', 'asdf', 'asdf', '', 'asdf', '3216549875', '', '', 'sdf', 3, 2, '', 1, '2010-02-18 08:24:13', '2010-02-18 08:24:13');

DROP TABLE IF EXISTS `core_acos`;
CREATE TABLE `core_acos` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `foreign_key` int(10) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mptt_alias` (`alias`,`lft`,`rght`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=572 ;

INSERT INTO `core_acos` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
(1, NULL, NULL, NULL, 'controllers', 1, 1142),
(2, 1, NULL, NULL, 'Pages', 2, 37),
(3, 2, NULL, NULL, 'display', 3, 4),
(4, 2, NULL, NULL, 'comment', 5, 6),
(5, 2, NULL, NULL, 'rate', 7, 8),
(6, 2, NULL, NULL, 'admin_reorder', 9, 10),
(7, 2, NULL, NULL, 'admin_delete', 11, 12),
(8, 2, NULL, NULL, 'admin_commentPurge', 13, 14),
(9, 2, NULL, NULL, 'admin_mass', 15, 16),
(10, 2, NULL, NULL, 'admin_buildAcl', 17, 18),
(11, 2, NULL, NULL, 'add', 19, 20),
(12, 2, NULL, NULL, 'edit', 21, 22),
(13, 2, NULL, NULL, 'index', 23, 24),
(14, 2, NULL, NULL, 'view', 25, 26),
(15, 2, NULL, NULL, 'delete', 27, 28),
(16, 1, NULL, NULL, 'Blog', 38, 143),
(17, 16, NULL, NULL, 'Categories', 39, 72),
(18, 17, NULL, NULL, 'index', 40, 41),
(19, 17, NULL, NULL, 'admin_index', 42, 43),
(20, 17, NULL, NULL, 'admin_add', 44, 45),
(21, 17, NULL, NULL, 'admin_edit', 46, 47),
(22, 17, NULL, NULL, 'comment', 48, 49),
(23, 17, NULL, NULL, 'rate', 50, 51),
(24, 17, NULL, NULL, 'admin_reorder', 52, 53),
(25, 17, NULL, NULL, 'admin_delete', 54, 55),
(26, 17, NULL, NULL, 'admin_commentPurge', 56, 57),
(27, 17, NULL, NULL, 'admin_mass', 58, 59),
(28, 17, NULL, NULL, 'admin_buildAcl', 60, 61),
(29, 17, NULL, NULL, 'add', 62, 63),
(30, 17, NULL, NULL, 'edit', 64, 65),
(31, 17, NULL, NULL, 'view', 66, 67),
(32, 17, NULL, NULL, 'delete', 68, 69),
(33, 16, NULL, NULL, 'Posts', 73, 110),
(34, 33, NULL, NULL, 'index', 74, 75),
(35, 33, NULL, NULL, 'view', 76, 77),
(36, 33, NULL, NULL, 'admin_dashboard', 78, 79),
(37, 33, NULL, NULL, 'admin_index', 80, 81),
(38, 33, NULL, NULL, 'admin_add', 82, 83),
(39, 33, NULL, NULL, 'admin_edit', 84, 85),
(40, 33, NULL, NULL, 'admin_view', 86, 87),
(41, 33, NULL, NULL, 'admin_delete', 88, 89),
(42, 33, NULL, NULL, 'comment', 90, 91),
(43, 33, NULL, NULL, 'rate', 92, 93),
(44, 33, NULL, NULL, 'admin_reorder', 94, 95),
(45, 33, NULL, NULL, 'admin_commentPurge', 96, 97),
(46, 33, NULL, NULL, 'admin_mass', 98, 99),
(47, 33, NULL, NULL, 'admin_buildAcl', 100, 101),
(48, 33, NULL, NULL, 'add', 102, 103),
(49, 33, NULL, NULL, 'edit', 104, 105),
(50, 33, NULL, NULL, 'delete', 106, 107),
(51, 16, NULL, NULL, 'Tags', 111, 142),
(52, 51, NULL, NULL, 'admin_index', 112, 113),
(53, 51, NULL, NULL, 'admin_clean_up', 114, 115),
(54, 51, NULL, NULL, 'comment', 116, 117),
(55, 51, NULL, NULL, 'rate', 118, 119),
(56, 51, NULL, NULL, 'admin_reorder', 120, 121),
(57, 51, NULL, NULL, 'admin_delete', 122, 123),
(58, 51, NULL, NULL, 'admin_commentPurge', 124, 125),
(59, 51, NULL, NULL, 'admin_mass', 126, 127),
(60, 51, NULL, NULL, 'admin_buildAcl', 128, 129),
(61, 51, NULL, NULL, 'add', 130, 131),
(62, 51, NULL, NULL, 'edit', 132, 133),
(63, 51, NULL, NULL, 'index', 134, 135),
(64, 51, NULL, NULL, 'view', 136, 137),
(65, 51, NULL, NULL, 'delete', 138, 139),
(66, 1, NULL, NULL, 'Cms', 144, 313),
(67, 66, NULL, NULL, 'Categories', 145, 178),
(68, 67, NULL, NULL, 'index', 146, 147),
(69, 67, NULL, NULL, 'admin_index', 148, 149),
(70, 67, NULL, NULL, 'admin_add', 150, 151),
(71, 67, NULL, NULL, 'admin_edit', 152, 153),
(72, 67, NULL, NULL, 'comment', 154, 155),
(73, 67, NULL, NULL, 'rate', 156, 157),
(74, 67, NULL, NULL, 'admin_reorder', 158, 159),
(75, 67, NULL, NULL, 'admin_delete', 160, 161),
(76, 67, NULL, NULL, 'admin_commentPurge', 162, 163),
(77, 67, NULL, NULL, 'admin_mass', 164, 165),
(78, 67, NULL, NULL, 'admin_buildAcl', 166, 167),
(79, 67, NULL, NULL, 'add', 168, 169),
(80, 67, NULL, NULL, 'edit', 170, 171),
(81, 67, NULL, NULL, 'view', 172, 173),
(82, 67, NULL, NULL, 'delete', 174, 175),
(83, 66, NULL, NULL, 'Contents', 179, 214),
(84, 83, NULL, NULL, 'index', 180, 181),
(85, 83, NULL, NULL, 'view', 182, 183),
(86, 83, NULL, NULL, 'admin_index', 184, 185),
(87, 83, NULL, NULL, 'admin_view', 186, 187),
(88, 83, NULL, NULL, 'admin_add', 188, 189),
(89, 83, NULL, NULL, 'admin_edit', 190, 191),
(90, 83, NULL, NULL, 'comment', 192, 193),
(91, 83, NULL, NULL, 'rate', 194, 195),
(92, 83, NULL, NULL, 'admin_reorder', 196, 197),
(93, 83, NULL, NULL, 'admin_delete', 198, 199),
(94, 83, NULL, NULL, 'admin_commentPurge', 200, 201),
(95, 83, NULL, NULL, 'admin_mass', 202, 203),
(96, 83, NULL, NULL, 'admin_buildAcl', 204, 205),
(97, 83, NULL, NULL, 'add', 206, 207),
(98, 83, NULL, NULL, 'edit', 208, 209),
(99, 83, NULL, NULL, 'delete', 210, 211),
(100, 66, NULL, NULL, 'Features', 215, 246),
(101, 100, NULL, NULL, 'index', 216, 217),
(102, 100, NULL, NULL, 'admin_index', 218, 219),
(103, 100, NULL, NULL, 'admin_add', 220, 221),
(104, 100, NULL, NULL, 'comment', 222, 223),
(105, 100, NULL, NULL, 'rate', 224, 225),
(106, 100, NULL, NULL, 'admin_reorder', 226, 227),
(107, 100, NULL, NULL, 'admin_delete', 228, 229),
(108, 100, NULL, NULL, 'admin_commentPurge', 230, 231),
(109, 100, NULL, NULL, 'admin_mass', 232, 233),
(110, 100, NULL, NULL, 'admin_buildAcl', 234, 235),
(111, 100, NULL, NULL, 'add', 236, 237),
(112, 100, NULL, NULL, 'edit', 238, 239),
(113, 100, NULL, NULL, 'view', 240, 241),
(114, 100, NULL, NULL, 'delete', 242, 243),
(115, 66, NULL, NULL, 'Frontpages', 247, 278),
(116, 115, NULL, NULL, 'index', 248, 249),
(117, 115, NULL, NULL, 'admin_index', 250, 251),
(118, 115, NULL, NULL, 'admin_add', 252, 253),
(119, 115, NULL, NULL, 'comment', 254, 255),
(120, 115, NULL, NULL, 'rate', 256, 257),
(121, 115, NULL, NULL, 'admin_reorder', 258, 259),
(122, 115, NULL, NULL, 'admin_delete', 260, 261),
(123, 115, NULL, NULL, 'admin_commentPurge', 262, 263),
(124, 115, NULL, NULL, 'admin_mass', 264, 265),
(125, 115, NULL, NULL, 'admin_buildAcl', 266, 267),
(126, 115, NULL, NULL, 'add', 268, 269),
(127, 115, NULL, NULL, 'edit', 270, 271),
(128, 115, NULL, NULL, 'view', 272, 273),
(129, 115, NULL, NULL, 'delete', 274, 275),
(130, 66, NULL, NULL, 'Layouts', 279, 312),
(131, 130, NULL, NULL, 'admin_index', 280, 281),
(132, 130, NULL, NULL, 'admin_add', 282, 283),
(133, 130, NULL, NULL, 'admin_edit', 284, 285),
(134, 130, NULL, NULL, 'comment', 286, 287),
(135, 130, NULL, NULL, 'rate', 288, 289),
(136, 130, NULL, NULL, 'admin_reorder', 290, 291),
(137, 130, NULL, NULL, 'admin_delete', 292, 293),
(138, 130, NULL, NULL, 'admin_commentPurge', 294, 295),
(139, 130, NULL, NULL, 'admin_mass', 296, 297),
(140, 130, NULL, NULL, 'admin_buildAcl', 298, 299),
(141, 130, NULL, NULL, 'add', 300, 301),
(142, 130, NULL, NULL, 'edit', 302, 303),
(143, 130, NULL, NULL, 'index', 304, 305),
(144, 130, NULL, NULL, 'view', 306, 307),
(145, 130, NULL, NULL, 'delete', 308, 309),
(146, 1, NULL, NULL, 'Contact', 314, 383),
(147, 146, NULL, NULL, 'Branches', 315, 348),
(148, 147, NULL, NULL, 'view', 316, 317),
(149, 147, NULL, NULL, 'admin_index', 318, 319),
(150, 147, NULL, NULL, 'admin_add', 320, 321),
(151, 147, NULL, NULL, 'admin_edit', 322, 323),
(152, 147, NULL, NULL, 'comment', 324, 325),
(153, 147, NULL, NULL, 'rate', 326, 327),
(154, 147, NULL, NULL, 'admin_reorder', 328, 329),
(155, 147, NULL, NULL, 'admin_delete', 330, 331),
(156, 147, NULL, NULL, 'admin_commentPurge', 332, 333),
(157, 147, NULL, NULL, 'admin_mass', 334, 335),
(158, 147, NULL, NULL, 'admin_buildAcl', 336, 337),
(159, 147, NULL, NULL, 'add', 338, 339),
(160, 147, NULL, NULL, 'edit', 340, 341),
(161, 147, NULL, NULL, 'index', 342, 343),
(162, 147, NULL, NULL, 'delete', 344, 345),
(163, 146, NULL, NULL, 'Contacts', 349, 382),
(164, 163, NULL, NULL, 'admin_index', 350, 351),
(165, 163, NULL, NULL, 'admin_add', 352, 353),
(166, 163, NULL, NULL, 'admin_edit', 354, 355),
(167, 163, NULL, NULL, 'comment', 356, 357),
(168, 163, NULL, NULL, 'rate', 358, 359),
(169, 163, NULL, NULL, 'admin_reorder', 360, 361),
(170, 163, NULL, NULL, 'admin_delete', 362, 363),
(171, 163, NULL, NULL, 'admin_commentPurge', 364, 365),
(172, 163, NULL, NULL, 'admin_mass', 366, 367),
(173, 163, NULL, NULL, 'admin_buildAcl', 368, 369),
(174, 163, NULL, NULL, 'add', 370, 371),
(175, 163, NULL, NULL, 'edit', 372, 373),
(176, 163, NULL, NULL, 'index', 374, 375),
(177, 163, NULL, NULL, 'view', 376, 377),
(178, 163, NULL, NULL, 'delete', 378, 379),
(179, 1, NULL, NULL, 'Filemanager', 384, 419),
(180, 179, NULL, NULL, 'FileManager', 385, 418),
(181, 180, NULL, NULL, 'admin_index', 386, 387),
(182, 180, NULL, NULL, 'admin_view', 388, 389),
(183, 180, NULL, NULL, 'admin_download', 390, 391),
(184, 180, NULL, NULL, 'admin_delete', 392, 393),
(185, 180, NULL, NULL, 'comment', 394, 395),
(186, 180, NULL, NULL, 'rate', 396, 397),
(187, 180, NULL, NULL, 'admin_reorder', 398, 399),
(188, 180, NULL, NULL, 'admin_commentPurge', 400, 401),
(189, 180, NULL, NULL, 'admin_mass', 402, 403),
(190, 180, NULL, NULL, 'admin_buildAcl', 404, 405),
(191, 180, NULL, NULL, 'add', 406, 407),
(192, 180, NULL, NULL, 'edit', 408, 409),
(193, 180, NULL, NULL, 'index', 410, 411),
(194, 180, NULL, NULL, 'view', 412, 413),
(195, 180, NULL, NULL, 'delete', 414, 415),
(196, 1, NULL, NULL, 'Installer', 420, 463),
(197, 196, NULL, NULL, 'Install', 421, 442),
(198, 197, NULL, NULL, 'index', 422, 423),
(199, 197, NULL, NULL, 'licence', 424, 425),
(200, 197, NULL, NULL, 'database', 426, 427),
(201, 197, NULL, NULL, 'install', 428, 429),
(202, 197, NULL, NULL, 'siteConfig', 430, 431),
(203, 197, NULL, NULL, 'done', 432, 433),
(204, 197, NULL, NULL, 'add', 434, 435),
(205, 197, NULL, NULL, 'edit', 436, 437),
(206, 197, NULL, NULL, 'view', 438, 439),
(207, 197, NULL, NULL, 'delete', 440, 441),
(208, 196, NULL, NULL, 'Releases', 443, 460),
(209, 208, NULL, NULL, 'admin_index', 444, 445),
(210, 208, NULL, NULL, 'admin_core_data', 446, 447),
(211, 208, NULL, NULL, 'admin_sample_data', 448, 449),
(212, 208, NULL, NULL, 'add', 450, 451),
(213, 208, NULL, NULL, 'edit', 452, 453),
(214, 208, NULL, NULL, 'index', 454, 455),
(215, 208, NULL, NULL, 'view', 456, 457),
(216, 208, NULL, NULL, 'delete', 458, 459),
(217, 1, NULL, NULL, 'Management', 464, 949),
(218, 217, NULL, NULL, 'Acos', 465, 500),
(219, 218, NULL, NULL, 'admin_index', 466, 467),
(220, 218, NULL, NULL, 'admin_view', 468, 469),
(221, 218, NULL, NULL, 'admin_add', 470, 471),
(222, 218, NULL, NULL, 'admin_edit', 472, 473),
(223, 218, NULL, NULL, 'comment', 474, 475),
(224, 218, NULL, NULL, 'rate', 476, 477),
(225, 218, NULL, NULL, 'admin_reorder', 478, 479),
(226, 218, NULL, NULL, 'admin_delete', 480, 481),
(227, 218, NULL, NULL, 'admin_commentPurge', 482, 483),
(228, 218, NULL, NULL, 'admin_mass', 484, 485),
(229, 218, NULL, NULL, 'admin_buildAcl', 486, 487),
(230, 218, NULL, NULL, 'add', 488, 489),
(231, 218, NULL, NULL, 'edit', 490, 491),
(232, 218, NULL, NULL, 'index', 492, 493),
(233, 218, NULL, NULL, 'view', 494, 495),
(234, 218, NULL, NULL, 'delete', 496, 497),
(235, 217, NULL, NULL, 'Backups', 501, 530),
(236, 235, NULL, NULL, 'admin_backup', 502, 503),
(237, 235, NULL, NULL, 'comment', 504, 505),
(238, 235, NULL, NULL, 'rate', 506, 507),
(239, 235, NULL, NULL, 'admin_reorder', 508, 509),
(240, 235, NULL, NULL, 'admin_delete', 510, 511),
(241, 235, NULL, NULL, 'admin_commentPurge', 512, 513),
(242, 235, NULL, NULL, 'admin_mass', 514, 515),
(243, 235, NULL, NULL, 'admin_buildAcl', 516, 517),
(244, 235, NULL, NULL, 'add', 518, 519),
(245, 235, NULL, NULL, 'edit', 520, 521),
(246, 235, NULL, NULL, 'index', 522, 523),
(247, 235, NULL, NULL, 'view', 524, 525),
(248, 235, NULL, NULL, 'delete', 526, 527),
(249, 217, NULL, NULL, 'Comments', 531, 566),
(250, 249, NULL, NULL, 'admin_index', 532, 533),
(251, 249, NULL, NULL, 'admin_perge', 534, 535),
(252, 249, NULL, NULL, 'admin_commentPurge', 536, 537),
(253, 249, NULL, NULL, 'comment', 538, 539),
(254, 249, NULL, NULL, 'rate', 540, 541),
(255, 249, NULL, NULL, 'admin_reorder', 542, 543),
(256, 249, NULL, NULL, 'admin_delete', 544, 545),
(257, 249, NULL, NULL, 'admin_mass', 546, 547),
(258, 249, NULL, NULL, 'admin_buildAcl', 548, 549),
(259, 249, NULL, NULL, 'add', 550, 551),
(260, 249, NULL, NULL, 'edit', 552, 553),
(261, 249, NULL, NULL, 'index', 554, 555),
(262, 249, NULL, NULL, 'view', 556, 557),
(263, 249, NULL, NULL, 'delete', 558, 559),
(264, 217, NULL, NULL, 'Configs', 567, 600),
(265, 264, NULL, NULL, 'admin_index', 568, 569),
(266, 264, NULL, NULL, 'admin_add', 570, 571),
(267, 264, NULL, NULL, 'admin_edit', 572, 573),
(268, 264, NULL, NULL, 'comment', 574, 575),
(269, 264, NULL, NULL, 'rate', 576, 577),
(270, 264, NULL, NULL, 'admin_reorder', 578, 579),
(271, 264, NULL, NULL, 'admin_delete', 580, 581),
(272, 264, NULL, NULL, 'admin_commentPurge', 582, 583),
(273, 264, NULL, NULL, 'admin_mass', 584, 585),
(274, 264, NULL, NULL, 'admin_buildAcl', 586, 587),
(275, 264, NULL, NULL, 'add', 588, 589),
(276, 264, NULL, NULL, 'edit', 590, 591),
(277, 264, NULL, NULL, 'index', 592, 593),
(278, 264, NULL, NULL, 'view', 594, 595),
(279, 264, NULL, NULL, 'delete', 596, 597),
(280, 217, NULL, NULL, 'IpAddresses', 601, 634),
(281, 280, NULL, NULL, 'admin_index', 602, 603),
(282, 280, NULL, NULL, 'admin_add', 604, 605),
(283, 280, NULL, NULL, 'admin_edit', 606, 607),
(284, 280, NULL, NULL, 'comment', 608, 609),
(285, 280, NULL, NULL, 'rate', 610, 611),
(286, 280, NULL, NULL, 'admin_reorder', 612, 613),
(287, 280, NULL, NULL, 'admin_delete', 614, 615),
(288, 280, NULL, NULL, 'admin_commentPurge', 616, 617),
(289, 280, NULL, NULL, 'admin_mass', 618, 619),
(290, 280, NULL, NULL, 'admin_buildAcl', 620, 621),
(291, 280, NULL, NULL, 'add', 622, 623),
(292, 280, NULL, NULL, 'edit', 624, 625),
(293, 280, NULL, NULL, 'index', 626, 627),
(294, 280, NULL, NULL, 'view', 628, 629),
(295, 280, NULL, NULL, 'delete', 630, 631),
(296, 217, NULL, NULL, 'Locks', 635, 666),
(297, 296, NULL, NULL, 'admin_index', 636, 637),
(298, 296, NULL, NULL, 'admin_unlock', 638, 639),
(299, 296, NULL, NULL, 'comment', 640, 641),
(300, 296, NULL, NULL, 'rate', 642, 643),
(301, 296, NULL, NULL, 'admin_reorder', 644, 645),
(302, 296, NULL, NULL, 'admin_delete', 646, 647),
(303, 296, NULL, NULL, 'admin_commentPurge', 648, 649),
(304, 296, NULL, NULL, 'admin_mass', 650, 651),
(305, 296, NULL, NULL, 'admin_buildAcl', 652, 653),
(306, 296, NULL, NULL, 'add', 654, 655),
(307, 296, NULL, NULL, 'edit', 656, 657),
(308, 296, NULL, NULL, 'index', 658, 659),
(309, 296, NULL, NULL, 'view', 660, 661),
(310, 296, NULL, NULL, 'delete', 662, 663),
(311, 217, NULL, NULL, 'Management', 667, 948),
(312, 311, NULL, NULL, 'admin_dashboard', 668, 669),
(313, 311, NULL, NULL, 'comment', 670, 671),
(314, 311, NULL, NULL, 'rate', 672, 673),
(315, 311, NULL, NULL, 'admin_reorder', 674, 675),
(316, 311, NULL, NULL, 'admin_delete', 676, 677),
(317, 311, NULL, NULL, 'admin_commentPurge', 678, 679),
(318, 311, NULL, NULL, 'admin_mass', 680, 681),
(319, 311, NULL, NULL, 'admin_buildAcl', 682, 683),
(320, 311, NULL, NULL, 'add', 684, 685),
(321, 311, NULL, NULL, 'edit', 686, 687),
(322, 311, NULL, NULL, 'index', 688, 689),
(323, 311, NULL, NULL, 'view', 690, 691),
(324, 311, NULL, NULL, 'delete', 692, 693),
(325, 311, NULL, NULL, 'Menus', 694, 727),
(326, 325, NULL, NULL, 'admin_index', 695, 696),
(327, 325, NULL, NULL, 'admin_add', 697, 698),
(328, 325, NULL, NULL, 'admin_edit', 699, 700),
(329, 325, NULL, NULL, 'comment', 701, 702),
(330, 325, NULL, NULL, 'rate', 703, 704),
(331, 325, NULL, NULL, 'admin_reorder', 705, 706),
(332, 325, NULL, NULL, 'admin_delete', 707, 708),
(333, 325, NULL, NULL, 'admin_commentPurge', 709, 710),
(334, 325, NULL, NULL, 'admin_mass', 711, 712),
(335, 325, NULL, NULL, 'admin_buildAcl', 713, 714),
(336, 325, NULL, NULL, 'add', 715, 716),
(337, 325, NULL, NULL, 'edit', 717, 718),
(338, 325, NULL, NULL, 'index', 719, 720),
(339, 325, NULL, NULL, 'view', 721, 722),
(340, 325, NULL, NULL, 'delete', 723, 724),
(341, 311, NULL, NULL, 'MenuItems', 728, 761),
(342, 341, NULL, NULL, 'admin_index', 729, 730),
(343, 341, NULL, NULL, 'admin_add', 731, 732),
(344, 341, NULL, NULL, 'admin_edit', 733, 734),
(345, 341, NULL, NULL, 'comment', 735, 736),
(346, 341, NULL, NULL, 'rate', 737, 738),
(347, 341, NULL, NULL, 'admin_reorder', 739, 740),
(348, 341, NULL, NULL, 'admin_delete', 741, 742),
(349, 341, NULL, NULL, 'admin_commentPurge', 743, 744),
(350, 341, NULL, NULL, 'admin_mass', 745, 746),
(351, 341, NULL, NULL, 'admin_buildAcl', 747, 748),
(352, 341, NULL, NULL, 'add', 749, 750),
(353, 341, NULL, NULL, 'edit', 751, 752),
(354, 341, NULL, NULL, 'index', 753, 754),
(355, 341, NULL, NULL, 'view', 755, 756),
(356, 341, NULL, NULL, 'delete', 757, 758),
(357, 311, NULL, NULL, 'Modules', 762, 795),
(358, 357, NULL, NULL, 'admin_index', 763, 764),
(359, 357, NULL, NULL, 'admin_add', 765, 766),
(360, 357, NULL, NULL, 'admin_edit', 767, 768),
(361, 357, NULL, NULL, 'comment', 769, 770),
(362, 357, NULL, NULL, 'rate', 771, 772),
(363, 357, NULL, NULL, 'admin_reorder', 773, 774),
(364, 357, NULL, NULL, 'admin_delete', 775, 776),
(365, 357, NULL, NULL, 'admin_commentPurge', 777, 778),
(366, 357, NULL, NULL, 'admin_mass', 779, 780),
(367, 357, NULL, NULL, 'admin_buildAcl', 781, 782),
(368, 357, NULL, NULL, 'add', 783, 784),
(369, 357, NULL, NULL, 'edit', 785, 786),
(370, 357, NULL, NULL, 'index', 787, 788),
(371, 357, NULL, NULL, 'view', 789, 790),
(372, 357, NULL, NULL, 'delete', 791, 792),
(373, 311, NULL, NULL, 'Routes', 796, 829),
(374, 373, NULL, NULL, 'admin_index', 797, 798),
(375, 373, NULL, NULL, 'admin_add', 799, 800),
(376, 373, NULL, NULL, 'admin_edit', 801, 802),
(377, 373, NULL, NULL, 'comment', 803, 804),
(378, 373, NULL, NULL, 'rate', 805, 806),
(379, 373, NULL, NULL, 'admin_reorder', 807, 808),
(380, 373, NULL, NULL, 'admin_delete', 809, 810),
(381, 373, NULL, NULL, 'admin_commentPurge', 811, 812),
(382, 373, NULL, NULL, 'admin_mass', 813, 814),
(383, 373, NULL, NULL, 'admin_buildAcl', 815, 816),
(384, 373, NULL, NULL, 'add', 817, 818),
(385, 373, NULL, NULL, 'edit', 819, 820),
(386, 373, NULL, NULL, 'index', 821, 822),
(387, 373, NULL, NULL, 'view', 823, 824),
(388, 373, NULL, NULL, 'delete', 825, 826),
(389, 311, NULL, NULL, 'Themes', 830, 863),
(390, 389, NULL, NULL, 'admin_index', 831, 832),
(391, 389, NULL, NULL, 'admin_add', 833, 834),
(392, 389, NULL, NULL, 'admin_edit', 835, 836),
(393, 389, NULL, NULL, 'admin_mass', 837, 838),
(394, 389, NULL, NULL, 'comment', 839, 840),
(395, 389, NULL, NULL, 'rate', 841, 842),
(396, 389, NULL, NULL, 'admin_reorder', 843, 844),
(397, 389, NULL, NULL, 'admin_delete', 845, 846),
(398, 389, NULL, NULL, 'admin_commentPurge', 847, 848),
(399, 389, NULL, NULL, 'admin_buildAcl', 849, 850),
(400, 389, NULL, NULL, 'add', 851, 852),
(401, 389, NULL, NULL, 'edit', 853, 854),
(402, 389, NULL, NULL, 'index', 855, 856),
(403, 389, NULL, NULL, 'view', 857, 858),
(404, 389, NULL, NULL, 'delete', 859, 860),
(405, 311, NULL, NULL, 'Users', 864, 911),
(406, 405, NULL, NULL, 'login', 865, 866),
(407, 405, NULL, NULL, 'logout', 867, 868),
(408, 405, NULL, NULL, 'register', 869, 870),
(409, 405, NULL, NULL, 'admin_login', 871, 872),
(410, 405, NULL, NULL, 'admin_logout', 873, 874),
(411, 405, NULL, NULL, 'admin_index', 875, 876),
(412, 405, NULL, NULL, 'admin_logged_in', 877, 878),
(413, 405, NULL, NULL, 'admin_add', 879, 880),
(414, 405, NULL, NULL, 'admin_edit', 881, 882),
(415, 405, NULL, NULL, 'admin_initDB', 883, 884),
(416, 405, NULL, NULL, 'comment', 885, 886),
(417, 405, NULL, NULL, 'rate', 887, 888),
(418, 405, NULL, NULL, 'admin_reorder', 889, 890),
(419, 405, NULL, NULL, 'admin_delete', 891, 892),
(420, 405, NULL, NULL, 'admin_commentPurge', 893, 894),
(421, 405, NULL, NULL, 'admin_mass', 895, 896),
(422, 405, NULL, NULL, 'admin_buildAcl', 897, 898),
(423, 405, NULL, NULL, 'add', 899, 900),
(424, 405, NULL, NULL, 'edit', 901, 902),
(425, 405, NULL, NULL, 'index', 903, 904),
(426, 405, NULL, NULL, 'view', 905, 906),
(427, 405, NULL, NULL, 'delete', 907, 908),
(428, 1, NULL, NULL, 'Newsletter', 950, 1079),
(429, 428, NULL, NULL, 'Campaigns', 951, 986),
(430, 429, NULL, NULL, 'admin_index', 952, 953),
(431, 429, NULL, NULL, 'admin_add', 954, 955),
(432, 429, NULL, NULL, 'admin_edit', 956, 957),
(433, 429, NULL, NULL, 'admin_toggle', 958, 959),
(434, 429, NULL, NULL, 'admin_delete', 960, 961),
(435, 429, NULL, NULL, 'admin_mass', 962, 963),
(436, 429, NULL, NULL, 'comment', 964, 965),
(437, 429, NULL, NULL, 'rate', 966, 967),
(438, 429, NULL, NULL, 'admin_reorder', 968, 969),
(439, 429, NULL, NULL, 'admin_commentPurge', 970, 971),
(440, 429, NULL, NULL, 'admin_buildAcl', 972, 973),
(441, 429, NULL, NULL, 'add', 974, 975),
(442, 429, NULL, NULL, 'edit', 976, 977),
(443, 429, NULL, NULL, 'index', 978, 979),
(444, 429, NULL, NULL, 'view', 980, 981),
(445, 429, NULL, NULL, 'delete', 982, 983),
(446, 428, NULL, NULL, 'Newsletters', 987, 1038),
(447, 446, NULL, NULL, 'track', 988, 989),
(448, 446, NULL, NULL, 'sendNewsletters', 990, 991),
(449, 446, NULL, NULL, 'admin_dashboard', 992, 993),
(450, 446, NULL, NULL, 'admin_report', 994, 995),
(451, 446, NULL, NULL, 'admin_index', 996, 997),
(452, 446, NULL, NULL, 'admin_add', 998, 999),
(453, 446, NULL, NULL, 'admin_edit', 1000, 1001),
(454, 446, NULL, NULL, 'admin_view', 1002, 1003),
(455, 446, NULL, NULL, 'admin_preview', 1004, 1005),
(456, 446, NULL, NULL, 'admin_delte', 1006, 1007),
(457, 446, NULL, NULL, 'admin_mass', 1008, 1009),
(458, 446, NULL, NULL, 'admin_toggleSend', 1010, 1011),
(459, 446, NULL, NULL, 'admin_stopAll', 1012, 1013),
(460, 446, NULL, NULL, 'comment', 1014, 1015),
(461, 446, NULL, NULL, 'rate', 1016, 1017),
(462, 446, NULL, NULL, 'admin_reorder', 1018, 1019),
(463, 446, NULL, NULL, 'admin_delete', 1020, 1021),
(464, 446, NULL, NULL, 'admin_commentPurge', 1022, 1023),
(465, 446, NULL, NULL, 'admin_buildAcl', 1024, 1025),
(466, 446, NULL, NULL, 'add', 1026, 1027),
(467, 446, NULL, NULL, 'edit', 1028, 1029),
(468, 446, NULL, NULL, 'index', 1030, 1031),
(469, 446, NULL, NULL, 'view', 1032, 1033),
(470, 446, NULL, NULL, 'delete', 1034, 1035),
(471, 428, NULL, NULL, 'Templates', 1039, 1078),
(472, 471, NULL, NULL, 'admin_index', 1040, 1041),
(473, 471, NULL, NULL, 'admin_add', 1042, 1043),
(474, 471, NULL, NULL, 'admin_edit', 1044, 1045),
(475, 471, NULL, NULL, 'admin_view', 1046, 1047),
(476, 471, NULL, NULL, 'admin_export', 1048, 1049),
(477, 471, NULL, NULL, 'admin_preview', 1050, 1051),
(478, 471, NULL, NULL, 'admin_delete', 1052, 1053),
(479, 471, NULL, NULL, 'admin_mass', 1054, 1055),
(480, 471, NULL, NULL, 'comment', 1056, 1057),
(481, 471, NULL, NULL, 'rate', 1058, 1059),
(482, 471, NULL, NULL, 'admin_reorder', 1060, 1061),
(483, 471, NULL, NULL, 'admin_commentPurge', 1062, 1063),
(484, 471, NULL, NULL, 'admin_buildAcl', 1064, 1065),
(485, 471, NULL, NULL, 'add', 1066, 1067),
(486, 471, NULL, NULL, 'edit', 1068, 1069),
(487, 471, NULL, NULL, 'index', 1070, 1071),
(488, 471, NULL, NULL, 'view', 1072, 1073),
(489, 471, NULL, NULL, 'delete', 1074, 1075),
(490, 1, NULL, NULL, 'Db Admin', 1080, 1139),
(491, 490, NULL, NULL, 'Databases', 1081, 1108),
(492, 491, NULL, NULL, 'admin_index', 1082, 1083),
(493, 491, NULL, NULL, 'comment', 1084, 1085),
(494, 491, NULL, NULL, 'rate', 1086, 1087),
(495, 491, NULL, NULL, 'admin_reorder', 1088, 1089),
(496, 491, NULL, NULL, 'admin_delete', 1090, 1091),
(497, 491, NULL, NULL, 'admin_commentPurge', 1092, 1093),
(498, 491, NULL, NULL, 'admin_mass', 1094, 1095),
(499, 491, NULL, NULL, 'admin_buildAcl', 1096, 1097),
(500, 491, NULL, NULL, 'add', 1098, 1099),
(501, 491, NULL, NULL, 'edit', 1100, 1101),
(502, 491, NULL, NULL, 'index', 1102, 1103),
(503, 491, NULL, NULL, 'view', 1104, 1105),
(504, 491, NULL, NULL, 'delete', 1106, 1107),
(505, 2, NULL, NULL, 'admin_index', 29, 30),
(506, 2, NULL, NULL, 'admin_add', 31, 32),
(507, 2, NULL, NULL, 'admin_edit', 33, 34),
(508, 2, NULL, NULL, 'blackHole', 35, 36),
(509, 17, NULL, NULL, 'blackHole', 70, 71),
(510, 33, NULL, NULL, 'blackHole', 108, 109),
(511, 51, NULL, NULL, 'blackHole', 140, 141),
(512, 67, NULL, NULL, 'blackHole', 176, 177),
(513, 83, NULL, NULL, 'blackHole', 212, 213),
(514, 100, NULL, NULL, 'blackHole', 244, 245),
(515, 115, NULL, NULL, 'blackHole', 276, 277),
(516, 130, NULL, NULL, 'blackHole', 310, 311),
(517, 147, NULL, NULL, 'blackHole', 346, 347),
(518, 163, NULL, NULL, 'blackHole', 380, 381),
(519, 1, NULL, NULL, 'Filemanager', 1140, 1141),
(520, 180, NULL, NULL, 'blackHole', 416, 417),
(521, 196, NULL, NULL, 'Install', 461, 462),
(522, 218, NULL, NULL, 'blackHole', 498, 499),
(523, 235, NULL, NULL, 'blackHole', 528, 529),
(524, 249, NULL, NULL, 'admin_toggle', 560, 561),
(525, 249, NULL, NULL, 'admin_reply', 562, 563),
(526, 249, NULL, NULL, 'blackHole', 564, 565),
(527, 264, NULL, NULL, 'blackHole', 598, 599),
(528, 280, NULL, NULL, 'blackHole', 632, 633),
(529, 296, NULL, NULL, 'blackHole', 664, 665),
(530, 311, NULL, NULL, 'blackHole', 912, 913),
(531, 325, NULL, NULL, 'blackHole', 725, 726),
(532, 341, NULL, NULL, 'blackHole', 759, 760),
(533, 357, NULL, NULL, 'blackHole', 793, 794),
(534, 311, NULL, NULL, 'Pages', 914, 947),
(535, 534, NULL, NULL, 'admin_index', 915, 916),
(536, 534, NULL, NULL, 'admin_add', 917, 918),
(537, 534, NULL, NULL, 'admin_edit', 919, 920),
(538, 534, NULL, NULL, 'blackHole', 921, 922),
(539, 534, NULL, NULL, 'comment', 923, 924),
(540, 534, NULL, NULL, 'rate', 925, 926),
(541, 534, NULL, NULL, 'admin_reorder', 927, 928),
(542, 534, NULL, NULL, 'admin_delete', 929, 930),
(543, 534, NULL, NULL, 'admin_commentPurge', 931, 932),
(544, 534, NULL, NULL, 'admin_mass', 933, 934),
(545, 534, NULL, NULL, 'admin_buildAcl', 935, 936),
(546, 534, NULL, NULL, 'add', 937, 938),
(547, 534, NULL, NULL, 'edit', 939, 940),
(548, 534, NULL, NULL, 'index', 941, 942),
(549, 534, NULL, NULL, 'view', 943, 944),
(550, 534, NULL, NULL, 'delete', 945, 946),
(551, 373, NULL, NULL, 'blackHole', 827, 828),
(552, 389, NULL, NULL, 'blackHole', 861, 862),
(553, 405, NULL, NULL, 'blackHole', 909, 910),
(554, 429, NULL, NULL, 'blackHole', 984, 985),
(555, 446, NULL, NULL, 'blackHole', 1036, 1037),
(556, 471, NULL, NULL, 'blackHole', 1076, 1077),
(557, 490, NULL, NULL, 'Listings', 1109, 1138),
(558, 557, NULL, NULL, 'admin_index', 1110, 1111),
(559, 557, NULL, NULL, 'blackHole', 1112, 1113),
(560, 557, NULL, NULL, 'comment', 1114, 1115),
(561, 557, NULL, NULL, 'rate', 1116, 1117),
(562, 557, NULL, NULL, 'admin_reorder', 1118, 1119),
(563, 557, NULL, NULL, 'admin_delete', 1120, 1121),
(564, 557, NULL, NULL, 'admin_commentPurge', 1122, 1123),
(565, 557, NULL, NULL, 'admin_mass', 1124, 1125),
(566, 557, NULL, NULL, 'admin_buildAcl', 1126, 1127),
(567, 557, NULL, NULL, 'add', 1128, 1129),
(568, 557, NULL, NULL, 'edit', 1130, 1131),
(569, 557, NULL, NULL, 'index', 1132, 1133),
(570, 557, NULL, NULL, 'view', 1134, 1135),
(571, 557, NULL, NULL, 'delete', 1136, 1137);

DROP TABLE IF EXISTS `core_addresses`;
CREATE TABLE `core_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `street` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `province` varchar(100) NOT NULL,
  `postal` varchar(10) NOT NULL,
  `country_id` int(11) NOT NULL,
  `continent_id` int(11) NOT NULL,
  `plugin` varchar(50) DEFAULT NULL,
  `model` varchar(50) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `core_addresses` (`id`, `name`, `street`, `city`, `province`, `postal`, `country_id`, `continent_id`, `plugin`, `model`, `created`, `modified`) VALUES
(1, '0', 'some', 'thing', 'goes', 'here', 1, 1, NULL, NULL, NULL, NULL);

DROP TABLE IF EXISTS `core_aros`;
CREATE TABLE `core_aros` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `foreign_key` int(10) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

INSERT INTO `core_aros` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
(1, NULL, 'Group', 1, NULL, 1, 2),
(2, NULL, 'User', 1, NULL, 3, 4);

DROP TABLE IF EXISTS `core_aros_acos`;
CREATE TABLE `core_aros_acos` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aro_id` int(10) NOT NULL,
  `aco_id` int(10) NOT NULL,
  `_create` varchar(2) NOT NULL DEFAULT '0',
  `_read` varchar(2) NOT NULL DEFAULT '0',
  `_update` varchar(2) NOT NULL DEFAULT '0',
  `_delete` varchar(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ARO_ACO_KEY` (`aro_id`,`aco_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `core_aros_acos` (`id`, `aro_id`, `aco_id`, `_create`, `_read`, `_update`, `_delete`) VALUES
(1, 2, 1, '1', '1', '1', '1');

DROP TABLE IF EXISTS `core_backups`;
CREATE TABLE `core_backups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `plugin` varchar(50) DEFAULT NULL,
  `model` varchar(50) NOT NULL,
  `last_id` int(11) NOT NULL,
  `data` text NOT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `core_comments`;
CREATE TABLE `core_comments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `class` varchar(128) NOT NULL,
  `foreign_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `website` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `active` tinyint(1) NOT NULL,
  `rating` int(11) NOT NULL,
  `points` int(11) NOT NULL,
  `status` varchar(100) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `core_configs`;
CREATE TABLE `core_configs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `key` varchar(100) NOT NULL,
  `value` text NOT NULL,
  `type` varchar(20) NOT NULL,
  `options` text NOT NULL,
  `description` text,
  `core` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `config_key` (`key`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ;

INSERT INTO `core_configs` (`id`, `key`, `value`, `type`, `options`, `description`, `core`) VALUES
(1, 'debug', '2', 'dropdown', '0,1,2,3', '<p>Production Mode: 0: No error messages, errors, or warnings shown. Flash messages redirect.  Development Mode: 1: Errors and warnings shown, model caches refreshed, flash messages halted. 2: As in 1, but also with full debug messages and SQL output.</p>', 1),
(2, 'log', '1', 'bool', 'true,false', 'In case of Production Mode CakePHP gives you the possibility to continue logging errors.\r\n\r\nThe following parameters can be used:\r\nBoolean: Set true/false to activate/deactivate logging', 1),
(3, 'Session.save', 'database', 'dropdown', 'php,cake,database', '<p>\r\n	The preferred session handling method. &#39;php&#39; -&gt; Uses settings defined in your php.ini. &#39;cake&#39; -&gt; Saves session files in CakePHP&#39;s /tmp directory. &#39;database&#39; -&gt; Uses CakePHP&#39;s database sessions.</p>\r\n', 1),
(4, 'App.encoding', 'UTF-8', 'string', '', 'Application wide charset encoding', 1),
(5, 'Cache.disable', 'false', 'bool', 'true,false', 'Turn off all caching application-wide.', 1),
(6, 'Session.model', 'Management.Session', 'string', '', 'The model name to be used for the session model.\r\n\r\n''Session.save'' must be set to ''database'' in order to utilize this constant.\r\n\r\nThe model name set here should *not* be used elsewhere in your application.', 1),
(7, 'Session.database', 'default', 'string', '', 'The DATABASE_CONFIG::$var to use for database session handling.\r\n\r\n''Session.save'' must be set to ''database'' in order to utilize this constant.', 1),
(8, 'Session.timeout', '120', 'integer', '', 'Session time out time (in seconds).\r\nActual value depends on ''Security.level'' setting.', 1),
(9, 'Session.start', 'true', 'bool', 'true,false', 'If set to false, sessions are not automatically started.', 1),
(10, 'Session.checkAgent', 'true', 'bool', 'true,false', 'When set to false, HTTP_USER_AGENT will not be checked in the session', 1),
(11, 'Security.level', 'medium', 'dropdown', 'high,medium,low', 'The level of CakePHP security. The session timeout time defined in ''Session.timeout'' is multiplied according to the settings here.\r\n\r\n''high'' -> Session timeout in ''Session.timeout'' x 10\r\n''medium'' -> Session timeout in ''session.timeout'' x 100\r\n''low'' -> Session timeout in ''Session.timeout'' x 300\r\n\r\nsession IDs are also regenerated between requests if set to high', 1),
(12, 'Session.cookie', 'CAKEPHP', 'string', '', 'The name of the session cookie', 1),
(13, 'Wysiwyg.editor', 'tiny_mce', 'dropdown', 'text,ck_editor,tiny_mce', '<p>Select the wysiwyg editor that you would like to use.</p>', 0),
(14, 'Currency.name', 'Rand', 'string', '', '<p>The name of the default currency</p>', 0),
(15, 'Currency.unit', 'R', 'string', '', 'The unit of the default currency', 0),
(16, 'Language.name', 'English', 'string', '', 'The default language of the site', 0),
(17, 'Language.code', 'En', 'string', '', 'The iso code of the default site language.', 0),
(18, 'Blog.allow_comments', 'true', 'bool', 'true,false', 'Whether to allow comments on the blog or not. If disabled historical comments will not be displayed but will not be deleted.', 0),
(19, 'Cms.allow_comments', 'true', 'bool', 'true,false', 'Whether to allow comments on the cms Content items or not. If disabled historical comments will not be displayed but will not be deleted.', 0),
(20, 'Newsletter.send_count', '200', 'integer', '', 'The number of newsletters to send at a time.', 0),
(21, 'Newsletter.send_interval', '300', 'integer', '', 'The time interval between sending emails in seconds', 0),
(22, 'Newsletter.track_views', 'true', 'bool', 'true,false', 'Attempt to track the number of views a newsletter creates.  works with  a call back to the server.  Needs html to work', 0),
(23, 'Newsletter.send_as', 'both', 'dropdown', 'both,html,text', 'What format to send the newsletter out as. Both is the best option as its nut uncommon for people to only accept text mails.', 0),
(24, 'Website.name', 'Infinitas Cms', 'string', '', '<p>This is the name of the site that will be used in emails and on the website its self</p>', 0),
(25, 'Website.description', 'Infinitas Cms is a open source content management system that is designed to be fast and user friendly, with all the features you need.', 'string', '', 'This is the main description about the site', 0),
(26, 'Cms.auto_redirect', 'true', 'bool', 'true,false', 'When a category has only one content itme should the site automaticaly redirect to that one item of first display the category.\r\n\r\nThis will also work for sections.', 0),
(27, 'Comments.time_limit', '4 weeks', 'string', '', 'the date the comments will stop being available. if it is set to 0 users will always be able to comment on a record.\r\n\r\nit uses strtotime() and will expire after the amount of time you specify. eg: 4 weeks - comments will be disabled 4 weeks after the post was last edited.', 0),
(28, 'Blog.depreciate', '6 months', 'string', '', 'Uses strtotime, after this time the post will be marked as depreciated.  set to 0 to never show this message.', 0),
(29, 'Comments.purge', '4 weeks', 'string', '', 'If set to 0 purge is disabled.  You can also enter a time string used in strtotime() like "4 weeks" and purge will remove comments that pending older than 4 weeks.', 0),
(30, 'Comments.auto_moderate', 'false', 'bool', 'true,false', 'Set this to true for comments to be automaticaly set to active so you do not need to manually moderate them in admin.\r\n\r\nif set to false, comments will need to be activated before they are displayed on the site.', 0),
(31, 'FileManager.base_path', 'z:/www/webroot', 'string', '', '<p>The base path for access to manage files.</p>', 0),
(32, 'Newsletter.send_method', 'smtp', 'dropdown', 'smtp,mail,debug', '<p>This is the method that you would like to send emails with.&nbsp; Smtp requres that you have the correct ports and login details (for servers that require sending authentication ).</p>', 0),
(33, 'Newsletter.smtp_out_going_port', '25', 'integer', '', '<p>The default port is 25 for smtp sending (outgoing mails). If you are having problems sending try findout from your host if there is another port to use.</p>', 0),
(34, 'Newsletter.smtp_timeout', '30', 'integer', '', '<p>Smtp timeout in seconds. If you are getting timeout errors try and up this ammount a bit. The default time is 30 seconds</p>', 0),
(35, 'Newsletter.smtp_host', 'mail.php-dev.co.za', 'string', '', '<p>This is the host address of your smtp server. There is no default. It is normaly something like mail.server.com but can be an ip address.</p>', 0),
(36, 'Newsletter.smtp_username', 'test@php-dev.co.za', 'string', '', '<p>This is your smtp username for authenticating. It is usualy in the form of username@domain.com. If your server does not require outgoing authentication you must leave this blank.</p>', 0),
(37, 'Newsletter.smtp_password', 'test', 'string', '', '<p>This is your password for smtp authentication. It should be left blank if there is no authentication for outgoing mails on your server.</p>', 0),
(38, 'Newsletter.from_name', 'Dogmatic', 'string', '', '<p>This is the name you would like to have as the sender of your mails.. will default to the site name if it is empty.</p>', 0),
(39, 'Newsletter.from_email', 'test@php-dev.co.za', 'string', '', '<p>The email address where your mails come from. This is used as the default when generating mails.</p>', 0),
(40, 'Newsletter.template', 'default', 'string', '', '<p>This is the internal template that is used by the Newsletter plugin to send mails. If you do not know what this is do not edit it.&nbsp; The default template used is &quot;default&quot;.</p>', 0),
(41, 'Global.pagination_select', '5,10,20,50,100', 'string', '', '<p>This is for the options in the pagiantion drop down. Any comma seperated list of integers will be generated in the pagination.</p>\r\n<p>The default is "5,10,20,50,100"</p>', 0),
(42, 'Pagination.nothing_found_message', 'Nothing was found, try a more generic search.', 'string', '', '<p>This is the message that will show at the bottom of a page when there is no resaults.</p>', 0),
(43, 'Blog.allow_ratings', 'true', 'bool', 'true,false', '<p>If you would like people to be able to rate your blog posts enable this option.</p>', 0),
(44, 'Rating.time_limit', '4 weeks', 'string', '', '<p>the date the ratings will stop being available. if it is set to 0 users will always be able to comment on a record. it uses strtotime() and will expire after the amount of time you specify. eg: 4 weeks - ratings will be disabled 4 weeks after the post was last edited.</p>', 0),
(45, 'Comment.fields', 'name,email,website,comment', 'string', '', '<p>A comma seperated list of the fields you should have in your comments. the defaut is &quot;name,email,website,comment&quot;. if you are adding other fields to the comments make sure that the fields are available in the database or the information will not be saved.</p>', 0),
(46, 'Rating.require_auth', 'true', 'bool', 'true,false', '<p>Set to true if you would like only logged in users to be able to rate items.&nbsp; If set to false anybody will be able to rate items. The default setting is true.</p>', 0),
(47, 'Website.blacklist_keywords', 'levitra,viagra,casino,sex,loan,finance,slots,debt,free,interesting,sorry,cool', 'string', '', '<p>A list of comma separated keywords that are used for automatic moderation of comments and reviews.</p>', 0),
(48, 'Website.blacklist_words', '.html,.info,?,&,.de,.pl,.cn', 'string', '', '<p>A list of comma seperated words used to automaticaly moderate comments and reviews on the site.</p>', 0),
(49, 'Reviews.auto_moderate', 'true', 'bool', 'true,false', '<p>Set this to true to alow the reviews to be automaticaly moderated for spam. If set to true the reviews will be cross checked with the data in the blacklisted keywordsconfiguration setting.</p>', 0),
(50, 'Global.pagination_limit', '100', 'integer', '', '<p>This is the maximum number of rows a query will ever return. only used where limits are set. This should stop people from passing params in urls to pull the entire database. Setting this value to 0 will disable and alow any nomber of records to be requested. The default for this setting is 100.</p>', 0),
(51, 'Website.home_page', 'cms', 'dropdown', 'blog,cms,shop', '<p>this is the page visitors to your site will land on when entering your domain directly</p>', 0),
(52, 'Cms.content_layout', 'default', 'string', '', '<p>This is the default layout of your content pages for the cms.&nbsp; Have a look when editing content pages for what is available, you can set any one of the values in the dropdown as the default here.&nbsp; All values must be like &quot;my_layout&quot; and not &quot;My Layout&quot;</p>', 0),
(53, 'Cms.content_title', 'true', 'bool', 'true,false', '<p>This sets if the heading is displayed in the content pages of your cms</p>', 0),
(54, 'Cms.content_title_link', 'true', 'bool', 'true,false', '<p>Set this to true to make the headings links in your content itmes pages</p>', 0),
(55, 'Cms.content_introduction_text', 'true', 'bool', 'true,false', '<p>Display the introduction text when viewing the content pages in your cms</p>', 0),
(56, 'Cms.content_category_title', 'true', 'bool', 'true,false', '<p>This sets if the category name should be displayed in the content items page</p>', 0),
(57, 'Cms.content_category_title_link', 'true', 'bool', 'true,false', '<p>If you have category headings displayed on the content pages this will set if they should be links</p>', 0),
(58, 'Cms.content_rateable', 'true', 'bool', 'true,false', '<p>If this is enabled content will be rateable by users and will display the overall rating for that content item.</p>', 0),
(59, 'Cms.content_commentable', 'true', 'bool', 'true,false', '<p>This sets if users my comment on the content items displayed in the site.</p>', 0),
(60, 'Cms.content_show_created', 'true', 'bool', 'true,false', '<p>If this is set to true the date the article will be displayed on the content items</p>', 0),
(61, 'Cms.content_show_author', 'true', 'bool', 'true,false', '<p>When set to true this will display the author of the article</p>', 0),
(62, 'Cms.content_share', 'true', 'bool', 'true,false', '<p>If this is set to true some social networking links will be available for your users to share your content</p>', 0),
(63, 'Website.read_more', 'Read more...', 'string', '', '<p>This is the text you want to be displayed in read more text.</p>', 0),
(64, 'Website.password_regex', '^(?=.*\\d)(?=.*[a-z])(?=.*[A-Z])(?!.*\\s).{4,8}$', 'string', '', '<p>This is the regex for password validation.&nbsp; the default value is ^(?=.*\\d)(?=.*[a-z])(?=.*[A-Z])(?!.*\\s).{4,8}$ and requires one lower case letter, one upper case letter, one digit, 6-13 length, and no spaces. If you would like to change this, remember to update the Website.password_validation to match or the users will get the wrong message.</p>', 0),
(65, 'Website.password_validation', 'Please enter a password with one lower case letter, one upper case letter, one digit, 6-13 length, and no spaces', 'string', '', '<p>This is the message that is displayed to the user for password validation and is use in conjunction with the Website.password_regex configuration value. Remember to change the regex if you would like a different password type. Also you will need to update the language files if you are using different languages on the site.</p>', 0),
(66, 'Website.empty_select', 'Please select', 'string', '', '<p>This is the default option that you will see on dropdown''s. The default is &quot;Please Select&quot;</p>', 0),
(67, 'CORE.active_options', '{"":"Please Select","0":"Inactive","1":"Active"}', 'array', '', '<p>\r\n	This is just to make selects for active/inactive more consistent.</p>', 1),
(70, 'CORE.core_options', '{"":"Please Select","0":"Extention","1":"Core"} ', 'array', '', '<p>\r\n	This is to egnerate dropdowns for core filter options</p>\r\n', 1),
(71, 'Security.login_attempts', '3', 'integer', '', '<p>\r\n	This is the number of times a user can attempt to login to the system before they are blocked. Once the user is blocked they will not be able to access anything on the site untill the time limit has passed.&nbsp; The time limit is dependent on the number of times the user has been blocked before.</p>\r\n<p>\r\n	<br />\r\n	The blocking is done per ip address so others on the same ip address will be blocked.</p>\r\n', 1),
(72, 'Website.admin_quick_post', 'blog', 'dropdown', 'cms,blog', '<p>\r\n	This is the quick post form you will see on the admin dashboard. Select the one that is better for your needs.</p>', 0);

DROP TABLE IF EXISTS `core_countries`;
CREATE TABLE `core_countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `code` varchar(5) NOT NULL,
  `continent_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `core_countries` (`id`, `name`, `code`, `continent_id`) VALUES
(1, 'South Africa', 'ZAF', 0);

DROP TABLE IF EXISTS `core_feeds`;
CREATE TABLE `core_feeds` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `plugin` int(11) DEFAULT NULL,
  `model` varchar(50) NOT NULL,
  `controller` varchar(100) NOT NULL,
  `action` varchar(100) NOT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `core_groups`;
CREATE TABLE `core_groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `parent_id` int(11) NOT NULL,
  `lft` int(11) NOT NULL,
  `rght` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

INSERT INTO `core_groups` (`id`, `name`, `description`, `created`, `modified`, `parent_id`, `lft`, `rght`) VALUES
(1, 'Administrators', 'Site Administrators', '2010-02-04 16:53:33', '2010-02-04 16:53:33', 0, 1, 2),
(2, 'Users', '', '2010-02-17 23:14:32', '2010-02-17 23:14:32', 0, 3, 4);

DROP TABLE IF EXISTS `core_ip_addresses`;
CREATE TABLE `core_ip_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `times_blocked` smallint(6) NOT NULL DEFAULT '0',
  `unlock_at` datetime DEFAULT NULL,
  `risk` int(11) NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `core_logs`;
CREATE TABLE `core_logs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `model` varchar(100) DEFAULT NULL,
  `model_id` int(11) DEFAULT NULL,
  `action` varchar(50) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `change` text,
  `version_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=57 ;

INSERT INTO `core_logs` (`id`, `title`, `description`, `model`, `model_id`, `action`, `user_id`, `change`, `version_id`, `created`) VALUES
(1, 'Test', 'Category "Test" (1) updated by Management.User "1" (1).', 'Category', 1, 'edit', 1, 'description (<p>This is a test category</p>) => (<p>\r\n	This is a test category test</p>\r\n)', NULL, '2010-02-17 23:57:12'),
(2, 'People', 'MenuItem "People" (82) added by Management.User "1" (1).', 'MenuItem', 82, 'add', 1, 'name () => (People), plugin () => (contact), controller () => (contacts), active () => (1), group_id () => (1), menu_id () => (2), parent_id () => (72), force_backend () => (1), force_frontend () => (0), created () => (2010-02-18 05:17:24)', NULL, '2010-02-18 05:17:24'),
(3, 'People', 'MenuItem "People" (82) updated by Management.User "1" (1).', 'MenuItem', 82, 'edit', 1, 'menu_id (2) => (1)', NULL, '2010-02-18 05:18:52'),
(4, 'Aco (460)', 'Aco (460) added by Management.User "1" (1).', 'Aco', 460, 'add', 1, 'parent_id () => (442), alias () => (Contacts)', NULL, '2010-02-18 06:27:59'),
(5, 'Aco (461)', 'Aco (461) added by Management.User "1" (1).', 'Aco', 461, 'add', 1, 'parent_id () => (460), alias () => (admin_index)', NULL, '2010-02-18 06:27:59'),
(6, 'Aco (462)', 'Aco (462) added by Management.User "1" (1).', 'Aco', 462, 'add', 1, 'parent_id () => (460), alias () => (admin_add)', NULL, '2010-02-18 06:27:59'),
(7, 'Aco (463)', 'Aco (463) added by Management.User "1" (1).', 'Aco', 463, 'add', 1, 'parent_id () => (460), alias () => (admin_edit)', NULL, '2010-02-18 06:27:59'),
(8, 'Aco (464)', 'Aco (464) added by Management.User "1" (1).', 'Aco', 464, 'add', 1, 'parent_id () => (460), alias () => (comment)', NULL, '2010-02-18 06:27:59'),
(9, 'Aco (465)', 'Aco (465) added by Management.User "1" (1).', 'Aco', 465, 'add', 1, 'parent_id () => (460), alias () => (rate)', NULL, '2010-02-18 06:27:59'),
(10, 'Aco (466)', 'Aco (466) added by Management.User "1" (1).', 'Aco', 466, 'add', 1, 'parent_id () => (460), alias () => (admin_reorder)', NULL, '2010-02-18 06:27:59'),
(11, 'Aco (467)', 'Aco (467) added by Management.User "1" (1).', 'Aco', 467, 'add', 1, 'parent_id () => (460), alias () => (admin_delete)', NULL, '2010-02-18 06:27:59'),
(12, 'Aco (468)', 'Aco (468) added by Management.User "1" (1).', 'Aco', 468, 'add', 1, 'parent_id () => (460), alias () => (admin_commentPurge)', NULL, '2010-02-18 06:28:00'),
(13, 'Aco (469)', 'Aco (469) added by Management.User "1" (1).', 'Aco', 469, 'add', 1, 'parent_id () => (460), alias () => (admin_mass)', NULL, '2010-02-18 06:28:00'),
(14, 'Aco (470)', 'Aco (470) added by Management.User "1" (1).', 'Aco', 470, 'add', 1, 'parent_id () => (460), alias () => (admin_buildAcl)', NULL, '2010-02-18 06:28:00'),
(15, 'Aco (471)', 'Aco (471) added by Management.User "1" (1).', 'Aco', 471, 'add', 1, 'parent_id () => (460), alias () => (add)', NULL, '2010-02-18 06:28:00'),
(16, 'Aco (472)', 'Aco (472) added by Management.User "1" (1).', 'Aco', 472, 'add', 1, 'parent_id () => (460), alias () => (edit)', NULL, '2010-02-18 06:28:00'),
(17, 'Aco (473)', 'Aco (473) added by Management.User "1" (1).', 'Aco', 473, 'add', 1, 'parent_id () => (460), alias () => (index)', NULL, '2010-02-18 06:28:00'),
(18, 'Aco (474)', 'Aco (474) added by Management.User "1" (1).', 'Aco', 474, 'add', 1, 'parent_id () => (460), alias () => (view)', NULL, '2010-02-18 06:28:00'),
(19, 'Aco (475)', 'Aco (475) added by Management.User "1" (1).', 'Aco', 475, 'add', 1, 'parent_id () => (460), alias () => (delete)', NULL, '2010-02-18 06:28:00'),
(20, 'Head Office', 'Branch "Head Office" (19) added by Management.User "1" (1).', 'Branch', 19, 'add', 1, 'active () => (1), name () => (Head Office), phone () => (3216549875), address () => (12a some street blah), map () => (http://osm.org/go/k07zlcCm), image () => (admin_login.png), created () => (2010-02-18 07:58:50), ordering () => (1)', NULL, '2010-02-18 07:58:50'),
(21, 'Head Office', 'Branch "Head Office" (1) added by Management.User "1" (1).', 'Branch', 1, 'add', 1, 'active () => (1), name () => (Head Office), phone () => (3216549875), address () => (asdf), map () => (http://osm.org/go/k07zlcCm), image () => (admin_login.png), created () => (2010-02-18 08:03:11), ordering () => (1)', NULL, '2010-02-18 08:03:11'),
(22, 'Head Office', 'Branch "Head Office" (2) added by Management.User "1" (1).', 'Branch', 2, 'add', 1, 'active () => (1), name () => (Head Office), phone () => (3216549875), address () => (asdf), map () => (http://osm.org/go/k07zlcCm), image () => (admin_login.png), created () => (2010-02-18 08:06:38), ordering () => (2)', NULL, '2010-02-18 08:06:38'),
(23, 'Head Office', 'Branch "Head Office" (3) added by Management.User "1" (1).', 'Branch', 3, 'add', 1, 'active () => (1), name () => (Head Office), phone () => (3216549875), address () => (asdf), map () => (http://osm.org/go/k07zlcCm), image () => (admin_login.png), created () => (2010-02-18 08:07:27), ordering () => (1)', NULL, '2010-02-18 08:07:27'),
(24, 'Head Office', 'Branch "Head Office" (3) updated by Management.User "1" (1).', 'Branch', 3, 'edit', 1, 'image (admin_login.png) => (user_manager.png)', NULL, '2010-02-18 08:11:59'),
(25, 'Head Office', 'Branch "Head Office" (3) updated by Management.User "1" (1).', 'Branch', 3, 'edit', 1, 'image (user_manager.png) => (admin_login.png)', NULL, '2010-02-18 08:12:14'),
(26, 'Contact (1)', 'Contact (1) added by Management.User "1" (1).', 'Contact', 1, 'add', 1, 'first_name () => (bob), last_name () => (smith), position () => (boss), phone () => (3216549875), skype () => (bobSmith), branch_id () => (3), active () => (0), image () => (installer_home.png), created () => (2010-02-18 08:21:41), ordering () => (1)', NULL, '2010-02-18 08:21:41'),
(27, 'Contact (2)', 'Contact (2) added by Management.User "1" (1).', 'Contact', 2, 'add', 1, 'first_name () => (asdf), last_name () => (asdf), position () => (asdf), phone () => (3216549875), skype () => (sdf), branch_id () => (3), active () => (1), image () => (installer_home-0.png), created () => (2010-02-18 08:24:13), ordering () => (2)', NULL, '2010-02-18 08:24:13'),
(28, 'Cms SEO- copy ( 2010-02-18 )', 'Route "Cms SEO- copy ( 2010-02-18 )" (23) added by Management.User "1" (1).', 'Route', 23, 'add', 1, 'force_backend () => (0), force_frontend () => (1), order_id () => (1), core () => (0), name () => (Cms SEO- copy ( 2010-02-18 )), url () => (/cms/:category/:id-:slug), plugin () => (cms), controller () => (contents), action () => (view), pass () => (id,slug), rules () => (id:[0-9]+), ordering () => (17), theme_id () => (0), created () => (2010-02-18 18:46:08)', NULL, '2010-02-18 18:46:08'),
(29, 'Contacts Seo', 'Route "Contacts Seo" (23) updated by Management.User "1" (1).', 'Route', 23, 'edit', 1, 'name (Cms SEO- copy ( 2010-02-18 )) => (Contacts Seo), url (/cms/:category/:id-:slug) => (/contact/:branch/:id-:slug), plugin (cms) => (contact), controller (contents) => (contacts), active (0) => (1)', NULL, '2010-02-18 18:46:49'),
(30, 'Contacts Seo- copy ( 2010-02-18 )', 'Route "Contacts Seo- copy ( 2010-02-18 )" (24) added by Management.User "1" (1).', 'Route', 24, 'add', 1, 'force_backend () => (0), force_frontend () => (1), order_id () => (1), core () => (0), name () => (Contacts Seo- copy ( 2010-02-18 )), url () => (/contact/:branch/:id-:slug), plugin () => (contact), controller () => (contacts), action () => (view), pass () => (id,slug), rules () => (id:[0-9]+), ordering () => (18), theme_id () => (0), created () => (2010-02-18 18:47:38)', NULL, '2010-02-18 18:47:38'),
(31, 'Contact - Branches Seo', 'Route "Contact - Branches Seo" (24) updated by Management.User "1" (1).', 'Route', 24, 'edit', 1, 'name (Contacts Seo- copy ( 2010-02-18 )) => (Contact - Branches Seo), url (/contact/:branch/:id-:slug) => (/contact/:id-:slug), controller (contacts) => (branches), active (0) => (1)', NULL, '2010-02-18 18:48:30'),
(32, 'Contact - Contacts Seo', 'Route "Contact - Contacts Seo" (23) updated by Management.User "1" (1).', 'Route', 23, 'edit', 1, 'name (Contacts Seo) => (Contact - Contacts Seo)', NULL, '2010-02-18 18:48:40'),
(33, 'Blog - Posts Seo', 'Route "Blog - Posts Seo" (22) updated by Management.User "1" (1).', 'Route', 22, 'edit', 1, 'name (Blog SEO) => (Blog - Posts Seo)', NULL, '2010-02-18 18:49:20'),
(34, 'Head Office', 'Branch "Head Office" (3) updated by Management.User "1" (1).', 'Branch', 3, 'edit', 1, 'slug () => (head-office)', NULL, '2010-02-18 18:52:16'),
(35, 'Security', 'MenuItem "Security" (83) added by Management.User "1" (1).', 'MenuItem', 83, 'add', 1, 'name () => (Security), plugin () => (management), active () => (1), group_id () => (1), menu_id () => (1), parent_id () => (54), force_backend () => (1), force_frontend () => (0), created () => (2010-02-19 00:50:37)', NULL, '2010-02-19 00:50:37'),
(36, 'Blocked IP''s', 'MenuItem "Blocked IP''s" (84) added by Management.User "1" (1).', 'MenuItem', 84, 'add', 1, 'name () => (Blocked IP''s), plugin () => (management), controller () => (ip_addresses), active () => (1), group_id () => (1), menu_id () => (1), parent_id () => (83), force_backend () => (1), force_frontend () => (0), created () => (2010-02-19 00:52:23)', NULL, '2010-02-19 00:52:23'),
(37, 'Config (71)', 'Config (71) added by Management.User "1" (1).', 'Config', 71, 'add', 1, 'key () => (Security.login_attempts), value () => (3), type () => (integer), core () => (1), description () => (<p>\r\n	This is the number of times a user can attempt to login to the system before they are blocked. Once the user is blocked they will not be able to access anything on the site untill the time limit has passed.&nbsp; The time limit is dependent on the number of times the user has been blocked before.</p>\r\n<p>\r\n	<br />\r\n	The blocking is done per ip address so others on the same ip address will be blocked.</p>\r\n)', NULL, '2010-02-19 02:10:38'),
(38, 'Create Release', 'MenuItem "Create Release" (85) added by Management.User "1" (1).', 'MenuItem', 85, 'add', 1, 'name () => (Create Release), plugin () => (installer), controller () => (releases), active () => (1), group_id () => (1), menu_id () => (1), parent_id () => (64), force_backend () => (1), force_frontend () => (0), created () => (2010-02-19 06:15:56)', NULL, '2010-02-19 06:15:56'),
(39, 'User (1)', 'User (1) updated by Management.User "1" (1).', 'User', 1, 'edit', 1, 'last_login (2010-02-21 00:55:39) => (2010-02-21 00:55:58)', NULL, '2010-02-21 00:55:58'),
(40, 'Config (72)', 'Config (72) added by Management.User "1" (1).', 'Config', 72, 'add', 1, 'key () => (Website.admin_quick_post), value () => (cms), type () => (dropdown), options () => (cms,blog), core () => (0), description () => (<p>\r\n	This is the quick post form you will see on the admin dashboard. Select the one that is better for your needs.</p>\r\n<div firebugversion="1.5.0" id="_firebugConsole" style="display: none;">\r\n	&nbsp;</div>)', NULL, '2010-02-23 20:00:41'),
(41, 'Config (72)', 'Config (72) updated by Management.User "1" (1).', 'Config', 72, 'edit', 1, 'value (cms) => (blog), description (<p>\r\n	This is the quick post form you will see on the admin dashboard. Select the one that is better for your needs.</p>\r\n<div firebugversion="1.5.0" id="_firebugConsole" style="display: none;">\r\n	&nbsp;</div>) => (<p>\r\n	This is the quick post form you will see on the admin dashboard. Select the one that is better for your needs.</p>)', NULL, '2010-02-23 20:12:41'),
(42, 'bob smith', 'Comment "bob smith" (3) deleted by Management.User "1" (1).', 'Comment', 3, 'delete', 1, NULL, NULL, '2010-02-23 22:45:14'),
(43, 'PostsTag (56)', 'PostsTag (56) deleted by Management.User "1" (1).', 'PostsTag', 56, 'delete', 1, NULL, NULL, '2010-02-24 16:11:39'),
(44, 'test', 'Category "test" (6) added by Management.User "1" (1).', 'Category', 6, 'add', 1, 'active () => (0), group_id () => (1), content_count () => (0), title () => (test), parent_id () => (5), description () => (<p>\r\n	test</p>), created () => (2010-02-25 12:13:39), slug () => (test)', NULL, '2010-02-25 12:13:39'),
(45, 'Frontpage (6)', 'Frontpage (6) added by Management.User "1" (1).', 'Frontpage', 6, 'add', 1, 'content_id () => (4), ordering () => (0), order_id () => (1), created () => (2010-02-25 12:15:11)', NULL, '2010-02-25 12:15:11'),
(46, 'Frontpage (5)', 'Frontpage (5) updated by Management.User "1" (1).', 'Frontpage', 5, 'edit', 1, 'ordering () => (3)', NULL, '2010-02-25 12:15:19'),
(47, 'Api', 'MenuItem "Api" (65) updated by Management.User "1" (1).', 'MenuItem', 65, 'edit', 1, 'parent_id (64) => (60)', NULL, '2010-02-25 17:15:15'),
(48, 'Create Release', 'MenuItem "Create Release" (85) updated by Management.User "1" (1).', 'MenuItem', 85, 'edit', 1, 'parent_id (64) => (57)', NULL, '2010-02-25 17:15:45'),
(49, 'Menus', 'MenuItem "Menus" (55) updated by Management.User "1" (1).', 'MenuItem', 55, 'edit', 1, 'parent_id (54) => (1)', NULL, '2010-02-25 21:09:07'),
(50, 'Contacts', 'MenuItem "Contacts" (72) updated by Management.User "1" (1).', 'MenuItem', 72, 'edit', 1, 'parent_id (54) => (1)', NULL, '2010-02-25 21:09:45'),
(51, 'Static Pages', 'MenuItem "Static Pages" (86) added by Management.User "1" (1).', 'MenuItem', 86, 'add', 1, 'name () => (Static Pages), plugin () => (management), controller () => (pages), active () => (1), group_id () => (1), menu_id () => (1), parent_id () => (54), force_backend () => (1), force_frontend () => (0), created () => (2010-02-25 21:10:52)', NULL, '2010-02-25 21:10:52'),
(52, 'User (1)', 'User (1) updated by Management.User "1" (1).', 'User', 1, 'edit', 1, 'last_login (2010-02-25 12:23:23) => (2010-02-26 01:05:31)', NULL, '2010-02-26 01:05:31'),
(53, 'Config (13)', 'Config (13) updated by Management.User "1" (1).', 'Config', 13, 'edit', 1, 'value (ckEditor) => (text), description (Select the wysiwyg editor that you would like to use.) => (<p>\r\n	Select the wysiwyg editor that you would like to use.</p>\r\n)', NULL, '2010-02-26 01:47:08'),
(54, 'Config (13)', 'Config (13) updated by Management.User "1" (1).', 'Config', 13, 'edit', 1, 'value (text) => (tiny_mce)', NULL, '2010-02-26 01:51:26'),
(55, 'Config (13)', 'Config (13) updated by Management.User "1" (1).', 'Config', 13, 'edit', 1, 'value (tiny_mce) => (ck_editor), description (<p>\r\n	Select the wysiwyg editor that you would like to use.</p>\r\n) => (<p>Select the wysiwyg editor that you would like to use.</p>)', NULL, '2010-02-26 01:51:54'),
(56, 'Config (13)', 'Config (13) updated by Management.User "1" (1).', 'Config', 13, 'edit', 1, 'value (ck_editor) => (tiny_mce)', NULL, '2010-02-26 02:15:46');

DROP TABLE IF EXISTS `core_menus`;
CREATE TABLE `core_menus` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `item_count` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_index` (`type`,`active`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

INSERT INTO `core_menus` (`id`, `name`, `type`, `item_count`, `active`, `created`, `modified`) VALUES
(1, 'Admin Menu', 'core_admin', 0, 1, '2010-01-27 18:07:51', '2010-01-27 18:07:51'),
(2, 'Main User Menu', 'main_menu', 0, 1, '2010-02-01 00:35:47', '2010-02-01 00:35:47');

DROP TABLE IF EXISTS `core_menu_items`;
CREATE TABLE `core_menu_items` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `slug` varchar(200) NOT NULL,
  `link` varchar(255) NOT NULL,
  `prefix` varchar(50) NOT NULL,
  `plugin` varchar(100) NOT NULL,
  `controller` varchar(100) NOT NULL,
  `action` varchar(100) NOT NULL,
  `params` varchar(255) NOT NULL,
  `force_backend` tinyint(1) NOT NULL DEFAULT '0',
  `force_frontend` tinyint(1) NOT NULL DEFAULT '0',
  `class` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `menu_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `lft` int(11) NOT NULL,
  `rght` int(11) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menuItems_groupIndex` (`group_id`),
  KEY `menuItems_menuIndex` (`menu_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=87 ;

INSERT INTO `core_menu_items` (`id`, `name`, `slug`, `link`, `prefix`, `plugin`, `controller`, `action`, `params`, `force_backend`, `force_frontend`, `class`, `active`, `menu_id`, `group_id`, `parent_id`, `lft`, `rght`, `created`, `modified`) VALUES
(1, 'Site', 'dashboard', '', '', 'management', 'management', 'dashboard', '', 1, 0, '', 1, 1, 1, 0, 1, 18, '2010-01-27 18:07:51', '2010-01-28 14:44:49'),
(2, 'Blog', 'blog', '', '', 'blog', 'posts', 'dashboard', '', 1, 0, '', 1, 1, 1, 0, 19, 44, '2010-01-27 18:07:51', '2010-01-28 18:07:26'),
(3, 'Posts', 'blog-index', '', '', 'blog', 'posts', 'index', '', 1, 0, '', 1, 1, 1, 2, 28, 37, '2010-01-27 18:07:51', '2010-01-28 18:08:09'),
(5, 'Configuration', '', '', '', 'management', 'configs', '', '', 1, 0, '', 1, 1, 1, 1, 2, 3, '2010-01-28 14:46:38', '2010-02-10 20:12:50'),
(6, 'File Manager', '', '', '', 'filemanager', 'file_manager', '', '', 1, 0, '', 1, 1, 1, 54, 124, 125, '2010-01-28 14:50:05', '2010-01-28 18:24:24'),
(7, 'Menu Items', '', '', '', 'management', 'menuItems', '', '', 1, 0, '', 1, 1, 1, 55, 11, 12, '2010-01-28 16:20:12', '2010-01-28 18:22:02'),
(8, 'Routes', '', '', '', 'management', 'routes', '', '', 1, 0, '', 1, 1, 1, 54, 126, 127, '2010-01-28 16:24:35', '2010-01-28 18:24:46'),
(9, 'Themes', '', '', '', 'management', 'themes', '', '', 1, 0, '', 1, 1, 1, 54, 128, 129, '2010-01-28 16:24:54', '2010-01-28 18:25:05'),
(10, 'Modules', '', '', '', 'management', 'modules', '', '', 1, 0, '', 1, 1, 1, 54, 130, 131, '2010-01-28 16:25:19', '2010-01-28 18:25:17'),
(11, 'Tags', '', '', '', 'blog', 'tags', '', '', 1, 0, '', 1, 1, 1, 2, 38, 41, '2010-01-28 16:27:12', '2010-01-28 16:27:12'),
(12, 'Cms', '', '', '', 'cms', 'categories', 'dashboard', '', 1, 0, '', 1, 1, 1, 0, 45, 88, '2010-01-28 16:27:44', '2010-01-28 16:27:44'),
(13, 'Categories', '', '', '', 'cms', 'categories', '', '', 1, 0, '', 1, 1, 1, 12, 46, 55, '2010-01-28 16:28:23', '2010-01-28 16:28:23'),
(14, 'Contents', '', '', '', 'cms', 'contents', '', '', 1, 0, '', 1, 1, 1, 12, 56, 65, '2010-01-28 16:28:50', '2010-01-28 16:30:03'),
(15, 'Front Page Items', '', '', '', 'cms', 'frontpages', '', '', 1, 0, '', 1, 1, 1, 12, 66, 71, '2010-01-28 16:31:16', '2010-01-28 16:31:16'),
(16, 'Comments', '', '', '', 'management', 'comments', 'index', 'class:Cms', 1, 0, '', 1, 1, 1, 12, 72, 77, '2010-01-28 16:31:50', '2010-01-28 16:32:17'),
(19, 'Backup Categories', '', '', '', 'backup', 'backups', 'backup', 'p:cms/m:category', 1, 0, '', 1, 1, 1, 13, 47, 48, '2010-01-28 16:36:02', '2010-01-28 16:44:42'),
(20, 'Backup Contents', '', '', '', 'backup', 'backups', 'backup', 'p:cms/m:content', 1, 0, '', 1, 1, 1, 14, 57, 58, '2010-01-28 16:36:42', '2010-01-28 16:44:31'),
(21, 'Backup Front Pages', '', '', '', 'backup', 'backups', 'backup', 'p:cms/m:frontPages', 1, 0, '', 1, 1, 1, 15, 67, 68, '2010-01-28 16:45:51', '2010-01-28 16:45:51'),
(22, 'Active', '', '', '', 'cms', 'categories', 'index', 'Category.active:1', 1, 0, '', 1, 1, 1, 13, 49, 50, '2010-01-28 16:52:56', '2010-01-28 16:52:56'),
(23, 'Pending', '', '', '', 'cms', 'categories', 'index', 'Category.active:0', 1, 0, '', 1, 1, 1, 13, 51, 52, '2010-01-28 16:53:50', '2010-01-28 16:53:50'),
(24, 'New', '', '', '', 'cms', 'categories', 'add', '', 1, 0, '', 1, 1, 1, 13, 53, 54, '2010-01-28 16:54:06', '2010-01-28 16:54:06'),
(25, 'Active', '', '', '', 'cms', 'contents', 'index', 'Content.active:1', 1, 0, '', 1, 1, 1, 14, 59, 60, '2010-01-28 16:55:44', '2010-01-28 16:55:44'),
(26, 'Pending', '', '', '', 'cms', 'contents', 'index', 'Content.active:0', 1, 0, '', 1, 1, 1, 14, 61, 62, '2010-01-28 16:56:27', '2010-01-28 16:56:27'),
(27, 'New', '', '', '', 'cms', 'contents', 'add', '', 1, 0, '', 1, 1, 1, 14, 63, 64, '2010-01-28 16:56:44', '2010-01-28 16:56:44'),
(28, 'New', '', '', '', 'cms', 'frontpages', 'add', '', 1, 0, '', 1, 1, 1, 15, 69, 70, '2010-01-28 16:57:26', '2010-01-28 16:57:26'),
(29, 'Featured Pages', '', '', '', 'cms', 'features', '', '', 1, 0, '', 1, 1, 1, 12, 82, 85, '2010-01-28 16:58:02', '2010-01-28 16:58:02'),
(30, 'New', '', '', '', 'cms', 'features', 'add', '', 1, 0, '', 1, 1, 1, 29, 83, 84, '2010-01-28 16:58:27', '2010-01-28 16:58:27'),
(31, 'Pending', '', '', '', 'management', 'comments', 'index', 'Comment.class:Cms,Comment.active:0', 1, 0, '', 1, 1, 1, 16, 75, 76, '2010-01-28 17:00:50', '2010-01-28 17:03:24'),
(32, 'Accept All', '', '', '', 'management', 'comments', 'accept', 'Comment.class:Cms', 1, 0, '', 1, 1, 1, 16, 73, 74, '2010-01-28 17:03:00', '2010-01-28 17:03:00'),
(33, 'Active', '', '', '', 'blog', 'posts', 'index', 'Post.active:1', 1, 0, '', 1, 1, 1, 3, 29, 30, '2010-01-28 17:26:26', '2010-01-28 17:26:26'),
(34, 'Pending', '', '', '', 'blog', 'posts', 'index', 'Post.active:0', 1, 0, '', 1, 1, 1, 3, 31, 32, '2010-01-28 17:26:45', '2010-01-28 17:26:45'),
(35, 'New', '', '', '', 'blog', 'posts', 'add', '', 1, 0, '', 1, 1, 1, 3, 33, 34, '2010-01-28 17:27:12', '2010-01-28 17:27:12'),
(36, 'Backup', '', '', '', 'backup', 'backups', 'backup', 'p:blog/m:post', 1, 0, '', 1, 1, 1, 3, 35, 36, '2010-01-28 17:27:50', '2010-01-28 17:27:50'),
(37, 'Clean Up', '', '', '', 'blog', 'tags', 'clean_up', '', 1, 0, '', 1, 1, 1, 11, 39, 40, '2010-01-28 17:29:03', '2010-01-28 17:29:03'),
(38, 'Newsletter', '', '', '', 'newsletter', 'newsletters', 'dashboard', '', 1, 0, '', 1, 1, 1, 0, 89, 122, '2010-01-28 17:30:25', '2010-01-28 17:31:34'),
(39, 'Templates', '', '', '', 'newsletter', 'templates', '', '', 1, 0, '', 1, 1, 1, 38, 90, 95, '2010-01-28 17:33:17', '2010-01-28 17:33:17'),
(40, 'Campaigns', '', '', '', 'newsletter', 'campaigns', '', '', 1, 0, '', 1, 1, 1, 38, 96, 105, '2010-01-28 17:33:37', '2010-01-28 17:33:37'),
(41, 'Newsletters', '', '', '', 'newsletter', 'newsletters', '', '', 1, 0, '', 1, 1, 1, 38, 106, 119, '2010-01-28 17:33:51', '2010-01-28 17:33:51'),
(42, 'New', '', '', '', 'newsletter', 'templates', 'add', '', 1, 0, '', 1, 1, 1, 39, 91, 92, '2010-01-28 17:35:29', '2010-01-28 17:35:29'),
(43, 'Active', '', '', '', 'newsletter', 'campaigns', 'index', 'Campaign.active:1', 1, 0, '', 1, 1, 1, 40, 97, 98, '2010-01-28 17:36:14', '2010-01-28 17:36:14'),
(44, 'Pending', '', '', '', 'newsletter', 'campaigns', 'index', 'Campaign.active:0', 1, 0, '', 1, 1, 1, 40, 99, 100, '2010-01-28 17:36:26', '2010-01-28 17:36:26'),
(45, 'New', '', '', '', 'newsletter', 'campaigns', 'add', '', 1, 0, '', 1, 1, 1, 40, 101, 102, '2010-01-28 17:36:43', '2010-01-28 17:36:43'),
(46, 'Active', '', '', '', 'newsletter', 'newsletters', 'index', 'Newsletter.active:1', 1, 0, '', 1, 1, 1, 41, 107, 108, '2010-01-28 17:57:04', '2010-01-28 17:57:04'),
(47, 'Pending', '', '', '', 'newsletter', 'newsletters', 'index', 'Newsletter.active:0', 1, 0, '', 1, 1, 1, 41, 109, 110, '2010-01-28 17:57:22', '2010-01-28 17:57:22'),
(48, 'Sending', '', '', '', 'newsletter', 'newsletters', 'index', 'Newsletter.active:1/Newsletter.sent:0', 1, 0, '', 1, 1, 1, 41, 111, 112, '2010-01-28 17:58:17', '2010-01-28 17:58:17'),
(49, 'Sent', '', '', '', 'newsletter', 'newsletters', 'index', 'Newsletter.sent:1', 1, 0, '', 1, 1, 1, 41, 113, 114, '2010-01-28 17:58:35', '2010-01-28 17:58:35'),
(50, 'New', '', '', '', 'newsletter', 'newsletters', 'add', '', 1, 0, '', 1, 1, 1, 41, 115, 116, '2010-01-28 17:58:45', '2010-01-28 17:58:45'),
(51, 'Backup', '', '', '', 'backup', 'backups', 'backup', 'p:newsletter/m:template', 1, 0, '', 1, 1, 1, 39, 93, 94, '2010-01-28 18:02:29', '2010-01-28 18:02:29'),
(52, 'Backup', '', '', '', 'backup', 'backups', 'backup', 'p:newsletter/m:campaign', 1, 0, '', 1, 1, 1, 40, 103, 104, '2010-01-28 18:02:37', '2010-01-28 18:04:07'),
(53, 'Backup', '', '', '', 'backup', 'backups', 'backup', 'p:newsletter/m:newsletter', 1, 0, '', 1, 1, 1, 41, 117, 118, '2010-01-28 18:02:55', '2010-01-28 18:02:55'),
(54, 'Management', '', '', '', 'management', 'management', 'dashboard', '', 1, 0, '', 1, 1, 1, 0, 123, 140, '2010-01-28 18:20:54', '2010-01-28 18:20:54'),
(55, 'Menus', '', '', '', 'management', 'menus', 'index', '', 1, 0, '', 1, 1, 1, 1, 10, 13, '2010-01-28 18:21:43', '2010-02-25 21:09:07'),
(56, 'Configuration', '', '', '', 'management', 'configs', 'index', 'Config.key:Blog', 1, 0, '', 1, 1, 1, 2, 42, 43, '2010-01-28 18:23:13', '2010-01-28 18:23:59'),
(57, 'Installer', '', '', '', 'installer', 'install', 'dashboard', '', 1, 0, '', 1, 1, 1, 58, 142, 145, '2010-01-28 18:37:06', '2010-01-28 18:39:35'),
(58, 'Extentions', '', '', '', '', '', '', '', 1, 0, '', 1, 1, 1, 0, 141, 146, '2010-01-28 18:38:23', '2010-01-28 18:38:23'),
(59, 'Users', '', '', '', 'management', 'users', '', '', 1, 0, '', 1, 1, 1, 1, 4, 9, '2010-01-29 11:12:36', '2010-01-29 11:12:36'),
(60, 'Help', '', '', '', '', '', '', '', 1, 0, '', 1, 1, 1, 0, 147, 154, '2010-01-29 14:02:00', '2010-01-29 14:02:00'),
(62, 'Infinitas', '', 'http://infinitas-cms.org', '', '', '', '', '', 0, 0, '', 1, 1, 1, 60, 148, 149, '2010-01-29 14:03:40', '2010-01-29 14:09:03'),
(63, 'Git Repo', '', 'http://github.com/infinitas/infinitas', '', '', '', '', '', 0, 0, '', 1, 1, 1, 60, 150, 151, '2010-01-29 14:09:46', '2010-01-29 15:43:03'),
(65, 'Api', '', '', '', 'api_generator', 'apiClasses', 'index', '', 0, 1, '', 1, 1, 0, 60, 152, 153, '2010-01-29 15:45:26', '2010-02-25 17:15:15'),
(66, 'Home', '', '/', '', '', '', '', '', 0, 1, '', 1, 2, 0, 0, 157, 158, '2010-02-01 00:38:17', '2010-02-01 02:04:39'),
(67, 'Blog', '', '', '', 'blog', 'posts', 'index', '', 0, 1, '', 1, 2, 0, 0, 159, 160, '2010-02-01 00:39:54', '2010-02-01 02:04:04'),
(68, 'Cms', '', '', '', 'cms', 'frontpages', 'index', '', 0, 1, '', 1, 2, 0, 0, 161, 166, '2010-02-01 00:40:18', '2010-02-01 02:03:32'),
(69, 'Register', '', '', '', 'management', 'users', 'register', '', 0, 1, '', 1, 2, 0, 0, 167, 168, '2010-02-02 22:59:25', '2010-02-02 22:59:25'),
(70, 'Logout', '', '', '', 'management', 'users', 'logout', '', 0, 1, '', 1, 1, 0, 0, 169, 170, '2010-02-04 21:07:20', '2010-02-04 21:07:20'),
(71, 'Contact', '', '', '', 'contact', 'branches', '', '', 0, 1, '', 1, 2, 0, 0, 171, 172, '2010-02-10 18:10:06', '2010-02-10 18:10:06'),
(72, 'Contacts', '', '', '', 'contact', 'branches', '', '', 1, 0, '', 1, 1, 1, 1, 14, 17, '2010-02-10 18:10:39', '2010-02-25 21:09:45'),
(73, 'Categories', '', '', '', 'blog', 'categories', '', '', 1, 0, '', 1, 1, 1, 2, 20, 27, '2010-02-10 20:02:59', '2010-02-10 20:02:59'),
(74, 'Active', '', '', '', 'blog', 'categories', 'index', 'Category.active:1', 1, 0, '', 1, 1, 1, 73, 21, 22, '2010-02-10 20:03:53', '2010-02-10 20:03:53'),
(75, 'Disabled', '', '', '', 'blog', 'categories', 'index', 'Category.active:0', 1, 0, '', 1, 1, 1, 73, 23, 24, '2010-02-10 20:04:12', '2010-02-10 20:04:12'),
(76, 'Add', '', '', '', 'blog', 'categories', 'add', '', 1, 0, '', 1, 1, 1, 73, 25, 26, '2010-02-10 20:04:30', '2010-02-10 20:04:30'),
(77, 'Global Unlock', '', '', '', 'management', 'locks', '', '', 1, 0, '', 1, 1, 1, 54, 132, 133, '2010-02-11 00:10:23', '2010-02-11 00:10:23'),
(78, 'Configuration', '', '', '', 'management', 'configs', 'index', 'Config.key:Cms', 1, 0, '', 1, 1, 1, 12, 86, 87, '2010-02-15 23:52:45', '2010-02-15 23:52:45'),
(79, 'Configuration', '', '', '', 'management', 'configs', 'index', 'Config.key:Newsletter', 1, 0, '', 1, 1, 1, 38, 120, 121, '2010-02-15 23:53:24', '2010-02-15 23:53:24'),
(80, 'Current visitors', '', '', '', 'management', 'users', 'logged_in', '', 1, 0, '', 1, 1, 1, 59, 7, 8, '2010-02-17 17:33:24', '2010-02-17 17:33:24'),
(81, 'Groups', '', '', '', 'management', 'groups', '', '', 1, 0, '', 1, 1, 1, 59, 5, 6, '2010-02-17 22:50:30', '2010-02-17 22:50:30'),
(82, 'People', '', '', '', 'contact', 'contacts', '', '', 1, 0, '', 1, 1, 1, 72, 15, 16, '2010-02-18 05:17:24', '2010-02-18 05:18:52'),
(83, 'Security', '', '', '', 'management', '', '', '', 1, 0, '', 1, 1, 1, 54, 134, 137, '2010-02-19 00:50:37', '2010-02-19 00:50:37'),
(84, 'Blocked IP''s', '', '', '', 'management', 'ip_addresses', '', '', 1, 0, '', 1, 1, 1, 83, 135, 136, '2010-02-19 00:52:23', '2010-02-19 00:52:23'),
(85, 'Create Release', '', '', '', 'installer', 'releases', '', '', 1, 0, '', 1, 1, 1, 57, 143, 144, '2010-02-19 06:15:56', '2010-02-25 17:15:45'),
(86, 'Static Pages', '', '', '', 'management', 'pages', '', '', 1, 0, '', 1, 1, 1, 54, 138, 139, '2010-02-25 21:10:52', '2010-02-25 21:10:52');

DROP TABLE IF EXISTS `core_modules`;
CREATE TABLE `core_modules` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `module` varchar(100) NOT NULL,
  `config` text,
  `theme_id` int(11) NOT NULL DEFAULT '0',
  `position_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `locked` tinyint(1) NOT NULL,
  `locked_by` int(11) DEFAULT NULL,
  `locked_since` int(11) DEFAULT NULL,
  `show_heading` tinyint(1) NOT NULL DEFAULT '1',
  `core` tinyint(1) NOT NULL DEFAULT '0',
  `author` varchar(50) DEFAULT NULL,
  `licence` varchar(75) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `update_url` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

INSERT INTO `core_modules` (`id`, `name`, `content`, `module`, `config`, `theme_id`, `position_id`, `group_id`, `ordering`, `admin`, `active`, `locked`, `locked_by`, `locked_since`, `show_heading`, `core`, `author`, `licence`, `url`, `update_url`, `created`, `modified`) VALUES
(2, 'login', '', 'login', '', 0, 4, 1, 2, 0, 0, 0, NULL, NULL, 1, 0, 'Infinitas', 'MIT', 'http://www.i-project.co.za', '', '2010-01-19 00:30:53', '2010-02-01 01:22:16'),
(4, 'Popular Posts', '', 'popular_posts', '', 0, 5, 1, 1, 0, 0, 0, NULL, NULL, 1, 0, 'Infinitas', 'MIT', 'http://www.i-project.co.za', '', '2010-01-19 00:58:20', '2010-01-19 00:58:20'),
(5, 'search', '', 'search', '', 0, 12, 1, 1, 0, 0, 0, NULL, NULL, 0, 1, 'Infinitas', '', 'http://www.i-project.co.za', '', '2010-01-19 11:22:09', '2010-01-19 14:44:49'),
(7, 'Latest News', '', 'latest_news', '', 0, 3, 1, 1, 0, 1, 0, NULL, NULL, 1, 0, 'Infinitas', 'MIT', 'http://www.i-project.co.za', '', '2010-01-19 11:40:45', '2010-01-19 11:40:45'),
(9, 'Latest Tweets', '', 'twitter_tweets', '', 0, 3, 1, 2, 0, 0, 0, NULL, NULL, 0, 1, 'Infinitas', 'MIT', 'http://www.infinitas-cms.org', '', '2010-01-21 19:23:37', '2010-01-21 20:46:54'),
(10, 'Twitter News', '', 'twitter_search', '', 0, 4, 1, 1, 0, 0, 0, NULL, NULL, 0, 1, 'Infinitas', 'MIT', 'http://www.infinitas-cms.org', '', '2010-01-21 19:50:17', '2010-02-08 01:46:56'),
(11, 'Infinitas Users', '<div style="padding-top:10px"><script type="text/javascript" src="http://www.ohloh.net/p/442724/widgets/project_users.js?style=blue"></script></div>', '', '', 0, 4, 1, 3, 0, 1, 0, NULL, NULL, 0, 0, 'Infinitas', 'MIT', 'http://infinitas-cms.org', '', '2010-01-21 20:02:55', '2010-02-08 01:59:04'),
(12, 'Admin Menu', '', 'menu', '{"menu":"core_admin"}', 0, 1, 1, 1, 1, 1, 0, NULL, NULL, 0, 1, 'Infinitas', 'MIT', 'http://infinitas-cms.org', '', '2010-01-27 18:14:16', '2010-02-08 01:46:29'),
(13, 'Frontend Menu', '', 'main_menu', '{"menu":"main_menu"}', 0, 1, 1, 2, 0, 1, 0, NULL, NULL, 0, 1, 'Infinitas', 'MIT', 'http://infinitas-cms.org', '', '2010-02-01 00:57:01', '2010-02-08 01:46:36'),
(14, 'Tag Cloud', '', 'post_tag_cloud', '', 0, 4, 2, 4, 0, 1, 0, NULL, NULL, 1, 1, 'Infinitas', 'MIT', 'http://infinitas-cms.org', '', '2010-02-01 16:01:01', '2010-02-08 01:59:13'),
(15, 'Post Dates', '', 'post_dates', '', 0, 4, 2, 5, 0, 1, 0, NULL, NULL, 1, 1, 'Infinitas', 'MIT', 'http://infinitas-cms.org', '', '2010-02-01 16:34:00', '2010-02-08 01:59:22'),
(16, 'Google analytics', '', 'google_analytics', '{"code":"UA-xxxxxxxx-x"}', 0, 2, 2, 1, 0, 1, 0, NULL, NULL, 0, 1, 'Infinitas', 'MIT', 'http://infinitas-cms.org', '', '2010-02-01 20:45:05', '2010-02-17 23:44:56');

DROP TABLE IF EXISTS `core_modules_routes`;
CREATE TABLE `core_modules_routes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `module_id` int(11) NOT NULL,
  `route_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;

INSERT INTO `core_modules_routes` (`id`, `module_id`, `route_id`) VALUES
(10, 4, 0),
(13, 7, 0),
(17, 5, 0),
(21, 9, 7),
(24, 13, 0),
(25, 2, 7),
(26, 2, 8),
(27, 2, 9),
(28, 10, 0);

DROP TABLE IF EXISTS `core_module_positions`;
CREATE TABLE `core_module_positions` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

INSERT INTO `core_module_positions` (`id`, `name`, `created`, `modified`) VALUES
(1, 'top', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(2, 'bottom', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(3, 'left', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(4, 'right', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(5, 'custom1', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(6, 'custom2', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(7, 'custom3', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(8, 'custom4', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(9, 'bread_crumbs', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(10, 'debug', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(11, 'feeds', '2010-01-18 21:45:23', '2010-01-18 21:45:23'),
(12, 'search', '2010-01-18 21:45:23', '2010-01-18 21:45:23');

DROP TABLE IF EXISTS `core_ratings`;
CREATE TABLE `core_ratings` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `class` varchar(100) NOT NULL,
  `foreign_id` int(11) NOT NULL,
  `rating` int(3) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

INSERT INTO `core_ratings` (`id`, `class`, `foreign_id`, `rating`, `user_id`, `ip`, `created`) VALUES
(1, 'Blog.Post', 5, 4, 12, '::123', '2010-02-10 16:27:07'),
(2, 'Blog.Post', 5, 3, 12, '::11', '2010-02-10 16:29:47'),
(3, 'Blog.Post', 5, 1, 121, '::1', '2010-02-10 16:30:31'),
(4, 'Blog.Post', 5, 1, 1, '::1', '2010-02-10 16:30:58');

DROP TABLE IF EXISTS `core_routes`;
CREATE TABLE `core_routes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `core` tinyint(1) NOT NULL,
  `name` varchar(50) NOT NULL,
  `url` varchar(255) NOT NULL,
  `prefix` varchar(100) DEFAULT NULL,
  `plugin` varchar(50) DEFAULT NULL,
  `controller` varchar(50) DEFAULT NULL,
  `action` varchar(50) DEFAULT NULL,
  `values` text NOT NULL,
  `pass` varchar(100) DEFAULT NULL,
  `rules` text NOT NULL,
  `force_backend` tinyint(1) NOT NULL DEFAULT '0',
  `force_frontend` tinyint(1) NOT NULL DEFAULT '0',
  `order_id` int(11) NOT NULL DEFAULT '1',
  `ordering` int(11) NOT NULL,
  `theme_id` int(11) DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;

INSERT INTO `core_routes` (`id`, `core`, `name`, `url`, `prefix`, `plugin`, `controller`, `action`, `values`, `pass`, `rules`, `force_backend`, `force_frontend`, `order_id`, `ordering`, `theme_id`, `active`, `created`, `modified`) VALUES
(7, 0, 'Home Page', '/', '', 'cms', 'frontpages', '', '', '', '', 0, 0, 1, 2, 0, 1, '2010-01-13 16:50:39', '2010-01-20 17:45:43'),
(8, 0, 'Pages', '/pages/*', '', '0', 'pages', 'display', '', '', '', 0, 0, 1, 3, 4, 1, '2010-01-13 18:26:36', '2010-01-14 00:38:53'),
(9, 0, 'Admin Home', '/admin', 'admin', 'management', 'management', 'dashboard', '', NULL, '', 1, 0, 1, 4, NULL, 1, '2010-01-13 18:36:50', '2010-01-13 18:36:50'),
(11, 0, 'Management Home', '/admin/management', 'admin', 'management', 'management', 'dashboard', '', NULL, '', 1, 0, 1, 6, NULL, 1, '2010-01-13 18:40:23', '2010-01-13 18:42:53'),
(12, 0, 'Blog Home - Backend', '/admin/blog', 'admin', 'blog', 'posts', 'dashboard', '', NULL, '', 1, 0, 1, 7, NULL, 1, '2010-01-13 18:45:23', '2010-01-13 19:02:17'),
(13, 0, 'Blog Home - Frontend', '/blog', '', 'blog', 'posts', '', '', NULL, '', 0, 1, 1, 8, NULL, 1, '2010-01-13 18:47:07', '2010-01-13 19:10:00'),
(14, 0, 'Cms Home - Backend', '/admin/cms', 'admin', 'cms', 'categories', 'dashboard', '', NULL, '', 1, 0, 1, 9, NULL, 1, '2010-01-13 19:01:14', '2010-01-13 19:04:59'),
(15, 0, 'Cms Home - Frontend', '/cms', '', 'cms', 'frontpages', '', '', '', '', 0, 1, 1, 10, 0, 1, '2010-01-13 19:05:28', '2010-01-18 01:40:23'),
(16, 0, 'Newsletter Home - Backend', '/admin/newsletter', 'admin', 'newsletter', 'newsletters', 'dashboard', '', NULL, '', 1, 0, 1, 12, NULL, 1, '2010-01-13 19:18:16', '2010-01-18 01:35:56'),
(18, 0, 'Blog Test', '/p/:year/:month/:day', '', 'blog', 'posts', '', 'day:null', NULL, 'year:[12][0-9]{3}\r\nmonth:0[1-9]|1[012]\r\nday:0[1-9]|[12][0-9]|3[01]\r\n', 0, 1, 1, 13, 1, 1, '2010-01-13 19:36:31', '2010-01-18 01:35:41'),
(19, 0, 'Cms SEO', '/cms/:category/:id-:slug', '', 'cms', 'contents', 'view', '', 'id,slug', 'id:[0-9]+', 0, 1, 1, 11, 0, 1, '2010-01-18 01:35:21', '2010-01-18 02:09:17'),
(20, 0, 'Login', '/login', '', 'management', 'users', 'login', '', '', '', 0, 0, 1, 14, 0, 1, '2010-02-04 21:05:36', '2010-02-04 21:05:36'),
(21, 0, 'Logout', '/logout', '', 'management', 'users', 'logout', '', '', '', 0, 0, 1, 15, 0, 1, '2010-02-04 21:05:49', '2010-02-04 21:06:23'),
(22, 0, 'Blog - Posts Seo', '/blog/:category/:id-:slug', '', 'blog', 'posts', 'view', '', 'id,slug', 'id:[0-9]+', 0, 1, 1, 16, 0, 1, '2010-02-10 16:49:30', '2010-02-18 18:49:20'),
(23, 0, 'Contact - Contacts Seo', '/contact/:branch/:id-:slug', '', 'contact', 'contacts', 'view', '', 'id,slug', 'id:[0-9]+', 0, 1, 1, 17, 0, 1, '2010-02-18 18:46:08', '2010-02-18 18:48:40'),
(24, 0, 'Contact - Branches Seo', '/contact/:id-:slug', '', 'contact', 'branches', 'view', '', 'id,slug', 'id:[0-9]+', 0, 1, 1, 18, 0, 1, '2010-02-18 18:47:38', '2010-02-18 18:48:30');

DROP TABLE IF EXISTS `core_schema_migrations`;
CREATE TABLE `core_schema_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `core_schema_migrations` (`id`, `version`, `type`, `created`) VALUES
(1, 1, 'migrations', '2010-02-19 16:58:51');

DROP TABLE IF EXISTS `core_sessions`;
CREATE TABLE `core_sessions` (
  `id` varchar(40) NOT NULL,
  `data` text,
  `expires` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `core_sessions` (`id`, `data`, `expires`) VALUES
('p18mrsor8m2r01ra6tsm6lddt5', 'Config|a:3:{s:9:"userAgent";s:32:"b02e133c99f39b64ac6822017b648dfa";s:4:"time";i:1267157038;s:7:"timeout";i:10;}Infinitas|a:1:{s:8:"Security";a:1:{s:10:"ip_checked";b:1;}}_Token|s:179:"a:5:{s:3:"key";s:40:"96edaa810b30c8f29fdfec0fb0b0c7a5098fe7b6";s:7:"expires";i:1267151038;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";Message|a:0:{}Auth|a:1:{s:4:"User";a:16:{s:2:"id";s:1:"1";s:10:"ip_address";s:3:"::1";s:10:"last_login";s:19:"2010-02-25 12:23:23";s:8:"modified";s:19:"2010-02-04 16:54:48";s:7:"browser";s:11:"Mozilla 5.0";s:16:"operating_system";s:10:"Windows NT";s:7:"country";s:7:"Unknown";s:4:"city";s:4:"TODO";s:9:"is_mobile";s:1:"0";s:8:"username";s:5:"admin";s:5:"email";s:15:"admin@admin.com";s:8:"birthday";s:10:"2010-02-04";s:6:"active";s:1:"1";s:8:"group_id";s:1:"1";s:10:"last_click";N;s:7:"created";s:19:"2010-02-04 16:54:48";}}', 1267157039);

DROP TABLE IF EXISTS `core_themes`;
CREATE TABLE `core_themes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` text,
  `author` varchar(150) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `update_url` varchar(255) DEFAULT NULL,
  `licence` varchar(100) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `core` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

INSERT INTO `core_themes` (`id`, `name`, `description`, `author`, `url`, `update_url`, `licence`, `active`, `core`, `created`, `modified`) VALUES
(1, 'default', 'This is the default infinitas theme', 'Infinitas', NULL, NULL, '', 0, 1, '2010-01-14 01:39:54', '2010-01-14 01:39:57'),
(2, 'terrafirma', NULL, '', NULL, NULL, '', 0, 0, NULL, NULL),
(3, 'aqueous', 'A blue 3 col layout', 'Six Shooter Media\r\n', NULL, NULL, '', 0, 0, NULL, NULL),
(4, 'aqueous_light', 'aqueous_light', '', NULL, NULL, '', 1, 0, NULL, NULL);

DROP TABLE IF EXISTS `core_users`;
CREATE TABLE `core_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(40) NOT NULL,
  `birthday` date DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `group_id` int(11) NOT NULL,
  `ip_address` varchar(100) NOT NULL,
  `browser` varchar(100) NOT NULL,
  `operating_system` varchar(50) NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_click` datetime DEFAULT NULL,
  `country` varchar(150) NOT NULL,
  `city` varchar(150) NOT NULL,
  `is_mobile` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`,`email`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `core_users` (`id`, `username`, `email`, `password`, `birthday`, `active`, `group_id`, `ip_address`, `browser`, `operating_system`, `last_login`, `last_click`, `country`, `city`, `is_mobile`, `created`, `modified`) VALUES
(1, 'admin', 'admin@admin.com', 'b45e7cddbeafb9f619d93fd996c6a78c784e7fb5', '2010-02-04', 1, 1, '::1', 'Mozilla 5.0', 'Windows NT', '2010-02-26 01:05:31', NULL, 'Unknown', 'TODO', 0, '2010-02-04 16:54:48', '2010-02-04 16:54:48');

DROP TABLE IF EXISTS `newsletter_campaigns`;
CREATE TABLE `newsletter_campaigns` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `newsletter_count` int(11) NOT NULL DEFAULT '0',
  `template_id` int(11) NOT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `locked_by` int(11) DEFAULT NULL,
  `locked_since` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

INSERT INTO `newsletter_campaigns` (`id`, `name`, `description`, `active`, `newsletter_count`, `template_id`, `locked`, `locked_by`, `locked_since`, `created`, `modified`) VALUES
(3, '436', '34563456546', 0, 2, 1, 1, 1, '2009-12-21 16:28:38', '2009-12-12 12:47:53', '2009-12-21 16:28:38'),
(6, '23423', '23423', 1, 1, 1, 0, NULL, NULL, '2010-01-04 09:23:38', '2010-01-04 09:23:57');

DROP TABLE IF EXISTS `newsletter_newsletters`;
CREATE TABLE `newsletter_newsletters` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `campaign_id` int(11) DEFAULT NULL,
  `template_id` int(11) NOT NULL,
  `from` varchar(150) NOT NULL,
  `reply_to` varchar(150) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `html` text NOT NULL,
  `text` text NOT NULL,
  `active` tinyint(1) NOT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL DEFAULT '0',
  `sends` int(11) NOT NULL DEFAULT '0',
  `last_sent` datetime DEFAULT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `locked_by` int(11) DEFAULT NULL,
  `locked_since` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `campaign_id` (`campaign_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

INSERT INTO `newsletter_newsletters` (`id`, `campaign_id`, `template_id`, `from`, `reply_to`, `subject`, `html`, `text`, `active`, `sent`, `views`, `sends`, `last_sent`, `locked`, `locked_by`, `locked_since`, `created`, `modified`, `created_by`, `modified_by`) VALUES
(7, 3, 0, 'dogmatic69@gmail.com', 'dogmatic69@gmail.com', 'asdf', '<p>asd</p>', '<p>asd</p>', 0, 1, 0, 0, NULL, 0, NULL, NULL, '2010-01-04 03:14:15', '2010-01-04 03:14:15', NULL, NULL),
(9, 3, 0, 'dogmatic69@gmail.com', 'dogmatic69@gmail.com', 'asdf- copy ( 2010-01-04 )', '<p>asd</p>', '<p>asd</p>', 0, 1, 0, 0, NULL, 0, NULL, NULL, '2010-01-04 03:14:15', '2010-01-04 03:14:15', NULL, NULL),
(10, 6, 0, 'gsdfgd@dssd.com', 'gsdfgd@dssd.com', 'dsfgsdf', '<p>dfgdsfgsd</p>', '<p>sdfgdsfsfsfsfsfsf</p>', 0, 0, 0, 0, NULL, 0, NULL, NULL, '2010-01-12 14:19:31', '2010-01-12 14:19:31', NULL, NULL);

DROP TABLE IF EXISTS `newsletter_newsletters_users`;
CREATE TABLE `newsletter_newsletters_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `newsletter_id` int(11) NOT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `newsletter_sent` (`sent`),
  KEY `newsletter_newsletter_id` (`newsletter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `newsletter_subscribers`;
CREATE TABLE `newsletter_subscribers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `newsletter_subscribers` (`id`, `user_id`, `active`, `created`, `modified`) VALUES
(1, 1, 1, '2009-12-13 01:49:32', '2009-12-13 01:49:32');

DROP TABLE IF EXISTS `newsletter_templates`;
CREATE TABLE `newsletter_templates` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `header` text,
  `footer` text,
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `locked_by` int(11) DEFAULT NULL,
  `locked_since` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `newsletter_templates` (`id`, `name`, `header`, `footer`, `locked`, `locked_by`, `locked_since`, `created`, `modified`) VALUES
(1, 'first template', '<p style="color: red;">this is the head</p>', '<p>this is the foot</p>', 1, 1, '2009-12-21 16:26:14', '2009-12-12 17:04:07', '2009-12-21 16:26:14');

DROP TABLE IF EXISTS `relation_relations`;
CREATE TABLE `relation_relations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `plugin` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL DEFAULT '',
  `foreign_key` varchar(100) DEFAULT NULL,
  `conditions` text,
  `fields` text,
  `order` text,
  `dependent` tinyint(1) DEFAULT '0',
  `limit` int(11) DEFAULT NULL,
  `offset` int(11) DEFAULT NULL,
  `counter_cache` tinyint(1) DEFAULT '0',
  `counter_scope` text NOT NULL,
  `join_table` varchar(150) NOT NULL,
  `with` varchar(150) DEFAULT NULL,
  `association_foreign_key` varchar(100) NOT NULL,
  `unique` tinyint(1) DEFAULT '0',
  `finder_query` text NOT NULL,
  `delete_query` text NOT NULL,
  `insert_query` text NOT NULL,
  `bind` tinyint(1) NOT NULL DEFAULT '1',
  `reverse_association` tinyint(1) NOT NULL DEFAULT '0',
  `type_id` int(11) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_name` (`model`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `relation_relations` (`id`, `name`, `description`, `plugin`, `model`, `foreign_key`, `conditions`, `fields`, `order`, `dependent`, `limit`, `offset`, `counter_cache`, `counter_scope`, `join_table`, `with`, `association_foreign_key`, `unique`, `finder_query`, `delete_query`, `insert_query`, `bind`, `reverse_association`, `type_id`, `created`, `modified`) VALUES
(1, 'User Profile', 'This is the join for the user profile. each user can only have one profile.', '', 'UserProfile', 'user_id', NULL, NULL, NULL, 0, 0, 0, 0, '', '', NULL, '', 0, '', '', '', 1, 0, 1, NULL, NULL);

DROP TABLE IF EXISTS `relation_relation_types`;
CREATE TABLE `relation_relation_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type` (`type`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

INSERT INTO `relation_relation_types` (`id`, `name`, `type`, `description`, `created`, `modified`) VALUES
(1, 'one to one', 'hasOne', 'A user has one profile.', '2010-02-02 16:23:08', '2010-02-02 16:23:08'),
(2, 'one to many', 'hasMany', 'A user can have multiple posts.', '2010-02-02 16:23:08', '2010-02-02 16:23:08'),
(3, 'many to one', 'belongsTo', 'Many posts belong to a user.', '2010-02-02 16:23:08', '2010-02-02 16:23:08'),
(4, 'many to many', 'hasAndBelongsToMany', 'posts has and belongs to many tags', '2010-02-02 16:23:08', '2010-02-02 16:23:08');

DROP TABLE IF EXISTS `schema_migrations`;
CREATE TABLE `schema_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

INSERT INTO `schema_migrations` (`id`, `version`, `type`, `created`) VALUES
(1, 1, 'migrations', '2010-02-01 03:44:24'),
(2, 1, 'app', '2010-02-01 03:44:26');

DROP TABLE IF EXISTS `user_configs`;
CREATE TABLE `user_configs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `key` varchar(100) NOT NULL,
  `value` varchar(255) NOT NULL,
  `type` varchar(20) NOT NULL,
  `options` text NOT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `config_key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `user_details`;
CREATE TABLE `user_details` (
  `name` varchar(50) NOT NULL,
  `surname` varchar(50) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `landline` varchar(15) NOT NULL,
  `company` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;