[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r548 - tag/rel700/rapport_avance/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r548 - tag/rel700/rapport_avance/sql |
Date: |
Wed, 23 Oct 2013 21:19:05 +0200 (CEST) |
Author: danydb
Date: 2013-10-23 21:19:05 +0200 (Wed, 23 Oct 2013)
New Revision: 548
Modified:
tag/rel700/rapport_avance/sql/upgrade4.sql
Log:
rapav: Correct script upgrade
Modified: tag/rel700/rapport_avance/sql/upgrade4.sql
===================================================================
--- tag/rel700/rapport_avance/sql/upgrade4.sql 2013-10-23 19:14:48 UTC (rev
547)
+++ tag/rel700/rapport_avance/sql/upgrade4.sql 2013-10-23 19:19:05 UTC (rev
548)
@@ -3,7 +3,7 @@
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
+CREATE FUNCTION rapport_advanced.formulaire_param_detail_jrn_def_id_ins_upd()
RETURNS trigger
AS $$
declare
jrn_def_id integer;
@@ -13,7 +13,8 @@
NEW.jrn_def_id := jrn_def_id;
end if;
return NEW;
-end;$$;
+end;
+$$
language plpgsql;
CREATE INDEX fki_jrn_def_id ON rapport_advanced.formulaire_param_detail USING
btree (jrn_def_id);
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r548 - tag/rel700/rapport_avance/sql,
phpcompta-dev <=