[Phpcompta-dev] r438 - in trunk: coprop/sql rapport_avance/doc

[phpcompta-dev]

Author: danydb
Date: 2012-10-02 19:30:29 +0200 (Tue, 02 Oct 2012)
New Revision: 438

Added:
   trunk/coprop/sql/upgrade2.sql
Removed:
   trunk/coprop/sql/upgrade1.sql
Modified:
   trunk/rapport_avance/doc/
Log:
Upgrade SQL for next version

Deleted: trunk/coprop/sql/upgrade1.sql
===================================================================
--- trunk/coprop/sql/upgrade1.sql       2012-10-02 17:29:36 UTC (rev 437)
+++ trunk/coprop/sql/upgrade1.sql       2012-10-02 17:30:29 UTC (rev 438)
@@ -1,22 +0,0 @@
-begin;
-
-create table coprop.version
-(
-    v_id  bigint,
-    v_note text,
-    v_date date default now(),
-       CONSTRAINT version_pkey PRIMARY KEY (v_id )
-);
-
--- alter table budget
-alter table coprop.budget drop column b_end;
-alter table coprop.budget drop column b_start;
-alter table coprop.budget add column b_exercice bigint;
-alter table coprop.budget add column b_type varchar(8);
-insert into coprop.parameter values ('categorie_charge','0');
-
-
-commit;
-
-
-

Copied: trunk/coprop/sql/upgrade2.sql (from rev 432, 
trunk/coprop/sql/upgrade1.sql)
===================================================================
--- trunk/coprop/sql/upgrade2.sql                               (rev 0)
+++ trunk/coprop/sql/upgrade2.sql       2012-10-02 17:30:29 UTC (rev 438)
@@ -0,0 +1,8 @@
+begin;
+
+insert into coprop.version (v_id,v_note) values (2,'Ajout catégorie de 
charges');
+
+commit;
+
+
+


Property changes on: trunk/rapport_avance/doc
___________________________________________________________________
Name: svn:ignore
   + .~lock.rapav.odt#




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