-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Jan 22, 2018 at 10:31 AM
-- Server version: 5.5.42
-- PHP Version: 5.6.10

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: `laraclassified`
--


-- cities
UPDATE `<<prefix>>cities` SET `name` = 'Akyar', `asciiname` = 'Akyar' WHERE `country_code` LIKE 'RU' AND `name` LIKE 'Ak”yar';


-- home_sections
UPDATE `<<prefix>>home_sections` SET `name` = 'Locations & Country Map' WHERE `method` = 'getLocations';


-- messages
ALTER TABLE `<<prefix>>messages` 
    ADD `parent_id` INT UNSIGNED NULL DEFAULT '0' AFTER `post_id`, 
    ADD `from_user_id` INT UNSIGNED NULL DEFAULT '0' AFTER `parent_id`, 
    ADD `to_user_id` INT UNSIGNED NULL DEFAULT '0' AFTER `from_user_id`;
ALTER TABLE `<<prefix>>messages` 
    ADD `from_name` VARCHAR(200) NULL DEFAULT NULL AFTER `from_user_id`, 
    ADD `from_email` VARCHAR(100) NULL DEFAULT NULL AFTER `from_name`, 
    ADD `from_phone` VARCHAR(50) NULL DEFAULT NULL AFTER `from_email`;
