10 lines
267 B
MySQL
10 lines
267 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`Origen`
|
||
|
|
AS SELECT `o`.`id` AS `id`,
|
||
|
|
`o`.`code` AS `Abreviatura`,
|
||
|
|
`o`.`name` AS `Origen`,
|
||
|
|
`o`.`countryFk` AS `Id_Paises`,
|
||
|
|
`o`.`warehouseFk` AS `warehouse_id`
|
||
|
|
FROM `vn`.`origin` `o`
|