12 lines
388 B
MySQL
12 lines
388 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`Movimientos_mark`
|
||
|
|
AS SELECT `mm`.`saleFk` AS `Id_Movimiento`,
|
||
|
|
`mm`.`isChecked` AS `valor`,
|
||
|
|
`mm`.`created` AS `odbc_date`,
|
||
|
|
`mm`.`originalQuantity` AS `original_quantity`,
|
||
|
|
`mm`.`workerFk` AS `Id_Trabajador`,
|
||
|
|
`mm`.`id` AS `Id_Movimiento_mark`,
|
||
|
|
`mm`.`stateFk` AS `stateFk`
|
||
|
|
FROM `vn`.`saleTracking` `mm`
|