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

12 lines
431 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`config_host`
AS SELECT `vn`.`host`.`code` AS `config_host_id`,
`vn`.`host`.`warehouseFk` AS `warehouse`,
`vn`.`host`.`companyFk` AS `empresaId`,
`vn`.`host`.`bankFk` AS `caja`,
`vn`.`host`.`printerFk` AS `Id_Impresora`,
`vn`.`host`.`routeDaysBefore` AS `route_days_before`,
`vn`.`host`.`routeDaysAfter` AS `route_days_after`
FROM `vn`.`host`