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

10 lines
276 B
SQL

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`definitivo`
AS SELECT `d`.`id` AS `definitivo_id`,
`d`.`companyFk` AS `empresa_id`,
`d`.`started` AS `desde`,
`d`.`ended` AS `hasta`,
`d`.`created` AS `fecha`
FROM `vn`.`dmsStorageBox` `d`