20 lines
744 B
SQL
20 lines
744 B
SQL
CREATE OR REPLACE DEFINER=`vn`@`localhost`
|
|
SQL SECURITY DEFINER
|
|
VIEW `vn`.`tr2`
|
|
AS SELECT `vn`.`travel`.`id` AS `id`,
|
|
`vn`.`travel`.`shipped` AS `shipped`,
|
|
`vn`.`travel`.`shipmentHour` AS `shipmentHour`,
|
|
`vn`.`travel`.`landed` AS `landed`,
|
|
`vn`.`travel`.`landingHour` AS `landingHour`,
|
|
`vn`.`travel`.`warehouseInFk` AS `warehouseInFk`,
|
|
`vn`.`travel`.`warehouseOutFk` AS `warehouseOutFk`,
|
|
`vn`.`travel`.`agencyModeFk` AS `agencyFk`,
|
|
`vn`.`travel`.`ref` AS `ref`,
|
|
`vn`.`travel`.`isDelivered` AS `isDelivered`,
|
|
`vn`.`travel`.`isReceived` AS `isReceived`,
|
|
`vn`.`travel`.`m3` AS `m3`,
|
|
`vn`.`travel`.`kg` AS `kg`,
|
|
`vn`.`travel`.`cargoSupplierFk` AS `cargoSupplierFk`,
|
|
`vn`.`travel`.`totalEntries` AS `totalEntries`
|
|
FROM `vn`.`travel`
|