12.- Tabla TimeZone | Proyecto Profesional PHP / MVC / 3 Capas

Proyecto Profesional PHP / MVC / 3 Capas

La tabla TimeZone contiene todas las zonas horarias del mundo.
Es importante esta tabla ya que todas las fechas utilizadas en la aplicación son GMT.
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


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


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

--
-- Estructura de tabla para la tabla `adm_timezones`
--

CREATE TABLE `adm_timezones` (
  `timezone_code` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `timezone_pais_code` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `timezone_estado_id` smallint(5) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcado de datos para la tabla `adm_timezones`
--

INSERT INTO `adm_timezones` (`timezone_code`, `timezone_pais_code`, `timezone_estado_id`) VALUES
('Africa/Abidjan', 'CI', 15),
('Africa/Accra', 'GH', 15),
('Africa/Addis_Ababa', 'ET', 15),
('Africa/Algiers', 'DZ', 15),
('Africa/Asmara', 'ER', 15),
('Africa/Bamako', 'ML', 15),
('Africa/Bangui', 'CF', 15),
('Africa/Banjul', 'GM', 15),
('Africa/Bissau', 'GW', 15),
('Africa/Blantyre', 'MW', 15),
('Africa/Brazzaville', 'CG', 15),
('Africa/Bujumbura', 'BI', 15),
('Africa/Cairo', 'EG', 15),
('Africa/Casablanca', 'MA', 15),
('Africa/Ceuta', 'ES', 15),
('Africa/Conakry', 'GN', 15),
('Africa/Dakar', 'SN', 15),
('Africa/Dar_es_Salaam', 'TZ', 15),
('Africa/Djibouti', 'DJ', 15),
('Africa/Douala', 'CM', 15),
('Africa/El_Aaiun', 'EH', 15),
('Africa/Freetown', 'SL', 15),
('Africa/Gaborone', 'BW', 15),
('Africa/Harare', 'ZW', 15),
('Africa/Johannesburg', 'ZA', 15),
('Africa/Juba', 'SS', 15),
('Africa/Kampala', 'UG', 15),
('Africa/Khartoum', 'SD', 15),
('Africa/Kigali', 'RW', 15),
('Africa/Kinshasa', 'CD', 15),
('Africa/Lagos', 'NG', 15),
('Africa/Libreville', 'GA', 15),
('Africa/Lome', 'TG', 15),
('Africa/Luanda', 'AO', 15),
('Africa/Lubumbashi', 'CD', 15),
('Africa/Lusaka', 'ZM', 15),
('Africa/Malabo', 'GQ', 15),
('Africa/Maputo', 'MZ', 15),
('Africa/Maseru', 'LS', 15),
('Africa/Mbabane', 'SZ', 15),
('Africa/Mogadishu', 'SO', 15),
('Africa/Monrovia', 'LR', 15),
('Africa/Nairobi', 'KE', 15),
('Africa/Ndjamena', 'TD', 15),
('Africa/Niamey', 'NE', 15),
('Africa/Nouakchott', 'MR', 15),
('Africa/Ouagadougou', 'BF', 15),
('Africa/Porto-Novo', 'BJ', 15),
('Africa/Sao_Tome', 'ST', 15),
('Africa/Tripoli', 'LY', 15),
('Africa/Tunis', 'TN', 15),
('Africa/Windhoek', 'NA', 15),
('America/Adak', 'US', 15),
('America/Anchorage', 'US', 15),
('America/Anguilla', 'AI', 15),
('America/Antigua', 'AG', 15),
('America/Araguaina', 'BR', 15),
('America/Argentina/Buenos_Aires', 'AR', 15),
('America/Argentina/Catamarca', 'AR', 15),
('America/Argentina/Cordoba', 'AR', 15),
('America/Argentina/Jujuy', 'AR', 15),
('America/Argentina/La_Rioja', 'AR', 15),
('America/Argentina/Mendoza', 'AR', 15),
('America/Argentina/Rio_Gallegos', 'AR', 15),
('America/Argentina/Salta', 'AR', 15),
('America/Argentina/San_Juan', 'AR', 15),
('America/Argentina/San_Luis', 'AR', 15),
('America/Argentina/Tucuman', 'AR', 15),
('America/Argentina/Ushuaia', 'AR', 15),
('America/Aruba', 'AW', 15),
('America/Asuncion', 'PY', 15),
('America/Atikokan', 'CA', 15),
('America/Bahia', 'BR', 15),
('America/Bahia_Banderas', 'MX', 15),
('America/Barbados', 'BB', 15),
('America/Belem', 'BR', 15),
('America/Belize', 'BZ', 15),
('America/Blanc-Sablon', 'CA', 15),
('America/Boa_Vista', 'BR', 15),
('America/Bogota', 'CO', 15),
('America/Boise', 'US', 15),
('America/Cambridge_Bay', 'CA', 15),
('America/Campo_Grande', 'BR', 15),
('America/Cancun', 'MX', 15),
('America/Caracas', 'VE', 15),
('America/Cayenne', 'GF', 15),
('America/Cayman', 'KY', 15),
('America/Chicago', 'US', 15),
('America/Chihuahua', 'MX', 15),
('America/Costa_Rica', 'CR', 15),
('America/Creston', 'CA', 15),
('America/Cuiaba', 'BR', 15),
('America/Curacao', 'CW', 15),
('America/Danmarkshavn', 'GL', 15),
('America/Dawson', 'CA', 15),
('America/Dawson_Creek', 'CA', 15),
('America/Denver', 'US', 15),
('America/Detroit', 'US', 15),
('America/Dominica', 'DM', 15),
('America/Edmonton', 'CA', 15),
('America/Eirunepe', 'BR', 15),
('America/El_Salvador', 'SV', 15),
('America/Fort_Nelson', 'CA', 15),
('America/Fortaleza', 'BR', 15),
('America/Glace_Bay', 'CA', 15),
('America/Godthab', 'GL', 15),
('America/Goose_Bay', 'CA', 15),
('America/Grand_Turk', 'TC', 15),
('America/Grenada', 'GD', 15),
('America/Guadeloupe', 'GP', 15),
('America/Guatemala', 'GT', 15),
('America/Guayaquil', 'EC', 15),
('America/Guyana', 'GY', 15),
('America/Halifax', 'CA', 15),
('America/Havana', 'CU', 15),
('America/Hermosillo', 'MX', 15),
('America/Indiana/Indianapolis', 'US', 15),
('America/Indiana/Knox', 'US', 15),
('America/Indiana/Marengo', 'US', 15),
('America/Indiana/Petersburg', 'US', 15),
('America/Indiana/Tell_City', 'US', 15),
('America/Indiana/Vevay', 'US', 15),
('America/Indiana/Vincennes', 'US', 15),
('America/Indiana/Winamac', 'US', 15),
('America/Inuvik', 'CA', 15),
('America/Iqaluit', 'CA', 15),
('America/Jamaica', 'JM', 15),
('America/Juneau', 'US', 15),
('America/Kentucky/Louisville', 'US', 15),
('America/Kentucky/Monticello', 'US', 15),
('America/Kralendijk', 'BQ', 15),
('America/La_Paz', 'BO', 15),
('America/Lima', 'PE', 15),
('America/Los_Angeles', 'US', 15),
('America/Lower_Princes', 'SX', 15),
('America/Maceio', 'BR', 15),
('America/Managua', 'NI', 15),
('America/Manaus', 'BR', 15),
('America/Marigot', 'MF', 15),
('America/Martinique', 'MQ', 15),
('America/Matamoros', 'MX', 15),
('America/Mazatlan', 'MX', 15),
('America/Menominee', 'US', 15),
('America/Merida', 'MX', 15),
('America/Metlakatla', 'US', 15),
('America/Mexico_City', 'MX', 15),
('America/Miquelon', 'PM', 15),
('America/Moncton', 'CA', 15),
('America/Monterrey', 'MX', 15),
('America/Montevideo', 'UY', 15),
('America/Montserrat', 'MS', 15),
('America/Nassau', 'BS', 15),
('America/New_York', 'US', 15),
('America/Nipigon', 'CA', 15),
('America/Nome', 'US', 15),
('America/Noronha', 'BR', 15),
('America/North_Dakota/Beulah', 'US', 15),
('America/North_Dakota/Center', 'US', 15),
('America/North_Dakota/New_Salem', 'US', 15),
('America/Ojinaga', 'MX', 15),
('America/Panama', 'PA', 15),
('America/Pangnirtung', 'CA', 15),
('America/Paramaribo', 'SR', 15),
('America/Phoenix', 'US', 15),
('America/Port_of_Spain', 'TT', 15),
('America/Port-au-Prince', 'HT', 15),
('America/Porto_Velho', 'BR', 15),
('America/Puerto_Rico', 'PR', 15),
('America/Punta_Arenas', 'CL', 15),
('America/Rainy_River', 'CA', 15),
('America/Rankin_Inlet', 'CA', 15),
('America/Recife', 'BR', 15),
('America/Regina', 'CA', 15),
('America/Resolute', 'CA', 15),
('America/Rio_Branco', 'BR', 15),
('America/Santarem', 'BR', 15),
('America/Santiago', 'CL', 15),
('America/Santo_Domingo', 'DO', 15),
('America/Sao_Paulo', 'BR', 15),
('America/Scoresbysund', 'GL', 15),
('America/Sitka', 'US', 15),
('America/St_Barthelemy', 'BL', 15),
('America/St_Johns', 'CA', 15),
('America/St_Kitts', 'KN', 15),
('America/St_Lucia', 'LC', 15),
('America/St_Thomas', 'VI', 15),
('America/St_Vincent', 'VC', 15),
('America/Swift_Current', 'CA', 15),
('America/Tegucigalpa', 'HN', 15),
('America/Thule', 'GL', 15),
('America/Thunder_Bay', 'CA', 15),
('America/Tijuana', 'MX', 15),
('America/Toronto', 'CA', 15),
('America/Tortola', 'VG', 15),
('America/Vancouver', 'CA', 15),
('America/Whitehorse', 'CA', 15),
('America/Winnipeg', 'CA', 15),
('America/Yakutat', 'US', 15),
('America/Yellowknife', 'CA', 15),
('Antarctica/Macquarie', 'AU', 15),
('Arctic/Longyearbyen', 'SJ', 15),
('Asia/Aden', 'YE', 15),
('Asia/Almaty', 'KZ', 15),
('Asia/Amman', 'JO', 15),
('Asia/Anadyr', 'RU', 15),
('Asia/Aqtau', 'KZ', 15),
('Asia/Aqtobe', 'KZ', 15),
('Asia/Ashgabat', 'TM', 15),
('Asia/Atyrau', 'KZ', 15),
('Asia/Baghdad', 'IQ', 15),
('Asia/Bahrain', 'BH', 15),
('Asia/Baku', 'AZ', 15),
('Asia/Bangkok', 'TH', 15),
('Asia/Barnaul', 'RU', 15),
('Asia/Beirut', 'LB', 15),
('Asia/Bishkek', 'KG', 15),
('Asia/Brunei', 'BN', 15),
('Asia/Chita', 'RU', 15),
('Asia/Choibalsan', 'MN', 15),
('Asia/Colombo', 'LK', 15),
('Asia/Damascus', 'SY', 15),
('Asia/Dhaka', 'BD', 15),
('Asia/Dili', 'TL', 15),
('Asia/Dubai', 'AE', 15),
('Asia/Dushanbe', 'TJ', 15),
('Asia/Famagusta', 'CY', 15),
('Asia/Gaza', 'PS', 15),
('Asia/Hebron', 'PS', 15),
('Asia/Ho_Chi_Minh', 'VN', 15),
('Asia/Hong_Kong', 'HK', 15),
('Asia/Hovd', 'MN', 15),
('Asia/Irkutsk', 'RU', 15),
('Asia/Jakarta', 'ID', 15),
('Asia/Jayapura', 'ID', 15),
('Asia/Jerusalem', 'IL', 15),
('Asia/Kabul', 'AF', 15),
('Asia/Kamchatka', 'RU', 15),
('Asia/Karachi', 'PK', 15),
('Asia/Kathmandu', 'NP', 15),
('Asia/Khandyga', 'RU', 15),
('Asia/Kolkata', 'IN', 15),
('Asia/Krasnoyarsk', 'RU', 15),
('Asia/Kuala_Lumpur', 'MY', 15),
('Asia/Kuching', 'MY', 15),
('Asia/Kuwait', 'KW', 15),
('Asia/Macau', 'MO', 15),
('Asia/Magadan', 'RU', 15),
('Asia/Makassar', 'ID', 15),
('Asia/Manila', 'PH', 15),
('Asia/Muscat', 'OM', 15),
('Asia/Nicosia', 'CY', 15),
('Asia/Novokuznetsk', 'RU', 15),
('Asia/Novosibirsk', 'RU', 15),
('Asia/Omsk', 'RU', 15),
('Asia/Oral', 'KZ', 15),
('Asia/Phnom_Penh', 'KH', 15),
('Asia/Pontianak', 'ID', 15),
('Asia/Pyongyang', 'KP', 15),
('Asia/Qatar', 'QA', 15),
('Asia/Qyzylorda', 'KZ', 15),
('Asia/Riyadh', 'SA', 15),
('Asia/Sakhalin', 'RU', 15),
('Asia/Samarkand', 'UZ', 15),
('Asia/Seoul', 'KR', 15),
('Asia/Shanghai', 'CN', 15),
('Asia/Singapore', 'SG', 15),
('Asia/Srednekolymsk', 'RU', 15),
('Asia/Taipei', 'TW', 15),
('Asia/Tashkent', 'UZ', 15),
('Asia/Tbilisi', 'GE', 15),
('Asia/Tehran', 'IR', 15),
('Asia/Thimphu', 'BT', 15),
('Asia/Tokyo', 'JP', 15),
('Asia/Tomsk', 'RU', 15),
('Asia/Ulaanbaatar', 'MN', 15),
('Asia/Urumqi', 'CN', 15),
('Asia/Ust-Nera', 'RU', 15),
('Asia/Vientiane', 'LA', 15),
('Asia/Vladivostok', 'RU', 15),
('Asia/Yakutsk', 'RU', 15),
('Asia/Yangon', 'MM', 15),
('Asia/Yekaterinburg', 'RU', 15),
('Asia/Yerevan', 'AM', 15),
('Atlantic/Azores', 'PT', 15),
('Atlantic/Bermuda', 'BM', 15),
('Atlantic/Canary', 'ES', 15),
('Atlantic/Cape_Verde', 'CV', 15),
('Atlantic/Faroe', 'FO', 15),
('Atlantic/Madeira', 'PT', 15),
('Atlantic/Reykjavik', 'IS', 15),
('Atlantic/St_Helena', 'SH', 15),
('Atlantic/Stanley', 'FK', 15),
('Australia/Adelaide', 'AU', 15),
('Australia/Brisbane', 'AU', 15),
('Australia/Broken_Hill', 'AU', 15),
('Australia/Currie', 'AU', 15),
('Australia/Darwin', 'AU', 15),
('Australia/Eucla', 'AU', 15),
('Australia/Hobart', 'AU', 15),
('Australia/Lindeman', 'AU', 15),
('Australia/Lord_Howe', 'AU', 15),
('Australia/Melbourne', 'AU', 15),
('Australia/Perth', 'AU', 15),
('Australia/Sydney', 'AU', 15),
('Europe/Amsterdam', 'NL', 15),
('Europe/Andorra', 'AD', 15),
('Europe/Astrakhan', 'RU', 15),
('Europe/Athens', 'GR', 15),
('Europe/Belgrade', 'RS', 15),
('Europe/Berlin', 'DE', 15),
('Europe/Bratislava', 'SK', 15),
('Europe/Brussels', 'BE', 15),
('Europe/Bucharest', 'RO', 15),
('Europe/Budapest', 'HU', 15),
('Europe/Busingen', 'DE', 15),
('Europe/Chisinau', 'MD', 15),
('Europe/Copenhagen', 'DK', 15),
('Europe/Dublin', 'IE', 15),
('Europe/Gibraltar', 'GI', 15),
('Europe/Guernsey', 'GG', 15),
('Europe/Helsinki', 'FI', 15),
('Europe/Isle_of_Man', 'IM', 15),
('Europe/Istanbul', 'TR', 15),
('Europe/Jersey', 'JE', 15),
('Europe/Kaliningrad', 'RU', 15),
('Europe/Kiev', 'UA', 15),
('Europe/Kirov', 'RU', 15),
('Europe/Lisbon', 'PT', 15),
('Europe/Ljubljana', 'SI', 15),
('Europe/London', 'GB', 15),
('Europe/Luxembourg', 'LU', 15),
('Europe/Madrid', 'ES', 15),
('Europe/Malta', 'MT', 15),
('Europe/Mariehamn', 'AX', 15),
('Europe/Minsk', 'BY', 15),
('Europe/Monaco', 'MC', 15),
('Europe/Moscow', 'RU', 15),
('Europe/Oslo', 'NO', 15),
('Europe/Paris', 'FR', 15),
('Europe/Podgorica', 'ME', 15),
('Europe/Prague', 'CZ', 15),
('Europe/Riga', 'LV', 15),
('Europe/Rome', 'IT', 15),
('Europe/Samara', 'RU', 15),
('Europe/San_Marino', 'SM', 15),
('Europe/Sarajevo', 'BA', 15),
('Europe/Saratov', 'RU', 15),
('Europe/Simferopol', 'RU', 15),
('Europe/Skopje', 'MK', 15),
('Europe/Sofia', 'BG', 15),
('Europe/Stockholm', 'SE', 15),
('Europe/Tallinn', 'EE', 15),
('Europe/Tirane', 'AL', 15),
('Europe/Ulyanovsk', 'RU', 15),
('Europe/Uzhgorod', 'UA', 15),
('Europe/Vaduz', 'LI', 15),
('Europe/Vatican', 'VA', 15),
('Europe/Vienna', 'AT', 15),
('Europe/Vilnius', 'LT', 15),
('Europe/Volgograd', 'RU', 15),
('Europe/Warsaw', 'PL', 15),
('Europe/Zagreb', 'HR', 15),
('Europe/Zaporozhye', 'UA', 15),
('Europe/Zurich', 'CH', 15),
('Indian/Antananarivo', 'MG', 15),
('Indian/Chagos', 'IO', 15),
('Indian/Christmas', 'CX', 15),
('Indian/Cocos', 'CC', 15),
('Indian/Comoro', 'KM', 15),
('Indian/Mahe', 'SC', 15),
('Indian/Maldives', 'MV', 15),
('Indian/Mauritius', 'MU', 15),
('Indian/Mayotte', 'YT', 15),
('Indian/Reunion', 'RE', 15),
('Pacific/Apia', 'WS', 15),
('Pacific/Auckland', 'NZ', 15),
('Pacific/Bougainville', 'PG', 15),
('Pacific/Chatham', 'NZ', 15),
('Pacific/Chuuk', 'FM', 15),
('Pacific/Easter', 'CL', 15),
('Pacific/Efate', 'VU', 15),
('Pacific/Enderbury', 'KI', 15),
('Pacific/Fakaofo', 'TK', 15),
('Pacific/Fiji', 'FJ', 15),
('Pacific/Funafuti', 'TV', 15),
('Pacific/Galapagos', 'EC', 15),
('Pacific/Gambier', 'PF', 15),
('Pacific/Guadalcanal', 'SB', 15),
('Pacific/Guam', 'GU', 15),
('Pacific/Honolulu', 'US', 15),
('Pacific/Kiritimati', 'KI', 15),
('Pacific/Kosrae', 'FM', 15),
('Pacific/Kwajalein', 'MH', 15),
('Pacific/Majuro', 'MH', 15),
('Pacific/Marquesas', 'PF', 15),
('Pacific/Midway', 'UM', 15),
('Pacific/Nauru', 'NR', 15),
('Pacific/Niue', 'NU', 15),
('Pacific/Norfolk', 'NF', 15),
('Pacific/Noumea', 'NC', 15),
('Pacific/Pago_Pago', 'AS', 15),
('Pacific/Palau', 'PW', 15),
('Pacific/Pitcairn', 'PN', 15),
('Pacific/Pohnpei', 'FM', 15),
('Pacific/Port_Moresby', 'PG', 15),
('Pacific/Rarotonga', 'CK', 15),
('Pacific/Saipan', 'MP', 15),
('Pacific/Tahiti', 'PF', 15),
('Pacific/Tarawa', 'KI', 15),
('Pacific/Tongatapu', 'TO', 15),
('Pacific/Wake', 'UM', 15),
('Pacific/Wallis', 'WF', 15);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `adm_timezones`
--
ALTER TABLE `adm_timezones`
  ADD PRIMARY KEY (`timezone_code`),
  ADD KEY `idx_timezone_pais_code` (`timezone_pais_code`),
  ADD KEY `idx_timezone_estado_id` (`timezone_estado_id`);

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `adm_timezones`
--
ALTER TABLE `adm_timezones`
  ADD CONSTRAINT `fx_timezone_estado_id` FOREIGN KEY (`timezone_estado_id`) REFERENCES `adm_estados` (`estado_id`),
  ADD CONSTRAINT `fx_timezone_pais_code` FOREIGN KEY (`timezone_pais_code`) REFERENCES `adm_paises` (`pais_code`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Cookie	Duración	Descripción
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.