Author: danydb Date: 2013-10-23 21:14:03 +0200 (Wed, 23 Oct 2013) New Revision: 546
Added: tag/rel700/rapport_avance/sql/upgrade4.sql Modified: tag/rel700/rapport_avance/rapav_constant.php Log: Upgrade RAPAV version 4 Modified: tag/rel700/rapport_avance/rapav_constant.php =================================================================== --- tag/rel700/rapport_avance/rapav_constant.php 2013-10-23 19:10:59 UTC (rev 545) +++ tag/rel700/rapport_avance/rapav_constant.php 2013-10-23 19:14:03 UTC (rev 546) @@ -11,5 +11,5 @@ global $cn,$rapav_version; $cn=new Database (dossier::id()); -$rapav_version=3; -?> \ No newline at end of file +$rapav_version=4; +?> Added: tag/rel700/rapport_avance/sql/upgrade4.sql =================================================================== --- tag/rel700/rapport_avance/sql/upgrade4.sql (rev 0) +++ tag/rel700/rapport_avance/sql/upgrade4.sql 2013-10-23 19:14:03 UTC (rev 546) @@ -0,0 +1,32 @@ +begin; + +ALTER TABLE rapport_advanced.formulaire_param_detail ADD COLUMN jrn_def_id bigint; +COMMENT ON COLUMN rapport_advanced.formulaire_param_detail.jrn_def_id IS 'FK to jrn_def, if null then all the ledgers are concerned'; + +CREATE FUNCTION formulaire_param_detail_jrn_def_id_ins_upd() RETURNS trigger + AS $$ +declare + jrn_def_id integer; +begin + if NEW.jrn_def_id = -1 then + jrn_def_id=NULL; + NEW.jrn_def_id := jrn_def_id; + end if; + return NEW; +end;$$; +language plpgsql; + +CREATE INDEX fki_jrn_def_id ON rapport_advanced.formulaire_param_detail USING btree (jrn_def_id); + +CREATE TRIGGER formulaire_param_detail_trg BEFORE INSERT OR UPDATE OF jrn_def_id ON rapport_advanced.formulaire_param_detail FOR EACH ROW EXECUTE PROCEDURE rapport_advanced.formulaire_param_detail_jrn_def_id_ins_upd(); + +ALTER TABLE rapport_advanced.formulaire_param_detail ADD CONSTRAINT formulaire_param_detail_jrn_def_id_fkey FOREIGN KEY (jrn_def_id) REFERENCES jrn_def (jrn_def_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; + + + +alter table rapport_advanced.formulaire_param_detail add column date_paid integer default 0; +alter table rapport_advanced.restore_formulaire_param_detail add column date_paid integer default 0; + +insert into rapport_advanced.version(version_id,version_note) values (4,'Ajout date et journaux dans les formules'); + +commit; --- PhpCompta est un logiciel de comptabilité libre en ligne (full web) Projet opensource http://www.phpcompta.eu _______________________________________________ Phpcompta est un logiciel libre de comptabilité en ligne (http://www.phpcompta.eu) Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
