-- phpMyAdmin SQL Dump
-- version 2.8.2-Debian-0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 15, 2007 at 02:40 AM
-- Server version: 5.0.24
-- PHP Version: 5.1.6
--
-- Database: `PzzAzz`
--
-- --------------------------------------------------------
--
-- Table structure for table `timezone`
--
DROP TABLE IF EXISTS `timezone`;
CREATE TABLE `timezone` (
`id` int(11) NOT NULL,
`GMT` int(11) NOT NULL,
`DST` int(2) NOT NULL,
`Code` varchar(10) NOT NULL,
`Name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `timezone`
--
INSERT INTO `timezone` (`id`, `GMT`, `DST`, `Code`, `Name`) VALUES
(1, -12, 0, 'KWAT', 'International Date Line West'),
(2, -11, 0, 'NST', 'Midway Island Samoa'),
(3, -10, 0, 'AHST', 'Hawaii'),
(4, -9, 1, 'HADT', 'Alaska'),
(5, -8, 1, 'AKDT', 'Pacific Time (US & Canada); Tijuana'),
(6, -7, 0, 'MST', 'Arizona'),
(7, -7, 1, 'PDT', 'Chihuahua, La Paz, Mazatlan'),
(8, -7, 1, 'PDT', 'Mountain Time (US & Canada)'),
(9, -6, 0, 'CST', 'Central America'),
(10, -6, 1, 'MWT', 'Central Time (US & Canada)'),
(11, -6, 1, 'MWT', 'Guadalajara, Mexico City, Monterrey'),
(12, -6, 0, 'CST', 'Saskatchewan'),
(13, -5, 0, 'EST', 'Bogota, Lime, Quito'),
(14, -5, 1, 'CDT', 'Eastern Time (US & Canada)'),
(15, -5, 0, 'EST', 'Indiana (East)'),
(16, -4, 1, 'COST', 'Atlantic Time (Canada)'),
(17, -4, 0, 'AST', 'Caracas, La Paz'),
(18, -4, 1, 'COST', 'Santiago'),
(19, -4, 1, 'COST', 'Newfoundland'),
(20, -3, 1, 'ARST', 'Brasilia'),
(21, -3, 0, 'BRT', 'Buenos Aires, Georgetown'),
(22, -3, 1, 'ARST', 'Greenland'),
(23, -2, 1, 'BRST', 'Mid-Atlantic'),
(24, -1, 1, 'FNST', 'Azores'),
(25, -1, 0, 'WAT', 'Cape Verde Is.'),
(26, 0, 0, 'GMT', 'Casablanca, Monrovia'),
(27, 0, 1, 'EGST', 'Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London'),
(28, 1, 1, 'WEST', 'Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna'),
(29, 1, 1, 'WEST', 'Belgrade, Bratislava, Budapest, Ljubljana, Prague'),
(30, 1, 1, 'WEST', 'Brussels, Copenhagen, Madrid, Paris'),
(31, 1, 1, 'WEST', 'Sarajevo, Skopje, Warsaw, Zagreb'),
(32, 1, 0, 'CET', 'West Central Africa'),
(33, 2, 1, 'CEST', 'Athens, Istanbul, Minsk'),
(34, 2, 1, 'CEST', 'Bucharest'),
(35, 2, 1, 'CEST', 'Cairo'),
(36, 2, 0, 'CAT', 'Harare, Pretoria'),
(37, 2, 1, 'CEST', 'Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius'),
(38, 2, 0, 'CAT', 'Jerusalem'),
(39, 3, 1, 'EEST', 'Baghdad'),
(40, 3, 0, 'EAT', 'Kuwait, Riyadh'),
(41, 3, 1, 'EEST', 'Moscow, St. Petersburg, Volgograd'),
(42, 3, 0, 'EAT', 'Nairobi'),
(43, 4, 1, 'ADT', 'Tehran'),
(44, 4, 0, 'FORT', 'Abu Dhabi, Muscat'),
(45, 4, 1, 'ADT', 'Baku, Tbilisi, Yerevan'),
(46, 5, 0, 'ALMT', 'Kabul'),
(47, 5, 1, 'AQTST', 'Ekaterinburg'),
(48, 5, 0, 'ALMT', 'Islamabad, Karachi, Tashkent'),
(49, 6, 0, 'MAWT', 'Chennai, Kolkata, Mumbai, New Delhi'),
(50, 6, 0, 'MAWT', 'Kathmandu'),
(51, 6, 1, 'SHEST', 'Almaty, Novosibirsk'),
(52, 6, 0, 'MAWT', 'Astana, Dhaka'),
(53, 6, 0, 'MAWT', 'Sri Jayawardenepura'),
(54, 7, 0, 'DAVT', 'Rangoon'),
(55, 7, 0, 'DAVT', 'Bangkok, Hanoi, Jakarta'),
(56, 7, 1, 'ALMST', 'Krasnoyarsk'),
(57, 8, 0, 'WST', 'Beijing, Chongging, Hong Kong, Urumgi'),
(58, 8, 1, 'HOVST', 'Irkutsk, Ulaan Bataar'),
(59, 8, 0, 'WST', 'Kuala Lumpur, Singapore'),
(60, 8, 0, 'WST', 'Perth'),
(61, 8, 0, 'WST', 'Taipei'),
(62, 9, 0, 'CHOT', 'Osaka, Sapporo, Tokyo'),
(63, 9, 0, 'CHOT', 'Seoul'),
(64, 9, 1, 'CDT', 'Yakutsk'),
(65, 10, 1, 'CHOST', 'Adelaide'),
(66, 10, 0, 'PMT', 'Darwin'),
(67, 10, 0, 'PMT', 'Brisbane'),
(68, 10, 1, 'CHOST', 'Canberra, Melbourne, Sydney'),
(69, 10, 0, 'PMT', 'Guam, Port Moresby'),
(70, 10, 1, 'CHOST', 'Hobart'),
(71, 10, 1, 'CHOST', 'Vladivostok'),
(72, 11, 0, 'ANAT', 'Magadan, Solomon Is., New Caledonia'),
(73, 12, 1, 'ANAST', 'Auckland, Wellington'),
(74, 12, 0, 'NZST', 'Figi, Kamchatka, Marshall Is.'),
(75, 13, 0, 'ANAT', 'Nuku''alofa');
|