Login   Register  
PHP Classes
elePHPant
Icontem

File: TimeTaMeR/TimeTaMeR.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Dennis T Kaplan  >  TimeTaMeR  >  TimeTaMeR/TimeTaMeR.sql  >  Download  
File: TimeTaMeR/TimeTaMeR.sql
Role: Auxiliary data
Content type: text/plain
Description: Database
Class: TimeTaMeR
Determine the local and Web user machine time zone
Author: By
Last change:
Date: 2007-02-15 00:06
Size: 3,908 bytes
 

Contents

Class file image Download
-- 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');