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