[Noalyss-commit] [noalyss] 19/22: upgrade SQL scripts

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 207af4671144e860f51786b19ad340fe26d3e437
Author: Dany De Bontridder <address@hidden>
Date:   Wed Jun 17 19:23:10 2015 +0200

    upgrade SQL scripts
---
 sql/ac_upgrade.sql |   12 ++++++++++++
 sql/upgrade.sql    |    4 ++--
 2 files changed, 14 insertions(+), 2 deletions(-)

diff --git a/sql/ac_upgrade.sql b/sql/ac_upgrade.sql
new file mode 100644
index 0000000..9beca2b
--- /dev/null
+++ b/sql/ac_upgrade.sql
@@ -0,0 +1,12 @@
+
+begin;
+ALTER TABLE ac_dossier drop COLUMN dos_jnt_user ;
+delete from jnt_use_dos where jnt_id in (select priv_jnt from priv_user where 
priv_priv='X');
+delete from jnt_use_dos where use_id in (select use_id from ac_users where 
use_admin=1 or use_active=0);              
+ALTER TABLE ac_users ADD COLUMN use_email text;
+COMMENT ON COLUMN ac_users.use_email IS 'Email of the user';
+
+drop table priv_user;
+select upgrade_repo(16);
+alter table 
+rollback;
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 8936cd6..8c11283 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -59,7 +59,7 @@ values
 
 insert into profile_menu (me_code,me_code_dep,p_id,p_order, 
p_type_display,pm_default) 
 values
-('BALAGE','PRINT',1,550,'M',0),('BALAGE','PRINT',2,550,'M',0),
+('BALAGE','PRINT',1,550,'E',0),('BALAGE','PRINT',2,550,'E',0),
 ('CSV:balance_age',null,1,null,'P',0),('CSV:balance_age',null,2,null,'P',0)
 ;
 
@@ -156,7 +156,7 @@ begin
        return sResult::account_type;
 end;
 $BODY$ 
-LANGUAGE plpgsql ;;
+LANGUAGE plpgsql ;
 
 CREATE OR REPLACE FUNCTION comptaproc.account_insert(p_f_id integer, p_account 
text)
   RETURNS text AS