--
-- Seo Panel 3.6.0 changes
--
--
-- Table structure for table `timezone`
--

UPDATE searchengines SET regex = '<li.*?<h2><a.*?href="(.*?)".*?>(.*?)<\\/a><\\/h2>.*?<p.*?>(.*?)<\\/p>' WHERE url like '%bing.com%';

DROP TABLE IF EXISTS `timezone`;
CREATE TABLE IF NOT EXISTS `timezone` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timezone_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `timezone_label` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `gmt_diff` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '+00.00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=91 ;

--
-- Dumping data for table `timezone`
--

INSERT INTO `timezone` (`id`, `timezone_name`, `timezone_label`, `gmt_diff`) VALUES
(1, 'Pacific/Midway', '(GMT-11:00) Midway Island, Samoa', '-11:00'),
(2, 'America/Adak', '(GMT-10:00) Hawaii-Aleutian', '-10:00'),
(3, 'Etc/GMT+10', '(GMT-10:00) Hawaii', '-10:00'),
(4, 'Pacific/Marquesas', '(GMT-09:30) Marquesas Islands', '-09:30'),
(5, 'Pacific/Gambier', '(GMT-09:00) Gambier Islands', '-09:00'),
(6, 'America/Anchorage', '(GMT-09:00) Alaska', '-09:00'),
(7, 'America/Ensenada', '(GMT-08:00) Tijuana, Baja California', '-08:00'),
(8, 'Etc/GMT+8', '(GMT-08:00) Pitcairn Islands', '-08:00'),
(9, 'America/Los_Angeles', '(GMT-08:00) Pacific Time (US & Canada)', '-08:00'),
(10, 'America/Denver', '(GMT-07:00) Mountain Time (US & Canada)', '-07:00'),
(11, 'America/Chihuahua', '(GMT-07:00) Chihuahua, La Paz, Mazatlan', '-07:00'),
(12, 'America/Dawson_Creek', '(GMT-07:00) Arizona', '-07:00'),
(13, 'America/Belize', '(GMT-06:00) Saskatchewan, Central America', '-06:00'),
(14, 'America/Cancun', '(GMT-06:00) Guadalajara, Mexico City, Monterrey', '-06:00'),
(15, 'Chile/EasterIsland', '(GMT-06:00) Easter Island', '-06:00'),
(16, 'America/Chicago', '(GMT-06:00) Central Time (US & Canada)', '-06:00'),
(17, 'America/New_York', '(GMT-05:00) Eastern Time (US & Canada)', '-05:00'),
(18, 'America/Havana', '(GMT-05:00) Cuba', '-05:00'),
(19, 'America/Bogota', '(GMT-05:00) Bogota, Lima, Quito, Rio Branco', '-05:00'),
(20, 'America/Caracas', '(GMT-04:30) Caracas', '-04:30'),
(21, 'America/Santiago', '(GMT-04:00) Santiago', '-04:00'),
(22, 'America/La_Paz', '(GMT-04:00) La Paz', '-04:00'),
(23, 'Atlantic/Stanley', '(GMT-04:00) Faukland Islands', '-04:00'),
(24, 'America/Campo_Grande', '(GMT-04:00) Brazil', '-04:00'),
(25, 'America/Goose_Bay', '(GMT-04:00) Atlantic Time (Goose Bay)', '-04:00'),
(26, 'America/Glace_Bay', '(GMT-04:00) Atlantic Time (Canada)', '-04:00'),
(27, 'America/St_Johns', '(GMT-03:30) Newfoundland', '-03:30'),
(28, 'America/Araguaina', '(GMT-03:00) UTC-3', '-03:00'),
(29, 'America/Montevideo', '(GMT-03:00) Montevideo', '-03:00'),
(30, 'America/Miquelon', '(GMT-03:00) Miquelon, St. Pierre', '-03:00'),
(31, 'America/Godthab', '(GMT-03:00) Greenland', '-03:00'),
(32, 'America/Argentina/Buenos_Aires', '(GMT-03:00) Buenos Aires', '-03:00'),
(33, 'America/Sao_Paulo', '(GMT-03:00) Brasilia', '-03:00'),
(34, 'America/Noronha', '(GMT-02:00) Mid-Atlantic', '-02:00'),
(35, 'Atlantic/Cape_Verde', '(GMT-01:00) Cape Verde Is.', '-01:00'),
(36, 'Atlantic/Azores', '(GMT-01:00) Azores', '-01:00'),
(37, 'Europe/Belfast', '(GMT) Greenwich Mean Time : Belfast', '+00:00'),
(38, 'Europe/Dublin', '(GMT) Greenwich Mean Time : Dublin', '+00:00'),
(39, 'Europe/Lisbon', '(GMT) Greenwich Mean Time : Lisbon', '+00:00'),
(40, 'Europe/London', '(GMT) Greenwich Mean Time : London', '+00:00'),
(41, 'Africa/Abidjan', '(GMT) Monrovia, Reykjavik', '+00:00'),
(42, 'Europe/Berlin', '(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna', '+01:00'),
(43, 'Europe/Belgrade', '(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague', '+01:00'),
(44, 'Europe/Brussels', '(GMT+01:00) Brussels, Copenhagen, Madrid, Paris', '+01:00'),
(45, 'Africa/Algiers', '(GMT+01:00) West Central Africa', '+01:00'),
(46, 'Africa/Windhoek', '(GMT+01:00) Windhoek', '+01:00'),
(47, 'Asia/Beirut', '(GMT+02:00) Beirut', '+02:00'),
(48, 'Africa/Cairo', '(GMT+02:00) Cairo', '+02:00'),
(49, 'Asia/Gaza', '(GMT+02:00) Gaza', '+02:00'),
(50, 'Africa/Blantyre', '(GMT+02:00) Harare, Pretoria', '+02:00'),
(51, 'Asia/Jerusalem', '(GMT+02:00) Jerusalem', '+02:00'),
(52, 'Europe/Minsk', '(GMT+02:00) Minsk', '+02:00'),
(53, 'Asia/Damascus', '(GMT+02:00) Syria', '+02:00'),
(54, 'Europe/Moscow', '(GMT+03:00) Moscow, St. Petersburg, Volgograd', '+03:00'),
(55, 'Africa/Addis_Ababa', '(GMT+03:00) Nairobi', '+03:00'),
(56, 'Asia/Tehran', '(GMT+03:30) Tehran', '+03:30'),
(57, 'Asia/Dubai', '(GMT+04:00) Abu Dhabi, Muscat', '+04:00'),
(58, 'Asia/Yerevan', '(GMT+04:00) Yerevan', '+04:00'),
(59, 'Asia/Kabul', '(GMT+04:30) Kabul', '+04:30'),
(60, 'Asia/Yekaterinburg', '(GMT+05:00) Ekaterinburg', '+05:00'),
(61, 'Asia/Tashkent', '(GMT+05:00) Tashkent', '+05:00'),
(62, 'Asia/Kolkata', '(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi', '+05:30'),
(63, 'Asia/Katmandu', '(GMT+05:45) Kathmandu', '+05:45'),
(64, 'Asia/Dhaka', '(GMT+06:00) Astana, Dhaka', '+06:00'),
(65, 'Asia/Novosibirsk', '(GMT+06:00) Novosibirsk', '+06:00'),
(66, 'Asia/Rangoon', '(GMT+06:30) Yangon (Rangoon)', '+06:30'),
(67, 'Asia/Bangkok', '(GMT+07:00) Bangkok, Hanoi, Jakarta', '+07:00'),
(68, 'Asia/Krasnoyarsk', '(GMT+07:00) Krasnoyarsk', '+07:00'),
(69, 'Asia/Hong_Kong', '(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi', '+08:00'),
(70, 'Asia/Irkutsk', '(GMT+08:00) Irkutsk, Ulaan Bataar', '+08:00'),
(71, 'Australia/Perth', '(GMT+08:00) Perth', '+08:00'),
(72, 'Australia/Eucla', '(GMT+08:45) Eucla', '+08:45'),
(73, 'Asia/Tokyo', '(GMT+09:00) Osaka, Sapporo, Tokyo', '+09:00'),
(74, 'Asia/Seoul', '(GMT+09:00) Seoul', '+09:00'),
(75, 'Asia/Yakutsk', '(GMT+09:00) Yakutsk', '+09:00'),
(76, 'Australia/Adelaide', '(GMT+09:30) Adelaide', '+09:30'),
(77, 'Australia/Darwin', '(GMT+09:30) Darwin', '+09:30'),
(78, 'Australia/Brisbane', '(GMT+10:00) Brisbane', '+10:00'),
(79, 'Australia/Hobart', '(GMT+10:00) Hobart', '+10:00'),
(80, 'Asia/Vladivostok', '(GMT+10:00) Vladivostok', '+10:00'),
(81, 'Australia/Lord_Howe', '(GMT+10:30) Lord Howe Island', '+10:30'),
(82, 'Etc/GMT-11', '(GMT+11:00) Solomon Is., New Caledonia', '+11:00'),
(83, 'Asia/Magadan', '(GMT+11:00) Magadan', '+11:00'),
(84, 'Pacific/Norfolk', '(GMT+11:30) Norfolk Island', '+11:30'),
(85, 'Asia/Anadyr', '(GMT+12:00) Anadyr, Kamchatka', '+12:00'),
(86, 'Pacific/Auckland', '(GMT+12:00) Auckland, Wellington', '+12:00'),
(87, 'Etc/GMT-12', '(GMT+12:00) Fiji, Kamchatka, Marshall Is.', '+12:00'),
(88, 'Pacific/Chatham', '(GMT+12:45) Chatham Islands', '+12:45'),
(89, 'Pacific/Tongatapu', '(GMT+13:00) Nuku''alofa', '+13:00'),
(90, 'Pacific/Kiritimati', '(GMT+14:00) Kiritimati', '+14:00');
