10 lines
308 B
MySQL
10 lines
308 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`Movimientos_componentes`
|
||
|
|
AS SELECT `sc`.`saleFk` AS `Id_Movimiento`,
|
||
|
|
`sc`.`componentFk` AS `Id_Componente`,
|
||
|
|
`sc`.`value` AS `Valor`,
|
||
|
|
`sc`.`created` AS `created`,
|
||
|
|
`sc`.`isGreuge` AS `greuge`
|
||
|
|
FROM `vn`.`saleComponent` `sc`
|