ALTER TABLE `<<prefix>>messages` 
    CHANGE `name` `to_name` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, 
    CHANGE `email` `to_email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, 
    CHANGE `phone` `to_phone` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `<<prefix>>messages` CHANGE `reply_sent` `is_read` TINYINT(1) UNSIGNED NULL DEFAULT '0';
ALTER TABLE `<<prefix>>messages` CHANGE `post_id` `post_id` INT(10) UNSIGNED NULL DEFAULT '0';
ALTER TABLE `<<prefix>>messages` CHANGE `message` `message` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `<<prefix>>messages` ADD `subject` TEXT NULL DEFAULT NULL AFTER `to_phone`;
ALTER TABLE `<<prefix>>messages` ADD `deleted_by` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `is_read`;

ALTER TABLE `<<prefix>>messages` ADD INDEX(`parent_id`);
ALTER TABLE `<<prefix>>messages` ADD INDEX(`from_user_id`);
ALTER TABLE `<<prefix>>messages` ADD INDEX(`to_user_id`);
ALTER TABLE `<<prefix>>messages` ADD INDEX(`deleted_by`);


-- settings
TRUNCATE TABLE `<<prefix>>settings`;

INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(1, 'app', 'Application', NULL, 'Application Setup', '[\n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Brand Info</h3>\"},\n    {\"name\":\"purchase_code\",\"label\":\"Purchase Code\",\"type\":\"text\",\"hint\":\"Get your Purchase Code <a href=\\\"https://help.market.envato.com/hc/en-us/articles/202822600-Where-Is-My-Purchase-Code-\\\" target=\\\"_blank\\\">here</a>.\"},\n    {\"name\":\"name\",\"label\":\"App Name\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"slogan\",\"label\":\"App Slogan\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"logo\",\"label\":\"App Logo\",\"type\":\"image\",\"upload\":\"true\",\"disk\":\"uploads\",\"default\":\"app/default/logo.png\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"favicon\",\"label\":\"Favicon\",\"type\":\"image\",\"upload\":\"true\",\"disk\":\"uploads\",\"default\":\"app/default/ico/favicon.png\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"separator_clear_1\",\"type\":\"custom_html\",\"value\":\"<div style=\\\"clear: both;\\\"></div>\"},\n    {\"name\":\"email\",\"label\":\"Email\",\"type\":\"email\",\"hint\":\"The email address that all emails from the contact form will go to.\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"phone_number\",\"label\":\"Phone number\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n\n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>Date Format</h3>\"},\n    {\"name\":\"default_date_format\",\"label\":\"Date Format\",\"type\":\"text\",\"hint\":\"The implementation makes a call to <a href=\\\"http://php.net/strftime\\\" target=\\\"_blank\\\">strftime</a> using the current instance timestamp.\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"default_datetime_format\",\"label\":\"Date Time Format\",\"type\":\"text\",\"hint\":\"The implementation makes a call to <a href=\\\"http://php.net/strftime\\\" target=\\\"_blank\\\">strftime</a> using the current instance timestamp.\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"default_timezone\",\"label\":\"Default Timezone\",\"type\":\"select2\",\"attribute\":\"time_zone_id\",\"model\":\"\\\\App\\\\Models\\\\TimeZone\",\"hint\":\"NOTE: This option is used in the Admin panel\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}}\n]', 0, 2, 3, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(2, 'style', 'Style', NULL, 'Style Customization', '[\n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Front-End</h3>\"},\n    {\"name\":\"app_skin\",\"label\":\"Front Skin\",\"type\":\"select2_from_array\",\"options\":{\"skin-default\":\"Default\",\"skin-blue\":\"Blue\",\"skin-yellow\":\"Yellow\",\"skin-green\":\"Green\",\"skin-red\":\"Red\"}},\n    \n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h4>Customize the Front Style</h4>\"},\n    {\"name\":\"separator_2_1\",\"type\":\"custom_html\",\"value\":\"<h5><strong>Global</strong></h5>\"},\n    {\"name\":\"body_background_color\",\"label\":\"Body Background Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#FFFFFF\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"body_text_color\",\"label\":\"Body Text Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#292B2C\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"body_background_image\",\"label\":\"Body Background Image\",\"type\":\"image\",\"upload\":\"true\",\"disk\":\"uploads\",\"default\":\"\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"separator_clear_1\",\"type\":\"custom_html\",\"value\":\"<div style=\\\"clear: both;\\\"></div>\"},\n    {\"name\":\"body_background_image_fixed\",\"label\":\"Body Background Image Fixed\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\",\"style\":\"margin-top: 20px;\"}},\n    {\"name\":\"page_width\",\"label\":\"Page Width\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"separator_clear_2\",\"type\":\"custom_html\",\"value\":\"<div style=\\\"clear: both;\\\"></div>\"},\n    {\"name\":\"title_color\",\"label\":\"Titles Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#292B2C\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"progress_background_color\",\"label\":\"Progress Background Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"link_color\",\"label\":\"Links Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#4682B4\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"link_color_hover\",\"label\":\"Links Color (Hover)\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#FF8C00\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_2_2\",\"type\":\"custom_html\",\"value\":\"<h5><strong>Header</strong></h5>\"},\n    {\"name\":\"header_sticky\",\"label\":\"Header Sticky\",\"type\":\"checkbox\"},\n    {\"name\":\"header_height\",\"label\":\"Header Height\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"header_background_color\",\"label\":\"Header Background Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#F8F8F8\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"header_bottom_border_width\",\"label\":\"Header Bottom Border Width\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"header_bottom_border_color\",\"label\":\"Header Bottom Border Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#E8E8E8\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"header_link_color\",\"label\":\"Header Links Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#333\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"header_link_color_hover\",\"label\":\"Header Links Color (Hover)\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#000\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n\n    {\"name\":\"separator_2_3\",\"type\":\"custom_html\",\"value\":\"<h5><strong>Footer</strong></h5>\"},\n    {\"name\":\"footer_background_color\",\"label\":\"Footer Background Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#F5F5F5\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"footer_text_color\",\"label\":\"Footer Text Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#333\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"footer_title_color\",\"label\":\"Footer Titles Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#000\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"separator_clear_2\",\"type\":\"custom_html\",\"value\":\"<div style=\\\"clear: both;\\\"></div>\"},\n    {\"name\":\"footer_link_color\",\"label\":\"Footer Links Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#333\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"footer_link_color_hover\",\"label\":\"Footer Links Color (Hover)\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#333\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"payment_icon_top_border_width\",\"label\":\"Payment Methods Icons Top Border Width\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"payment_icon_top_border_color\",\"label\":\"Payment Methods Icons Top Border Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#DDD\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"payment_icon_bottom_border_width\",\"label\":\"Payment Methods Icons Bottom Border Width\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"payment_icon_bottom_border_color\",\"label\":\"Payment Methods Icons Bottom Border Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#DDD\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n\n    {\"name\":\"separator_2_4\",\"type\":\"custom_html\",\"value\":\"<h5><strong>Button \'Add Listing\'</strong></h5>\"},\n    {\"name\":\"btn_post_bg_top_color\",\"label\":\"Gradient Background Top Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#ffeb43\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"btn_post_bg_bottom_color\",\"label\":\"Gradient Background Bottom Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#fcde11\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"btn_post_border_color\",\"label\":\"Button Border Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#f6d80f\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"btn_post_text_color\",\"label\":\"Button Text Color\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#292b2c\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"btn_post_bg_top_color_hover\",\"label\":\"Gradient Background Top Color (Hover)\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#fff860\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"btn_post_bg_bottom_color_hover\",\"label\":\"Gradient Background Bottom Color (Hover)\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#ffeb43\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"btn_post_border_color_hover\",\"label\":\"Button Border Color (Hover)\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#fcde11\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"btn_post_text_color_hover\",\"label\":\"Button Text Color (Hover)\",\"type\":\"color_picker\",\"colorpicker_options\":{\"customClass\":\"custom-class\"},\"attributes\":{\"placeholder\":\"#1b1d1e\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n\n    {\"name\":\"separator_3\",\"type\":\"custom_html\",\"value\":\"<h4>Raw CSS (Optional)</h4>\"},\n    {\"name\":\"separator_3_1\",\"type\":\"custom_html\",\"value\":\"You can also add raw CSS to customize your website style by using the field below. <br>If you want to add a large CSS code, you have to use the /public/css/custom.css file.\"},\n    {\"name\":\"custom_css\",\"label\":\"Custom CSS\",\"type\":\"textarea\",\"attributes\":{\"rows\":\"5\"},\"hint\":\"Please <strong>do not</strong> include the &lt;style&gt; tags.\"},\n    \n    {\"name\":\"separator_4\",\"type\":\"custom_html\",\"value\":\"<h3>Admin panel</h3>\"},\n    {\"name\":\"admin_skin\",\"label\":\"Admin Skin\",\"type\":\"select2_from_array\",\"options\":{\"skin-black\":\"Black\",\"skin-blue\":\"Blue\",\"skin-purple\":\"Purple\",\"skin-red\":\"Red\",\"skin-yellow\":\"Yellow\",\"skin-green\":\"Green\",\"skin-blue-light\":\"Blue light\",\"skin-black-light\":\"Black light\",\"skin-purple-light\":\"Purple light\",\"skin-green-light\":\"Green light\",\"skin-red-light\":\"Red light\",\"skin-yellow-light\":\"Yellow light\"}}\n]', 0, 4, 5, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(3, 'listing', 'Listing & Search', NULL, 'Listing & Search Options', '[\n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Displaying</h3>\"},\n    {\"name\":\"display_mode\",\"label\":\"Listing Page Display Mode\",\"type\":\"select2_from_array\",\"options\":{\".grid-view\":\"Grid\",\".list-view\":\"List\",\".compact-view\":\"Compact\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"grid_view_cols\",\"label\":\"Grid View Columns\",\"type\":\"select2_from_array\",\"options\":{\"4\":\"4\",\"3\":\"3\",\"2\":\"2\"},\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"items_per_page\",\"label\":\"Items per page\",\"type\":\"text\",\"hint\":\"Number of items per page (> 4 and < 40)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"left_sidebar\",\"label\":\"Listing Page Left Sidebar\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\",\"style\":\"margin-top: 20px;\"}},\n    \n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>Distance</h3>\"},\n    {\"name\":\"search_distance_max\",\"label\":\"Max Search Distance\",\"type\":\"select2_from_array\",\"options\":{\"1000\":\"1000\",\"900\":\"900\",\"800\":\"800\",\"700\":\"700\",\"600\":\"600\",\"500\":\"500\",\"400\":\"400\",\"300\":\"300\",\"200\":\"200\",\"100\":\"100\",\"50\":\"50\",\"0\":\"0\"},\"hint\":\"Max search radius distance (in km or miles)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"search_distance_default\",\"label\":\"Default Search Distance\",\"type\":\"select2_from_array\",\"options\":{\"200\":\"200\",\"100\":\"100\",\"50\":\"50\",\"25\":\"25\",\"20\":\"20\",\"10\":\"10\",\"0\":\"0\"},\"hint\":\"Default search radius distance (in km or miles)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"search_distance_interval\",\"label\":\"Distance Interval\",\"type\":\"select2_from_array\",\"options\":{\"250\":\"250\",\"200\":\"200\",\"100\":\"100\",\"50\":\"50\",\"25\":\"25\",\"20\":\"20\",\"10\":\"10\",\"5\":\"5\"},\"hint\":\"The interval between filter distances (shown on the search results page)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}}\n]', 0, 6, 7, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(4, 'single', 'Ads Single Page', NULL, 'Ads Single Page Options', '[\n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Publication</h3>\"},\n    {\"name\":\"pictures_limit\",\"label\":\"Pictures Limit\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"tags_limit\",\"label\":\"Tags Limit\",\"type\":\"text\",\"hint\":\"NOTE: The \'tags\' field in the \'posts\' table is a varchar 255\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"guests_can_post_ads\",\"label\":\"Allow Guests to post Ads\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"posts_review_activation\",\"label\":\"Allow Ads to be reviewed by Admins\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"guests_can_contact_seller\",\"label\":\"Allow Guests to contact Sellers\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n\n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>Edition</h3>\"},\n    {\"name\":\"simditor_wysiwyg\",\"label\":\"Allow the Simditor WYSIWYG Editor\",\"type\":\"checkbox\"},\n    {\"name\":\"ckeditor_wysiwyg\",\"label\":\"Allow the CKEditor WYSIWYG Editor\",\"type\":\"checkbox\",\"hint\":\"For commercial use: http://ckeditor.com/pricing. NOTE: You need to disable the \'Simditor WYSIWYG Editor\'\"},\n    \n    {\"name\":\"separator_3\",\"type\":\"custom_html\",\"value\":\"<h3>External Services</h3>\"},\n    {\"name\":\"show_post_on_googlemap\",\"label\":\"Show Ads on Google Maps (Single Page Only)\",\"type\":\"checkbox\",\"hint\":\"You have to enter your Google Maps API key at: <br>Setup -> General Settings -> Others.\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"activation_facebook_comments\",\"label\":\"Allow Facebook Comments (Single Page Only)\",\"type\":\"checkbox\",\"hint\":\"You have to configure the Login with Facebook at: <br>Setup -> General Settings -> Social Login.\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_4\",\"type\":\"custom_html\",\"value\":\"<hr>\"}\n]', 0, 8, 9, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(5, 'mail', 'Mail', NULL, 'Mail Sending Configuration', '[\n    {\"name\":\"driver\",\"label\":\"Mail Driver\",\"type\":\"select2_from_array\",\"options\":{\"smtp\":\"SMTP\",\"mailgun\":\"Mailgun\",\"mandrill\":\"Mandrill\",\"ses\":\"Amazon SES\",\"sparkpost\":\"Sparkpost\",\"mail\":\"PHP Mail\",\"sendmail\":\"Sendmail\"}},\n    \n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>SMTP Parameters</h3>\"},\n    {\"name\":\"separator_1_1\",\"type\":\"custom_html\",\"value\":\"Required for drivers: SMTP, Mailgun, Mandrill, Sparkpost\"},\n    {\"name\":\"host\",\"label\":\"Mail Host\",\"type\":\"text\",\"hint\":\"SMTP Host\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"port\",\"label\":\"Mail Port\",\"type\":\"text\",\"hint\":\"SMTP Port (e.g. 25, 587, ...)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"username\",\"label\":\"Mail Username\",\"type\":\"text\",\"hint\":\"SMTP Username\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"password\",\"label\":\"Mail Password\",\"type\":\"text\",\"hint\":\"SMTP Password\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"encryption\",\"label\":\"Mail Encryption\",\"type\":\"text\",\"hint\":\"SMTP Encryption (e.g. tls, ssl, starttls)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>Mailgun</h3>\"},\n    {\"name\":\"mailgun_domain\",\"label\":\"Mailgun Domain\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"mailgun_secret\",\"label\":\"Mailgun Secret\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_3\",\"type\":\"custom_html\",\"value\":\"<h3>Mandrill</h3>\"},\n    {\"name\":\"mandrill_secret\",\"label\":\"Mandrill Secret\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_4\",\"type\":\"custom_html\",\"value\":\"<h3>Amazon SES</h3>\"},\n    {\"name\":\"ses_key\",\"label\":\"SES Key\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"ses_secret\",\"label\":\"SES Secret\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"ses_region\",\"label\":\"SES Region\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_5\",\"type\":\"custom_html\",\"value\":\"<h3>Sparkpost</h3>\"},\n    {\"name\":\"sparkpost_secret\",\"label\":\"Sparkpost Secret\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_6\",\"type\":\"custom_html\",\"value\":\"<hr>\"},\n    \n    {\"name\":\"separator_7\",\"type\":\"custom_html\",\"value\":\"<h3>Other Configurations</h3>\"},\n    {\"name\":\"email_sender\",\"label\":\"Transactional Email Sender\",\"type\":\"email\",\"hint\":\"Transactional Email Sender. Example: noreply@yoursite.com\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"email_verification\",\"label\":\"settings_mail_email_verification_label\",\"type\":\"checkbox\",\"hint\":\"settings_mail_email_verification_hint\"},\n    {\"name\":\"admin_notification\",\"label\":\"settings_mail_admin_notification_label\",\"type\":\"checkbox\",\"hint\":\"settings_mail_admin_notification_hint\"},\n    {\"name\":\"payment_notification\",\"label\":\"settings_mail_payment_notification_label\",\"type\":\"checkbox\",\"hint\":\"settings_mail_payment_notification_hint\"}\n]', 0, 10, 11, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(6, 'sms', 'SMS', NULL, 'SMS Sending Configuration', '[\n    {\"name\":\"driver\",\"label\":\"SMS Driver\",\"type\":\"select2_from_array\",\"options\":{\"nexmo\":\"Nexmo\",\"twilio\":\"Twilio\"}},\n    \n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Nexmo</h3>\"},\n    {\"name\":\"separator_1_1\",\"type\":\"custom_html\",\"value\":\"Get a Nexmo Account <a href=\\\"https://www.nexmo.com/\\\" target=\\\"_blank\\\">here</a>.\"},\n    {\"name\":\"nexmo_key\",\"label\":\"Nexmo Key\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"nexmo_secret\",\"label\":\"Nexmo Secret\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"nexmo_from\",\"label\":\"Nexmo From\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>Twilio</h3>\"},\n    {\"name\":\"separator_2_1\",\"type\":\"custom_html\",\"value\":\"Get a Twilio Account <a href=\\\"https://www.twilio.com/\\\" target=\\\"_blank\\\">here</a>.\"},\n    {\"name\":\"twilio_account_sid\",\"label\":\"Twilio Account SID\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"twilio_auth_token\",\"label\":\"Twilio Auth Token\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"twilio_from\",\"label\":\"Twilio From\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_3\",\"type\":\"custom_html\",\"value\":\"<hr>\"},\n    \n    {\"name\":\"separator_4\",\"type\":\"custom_html\",\"value\":\"<h3>Other Configurations</h3>\"},\n    {\"name\":\"phone_verification\",\"label\":\"Enable Phone Verification\",\"type\":\"checkbox\",\"hint\":\"By enabling this option you have to add this entry: <strong>DISABLE_PHONE=false</strong> in the /.env file.\"},\n    {\"name\":\"message_activation\",\"label\":\"Enable SMS Message\",\"type\":\"checkbox\",\"hint\":\"Send a SMS in addition for each message between users. NOTE: You will have a lot to spend on the SMS sending credit.\"}\n]', 0, 12, 13, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(7, 'seo', 'SEO', NULL, 'SEO Tools', '[\n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Verification Tools</h3>\"},\n    {\"name\":\"google_site_verification\",\"label\":\"Google site verification content\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"alexa_verify_id\",\"label\":\"Alexa site verification content\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"msvalidate\",\"label\":\"Bing site verification content\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"twitter_username\",\"label\":\"Twitter Username\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>Indexing (On Search Engines)</h3>\"},\n    {\"name\":\"no_index_categories\",\"label\":\"No Index Categories Pages\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"no_index_tags\",\"label\":\"No Index Tags Pages\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"no_index_cities\",\"label\":\"No Index Cities Pages\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"no_index_users\",\"label\":\"No Index Users Pages\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"no_index_all\",\"label\":\"No Index All Pages\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n\n    {\"name\":\"separator_3\",\"type\":\"custom_html\",\"value\":\"<h3>Posts Permalink Settings</h3>\"},\n    {\"name\":\"posts_permalink\",\"label\":\"Posts Permalink\",\"type\":\"select2_from_array\",\"options\":{\"{slug}-{id}\":\"{slug}-{id}\",\"{slug}/{id}\":\"{slug}/{id}\",\"{slug}_{id}\":\"{slug}_{id}\",\"{id}-{slug}\":\"{id}-{slug}\",\"{id}/{slug}\":\"{id}/{slug}\",\"{id}_{slug}\":\"{id}_{slug}\",\"{id}\":\"{id}\"},\"hint\":\"The word {id} will be replaced by the Post ID, and {slug} by the Post title\'s slug.<br>e.g. http://www.domain.com/{slug}/{id}\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"posts_permalink_ext\",\"label\":\"Posts Permalink Extension\",\"type\":\"select2_from_array\",\"options\":{\"\":\"&nbsp;\",\".html\":\".html\",\".htm\":\".htm\",\".php\":\".php\",\".aspx\":\".aspx\"},\"hint\":\"You can add an extension for the Posts Permalink (Optional).<br>e.g. http://www.domain.com/{slug}/{id}.html\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}}\n]', 0, 14, 15, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(8, 'upload', 'Upload', NULL, 'Upload Settings', '[\n    {\"name\":\"image_types\",\"label\":\"Upload Image Types\",\"type\":\"text\",\"hint\":\"Upload image types (ex: jpg,jpeg,gif,png,...)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"file_types\",\"label\":\"Upload File Types\",\"type\":\"text\",\"hint\":\"Upload file types (ex: pdf,doc,docx,odt,...)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"max_file_size\",\"label\":\"Upload Max File Size\",\"type\":\"text\",\"hint\":\"Upload Max File Size (in KB)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<hr>\"}\n]', 0, 16, 17, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(9, 'geo_location', 'Geo Location', NULL, 'Geo Location Configuration', '[\n    {\"name\":\"geolocation_activation\",\"label\":\"Enable Geolocation\",\"type\":\"checkbox\",\"hint\":\"Before enabling this option you need to download the Maxmind database by following the documentation <a href=\\\"http://support.bedigit.com/help-center/articles/14/enable-the-geo-location\\\" target=\\\"_blank\\\">here</a>.\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\",\"style\":\"margin-top: 20px;\"}},\n    {\"name\":\"default_country_code\",\"label\":\"Default Country\",\"type\":\"select2\",\"attribute\":\"asciiname\",\"model\":\"\\\\App\\\\Models\\\\Country\",\"allows_null\":\"true\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"separator_clear_1\",\"type\":\"custom_html\",\"value\":\"<div style=\\\"clear: both;\\\"></div>\"},\n    {\"name\":\"country_flag_activation\",\"label\":\"Show country flag on top\",\"type\":\"checkbox\",\"hint\":\"<br>\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"local_currency_packages_activation\",\"label\":\"Allow users to pay the Packages in their country currency\",\"type\":\"checkbox\",\"hint\":\"You have to create a list of <a href=\\\"#admin#/package\\\" target=\\\"_blank\\\">Packages</a> per currency (using currencies of activated countries) to allow users to pay the Packages in their local currency.<br>NOTE: By unchecking this field all the lists of Packages (without currency matching) will be shown during the payment process.\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}}\n]', 0, 18, 19, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(10, 'security', 'Security', NULL, 'Security Options', '[\n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Login</h3>\"},\n    {\"name\":\"login_open_in_modal\",\"label\":\"Open In Modal\",\"type\":\"checkbox\",\"hint\":\"Open the top login link into Modal\"},\n    {\"name\":\"login_max_attempts\",\"label\":\"Max Attempts\",\"type\":\"select2_from_array\",\"options\":{\"30\":\"30\",\"20\":\"20\",\"10\":\"10\",\"5\":\"5\",\"4\":\"4\",\"3\":\"3\",\"2\":\"2\",\"1\":\"1\"},\"hint\":\"The maximum number of attempts to allow\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"login_decay_minutes\",\"label\":\"Decay Minutes\",\"type\":\"select2_from_array\",\"options\":{\"1440\":\"1440\",\"720\":\"720\",\"60\":\"60\",\"30\":\"30\",\"20\":\"20\",\"15\":\"15\",\"10\":\"10\",\"5\":\"5\",\"4\":\"4\",\"3\":\"3\",\"2\":\"2\",\"1\":\"1\"},\"hint\":\"The number of minutes to throttle for\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>reCAPTCHA</h3>\"},\n    {\"name\":\"recaptcha_activation\",\"label\":\"Enable reCAPTCHA\",\"type\":\"checkbox\",\"hint\":\"Get reCAPTCHA site keys <a href=\\\"https://www.google.com/recaptcha/\\\" target=\\\"_blank\\\">here</a>.\"},\n    {\"name\":\"recaptcha_public_key\",\"label\":\"reCAPTCHA Public Key\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"recaptcha_private_key\",\"label\":\"reCAPTCHA Private Key\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}}\n]', 0, 20, 21, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(11, 'social_auth', 'Social Login', NULL, 'Social Network Login', '[\n    {\"name\":\"social_login_activation\",\"label\":\"Enable Social Login\",\"type\":\"checkbox\",\"hint\":\"Allow users to connect via social networks\"},\n    \n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Facebook</h3>\"},\n    {\"name\":\"separator_1_1\",\"type\":\"custom_html\",\"value\":\"Create a Facebook App <a href=\\\"https://developers.facebook.com/\\\" target=\\\"_blank\\\">here</a>. The \\\"OAuth redirect URI\\\" is: (http:// or https://) yoursite.com<strong>/auth/facebook/callback</strong> or www.yoursite.com<strong>/auth/facebook/callback</strong>\"},\n    {\"name\":\"facebook_client_id\",\"label\":\"Facebook Client ID\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"facebook_client_secret\",\"label\":\"Facebook Client Secret\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>Google+</h3>\"},\n    {\"name\":\"separator_2_1\",\"type\":\"custom_html\",\"value\":\"Create a Google+ App <a href=\\\"https://console.developers.google.com/\\\" target=\\\"_blank\\\">here</a>. The \\\"Authorized Redirect URI\\\" is: (http:// or https://) yoursite.com<strong>/auth/google/callback</strong> or www.yoursite.com<strong>/auth/google/callback</strong>\"},\n    {\"name\":\"google_client_id\",\"label\":\"Google Client ID\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"google_client_secret\",\"label\":\"Google Client Secret\",\"type\":\"text\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}}\n]', 0, 22, 23, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(12, 'social_link', 'Social Network', NULL, 'Social Network Profiles', '[\n    {\"name\":\"facebook_page_url\",\"label\":\"Facebook Page URL\",\"type\":\"text\"},\n    {\"name\":\"twitter_url\",\"label\":\"Twitter URL\",\"type\":\"text\"},\n    {\"name\":\"google_plus_url\",\"label\":\"Google+ URL\",\"type\":\"text\"},\n    {\"name\":\"linkedin_url\",\"label\":\"LinkedIn URL\",\"type\":\"text\"},\n    {\"name\":\"pinterest_url\",\"label\":\"Pinterest URL\",\"type\":\"text\"}\n]', 0, 24, 25, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(13, 'other', 'Others', NULL, 'Other Options', '[\n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Tips Info</h3>\"},\n    {\"name\":\"show_tips_messages\",\"label\":\"Show Tips Notification Messages\",\"type\":\"checkbox\",\"hint\":\"e.g. SITENAME is also available in your country: COUNTRY. Starting good deals here now!<br>Login for faster access to the best deals. Click here if you don\'t have an account.\"},\n    \n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>Google Maps</h3>\"},\n    {\"name\":\"googlemaps_key\",\"label\":\"Google Maps Key\",\"type\":\"text\"},\n    \n    {\"name\":\"separator_3\",\"type\":\"custom_html\",\"value\":\"<h3>Number Format</h3>\"},\n    {\"name\":\"decimals_superscript\",\"label\":\"Decimals Superscript\",\"type\":\"checkbox\"},\n    \n    {\"name\":\"separator_4\",\"type\":\"custom_html\",\"value\":\"<h3>Optimization</h3>\"},\n    {\"name\":\"cookie_expiration\",\"label\":\"Cookie Expiration Time\",\"type\":\"text\",\"hint\":\"Cookie Expiration Time (in secondes)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"cache_expiration\",\"label\":\"Cache Expiration Time\",\"type\":\"text\",\"hint\":\"Cache Expiration Time (in minutes)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"minify_html_activation\",\"label\":\"Enable HTML Minify\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"http_cache_activation\",\"label\":\"Enable HTTP Cache\",\"type\":\"checkbox\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n\n    {\"name\":\"separator_5\",\"type\":\"custom_html\",\"value\":\"<h3>JavaScript (in the &lt;head&gt; section)</h3>\"},\n    {\"name\":\"js_code\",\"label\":\"JavaScript Code\",\"type\":\"textarea\",\"attributes\":{\"rows\":\"10\"},\"hint\":\"Paste your JavaScript code here to put it in the &lt;head&gt; section of HTML pages.\"}\n]', 0, 26, 27, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(14, 'cron', 'Cron', NULL, 'Cron Job', '[\n    {\"name\":\"separator_1\",\"type\":\"custom_html\",\"value\":\"<h3>Cron</h3>\"},\n    {\"name\":\"separator_1_1\",\"type\":\"custom_html\",\"value\":\"You need to add \'/usr/bin/php -q /path/to/your/website/artisan ads:clean\' in your Cron Job tab. Click <a href=\\\"http://support.bedigit.com/help-center/articles/19/configuring-the-cron-job\\\" target=\\\"_blank\\\">here</a> for more information.\"},\n    {\"name\":\"unactivated_posts_expiration\",\"label\":\"Unactivated Ads Expiration\",\"type\":\"text\", \"hint\":\"In days (Delete the unactivated ads after this expiration)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"activated_posts_expiration\",\"label\":\"Activated Ads Expiration\",\"type\":\"text\", \"hint\":\"In days (Archive the activated ads after this expiration)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    {\"name\":\"archived_posts_expiration\",\"label\":\"Archived Ads Expiration\",\"type\":\"text\", \"hint\":\"In days (Delete the archived ads after this expiration)\",\"wrapperAttributes\":{\"class\":\"form-group col-md-6\"}},\n    \n    {\"name\":\"separator_2\",\"type\":\"custom_html\",\"value\":\"<h3>Test</h3>\"},\n    {\"name\":\"separator_2_1\",\"type\":\"custom_html\",\"value\":\"You can run manually the Cron Job command by clicking the button below. <br><strong>CAUTION:</strong><br>- All the expirated paid ads (also called: premium or featured ads) will become regular ads (also called: normal or free ads).<br>&nbsp;&nbsp;You have to setup the premium ads expiration duration from: Setup -> Packages.<br>- All expirated active regular ads will be archived. <br>- All expirated inactive regular ads will be deleted.<br>- All expirated archived regular ads will be deleted.\"},\n    {\"name\":\"separator_2_2\",\"type\":\"custom_html\",\"value\":\"<a href=\\\"#admin#/test_cron\\\" class=\\\"btn btn-primary\\\"><i class=\\\"fa fa-play-circle-o\\\"></i> Run Manually</a>\"}\n]', 0, 28, 29, 1, 1, NULL, NULL);
INSERT INTO `<<prefix>>settings` (`id`, `key`, `name`, `value`, `description`, `field`, `parent_id`, `lft`, `rgt`, `depth`, `active`, `created_at`, `updated_at`) VALUES(15, 'footer', 'Footer', NULL, 'Pages Footer', '[\n    {\"name\":\"show_payment_plugins_logos\",\"label\":\"Show Payment Plugins Logos\",\"type\":\"checkbox\"},\n    {\"name\":\"show_powered_by\",\"label\":\"Show Powered by Info\",\"type\":\"checkbox\"},\n    {\"name\":\"powered_by_info\",\"label\":\"Powered by\",\"type\":\"text\"},\n    {\"name\":\"tracking_code\",\"label\":\"Tracking Code\",\"type\":\"textarea\",\"attributes\":{\"rows\":\"15\"},\"hint\":\"Paste your Google Analytics (or other) tracking code here. This will be added into the footer.\"}\n]', 0, 30, 31, 1, 1, NULL, NULL);


-- time_zones
TRUNCATE TABLE `<<prefix>>time_zones`;

INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(1, 'CI', 'Africa/Abidjan', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(2, 'GH', 'Africa/Accra', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(3, 'ET', 'Africa/Addis_Ababa', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(4, 'DZ', 'Africa/Algiers', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(5, 'ER', 'Africa/Asmara', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(6, 'ML', 'Africa/Bamako', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(7, 'CF', 'Africa/Bangui', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(8, 'GM', 'Africa/Banjul', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(9, 'GW', 'Africa/Bissau', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(10, 'MW', 'Africa/Blantyre', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(11, 'CG', 'Africa/Brazzaville', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(12, 'BI', 'Africa/Bujumbura', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(13, 'EG', 'Africa/Cairo', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(14, 'MA', 'Africa/Casablanca', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(15, 'ES', 'Africa/Ceuta', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(16, 'GN', 'Africa/Conakry', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(17, 'SN', 'Africa/Dakar', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(18, 'TZ', 'Africa/Dar_es_Salaam', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(19, 'DJ', 'Africa/Djibouti', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(20, 'CM', 'Africa/Douala', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(21, 'EH', 'Africa/El_Aaiun', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(22, 'SL', 'Africa/Freetown', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(23, 'BW', 'Africa/Gaborone', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(24, 'ZW', 'Africa/Harare', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(25, 'ZA', 'Africa/Johannesburg', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(26, 'SS', 'Africa/Juba', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(27, 'UG', 'Africa/Kampala', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(28, 'SD', 'Africa/Khartoum', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(29, 'RW', 'Africa/Kigali', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(30, 'CD', 'Africa/Kinshasa', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(31, 'NG', 'Africa/Lagos', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(32, 'GA', 'Africa/Libreville', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(33, 'TG', 'Africa/Lome', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(34, 'AO', 'Africa/Luanda', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(35, 'CD', 'Africa/Lubumbashi', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(36, 'ZM', 'Africa/Lusaka', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(37, 'GQ', 'Africa/Malabo', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(38, 'MZ', 'Africa/Maputo', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(39, 'LS', 'Africa/Maseru', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(40, 'SZ', 'Africa/Mbabane', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(41, 'SO', 'Africa/Mogadishu', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(42, 'LR', 'Africa/Monrovia', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(43, 'KE', 'Africa/Nairobi', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(44, 'TD', 'Africa/Ndjamena', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(45, 'NE', 'Africa/Niamey', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(46, 'MR', 'Africa/Nouakchott', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(47, 'BF', 'Africa/Ouagadougou', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(48, 'BJ', 'Africa/Porto-Novo', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(49, 'ST', 'Africa/Sao_Tome', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(50, 'LY', 'Africa/Tripoli', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(51, 'TN', 'Africa/Tunis', 1, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(52, 'NA', 'Africa/Windhoek', 2, 1, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(53, 'US', 'America/Adak', -10, -9, -10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(54, 'US', 'America/Anchorage', -9, -8, -9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(55, 'AI', 'America/Anguilla', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(56, 'AG', 'America/Antigua', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(57, 'BR', 'America/Araguaina', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(58, 'AR', 'America/Argentina/Buenos_Aires', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(59, 'AR', 'America/Argentina/Catamarca', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(60, 'AR', 'America/Argentina/Cordoba', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(61, 'AR', 'America/Argentina/Jujuy', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(62, 'AR', 'America/Argentina/La_Rioja', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(63, 'AR', 'America/Argentina/Mendoza', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(64, 'AR', 'America/Argentina/Rio_Gallegos', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(65, 'AR', 'America/Argentina/Salta', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(66, 'AR', 'America/Argentina/San_Juan', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(67, 'AR', 'America/Argentina/San_Luis', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(68, 'AR', 'America/Argentina/Tucuman', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(69, 'AR', 'America/Argentina/Ushuaia', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(70, 'AW', 'America/Aruba', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(71, 'PY', 'America/Asuncion', -3, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(72, 'CA', 'America/Atikokan', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(73, 'BR', 'America/Bahia', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(74, 'MX', 'America/Bahia_Banderas', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(75, 'BB', 'America/Barbados', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(76, 'BR', 'America/Belem', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(77, 'BZ', 'America/Belize', -6, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(78, 'CA', 'America/Blanc-Sablon', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(79, 'BR', 'America/Boa_Vista', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(80, 'CO', 'America/Bogota', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(81, 'US', 'America/Boise', -7, -6, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(82, 'CA', 'America/Cambridge_Bay', -7, -6, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(83, 'BR', 'America/Campo_Grande', -3, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(84, 'MX', 'America/Cancun', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(85, 'VE', 'America/Caracas', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(86, 'GF', 'America/Cayenne', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(87, 'KY', 'America/Cayman', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(88, 'US', 'America/Chicago', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(89, 'MX', 'America/Chihuahua', -7, -6, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(90, 'CR', 'America/Costa_Rica', -6, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(91, 'CA', 'America/Creston', -7, -7, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(92, 'BR', 'America/Cuiaba', -3, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(93, 'CW', 'America/Curacao', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(94, 'GL', 'America/Danmarkshavn', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(95, 'CA', 'America/Dawson', -8, -7, -8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(96, 'CA', 'America/Dawson_Creek', -7, -7, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(97, 'US', 'America/Denver', -7, -6, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(98, 'US', 'America/Detroit', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(99, 'DM', 'America/Dominica', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(100, 'CA', 'America/Edmonton', -7, -6, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(101, 'BR', 'America/Eirunepe', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(102, 'SV', 'America/El_Salvador', -6, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(103, 'CA', 'America/Fort_Nelson', -7, -7, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(104, 'BR', 'America/Fortaleza', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(105, 'CA', 'America/Glace_Bay', -4, -3, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(106, 'GL', 'America/Godthab', -3, -2, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(107, 'CA', 'America/Goose_Bay', -4, -3, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(108, 'TC', 'America/Grand_Turk', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(109, 'GD', 'America/Grenada', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(110, 'GP', 'America/Guadeloupe', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(111, 'GT', 'America/Guatemala', -6, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(112, 'EC', 'America/Guayaquil', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(113, 'GY', 'America/Guyana', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(114, 'CA', 'America/Halifax', -4, -3, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(115, 'CU', 'America/Havana', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(116, 'MX', 'America/Hermosillo', -7, -7, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(117, 'US', 'America/Indiana/Indianapolis', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(118, 'US', 'America/Indiana/Knox', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(119, 'US', 'America/Indiana/Marengo', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(120, 'US', 'America/Indiana/Petersburg', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(121, 'US', 'America/Indiana/Tell_City', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(122, 'US', 'America/Indiana/Vevay', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(123, 'US', 'America/Indiana/Vincennes', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(124, 'US', 'America/Indiana/Winamac', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(125, 'CA', 'America/Inuvik', -7, -6, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(126, 'CA', 'America/Iqaluit', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(127, 'JM', 'America/Jamaica', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(128, 'US', 'America/Juneau', -9, -8, -9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(129, 'US', 'America/Kentucky/Louisville', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(130, 'US', 'America/Kentucky/Monticello', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(131, 'BQ', 'America/Kralendijk', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(132, 'BO', 'America/La_Paz', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(133, 'PE', 'America/Lima', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(134, 'US', 'America/Los_Angeles', -8, -7, -8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(135, 'SX', 'America/Lower_Princes', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(136, 'BR', 'America/Maceio', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(137, 'NI', 'America/Managua', -6, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(138, 'BR', 'America/Manaus', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(139, 'MF', 'America/Marigot', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(140, 'MQ', 'America/Martinique', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(141, 'MX', 'America/Matamoros', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(142, 'MX', 'America/Mazatlan', -7, -6, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(143, 'US', 'America/Menominee', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(144, 'MX', 'America/Merida', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(145, 'US', 'America/Metlakatla', -9, -8, -9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(146, 'MX', 'America/Mexico_City', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(147, 'PM', 'America/Miquelon', -3, -2, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(148, 'CA', 'America/Moncton', -4, -3, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(149, 'MX', 'America/Monterrey', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(150, 'UY', 'America/Montevideo', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(151, 'MS', 'America/Montserrat', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(152, 'BS', 'America/Nassau', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(153, 'US', 'America/New_York', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(154, 'CA', 'America/Nipigon', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(155, 'US', 'America/Nome', -9, -8, -9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(156, 'BR', 'America/Noronha', -2, -2, -2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(157, 'US', 'America/North_Dakota/Beulah', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(158, 'US', 'America/North_Dakota/Center', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(159, 'US', 'America/North_Dakota/New_Salem', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(160, 'MX', 'America/Ojinaga', -7, -6, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(161, 'PA', 'America/Panama', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(162, 'CA', 'America/Pangnirtung', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(163, 'SR', 'America/Paramaribo', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(164, 'US', 'America/Phoenix', -7, -7, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(165, 'HT', 'America/Port-au-Prince', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(166, 'TT', 'America/Port_of_Spain', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(167, 'BR', 'America/Porto_Velho', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(168, 'PR', 'America/Puerto_Rico', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(169, 'CL', 'America/Punta_Arenas', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(170, 'CA', 'America/Rainy_River', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(171, 'CA', 'America/Rankin_Inlet', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(172, 'BR', 'America/Recife', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(173, 'CA', 'America/Regina', -6, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(174, 'CA', 'America/Resolute', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(175, 'BR', 'America/Rio_Branco', -5, -5, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(176, 'BR', 'America/Santarem', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(177, 'CL', 'America/Santiago', -3, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(178, 'DO', 'America/Santo_Domingo', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(179, 'BR', 'America/Sao_Paulo', -2, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(180, 'GL', 'America/Scoresbysund', -1, 0, -1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(181, 'US', 'America/Sitka', -9, -8, -9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(182, 'BL', 'America/St_Barthelemy', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(183, 'CA', 'America/St_Johns', -3.5, -2.5, -3.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(184, 'KN', 'America/St_Kitts', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(185, 'LC', 'America/St_Lucia', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(186, 'VI', 'America/St_Thomas', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(187, 'VC', 'America/St_Vincent', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(188, 'CA', 'America/Swift_Current', -6, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(189, 'HN', 'America/Tegucigalpa', -6, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(190, 'GL', 'America/Thule', -4, -3, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(191, 'CA', 'America/Thunder_Bay', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(192, 'MX', 'America/Tijuana', -8, -7, -8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(193, 'CA', 'America/Toronto', -5, -4, -5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(194, 'VG', 'America/Tortola', -4, -4, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(195, 'CA', 'America/Vancouver', -8, -7, -8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(196, 'CA', 'America/Whitehorse', -8, -7, -8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(197, 'CA', 'America/Winnipeg', -6, -5, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(198, 'US', 'America/Yakutat', -9, -8, -9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(199, 'CA', 'America/Yellowknife', -7, -6, -7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(200, 'AQ', 'Antarctica/Casey', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(201, 'AQ', 'Antarctica/Davis', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(202, 'AQ', 'Antarctica/DumontDUrville', 10, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(203, 'AU', 'Antarctica/Macquarie', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(204, 'AQ', 'Antarctica/Mawson', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(205, 'AQ', 'Antarctica/McMurdo', 13, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(206, 'AQ', 'Antarctica/Palmer', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(207, 'AQ', 'Antarctica/Rothera', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(208, 'AQ', 'Antarctica/Syowa', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(209, 'AQ', 'Antarctica/Troll', 0, 2, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(210, 'AQ', 'Antarctica/Vostok', 6, 6, 6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(211, 'SJ', 'Arctic/Longyearbyen', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(212, 'YE', 'Asia/Aden', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(213, 'KZ', 'Asia/Almaty', 6, 6, 6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(214, 'JO', 'Asia/Amman', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(215, 'RU', 'Asia/Anadyr', 12, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(216, 'KZ', 'Asia/Aqtau', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(217, 'KZ', 'Asia/Aqtobe', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(218, 'TM', 'Asia/Ashgabat', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(219, 'KZ', 'Asia/Atyrau', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(220, 'IQ', 'Asia/Baghdad', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(221, 'BH', 'Asia/Bahrain', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(222, 'AZ', 'Asia/Baku', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(223, 'TH', 'Asia/Bangkok', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(224, 'RU', 'Asia/Barnaul', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(225, 'LB', 'Asia/Beirut', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(226, 'KG', 'Asia/Bishkek', 6, 6, 6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(227, 'BN', 'Asia/Brunei', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(228, 'RU', 'Asia/Chita', 9, 9, 9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(229, 'MN', 'Asia/Choibalsan', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(230, 'LK', 'Asia/Colombo', 5.5, 5.5, 5.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(231, 'SY', 'Asia/Damascus', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(232, 'BD', 'Asia/Dhaka', 6, 6, 6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(233, 'TL', 'Asia/Dili', 9, 9, 9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(234, 'AE', 'Asia/Dubai', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(235, 'TJ', 'Asia/Dushanbe', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(236, 'CY', 'Asia/Famagusta', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(237, 'PS', 'Asia/Gaza', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(238, 'PS', 'Asia/Hebron', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(239, 'VN', 'Asia/Ho_Chi_Minh', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(240, 'HK', 'Asia/Hong_Kong', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(241, 'MN', 'Asia/Hovd', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(242, 'RU', 'Asia/Irkutsk', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(243, 'ID', 'Asia/Jakarta', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(244, 'ID', 'Asia/Jayapura', 9, 9, 9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(245, 'IL', 'Asia/Jerusalem', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(246, 'AF', 'Asia/Kabul', 4.5, 4.5, 4.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(247, 'RU', 'Asia/Kamchatka', 12, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(248, 'PK', 'Asia/Karachi', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(249, 'NP', 'Asia/Kathmandu', 5.75, 5.75, 5.75);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(250, 'RU', 'Asia/Khandyga', 9, 9, 9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(251, 'IN', 'Asia/Kolkata', 5.5, 5.5, 5.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(252, 'RU', 'Asia/Krasnoyarsk', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(253, 'MY', 'Asia/Kuala_Lumpur', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(254, 'MY', 'Asia/Kuching', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(255, 'KW', 'Asia/Kuwait', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(256, 'MO', 'Asia/Macau', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(257, 'RU', 'Asia/Magadan', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(258, 'ID', 'Asia/Makassar', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(259, 'PH', 'Asia/Manila', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(260, 'OM', 'Asia/Muscat', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(261, 'CY', 'Asia/Nicosia', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(262, 'RU', 'Asia/Novokuznetsk', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(263, 'RU', 'Asia/Novosibirsk', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(264, 'RU', 'Asia/Omsk', 6, 6, 6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(265, 'KZ', 'Asia/Oral', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(266, 'KH', 'Asia/Phnom_Penh', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(267, 'ID', 'Asia/Pontianak', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(268, 'KP', 'Asia/Pyongyang', 8.5, 8.5, 8.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(269, 'QA', 'Asia/Qatar', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(270, 'KZ', 'Asia/Qyzylorda', 6, 6, 6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(271, 'SA', 'Asia/Riyadh', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(272, 'RU', 'Asia/Sakhalin', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(273, 'UZ', 'Asia/Samarkand', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(274, 'KR', 'Asia/Seoul', 9, 9, 9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(275, 'CN', 'Asia/Shanghai', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(276, 'SG', 'Asia/Singapore', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(277, 'RU', 'Asia/Srednekolymsk', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(278, 'TW', 'Asia/Taipei', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(279, 'UZ', 'Asia/Tashkent', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(280, 'GE', 'Asia/Tbilisi', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(281, 'IR', 'Asia/Tehran', 3.5, 4.5, 3.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(282, 'BT', 'Asia/Thimphu', 6, 6, 6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(283, 'JP', 'Asia/Tokyo', 9, 9, 9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(284, 'RU', 'Asia/Tomsk', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(285, 'MN', 'Asia/Ulaanbaatar', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(286, 'CN', 'Asia/Urumqi', 6, 6, 6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(287, 'RU', 'Asia/Ust-Nera', 10, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(288, 'LA', 'Asia/Vientiane', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(289, 'RU', 'Asia/Vladivostok', 10, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(290, 'RU', 'Asia/Yakutsk', 9, 9, 9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(291, 'MM', 'Asia/Yangon', 6.5, 6.5, 6.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(292, 'RU', 'Asia/Yekaterinburg', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(293, 'AM', 'Asia/Yerevan', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(294, 'PT', 'Atlantic/Azores', -1, 0, -1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(295, 'BM', 'Atlantic/Bermuda', -4, -3, -4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(296, 'ES', 'Atlantic/Canary', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(297, 'CV', 'Atlantic/Cape_Verde', -1, -1, -1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(298, 'FO', 'Atlantic/Faroe', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(299, 'PT', 'Atlantic/Madeira', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(300, 'IS', 'Atlantic/Reykjavik', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(301, 'GS', 'Atlantic/South_Georgia', -2, -2, -2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(302, 'SH', 'Atlantic/St_Helena', 0, 0, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(303, 'FK', 'Atlantic/Stanley', -3, -3, -3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(304, 'AU', 'Australia/Adelaide', 10.5, 9.5, 9.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(305, 'AU', 'Australia/Brisbane', 10, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(306, 'AU', 'Australia/Broken_Hill', 10.5, 9.5, 9.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(307, 'AU', 'Australia/Currie', 11, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(308, 'AU', 'Australia/Darwin', 9.5, 9.5, 9.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(309, 'AU', 'Australia/Eucla', 8.75, 8.75, 8.75);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(310, 'AU', 'Australia/Hobart', 11, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(311, 'AU', 'Australia/Lindeman', 10, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(312, 'AU', 'Australia/Lord_Howe', 11, 10.5, 10.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(313, 'AU', 'Australia/Melbourne', 11, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(314, 'AU', 'Australia/Perth', 8, 8, 8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(315, 'AU', 'Australia/Sydney', 11, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(316, 'NL', 'Europe/Amsterdam', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(317, 'AD', 'Europe/Andorra', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(318, 'RU', 'Europe/Astrakhan', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(319, 'GR', 'Europe/Athens', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(320, 'RS', 'Europe/Belgrade', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(321, 'DE', 'Europe/Berlin', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(322, 'SK', 'Europe/Bratislava', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(323, 'BE', 'Europe/Brussels', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(324, 'RO', 'Europe/Bucharest', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(325, 'HU', 'Europe/Budapest', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(326, 'DE', 'Europe/Busingen', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(327, 'MD', 'Europe/Chisinau', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(328, 'DK', 'Europe/Copenhagen', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(329, 'IE', 'Europe/Dublin', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(330, 'GI', 'Europe/Gibraltar', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(331, 'GG', 'Europe/Guernsey', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(332, 'FI', 'Europe/Helsinki', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(333, 'IM', 'Europe/Isle_of_Man', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(334, 'TR', 'Europe/Istanbul', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(335, 'JE', 'Europe/Jersey', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(336, 'RU', 'Europe/Kaliningrad', 2, 2, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(337, 'UA', 'Europe/Kiev', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(338, 'RU', 'Europe/Kirov', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(339, 'PT', 'Europe/Lisbon', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(340, 'SI', 'Europe/Ljubljana', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(341, 'UK', 'Europe/London', 0, 1, 0);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(342, 'LU', 'Europe/Luxembourg', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(343, 'ES', 'Europe/Madrid', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(344, 'MT', 'Europe/Malta', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(345, 'AX', 'Europe/Mariehamn', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(346, 'BY', 'Europe/Minsk', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(347, 'MC', 'Europe/Monaco', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(348, 'RU', 'Europe/Moscow', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(349, 'NO', 'Europe/Oslo', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(350, 'FR', 'Europe/Paris', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(351, 'ME', 'Europe/Podgorica', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(352, 'CZ', 'Europe/Prague', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(353, 'LV', 'Europe/Riga', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(354, 'IT', 'Europe/Rome', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(355, 'RU', 'Europe/Samara', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(356, 'SM', 'Europe/San_Marino', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(357, 'BA', 'Europe/Sarajevo', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(358, 'RU', 'Europe/Saratov', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(359, 'RU', 'Europe/Simferopol', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(360, 'MK', 'Europe/Skopje', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(361, 'BG', 'Europe/Sofia', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(362, 'SE', 'Europe/Stockholm', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(363, 'EE', 'Europe/Tallinn', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(364, 'AL', 'Europe/Tirane', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(365, 'RU', 'Europe/Ulyanovsk', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(366, 'UA', 'Europe/Uzhgorod', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(367, 'LI', 'Europe/Vaduz', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(368, 'VA', 'Europe/Vatican', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(369, 'AT', 'Europe/Vienna', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(370, 'LT', 'Europe/Vilnius', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(371, 'RU', 'Europe/Volgograd', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(372, 'PL', 'Europe/Warsaw', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(373, 'HR', 'Europe/Zagreb', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(374, 'UA', 'Europe/Zaporozhye', 2, 3, 2);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(375, 'CH', 'Europe/Zurich', 1, 2, 1);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(376, 'MG', 'Indian/Antananarivo', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(377, 'IO', 'Indian/Chagos', 6, 6, 6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(378, 'CX', 'Indian/Christmas', 7, 7, 7);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(379, 'CC', 'Indian/Cocos', 6.5, 6.5, 6.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(380, 'KM', 'Indian/Comoro', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(381, 'TF', 'Indian/Kerguelen', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(382, 'SC', 'Indian/Mahe', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(383, 'MV', 'Indian/Maldives', 5, 5, 5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(384, 'MU', 'Indian/Mauritius', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(385, 'YT', 'Indian/Mayotte', 3, 3, 3);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(386, 'RE', 'Indian/Reunion', 4, 4, 4);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(387, 'WS', 'Pacific/Apia', 14, 13, 13);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(388, 'NZ', 'Pacific/Auckland', 13, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(389, 'PG', 'Pacific/Bougainville', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(390, 'NZ', 'Pacific/Chatham', 13.75, 12.75, 12.75);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(391, 'FM', 'Pacific/Chuuk', 10, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(392, 'CL', 'Pacific/Easter', -5, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(393, 'VU', 'Pacific/Efate', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(394, 'KI', 'Pacific/Enderbury', 13, 13, 13);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(395, 'TK', 'Pacific/Fakaofo', 13, 13, 13);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(396, 'FJ', 'Pacific/Fiji', 13, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(397, 'TV', 'Pacific/Funafuti', 12, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(398, 'EC', 'Pacific/Galapagos', -6, -6, -6);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(399, 'PF', 'Pacific/Gambier', -9, -9, -9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(400, 'SB', 'Pacific/Guadalcanal', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(401, 'GU', 'Pacific/Guam', 10, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(402, 'US', 'Pacific/Honolulu', -10, -10, -10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(403, 'KI', 'Pacific/Kiritimati', 14, 14, 14);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(404, 'FM', 'Pacific/Kosrae', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(405, 'MH', 'Pacific/Kwajalein', 12, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(406, 'MH', 'Pacific/Majuro', 12, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(407, 'PF', 'Pacific/Marquesas', -9.5, -9.5, -9.5);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(408, 'UM', 'Pacific/Midway', -11, -11, -11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(409, 'NR', 'Pacific/Nauru', 12, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(410, 'NU', 'Pacific/Niue', -11, -11, -11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(411, 'NF', 'Pacific/Norfolk', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(412, 'NC', 'Pacific/Noumea', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(413, 'AS', 'Pacific/Pago_Pago', -11, -11, -11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(414, 'PW', 'Pacific/Palau', 9, 9, 9);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(415, 'PN', 'Pacific/Pitcairn', -8, -8, -8);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(416, 'FM', 'Pacific/Pohnpei', 11, 11, 11);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(417, 'PG', 'Pacific/Port_Moresby', 10, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(418, 'CK', 'Pacific/Rarotonga', -10, -10, -10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(419, 'MP', 'Pacific/Saipan', 10, 10, 10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(420, 'PF', 'Pacific/Tahiti', -10, -10, -10);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(421, 'KI', 'Pacific/Tarawa', 12, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(422, 'TO', 'Pacific/Tongatapu', 14, 13, 13);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(423, 'UM', 'Pacific/Wake', 12, 12, 12);
INSERT INTO `<<prefix>>time_zones` (`id`, `country_code`, `time_zone_id`, `gmt`, `dst`, `raw`) VALUES(424, 'WF', 'Pacific/Wallis', 12, 12, 12);


-- users
ALTER TABLE `<<prefix>>users` ADD `can_be_impersonated` TINYINT(1) UNSIGNED NULL DEFAULT '1' AFTER `is_admin`;
ALTER TABLE `<<prefix>>users` ADD INDEX(`is_admin`);
ALTER TABLE `<<prefix>>users` ADD INDEX(`can_be_impersonated`);


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