-- -- Estructura de tabla para la tabla `timezone` -- CREATE TABLE IF NOT EXISTS `timezone` ( `tzid` int(11) NOT NULL auto_increment, `tzciudad` varchar(35) collate utf8_unicode_ci NOT NULL default '', `tzcodigo` varchar(5) collate utf8_unicode_ci default NULL, `tzgmthora` varchar(35) collate utf8_unicode_ci NOT NULL default '', `tzgmt` decimal(6,2) NOT NULL default '0.00', `tztimezone` varchar(50) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Zonas de PHP', `tzfecreg` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`tzid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=63 ; -- -- Volcar la base de datos para la tabla `timezone` -- INSERT INTO `timezone` (`tzid`, `tzciudad`, `tzcodigo`, `tzgmthora`, `tzgmt`, `tztimezone`, `tzfecreg`) VALUES (1, 'Wellington', 'NZDT', 'GMT +13', 13.00, 'Pacific/Auckland', '2008-11-05 22:03:11'), (2, 'New-Caledonia', 'NCT', 'GMT +11', 11.00, 'Pacific/Noumea', '2008-11-05 22:03:11'), (3, 'Melbourne', 'EST', 'GMT +11', 11.00, 'Australia/Melbourne', '2008-11-05 22:03:11'), (4, 'Sydney', 'EST', 'GMT +11', 11.00, 'Australia/Sydney', '2008-11-05 22:03:11'), (5, 'Vladivostok', 'VLAT', 'GMT +10', 10.00, 'Asia/Vladivostok', '2008-11-05 22:03:11'), (6, 'Darwin', 'GALT', 'GMT -6', -6.00, 'Pacific/Galapagos', '2008-11-08 03:16:23'), (7, 'Seúl', 'KST', 'GMT +9', 9.00, 'Asia/Seoul', '2008-11-05 22:03:11'), (8, 'Tokyo', 'JST', 'GMT +9', 9.00, 'Asia/Tokyo', '2008-11-05 22:03:11'), (9, 'Hongkong', 'HKT', 'GMT +8', 8.00, 'Asia/Hong_Kong', '2008-11-05 22:03:11'), (10, 'Beijing', 'HKT', 'GMT +8', 8.00, 'Asia/Hong_Kong', '2008-11-05 22:03:11'), (11, 'Perth', 'WST', 'GMT +9', 9.00, 'Australia/Perth', '2008-11-05 22:03:11'), (12, 'Singapore', 'SGT', 'GMT +8', 8.00, 'Asia/Singapore', '2008-11-05 22:03:11'), (13, 'Bangkok', 'ICT', 'GMT +7', 7.00, 'Asia/Bangkok', '2008-11-05 22:03:11'), (14, 'Jakarta', 'WIT', 'GMT +7', 7.00, 'Asia/Jakarta', '2008-11-05 22:03:11'), (15, 'Novosibirsk', 'NOVT', 'GMT +6', 6.00, 'Asia/Novosibirsk', '2008-11-05 22:03:11'), (16, 'Almaty', 'ALMT', 'GMT +6', 6.00, 'Asia/Almaty', '2008-11-05 22:03:11'), (17, 'Calcuta', 'IST', 'GMT +5.5', 5.50, 'Asia/Calcutta', '2008-11-08 03:16:23'), (18, 'Nueva Delhi', 'IST', 'GMT +5.5', 5.50, 'Asia/Calcutta', '2008-11-08 03:16:23'), (19, 'Ashgabad', 'TMT', 'GMT +5', 5.00, 'Asia/Ashgabat', '2008-11-05 22:03:11'), (20, 'Karachi', 'PKT', 'GMT +5', 5.00, 'Asia/Karachi', '2008-11-05 22:03:11'), (21, 'Mauritius', 'MUT', 'GMT +4', 4.00, 'Indian/Mauritius', '2008-11-05 22:03:11'), (22, 'Bagdad', 'AST', 'GMT +3', 3.00, 'Asia/Baghdad', '2008-11-05 22:03:11'), (23, 'Moscú', 'MSK', 'GMT +3', 3.00, 'Europe/Moscow', '2008-11-05 22:03:11'), (24, 'Nairobi', 'EAT', 'GMT +3', 3.00, 'Africa/Nairobi', '2008-11-05 22:03:11'), (25, 'Ankara', 'EET', 'GMT +2', 2.00, 'Europe/Istanbul', '2008-11-05 22:03:11'), (26, 'Helsinki', 'EET', 'GMT +2', 2.00, 'Europe/Helsinki', '2008-11-05 22:03:11'), (27, 'Estambul', 'EET', 'GMT +2', 2.00, 'Europe/Istanbul', '2008-11-05 22:03:11'), (28, 'Kiev', 'EET', 'GMT +2', 2.00, 'Europe/Kiev', '2008-11-05 22:03:11'), (29, 'Johannesburg', 'SAST', 'GMT +2', 2.00, 'Africa/Johannesburg', '2008-11-05 22:03:11'), (30, 'Cairo', 'EET', 'GMT +2', 2.00, 'Africa/Cairo', '2008-11-05 22:03:11'), (31, 'Windhoek', 'WAST', 'GMT +2', 2.00, 'Africa/Windhoek', '2008-11-05 22:03:11'), (32, 'Berlín', 'CET', 'GMT +1', 1.00, 'Europe/Berlin', '2008-11-05 22:03:11'), (33, 'Madrid', 'CET', 'GMT +1', 1.00, 'Europe/Madrid', '2008-11-05 22:03:11'), (34, 'París', 'CET', 'GMT +1', 1.00, 'Europe/Paris', '2008-11-05 22:03:11'), (35, 'Roma', 'CET', 'GMT +1', 1.00, 'Europe/Rome', '2008-11-05 22:03:11'), (36, 'Estocolmo', 'CET', 'GMT +1', 1.00, 'Europe/Stockholm', '2008-11-05 22:03:11'), (37, 'Trípoli', 'EET', 'GMT +2', 2.00, 'Africa/Tripoli', '2008-11-05 22:03:11'), (38, 'Lisboa', 'WET', 'GMT', 0.00, 'Europe/Lisbon', '2008-11-08 03:16:23'), (39, 'Londres', 'GMT', 'GMT', 0.00, 'Europe/London', '2008-11-08 03:16:23'), (40, 'Túnez', 'CET', 'GMT +1', 1.00, 'Africa/Tunis', '2008-11-05 22:03:11'), (41, 'Dakar', 'GMT', 'GMT', 0.00, 'Africa/Dakar', '2008-11-08 03:16:23'), (42, 'Reykjavik', 'GMT', 'GMT', 0.00, 'Atlantic/Reykjavik', '2008-11-08 03:16:23'), (43, 'Azores', 'AZOT', 'GMT -1', -1.00, 'Atlantic/Azores', '2008-11-08 03:16:23'), (44, 'Cabo Verde', 'CVT', 'GMT -1', -1.00, 'Atlantic/Cape_Verde', '2008-11-08 03:16:23'), (45, 'Buenos Aires', 'ART', 'GMT -3', -3.00, 'America/Buenos_Aires', '2008-11-08 03:16:23'), (46, 'Río de Janeiro', 'BRT', 'GMT -3', -3.00, 'America/Bahia', '2008-11-08 03:16:23'), (47, 'Caracas', 'VET', 'GMT -4.5', -4.50, 'America/Caracas', '2008-11-08 03:16:23'), (48, 'La Paz', 'BOT', 'GMT -4', -4.00, 'America/La_Paz', '2008-11-08 03:16:23'), (49, 'Santiago de Chile', 'CLST', 'GMT -3', -3.00, 'America/Santiago', '2008-11-08 03:16:23'), (50, 'Montreal', 'EST', 'GMT -5', -5.00, 'America/Montreal', '2008-11-08 03:16:23'), (51, 'New York', 'EST', 'GMT -5', -5.00, 'America/New_York', '2008-11-08 03:16:23'), (52, 'Washington', 'EST', 'GMT -5', -5.00, 'America/New_York', '2008-11-08 03:16:23'), (53, 'Chicago', 'CST', 'GMT -6', -6.00, 'America/Chicago', '2008-11-08 03:16:23'), (54, 'México DF', 'CST', 'GMT -6', -6.00, 'America/Mexico_City', '2008-11-08 03:16:23'), (55, 'Denver', 'MST', 'GMT -7', -7.00, 'America/Denver', '2008-11-08 03:16:23'), (56, 'Los Ángeles', 'PST', 'GMT -8', -8.00, 'America/Los_Angeles', '2008-11-08 03:16:23'), (57, 'San Francisco', 'PST', 'GMT -8', -8.00, 'America/Los_Angeles', '2008-11-08 03:16:23'), (58, 'Anchorage', 'AKST', 'GMT -9', -9.00, 'America/Anchorage', '2008-11-08 03:16:23'), (59, 'Fairbanks', 'AKST', 'GMT -9', -9.00, 'America/Anchorage', '2008-11-08 03:16:23'), (60, 'Honolulú', 'HST', 'GMT -10', -10.00, 'Pacific/Honolulu', '2008-11-08 03:16:23'), (61, 'Westsamoa', 'SST', 'GMT -11', -11.00, 'Pacific/Samoa', '2008-11-08 03:16:23'), (62, 'Islas Canarias', 'WET', 'GMT', 0.00, 'Atlantic/Canary', '2008-11-08 03:16:23');