19 lines
545 B
MySQL
19 lines
545 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`price_fixed`
|
||
|
|
AS SELECT `pf`.`itemFk` AS `item_id`,
|
||
|
|
`pf`.`rate0` AS `rate_0`,
|
||
|
|
`pf`.`rate1` AS `rate_1`,
|
||
|
|
`pf`.`rate2` AS `rate_2`,
|
||
|
|
`pf`.`rate3` AS `rate_3`,
|
||
|
|
`pf`.`started` AS `date_start`,
|
||
|
|
`pf`.`ended` AS `date_end`,
|
||
|
|
`pf`.`bonus` AS `bonus`,
|
||
|
|
`pf`.`warehouseFk` AS `warehouse_id`,
|
||
|
|
`pf`.`created` AS `odbc_date`,
|
||
|
|
`pf`.`id` AS `price_fixed_id`,
|
||
|
|
`pf`.`grouping` AS `grouping`,
|
||
|
|
`pf`.`packing` AS `Packing`,
|
||
|
|
`pf`.`box` AS `caja`
|
||
|
|
FROM `vn`.`priceFixed` `pf`
|