[Phpcompta-dev] r501 - trunk/rapport_avance/sql

[phpcompta-dev]

Author: danydb
Date: 2013-05-15 20:50:31 +0200 (Wed, 15 May 2013)
New Revision: 501

Modified:
   trunk/rapport_avance/sql/upgrade3.sql
Log:
int?\195?\169gre script mise ?\195?\160 jour

Modified: trunk/rapport_avance/sql/upgrade3.sql
===================================================================
--- trunk/rapport_avance/sql/upgrade3.sql       2013-05-15 18:49:31 UTC (rev 
500)
+++ trunk/rapport_avance/sql/upgrade3.sql       2013-05-15 18:50:31 UTC (rev 
501)
@@ -1,3 +1,4 @@
+begin;
 ALTER TABLE rapport_advanced.formulaire ADD COLUMN f_lob oid;
 COMMENT ON COLUMN rapport_advanced.formulaire.f_lob IS 'OID for file';
 
@@ -36,3 +37,9 @@
 ALTER TABLE rapport_advanced.declaration_row ADD COLUMN dr_start date;
 
 ALTER TABLE rapport_advanced.declaration_row ADD COLUMN dr_end date;
+
+ALTER TABLE rapport_advanced.declaration ADD COLUMN d_description text;
+
+insert into rapport_advanced.version  
(version_id,version_note)values(3,'Génération de document');
+
+commit;
\ No newline at end of file



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu