[Noalyss-commit] [noalyss] 60/323: remove deprecated theme

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 6f25435751eef449a77092bc92260c6d1ec55961
Author: Dany De Bontridder <address@hidden>
Date:   Wed Jan 17 21:50:58 2018 +0100

    remove deprecated theme
---
 sql/upgrade.sql | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index b0feadf..d74f0ae 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -6,7 +6,7 @@ alter table action_gestion drop ag_ref_ag_id;
 -- add style
 insert into theme (the_name,the_filestyle) values 
('Classic7','style-classic7.css');
 delete from theme where the_filestyle in 
('style-mandarine.css','style-mobile.css');
-update user_global_pref set parameter_value='style-
+update user_global_pref set parameter_value='style-classic7.css' where 
parameter_value in  ('style-mandarine.css','style-mobile.css');
 -- add constraint
 alter table jnt_use_dos add CONSTRAINT use_id_dos_id_uniq UNIQUE 
(use_id,dos_id);
 */
@@ -96,4 +96,7 @@ comment on column jrn_def.jrn_enable is 'Set to 1 if the 
ledger is enable ';
 alter table jrn add jr_optype varchar(3);
 alter table jrn alter jr_optype set default 'NOR';
 comment on column jrn.jr_optype is 'Type of operation , NOR = NORMAL , OPE 
opening , EXT extourne, CLO closing';
-update jrn set jr_optype='NOR';
\ No newline at end of file
+update jrn set jr_optype='NOR';
+
+-- update quant_sold set qs_vat_sided=round(qs_vat_sided,2);
+-- update quant_purchase set qp_vat_sided=round(qp_vat_sided,2);
\ No newline at end of file