p1juNUwv

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : SANDBOX FA
5Source Server Version : 50154
6Source Host           : freightaccess.com:3306
7Source Database       : sandbox_main
8
9Target Server Type    : MYSQL
10Target Server Version : 50154
11File Encoding         : 65001
12
13Date: 2011-03-14 09:19:10
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17-- ----------------------------
18-- Table structure for `timezones`
19-- ----------------------------
20DROP TABLE IF EXISTS `timezones`;
21CREATE TABLE `timezones` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `GMT` varchar(6) NOT NULL,
24  `timezone_gmt` varchar(75) DEFAULT NULL,
25  `timezone` varchar(75) DEFAULT NULL,
26  `zone` varchar(4) DEFAULT NULL,
27  `military` varchar(12) DEFAULT NULL,
28  `DST` tinyint(4) NOT NULL,
29  `name` varchar(75) NOT NULL,
30  PRIMARY KEY (`id`),
31  UNIQUE KEY `GMT` (`GMT`) USING BTREE
32) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
33
34-- ----------------------------
35-- Records of timezones
36-- ----------------------------
37INSERT INTO `timezones` VALUES ('1', '5.0', 'Etc/GMT+5', 'Asia/Tashkent', 'E', 'Echo', '0', '(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent');
38INSERT INTO `timezones` VALUES ('2', '4.5', 'Asia/Kabul', 'Asia/Kabul', 'D*', null, '0', '(GMT +4:30) Kabul');
39INSERT INTO `timezones` VALUES ('3', '4.0', 'Etc/GMT+4', 'Asia/Muscat', 'D', 'Delta', '0', '(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi');
40INSERT INTO `timezones` VALUES ('4', '3.5', 'Asia/Tehran', 'Asia/Tehran', 'C*', null, '0', '(GMT +3:30) Tehran');
41INSERT INTO `timezones` VALUES ('5', '3.0', 'Etc/GMT+3', 'Asia/Baghdad', 'C', 'Charlie', '0', '(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg');
42INSERT INTO `timezones` VALUES ('6', '2.0', 'Etc/GMT+2', null, 'B', 'Bravo', '1', '(GMT +2:00) Kaliningrad, South Africa');
43INSERT INTO `timezones` VALUES ('7', '1.0', 'Etc/GMT+1', 'Europe/Paris', 'A', 'Alpha', '1', '(GMT +1:00 hour) Brussels, Copenhagen, Madrid, Paris');
44INSERT INTO `timezones` VALUES ('8', '-12.0', 'Etc/GMT-12', 'Kwajalein', 'Y', 'Yankee', '0', '(GMT -12:00) Eniwetok, Kwajalein');
45INSERT INTO `timezones` VALUES ('9', '-11.0', 'Etc/GMT-11', 'US/Samoa', 'X', 'X-ray', '0', '(GMT -11:00) Midway Island, Samoa');
46INSERT INTO `timezones` VALUES ('10', '-10.0', 'Etc/GMT-10', 'US/Hawaii', 'W', 'Whiskey', '0', '(GMT -10:00) Hawaii');
47INSERT INTO `timezones` VALUES ('11', '-9.0', 'Etc/GMT-9', 'US/Alaska', 'V', 'Victor', '0', '(GMT -9:00) Alaska');
48INSERT INTO `timezones` VALUES ('12', '-8.0', 'Etc/GMT-8', 'US/Pacific', 'U', 'Uniform', '0', '(GMT -8:00) Pacific Time (US & Canada)');
49INSERT INTO `timezones` VALUES ('13', '-7.0', 'Etc/GMT-7', 'US/Mountain', 'T', 'Tango', '0', '(GMT -7:00) Mountain Time (US & Canada)');
50INSERT INTO `timezones` VALUES ('14', '-6.0', 'Etc/GMT-6', 'US/Central', 'S', 'Sierra', '0', '(GMT -6:00) Central Time (US & Canada), Mexico City');
51INSERT INTO `timezones` VALUES ('15', '-5.0', 'Etc/GMT-5', 'US/Eastern', 'R', 'Romeo', '0', '(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima');
52INSERT INTO `timezones` VALUES ('16', '-4.0', 'Etc/GMT-4', 'US/Atlantic', 'Q', 'Quebec', '0', '(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz');
53INSERT INTO `timezones` VALUES ('17', '-3.5', 'Canada/Newfoundland', 'Canada/Newfoundland', 'P*', null, '0', '(GMT -3:30) Newfoundland');
54INSERT INTO `timezones` VALUES ('18', '-3.0', 'Etc/GMT-3', 'America/Buenos_Aires', 'P', 'Papa', '0', '(GMT -3:00) Brazil, Buenos Aires, Georgetown');
55INSERT INTO `timezones` VALUES ('19', '-2.0', 'Etc/GMT-2', 'Atlantic/Bermuda', 'O', 'Oscar', '0', '(GMT -2:00) Mid-Atlantic');
56INSERT INTO `timezones` VALUES ('20', '-1.0', 'Etc/GMT-1', 'Atlantic/Azores', 'N', 'November', '0', '(GMT -1:00 hour) Azores, Cape Verde Islands');
57INSERT INTO `timezones` VALUES ('21', '0.0', 'Etc/GMT0', 'Europe/London', 'N', 'November', '0', '(GMT) Western Europe Time, London, Lisbon, Casablanca');
58INSERT INTO `timezones` VALUES ('22', '5.5', 'Asia/Calcutta', 'Asia/Calcutta', 'E*', null, '0', '(GMT +5:30) Bombay, Calcutta, Madras, New Delhi');
59INSERT INTO `timezones` VALUES ('23', '5.75', 'Asia/Kathmandu', 'Asia/Kathmandu', null, null, '0', '(GMT +5:45) Kathmandu');
60INSERT INTO `timezones` VALUES ('24', '6.0', 'Etc/GMT+6', null, 'F', 'Foxtrot', '0', '(GMT +6:00) Almaty, Dhaka, Colombo');
61INSERT INTO `timezones` VALUES ('25', '7.0', 'Etc/GMT+7', 'Asia/Bangkok', 'G', 'Golf', '0', '(GMT +7:00) Bangkok, Hanoi, Jakarta');
62INSERT INTO `timezones` VALUES ('26', '8.0', 'Etc/GMT+8', 'HongKong', 'H', 'Hotel', '0', '(GMT +8:00) Beijing, Perth, Singapore, Hong Kong');
63INSERT INTO `timezones` VALUES ('27', '9.0', 'Etc/GMT+9', ' Asia/Tokyo', 'I', 'India', '0', '(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk');
64INSERT INTO `timezones` VALUES ('28', '9.5', 'Australia/Darwin', 'Australia/Darwin', 'I*', null, '0', '(GMT +9:30) Adelaide, Darwin');
65INSERT INTO `timezones` VALUES ('29', '10.0', 'Etc/GMT+10', '', 'K', 'Kilo', '0', '(GMT +10:00) Eastern Australia, Guam, Vladivostok');
66INSERT INTO `timezones` VALUES ('30', '11.0', 'Etc/GMT+11', null, 'L', 'Lima', '0', '(GMT +11:00) Magadan, Solomon Islands, New Caledonia');
67INSERT INTO `timezones` VALUES ('31', '12.0', 'Etc/GMT+12', 'Pacific/Fiji', 'M', 'Mike', '0', '(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka');