From 0fb44804984bb189e3dba85b2fbaee072f892c4e Mon Sep 17 00:00:00 2001 From: Maxime Bourget Date: Mon, 17 Jun 2013 08:33:41 +0100 Subject: [PATCH] Fix view creation to use MOP productino database. --- sql/create_topick_view.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/create_topick_view.sql b/sql/create_topick_view.sql index a677f6c..433ade2 100644 --- a/sql/create_topick_view.sql +++ b/sql/create_topick_view.sql @@ -1,4 +1,4 @@ - +drop view if exists 0_topick; Create View `0_topick` AS select `move`.`sku` AS `sku`, `move`.`location` AS `location`, @@ -10,4 +10,4 @@ Create View `0_topick` AS select `move`.`detailId` AS `detail_id`, `move`.`quantity` AS `quantity`, `move`.`id` AS `id`, -`move`.`type` AS `type` from `test_mop`.`move` +`move`.`type` AS `type` from `mop`.`move` -- 2.30.2