--
-- Structure for view `gen_vciuds`
--
DROP TABLE IF EXISTS `gen_vciuds`;

CREATE  VIEW `gen_vciuds`  AS SELECT `a`.`ciud_codi` AS `ciud_codi`, `a`.`ciud_dane` AS `ciud_dane`, `a`.`ciud_nomb` AS `ciud_nomb`, `b`.`deps_codi` AS `deps_codi`, `b`.`deps_nomb` AS `deps_nomb`, `c`.`pais_codi` AS `pais_codi`, `c`.`pais_iso2` AS `pais_iso2`, `c`.`pais_iso3` AS `pais_iso3`, `c`.`pais_nomb` AS `pais_nomb` FROM ((`gen_tciud` `a` join `gen_tdeps` `b`) join `gen_tpais` `c`) WHERE `b`.`pais_codi` = `c`.`pais_codi` AND `a`.`deps_codi` = `b`.`deps_codi`  ;

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

--
-- Structure for view `gen_vrtask`
--
DROP TABLE IF EXISTS `gen_vrtask`;

CREATE  VIEW `gen_vrtask`  AS SELECT `d`.`rtask_codi` AS `rtask_codi`, `a`.`roles_codi` AS `roles_codi`, `a`.`roles_name` AS `roles_name`, `b`.`menus_codi` AS `menus_codi`, `b`.`menus_nomb` AS `menus_nomb`, `b`.`menus_mod` AS `menus_mod`, `b`.`menus_con` AS `menus_con`, `c`.`mtask_codi` AS `mtask_codi`, `c`.`mtask_desc` AS `mtask_desc`, `c`.`mtask_action` AS `mtask_action` FROM (((`gen_troles` `a` join `gen_tmenus` `b`) join `gen_tmtask` `c`) join `gen_trtask` `d`) WHERE `d`.`roles_codi` = `a`.`roles_codi` AND `d`.`menus_codi` = `b`.`menus_codi` AND `d`.`mtask_codi` = `c`.`mtask_codi`  ;

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

--
-- Structure for view `gen_vvipers`
--
DROP TABLE IF EXISTS `gen_vvipers`;

CREATE  VIEW `gen_vvipers`  AS SELECT `b`.`vipe_codi` AS `vipe_codi`, `a`.`vinc_codi` AS `vinc_codi`, `a`.`vinc_nomb` AS `vinc_nomb`, `b`.`pers_codi` AS `pers_codi` FROM (`gen_tvinc` `a` join `gen_tvipe` `b`) WHERE `a`.`vinc_codi` = `b`.`vinc_codi`  ;



--View sucursales,plantas, areas, equipos
--source
Select a.pers_codi, a.pers_rsoc, b.succli_codi,b.succli_nomb,c.plant_codi, c.plant_nomb, d.area_codi, d.area_nomb,f.equi_codi,f.equi_nomb FROM gen_tpers as a, gen_tsuccli b, gen_tplant as c, gen_tarea as d, gen_teqarea as e, gen_tequi as f WHERE a.pers_codi=b.pers_codi and b.succli_codi=c.succli_codi and c.plant_codi=d.plant_codi and d.area_codi= e.area_codi and e.equi_codi=f.equi_codi;

CREATE  VIEW `gen_veqcli`  AS SELECT `a`.`pers_codi` AS `pers_codi`, `a`.`pers_rsoc` AS `pers_rsoc`, `b`.`succli_codi` AS `succli_codi`, `b`.`succli_nomb` AS `succli_nomb`, `c`.`plant_codi` AS `plant_codi`, `c`.`plant_nomb` AS `plant_nomb`, `d`.`area_codi` AS `area_codi`, `d`.`area_nomb` AS `area_nomb`, `f`.`equi_codi` AS `equi_codi`, `f`.`equi_nomb` AS `equi_nomb` FROM (((((`gen_tpers` `a` join `gen_tsuccli` `b`) join `gen_tplant` `c`) join `gen_tarea` `d`) join `gen_teqarea` `e`) join `gen_tequi` `f`) WHERE `a`.`pers_codi` = `b`.`pers_codi` AND `b`.`succli_codi` = `c`.`succli_codi` AND `c`.`plant_codi` = `d`.`plant_codi` AND `d`.`area_codi` = `e`.`area_codi` AND `e`.`equi_codi` = `f`.`equi_codi`  ;


----view equipos
---source
SELECT a.equi_codi,a.equi_nomb, b.elemeq_codi, b.elemeq_nomb, c.pumed_codi, c.pumed_nomb
FROM gen_tequi as a, gen_telemeq as b, gen_tpumed as c
WHERE a.equi_codi=b.equi_codi and b.elemeq_codi=c.elemeq_codi

CREATE  VIEW `gen_vequi`  AS SELECT `a`.`equi_codi` AS `equi_codi`, `a`.`equi_nomb` AS `equi_nomb`, `b`.`elemeq_codi` AS `elemeq_codi`, `b`.`elemeq_nomb` AS `elemeq_nomb`, `c`.`pumed_codi` AS `pumed_codi`, `c`.`pumed_nomb` AS `pumed_nomb` FROM ((`gen_tequi` `a` join `gen_telemeq` `b`) join `gen_tpumed` `c`) WHERE `a`.`equi_codi` = `b`.`equi_codi` AND `b`.`elemeq_codi` = `c`.`elemeq_codi`  ;