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

9 lines
222 B
MySQL
Raw Permalink Normal View History

2024-01-29 08:12:29 +00:00
CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`warehouse_pickup`
AS SELECT
`wp`.`warehouseFk` AS `warehouse_id`,
`wp`.`agencyModeFk` AS `agency_id`
FROM
`vn`.`warehousePickup` `wp`;