[Noalyss-commit] [noalyss] 46/65: drop view before recreating it

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 24fe64c79fef2ae02cd59b51ad8bbcd69a42ba00
Author: Dany De Bontridder <address@hidden>
Date:   Sun Sep 6 06:05:07 2015 +0200

    drop view before recreating it
---
 html/admin/sql/patch/upgrade120.sql |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

diff --git a/html/admin/sql/patch/upgrade120.sql 
b/html/admin/sql/patch/upgrade120.sql
index f32c3f1..be27190 100644
--- a/html/admin/sql/patch/upgrade120.sql
+++ b/html/admin/sql/patch/upgrade120.sql
@@ -185,6 +185,8 @@ select insert_menu();
 
 drop function insert_menu();
 
+drop view v_all_menu;
+
 CREATE OR REPLACE VIEW v_all_menu AS 
  SELECT pm.me_code, 
        pm.pm_id,