[Phpcompta-dev] r337 - trunk/coprop/sql

[phpcompta-dev]

Author: danydb
Date: 2012-04-03 14:50:00 +0200 (Tue, 03 Apr 2012)
New Revision: 337

Added:
   trunk/coprop/sql/upgrade1.sql
Modified:
   trunk/coprop/sql/create_view_summary.sql
   trunk/coprop/sql/trunk_dev.sql
Log:
update coprop schema + backup dev

Modified: trunk/coprop/sql/create_view_summary.sql
===================================================================
--- trunk/coprop/sql/create_view_summary.sql    2012-04-03 12:40:38 UTC (rev 
336)
+++ trunk/coprop/sql/create_view_summary.sql    2012-04-03 12:50:00 UTC (rev 
337)
@@ -1,4 +1,4 @@
-CREATE OR REPLACE VIEW coprop.summary AS
+CREATE OR REPLACE VIEW coprop.summary AS 
  SELECT a.f_id AS lot_id, m.ad_value AS building_id, c.ad_value AS coprop_id
    FROM fiche_detail a
    JOIN fiche f1 ON f1.f_id = a.f_id
@@ -8,4 +8,4 @@
    JOIN ( SELECT fd1.f_id, fd1.ad_value
    FROM fiche_detail fd1
   WHERE fd1.ad_id = 71) c ON c.f_id = a.f_id
-  WHERE f1.fd_id = 8 AND a.ad_id = 1;
\ No newline at end of file
+  WHERE f1.fd_id = 8 AND a.ad_id = 1;

Modified: trunk/coprop/sql/trunk_dev.sql
===================================================================
--- trunk/coprop/sql/trunk_dev.sql      2012-04-03 12:40:38 UTC (rev 336)
+++ trunk/coprop/sql/trunk_dev.sql      2012-04-03 12:50:00 UTC (rev 337)
@@ -7696,8 +7696,8 @@
 -- Data for Name: clef_repartition; Type: TABLE DATA; Schema: coprop; Owner: -
 --
 
-INSERT INTO clef_repartition (cr_id, cr_name, cr_note, cr_tantieme) VALUES (5, 
'Charge Eau', 'Clef de répartition pour répartir les charges. 
-
+INSERT INTO clef_repartition (cr_id, cr_name, cr_note, cr_tantieme) VALUES (5, 
'Charge Eau', 'Clef de répartition pour répartir les charges. 
+
 Pour la Maison Horta', 6000);
 INSERT INTO clef_repartition (cr_id, cr_name, cr_note, cr_tantieme) VALUES (7, 
'Pau-BatA', 'Tantièmes Immeuble A', 10561);
 INSERT INTO clef_repartition (cr_id, cr_name, cr_note, cr_tantieme) VALUES 
(10, 'Charges chauffage bât B', '', 2000);

Added: trunk/coprop/sql/upgrade1.sql
===================================================================
--- trunk/coprop/sql/upgrade1.sql                               (rev 0)
+++ trunk/coprop/sql/upgrade1.sql       2012-04-03 12:50:00 UTC (rev 337)
@@ -0,0 +1,21 @@
+begin;
+
+create table coprop.version
+(
+    v_id  bigint,
+    v_note text,
+    v_date date default now()
+);
+
+-- 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 varchar(8) b_type;
+
+
+
+commit;
+
+
+



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