From b32b495d4e7fb3a637109dc965e9f72ae1559c2d Mon Sep 17 00:00:00 2001 From: Maxime Bourget Date: Sun, 16 Jun 2013 17:55:56 +0100 Subject: [PATCH] Add to pick view. --- sql/create_topick_view.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/create_topick_view.sql diff --git a/sql/create_topick_view.sql b/sql/create_topick_view.sql new file mode 100644 index 0000000..a677f6c --- /dev/null +++ b/sql/create_topick_view.sql @@ -0,0 +1,13 @@ + +Create View `0_topick` AS select +`move`.`sku` AS `sku`, +`move`.`location` AS `location`, +`move`.`orderLink` AS `order_link`, +`move`.`itemLink` AS `item_link`, +`move`.`base` AS `base`, +`move`.`variation` AS `variation`, +`move`.`orderId` AS `order_id`, +`move`.`detailId` AS `detail_id`, +`move`.`quantity` AS `quantity`, +`move`.`id` AS `id`, +`move`.`type` AS `type` from `test_mop`.`move` -- 2.30.2