D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
var
/
softaculous
/
atlantis
/
Filename :
atlantis.sql
back
Copy
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `atlantis204` -- -- -------------------------------------------------------- -- -- Table structure for table `config` -- CREATE TABLE `config` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `config_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `config_value` text COLLATE utf8_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=33 ; -- -- Dumping data for table `config` -- INSERT INTO `config` VALUES (1, 'site_name', 's:8:"Atlantis";', '[[regtime]]', '[[regtime]]'), (2, 'include_title', 'i:1;', '[[regtime]]', '[[regtime]]'), (3, 'domain_name', 's:0:"";', '[[regtime]]', '[[regtime]]'), (4, 'frontend_shell_view', 's:10:"page/shell";', '[[regtime]]', '[[regtime]]'), (5, 'admin_items_per_page', 'i:25;', '[[regtime]]', '[[regtime]]'), (6, 'default_language', 's:2:"en";', '[[regtime]]', '[[regtime]]'), (7, 'cache_lifetime', 'i:3600;', '[[regtime]]', '[[regtime]]'), (8, 'show_shortcut_bar', 'b:0;', '[[regtime]]', '[[regtime]]'), (9, 'cache', 'b:0;', '[[regtime]]', '[[regtime]]'), (10, 'allowed_max_filesize', 'i:4;', '[[regtime]]', '[[regtime]]'), (11, 'allowed_image_extensions', 'a:4:{i:0;s:3:"gif";i:1;s:3:"png";i:2;s:3:"jpg";i:3;s:4:"jpeg";}', '[[regtime]]', '[[regtime]]'), (12, 'allowed_others_extensions', 'a:2:{i:0;s:3:"pdf";i:1;s:3:"txt";}', '[[regtime]]', '[[regtime]]'), (13, 'static_images', 'a:1:{s:13:"Static Header";a:2:{s:8:"fullsize";a:3:{s:5:"width";i:1024;s:6:"height";i:768;s:4:"crop";b:0;}s:9:"thumbnail";a:3:{s:5:"width";i:200;s:6:"height";i:150;s:4:"crop";b:1;}}}', '[[regtime]]', '[[regtime]]'), (14, 'responsive_images', 'a:2:{s:17:"Responsive Header";a:4:{s:7:"desktop";a:3:{s:5:"width";i:1024;s:6:"height";i:768;s:4:"crop";b:0;}s:6:"tablet";a:3:{s:5:"width";i:640;s:6:"height";i:480;s:4:"crop";b:0;}s:5:"phone";a:3:{s:5:"width";i:320;s:6:"height";i:240;s:4:"crop";b:0;}s:9:"thumbnail";a:3:{s:5:"width";i:150;s:6:"height";i:150;s:4:"crop";b:1;}}s:18:"Responsive Gallery";a:4:{s:7:"desktop";a:3:{s:5:"width";i:1024;s:6:"height";i:768;s:4:"crop";b:0;}s:6:"tablet";a:3:{s:5:"width";i:640;s:6:"height";i:480;s:4:"crop";b:0;}s:5:"phone";a:3:{s:5:"width";i:320;s:6:"height";i:240;s:4:"crop";b:0;}s:9:"thumbnail";a:3:{s:5:"width";i:300;s:6:"height";i:300;s:4:"crop";b:1;}}}', '[[regtime]]', '[[regtime]]'), (15, 'responsive_breakpoints', 'a:2:{s:5:"large";i:1200;s:6:"medium";i:800;}', '[[regtime]]', '[[regtime]]'), (16, 'default_styles', 's:0:"";', '[[regtime]]', '[[regtime]]'), (17, 'default_scripts', 's:0:"";', '[[regtime]]', '[[regtime]]'), (18, 'excluded_scripts', 's:0:"";', '[[regtime]]', '[[regtime]]'), (19, 'default_404_view', 's:8:"page/404";', '[[regtime]]', '[[regtime]]'), (20, 'default_meta_keywords', 's:13:"default words";', '[[regtime]]', '[[regtime]]'), (21, 'default_meta_description', 's:20:"My default meta info";', '[[regtime]]', '[[regtime]]'), (22, 'modules_dir', 's:9:"/modules/";', '[[regtime]]', '[[regtime]]'), (23, 'user_media_upload', 's:21:"resources/media/user/";', '[[regtime]]', '[[regtime]]'), (24, 'theme_path', 's:25:"resources/themes/theme101";', '[[regtime]]', '[[regtime]]'), (25, 'amazon_s3_url', 's:0:"";', '[[regtime]]', '[[regtime]]'), (26, 'amazon_cloudfront_url', 's:0:"";', '[[regtime]]', '[[regtime]]'), (27, 'use_amazon_s3', 'b:0;', '[[regtime]]', '[[regtime]]'), (28, 'use_amazon_cdn', 'b:0;', '[[regtime]]', '[[regtime]]'), (29, 's3_sync_dirs', 'a:0:{}', '[[regtime]]', '[[regtime]]'), (30, 'delete_local_file', 'b:0;', '[[regtime]]', '[[regtime]]'), (31, 'use_smart_crop', 'b:1;', '[[regtime]]', '[[regtime]]'), (32, 'use_facedetection', 'b:1;', '[[regtime]]', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `galleries` -- CREATE TABLE `galleries` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` text COLLATE utf8_unicode_ci, `images` text COLLATE utf8_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `galleries` -- INSERT INTO `galleries` VALUES (1, 'Page Preview', 'This is a special gallery used to hold page preview thumbnails. You can attach them to a page using the Page sidebar menu - Related Image.', NULL, '[[regtime]]', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `locked_items` -- CREATE TABLE `locked_items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `item_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `item_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `media` -- CREATE TABLE `media` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `original_filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `tablet_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `phone_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `filesize` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `caption` text COLLATE utf8_unicode_ci, `credit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` text COLLATE utf8_unicode_ci, `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `alt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `weight` int(11) DEFAULT NULL, `css` text COLLATE utf8_unicode_ci, `anchor_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `resize` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=25 ; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` VALUES (1, '2015_12_15_000006_create_config_table', 1), (2, '2015_12_15_000006_create_galleries_table', 1), (3, '2015_12_15_000006_create_locked_items_table', 1), (4, '2015_12_15_000006_create_media_table', 1), (5, '2015_12_15_000006_create_modules_table', 1), (6, '2015_12_15_000006_create_multisites_sessions_table', 1), (7, '2015_12_15_000006_create_pages_categories_table', 1), (8, '2015_12_15_000006_create_pages_table', 1), (9, '2015_12_15_000006_create_pages_versions_table', 1), (10, '2015_12_15_000006_create_password_resets_table', 1), (11, '2015_12_15_000006_create_patterns_fields_table', 1), (12, '2015_12_15_000006_create_patterns_masks_table', 1), (13, '2015_12_15_000006_create_patterns_table', 1), (14, '2015_12_15_000006_create_patterns_versions_table', 1), (15, '2015_12_15_000006_create_permissions_table', 1), (16, '2015_12_15_000006_create_roles_table', 1), (17, '2015_12_15_000006_create_roles_users_table', 1), (18, '2015_12_15_000006_create_tags_table', 1), (19, '2015_12_15_000006_create_users_table', 1), (20, '2016_09_12_000006_add_page_canonical_url', 1), (21, '2016_10_18_000007_add_media_resize_prop', 1), (22, '2016_10_20_000007_add_user_widgets', 1), (23, '2017_07_07_000008_add_pages_log_table', 1), (24, '2018_02_22_000009_add_user_first_last_name', 1); -- -------------------------------------------------------- -- -- Table structure for table `modules` -- CREATE TABLE `modules` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `version` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `namespace` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `provider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `adminURL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `extra` text COLLATE utf8_unicode_ci, `active` int(11) NOT NULL DEFAULT '1', `description` text COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `modules` -- INSERT INTO `modules` VALUES (1, 'Site', 'Atlantis CMS', '1.0', 'Module\\Site', 'atlantis/site/src', 'Module\\Site\\Providers\\SiteServiceProvider', NULL, NULL, NULL, 1, '', '[[regtime]]', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `multisites_sessions` -- CREATE TABLE `multisites_sessions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `logged_user` int(11) NOT NULL, `key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `categories_id` int(11) DEFAULT NULL, `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `template` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `is_ssl` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '1', `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `styles` text COLLATE utf8_unicode_ci, `scripts` text COLLATE utf8_unicode_ci, `user` int(11) DEFAULT NULL, `mobile_template` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `cache` int(11) NOT NULL DEFAULT '1', `preview_thumb_id` int(11) DEFAULT NULL, `protected` int(11) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `canonical_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; -- -- Dumping data for table `pages` -- INSERT INTO `pages` VALUES (1, 'home page', NULL, '/', 1, 'admin', 'default', 0, 1, NULL, NULL, NULL, NULL, 1, 'default', 1, NULL, 0, '[[regtime]]', '[[regtime]]', NULL), (2, '404', NULL, '404', 0, 'admin', '404', 0, 1, NULL, NULL, NULL, NULL, 1, '404', 1, NULL, 0, '[[regtime]]', '[[regtime]]', NULL), (3, 'Site Login', NULL, 'site-login', 0, 'admin', 'site-login', 0, 1, NULL, NULL, NULL, NULL, 1, 'site-login', 1, NULL, 0, '[[regtime]]', '[[regtime]]', NULL); -- -------------------------------------------------------- -- -- Table structure for table `pages_categories` -- CREATE TABLE `pages_categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `category_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `category_action` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `category_string` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `category_view` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `category_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `pages_categories` -- INSERT INTO `pages_categories` VALUES (1, 'All Pages', NULL, NULL, NULL, NULL, '[[regtime]]', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `pages_log` -- CREATE TABLE `pages_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `module_id` int(11) NOT NULL, `page_id` int(11) DEFAULT NULL, `pattern_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `pages_versions` -- CREATE TABLE `pages_versions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `page_id` int(11) NOT NULL, `version_id` int(11) DEFAULT NULL, `page_body` text COLLATE utf8_unicode_ci, `excerpt` text COLLATE utf8_unicode_ci, `related_title` text COLLATE utf8_unicode_ci, `user_id` int(11) NOT NULL, `notes` text COLLATE utf8_unicode_ci, `mobile_body` text COLLATE utf8_unicode_ci, `seo_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `meta_description` text COLLATE utf8_unicode_ci, `meta_keywords` text COLLATE utf8_unicode_ci, `language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `active` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; -- -- Dumping data for table `pages_versions` -- INSERT INTO `pages_versions` VALUES (1, 1, 1, '<h1>Welcome to Atlantis 3!</h1>\n\n<h4>We are excited to have you working with Atlantis and have prepared some helpful links to get you started.</h4>\n\n<h4><a class="button" href="http://www.atlantis-cms.com/faq">FAQ</a><a class="button" href="http://www.atlantis-cms.com/user-docs">View documentation</a><a class="button" href="http://www.atlantis-cms.com/docs">For Developers</a></h4>\n\n<h4>If you have any questions, or suggestions, or anything else you want to share with us...please give us your feedback <a href="http://www.atlantis-cms.com/feedback" target="_blank">here</a> or join the discussion on <a href="http://forum.atlantis-cms.com/" target="_blank">our forum</a>.</h4>\n', NULL, NULL, 1, NULL, NULL, NULL, 'description', 'keywords', 'en', 1, '[[regtime]]', '[[regtime]]'), (2, 2, 1, '', NULL, NULL, 1, NULL, NULL, 'Page not Found', '', '', 'en', 1, '[[regtime]]', '[[regtime]]'), (3, 3, 1, '', NULL, NULL, 1, NULL, NULL, 'Site Login', '', '', 'en', 1, '[[regtime]]', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, KEY `password_resets_email_index` (`email`), KEY `password_resets_token_index` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `patterns` -- CREATE TABLE `patterns` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `outputs` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `weight` int(11) DEFAULT NULL, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `patterns_fields` -- CREATE TABLE `patterns_fields` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pattern_id` int(11) DEFAULT NULL, `key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `value` text COLLATE utf8_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `patterns_masks` -- CREATE TABLE `patterns_masks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pattern_id` int(11) DEFAULT NULL, `mask` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `patterns_versions` -- CREATE TABLE `patterns_versions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `text` text COLLATE utf8_unicode_ci, `view` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `pattern_id` int(11) DEFAULT NULL, `version_id` int(11) DEFAULT NULL, `active` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `role_id` int(11) NOT NULL, `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `value` text COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` VALUES (1, 4, 'pages', '1', NULL, NULL), (2, 4, 'patterns', '1', NULL, NULL), (3, 4, 'media', '1', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ; -- -- Dumping data for table `roles` -- INSERT INTO `roles` VALUES (1, 'admin-login', 'Grant access to admin.', '[[regtime]]', '[[regtime]]'), (2, 'site-login', 'Grant access to password protected pages.', '[[regtime]]', '[[regtime]]'), (3, 'admin', 'Administrative user, has access to everything.', '[[regtime]]', '[[regtime]]'), (4, 'editor', 'People with editorial privileges', '[[regtime]]', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `roles_users` -- CREATE TABLE `roles_users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -- Dumping data for table `roles_users` -- INSERT INTO `roles_users` VALUES (1, 1, 1, NULL, NULL), (2, 1, 3, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE `tags` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `resource` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `resource_id` int(11) DEFAULT NULL, `tag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `last_name` text COLLATE utf8_unicode_ci, `first_name` text COLLATE utf8_unicode_ci, `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `editor` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `widgets` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `users` -- INSERT INTO `users` VALUES (1, '[[admin_username]]', '[[admin_email]]', NULL, NULL, '[[admin_pass]]', 'en', NULL, NULL, '[[regtime]]', '[[regtime]]', NULL); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;