15 lines
468 B
MySQL
15 lines
468 B
MySQL
|
-- Place your SQL code here
|
||
|
|
ALTER TABLE IF EXISTS vn.expeditionTruck RENAME vn.roadmapStop;
|
||
|
|
|
||
|
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn`.`expeditionTruck`
|
||
|
|
AS SELECT `rs`.`id` AS `id`,
|
||
|
|
`rs`.`roadmapFk` AS `roadmapFk`,
|
||
|
|
`rs`.`warehouseFk` AS `warehouseFk`,
|
||
|
|
`rs`.`eta` AS `eta`,
|
||
|
|
`rs`.`description` AS `description`,
|
||
|
|
`rs`.`bufferFk` AS `bufferFk`,
|
||
|
|
`rs`.`created` AS `created`,
|
||
|
|
`rs`.`userFk` AS `userFk`
|
||
|
|
FROM `vn`.`roadmapStop` `rs`;
|