[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r549 - in trunk: . rapport_avance/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r549 - in trunk: . rapport_avance/sql |
Date: |
Wed, 23 Oct 2013 21:19:57 +0200 (CEST) |
Author: danydb
Date: 2013-10-23 21:19:57 +0200 (Wed, 23 Oct 2013)
New Revision: 549
Modified:
trunk/
trunk/rapport_avance/sql/upgrade4.sql
Log:
Merged revisions 548 via svnmerge from
svn+ssh://address@hidden/svn_extension/tag/rel700
........
r548 | danydb | 2013-10-23 21:19:05 +0200 (mer., 23 oct. 2013) | 2 lines
rapav: Correct script upgrade
........
Property changes on: trunk
___________________________________________________________________
Name: svnmerge-integrated
- /tag/rel700:1-546
+ /tag/rel700:1-548
Modified: trunk/rapport_avance/sql/upgrade4.sql
===================================================================
--- trunk/rapport_avance/sql/upgrade4.sql 2013-10-23 19:19:05 UTC (rev
548)
+++ trunk/rapport_avance/sql/upgrade4.sql 2013-10-23 19:19:57 UTC (rev
549)
@@ -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] r549 - in trunk: . rapport_avance/sql,
phpcompta-dev <=