salix/db/routines/vn2008/views/Paises.sql

14 lines
387 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`Paises`
AS SELECT `c`.`id` AS `Id`,
2024-04-24 07:05:29 +00:00
`c`.`name` AS `Pais`,
`c`.`CEE` AS `CEE`,
`c`.`isUeeMember` AS `isUeeMember`,
`c`.`code` AS `Codigo`,
`c`.`currencyFk` AS `Id_Moneda`,
`c`.`geoFk` AS `geoFk`,
`c`.`ibanLength` AS `ibanLength`,
`c`.`hasDailyInvoice` AS `hasDailyInvoice`
FROM `vn`.`country` `c`