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 */;
-- --------------------------------------------------------
-- Table structure for table `acos`
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(10) DEFAULT NULL,
`model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`foreign_key` int(10) DEFAULT NULL,
`alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`lft` int(10) DEFAULT NULL,
`rght` int(10) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=324 ;
-- Dumping data for table `acos`
INSERT INTO `acos` VALUES
(1, NULL, NULL, NULL, 'controllers', 1, 646),
(2, 1, NULL, NULL, 'Error', 2, 3),
(3, 1, NULL, NULL, 'Pages', 4, 7),
(4, 3, NULL, NULL, 'display', 5, 6),
(5, 1, NULL, NULL, 'Acl', 8, 9),
(6, 1, NULL, NULL, 'BootstrapUI', 10, 11),
(7, 1, NULL, NULL, 'Croogo\\Acl', 12, 45),
(8, 7, NULL, NULL, 'Admin', 13, 44),
(9, 8, NULL, NULL, 'Permissions', 14, 27),
(10, 9, NULL, NULL, 'index', 15, 16),
(11, 9, NULL, NULL, 'toggle', 17, 18),
(12, 9, NULL, NULL, 'view', 19, 20),
(13, 9, NULL, NULL, 'add', 21, 22),
(14, 9, NULL, NULL, 'edit', 23, 24),
(15, 9, NULL, NULL, 'delete', 25, 26),
(16, 8, NULL, NULL, 'Actions', 28, 43),
(17, 16, NULL, NULL, 'index', 29, 30),
(18, 16, NULL, NULL, 'add', 31, 32),
(19, 16, NULL, NULL, 'edit', 33, 34),
(20, 16, NULL, NULL, 'delete', 35, 36),
(21, 16, NULL, NULL, 'move', 37, 38),
(22, 16, NULL, NULL, 'generate', 39, 40),
(23, 16, NULL, NULL, 'view', 41, 42),
(24, 1, NULL, NULL, 'Croogo\\Blocks', 46, 85),
(25, 24, NULL, NULL, 'Admin', 47, 76),
(26, 25, NULL, NULL, 'Blocks', 48, 63),
(27, 26, NULL, NULL, 'process', 49, 50),
(28, 26, NULL, NULL, 'toggle', 51, 52),
(29, 26, NULL, NULL, 'index', 53, 54),
(30, 26, NULL, NULL, 'view', 55, 56),
(31, 26, NULL, NULL, 'add', 57, 58),
(32, 26, NULL, NULL, 'edit', 59, 60),
(33, 26, NULL, NULL, 'delete', 61, 62),
(34, 25, NULL, NULL, 'Regions', 64, 75),
(35, 34, NULL, NULL, 'index', 65, 66),
(36, 34, NULL, NULL, 'view', 67, 68),
(37, 34, NULL, NULL, 'add', 69, 70),
(38, 34, NULL, NULL, 'edit', 71, 72),
(39, 34, NULL, NULL, 'delete', 73, 74),
(40, 24, NULL, NULL, 'Api', 77, 84),
(41, 40, NULL, NULL, 'V10', 78, 83),
(42, 41, NULL, NULL, 'Blocks', 79, 82),
(43, 42, NULL, NULL, 'index', 80, 81),
(44, 1, NULL, NULL, 'Croogo\\Contacts', 86, 119),
(45, 44, NULL, NULL, 'Contacts', 87, 90),
(46, 45, NULL, NULL, 'view', 88, 89),
(47, 44, NULL, NULL, 'Admin', 91, 118),
(48, 47, NULL, NULL, 'Contacts', 92, 103),
(49, 48, NULL, NULL, 'index', 93, 94),
(50, 48, NULL, NULL, 'view', 95, 96),
(51, 48, NULL, NULL, 'add', 97, 98),
(52, 48, NULL, NULL, 'edit', 99, 100),
(53, 48, NULL, NULL, 'delete', 101, 102),
(54, 47, NULL, NULL, 'Messages', 104, 117),
(55, 54, NULL, NULL, 'process', 105, 106),
(56, 54, NULL, NULL, 'index', 107, 108),
(57, 54, NULL, NULL, 'view', 109, 110),
(58, 54, NULL, NULL, 'add', 111, 112),
(59, 54, NULL, NULL, 'edit', 113, 114),
(60, 54, NULL, NULL, 'delete', 115, 116),
(61, 1, NULL, NULL, 'Croogo\\Core', 120, 139),
(62, 61, NULL, NULL, 'Error', 121, 122),
(63, 61, NULL, NULL, 'Admin', 123, 138),
(64, 63, NULL, NULL, 'LinkChooser', 124, 137),
(65, 64, NULL, NULL, 'linkChooser', 125, 126),
(66, 64, NULL, NULL, 'index', 127, 128),
(67, 64, NULL, NULL, 'view', 129, 130),
(68, 64, NULL, NULL, 'add', 131, 132),
(69, 64, NULL, NULL, 'edit', 133, 134),
(70, 64, NULL, NULL, 'delete', 135, 136),
(71, 1, NULL, NULL, 'Croogo\\Dashboards', 140, 165),
(72, 71, NULL, NULL, 'Admin', 141, 164),
(73, 72, NULL, NULL, 'Dashboards', 142, 163),
(74, 73, NULL, NULL, 'index', 143, 144),
(75, 73, NULL, NULL, 'dashboard', 145, 146),
(76, 73, NULL, NULL, 'save', 147, 148),
(77, 73, NULL, NULL, 'delete', 149, 150),
(78, 73, NULL, NULL, 'toggle', 151, 152),
(79, 73, NULL, NULL, 'moveup', 153, 154),
(80, 73, NULL, NULL, 'movedown', 155, 156),
(81, 73, NULL, NULL, 'view', 157, 158),
(82, 73, NULL, NULL, 'add', 159, 160),
(83, 73, NULL, NULL, 'edit', 161, 162),
(84, 1, NULL, NULL, 'Croogo\\Extensions', 166, 223),
(85, 84, NULL, NULL, 'Admin', 167, 222),
(86, 85, NULL, NULL, 'Plugins', 168, 187),
(87, 86, NULL, NULL, 'index', 169, 170),
(88, 86, NULL, NULL, 'add', 171, 172),
(89, 86, NULL, NULL, 'delete', 173, 174),
(90, 86, NULL, NULL, 'toggle', 175, 176),
(91, 86, NULL, NULL, 'migrate', 177, 178),
(92, 86, NULL, NULL, 'moveup', 179, 180),
(93, 86, NULL, NULL, 'movedown', 181, 182),
(94, 86, NULL, NULL, 'view', 183, 184),
(95, 86, NULL, NULL, 'edit', 185, 186),
(96, 85, NULL, NULL, 'Themes', 188, 205),
(97, 96, NULL, NULL, 'index', 189, 190),
(98, 96, NULL, NULL, 'activate', 191, 192),
(99, 96, NULL, NULL, 'add', 193, 194),
(100, 96, NULL, NULL, 'editor', 195, 196),
(101, 96, NULL, NULL, 'save', 197, 198),
(102, 96, NULL, NULL, 'delete', 199, 200),
(103, 96, NULL, NULL, 'view', 201, 202),
(104, 96, NULL, NULL, 'edit', 203, 204),
(105, 85, NULL, NULL, 'Locales', 206, 221),
(106, 105, NULL, NULL, 'index', 207, 208),
(107, 105, NULL, NULL, 'activate', 209, 210),
(108, 105, NULL, NULL, 'deactivate', 211, 212),
(109, 105, NULL, NULL, 'add', 213, 214),
(110, 105, NULL, NULL, 'edit', 215, 216),
(111, 105, NULL, NULL, 'delete', 217, 218),
(112, 105, NULL, NULL, 'view', 219, 220),
(113, 1, NULL, NULL, 'Croogo\\FileManager', 224, 293),
(114, 113, NULL, NULL, 'Admin', 225, 292),
(115, 114, NULL, NULL, 'AssetUsages', 226, 241),
(116, 115, NULL, NULL, 'add', 227, 228),
(117, 115, NULL, NULL, 'changeType', 229, 230),
(118, 115, NULL, NULL, 'unregister', 231, 232),
(119, 115, NULL, NULL, 'index', 233, 234),
(120, 115, NULL, NULL, 'view', 235, 236),
(121, 115, NULL, NULL, 'edit', 237, 238),
(122, 115, NULL, NULL, 'delete', 239, 240),
(123, 114, NULL, NULL, 'FileManager', 242, 271),
(124, 123, NULL, NULL, 'index', 243, 244),
(125, 123, NULL, NULL, 'browse', 245, 246),
(126, 123, NULL, NULL, 'editFile', 247, 248),
(127, 123, NULL, NULL, 'upload', 249, 250),
(128, 123, NULL, NULL, 'deleteFile', 251, 252),
(129, 123, NULL, NULL, 'deleteDirectory', 253, 254),
(130, 123, NULL, NULL, 'rename', 255, 256),
(131, 123, NULL, NULL, 'createDirectory', 257, 258),
(132, 123, NULL, NULL, 'createFile', 259, 260),
(133, 123, NULL, NULL, 'chmod', 261, 262),
(134, 123, NULL, NULL, 'view', 263, 264),
(135, 123, NULL, NULL, 'add', 265, 266),
(136, 123, NULL, NULL, 'edit', 267, 268),
(137, 123, NULL, NULL, 'delete', 269, 270),
(138, 114, NULL, NULL, 'Attachments', 272, 291),
(139, 138, NULL, NULL, 'index', 273, 274),
(140, 138, NULL, NULL, 'add', 275, 276),
(141, 138, NULL, NULL, 'edit', 277, 278),
(142, 138, NULL, NULL, 'delete', 279, 280),
(143, 138, NULL, NULL, 'browse', 281, 282),
(144, 138, NULL, NULL, 'listing', 283, 284),
(145, 138, NULL, NULL, 'resize', 285, 286),
(146, 138, NULL, NULL, 'process', 287, 288),
(147, 138, NULL, NULL, 'view', 289, 290),
(148, 1, NULL, NULL, 'Croogo\\Install', 294, 311),
(149, 148, NULL, NULL, 'Install', 295, 310),
(150, 149, NULL, NULL, 'index', 296, 297),
(151, 149, NULL, NULL, 'database', 298, 299),
(152, 149, NULL, NULL, 'data', 300, 301),
(153, 149, NULL, NULL, 'acl', 302, 303),
(154, 149, NULL, NULL, 'undo', 304, 305),
(155, 149, NULL, NULL, 'adminUser', 306, 307),
(156, 149, NULL, NULL, 'finish', 308, 309),
(157, 1, NULL, NULL, 'Croogo\\Menus', 312, 357),
(158, 157, NULL, NULL, 'Admin', 313, 344),
(159, 158, NULL, NULL, 'Menus', 314, 325),
(160, 159, NULL, NULL, 'index', 315, 316),
(161, 159, NULL, NULL, 'view', 317, 318),
(162, 159, NULL, NULL, 'add', 319, 320),
(163, 159, NULL, NULL, 'edit', 321, 322),
(164, 159, NULL, NULL, 'delete', 323, 324),
(165, 158, NULL, NULL, 'Links', 326, 343),
(166, 165, NULL, NULL, 'index', 327, 328),
(167, 165, NULL, NULL, 'delete', 329, 330),
(168, 165, NULL, NULL, 'moveup', 331, 332),
(169, 165, NULL, NULL, 'movedown', 333, 334),
(170, 165, NULL, NULL, 'process', 335, 336),
(171, 165, NULL, NULL, 'view', 337, 338),
(172, 165, NULL, NULL, 'add', 339, 340),
(173, 165, NULL, NULL, 'edit', 341, 342),
(174, 157, NULL, NULL, 'Api', 345, 356),
(175, 174, NULL, NULL, 'V10', 346, 355),
(176, 175, NULL, NULL, 'Menus', 347, 350),
(177, 176, NULL, NULL, 'index', 348, 349),
(178, 175, NULL, NULL, 'Links', 351, 354),
(179, 178, NULL, NULL, 'index', 352, 353),
(180, 1, NULL, NULL, 'Croogo\\Meta', 358, 385),
(181, 180, NULL, NULL, 'Admin', 359, 376),
(182, 181, NULL, NULL, 'Meta', 360, 375),
(183, 182, NULL, NULL, 'deleteMeta', 361, 362),
(184, 182, NULL, NULL, 'addMeta', 363, 364),
(185, 182, NULL, NULL, 'index', 365, 366),
(186, 182, NULL, NULL, 'view', 367, 368),
(187, 182, NULL, NULL, 'add', 369, 370),
(188, 182, NULL, NULL, 'edit', 371, 372),
(189, 182, NULL, NULL, 'delete', 373, 374),
(190, 180, NULL, NULL, 'Api', 377, 384),
(191, 190, NULL, NULL, 'V10', 378, 383),
(192, 191, NULL, NULL, 'Meta', 379, 382),
(193, 192, NULL, NULL, 'index', 380, 381),
(194, 1, NULL, NULL, 'Croogo\\Nodes', 386, 437),
(195, 194, NULL, NULL, 'Nodes', 387, 400),
(196, 195, NULL, NULL, 'index', 388, 389),
(197, 195, NULL, NULL, 'term', 390, 391),
(198, 195, NULL, NULL, 'promoted', 392, 393),
(199, 195, NULL, NULL, 'feed', 394, 395),
(200, 195, NULL, NULL, 'search', 396, 397),
(201, 195, NULL, NULL, 'view', 398, 399),
(202, 194, NULL, NULL, 'Admin', 401, 426),
(203, 202, NULL, NULL, 'Nodes', 402, 425),
(204, 203, NULL, NULL, 'create', 403, 404),
(205, 203, NULL, NULL, 'updatePaths', 405, 406),
(206, 203, NULL, NULL, 'process', 407, 408),
(207, 203, NULL, NULL, 'toggle', 409, 410),
(208, 203, NULL, NULL, 'move', 411, 412),
(209, 203, NULL, NULL, 'hierarchy', 413, 414),
(210, 203, NULL, NULL, 'index', 415, 416),
(211, 203, NULL, NULL, 'view', 417, 418),
(212, 203, NULL, NULL, 'add', 419, 420),
(213, 203, NULL, NULL, 'edit', 421, 422),
(214, 203, NULL, NULL, 'delete', 423, 424),
(215, 194, NULL, NULL, 'Api', 427, 436),
(216, 215, NULL, NULL, 'V10', 428, 435),
(217, 216, NULL, NULL, 'Nodes', 429, 434),
(218, 217, NULL, NULL, 'index', 430, 431),
(219, 217, NULL, NULL, 'lookup', 432, 433),
(220, 1, NULL, NULL, 'Croogo\\Settings', 438, 487),
(221, 220, NULL, NULL, 'Admin', 439, 486),
(222, 221, NULL, NULL, 'Caches', 440, 453),
(223, 222, NULL, NULL, 'index', 441, 442),
(224, 222, NULL, NULL, 'clear', 443, 444),
(225, 222, NULL, NULL, 'view', 445, 446),
(226, 222, NULL, NULL, 'add', 447, 448),
(227, 222, NULL, NULL, 'edit', 449, 450),
(228, 222, NULL, NULL, 'delete', 451, 452),
(229, 221, NULL, NULL, 'Languages', 454, 467),
(230, 229, NULL, NULL, 'select', 455, 456),
(231, 229, NULL, NULL, 'index', 457, 458),
(232, 229, NULL, NULL, 'view', 459, 460),
(233, 229, NULL, NULL, 'add', 461, 462),
(234, 229, NULL, NULL, 'edit', 463, 464),
(235, 229, NULL, NULL, 'delete', 465, 466),
(236, 221, NULL, NULL, 'Settings', 468, 485),
(237, 236, NULL, NULL, 'prefix', 469, 470),
(238, 236, NULL, NULL, 'moveup', 471, 472),
(239, 236, NULL, NULL, 'movedown', 473, 474),
(240, 236, NULL, NULL, 'index', 475, 476),
(241, 236, NULL, NULL, 'view', 477, 478),
(242, 236, NULL, NULL, 'add', 479, 480),
(243, 236, NULL, NULL, 'edit', 481, 482),
(244, 236, NULL, NULL, 'delete', 483, 484),
(245, 1, NULL, NULL, 'Croogo\\Taxonomy', 488, 563),
(246, 245, NULL, NULL, 'Admin', 489, 542),
(247, 246, NULL, NULL, 'Taxonomies', 490, 505),
(248, 247, NULL, NULL, 'index', 491, 492),
(249, 247, NULL, NULL, 'moveUp', 493, 494),
(250, 247, NULL, NULL, 'moveDown', 495, 496),
(251, 247, NULL, NULL, 'delete', 497, 498),
(252, 247, NULL, NULL, 'view', 499, 500),
(253, 247, NULL, NULL, 'add', 501, 502),
(254, 247, NULL, NULL, 'edit', 503, 504),
(255, 246, NULL, NULL, 'Types', 506, 517),
(256, 255, NULL, NULL, 'index', 507, 508),
(257, 255, NULL, NULL, 'view', 509, 510),
(258, 255, NULL, NULL, 'add', 511, 512),
(259, 255, NULL, NULL, 'edit', 513, 514),
(260, 255, NULL, NULL, 'delete', 515, 516),
(261, 246, NULL, NULL, 'Terms', 518, 529),
(262, 261, NULL, NULL, 'index', 519, 520),
(263, 261, NULL, NULL, 'delete', 521, 522),
(264, 261, NULL, NULL, 'edit', 523, 524),
(265, 261, NULL, NULL, 'add', 525, 526),
(266, 261, NULL, NULL, 'view', 527, 528),
(267, 246, NULL, NULL, 'Vocabularies', 530, 541),
(268, 267, NULL, NULL, 'index', 531, 532),
(269, 267, NULL, NULL, 'view', 533, 534),
(270, 267, NULL, NULL, 'add', 535, 536),
(271, 267, NULL, NULL, 'edit', 537, 538),
(272, 267, NULL, NULL, 'delete', 539, 540),
(273, 245, NULL, NULL, 'Api', 543, 562),
(274, 273, NULL, NULL, 'V10', 544, 561),
(275, 274, NULL, NULL, 'Taxonomies', 545, 548),
(276, 275, NULL, NULL, 'index', 546, 547),
(277, 274, NULL, NULL, 'Types', 549, 552),
(278, 277, NULL, NULL, 'index', 550, 551),
(279, 274, NULL, NULL, 'Terms', 553, 556),
(280, 279, NULL, NULL, 'index', 554, 555),
(281, 274, NULL, NULL, 'Vocabularies', 557, 560),
(282, 281, NULL, NULL, 'index', 558, 559),
(283, 1, NULL, NULL, 'Croogo\\Users', 564, 639),
(284, 283, NULL, NULL, 'Users', 565, 584),
(285, 284, NULL, NULL, 'index', 566, 567),
(286, 284, NULL, NULL, 'add', 568, 569),
(287, 284, NULL, NULL, 'activate', 570, 571),
(288, 284, NULL, NULL, 'edit', 572, 573),
(289, 284, NULL, NULL, 'forgot', 574, 575),
(290, 284, NULL, NULL, 'reset', 576, 577),
(291, 284, NULL, NULL, 'login', 578, 579),
(292, 284, NULL, NULL, 'logout', 580, 581),
(293, 284, NULL, NULL, 'view', 582, 583),
(294, 283, NULL, NULL, 'Admin', 585, 622),
(295, 294, NULL, NULL, 'Users', 586, 609),
(296, 295, NULL, NULL, 'resetPassword', 587, 588),
(297, 295, NULL, NULL, 'login', 589, 590),
(298, 295, NULL, NULL, 'logout', 591, 592),
(299, 295, NULL, NULL, 'register', 593, 594),
(300, 295, NULL, NULL, 'forgot', 595, 596),
(301, 295, NULL, NULL, 'reset', 597, 598),
(302, 295, NULL, NULL, 'index', 599, 600),
(303, 295, NULL, NULL, 'view', 601, 602),
(304, 295, NULL, NULL, 'add', 603, 604),
(305, 295, NULL, NULL, 'edit', 605, 606),
(306, 295, NULL, NULL, 'delete', 607, 608),
(307, 294, NULL, NULL, 'Roles', 610, 621),
(308, 307, NULL, NULL, 'index', 611, 612),
(309, 307, NULL, NULL, 'view', 613, 614),
(310, 307, NULL, NULL, 'add', 615, 616),
(311, 307, NULL, NULL, 'edit', 617, 618),
(312, 307, NULL, NULL, 'delete', 619, 620),
(313, 283, NULL, NULL, 'Api', 623, 638),
(314, 313, NULL, NULL, 'V10', 624, 637),
(315, 314, NULL, NULL, 'Users', 625, 632),
(316, 315, NULL, NULL, 'lookup', 626, 627),
(317, 315, NULL, NULL, 'index', 628, 629),
(318, 315, NULL, NULL, 'token', 630, 631),
(319, 314, NULL, NULL, 'Roles', 633, 636),
(320, 319, NULL, NULL, 'index', 634, 635),
(321, 1, NULL, NULL, 'Croogo\\Wysiwyg', 640, 641),
(322, 1, NULL, NULL, 'Migrations', 642, 643),
(323, 1, NULL, NULL, 'Search', 644, 645);
-- --------------------------------------------------------
-- Table structure for table `aros`
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(10) DEFAULT NULL,
`model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`foreign_key` int(10) DEFAULT NULL,
`alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`lft` int(10) DEFAULT NULL,
`rght` int(10) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
-- Dumping data for table `aros`
INSERT INTO `aros` VALUES
(1, NULL, 'Roles', 1, 'Role-superadmin', 1, 4),
(2, NULL, 'Roles', 2, 'Role-public', 5, 12),
(3, 2, 'Roles', 3, 'Role-registered', 6, 7),
(4, 2, 'Roles', 4, 'Role-admin', 8, 11),
(5, 4, 'Roles', 5, 'Role-publisher', 9, 10),
(6, 1, 'Users', 1, '[[admin_username]]', 2, 3);
-- --------------------------------------------------------
-- Table structure for table `aros_acos`
CREATE TABLE `aros_acos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`aro_id` int(10) NOT NULL,
`aco_id` int(10) NOT NULL,
`_create` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`_read` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`_update` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`_delete` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=30 ;
-- Dumping data for table `aros_acos`
INSERT INTO `aros_acos` VALUES
(1, 2, 46, '1', '1', '1', '1'),
(2, 2, 196, '1', '1', '1', '1'),
(3, 2, 199, '1', '1', '1', '1'),
(4, 2, 197, '1', '1', '1', '1'),
(5, 2, 198, '1', '1', '1', '1'),
(6, 2, 200, '1', '1', '1', '1'),
(7, 2, 201, '1', '1', '1', '1'),
(8, 3, 285, '1', '1', '1', '1'),
(9, 2, 286, '1', '1', '1', '1'),
(10, 2, 287, '1', '1', '1', '1'),
(11, 3, 288, '1', '1', '1', '1'),
(12, 2, 289, '1', '1', '1', '1'),
(13, 2, 290, '1', '1', '1', '1'),
(14, 2, 291, '1', '1', '1', '1'),
(15, 2, 292, '1', '1', '1', '1'),
(16, 3, 292, '1', '1', '1', '1'),
(17, 2, 298, '1', '1', '1', '1'),
(18, 3, 298, '1', '1', '1', '1'),
(19, 3, 293, '1', '1', '1', '1'),
(20, 4, 73, '1', '1', '1', '1'),
(21, 5, 203, '1', '1', '1', '1'),
(22, 5, 159, '1', '1', '1', '1'),
(23, 5, 165, '1', '1', '1', '1'),
(24, 5, 26, '1', '1', '1', '1'),
(25, 5, 138, '1', '1', '1', '1'),
(26, 5, 123, '1', '1', '1', '1'),
(27, 5, 48, '1', '1', '1', '1'),
(28, 5, 54, '1', '1', '1', '1'),
(29, 4, 303, '1', '1', '1', '1');
-- --------------------------------------------------------
-- Table structure for table `assets`
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_asset_id` int(11) DEFAULT NULL,
`foreign_key` int(11) DEFAULT NULL,
`model` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`filesize` int(11) DEFAULT NULL,
`width` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`mime_type` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`extension` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`hash` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`adapter` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Gaufrette Storage Adapter Class',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modified` timestamp NULL DEFAULT NULL,
UNIQUE KEY `un_assets_dimension` (`parent_asset_id`,`width`,`height`),
KEY `ix_assets_hash` (`hash`,`path`),
KEY `fk_assets` (`model`,`foreign_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `asset_usages`
CREATE TABLE `asset_usages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`asset_id` int(11) NOT NULL,
`model` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`foreign_key` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
`type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modified` timestamp NULL DEFAULT NULL,
`params` text COLLATE utf8_unicode_ci,
KEY `fk_asset_usage` (`model`,`foreign_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `attachments`
CREATE TABLE `attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`body` text COLLATE utf8_unicode_ci,