DROP TABLE IF EXISTS `tbltimezones`;

CREATE TABLE `tbltimezones` (
  `id` int(11) NOT NULL auto_increment,
  `timezone_name` varchar(250) default NULL,
  `offset` double(11,1) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

/*Data for the table `tbltimezones` */

insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (1,'Hawaii-Aleutian Standard Time[UTC -10:00]',-10);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (2,'Alaska Standard Time[UTC -09:00]',-9);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (3,'Pacific Standard Time (USA)(PST)[UTC -08:00]',-8);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (4,'Mountain Standard Time (USA)(MST)[UTC -07:00]',-7);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (5,'Central Standard Time (USA)(CST)[UTC -06:00]',-6);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (6,'Eastern Standard Time (USA)(EST)[UTC -05:00]',-5);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (7,'Atlantic Standard Time[UTC -04:00]',-4);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (8,'Newfoundland Standard Time[UTC -03:30]',-3.5);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (9,'Greenwich Mean Time/Western European Time[UTC 00:00]',0);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (10,'Central European Time(CET)[UTC +01:00]',1);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (11,'Eastern European Time[UTC +02:00]',2);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (12,'South African Standard Time[UTC +02:00]',2);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (13,'Moscow Time[UTC +03:00]',3);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (14,'Pakistan Standard Time[UTC +05:00]',5);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (15,'Indian Standard Time[UTC +05:30]',5.5);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (16,'Indonesian Western Standard Time[UTC +07:00]',7);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (17,'Singapore Standard Time[UTC +08:00]',8);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (18,'Hong Kong Time[UTC +08:00]',8);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (19,'Australian Western Standard Time[UTC +08:00]',8);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (20,'Chinese Standard Time[UTC +08:00]',8);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (21,'Malaysian Standard Time[UTC +08:00]',8);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (22,'Philippine Standard Time[UTC +08:00]',8);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (23,'Japan Standard Time[UTC +09:00]',9);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (24,'Korea Standard Time[UTC +09:00]',9);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (25,'Australian Western Standard Time[UTC +09:00]',9);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (26,'Australian Central Standard Time[UTC +09:30]',9.5);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (27,'Australian Eastern Standard Time[UTC +10:00]',10);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (28,'Chamorro Standard Time (USA) Guam[UTC +10:00]',10);
insert into `tbltimezones` (`id`,`timezone_name`,`offset`) values (29,'New Zealand Standard Time[UTC +12:00]',12);