\n \n
Uniting fresh design and clean code
to create beautiful websites.
\n\n
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
\n\n
', '{"title":true}');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]system_role`
--
CREATE TABLE `[[dbprefix]]system_role` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`priority` int(11) NOT NULL DEFAULT '0',
`permissions` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:simple_array)',
PRIMARY KEY (`id`),
UNIQUE KEY `[[dbprefix]]SYSTEM_ROLE_NAME` (`name`),
KEY `[[dbprefix]]SYSTEM_ROLE_NAME_PRIORITY` (`name`,`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]system_role`
--
INSERT INTO `[[dbprefix]]system_role` VALUES
(1, 'Anonymous', 0, NULL),
(2, 'Authenticated', 1, 'blog: post comments'),
(3, 'Administrator', 2, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]system_session`
--
CREATE TABLE `[[dbprefix]]system_session` (
`id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`time` datetime NOT NULL,
`data` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]system_session`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]system_user`
--
CREATE TABLE `[[dbprefix]]system_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`status` smallint(6) NOT NULL DEFAULT '0',
`registered` datetime NOT NULL,
`login` datetime DEFAULT NULL,
`activation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`roles` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:simple_array)',
`data` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:json_array)',
PRIMARY KEY (`id`),
UNIQUE KEY `[[dbprefix]]SYSTEM_USER_USERNAME` (`username`),
UNIQUE KEY `[[dbprefix]]SYSTEM_USER_EMAIL` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]system_user`
--
INSERT INTO `[[dbprefix]]system_user` VALUES
(1, '[[admin_realname]]', '[[admin_username]]', '[[admin_email]]', '[[admin_pass]]', '', 1, '[[regtime]]', NULL, NULL, '2,3', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]system_widget`
--
CREATE TABLE `[[dbprefix]]system_widget` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`status` smallint(6) NOT NULL,
`nodes` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:simple_array)',
`roles` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:simple_array)',
`data` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:json_array)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]system_widget`
--
INSERT INTO `[[dbprefix]]system_widget` VALUES
(1, 'Hello, I''m Pagekit', 'system/text', 1, '1', NULL, '{"content":"