Edit - atlantis.sql

Edit: atlantis.sql

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 */;

Cancel