--
-- Host: localhost    Database: db_andromeda
-- ------------------------------------------------------


--
-- Temporary table structure for view `threedadv_sepomex_zip_code_full_wiew`
--

/*!50001 DROP VIEW IF EXISTS `threedadv_sepomex_zip_code_full_wiew`*/;
/*!50001 CREATE VIEW `threedadv_sepomex_zip_code_full_wiew` AS SELECT
 1 AS `zip_code_full_wiew_id`,
  1 AS `codigo_postal`,
  1 AS `nombre_ciudad`,
  1 AS `nombre_estado` */;

--
-- Final view structure for view `threedadv_sepomex_zip_code_full_wiew`
--

/*!50001 DROP VIEW IF EXISTS `threedadv_sepomex_zip_code_full_wiew`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `threedadv_sepomex_zip_code_full_wiew` AS select 0 AS `zip_code_full_wiew_id`,`tszc`.`codigo_postal` AS `codigo_postal`,`tsc`.`nombre_ciudad` AS `nombre_ciudad`,`tss`.`nombre_estado` AS `nombre_estado` from ((`threedadv_sepomex_zip_codes` `tszc` join `threedadv_sepomex_city` `tsc` on(`tsc`.`city_id` = `tszc`.`id_ciudad`)) join `threedadv_sepomex_state` `tss` on(`tss`.`state_id` = `tsc`.`id_estado`)) */;


