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

8 lines
202 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`barcodes`
AS SELECT `b`.`id` AS `id`,
`b`.`itemFk` AS `Id_Article`,
`b`.`code` AS `code`
FROM `vn`.`itemBarcode` `b`