[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r337 - trunk/coprop/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r337 - trunk/coprop/sql |
Date: |
Tue, 3 Apr 2012 14:50:01 +0200 (CEST) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r337 - trunk/coprop/sql,
phpcompta-dev <=