Login   Register  
PHP Classes
elePHPant
Icontem

File: gmt.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Abdul Kader  >  GMT Converter  >  gmt.sql  >  Download  
File: gmt.sql
Role: Auxiliary data
Content type: text/plain
Description: MySql table dump for gmt zones
Class: GMT Converter
Convert time between zones defined in a database
Author: By
Last change: default db removed
Date: 2009-08-01 06:07
Size: 1,815 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 29, 2009 at 09:25 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9-2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

-- --------------------------------------------------------

--
-- Table structure for table `gmt_zones`
--

CREATE TABLE IF NOT EXISTS `gmt_zones` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `gmt` varchar(6) NOT NULL DEFAULT '+00:00',
  `secondsDiff` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `gmt` (`gmt`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `gmt_zones`
--

INSERT INTO `gmt_zones` (`id`, `gmt`, `secondsDiff`) VALUES
(1, '-12:00', -43200),
(2, '-11:00', -39600),
(3, '-10:00', -36000),
(4, '-09:00', -32400),
(5, '-08:00', -28800),
(6, '-07:00', -25200),
(7, '-06:00', -21600),
(8, '-05:00', -18000),
(9, '-04:30', -12600),
(10, '-04:00', -14400),
(11, '-03:30', -9000),
(12, '-03:00', -10800),
(13, '-02:00', -7200),
(14, '-01:00', -3600),
(15, '+00:00', 0),
(16, '+01:00', 3600),
(17, '+02:00', 7200),
(18, '+03:00', 10800),
(19, '+03:30', 12600),
(20, '+04:00', 14400),
(21, '+04:30', 16200),
(22, '+05:00', 18000),
(23, '+05:30', 19800),
(24, '+05:45', 20700),
(25, '+06:00', 21600),
(26, '+06:30', 23400),
(27, '+07:00', 25200),
(28, '+08:00', 28800),
(29, '+09:00', 32400),
(30, '+09:30', 34200),
(31, '+10:00', 36000),
(32, '+11:00', 39600),
(33, '+12:00', 43200),
(34, '+13:00', 46800);