Default page

Edit File: croogo.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: `croogo407`
--

-- --------------------------------------------------------

--
-- Table structure for table `acos`
--

CREATE 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,
  PRIMARY KEY (`id`)
) 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`
--

CREATE 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,
  PRIMARY KEY (`id`)
) 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',
  PRIMARY KEY (`id`)
) 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`
--

CREATE 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,
  PRIMARY KEY (`id`),
  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,
  PRIMARY KEY (`id`),
  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,
  `excerpt` text COLLATE utf8_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `sticky` tinyint(1) NOT NULL DEFAULT '0',
  `visibility_roles` text COLLATE utf8_unicode_ci,
  `hash` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `plugin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_path` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  `asset_count` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_attachments_hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `blocks`
--

CREATE TABLE `blocks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `region_id` int(20) DEFAULT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `show_title` tinyint(1) NOT NULL DEFAULT '1',
  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `element` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `visibility_roles` text COLLATE utf8_unicode_ci,
  `visibility_paths` text COLLATE utf8_unicode_ci,
  `visibility_php` text COLLATE utf8_unicode_ci,
  `params` text COLLATE utf8_unicode_ci,
  `publish_start` datetime DEFAULT NULL,
  `publish_end` datetime DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`),
  KEY `fk_blocks2regions` (`region_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `blocks`
--

INSERT INTO `blocks` VALUES
(3, 4, 'About', 'about', 'This is the content of your block. Can be modified in admin panel.', 1, '', 1, 2, '', '', '', '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(5, 4, 'Meta', 'meta', '[menu:meta]', 1, '', 1, 6, '', '', '', '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(6, 4, 'Blogroll', 'blogroll', '[menu:blogroll]', 1, '', 1, 4, '', '', '', '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(7, 4, 'Categories', 'categories', '[vocabulary:categories type="blog"]', 1, '', 1, 3, '', '', '', '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(8, 4, 'Search', 'search', '', 0, '', 1, 1, 'Croogo/Nodes.search', '', '', '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(9, 4, 'Recent Posts', 'recent_posts', '[node:recent_posts order="Nodes.id DESC" limit="5"]', 1, '', 1, 5, '', '', '', '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(20) DEFAULT NULL,
  `model` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Node',
  `foreign_key` int(20) NOT NULL,
  `user_id` int(20) DEFAULT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `website` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `rating` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `notify` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `comment_type` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'comment',
  `lft` int(11) DEFAULT NULL,
  `rght` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) DEFAULT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `model` (`model`,`foreign_key`),
  KEY `fk_comments2users` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` VALUES
(1, NULL, 'Croogo/Nodes.Nodes', 1, NULL, 'Mr Croogo', 'email@example.com', 'http://www.croogo.org', '127.0.0.1', '', 'Hi, this is the first comment.', NULL, 1, 0, 'blog', 'comment', 1, 2, '[[regtime]]', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `body` text COLLATE utf8_unicode_ci,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `position` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `address2` text COLLATE utf8_unicode_ci,
  `state` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `postcode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message_status` tinyint(1) NOT NULL DEFAULT '1',
  `message_archive` tinyint(1) NOT NULL DEFAULT '1',
  `message_count` int(11) NOT NULL DEFAULT '0',
  `message_spam_protection` tinyint(1) NOT NULL DEFAULT '0',
  `message_captcha` tinyint(1) NOT NULL DEFAULT '0',
  `message_notify` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` VALUES
(1, 'Contact', 'contact', '', '', '', '', '', '', '', '', '', '', 'you@your-site.com', 1, 0, 0, 0, 0, 1, 1, '[[regtime]]', NULL, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_acl_phinxlog`
--

CREATE TABLE `croogo_acl_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_acl_phinxlog`
--

INSERT INTO `croogo_acl_phinxlog` VALUES
(20160807104926, 'AclInitialMigration', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_blocks_phinxlog`
--

CREATE TABLE `croogo_blocks_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_blocks_phinxlog`
--

INSERT INTO `croogo_blocks_phinxlog` VALUES
(20160807104952, 'BlocksInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20171210054951, 'BlocksAddForeignKeys', '[[regtime]]', '[[regtime]]', 0),
(20191120012124, 'BlocksSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_comments_phinxlog`
--

CREATE TABLE `croogo_comments_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_comments_phinxlog`
--

INSERT INTO `croogo_comments_phinxlog` VALUES
(20160807105013, 'CommentsInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20171218081825, 'CommentsAddForeignKeys', '[[regtime]]', '[[regtime]]', 0),
(20191120012457, 'CommentsSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_contacts_phinxlog`
--

CREATE TABLE `croogo_contacts_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_contacts_phinxlog`
--

INSERT INTO `croogo_contacts_phinxlog` VALUES
(20160807105032, 'ContactsInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20171218082143, 'ContactsAddForeignKeys', '[[regtime]]', '[[regtime]]', 0),
(20191120012527, 'ContactsSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_dashboards_phinxlog`
--

CREATE TABLE `croogo_dashboards_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_dashboards_phinxlog`
--

INSERT INTO `croogo_dashboards_phinxlog` VALUES
(20160807105058, 'DashboardsInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20171218082515, 'DashboardsAddForeignKeys', '[[regtime]]', '[[regtime]]', 0),
(20191120012626, 'DashboardsSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_file_manager_phinxlog`
--

CREATE TABLE `croogo_file_manager_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_file_manager_phinxlog`
--

INSERT INTO `croogo_file_manager_phinxlog` VALUES
(20191115050000, 'FileManagerInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20191120012700, 'FileManagerSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_menus_phinxlog`
--

CREATE TABLE `croogo_menus_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_menus_phinxlog`
--

INSERT INTO `croogo_menus_phinxlog` VALUES
(20160807105149, 'MenusInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20160807131950, 'UpgradeMenus', '[[regtime]]', '[[regtime]]', 0),
(20171218082635, 'MenusAddForeignKeys', '[[regtime]]', '[[regtime]]', 0),
(20191120012729, 'MenusSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_meta_phinxlog`
--

CREATE TABLE `croogo_meta_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_meta_phinxlog`
--

INSERT INTO `croogo_meta_phinxlog` VALUES
(20160807105202, 'MetaInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20191120012807, 'MetaSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_nodes_phinxlog`
--

CREATE TABLE `croogo_nodes_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_nodes_phinxlog`
--

INSERT INTO `croogo_nodes_phinxlog` VALUES
(20160807105214, 'NodesInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20171210054111, 'NodesAddForeignKeys', '[[regtime]]', '[[regtime]]', 0),
(20191120012834, 'NodesSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_settings_phinxlog`
--

CREATE TABLE `croogo_settings_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_settings_phinxlog`
--

INSERT INTO `croogo_settings_phinxlog` VALUES
(20160807105227, 'SettingsInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20171206045454, 'EnlargeLanguagesFields', '[[regtime]]', '[[regtime]]', 0),
(20191120012902, 'SettingsSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_taxonomy_phinxlog`
--

CREATE TABLE `croogo_taxonomy_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_taxonomy_phinxlog`
--

INSERT INTO `croogo_taxonomy_phinxlog` VALUES
(20160807105245, 'TaxonomyInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20171218083005, 'TaxonomyAddForeignKeys', '[[regtime]]', '[[regtime]]', 0),
(20191120012924, 'TaxonomySyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `croogo_users_phinxlog`
--

CREATE TABLE `croogo_users_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `croogo_users_phinxlog`
--

INSERT INTO `croogo_users_phinxlog` VALUES
(20160807105314, 'UsersInitialMigration', '[[regtime]]', '[[regtime]]', 0),
(20171210044550, 'UsersAddForeignKeys', '[[regtime]]', '[[regtime]]', 0),
(20191120014021, 'UsersSyncTimestampFields', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `dashboards`
--

CREATE TABLE `dashboards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alias` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_id` int(20) NOT NULL DEFAULT '0',
  `column` int(20) NOT NULL DEFAULT '0',
  `weight` int(20) NOT NULL DEFAULT '0',
  `collapsed` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_dashboards2users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `native` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `locale` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `weight` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_languages_locale` (`locale`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=709 ;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES
(1, 'Afrikaans', '', 'af', 'af', 0, 1, '[[regtime]]', NULL, 1, NULL),
(2, 'Afrikaans (Namibia)', 'NamibiÃ«', 'af', 'af_NA', 0, 2, '[[regtime]]', NULL, 1, NULL),
(3, 'Afrikaans (South Africa)', 'Suid-Afrika', 'af', 'af_ZA', 0, 3, '[[regtime]]', NULL, 1, NULL),
(4, 'Aghem', '', 'agq', 'agq', 0, 4, '[[regtime]]', NULL, 1, NULL),
(5, 'Aghem (Cameroon)', 'KÃ mÃ lÃ»Å‹', 'agq', 'agq_CM', 0, 5, '[[regtime]]', NULL, 1, NULL),
(6, 'Akan', '', 'ak', 'ak', 0, 6, '[[regtime]]', NULL, 1, NULL),
(7, 'Akan (Ghana)', 'Gaana', 'ak', 'ak_GH', 0, 7, '[[regtime]]', NULL, 1, NULL),
(8, 'Amharic', '', 'am', 'am', 0, 8, '[[regtime]]', NULL, 1, NULL),
(9, 'Amharic (Ethiopia)', 'áŠ¢á‰µá‹®áŒµá‹«', 'am', 'am_ET', 0, 9, '[[regtime]]', NULL, 1, NULL),
(10, 'Arabic', '', 'ar', 'ar', 1, 10, '[[regtime]]', NULL, 1, NULL),
(11, 'Arabic (World)', 'Ø§Ù„Ø¹Ø§Ù„Ù…', 'ar', 'ar_001', 0, 11, '[[regtime]]', NULL, 1, NULL),
(12, 'Arabic (United Arab Emirates)', 'Ø§Ù„Ø¥Ù…Ø§Ø±Ø§Øª Ø§Ù„Ø¹Ø±Ø¨ÙŠØ© Ø§Ù„Ù…ØªØØ¯Ø©', 'ar', 'ar_AE', 0, 12, '[[regtime]]', NULL, 1, NULL),
(13, 'Arabic (Bahrain)', 'Ø§Ù„Ø¨ØØ±ÙŠÙ†', 'ar', 'ar_BH', 0, 13, '[[regtime]]', NULL, 1, NULL),
(14, 'Arabic (Djibouti)', 'Ø¬ÙŠØ¨ÙˆØªÙŠ', 'ar', 'ar_DJ', 0, 14, '[[regtime]]', NULL, 1, NULL),
(15, 'Arabic (Algeria)', 'Ø§Ù„Ø¬Ø²Ø§Ø¦Ø±', 'ar', 'ar_DZ', 0, 15, '[[regtime]]', NULL, 1, NULL),
(16, 'Arabic (Egypt)', 'Ù…ØµØ±', 'ar', 'ar_EG', 0, 16, '[[regtime]]', NULL, 1, NULL),
(17, 'Arabic (Western Sahara)', 'Ø§Ù„ØµØØ±Ø§Ø¡ Ø§Ù„ØºØ±Ø¨ÙŠØ©', 'ar', 'ar_EH', 0, 17, '[[regtime]]', NULL, 1, NULL),
(18, 'Arabic (Eritrea)', 'Ø¥Ø±ÙŠØªØ±ÙŠØ§', 'ar', 'ar_ER', 0, 18, '[[regtime]]', NULL, 1, NULL),
(19, 'Arabic (Israel)', 'Ø¥Ø³Ø±Ø§Ø¦ÙŠÙ„', 'ar', 'ar_IL', 0, 19, '[[regtime]]', NULL, 1, NULL),
(20, 'Arabic (Iraq)', 'Ø§Ù„Ø¹Ø±Ø§Ù‚', 'ar', 'ar_IQ', 0, 20, '[[regtime]]', NULL, 1, NULL),
(21, 'Arabic (Jordan)', 'Ø§Ù„Ø£Ø±Ø¯Ù†', 'ar', 'ar_JO', 0, 21, '[[regtime]]', NULL, 1, NULL),
(22, 'Arabic (Comoros)', 'Ø¬Ø²Ø± Ø§Ù„Ù‚Ù…Ø±', 'ar', 'ar_KM', 0, 22, '[[regtime]]', NULL, 1, NULL),
(23, 'Arabic (Kuwait)', 'Ø§Ù„ÙƒÙˆÙŠØª', 'ar', 'ar_KW', 0, 23, '[[regtime]]', NULL, 1, NULL),
(24, 'Arabic (Lebanon)', 'Ù„Ø¨Ù†Ø§Ù†', 'ar', 'ar_LB', 0, 24, '[[regtime]]', NULL, 1, NULL),
(25, 'Arabic (Libya)', 'Ù„ÙŠØ¨ÙŠØ§', 'ar', 'ar_LY', 0, 25, '[[regtime]]', NULL, 1, NULL),
(26, 'Arabic (Morocco)', 'Ø§Ù„Ù…ØºØ±Ø¨', 'ar', 'ar_MA', 0, 26, '[[regtime]]', NULL, 1, NULL),
(27, 'Arabic (Mauritania)', 'Ù…ÙˆØ±ÙŠØªØ§Ù†ÙŠØ§', 'ar', 'ar_MR', 0, 27, '[[regtime]]', NULL, 1, NULL),
(28, 'Arabic (Oman)', 'Ø¹ÙÙ…Ø§Ù†', 'ar', 'ar_OM', 0, 28, '[[regtime]]', NULL, 1, NULL),
(29, 'Arabic (Palestinian Territories)', 'Ø§Ù„Ø£Ø±Ø§Ø¶ÙŠ Ø§Ù„ÙÙ„Ø³Ø·ÙŠÙ†ÙŠØ©', 'ar', 'ar_PS', 0, 29, '[[regtime]]', NULL, 1, NULL),
(30, 'Arabic (Qatar)', 'Ù‚Ø·Ø±', 'ar', 'ar_QA', 0, 30, '[[regtime]]', NULL, 1, NULL),
(31, 'Arabic (Saudi Arabia)', 'Ø§Ù„Ù…Ù…Ù„ÙƒØ© Ø§Ù„Ø¹Ø±Ø¨ÙŠØ© Ø§Ù„Ø³Ø¹ÙˆØ¯ÙŠØ©', 'ar', 'ar_SA', 0, 31, '[[regtime]]', NULL, 1, NULL),
(32, 'Arabic (Sudan)', 'Ø§Ù„Ø³ÙˆØ¯Ø§Ù†', 'ar', 'ar_SD', 0, 32, '[[regtime]]', NULL, 1, NULL),
(33, 'Arabic (Somalia)', 'Ø§Ù„ØµÙˆÙ…Ø§Ù„', 'ar', 'ar_SO', 0, 33, '[[regtime]]', NULL, 1, NULL),
(34, 'Arabic (South Sudan)', 'Ø¬Ù†ÙˆØ¨ Ø§Ù„Ø³ÙˆØ¯Ø§Ù†', 'ar', 'ar_SS', 0, 34, '[[regtime]]', NULL, 1, NULL),
(35, 'Arabic (Syria)', 'Ø³ÙˆØ±ÙŠØ§', 'ar', 'ar_SY', 0, 35, '[[regtime]]', NULL, 1, NULL),
(36, 'Arabic (Chad)', 'ØªØ´Ø§Ø¯', 'ar', 'ar_TD', 0, 36, '[[regtime]]', NULL, 1, NULL),
(37, 'Arabic (Tunisia)', 'ØªÙˆÙ†Ø³', 'ar', 'ar_TN', 0, 37, '[[regtime]]', NULL, 1, NULL),
(38, 'Arabic (Yemen)', 'Ø§Ù„ÙŠÙ…Ù†', 'ar', 'ar_YE', 0, 38, '[[regtime]]', NULL, 1, NULL),
(39, 'Assamese', '', 'as', 'as', 0, 39, '[[regtime]]', NULL, 1, NULL),
(40, 'Assamese (India)', 'à¦à¦¾à§°à¦¤', 'as', 'as_IN', 0, 40, '[[regtime]]', NULL, 1, NULL),
(41, 'Asu', '', 'asa', 'asa', 0, 41, '[[regtime]]', NULL, 1, NULL),
(42, 'Asu (Tanzania)', 'Tadhania', 'asa', 'asa_TZ', 0, 42, '[[regtime]]', NULL, 1, NULL),
(43, 'Asturian', '', 'ast', 'ast', 0, 43, '[[regtime]]', NULL, 1, NULL),
(44, 'Asturian (Spain)', 'EspaÃ±a', 'ast', 'ast_ES', 0, 44, '[[regtime]]', NULL, 1, NULL),
(45, 'Azerbaijani', '', 'az', 'az', 0, 45, '[[regtime]]', NULL, 1, NULL),
(46, 'Azerbaijani (Cyrillic)', '', 'az', 'az_Cyrl', 0, 46, '[[regtime]]', NULL, 1, NULL),
(47, 'Azerbaijani (Cyrillic, Azerbaijan)', 'ÐÐ·Ó™Ñ€Ð±Ð°Ñ˜Ò¹Ð°Ð½', 'az', 'az_Cyrl_AZ', 0, 47, '[[regtime]]', NULL, 1, NULL),
(48, 'Azerbaijani (Latin)', '', 'az', 'az_Latn', 0, 48, '[[regtime]]', NULL, 1, NULL),
(49, 'Azerbaijani (Latin, Azerbaijan)', 'AzÉ™rbaycan', 'az', 'az_Latn_AZ', 0, 49, '[[regtime]]', NULL, 1, NULL),
(50, 'Basaa', '', 'bas', 'bas', 0, 50, '[[regtime]]', NULL, 1, NULL),
(51, 'Basaa (Cameroon)', 'KÃ mÉ›Ì€rÃ»n', 'bas', 'bas_CM', 0, 51, '[[regtime]]', NULL, 1, NULL),
(52, 'Belarusian', '', 'be', 'be', 0, 52, '[[regtime]]', NULL, 1, NULL),
(53, 'Belarusian (Belarus)', 'Ð‘ÐµÐ»Ð°Ñ€ÑƒÑÑŒ', 'be', 'be_BY', 0, 53, '[[regtime]]', NULL, 1, NULL),
(54, 'Bemba', '', 'bem', 'bem', 0, 54, '[[regtime]]', NULL, 1, NULL),
(55, 'Bemba (Zambia)', 'Zambia', 'bem', 'bem_ZM', 0, 55, '[[regtime]]', NULL, 1, NULL),
(56, 'Bena', '', 'bez', 'bez', 0, 56, '[[regtime]]', NULL, 1, NULL),
(57, 'Bena (Tanzania)', 'Hutanzania', 'bez', 'bez_TZ', 0, 57, '[[regtime]]', NULL, 1, NULL),
(58, 'Bulgarian', '', 'bg', 'bg', 1, 58, '[[regtime]]', NULL, 1, NULL),
(59, 'Bulgarian (Bulgaria)', 'Ð‘ÑŠÐ»Ð³Ð°Ñ€Ð¸Ñ', 'bg', 'bg_BG', 0, 59, '[[regtime]]', NULL, 1, NULL),
(60, 'Bambara', '', 'bm', 'bm', 0, 60, '[[regtime]]', NULL, 1, NULL),
(61, 'Bambara (Mali)', 'Mali', 'bm', 'bm_ML', 0, 61, '[[regtime]]', NULL, 1, NULL),
(62, 'Bangla', '', 'bn', 'bn', 0, 62, '[[regtime]]', NULL, 1, NULL),
(63, 'Bangla (Bangladesh)', 'à¦¬à¦¾à¦‚à¦²à¦¾à¦¦à§‡à¦¶', 'bn', 'bn_BD', 0, 63, '[[regtime]]', NULL, 1, NULL),
(64, 'Bangla (India)', 'à¦à¦¾à¦°à¦¤', 'bn', 'bn_IN', 0, 64, '[[regtime]]', NULL, 1, NULL),
(65, 'Tibetan', '', 'bo', 'bo', 0, 65, '[[regtime]]', NULL, 1, NULL),
(66, 'Tibetan (China)', 'à½¢à¾’à¾±à¼‹à½“à½‚', 'bo', 'bo_CN', 0, 66, '[[regtime]]', NULL, 1, NULL),
(67, 'Tibetan (India)', 'à½¢à¾’à¾±à¼‹à½‚à½¢à¼‹', 'bo', 'bo_IN', 0, 67, '[[regtime]]', NULL, 1, NULL),
(68, 'Breton', '', 'br', 'br', 0, 68, '[[regtime]]', NULL, 1, NULL),
(69, 'Breton (France)', 'FraÃ±s', 'br', 'br_FR', 0, 69, '[[regtime]]', NULL, 1, NULL),
(70, 'Bodo', '', 'brx', 'brx', 0, 70, '[[regtime]]', NULL, 1, NULL),
(71, 'Bodo (India)', 'à¤à¤¾à¤°à¤¤', 'brx', 'brx_IN', 0, 71, '[[regtime]]', NULL, 1, NULL),
(72, 'Bosnian', '', 'bs', 'bs', 0, 72, '[[regtime]]', NULL, 1, NULL),
(73, 'Bosnian (Cyrillic)', '', 'bs', 'bs_Cyrl', 0, 73, '[[regtime]]', NULL, 1, NULL),
(74, 'Bosnian (Cyrillic, Bosnia & Herzegovina)', 'Ð‘Ð¾ÑÐ½Ð° Ð¸ Ð¥ÐµÑ€Ñ†ÐµÐ³Ð¾Ð²Ð¸Ð½Ð°', 'bs', 'bs_Cyrl_BA', 0, 74, '[[regtime]]', NULL, 1, NULL),
(75, 'Bosnian (Latin)', '', 'bs', 'bs_Latn', 0, 75, '[[regtime]]', NULL, 1, NULL),
(76, 'Bosnian (Latin, Bosnia & Herzegovina)', 'Bosna i Hercegovina', 'bs', 'bs_Latn_BA', 0, 76, '[[regtime]]', NULL, 1, NULL),
(77, 'Catalan', '', 'ca', 'ca', 0, 77, '[[regtime]]', NULL, 1, NULL),
(78, 'Catalan (Andorra)', 'Andorra', 'ca', 'ca_AD', 0, 78, '[[regtime]]', NULL, 1, NULL),
(79, 'Catalan (Spain)', 'Espanya', 'ca', 'ca_ES', 0, 79, '[[regtime]]', NULL, 1, NULL),
(80, 'Catalan (France)', 'FranÃ§a', 'ca', 'ca_FR', 0, 80, '[[regtime]]', NULL, 1, NULL),
(81, 'Catalan (Italy)', 'ItÃ lia', 'ca', 'ca_IT', 0, 81, '[[regtime]]', NULL, 1, NULL),
(82, 'Chechen', '', 'ce', 'ce', 0, 82, '[[regtime]]', NULL, 1, NULL),
(83, 'Chechen (Russia)', 'Ð Ð¾ÑÑÐ¸', 'ce', 'ce_RU', 0, 83, '[[regtime]]', NULL, 1, NULL),
(84, 'Chiga', '', 'cgg', 'cgg', 0, 84, '[[regtime]]', NULL, 1, NULL),
(85, 'Chiga (Uganda)', 'Uganda', 'cgg', 'cgg_UG', 0, 85, '[[regtime]]', NULL, 1, NULL),
(86, 'Cherokee', '', 'chr', 'chr', 0, 86, '[[regtime]]', NULL, 1, NULL),
(87, 'Cherokee (United States)', 'áŒáŠ áŽ¢á³áŽ¾áŽµáá”á… ááŽ¦ášáŽ©', 'chr', 'chr_US', 0, 87, '[[regtime]]', NULL, 1, NULL),
(88, 'Central Kurdish', '', 'ckb', 'ckb', 0, 88, '[[regtime]]', NULL, 1, NULL),
(89, 'Central Kurdish (Iraq)', 'Ø¹ÛŽØ±Ø§Ù‚', 'ckb', 'ckb_IQ', 0, 89, '[[regtime]]', NULL, 1, NULL),
(90, 'Central Kurdish (Iran)', 'Ø¦ÛŽØ±Ø§Ù†', 'ckb', 'ckb_IR', 0, 90, '[[regtime]]', NULL, 1, NULL),
(91, 'Czech', '', 'cs', 'cs', 1, 91, '[[regtime]]', NULL, 1, NULL),
(92, 'Czech (Czech Republic)', 'ÄŒeskÃ¡ republika', 'cs', 'cs_CZ', 0, 92, '[[regtime]]', NULL, 1, NULL),
(93, 'Welsh', '', 'cy', 'cy', 0, 93, '[[regtime]]', NULL, 1, NULL),
(94, 'Welsh (United Kingdom)', 'Y Deyrnas Unedig', 'cy', 'cy_GB', 0, 94, '[[regtime]]', NULL, 1, NULL),
(95, 'Danish', '', 'da', 'da', 0, 95, '[[regtime]]', NULL, 1, NULL),
(96, 'Danish (Denmark)', 'Danmark', 'da', 'da_DK', 0, 96, '[[regtime]]', NULL, 1, NULL),
(97, 'Danish (Greenland)', 'GrÃ¸nland', 'da', 'da_GL', 0, 97, '[[regtime]]', NULL, 1, NULL),
(98, 'Taita', '', 'dav', 'dav', 0, 98, '[[regtime]]', NULL, 1, NULL),
(99, 'Taita (Kenya)', 'Kenya', 'dav', 'dav_KE', 0, 99, '[[regtime]]', NULL, 1, NULL),
(100, 'German', '', 'de', 'de', 1, 100, '[[regtime]]', NULL, 1, NULL),
(101, 'German (Austria)', 'Ã–sterreich', 'de', 'de_AT', 0, 101, '[[regtime]]', NULL, 1, NULL),
(102, 'German (Belgium)', 'Belgien', 'de', 'de_BE', 0, 102, '[[regtime]]', NULL, 1, NULL),
(103, 'German (Switzerland)', 'Schweiz', 'de', 'de_CH', 0, 103, '[[regtime]]', NULL, 1, NULL),
(104, 'German (Germany)', 'Deutschland', 'de', 'de_DE', 0, 104, '[[regtime]]', NULL, 1, NULL),
(105, 'German (Italy)', 'Italien', 'de', 'de_IT', 0, 105, '[[regtime]]', NULL, 1, NULL),
(106, 'German (Liechtenstein)', 'Liechtenstein', 'de', 'de_LI', 0, 106, '[[regtime]]', NULL, 1, NULL),
(107, 'German (Luxembourg)', 'Luxemburg', 'de', 'de_LU', 0, 107, '[[regtime]]', NULL, 1, NULL),
(108, 'Zarma', '', 'dje', 'dje', 0, 108, '[[regtime]]', NULL, 1, NULL),
(109, 'Zarma (Niger)', 'NiÅ¾er', 'dje', 'dje_NE', 0, 109, '[[regtime]]', NULL, 1, NULL),
(110, 'Lower Sorbian', '', 'dsb', 'dsb', 0, 110, '[[regtime]]', NULL, 1, NULL),
(111, 'Lower Sorbian (Germany)', 'Nimska', 'dsb', 'dsb_DE', 0, 111, '[[regtime]]', NULL, 1, NULL),
(112, 'Duala', '', 'dua', 'dua', 0, 112, '[[regtime]]', NULL, 1, NULL),
(113, 'Duala (Cameroon)', 'Cameroun', 'dua', 'dua_CM', 0, 113, '[[regtime]]', NULL, 1, NULL),
(114, 'Jola-Fonyi', '', 'dyo', 'dyo', 0, 114, '[[regtime]]', NULL, 1, NULL),
(115, 'Jola-Fonyi (Senegal)', 'Senegal', 'dyo', 'dyo_SN', 0, 115, '[[regtime]]', NULL, 1, NULL),
(116, 'Dzongkha', '', 'dz', 'dz', 0, 116, '[[regtime]]', NULL, 1, NULL),
(117, 'Dzongkha (Bhutan)', 'à½ à½–à¾²à½´à½‚', 'dz', 'dz_BT', 0, 117, '[[regtime]]', NULL, 1, NULL),
(118, 'Embu', '', 'ebu', 'ebu', 0, 118, '[[regtime]]', NULL, 1, NULL),
(119, 'Embu (Kenya)', 'Kenya', 'ebu', 'ebu_KE', 0, 119, '[[regtime]]', NULL, 1, NULL),
(120, 'Ewe', '', 'ee', 'ee', 0, 120, '[[regtime]]', NULL, 1, NULL),
(121, 'Ewe (Ghana)', 'Ghana nutome', 'ee', 'ee_GH', 0, 121, '[[regtime]]', NULL, 1, NULL),
(122, 'Ewe (Togo)', 'Togo nutome', 'ee', 'ee_TG', 0, 122, '[[regtime]]', NULL, 1, NULL),
(123, 'Greek', '', 'el', 'el', 1, 123, '[[regtime]]', NULL, 1, NULL),
(124, 'Greek (Cyprus)', 'ÎšÏÏ€ÏÎ¿Ï‚', 'el', 'el_CY', 0, 124, '[[regtime]]', NULL, 1, NULL),
(125, 'Greek (Greece)', 'Î•Î»Î»Î¬Î´Î±', 'el', 'el_GR', 0, 125, '[[regtime]]', NULL, 1, NULL),
(126, 'English', '', 'en', 'en', 1, 126, '[[regtime]]', NULL, 1, NULL),
(127, 'English (World)', 'World', 'en', 'en_001', 0, 127, '[[regtime]]', NULL, 1, NULL),
(128, 'English (Europe)', 'Europe', 'en', 'en_150', 0, 128, '[[regtime]]', NULL, 1, NULL),
(129, 'English (Antigua & Barbuda)', 'Antigua & Barbuda', 'en', 'en_AG', 0, 129, '[[regtime]]', NULL, 1, NULL),
(130, 'English (Anguilla)', 'Anguilla', 'en', 'en_AI', 0, 130, '[[regtime]]', NULL, 1, NULL),
(131, 'English (American Samoa)', 'American Samoa', 'en', 'en_AS', 0, 131, '[[regtime]]', NULL, 1, NULL),
(132, 'English (Austria)', 'Austria', 'en', 'en_AT', 0, 132, '[[regtime]]', NULL, 1, NULL),
(133, 'English (Australia)', 'Australia', 'en', 'en_AU', 0, 133, '[[regtime]]', NULL, 1, NULL),
(134, 'English (Barbados)', 'Barbados', 'en', 'en_BB', 0, 134, '[[regtime]]', NULL, 1, NULL),
(135, 'English (Belgium)', 'Belgium', 'en', 'en_BE', 0, 135, '[[regtime]]', NULL, 1, NULL),
(136, 'English (Burundi)', 'Burundi', 'en', 'en_BI', 0, 136, '[[regtime]]', NULL, 1, NULL),
(137, 'English (Bermuda)', 'Bermuda', 'en', 'en_BM', 0, 137, '[[regtime]]', NULL, 1, NULL),
(138, 'English (Bahamas)', 'Bahamas', 'en', 'en_BS', 0, 138, '[[regtime]]', NULL, 1, NULL),
(139, 'English (Botswana)', 'Botswana', 'en', 'en_BW', 0, 139, '[[regtime]]', NULL, 1, NULL),
(140, 'English (Belize)', 'Belize', 'en', 'en_BZ', 0, 140, '[[regtime]]', NULL, 1, NULL),
(141, 'English (Canada)', 'Canada', 'en', 'en_CA', 0, 141, '[[regtime]]', NULL, 1, NULL),
(142, 'English (Cocos [Keeling] Islands)', 'Cocos (Keeling) Islands', 'en', 'en_CC', 0, 142, '[[regtime]]', NULL, 1, NULL),
(143, 'English (Switzerland)', 'Switzerland', 'en', 'en_CH', 0, 143, '[[regtime]]', NULL, 1, NULL),
(144, 'English (Cook Islands)', 'Cook Islands', 'en', 'en_CK', 0, 144, '[[regtime]]', NULL, 1, NULL),
(145, 'English (Cameroon)', 'Cameroon', 'en', 'en_CM', 0, 145, '[[regtime]]', NULL, 1, NULL),
(146, 'English (Christmas Island)', 'Christmas Island', 'en', 'en_CX', 0, 146, '[[regtime]]', NULL, 1, NULL),
(147, 'English (Cyprus)', 'Cyprus', 'en', 'en_CY', 0, 147, '[[regtime]]', NULL, 1, NULL),
(148, 'English (Germany)', 'Germany', 'en', 'en_DE', 0, 148, '[[regtime]]', NULL, 1, NULL),
(149, 'English (Diego Garcia)', 'Diego Garcia', 'en', 'en_DG', 0, 149, '[[regtime]]', NULL, 1, NULL),
(150, 'English (Denmark)', 'Denmark', 'en', 'en_DK', 0, 150, '[[regtime]]', NULL, 1, NULL),
(151, 'English (Dominica)', 'Dominica', 'en', 'en_DM', 0, 151, '[[regtime]]', NULL, 1, NULL),
(152, 'English (Eritrea)', 'Eritrea', 'en', 'en_ER', 0, 152, '[[regtime]]', NULL, 1, NULL),
(153, 'English (Finland)', 'Finland', 'en', 'en_FI', 0, 153, '[[regtime]]', NULL, 1, NULL),
(154, 'English (Fiji)', 'Fiji', 'en', 'en_FJ', 0, 154, '[[regtime]]', NULL, 1, NULL),
(155, 'English (Falkland Islands)', 'Falkland Islands', 'en', 'en_FK', 0, 155, '[[regtime]]', NULL, 1, NULL),
(156, 'English (Micronesia)', 'Micronesia', 'en', 'en_FM', 0, 156, '[[regtime]]', NULL, 1, NULL),
(157, 'English (United Kingdom)', 'United Kingdom', 'en', 'en_GB', 0, 157, '[[regtime]]', NULL, 1, NULL),
(158, 'English (Grenada)', 'Grenada', 'en', 'en_GD', 0, 158, '[[regtime]]', NULL, 1, NULL),
(159, 'English (Guernsey)', 'Guernsey', 'en', 'en_GG', 0, 159, '[[regtime]]', NULL, 1, NULL),
(160, 'English (Ghana)', 'Ghana', 'en', 'en_GH', 0, 160, '[[regtime]]', NULL, 1, NULL),
(161, 'English (Gibraltar)', 'Gibraltar', 'en', 'en_GI', 0, 161, '[[regtime]]', NULL, 1, NULL),
(162, 'English (Gambia)', 'Gambia', 'en', 'en_GM', 0, 162, '[[regtime]]', NULL, 1, NULL),
(163, 'English (Guam)', 'Guam', 'en', 'en_GU', 0, 163, '[[regtime]]', NULL, 1, NULL),
(164, 'English (Guyana)', 'Guyana', 'en', 'en_GY', 0, 164, '[[regtime]]', NULL, 1, NULL),
(165, 'English (Hong Kong SAR China)', 'Hong Kong SAR China', 'en', 'en_HK', 0, 165, '[[regtime]]', NULL, 1, NULL),
(166, 'English (Ireland)', 'Ireland', 'en', 'en_IE', 0, 166, '[[regtime]]', NULL, 1, NULL),
(167, 'English (Israel)', 'Israel', 'en', 'en_IL', 0, 167, '[[regtime]]', NULL, 1, NULL),
(168, 'English (Isle of Man)', 'Isle of Man', 'en', 'en_IM', 0, 168, '[[regtime]]', NULL, 1, NULL),
(169, 'English (India)', 'India', 'en', 'en_IN', 0, 169, '[[regtime]]', NULL, 1, NULL),
(170, 'English (British Indian Ocean Territory)', 'British Indian Ocean Territory', 'en', 'en_IO', 0, 170, '[[regtime]]', NULL, 1, NULL),
(171, 'English (Jersey)', 'Jersey', 'en', 'en_JE', 0, 171, '[[regtime]]', NULL, 1, NULL),
(172, 'English (Jamaica)', 'Jamaica', 'en', 'en_JM', 0, 172, '[[regtime]]', NULL, 1, NULL),
(173, 'English (Kenya)', 'Kenya', 'en', 'en_KE', 0, 173, '[[regtime]]', NULL, 1, NULL),
(174, 'English (Kiribati)', 'Kiribati', 'en', 'en_KI', 0, 174, '[[regtime]]', NULL, 1, NULL),
(175, 'English (St. Kitts & Nevis)', 'St. Kitts & Nevis', 'en', 'en_KN', 0, 175, '[[regtime]]', NULL, 1, NULL),
(176, 'English (Cayman Islands)', 'Cayman Islands', 'en', 'en_KY', 0, 176, '[[regtime]]', NULL, 1, NULL),
(177, 'English (St. Lucia)', 'St. Lucia', 'en', 'en_LC', 0, 177, '[[regtime]]', NULL, 1, NULL),
(178, 'English (Liberia)', 'Liberia', 'en', 'en_LR', 0, 178, '[[regtime]]', NULL, 1, NULL),
(179, 'English (Lesotho)', 'Lesotho', 'en', 'en_LS', 0, 179, '[[regtime]]', NULL, 1, NULL),
(180, 'English (Madagascar)', 'Madagascar', 'en', 'en_MG', 0, 180, '[[regtime]]', NULL, 1, NULL),
(181, 'English (Marshall Islands)', 'Marshall Islands', 'en', 'en_MH', 0, 181, '[[regtime]]', NULL, 1, NULL),
(182, 'English (Macau SAR China)', 'Macau SAR China', 'en', 'en_MO', 0, 182, '[[regtime]]', NULL, 1, NULL),
(183, 'English (Northern Mariana Islands)', 'Northern Mariana Islands', 'en', 'en_MP', 0, 183, '[[regtime]]', NULL, 1, NULL),
(184, 'English (Montserrat)', 'Montserrat', 'en', 'en_MS', 0, 184, '[[regtime]]', NULL, 1, NULL),
(185, 'English (Malta)', 'Malta', 'en', 'en_MT', 0, 185, '[[regtime]]', NULL, 1, NULL),
(186, 'English (Mauritius)', 'Mauritius', 'en', 'en_MU', 0, 186, '[[regtime]]', NULL, 1, NULL),
(187, 'English (Malawi)', 'Malawi', 'en', 'en_MW', 0, 187, '[[regtime]]', NULL, 1, NULL),
(188, 'English (Malaysia)', 'Malaysia', 'en', 'en_MY', 0, 188, '[[regtime]]', NULL, 1, NULL),
(189, 'English (Namibia)', 'Namibia', 'en', 'en_NA', 0, 189, '[[regtime]]', NULL, 1, NULL),
(190, 'English (Norfolk Island)', 'Norfolk Island', 'en', 'en_NF', 0, 190, '[[regtime]]', NULL, 1, NULL),
(191, 'English (Nigeria)', 'Nigeria', 'en', 'en_NG', 0, 191, '[[regtime]]', NULL, 1, NULL),
(192, 'English (Netherlands)', 'Netherlands', 'en', 'en_NL', 0, 192, '[[regtime]]', NULL, 1, NULL),
(193, 'English (Nauru)', 'Nauru', 'en', 'en_NR', 0, 193, '[[regtime]]', NULL, 1, NULL),
(194, 'English (Niue)', 'Niue', 'en', 'en_NU', 0, 194, '[[regtime]]', NULL, 1, NULL),
(195, 'English (New Zealand)', 'New Zealand', 'en', 'en_NZ', 0, 195, '[[regtime]]', NULL, 1, NULL),
(196, 'English (Papua New Guinea)', 'Papua New Guinea', 'en', 'en_PG', 0, 196, '[[regtime]]', NULL, 1, NULL),
(197, 'English (Philippines)', 'Philippines', 'en', 'en_PH', 0, 197, '[[regtime]]', NULL, 1, NULL),
(198, 'English (Pakistan)', 'Pakistan', 'en', 'en_PK', 0, 198, '[[regtime]]', NULL, 1, NULL),
(199, 'English (Pitcairn Islands)', 'Pitcairn Islands', 'en', 'en_PN', 0, 199, '[[regtime]]', NULL, 1, NULL),
(200, 'English (Puerto Rico)', 'Puerto Rico', 'en', 'en_PR', 0, 200, '[[regtime]]', NULL, 1, NULL),
(201, 'English (Palau)', 'Palau', 'en', 'en_PW', 0, 201, '[[regtime]]', NULL, 1, NULL),
(202, 'English (Rwanda)', 'Rwanda', 'en', 'en_RW', 0, 202, '[[regtime]]', NULL, 1, NULL),
(203, 'English (Solomon Islands)', 'Solomon Islands', 'en', 'en_SB', 0, 203, '[[regtime]]', NULL, 1, NULL),
(204, 'English (Seychelles)', 'Seychelles', 'en', 'en_SC', 0, 204, '[[regtime]]', NULL, 1, NULL),
(205, 'English (Sudan)', 'Sudan', 'en', 'en_SD', 0, 205, '[[regtime]]', NULL, 1, NULL),
(206, 'English (Sweden)', 'Sweden', 'en', 'en_SE', 0, 206, '[[regtime]]', NULL, 1, NULL),
(207, 'English (Singapore)', 'Singapore', 'en', 'en_SG', 0, 207, '[[regtime]]', NULL, 1, NULL),
(208, 'English (St. Helena)', 'St. Helena', 'en', 'en_SH', 0, 208, '[[regtime]]', NULL, 1, NULL),
(209, 'English (Slovenia)', 'Slovenia', 'en', 'en_SI', 0, 209, '[[regtime]]', NULL, 1, NULL),
(210, 'English (Sierra Leone)', 'Sierra Leone', 'en', 'en_SL', 0, 210, '[[regtime]]', NULL, 1, NULL),
(211, 'English (South Sudan)', 'South Sudan', 'en', 'en_SS', 0, 211, '[[regtime]]', NULL, 1, NULL),
(212, 'English (Sint Maarten)', 'Sint Maarten', 'en', 'en_SX', 0, 212, '[[regtime]]', NULL, 1, NULL),
(213, 'English (Swaziland)', 'Swaziland', 'en', 'en_SZ', 0, 213, '[[regtime]]', NULL, 1, NULL),
(214, 'English (Turks & Caicos Islands)', 'Turks & Caicos Islands', 'en', 'en_TC', 0, 214, '[[regtime]]', NULL, 1, NULL),
(215, 'English (Tokelau)', 'Tokelau', 'en', 'en_TK', 0, 215, '[[regtime]]', NULL, 1, NULL),
(216, 'English (Tonga)', 'Tonga', 'en', 'en_TO', 0, 216, '[[regtime]]', NULL, 1, NULL),
(217, 'English (Trinidad & Tobago)', 'Trinidad & Tobago', 'en', 'en_TT', 0, 217, '[[regtime]]', NULL, 1, NULL),
(218, 'English (Tuvalu)', 'Tuvalu', 'en', 'en_TV', 0, 218, '[[regtime]]', NULL, 1, NULL),
(219, 'English (Tanzania)', 'Tanzania', 'en', 'en_TZ', 0, 219, '[[regtime]]', NULL, 1, NULL),
(220, 'English (Uganda)', 'Uganda', 'en', 'en_UG', 0, 220, '[[regtime]]', NULL, 1, NULL),
(221, 'English (U.S. Outlying Islands)', 'U.S. Outlying Islands', 'en', 'en_UM', 0, 221, '[[regtime]]', NULL, 1, NULL),
(222, 'English (United States)', 'United States', 'en', 'en_US', 0, 222, '[[regtime]]', NULL, 1, NULL),
(223, 'English (United States, Computer)', 'United States', 'en', 'en_US_POSIX', 0, 223, '[[regtime]]', NULL, 1, NULL),
(224, 'English (St. Vincent & Grenadines)', 'St. Vincent & Grenadines', 'en', 'en_VC', 0, 224, '[[regtime]]', NULL, 1, NULL),
(225, 'English (British Virgin Islands)', 'British Virgin Islands', 'en', 'en_VG', 0, 225, '[[regtime]]', NULL, 1, NULL),
(226, 'English (U.S. Virgin Islands)', 'U.S. Virgin Islands', 'en', 'en_VI', 0, 226, '[[regtime]]', NULL, 1, NULL),
(227, 'English (Vanuatu)', 'Vanuatu', 'en', 'en_VU', 0, 227, '[[regtime]]', NULL, 1, NULL),
(228, 'English (Samoa)', 'Samoa', 'en', 'en_WS', 0, 228, '[[regtime]]', NULL, 1, NULL),
(229, 'English (South Africa)', 'South Africa', 'en', 'en_ZA', 0, 229, '[[regtime]]', NULL, 1, NULL),
(230, 'English (Zambia)', 'Zambia', 'en', 'en_ZM', 0, 230, '[[regtime]]', NULL, 1, NULL),
(231, 'English (Zimbabwe)', 'Zimbabwe', 'en', 'en_ZW', 0, 231, '[[regtime]]', NULL, 1, NULL),
(232, 'Esperanto', '', 'eo', 'eo', 0, 232, '[[regtime]]', NULL, 1, NULL),
(233, 'Spanish', '', 'es', 'es', 1, 233, '[[regtime]]', NULL, 1, NULL),
(234, 'Spanish (Latin America)', 'LatinoamÃ©rica', 'es', 'es_419', 0, 234, '[[regtime]]', NULL, 1, NULL),
(235, 'Spanish (Argentina)', 'Argentina', 'es', 'es_AR', 0, 235, '[[regtime]]', NULL, 1, NULL),
(236, 'Spanish (Bolivia)', 'Bolivia', 'es', 'es_BO', 0, 236, '[[regtime]]', NULL, 1, NULL),
(237, 'Spanish (Brazil)', 'Brasil', 'es', 'es_BR', 0, 237, '[[regtime]]', NULL, 1, NULL),
(238, 'Spanish (Chile)', 'Chile', 'es', 'es_CL', 0, 238, '[[regtime]]', NULL, 1, NULL),
(239, 'Spanish (Colombia)', 'Colombia', 'es', 'es_CO', 0, 239, '[[regtime]]', NULL, 1, NULL),
(240, 'Spanish (Costa Rica)', 'Costa Rica', 'es', 'es_CR', 0, 240, '[[regtime]]', NULL, 1, NULL),
(241, 'Spanish (Cuba)', 'Cuba', 'es', 'es_CU', 0, 241, '[[regtime]]', NULL, 1, NULL),
(242, 'Spanish (Dominican Republic)', 'RepÃºblica Dominicana', 'es', 'es_DO', 0, 242, '[[regtime]]', NULL, 1, NULL),
(243, 'Spanish (Ceuta & Melilla)', 'Ceuta y Melilla', 'es', 'es_EA', 0, 243, '[[regtime]]', NULL, 1, NULL),
(244, 'Spanish (Ecuador)', 'Ecuador', 'es', 'es_EC', 0, 244, '[[regtime]]', NULL, 1, NULL),
(245, 'Spanish (Spain)', 'EspaÃ±a', 'es', 'es_ES', 0, 245, '[[regtime]]', NULL, 1, NULL),
(246, 'Spanish (Equatorial Guinea)', 'Guinea Ecuatorial', 'es', 'es_GQ', 0, 246, '[[regtime]]', NULL, 1, NULL),
(247, 'Spanish (Guatemala)', 'Guatemala', 'es', 'es_GT', 0, 247, '[[regtime]]', NULL, 1, NULL),
(248, 'Spanish (Honduras)', 'Honduras', 'es', 'es_HN', 0, 248, '[[regtime]]', NULL, 1, NULL),
(249, 'Spanish (Canary Islands)', 'Canarias', 'es', 'es_IC', 0, 249, '[[regtime]]', NULL, 1, NULL),
(250, 'Spanish (Mexico)', 'MÃ©xico', 'es', 'es_MX', 0, 250, '[[regtime]]', NULL, 1, NULL),
(251, 'Spanish (Nicaragua)', 'Nicaragua', 'es', 'es_NI', 0, 251, '[[regtime]]', NULL, 1, NULL),
(252, 'Spanish (Panama)', 'PanamÃ¡', 'es', 'es_PA', 0, 252, '[[regtime]]', NULL, 1, NULL),
(253, 'Spanish (Peru)', 'PerÃº', 'es', 'es_PE', 0, 253, '[[regtime]]', NULL, 1, NULL),
(254, 'Spanish (Philippines)', 'Filipinas', 'es', 'es_PH', 0, 254, '[[regtime]]', NULL, 1, NULL),
(255, 'Spanish (Puerto Rico)', 'Puerto Rico', 'es', 'es_PR', 0, 255, '[[regtime]]', NULL, 1, NULL),
(256, 'Spanish (Paraguay)', 'Paraguay', 'es', 'es_PY', 0, 256, '[[regtime]]', NULL, 1, NULL),
(257, 'Spanish (El Salvador)', 'El Salvador', 'es', 'es_SV', 0, 257, '[[regtime]]', NULL, 1, NULL),
(258, 'Spanish (United States)', 'Estados Unidos', 'es', 'es_US', 0, 258, '[[regtime]]', NULL, 1, NULL),
(259, 'Spanish (Uruguay)', 'Uruguay', 'es', 'es_UY', 0, 259, '[[regtime]]', NULL, 1, NULL),
(260, 'Spanish (Venezuela)', 'Venezuela', 'es', 'es_VE', 0, 260, '[[regtime]]', NULL, 1, NULL),
(261, 'Estonian', '', 'et', 'et', 0, 261, '[[regtime]]', NULL, 1, NULL),
(262, 'Estonian (Estonia)', 'Eesti', 'et', 'et_EE', 0, 262, '[[regtime]]', NULL, 1, NULL),
(263, 'Basque', '', 'eu', 'eu', 0, 263, '[[regtime]]', NULL, 1, NULL),
(264, 'Basque (Spain)', 'Espainia', 'eu', 'eu_ES', 0, 264, '[[regtime]]', NULL, 1, NULL),
(265, 'Ewondo', '', 'ewo', 'ewo', 0, 265, '[[regtime]]', NULL, 1, NULL),
(266, 'Ewondo (Cameroon)', 'KamÉ™rÃºn', 'ewo', 'ewo_CM', 0, 266, '[[regtime]]', NULL, 1, NULL),
(267, 'Persian', '', 'fa', 'fa', 1, 267, '[[regtime]]', NULL, 1, NULL),
(268, 'Persian (Afghanistan)', 'Ø§ÙØºØ§Ù†Ø³ØªØ§Ù†', 'fa', 'fa_AF', 0, 268, '[[regtime]]', NULL, 1, NULL),
(269, 'Persian (Iran)', 'Ø§ÛŒØ±Ø§Ù†', 'fa', 'fa_IR', 0, 269, '[[regtime]]', NULL, 1, NULL),
(270, 'Fulah', '', 'ff', 'ff', 0, 270, '[[regtime]]', NULL, 1, NULL),
(271, 'Fulah (Cameroon)', 'Kameruun', 'ff', 'ff_CM', 0, 271, '[[regtime]]', NULL, 1, NULL),
(272, 'Fulah (Guinea)', 'Gine', 'ff', 'ff_GN', 0, 272, '[[regtime]]', NULL, 1, NULL),
(273, 'Fulah (Mauritania)', 'Muritani', 'ff', 'ff_MR', 0, 273, '[[regtime]]', NULL, 1, NULL),
(274, 'Fulah (Senegal)', 'Senegaal', 'ff', 'ff_SN', 0, 274, '[[regtime]]', NULL, 1, NULL),
(275, 'Finnish', '', 'fi', 'fi', 0, 275, '[[regtime]]', NULL, 1, NULL),
(276, 'Finnish (Finland)', 'Suomi', 'fi', 'fi_FI', 0, 276, '[[regtime]]', NULL, 1, NULL),
(277, 'Filipino', '', 'fil', 'fil', 0, 277, '[[regtime]]', NULL, 1, NULL),
(278, 'Filipino (Philippines)', 'Pilipinas', 'fil', 'fil_PH', 0, 278, '[[regtime]]', NULL, 1, NULL),
(279, 'Faroese', '', 'fo', 'fo', 0, 279, '[[regtime]]', NULL, 1, NULL),
(280, 'Faroese (Denmark)', 'Danmark', 'fo', 'fo_DK', 0, 280, '[[regtime]]', NULL, 1, NULL),
(281, 'Faroese (Faroe Islands)', 'FÃ¸royar', 'fo', 'fo_FO', 0, 281, '[[regtime]]', NULL, 1, NULL),
(282, 'French', '', 'fr', 'fr', 1, 282, '[[regtime]]', NULL, 1, NULL),
(283, 'French (Belgium)', 'Belgique', 'fr', 'fr_BE', 0, 283, '[[regtime]]', NULL, 1, NULL),
(284, 'French (Burkina Faso)', 'Burkina Faso', 'fr', 'fr_BF', 0, 284, '[[regtime]]', NULL, 1, NULL),
(285, 'French (Burundi)', 'Burundi', 'fr', 'fr_BI', 0, 285, '[[regtime]]', NULL, 1, NULL),
(286, 'French (Benin)', 'BÃ©nin', 'fr', 'fr_BJ', 0, 286, '[[regtime]]', NULL, 1, NULL),
(287, 'French (St. BarthÃ©lemy)', 'Saint-BarthÃ©lemy', 'fr', 'fr_BL', 0, 287, '[[regtime]]', NULL, 1, NULL),
(288, 'French (Canada)', 'Canada', 'fr', 'fr_CA', 0, 288, '[[regtime]]', NULL, 1, NULL),
(289, 'French (Congo - Kinshasa)', 'Congo-Kinshasa', 'fr', 'fr_CD', 0, 289, '[[regtime]]', NULL, 1, NULL),
(290, 'French (Central African Republic)', 'RÃ©publique centrafricaine', 'fr', 'fr_CF', 0, 290, '[[regtime]]', NULL, 1, NULL),
(291, 'French (Congo - Brazzaville)', 'Congo-Brazzaville', 'fr', 'fr_CG', 0, 291, '[[regtime]]', NULL, 1, NULL),
(292, 'French (Switzerland)', 'Suisse', 'fr', 'fr_CH', 0, 292, '[[regtime]]', NULL, 1, NULL),
(293, 'French (CÃ´te dâ€™Ivoire)', 'CÃ´te dâ€™Ivoire', 'fr', 'fr_CI', 0, 293, '[[regtime]]', NULL, 1, NULL),
(294, 'French (Cameroon)', 'Cameroun', 'fr', 'fr_CM', 0, 294, '[[regtime]]', NULL, 1, NULL),
(295, 'French (Djibouti)', 'Djibouti', 'fr', 'fr_DJ', 0, 295, '[[regtime]]', NULL, 1, NULL),
(296, 'French (Algeria)', 'AlgÃ©rie', 'fr', 'fr_DZ', 0, 296, '[[regtime]]', NULL, 1, NULL),
(297, 'French (France)', 'France', 'fr', 'fr_FR', 0, 297, '[[regtime]]', NULL, 1, NULL),
(298, 'French (Gabon)', 'Gabon', 'fr', 'fr_GA', 0, 298, '[[regtime]]', NULL, 1, NULL),
(299, 'French (French Guiana)', 'Guyane franÃ§aise', 'fr', 'fr_GF', 0, 299, '[[regtime]]', NULL, 1, NULL),
(300, 'French (Guinea)', 'GuinÃ©e', 'fr', 'fr_GN', 0, 300, '[[regtime]]', NULL, 1, NULL),
(301, 'French (Guadeloupe)', 'Guadeloupe', 'fr', 'fr_GP', 0, 301, '[[regtime]]', NULL, 1, NULL),
(302, 'French (Equatorial Guinea)', 'GuinÃ©e Ã©quatoriale', 'fr', 'fr_GQ', 0, 302, '[[regtime]]', NULL, 1, NULL),
(303, 'French (Haiti)', 'HaÃ¯ti', 'fr', 'fr_HT', 0, 303, '[[regtime]]', NULL, 1, NULL),
(304, 'French (Comoros)', 'Comores', 'fr', 'fr_KM', 0, 304, '[[regtime]]', NULL, 1, NULL),
(305, 'French (Luxembourg)', 'Luxembourg', 'fr', 'fr_LU', 0, 305, '[[regtime]]', NULL, 1, NULL),
(306, 'French (Morocco)', 'Maroc', 'fr', 'fr_MA', 0, 306, '[[regtime]]', NULL, 1, NULL),
(307, 'French (Monaco)', 'Monaco', 'fr', 'fr_MC', 0, 307, '[[regtime]]', NULL, 1, NULL),
(308, 'French (St. Martin)', 'Saint-Martin', 'fr', 'fr_MF', 0, 308, '[[regtime]]', NULL, 1, NULL),
(309, 'French (Madagascar)', 'Madagascar', 'fr', 'fr_MG', 0, 309, '[[regtime]]', NULL, 1, NULL),
(310, 'French (Mali)', 'Mali', 'fr', 'fr_ML', 0, 310, '[[regtime]]', NULL, 1, NULL),
(311, 'French (Martinique)', 'Martinique', 'fr', 'fr_MQ', 0, 311, '[[regtime]]', NULL, 1, NULL),
(312, 'French (Mauritania)', 'Mauritanie', 'fr', 'fr_MR', 0, 312, '[[regtime]]', NULL, 1, NULL),
(313, 'French (Mauritius)', 'Maurice', 'fr', 'fr_MU', 0, 313, '[[regtime]]', NULL, 1, NULL),
(314, 'French (New Caledonia)', 'Nouvelle-CalÃ©donie', 'fr', 'fr_NC', 0, 314, '[[regtime]]', NULL, 1, NULL),
(315, 'French (Niger)', 'Niger', 'fr', 'fr_NE', 0, 315, '[[regtime]]', NULL, 1, NULL),
(316, 'French (French Polynesia)', 'PolynÃ©sie franÃ§aise', 'fr', 'fr_PF', 0, 316, '[[regtime]]', NULL, 1, NULL),
(317, 'French (St. Pierre & Miquelon)', 'Saint-Pierre-et-Miquelon', 'fr', 'fr_PM', 0, 317, '[[regtime]]', NULL, 1, NULL),
(318, 'French (RÃ©union)', 'La RÃ©union', 'fr', 'fr_RE', 0, 318, '[[regtime]]', NULL, 1, NULL),
(319, 'French (Rwanda)', 'Rwanda', 'fr', 'fr_RW', 0, 319, '[[regtime]]', NULL, 1, NULL),
(320, 'French (Seychelles)', 'Seychelles', 'fr', 'fr_SC', 0, 320, '[[regtime]]', NULL, 1, NULL),
(321, 'French (Senegal)', 'SÃ©nÃ©gal', 'fr', 'fr_SN', 0, 321, '[[regtime]]', NULL, 1, NULL),
(322, 'French (Syria)', 'Syrie', 'fr', 'fr_SY', 0, 322, '[[regtime]]', NULL, 1, NULL),
(323, 'French (Chad)', 'Tchad', 'fr', 'fr_TD', 0, 323, '[[regtime]]', NULL, 1, NULL),
(324, 'French (Togo)', 'Togo', 'fr', 'fr_TG', 0, 324, '[[regtime]]', NULL, 1, NULL),
(325, 'French (Tunisia)', 'Tunisie', 'fr', 'fr_TN', 0, 325, '[[regtime]]', NULL, 1, NULL),
(326, 'French (Vanuatu)', 'Vanuatu', 'fr', 'fr_VU', 0, 326, '[[regtime]]', NULL, 1, NULL),
(327, 'French (Wallis & Futuna)', 'Wallis-et-Futuna', 'fr', 'fr_WF', 0, 327, '[[regtime]]', NULL, 1, NULL),
(328, 'French (Mayotte)', 'Mayotte', 'fr', 'fr_YT', 0, 328, '[[regtime]]', NULL, 1, NULL),
(329, 'Friulian', '', 'fur', 'fur', 0, 329, '[[regtime]]', NULL, 1, NULL),
(330, 'Friulian (Italy)', 'Italie', 'fur', 'fur_IT', 0, 330, '[[regtime]]', NULL, 1, NULL),
(331, 'Western Frisian', '', 'fy', 'fy', 0, 331, '[[regtime]]', NULL, 1, NULL),
(332, 'Western Frisian (Netherlands)', 'NederlÃ¢n', 'fy', 'fy_NL', 0, 332, '[[regtime]]', NULL, 1, NULL),
(333, 'Irish', '', 'ga', 'ga', 0, 333, '[[regtime]]', NULL, 1, NULL),
(334, 'Irish (Ireland)', 'Ã‰ire', 'ga', 'ga_IE', 0, 334, '[[regtime]]', NULL, 1, NULL),
(335, 'Scottish Gaelic', '', 'gd', 'gd', 0, 335, '[[regtime]]', NULL, 1, NULL),
(336, 'Scottish Gaelic (United Kingdom)', 'An RÃ¬oghachd Aonaichte', 'gd', 'gd_GB', 0, 336, '[[regtime]]', NULL, 1, NULL),
(337, 'Galician', '', 'gl', 'gl', 0, 337, '[[regtime]]', NULL, 1, NULL),
(338, 'Galician (Spain)', 'EspaÃ±a', 'gl', 'gl_ES', 0, 338, '[[regtime]]', NULL, 1, NULL),
(339, 'Swiss German', '', 'gsw', 'gsw', 0, 339, '[[regtime]]', NULL, 1, NULL),
(340, 'Swiss German (Switzerland)', 'Schwiiz', 'gsw', 'gsw_CH', 0, 340, '[[regtime]]', NULL, 1, NULL),
(341, 'Swiss German (France)', 'Frankriich', 'gsw', 'gsw_FR', 0, 341, '[[regtime]]', NULL, 1, NULL),
(342, 'Swiss German (Liechtenstein)', 'LiÃ¤chteschtÃ¤i', 'gsw', 'gsw_LI', 0, 342, '[[regtime]]', NULL, 1, NULL),
(343, 'Gujarati', '', 'gu', 'gu', 0, 343, '[[regtime]]', NULL, 1, NULL),
(344, 'Gujarati (India)', 'àªàª¾àª°àª¤', 'gu', 'gu_IN', 0, 344, '[[regtime]]', NULL, 1, NULL),
(345, 'Gusii', '', 'guz', 'guz', 0, 345, '[[regtime]]', NULL, 1, NULL),
(346, 'Gusii (Kenya)', 'Kenya', 'guz', 'guz_KE', 0, 346, '[[regtime]]', NULL, 1, NULL),
(347, 'Manx', '', 'gv', 'gv', 0, 347, '[[regtime]]', NULL, 1, NULL),
(348, 'Manx (Isle of Man)', 'Ellan Vannin', 'gv', 'gv_IM', 0, 348, '[[regtime]]', NULL, 1, NULL),
(349, 'Hausa', '', 'ha', 'ha', 0, 349, '[[regtime]]', NULL, 1, NULL),
(350, 'Hausa (Ghana)', 'Gana', 'ha', 'ha_GH', 0, 350, '[[regtime]]', NULL, 1, NULL),
(351, 'Hausa (Niger)', 'Nijar', 'ha', 'ha_NE', 0, 351, '[[regtime]]', NULL, 1, NULL),
(352, 'Hausa (Nigeria)', 'Najeriya', 'ha', 'ha_NG', 0, 352, '[[regtime]]', NULL, 1, NULL),
(353, 'Hawaiian', '', 'haw', 'haw', 0, 353, '[[regtime]]', NULL, 1, NULL),
(354, 'Hawaiian (United States)', 'Ê»Amelika Hui PÅ« Ê»Ia', 'haw', 'haw_US', 0, 354, '[[regtime]]', NULL, 1, NULL),
(355, 'Hebrew', '', 'he', 'he', 0, 355, '[[regtime]]', NULL, 1, NULL),
(356, 'Hebrew (Israel)', '×™×©×¨××œ', 'he', 'he_IL', 0, 356, '[[regtime]]', NULL, 1, NULL),
(357, 'Hindi', '', 'hi', 'hi', 0, 357, '[[regtime]]', NULL, 1, NULL),
(358, 'Hindi (India)', 'à¤à¤¾à¤°à¤¤', 'hi', 'hi_IN', 0, 358, '[[regtime]]', NULL, 1, NULL),
(359, 'Croatian', '', 'hr', 'hr', 0, 359, '[[regtime]]', NULL, 1, NULL),
(360, 'Croatian (Bosnia & Herzegovina)', 'Bosna i Hercegovina', 'hr', 'hr_BA', 0, 360, '[[regtime]]', NULL, 1, NULL),
(361, 'Croatian (Croatia)', 'Hrvatska', 'hr', 'hr_HR', 0, 361, '[[regtime]]', NULL, 1, NULL),
(362, 'Upper Sorbian', '', 'hsb', 'hsb', 0, 362, '[[regtime]]', NULL, 1, NULL),
(363, 'Upper Sorbian (Germany)', 'NÄ›mska', 'hsb', 'hsb_DE', 0, 363, '[[regtime]]', NULL, 1, NULL),
(364, 'Hungarian', '', 'hu', 'hu', 1, 364, '[[regtime]]', NULL, 1, NULL),
(365, 'Hungarian (Hungary)', 'MagyarorszÃ¡g', 'hu', 'hu_HU', 0, 365, '[[regtime]]', NULL, 1, NULL),
(366, 'Armenian', '', 'hy', 'hy', 0, 366, '[[regtime]]', NULL, 1, NULL),
(367, 'Armenian (Armenia)', 'Õ€Õ¡ÕµÕ¡Õ½Õ¿Õ¡Õ¶', 'hy', 'hy_AM', 0, 367, '[[regtime]]', NULL, 1, NULL),
(368, 'Indonesian', '', 'id', 'id', 1, 368, '[[regtime]]', NULL, 1, NULL),
(369, 'Indonesian (Indonesia)', 'Indonesia', 'id', 'id_ID', 0, 369, '[[regtime]]', NULL, 1, NULL),
(370, 'Igbo', '', 'ig', 'ig', 0, 370, '[[regtime]]', NULL, 1, NULL),
(371, 'Igbo (Nigeria)', 'Nigeria', 'ig', 'ig_NG', 0, 371, '[[regtime]]', NULL, 1, NULL),
(372, 'Sichuan Yi', '', 'ii', 'ii', 0, 372, '[[regtime]]', NULL, 1, NULL),
(373, 'Sichuan Yi (China)', 'êê‡©', 'ii', 'ii_CN', 0, 373, '[[regtime]]', NULL, 1, NULL),
(374, 'Icelandic', '', 'is', 'is', 0, 374, '[[regtime]]', NULL, 1, NULL),
(375, 'Icelandic (Iceland)', 'Ãsland', 'is', 'is_IS', 0, 375, '[[regtime]]', NULL, 1, NULL),
(376, 'Italian', '', 'it', 'it', 1, 376, '[[regtime]]', NULL, 1, NULL),
(377, 'Italian (Switzerland)', 'Svizzera', 'it', 'it_CH', 0, 377, '[[regtime]]', NULL, 1, NULL),
(378, 'Italian (Italy)', 'Italia', 'it', 'it_IT', 0, 378, '[[regtime]]', NULL, 1, NULL),
(379, 'Italian (San Marino)', 'San Marino', 'it', 'it_SM', 0, 379, '[[regtime]]', NULL, 1, NULL),
(380, 'Japanese', '', 'ja', 'ja', 1, 380, '[[regtime]]', NULL, 1, NULL),
(381, 'Japanese (Japan)', 'æ—¥æœ¬', 'ja', 'ja_JP', 0, 381, '[[regtime]]', NULL, 1, NULL),
(382, 'Ngomba', '', 'jgo', 'jgo', 0, 382, '[[regtime]]', NULL, 1, NULL),
(383, 'Ngomba (Cameroon)', 'KamÉ›lÃ»n', 'jgo', 'jgo_CM', 0, 383, '[[regtime]]', NULL, 1, NULL),
(384, 'Machame', '', 'jmc', 'jmc', 0, 384, '[[regtime]]', NULL, 1, NULL),
(385, 'Machame (Tanzania)', 'Tanzania', 'jmc', 'jmc_TZ', 0, 385, '[[regtime]]', NULL, 1, NULL),
(386, 'Georgian', '', 'ka', 'ka', 0, 386, '[[regtime]]', NULL, 1, NULL),
(387, 'Georgian (Georgia)', 'áƒ¡áƒáƒ¥áƒáƒ áƒ—áƒ•áƒ”áƒšáƒ', 'ka', 'ka_GE', 0, 387, '[[regtime]]', NULL, 1, NULL),
(388, 'Kabyle', '', 'kab', 'kab', 0, 388, '[[regtime]]', NULL, 1, NULL),
(389, 'Kabyle (Algeria)', 'Lezzayer', 'kab', 'kab_DZ', 0, 389, '[[regtime]]', NULL, 1, NULL),
(390, 'Kamba', '', 'kam', 'kam', 0, 390, '[[regtime]]', NULL, 1, NULL),
(391, 'Kamba (Kenya)', 'Kenya', 'kam', 'kam_KE', 0, 391, '[[regtime]]', NULL, 1, NULL),
(392, 'Makonde', '', 'kde', 'kde', 0, 392, '[[regtime]]', NULL, 1, NULL),
(393, 'Makonde (Tanzania)', 'Tanzania', 'kde', 'kde_TZ', 0, 393, '[[regtime]]', NULL, 1, NULL),
(394, 'Kabuverdianu', '', 'kea', 'kea', 0, 394, '[[regtime]]', NULL, 1, NULL),
(395, 'Kabuverdianu (Cape Verde)', 'Kabu Verdi', 'kea', 'kea_CV', 0, 395, '[[regtime]]', NULL, 1, NULL),
(396, 'Koyra Chiini', '', 'khq', 'khq', 0, 396, '[[regtime]]', NULL, 1, NULL),
(397, 'Koyra Chiini (Mali)', 'Maali', 'khq', 'khq_ML', 0, 397, '[[regtime]]', NULL, 1, NULL),
(398, 'Kikuyu', '', 'ki', 'ki', 0, 398, '[[regtime]]', NULL, 1, NULL),
(399, 'Kikuyu (Kenya)', 'Kenya', 'ki', 'ki_KE', 0, 399, '[[regtime]]', NULL, 1, NULL),
(400, 'Kazakh', '', 'kk', 'kk', 0, 400, '[[regtime]]', NULL, 1, NULL),
(401, 'Kazakh (Kazakhstan)', 'ÒšÐ°Ð·Ð°Ò›ÑÑ‚Ð°Ð½', 'kk', 'kk_KZ', 0, 401, '[[regtime]]', NULL, 1, NULL),
(402, 'Kako', '', 'kkj', 'kkj', 0, 402, '[[regtime]]', NULL, 1, NULL),
(403, 'Kako (Cameroon)', 'KamÉ›run', 'kkj', 'kkj_CM', 0, 403, '[[regtime]]', NULL, 1, NULL),
(404, 'Kalaallisut', '', 'kl', 'kl', 0, 404, '[[regtime]]', NULL, 1, NULL),
(405, 'Kalaallisut (Greenland)', 'Kalaallit Nunaat', 'kl', 'kl_GL', 0, 405, '[[regtime]]', NULL, 1, NULL),
(406, 'Kalenjin', '', 'kln', 'kln', 0, 406, '[[regtime]]', NULL, 1, NULL),
(407, 'Kalenjin (Kenya)', 'Emetab Kenya', 'kln', 'kln_KE', 0, 407, '[[regtime]]', NULL, 1, NULL),
(408, 'Khmer', '', 'km', 'km', 0, 408, '[[regtime]]', NULL, 1, NULL),
(409, 'Khmer (Cambodia)', 'áž€áž˜áŸ’áž–áž»áž‡áž¶', 'km', 'km_KH', 0, 409, '[[regtime]]', NULL, 1, NULL),
(410, 'Kannada', '', 'kn', 'kn', 0, 410, '[[regtime]]', NULL, 1, NULL),
(411, 'Kannada (India)', 'à²à²¾à²°à²¤', 'kn', 'kn_IN', 0, 411, '[[regtime]]', NULL, 1, NULL),
(412, 'Korean', '', 'ko', 'ko', 0, 412, '[[regtime]]', NULL, 1, NULL),
(413, 'Korean (North Korea)', 'ì¡°ì„ ë¯¼ì£¼ì£¼ì˜ì¸ë¯¼ê³µí™”êµ', 'ko', 'ko_KP', 0, 413, '[[regtime]]', NULL, 1, NULL),
(414, 'Korean (South Korea)', 'ëŒ€í•œë¯¼êµ', 'ko', 'ko_KR', 0, 414, '[[regtime]]', NULL, 1, NULL),
(415, 'Konkani', '', 'kok', 'kok', 0, 415, '[[regtime]]', NULL, 1, NULL),
(416, 'Konkani (India)', 'à¤à¤¾à¤°à¤¤', 'kok', 'kok_IN', 0, 416, '[[regtime]]', NULL, 1, NULL),
(417, 'Kashmiri', '', 'ks', 'ks', 0, 417, '[[regtime]]', NULL, 1, NULL),
(418, 'Kashmiri (India)', 'ÛÙÙ†Ù›Ø¯ÙˆØ³ØªØ§Ù†', 'ks', 'ks_IN', 0, 418, '[[regtime]]', NULL, 1, NULL),
(419, 'Shambala', '', 'ksb', 'ksb', 0, 419, '[[regtime]]', NULL, 1, NULL),
(420, 'Shambala (Tanzania)', 'Tanzania', 'ksb', 'ksb_TZ', 0, 420, '[[regtime]]', NULL, 1, NULL),
(421, 'Bafia', '', 'ksf', 'ksf', 0, 421, '[[regtime]]', NULL, 1, NULL),
(422, 'Bafia (Cameroon)', 'kamÉ›rÃºn', 'ksf', 'ksf_CM', 0, 422, '[[regtime]]', NULL, 1, NULL),
(423, 'Colognian', '', 'ksh', 'ksh', 0, 423, '[[regtime]]', NULL, 1, NULL),
(424, 'Colognian (Germany)', 'DoÃ¼tschland', 'ksh', 'ksh_DE', 0, 424, '[[regtime]]', NULL, 1, NULL),
(425, 'Cornish', '', 'kw', 'kw', 0, 425, '[[regtime]]', NULL, 1, NULL),
(426, 'Cornish (United Kingdom)', 'Rywvaneth Unys', 'kw', 'kw_GB', 0, 426, '[[regtime]]', NULL, 1, NULL),
(427, 'Kyrgyz', '', 'ky', 'ky', 0, 427, '[[regtime]]', NULL, 1, NULL),
(428, 'Kyrgyz (Kyrgyzstan)', 'ÐšÑ‹Ñ€Ð³Ñ‹Ð·ÑÑ‚Ð°Ð½', 'ky', 'ky_KG', 0, 428, '[[regtime]]', NULL, 1, NULL),
(429, 'Langi', '', 'lag', 'lag', 0, 429, '[[regtime]]', NULL, 1, NULL),
(430, 'Langi (Tanzania)', 'TaansanÃa', 'lag', 'lag_TZ', 0, 430, '[[regtime]]', NULL, 1, NULL),
(431, 'Luxembourgish', '', 'lb', 'lb', 0, 431, '[[regtime]]', NULL, 1, NULL),
(432, 'Luxembourgish (Luxembourg)', 'LÃ«tzebuerg', 'lb', 'lb_LU', 0, 432, '[[regtime]]', NULL, 1, NULL),
(433, 'Ganda', '', 'lg', 'lg', 0, 433, '[[regtime]]', NULL, 1, NULL),
(434, 'Ganda (Uganda)', 'Yuganda', 'lg', 'lg_UG', 0, 434, '[[regtime]]', NULL, 1, NULL),
(435, 'Lakota', '', 'lkt', 'lkt', 0, 435, '[[regtime]]', NULL, 1, NULL),
(436, 'Lakota (United States)', 'MÃlahaÅ‹ska TÈŸamÃ¡kÈŸoÄhe', 'lkt', 'lkt_US', 0, 436, '[[regtime]]', NULL, 1, NULL),
(437, 'Lingala', '', 'ln', 'ln', 0, 437, '[[regtime]]', NULL, 1, NULL),
(438, 'Lingala (Angola)', 'AngÃ³la', 'ln', 'ln_AO', 0, 438, '[[regtime]]', NULL, 1, NULL),
(439, 'Lingala (Congo - Kinshasa)', 'RepublÃki ya KongÃ³ DemokratÃki', 'ln', 'ln_CD', 0, 439, '[[regtime]]', NULL, 1, NULL),
(440, 'Lingala (Central African Republic)', 'Repibiki ya AfrÃka ya KÃ¡ti', 'ln', 'ln_CF', 0, 440, '[[regtime]]', NULL, 1, NULL),
(441, 'Lingala (Congo - Brazzaville)', 'Kongo', 'ln', 'ln_CG', 0, 441, '[[regtime]]', NULL, 1, NULL),
(442, 'Lao', '', 'lo', 'lo', 0, 442, '[[regtime]]', NULL, 1, NULL),
(443, 'Lao (Laos)', 'àº¥àº²àº§', 'lo', 'lo_LA', 0, 443, '[[regtime]]', NULL, 1, NULL),
(444, 'Northern Luri', '', 'lrc', 'lrc', 0, 444, '[[regtime]]', NULL, 1, NULL),
(445, 'Northern Luri (Iraq)', 'IQ', 'lrc', 'lrc_IQ', 0, 445, '[[regtime]]', NULL, 1, NULL),
(446, 'Northern Luri (Iran)', 'IR', 'lrc', 'lrc_IR', 0, 446, '[[regtime]]', NULL, 1, NULL),
(447, 'Lithuanian', '', 'lt', 'lt', 0, 447, '[[regtime]]', NULL, 1, NULL),
(448, 'Lithuanian (Lithuania)', 'Lietuva', 'lt', 'lt_LT', 0, 448, '[[regtime]]', NULL, 1, NULL),
(449, 'Luba-Katanga', '', 'lu', 'lu', 0, 449, '[[regtime]]', NULL, 1, NULL),
(450, 'Luba-Katanga (Congo - Kinshasa)', 'Ditunga wa Kongu', 'lu', 'lu_CD', 0, 450, '[[regtime]]', NULL, 1, NULL),
(451, 'Luo', '', 'luo', 'luo', 0, 451, '[[regtime]]', NULL, 1, NULL),
(452, 'Luo (Kenya)', 'Kenya', 'luo', 'luo_KE', 0, 452, '[[regtime]]', NULL, 1, NULL),
(453, 'Luyia', '', 'luy', 'luy', 0, 453, '[[regtime]]', NULL, 1, NULL),
(454, 'Luyia (Kenya)', 'Kenya', 'luy', 'luy_KE', 0, 454, '[[regtime]]', NULL, 1, NULL),
(455, 'Latvian', '', 'lv', 'lv', 0, 455, '[[regtime]]', NULL, 1, NULL),
(456, 'Latvian (Latvia)', 'Latvija', 'lv', 'lv_LV', 0, 456, '[[regtime]]', NULL, 1, NULL),
(457, 'Masai', '', 'mas', 'mas', 0, 457, '[[regtime]]', NULL, 1, NULL),
(458, 'Masai (Kenya)', 'Kenya', 'mas', 'mas_KE', 0, 458, '[[regtime]]', NULL, 1, NULL),
(459, 'Masai (Tanzania)', 'Tansania', 'mas', 'mas_TZ', 0, 459, '[[regtime]]', NULL, 1, NULL),
(460, 'Meru', '', 'mer', 'mer', 0, 460, '[[regtime]]', NULL, 1, NULL),
(461, 'Meru (Kenya)', 'Kenya', 'mer', 'mer_KE', 0, 461, '[[regtime]]', NULL, 1, NULL),
(462, 'Morisyen', '', 'mfe', 'mfe', 0, 462, '[[regtime]]', NULL, 1, NULL),
(463, 'Morisyen (Mauritius)', 'Moris', 'mfe', 'mfe_MU', 0, 463, '[[regtime]]', NULL, 1, NULL),
(464, 'Malagasy', '', 'mg', 'mg', 0, 464, '[[regtime]]', NULL, 1, NULL),
(465, 'Malagasy (Madagascar)', 'Madagasikara', 'mg', 'mg_MG', 0, 465, '[[regtime]]', NULL, 1, NULL),
(466, 'Makhuwa-Meetto', '', 'mgh', 'mgh', 0, 466, '[[regtime]]', NULL, 1, NULL),
(467, 'Makhuwa-Meetto (Mozambique)', 'Umozambiki', 'mgh', 'mgh_MZ', 0, 467, '[[regtime]]', NULL, 1, NULL),
(468, 'MetaÊ¼', '', 'mgo', 'mgo', 0, 468, '[[regtime]]', NULL, 1, NULL),
(469, 'MetaÊ¼ (Cameroon)', 'Kamalun', 'mgo', 'mgo_CM', 0, 469, '[[regtime]]', NULL, 1, NULL),
(470, 'Macedonian', '', 'mk', 'mk', 0, 470, '[[regtime]]', NULL, 1, NULL),
(471, 'Macedonian (Macedonia)', 'ÐœÐ°ÐºÐµÐ´Ð¾Ð½Ð¸Ñ˜Ð°', 'mk', 'mk_MK', 0, 471, '[[regtime]]', NULL, 1, NULL),
(472, 'Malayalam', '', 'ml', 'ml', 0, 472, '[[regtime]]', NULL, 1, NULL),
(473, 'Malayalam (India)', 'à´‡à´¨àµà´¤àµà´¯', 'ml', 'ml_IN', 0, 473, '[[regtime]]', NULL, 1, NULL),
(474, 'Mongolian', '', 'mn', 'mn', 0, 474, '[[regtime]]', NULL, 1, NULL),
(475, 'Mongolian (Mongolia)', 'ÐœÐ¾Ð½Ð³Ð¾Ð»', 'mn', 'mn_MN', 0, 475, '[[regtime]]', NULL, 1, NULL),
(476, 'Marathi', '', 'mr', 'mr', 0, 476, '[[regtime]]', NULL, 1, NULL),
(477, 'Marathi (India)', 'à¤à¤¾à¤°à¤¤', 'mr', 'mr_IN', 0, 477, '[[regtime]]', NULL, 1, NULL),
(478, 'Malay', '', 'ms', 'ms', 0, 478, '[[regtime]]', NULL, 1, NULL),
(479, 'Malay (Brunei)', 'Brunei', 'ms', 'ms_BN', 0, 479, '[[regtime]]', NULL, 1, NULL),
(480, 'Malay (Malaysia)', 'Malaysia', 'ms', 'ms_MY', 0, 480, '[[regtime]]', NULL, 1, NULL),
(481, 'Malay (Singapore)', 'Singapura', 'ms', 'ms_SG', 0, 481, '[[regtime]]', NULL, 1, NULL),
(482, 'Maltese', '', 'mt', 'mt', 0, 482, '[[regtime]]', NULL, 1, NULL),
(483, 'Maltese (Malta)', 'Malta', 'mt', 'mt_MT', 0, 483, '[[regtime]]', NULL, 1, NULL),
(484, 'Mundang', '', 'mua', 'mua', 0, 484, '[[regtime]]', NULL, 1, NULL),
(485, 'Mundang (Cameroon)', 'kameruÅ‹', 'mua', 'mua_CM', 0, 485, '[[regtime]]', NULL, 1, NULL),
(486, 'Burmese', '', 'my', 'my', 0, 486, '[[regtime]]', NULL, 1, NULL),
(487, 'Burmese (Myanmar [Burma])', 'á€™á€¼á€”á€ºá€™á€¬', 'my', 'my_MM', 0, 487, '[[regtime]]', NULL, 1, NULL),
(488, 'Mazanderani', '', 'mzn', 'mzn', 0, 488, '[[regtime]]', NULL, 1, NULL),
(489, 'Mazanderani (Iran)', 'Ø§ÛŒØ±Ø§Ù†', 'mzn', 'mzn_IR', 0, 489, '[[regtime]]', NULL, 1, NULL),
(490, 'Nama', '', 'naq', 'naq', 0, 490, '[[regtime]]', NULL, 1, NULL),
(491, 'Nama (Namibia)', 'Namibiab', 'naq', 'naq_NA', 0, 491, '[[regtime]]', NULL, 1, NULL),
(492, 'Norwegian BokmÃ¥l', '', 'nb', 'nb', 0, 492, '[[regtime]]', NULL, 1, NULL),
(493, 'Norwegian BokmÃ¥l (Norway)', 'Norge', 'nb', 'nb_NO', 0, 493, '[[regtime]]', NULL, 1, NULL),
(494, 'Norwegian BokmÃ¥l (Svalbard & Jan Mayen)', 'Svalbard og Jan Mayen', 'nb', 'nb_SJ', 0, 494, '[[regtime]]', NULL, 1, NULL),
(495, 'North Ndebele', '', 'nd', 'nd', 0, 495, '[[regtime]]', NULL, 1, NULL),
(496, 'North Ndebele (Zimbabwe)', 'Zimbabwe', 'nd', 'nd_ZW', 0, 496, '[[regtime]]', NULL, 1, NULL),
(497, 'Low German', '', 'nds', 'nds', 0, 497, '[[regtime]]', NULL, 1, NULL),
(498, 'Low German (Germany)', 'DE', 'nds', 'nds_DE', 0, 498, '[[regtime]]', NULL, 1, NULL);
INSERT INTO `languages` VALUES
(499, 'Low German (Netherlands)', 'NL', 'nds', 'nds_NL', 0, 499, '[[regtime]]', NULL, 1, NULL),
(500, 'Nepali', '', 'ne', 'ne', 0, 500, '[[regtime]]', NULL, 1, NULL),
(501, 'Nepali (India)', 'à¤à¤¾à¤°à¤¤', 'ne', 'ne_IN', 0, 501, '[[regtime]]', NULL, 1, NULL),
(502, 'Nepali (Nepal)', 'à¤¨à¥‡à¤ªà¤¾à¤²', 'ne', 'ne_NP', 0, 502, '[[regtime]]', NULL, 1, NULL),
(503, 'Dutch', '', 'nl', 'nl', 1, 503, '[[regtime]]', NULL, 1, NULL),
(504, 'Dutch (Aruba)', 'Aruba', 'nl', 'nl_AW', 0, 504, '[[regtime]]', NULL, 1, NULL),
(505, 'Dutch (Belgium)', 'BelgiÃ«', 'nl', 'nl_BE', 0, 505, '[[regtime]]', NULL, 1, NULL),
(506, 'Dutch (Caribbean Netherlands)', 'Caribisch Nederland', 'nl', 'nl_BQ', 0, 506, '[[regtime]]', NULL, 1, NULL),
(507, 'Dutch (CuraÃ§ao)', 'CuraÃ§ao', 'nl', 'nl_CW', 0, 507, '[[regtime]]', NULL, 1, NULL),
(508, 'Dutch (Netherlands)', 'Nederland', 'nl', 'nl_NL', 0, 508, '[[regtime]]', NULL, 1, NULL),
(509, 'Dutch (Suriname)', 'Suriname', 'nl', 'nl_SR', 0, 509, '[[regtime]]', NULL, 1, NULL),
(510, 'Dutch (Sint Maarten)', 'Sint-Maarten', 'nl', 'nl_SX', 0, 510, '[[regtime]]', NULL, 1, NULL),
(511, 'Kwasio', '', 'nmg', 'nmg', 0, 511, '[[regtime]]', NULL, 1, NULL),
(512, 'Kwasio (Cameroon)', 'Kamerun', 'nmg', 'nmg_CM', 0, 512, '[[regtime]]', NULL, 1, NULL),
(513, 'Norwegian Nynorsk', '', 'nn', 'nn', 0, 513, '[[regtime]]', NULL, 1, NULL),
(514, 'Norwegian Nynorsk (Norway)', 'Noreg', 'nn', 'nn_NO', 0, 514, '[[regtime]]', NULL, 1, NULL),
(515, 'Ngiemboon', '', 'nnh', 'nnh', 0, 515, '[[regtime]]', NULL, 1, NULL),
(516, 'Ngiemboon (Cameroon)', 'KÃ malÃ»m', 'nnh', 'nnh_CM', 0, 516, '[[regtime]]', NULL, 1, NULL),
(517, 'Nuer', '', 'nus', 'nus', 0, 517, '[[regtime]]', NULL, 1, NULL),
(518, 'Nuer (South Sudan)', 'SS', 'nus', 'nus_SS', 0, 518, '[[regtime]]', NULL, 1, NULL),
(519, 'Nyankole', '', 'nyn', 'nyn', 0, 519, '[[regtime]]', NULL, 1, NULL),
(520, 'Nyankole (Uganda)', 'Uganda', 'nyn', 'nyn_UG', 0, 520, '[[regtime]]', NULL, 1, NULL),
(521, 'Oromo', '', 'om', 'om', 0, 521, '[[regtime]]', NULL, 1, NULL),
(522, 'Oromo (Ethiopia)', 'Itoophiyaa', 'om', 'om_ET', 0, 522, '[[regtime]]', NULL, 1, NULL),
(523, 'Oromo (Kenya)', 'Keeniyaa', 'om', 'om_KE', 0, 523, '[[regtime]]', NULL, 1, NULL),
(524, 'Odia', '', 'or', 'or', 0, 524, '[[regtime]]', NULL, 1, NULL),
(525, 'Odia (India)', 'à¬à¬¾à¬°à¬¤', 'or', 'or_IN', 0, 525, '[[regtime]]', NULL, 1, NULL),
(526, 'Ossetic', '', 'os', 'os', 0, 526, '[[regtime]]', NULL, 1, NULL),
(527, 'Ossetic (Georgia)', 'Ð“ÑƒÑ‹Ñ€Ð´Ð·Ñ‹ÑÑ‚Ð¾Ð½', 'os', 'os_GE', 0, 527, '[[regtime]]', NULL, 1, NULL),
(528, 'Ossetic (Russia)', 'Ð£Ó•Ñ€Ó•ÑÐµ', 'os', 'os_RU', 0, 528, '[[regtime]]', NULL, 1, NULL),
(529, 'Punjabi', '', 'pa', 'pa', 0, 529, '[[regtime]]', NULL, 1, NULL),
(530, 'Punjabi (Arabic)', '', 'pa', 'pa_Arab', 0, 530, '[[regtime]]', NULL, 1, NULL),
(531, 'Punjabi (Arabic, Pakistan)', 'Ù¾Ø§Ú©Ø³ØªØ§Ù†', 'pa', 'pa_Arab_PK', 0, 531, '[[regtime]]', NULL, 1, NULL),
(532, 'Punjabi (Gurmukhi)', '', 'pa', 'pa_Guru', 0, 532, '[[regtime]]', NULL, 1, NULL),
(533, 'Punjabi (Gurmukhi, India)', 'à¨à¨¾à¨°à¨¤', 'pa', 'pa_Guru_IN', 0, 533, '[[regtime]]', NULL, 1, NULL),
(534, 'Polish', '', 'pl', 'pl', 1, 534, '[[regtime]]', NULL, 1, NULL),
(535, 'Polish (Poland)', 'Polska', 'pl', 'pl_PL', 0, 535, '[[regtime]]', NULL, 1, NULL),
(536, 'Pashto', '', 'ps', 'ps', 0, 536, '[[regtime]]', NULL, 1, NULL),
(537, 'Pashto (Afghanistan)', 'Ø§ÙØºØ§Ù†Ø³ØªØ§Ù†', 'ps', 'ps_AF', 0, 537, '[[regtime]]', NULL, 1, NULL),
(538, 'Portuguese', '', 'pt', 'pt', 1, 538, '[[regtime]]', NULL, 1, NULL),
(539, 'Portuguese (Angola)', 'Angola', 'pt', 'pt_AO', 0, 539, '[[regtime]]', NULL, 1, NULL),
(540, 'Portuguese (Brazil)', 'Brasil', 'pt', 'pt_BR', 0, 540, '[[regtime]]', NULL, 1, NULL),
(541, 'Portuguese (Switzerland)', 'SuÃÃ§a', 'pt', 'pt_CH', 0, 541, '[[regtime]]', NULL, 1, NULL),
(542, 'Portuguese (Cape Verde)', 'Cabo Verde', 'pt', 'pt_CV', 0, 542, '[[regtime]]', NULL, 1, NULL),
(543, 'Portuguese (Equatorial Guinea)', 'GuinÃ© Equatorial', 'pt', 'pt_GQ', 0, 543, '[[regtime]]', NULL, 1, NULL),
(544, 'Portuguese (Guinea-Bissau)', 'GuinÃ©-Bissau', 'pt', 'pt_GW', 0, 544, '[[regtime]]', NULL, 1, NULL),
(545, 'Portuguese (Luxembourg)', 'Luxemburgo', 'pt', 'pt_LU', 0, 545, '[[regtime]]', NULL, 1, NULL),
(546, 'Portuguese (Macau SAR China)', 'Macau, RAE da China', 'pt', 'pt_MO', 0, 546, '[[regtime]]', NULL, 1, NULL),
(547, 'Portuguese (Mozambique)', 'MoÃ§ambique', 'pt', 'pt_MZ', 0, 547, '[[regtime]]', NULL, 1, NULL),
(548, 'Portuguese (Portugal)', 'Portugal', 'pt', 'pt_PT', 0, 548, '[[regtime]]', NULL, 1, NULL),
(549, 'Portuguese (SÃ£o TomÃ© & PrÃncipe)', 'SÃ£o TomÃ© e PrÃncipe', 'pt', 'pt_ST', 0, 549, '[[regtime]]', NULL, 1, NULL),
(550, 'Portuguese (Timor-Leste)', 'Timor-Leste', 'pt', 'pt_TL', 0, 550, '[[regtime]]', NULL, 1, NULL),
(551, 'Quechua', '', 'qu', 'qu', 0, 551, '[[regtime]]', NULL, 1, NULL),
(552, 'Quechua (Bolivia)', 'Bolivia', 'qu', 'qu_BO', 0, 552, '[[regtime]]', NULL, 1, NULL),
(553, 'Quechua (Ecuador)', 'Ecuador', 'qu', 'qu_EC', 0, 553, '[[regtime]]', NULL, 1, NULL),
(554, 'Quechua (Peru)', 'PerÃº', 'qu', 'qu_PE', 0, 554, '[[regtime]]', NULL, 1, NULL),
(555, 'Romansh', '', 'rm', 'rm', 0, 555, '[[regtime]]', NULL, 1, NULL),
(556, 'Romansh (Switzerland)', 'Svizra', 'rm', 'rm_CH', 0, 556, '[[regtime]]', NULL, 1, NULL),
(557, 'Rundi', '', 'rn', 'rn', 0, 557, '[[regtime]]', NULL, 1, NULL),
(558, 'Rundi (Burundi)', 'Uburundi', 'rn', 'rn_BI', 0, 558, '[[regtime]]', NULL, 1, NULL),
(559, 'Romanian', '', 'ro', 'ro', 0, 559, '[[regtime]]', NULL, 1, NULL),
(560, 'Romanian (Moldova)', 'Republica Moldova', 'ro', 'ro_MD', 0, 560, '[[regtime]]', NULL, 1, NULL),
(561, 'Romanian (Romania)', 'RomÃ¢nia', 'ro', 'ro_RO', 0, 561, '[[regtime]]', NULL, 1, NULL),
(562, 'Rombo', '', 'rof', 'rof', 0, 562, '[[regtime]]', NULL, 1, NULL),
(563, 'Rombo (Tanzania)', 'Tanzania', 'rof', 'rof_TZ', 0, 563, '[[regtime]]', NULL, 1, NULL),
(564, 'Russian', '', 'ru', 'ru', 1, 564, '[[regtime]]', NULL, 1, NULL),
(565, 'Russian (Belarus)', 'Ð‘ÐµÐ»Ð°Ñ€ÑƒÑÑŒ', 'ru', 'ru_BY', 0, 565, '[[regtime]]', NULL, 1, NULL),
(566, 'Russian (Kyrgyzstan)', 'ÐšÐ¸Ñ€Ð³Ð¸Ð·Ð¸Ñ', 'ru', 'ru_KG', 0, 566, '[[regtime]]', NULL, 1, NULL),
(567, 'Russian (Kazakhstan)', 'ÐšÐ°Ð·Ð°Ñ…ÑÑ‚Ð°Ð½', 'ru', 'ru_KZ', 0, 567, '[[regtime]]', NULL, 1, NULL),
(568, 'Russian (Moldova)', 'ÐœÐ¾Ð»Ð´Ð¾Ð²Ð°', 'ru', 'ru_MD', 0, 568, '[[regtime]]', NULL, 1, NULL),
(569, 'Russian (Russia)', 'Ð Ð¾ÑÑÐ¸Ñ', 'ru', 'ru_RU', 0, 569, '[[regtime]]', NULL, 1, NULL),
(570, 'Russian (Ukraine)', 'Ð£ÐºÑ€Ð°Ð¸Ð½Ð°', 'ru', 'ru_UA', 0, 570, '[[regtime]]', NULL, 1, NULL),
(571, 'Kinyarwanda', '', 'rw', 'rw', 0, 571, '[[regtime]]', NULL, 1, NULL),
(572, 'Kinyarwanda (Rwanda)', 'Rwanda', 'rw', 'rw_RW', 0, 572, '[[regtime]]', NULL, 1, NULL),
(573, 'Rwa', '', 'rwk', 'rwk', 0, 573, '[[regtime]]', NULL, 1, NULL),
(574, 'Rwa (Tanzania)', 'Tanzania', 'rwk', 'rwk_TZ', 0, 574, '[[regtime]]', NULL, 1, NULL),
(575, 'Sakha', '', 'sah', 'sah', 0, 575, '[[regtime]]', NULL, 1, NULL),
(576, 'Sakha (Russia)', 'ÐÑ€Ð°ÑÑÑ‹Ñ‹Ð¹Ð°', 'sah', 'sah_RU', 0, 576, '[[regtime]]', NULL, 1, NULL),
(577, 'Samburu', '', 'saq', 'saq', 0, 577, '[[regtime]]', NULL, 1, NULL),
(578, 'Samburu (Kenya)', 'Kenya', 'saq', 'saq_KE', 0, 578, '[[regtime]]', NULL, 1, NULL),
(579, 'Sangu', '', 'sbp', 'sbp', 0, 579, '[[regtime]]', NULL, 1, NULL),
(580, 'Sangu (Tanzania)', 'Tansaniya', 'sbp', 'sbp_TZ', 0, 580, '[[regtime]]', NULL, 1, NULL),
(581, 'Northern Sami', '', 'se', 'se', 0, 581, '[[regtime]]', NULL, 1, NULL),
(582, 'Northern Sami (Finland)', 'Suopma', 'se', 'se_FI', 0, 582, '[[regtime]]', NULL, 1, NULL),
(583, 'Northern Sami (Norway)', 'Norga', 'se', 'se_NO', 0, 583, '[[regtime]]', NULL, 1, NULL),
(584, 'Northern Sami (Sweden)', 'RuoÅ§Å§a', 'se', 'se_SE', 0, 584, '[[regtime]]', NULL, 1, NULL),
(585, 'Sena', '', 'seh', 'seh', 0, 585, '[[regtime]]', NULL, 1, NULL),
(586, 'Sena (Mozambique)', 'MoÃ§ambique', 'seh', 'seh_MZ', 0, 586, '[[regtime]]', NULL, 1, NULL),
(587, 'Koyraboro Senni', '', 'ses', 'ses', 0, 587, '[[regtime]]', NULL, 1, NULL),
(588, 'Koyraboro Senni (Mali)', 'Maali', 'ses', 'ses_ML', 0, 588, '[[regtime]]', NULL, 1, NULL),
(589, 'Sango', '', 'sg', 'sg', 0, 589, '[[regtime]]', NULL, 1, NULL),
(590, 'Sango (Central African Republic)', 'KÃ¶dÃ¶rÃ¶sÃªse tÃ® BÃªafrÃ®ka', 'sg', 'sg_CF', 0, 590, '[[regtime]]', NULL, 1, NULL),
(591, 'Tachelhit', '', 'shi', 'shi', 0, 591, '[[regtime]]', NULL, 1, NULL),
(592, 'Tachelhit (Latin)', '', 'shi', 'shi_Latn', 0, 592, '[[regtime]]', NULL, 1, NULL),
(593, 'Tachelhit (Latin, Morocco)', 'lmÉ£rib', 'shi', 'shi_Latn_MA', 0, 593, '[[regtime]]', NULL, 1, NULL),
(594, 'Tachelhit (Tifinagh)', '', 'shi', 'shi_Tfng', 0, 594, '[[regtime]]', NULL, 1, NULL),
(595, 'Tachelhit (Tifinagh, Morocco)', 'âµâµŽâµ–âµ”âµ‰â´±', 'shi', 'shi_Tfng_MA', 0, 595, '[[regtime]]', NULL, 1, NULL),
(596, 'Sinhala', '', 'si', 'si', 0, 596, '[[regtime]]', NULL, 1, NULL),
(597, 'Sinhala (Sri Lanka)', 'à·à·Šâ€à¶»à·“ à¶½à¶‚à¶šà·à·€', 'si', 'si_LK', 0, 597, '[[regtime]]', NULL, 1, NULL),
(598, 'Slovak', '', 'sk', 'sk', 1, 598, '[[regtime]]', NULL, 1, NULL),
(599, 'Slovak (Slovakia)', 'Slovensko', 'sk', 'sk_SK', 0, 599, '[[regtime]]', NULL, 1, NULL),
(600, 'Slovenian', '', 'sl', 'sl', 0, 600, '[[regtime]]', NULL, 1, NULL),
(601, 'Slovenian (Slovenia)', 'Slovenija', 'sl', 'sl_SI', 0, 601, '[[regtime]]', NULL, 1, NULL),
(602, 'Inari Sami', '', 'smn', 'smn', 0, 602, '[[regtime]]', NULL, 1, NULL),
(603, 'Inari Sami (Finland)', 'SuomÃ¢', 'smn', 'smn_FI', 0, 603, '[[regtime]]', NULL, 1, NULL),
(604, 'Shona', '', 'sn', 'sn', 0, 604, '[[regtime]]', NULL, 1, NULL),
(605, 'Shona (Zimbabwe)', 'Zimbabwe', 'sn', 'sn_ZW', 0, 605, '[[regtime]]', NULL, 1, NULL),
(606, 'Somali', '', 'so', 'so', 0, 606, '[[regtime]]', NULL, 1, NULL),
(607, 'Somali (Djibouti)', 'Jabuuti', 'so', 'so_DJ', 0, 607, '[[regtime]]', NULL, 1, NULL),
(608, 'Somali (Ethiopia)', 'Itoobiya', 'so', 'so_ET', 0, 608, '[[regtime]]', NULL, 1, NULL),
(609, 'Somali (Kenya)', 'Kiiniya', 'so', 'so_KE', 0, 609, '[[regtime]]', NULL, 1, NULL),
(610, 'Somali (Somalia)', 'Soomaaliya', 'so', 'so_SO', 0, 610, '[[regtime]]', NULL, 1, NULL),
(611, 'Albanian', '', 'sq', 'sq', 0, 611, '[[regtime]]', NULL, 1, NULL),
(612, 'Albanian (Albania)', 'ShqipÃ«ri', 'sq', 'sq_AL', 0, 612, '[[regtime]]', NULL, 1, NULL),
(613, 'Albanian (Macedonia)', 'Maqedoni', 'sq', 'sq_MK', 0, 613, '[[regtime]]', NULL, 1, NULL),
(614, 'Albanian (Kosovo)', 'KosovÃ«', 'sq', 'sq_XK', 0, 614, '[[regtime]]', NULL, 1, NULL),
(615, 'Serbian', '', 'sr', 'sr', 0, 615, '[[regtime]]', NULL, 1, NULL),
(616, 'Serbian (Cyrillic)', '', 'sr', 'sr_Cyrl', 0, 616, '[[regtime]]', NULL, 1, NULL),
(617, 'Serbian (Cyrillic, Bosnia & Herzegovina)', 'Ð‘Ð¾ÑÐ½Ð° Ð¸ Ð¥ÐµÑ€Ñ†ÐµÐ³Ð¾Ð²Ð¸Ð½Ð°', 'sr', 'sr_Cyrl_BA', 0, 617, '[[regtime]]', NULL, 1, NULL),
(618, 'Serbian (Cyrillic, Montenegro)', 'Ð¦Ñ€Ð½Ð° Ð“Ð¾Ñ€Ð°', 'sr', 'sr_Cyrl_ME', 0, 618, '[[regtime]]', NULL, 1, NULL),
(619, 'Serbian (Cyrillic, Serbia)', 'Ð¡Ñ€Ð±Ð¸Ñ˜Ð°', 'sr', 'sr_Cyrl_RS', 0, 619, '[[regtime]]', NULL, 1, NULL),
(620, 'Serbian (Cyrillic, Kosovo)', 'ÐšÐ¾ÑÐ¾Ð²Ð¾', 'sr', 'sr_Cyrl_XK', 0, 620, '[[regtime]]', NULL, 1, NULL),
(621, 'Serbian (Latin)', '', 'sr', 'sr_Latn', 0, 621, '[[regtime]]', NULL, 1, NULL),
(622, 'Serbian (Latin, Bosnia & Herzegovina)', 'Bosna i Hercegovina', 'sr', 'sr_Latn_BA', 0, 622, '[[regtime]]', NULL, 1, NULL),
(623, 'Serbian (Latin, Montenegro)', 'Crna Gora', 'sr', 'sr_Latn_ME', 0, 623, '[[regtime]]', NULL, 1, NULL),
(624, 'Serbian (Latin, Serbia)', 'Srbija', 'sr', 'sr_Latn_RS', 0, 624, '[[regtime]]', NULL, 1, NULL),
(625, 'Serbian (Latin, Kosovo)', 'Kosovo', 'sr', 'sr_Latn_XK', 0, 625, '[[regtime]]', NULL, 1, NULL),
(626, 'Swedish', '', 'sv', 'sv', 0, 626, '[[regtime]]', NULL, 1, NULL),
(627, 'Swedish (Ã…land Islands)', 'Ã…land', 'sv', 'sv_AX', 0, 627, '[[regtime]]', NULL, 1, NULL),
(628, 'Swedish (Finland)', 'Finland', 'sv', 'sv_FI', 0, 628, '[[regtime]]', NULL, 1, NULL),
(629, 'Swedish (Sweden)', 'Sverige', 'sv', 'sv_SE', 0, 629, '[[regtime]]', NULL, 1, NULL),
(630, 'Swahili', '', 'sw', 'sw', 0, 630, '[[regtime]]', NULL, 1, NULL),
(631, 'Swahili (Congo - Kinshasa)', 'Jamhuri ya Kidemokrasia ya Kongo', 'sw', 'sw_CD', 0, 631, '[[regtime]]', NULL, 1, NULL),
(632, 'Swahili (Kenya)', 'Kenya', 'sw', 'sw_KE', 0, 632, '[[regtime]]', NULL, 1, NULL),
(633, 'Swahili (Tanzania)', 'Tanzania', 'sw', 'sw_TZ', 0, 633, '[[regtime]]', NULL, 1, NULL),
(634, 'Swahili (Uganda)', 'Uganda', 'sw', 'sw_UG', 0, 634, '[[regtime]]', NULL, 1, NULL),
(635, 'Tamil', '', 'ta', 'ta', 0, 635, '[[regtime]]', NULL, 1, NULL),
(636, 'Tamil (India)', 'à®‡à®¨à¯à®¤à®¿à®¯à®¾', 'ta', 'ta_IN', 0, 636, '[[regtime]]', NULL, 1, NULL),
(637, 'Tamil (Sri Lanka)', 'à®‡à®²à®™à¯à®•à¯ˆ', 'ta', 'ta_LK', 0, 637, '[[regtime]]', NULL, 1, NULL),
(638, 'Tamil (Malaysia)', 'à®®à®²à¯‡à®šà®¿à®¯à®¾', 'ta', 'ta_MY', 0, 638, '[[regtime]]', NULL, 1, NULL),
(639, 'Tamil (Singapore)', 'à®šà®¿à®™à¯à®•à®ªà¯à®ªà¯‚à®°à¯', 'ta', 'ta_SG', 0, 639, '[[regtime]]', NULL, 1, NULL),
(640, 'Telugu', '', 'te', 'te', 0, 640, '[[regtime]]', NULL, 1, NULL),
(641, 'Telugu (India)', 'à°à°¾à°°à°¤ à°¦à±‡à°¶à°‚', 'te', 'te_IN', 0, 641, '[[regtime]]', NULL, 1, NULL),
(642, 'Teso', '', 'teo', 'teo', 0, 642, '[[regtime]]', NULL, 1, NULL),
(643, 'Teso (Kenya)', 'Kenia', 'teo', 'teo_KE', 0, 643, '[[regtime]]', NULL, 1, NULL),
(644, 'Teso (Uganda)', 'Uganda', 'teo', 'teo_UG', 0, 644, '[[regtime]]', NULL, 1, NULL),
(645, 'Thai', '', 'th', 'th', 0, 645, '[[regtime]]', NULL, 1, NULL),
(646, 'Thai (Thailand)', 'à¹„à¸—à¸¢', 'th', 'th_TH', 0, 646, '[[regtime]]', NULL, 1, NULL),
(647, 'Tigrinya', '', 'ti', 'ti', 0, 647, '[[regtime]]', NULL, 1, NULL),
(648, 'Tigrinya (Eritrea)', 'ER', 'ti', 'ti_ER', 0, 648, '[[regtime]]', NULL, 1, NULL),
(649, 'Tigrinya (Ethiopia)', 'ET', 'ti', 'ti_ET', 0, 649, '[[regtime]]', NULL, 1, NULL),
(650, 'Tongan', '', 'to', 'to', 0, 650, '[[regtime]]', NULL, 1, NULL),
(651, 'Tongan (Tonga)', 'Tonga', 'to', 'to_TO', 0, 651, '[[regtime]]', NULL, 1, NULL),
(652, 'Turkish', '', 'tr', 'tr', 0, 652, '[[regtime]]', NULL, 1, NULL),
(653, 'Turkish (Cyprus)', 'KÄ±brÄ±s', 'tr', 'tr_CY', 0, 653, '[[regtime]]', NULL, 1, NULL),
(654, 'Turkish (Turkey)', 'TÃ¼rkiye', 'tr', 'tr_TR', 0, 654, '[[regtime]]', NULL, 1, NULL),
(655, 'Tasawaq', '', 'twq', 'twq', 0, 655, '[[regtime]]', NULL, 1, NULL),
(656, 'Tasawaq (Niger)', 'NiÅ¾er', 'twq', 'twq_NE', 0, 656, '[[regtime]]', NULL, 1, NULL),
(657, 'Central Atlas Tamazight', '', 'tzm', 'tzm', 0, 657, '[[regtime]]', NULL, 1, NULL),
(658, 'Central Atlas Tamazight (Morocco)', 'Meá¹›á¹›uk', 'tzm', 'tzm_MA', 0, 658, '[[regtime]]', NULL, 1, NULL),
(659, 'Uyghur', '', 'ug', 'ug', 0, 659, '[[regtime]]', NULL, 1, NULL),
(660, 'Uyghur (China)', 'Ø¬Û‡ÚÚ¯Ùˆ', 'ug', 'ug_CN', 0, 660, '[[regtime]]', NULL, 1, NULL),
(661, 'Ukrainian', '', 'uk', 'uk', 0, 661, '[[regtime]]', NULL, 1, NULL),
(662, 'Ukrainian (Ukraine)', 'Ð£ÐºÑ€Ð°Ñ—Ð½Ð°', 'uk', 'uk_UA', 0, 662, '[[regtime]]', NULL, 1, NULL),
(663, 'Urdu', '', 'ur', 'ur', 0, 663, '[[regtime]]', NULL, 1, NULL),
(664, 'Urdu (India)', 'Ø¨Ú¾Ø§Ø±Øª', 'ur', 'ur_IN', 0, 664, '[[regtime]]', NULL, 1, NULL),
(665, 'Urdu (Pakistan)', 'Ù¾Ø§Ú©Ø³ØªØ§Ù†', 'ur', 'ur_PK', 0, 665, '[[regtime]]', NULL, 1, NULL),
(666, 'Uzbek', '', 'uz', 'uz', 0, 666, '[[regtime]]', NULL, 1, NULL),
(667, 'Uzbek (Arabic)', '', 'uz', 'uz_Arab', 0, 667, '[[regtime]]', NULL, 1, NULL),
(668, 'Uzbek (Arabic, Afghanistan)', 'Ø§ÙØºØ§Ù†Ø³ØªØ§Ù†', 'uz', 'uz_Arab_AF', 0, 668, '[[regtime]]', NULL, 1, NULL),
(669, 'Uzbek (Cyrillic)', '', 'uz', 'uz_Cyrl', 0, 669, '[[regtime]]', NULL, 1, NULL),
(670, 'Uzbek (Cyrillic, Uzbekistan)', 'ÐŽÐ·Ð±ÐµÐºÐ¸ÑÑ‚Ð¾Ð½', 'uz', 'uz_Cyrl_UZ', 0, 670, '[[regtime]]', NULL, 1, NULL),
(671, 'Uzbek (Latin)', '', 'uz', 'uz_Latn', 0, 671, '[[regtime]]', NULL, 1, NULL),
(672, 'Uzbek (Latin, Uzbekistan)', 'OÊ»zbekiston', 'uz', 'uz_Latn_UZ', 0, 672, '[[regtime]]', NULL, 1, NULL),
(673, 'Vai', '', 'vai', 'vai', 0, 673, '[[regtime]]', NULL, 1, NULL),
(674, 'Vai (Latin)', '', 'vai', 'vai_Latn', 0, 674, '[[regtime]]', NULL, 1, NULL),
(675, 'Vai (Latin, Liberia)', 'Laibhiya', 'vai', 'vai_Latn_LR', 0, 675, '[[regtime]]', NULL, 1, NULL),
(676, 'Vai (Vai)', '', 'vai', 'vai_Vaii', 0, 676, '[[regtime]]', NULL, 1, NULL),
(677, 'Vai (Vai, Liberia)', 'ê•žê”¤ê”«ê•©', 'vai', 'vai_Vaii_LR', 0, 677, '[[regtime]]', NULL, 1, NULL),
(678, 'Vietnamese', '', 'vi', 'vi', 0, 678, '[[regtime]]', NULL, 1, NULL),
(679, 'Vietnamese (Vietnam)', 'Viá»‡t Nam', 'vi', 'vi_VN', 0, 679, '[[regtime]]', NULL, 1, NULL),
(680, 'Vunjo', '', 'vun', 'vun', 0, 680, '[[regtime]]', NULL, 1, NULL),
(681, 'Vunjo (Tanzania)', 'Tanzania', 'vun', 'vun_TZ', 0, 681, '[[regtime]]', NULL, 1, NULL),
(682, 'Walser', '', 'wae', 'wae', 0, 682, '[[regtime]]', NULL, 1, NULL),
(683, 'Walser (Switzerland)', 'Schwiz', 'wae', 'wae_CH', 0, 683, '[[regtime]]', NULL, 1, NULL),
(684, 'Soga', '', 'xog', 'xog', 0, 684, '[[regtime]]', NULL, 1, NULL),
(685, 'Soga (Uganda)', 'Yuganda', 'xog', 'xog_UG', 0, 685, '[[regtime]]', NULL, 1, NULL),
(686, 'Yangben', '', 'yav', 'yav', 0, 686, '[[regtime]]', NULL, 1, NULL),
(687, 'Yangben (Cameroon)', 'KemelÃºn', 'yav', 'yav_CM', 0, 687, '[[regtime]]', NULL, 1, NULL),
(688, 'Yiddish', '', 'yi', 'yi', 0, 688, '[[regtime]]', NULL, 1, NULL),
(689, 'Yiddish (World)', '×•×•×¢×œ×˜', 'yi', 'yi_001', 0, 689, '[[regtime]]', NULL, 1, NULL),
(690, 'Yoruba', '', 'yo', 'yo', 0, 690, '[[regtime]]', NULL, 1, NULL),
(691, 'Yoruba (Benin)', 'OrÃlÉ›ÌÃ¨de BÉ›Ì€nÉ›Ì€', 'yo', 'yo_BJ', 0, 691, '[[regtime]]', NULL, 1, NULL),
(692, 'Yoruba (Nigeria)', 'OrÃláº¹ÌÃ¨de NÃ Ã¬jÃrÃÃ ', 'yo', 'yo_NG', 0, 692, '[[regtime]]', NULL, 1, NULL),
(693, 'Cantonese', '', 'yue', 'yue', 0, 693, '[[regtime]]', NULL, 1, NULL),
(694, 'Cantonese (Hong Kong SAR China)', 'ä¸è¯äººæ°‘å…±å’Œåœ‹é¦™æ¸¯ç‰¹åˆ¥è¡Œæ”¿å€', 'yue', 'yue_HK', 0, 694, '[[regtime]]', NULL, 1, NULL),
(695, 'Standard Moroccan Tamazight', '', 'zgh', 'zgh', 0, 695, '[[regtime]]', NULL, 1, NULL),
(696, 'Standard Moroccan Tamazight (Morocco)', 'âµâµŽâµ–âµ”âµ‰â´±', 'zgh', 'zgh_MA', 0, 696, '[[regtime]]', NULL, 1, NULL),
(697, 'Chinese', '', 'zh', 'zh', 1, 697, '[[regtime]]', NULL, 1, NULL),
(698, 'Chinese (Simplified)', '', 'zh', 'zh_Hans', 0, 698, '[[regtime]]', NULL, 1, NULL),
(699, 'Chinese (Simplified, China)', 'ä¸å›½', 'zh', 'zh_Hans_CN', 0, 699, '[[regtime]]', NULL, 1, NULL),
(700, 'Chinese (Simplified, Hong Kong SAR China)', 'ä¸å›½é¦™æ¸¯ç‰¹åˆ«è¡Œæ”¿åŒº', 'zh', 'zh_Hans_HK', 0, 700, '[[regtime]]', NULL, 1, NULL),
(701, 'Chinese (Simplified, Macau SAR China)', 'ä¸å›½æ¾³é—¨ç‰¹åˆ«è¡Œæ”¿åŒº', 'zh', 'zh_Hans_MO', 0, 701, '[[regtime]]', NULL, 1, NULL),
(702, 'Chinese (Simplified, Singapore)', 'æ–°åŠ å¡', 'zh', 'zh_Hans_SG', 0, 702, '[[regtime]]', NULL, 1, NULL),
(703, 'Chinese (Traditional)', '', 'zh', 'zh_Hant', 0, 703, '[[regtime]]', NULL, 1, NULL),
(704, 'Chinese (Traditional, Hong Kong SAR China)', 'ä¸åœ‹é¦™æ¸¯ç‰¹åˆ¥è¡Œæ”¿å€', 'zh', 'zh_Hant_HK', 0, 704, '[[regtime]]', NULL, 1, NULL),
(705, 'Chinese (Traditional, Macau SAR China)', 'ä¸åœ‹æ¾³é–€ç‰¹åˆ¥è¡Œæ”¿å€', 'zh', 'zh_Hant_MO', 0, 705, '[[regtime]]', NULL, 1, NULL),
(706, 'Chinese (Traditional, Taiwan)', 'å°ç£', 'zh', 'zh_Hant_TW', 0, 706, '[[regtime]]', NULL, 1, NULL),
(707, 'Zulu', '', 'zu', 'zu', 0, 707, '[[regtime]]', NULL, 1, NULL),
(708, 'Zulu (South Africa)', 'i-South Africa', 'zu', 'zu_ZA', 0, 708, '[[regtime]]', NULL, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(20) DEFAULT NULL,
  `menu_id` int(20) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `target` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `lft` int(11) DEFAULT NULL,
  `rght` int(11) DEFAULT NULL,
  `visibility_roles` text COLLATE utf8_unicode_ci,
  `params` text COLLATE utf8_unicode_ci,
  `publish_start` datetime DEFAULT NULL,
  `publish_end` datetime DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_links2menus` (`menu_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;

--
-- Dumping data for table `links`
--

INSERT INTO `links` VALUES
(5, NULL, 4, 'About', 'about', '', 'plugin:Croogo%2fNodes/controller:Nodes/action:view/type:page/slug:about', '', '', 1, 3, 4, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(6, NULL, 4, 'Contact', 'contact', '', 'plugin:Croogo%2fContacts/controller:Contacts/action:view/contact', '', '', 1, 5, 6, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(7, NULL, 3, 'Home', 'home', '', 'plugin:Croogo%2fNodes/controller:Nodes/action:promoted', '', '', 1, 5, 6, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(8, NULL, 3, 'About', 'about', '', 'plugin:Croogo%2fNodes/controller:Nodes/action:view/type:page/slug:about', '', '', 1, 7, 10, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(9, 8, 3, 'Child link', 'child-link', '', '#', '', '', 0, 8, 9, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(10, NULL, 5, 'Site Admin', 'site-admin', '', '/admin', '', '', 1, 1, 2, '["2","3"]', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(11, NULL, 5, 'Log out', 'log-out', '', '/plugin:Croogo%2fUsers/controller:Users/action:logout', '', '', 1, 7, 8, '["1","3","4","5"]', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(12, NULL, 6, 'Croogo', 'croogo', '', 'http://www.croogo.org', '', '', 1, 3, 4, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(14, NULL, 6, 'CakePHP', 'cakephp', '', 'http://www.cakephp.org', '', '', 1, 1, 2, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(15, NULL, 3, 'Contact', 'contact', '', '/plugin:Croogo%2fContacts/controller:Contacts/action:view/contact', '', '', 1, 11, 12, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(16, NULL, 5, 'Entries (RSS)', 'entries-rss', '', 'plugin:Croogo%2fNodes/controller:Nodes/action:feed/_ext:rss', '', '', 1, 3, 4, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(17, NULL, 5, 'Comments (RSS)', 'comments-rss', '', 'plugin:Croogo%2fComments/controller:Comments/action:index/_ext:rss', '', '', 0, 5, 6, '', '', NULL, NULL, '[[regtime]]', NULL, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `status` int(1) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `link_count` int(11) NOT NULL DEFAULT '0',
  `params` text COLLATE utf8_unicode_ci,
  `publish_start` datetime DEFAULT NULL,
  `publish_end` datetime DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`(190))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES
(3, 'Main Menu', 'main', '', '', 1, NULL, 4, '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(4, 'Footer', 'footer', '', '', 1, NULL, 2, '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(5, 'Meta', 'meta', '', '', 1, NULL, 4, '', NULL, NULL, '[[regtime]]', NULL, 1, NULL),
(6, 'Blogroll', 'blogroll', '', '', 1, NULL, 2, '', NULL, NULL, '[[regtime]]', NULL, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contact_id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci,
  `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `message_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `modified_by` int(20) DEFAULT NULL,
  `created_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_messages2contacts` (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `meta`
--

CREATE TABLE `meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Node',
  `foreign_key` int(20) DEFAULT NULL,
  `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `weight` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `meta`
--

INSERT INTO `meta` VALUES
(1, '', NULL, 'meta_description', 'Croogo - A CakePHP powered Content Management System', NULL, '[[regtime]]', NULL, 1, NULL),
(2, '', NULL, 'meta_generator', 'Croogo - Content Management System', NULL, '[[regtime]]', NULL, 1, NULL),
(3, '', NULL, 'meta_robots', 'index, follow', NULL, '[[regtime]]', NULL, 1, NULL),
(4, 'Croogo/Nodes.Nodes', 1, 'meta_keywords', 'key1, key2', NULL, '[[regtime]]', NULL, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `model_taxonomies`
--

CREATE TABLE `model_taxonomies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `foreign_key` int(20) NOT NULL,
  `taxonomy_id` int(20) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `model` (`model`,`foreign_key`,`taxonomy_id`),
  KEY `fk_model_taxonomies2taxonomies` (`taxonomy_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `model_taxonomies`
--

INSERT INTO `model_taxonomies` VALUES
(1, 'Croogo/Nodes.Nodes', 1, 1, '[[regtime]]', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `nodes`
--

CREATE TABLE `nodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(20) DEFAULT NULL,
  `user_id` int(20) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `excerpt` text COLLATE utf8_unicode_ci,
  `status` int(1) DEFAULT NULL,
  `mime_type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment_status` int(1) NOT NULL DEFAULT '1',
  `comment_count` int(11) DEFAULT '0',
  `promote` tinyint(1) NOT NULL DEFAULT '0',
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `terms` text COLLATE utf8_unicode_ci,
  `sticky` tinyint(1) NOT NULL DEFAULT '0',
  `lft` int(11) DEFAULT NULL,
  `rght` int(11) DEFAULT NULL,
  `visibility_roles` text COLLATE utf8_unicode_ci,
  `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'post',
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `publish_start` datetime DEFAULT NULL,
  `publish_end` datetime DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_nodes_slug_by_type` (`type`,`slug`(190)),
  KEY `fk_nodes2users` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `nodes`
--

INSERT INTO `nodes` VALUES
(1, NULL, 1, 'Hello World', 'hello-world', '<p>Welcome to Croogo. This is your first post. You can edit or delete it from the admin panel.</p>', '', 1, '', 2, 1, 1, '/blog/hello-world', '{"1":"uncategorized"}', 0, 1, 2, '', 'blog', 1, NULL, NULL, NULL, '[[regtime]]', NULL),
(2, NULL, 1, 'About', 'about', '<p>This is an example of a Croogo page, you could edit this to put information about yourself or your site.</p>', '', 1, '', 0, 0, 0, '/about', '', 0, 1, 2, '', 'page', 1, NULL, NULL, NULL, '[[regtime]]', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `block_count` int(11) NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `modified_by` int(20) DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` VALUES
(3, 'none', 'none', '', 0, '[[regtime]]', NULL, NULL, 1),
(4, 'right', 'right', '', 6, '[[regtime]]', NULL, NULL, 1),
(6, 'left', 'left', '', 0, '[[regtime]]', NULL, NULL, 1),
(7, 'header', 'header', '', 0, '[[regtime]]', NULL, NULL, 1),
(8, 'footer', 'footer', '', 0, '[[regtime]]', NULL, NULL, 1),
(9, 'region1', 'region1', '', 0, '[[regtime]]', NULL, NULL, 1),
(10, 'region2', 'region2', '', 0, '[[regtime]]', NULL, NULL, 1),
(11, 'region3', 'region3', '', 0, '[[regtime]]', NULL, NULL, 1),
(12, 'region4', 'region4', '', 0, '[[regtime]]', NULL, NULL, 1),
(13, 'region5', 'region5', '', 0, '[[regtime]]', NULL, NULL, 1),
(14, 'region6', 'region6', '', 0, '[[regtime]]', NULL, NULL, 1),
(15, 'region7', 'region7', '', 0, '[[regtime]]', NULL, NULL, 1),
(16, 'region8', 'region8', '', 0, '[[regtime]]', NULL, NULL, 1),
(17, 'region9', 'region9', '', 0, '[[regtime]]', NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES
(1, 'SuperAdmin', 'superadmin', '[[regtime]]', NULL, 1, 1),
(2, 'Public', 'public', '[[regtime]]', NULL, 1, 1),
(3, 'Registered', 'registered', '[[regtime]]', NULL, 1, 1),
(4, 'Admin', 'admin', '[[regtime]]', NULL, 1, 1),
(5, 'Publisher', 'publisher', '[[regtime]]', NULL, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `roles_users`
--

CREATE TABLE `roles_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `granted_by` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `fk_roles_users2roles` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `input_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  `editable` tinyint(1) NOT NULL DEFAULT '1',
  `weight` int(11) DEFAULT NULL,
  `params` text COLLATE utf8_unicode_ci NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=33 ;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES
(1, 'Site.title', 'Croogo', '', '', '', 1, 1, '', '[[regtime]]', NULL, 1, NULL),
(2, 'Site.tagline', 'A CakePHP powered Content Management System.', '', '', 'textarea', 1, 2, '', '[[regtime]]', NULL, 1, NULL),
(3, 'Site.email', 'you@your-site.com', '', '', '', 1, 3, '', '[[regtime]]', NULL, 1, NULL),
(4, 'Site.status', '1', '', '', 'checkbox', 1, 6, '', '[[regtime]]', NULL, 1, NULL),
(5, 'Service.akismet_key', 'your-key', '', '', '', 1, 11, '', '[[regtime]]', NULL, 1, NULL),
(6, 'Service.recaptcha_public_key', 'your-public-key', '', '', '', 1, 12, '', '[[regtime]]', NULL, 1, NULL),
(7, 'Service.recaptcha_private_key', 'your-private-key', '', '', '', 1, 13, '', '[[regtime]]', NULL, 1, NULL),
(8, 'Service.akismet_url', 'http://your-blog.com', '', '', '', 1, 10, '', '[[regtime]]', NULL, 1, NULL),
(9, 'Site.theme', 'Croogo/Core', '', '', '', 0, 14, '', '[[regtime]]', NULL, 1, NULL),
(10, 'Site.feed_url', '', '', '', '', 0, 15, '', '[[regtime]]', NULL, 1, NULL),
(11, 'Reading.nodes_per_page', '5', '', '', '', 1, 16, '', '[[regtime]]', NULL, 1, NULL),
(12, 'Comment.level', '1', '', 'levels deep (threaded comments)', '', 1, 18, '', '[[regtime]]', NULL, 1, NULL),
(13, 'Comment.feed_limit', '10', '', 'number of comments to show in feed', '', 1, 19, '', '[[regtime]]', NULL, 1, NULL),
(14, 'Site.locale', 'en_US', '', '', 'text', 1, 20, '', '[[regtime]]', NULL, 1, NULL),
(15, 'Reading.date_time_format', 'EEE, MMM dd yyyy HH:mm:ss', '', '', '', 1, 21, '', '[[regtime]]', NULL, 1, NULL),
(16, 'Comment.date_time_format', 'MMM dd, yyyy', '', '', '', 1, 22, '', '[[regtime]]', NULL, 1, NULL),
(17, 'Site.timezone', 'UTC', '', 'Provide a valid timezone identifier as specified in https://php.net/manual/en/timezones.php', 'select', 1, 4, 'optionClass=Croogo/Settings.Timezones', '[[regtime]]', NULL, 1, NULL),
(18, 'Hook.bootstraps', 'Croogo/Settings,Croogo/Contacts,Croogo/Nodes,Croogo/Meta,Croogo/Menus,Croogo/Users,Croogo/Blocks,Croogo/Taxonomy,Croogo/FileManager,Croogo/Wysiwyg,Croogo/Dashboards', '', '', '', 0, 23, '', '[[regtime]]', NULL, 1, NULL),
(19, 'Comment.email_notification', '1', 'Enable email notification', '', 'checkbox', 1, 24, '', '[[regtime]]', NULL, 1, NULL),
(20, 'Access Control.multiRole', '0', 'Enable Multiple Roles', '', 'checkbox', 1, 25, '', '[[regtime]]', NULL, 1, NULL),
(21, 'Access Control.rowLevel', '0', 'Row Level Access Control', '', 'checkbox', 1, 26, '', '[[regtime]]', NULL, 1, NULL),
(22, 'Access Control.autoLoginDuration', '+1 week', '"Remember Me" Duration', 'Eg: +1 day, +1 week. Leave empty to disable.', 'text', 1, 27, '', '[[regtime]]', NULL, 1, NULL),
(23, 'Access Control.models', '', 'Models with Row Level Acl', 'Select models to activate Row Level Access Control on', 'multiple', 1, 26, 'multiple=checkbox\noptions={"Croogo/Nodes.Nodes": "Nodes", "Croogo/Blocks.Blocks": "Blocks", "Croogo/Menus.Menus": "Menus", "Croogo/Menus.Links": "Links"}', '[[regtime]]', NULL, 1, NULL),
(24, 'Site.ipWhitelist', '127.0.0.1', 'Whitelisted IP Addresses', 'Separate multiple IP addresses with comma', 'text', 1, 27, '', '[[regtime]]', NULL, 1, NULL),
(25, 'Site.asset_timestamp', 'force', 'Asset timestamp', 'Appends a timestamp which is last modified time of the particular file at the end of asset files URLs (CSS, JavaScript, Image). Useful to prevent visitors to visit the site with an outdated version of these files in their browser cache.', 'radio', 1, 28, 'options={"0": "Disabled", "1": "Enabled in debug mode only", "force": "Always enabled"}', '[[regtime]]', NULL, 1, NULL),
(26, 'Site.admin_theme', 'Croogo/Core', 'Administration Theme', '', 'text', 1, 29, '', '[[regtime]]', NULL, 1, NULL),
(27, 'Site.home_url', '', 'Home Url', 'Default action for home page in link string format.', 'text', 1, 30, '', '[[regtime]]', NULL, 1, NULL),
(28, 'Croogo.version', '', 'Croogo Version', '', 'text', 0, 31, '', '[[regtime]]', NULL, 1, NULL),
(29, 'Croogo.appVersion', '', 'App Version', '', 'text', 0, 31, '', '[[regtime]]', NULL, 1, NULL),
(30, 'Theme.bgImagePath', '', 'Background Image', '', 'file', 1, 32, '', '[[regtime]]', NULL, 1, NULL),
(31, 'Access Control.splitSession', '', 'Separate front-end and admin session', '', 'checkbox', 1, 32, '', '[[regtime]]', NULL, 1, NULL),
(32, 'Croogo.installed', '1', '', '', '', 0, 0, '', '[[regtime]]', NULL, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `taxonomies`
--

CREATE TABLE `taxonomies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(20) DEFAULT NULL,
  `term_id` int(10) NOT NULL,
  `vocabulary_id` int(10) NOT NULL,
  `lft` int(11) DEFAULT NULL,
  `rght` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_taxonomies2terms` (`term_id`),
  KEY `fk_taxonomies2vocabularies` (`vocabulary_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `taxonomies`
--

INSERT INTO `taxonomies` VALUES
(1, NULL, 1, 1, 1, 2, '[[regtime]]', NULL),
(2, NULL, 2, 1, 3, 4, '[[regtime]]', NULL),
(3, NULL, 3, 2, 1, 2, '[[regtime]]', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `terms`
--

CREATE TABLE `terms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `params` text COLLATE utf8_unicode_ci,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`(190))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `terms`
--

INSERT INTO `terms` VALUES
(1, 'Uncategorized', 'uncategorized', '', NULL, '[[regtime]]', NULL, 1, NULL),
(2, 'Announcements', 'announcements', '', NULL, '[[regtime]]', NULL, 1, NULL),
(3, 'mytag', 'mytag', '', NULL, '[[regtime]]', NULL, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `types`
--

CREATE TABLE `types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `format_show_author` tinyint(1) NOT NULL DEFAULT '1',
  `format_show_date` tinyint(1) NOT NULL DEFAULT '1',
  `format_use_wysiwyg` tinyint(1) NOT NULL DEFAULT '1',
  `comment_status` int(1) NOT NULL DEFAULT '1',
  `comment_approve` tinyint(1) NOT NULL DEFAULT '1',
  `comment_spam_protection` tinyint(1) NOT NULL DEFAULT '0',
  `comment_captcha` tinyint(1) NOT NULL DEFAULT '0',
  `params` text COLLATE utf8_unicode_ci,
  `plugin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`(190))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `types`
--

INSERT INTO `types` VALUES
(1, 'Page', 'page', 'A page is a simple method for creating and displaying information that rarely changes, such as an "About us" section of a website. By default, a page entry does not allow visitor comments.', 0, 0, 1, 0, 1, 0, 0, 'routes=true', NULL, '[[regtime]]', NULL, 1, NULL),
(2, 'Blog', 'blog', 'A blog entry is a single post to an online journal, or blog.', 1, 1, 1, 2, 1, 0, 0, 'routes=true', NULL, '[[regtime]]', NULL, 1, NULL),
(4, 'Post', 'post', 'Default content type.', 1, 1, 1, 2, 1, 0, 0, 'routes=true', NULL, '[[regtime]]', NULL, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `types_vocabularies`
--

CREATE TABLE `types_vocabularies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(20) NOT NULL,
  `vocabulary_id` int(20) NOT NULL,
  `weight` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type_id` (`type_id`,`vocabulary_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=32 ;

--
-- Dumping data for table `types_vocabularies`
--

INSERT INTO `types_vocabularies` VALUES
(24, 4, 1, NULL, '[[regtime]]', NULL),
(25, 4, 2, NULL, '[[regtime]]', NULL),
(30, 2, 1, NULL, '[[regtime]]', NULL),
(31, 2, 2, NULL, '[[regtime]]', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `username` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `website` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `activation_key` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bio` text COLLATE utf8_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `timezone` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'UTC',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_users2roles` (`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES
(1, 1, '[[admin_username]]', '[[admin_pass]]', '[[admin_username]]', '[[admin_email]]', NULL, '[[activation_key]]', NULL, NULL, 1, 'UTC', '[[regtime]]', '[[regtime]]', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `vocabularies`
--

CREATE TABLE `vocabularies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `multiple` tinyint(1) NOT NULL DEFAULT '0',
  `tags` tinyint(1) NOT NULL DEFAULT '0',
  `plugin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `created_by` int(20) NOT NULL,
  `modified_by` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`(190))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `vocabularies`
--

INSERT INTO `vocabularies` VALUES
(1, 'Categories', 'categories', '', 0, 1, 0, NULL, 1, '[[regtime]]', NULL, 1, NULL),
(2, 'Tags', 'tags', '', 0, 1, 0, NULL, 2, '[[regtime]]', NULL, 1, NULL);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blocks`
--
ALTER TABLE `blocks`
  ADD CONSTRAINT `fk_blocks2regions` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`);

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `fk_comments2users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `dashboards`
--
ALTER TABLE `dashboards`
  ADD CONSTRAINT `fk_dashboards2users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `links`
--
ALTER TABLE `links`
  ADD CONSTRAINT `fk_links2menus` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`);

--
-- Constraints for table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `fk_messages2contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`);

--
-- Constraints for table `model_taxonomies`
--
ALTER TABLE `model_taxonomies`
  ADD CONSTRAINT `fk_model_taxonomies2taxonomies` FOREIGN KEY (`taxonomy_id`) REFERENCES `taxonomies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `nodes`
--
ALTER TABLE `nodes`
  ADD CONSTRAINT `fk_nodes2users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `roles_users`
--
ALTER TABLE `roles_users`
  ADD CONSTRAINT `fk_roles_users2roles` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  ADD CONSTRAINT `fk_roles_users2users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `taxonomies`
--
ALTER TABLE `taxonomies`
  ADD CONSTRAINT `fk_taxonomies2terms` FOREIGN KEY (`term_id`) REFERENCES `terms` (`id`),
  ADD CONSTRAINT `fk_taxonomies2vocabularies` FOREIGN KEY (`vocabulary_id`) REFERENCES `vocabularies` (`id`);

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `fk_users2roles` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

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