[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r563 - in trunk/rapport_avance: doc sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r563 - in trunk/rapport_avance: doc sql |
Date: |
Tue, 5 Nov 2013 17:21:24 +0100 (CET) |
Author: danydb
Date: 2013-11-05 17:21:23 +0100 (Tue, 05 Nov 2013)
New Revision: 563
Added:
trunk/rapport_avance/doc/listing-db.dia
trunk/rapport_avance/sql/1-add-listing.sql
Removed:
trunk/rapport_avance/sql/1-ajout-col-formulaire-param-detail.sql
trunk/rapport_avance/sql/2-date-paiement.sql
Modified:
trunk/rapport_avance/doc/rapav-analyse.dia
trunk/rapport_avance/doc/rapav-listing-code.odt
trunk/rapport_avance/doc/rapav.dia
Log:
update doc analyse
Added: trunk/rapport_avance/doc/listing-db.dia
===================================================================
(Binary files differ)
Property changes on: trunk/rapport_avance/doc/listing-db.dia
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Modified: trunk/rapport_avance/doc/rapav-analyse.dia
===================================================================
(Binary files differ)
Modified: trunk/rapport_avance/doc/rapav-listing-code.odt
===================================================================
(Binary files differ)
Modified: trunk/rapport_avance/doc/rapav.dia
===================================================================
--- trunk/rapport_avance/doc/rapav.dia 2013-11-05 10:54:27 UTC (rev 562)
+++ trunk/rapport_avance/doc/rapav.dia 2013-11-05 16:21:23 UTC (rev 563)
@@ -62,7 +62,7 @@
</dia:composite>
</dia:attribute>
</dia:diagramdata>
- <dia:layer name="Background" visible="true" active="true">
+ <dia:layer name="rapav" visible="true" active="true">
<dia:object type="UML - Class" version="0" id="O0">
<dia:attribute name="obj_pos">
<dia:point val="-0.621861,-22.15"/>
@@ -1245,13 +1245,13 @@
</dia:object>
<dia:object type="UML - Class" version="0" id="O4">
<dia:attribute name="obj_pos">
- <dia:point val="29.5167,-1.45"/>
+ <dia:point val="30.4167,-5.75"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="29.4667,-1.5;38.0692,5.8"/>
+ <dia:rectangle val="30.3667,-5.8;38.9692,1.5"/>
</dia:attribute>
<dia:attribute name="elem_corner">
- <dia:point val="29.5167,-1.45"/>
+ <dia:point val="30.4167,-5.75"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="8.5025000000000013"/>
@@ -2402,13 +2402,13 @@
</dia:object>
<dia:object type="UML - Class" version="0" id="O8">
<dia:attribute name="obj_pos">
- <dia:point val="63.6456,17.45"/>
+ <dia:point val="62.3956,0.55"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="63.5956,17.4;78.8681,29.5"/>
+ <dia:rectangle val="62.3456,0.5;77.6181,12.6"/>
</dia:attribute>
<dia:attribute name="elem_corner">
- <dia:point val="63.6456,17.45"/>
+ <dia:point val="62.3956,0.55"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="15.172499999999999"/>
@@ -3440,13 +3440,13 @@
</dia:object>
<dia:object type="UML - Class" version="0" id="O13">
<dia:attribute name="obj_pos">
- <dia:point val="65.8512,-9.7"/>
+ <dia:point val="43.1012,-13.75"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="65.8012,-9.75;86.4212,-5.65"/>
+ <dia:rectangle val="43.0512,-13.8;63.6712,-9.7"/>
</dia:attribute>
<dia:attribute name="elem_corner">
- <dia:point val="65.8512,-9.7"/>
+ <dia:point val="43.1012,-13.75"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="20.52"/>
@@ -3712,23 +3712,23 @@
</dia:object>
<dia:object type="UML - Constraint" version="0" id="O17">
<dia:attribute name="obj_pos">
- <dia:point val="29.5167,2.85"/>
+ <dia:point val="30.4167,-1.45"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="20.439,2.525;36.565,3.8023"/>
+ <dia:rectangle val="20.2925,-1.5169;37.015,3.78123"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="conn_endpoints">
- <dia:point val="29.5167,2.85"/>
+ <dia:point val="30.4167,-1.45"/>
<dia:point val="20.5133,3.4"/>
</dia:attribute>
<dia:attribute name="constraint">
<dia:string>#formulaire_param_p_type_fkey#</dia:string>
</dia:attribute>
<dia:attribute name="text_pos">
- <dia:point val="25.015,3.125"/>
+ <dia:point val="25.465,0.975"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000"/>
@@ -3743,23 +3743,23 @@
</dia:object>
<dia:object type="UML - Constraint" version="0" id="O18">
<dia:attribute name="obj_pos">
- <dia:point val="33.6778,-1.49998"/>
+ <dia:point val="34.2161,-5.7989"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="33.1001,-8.70988;44.3695,-1.44876"/>
+ <dia:rectangle val="33.4598,-8.74988;44.8195,-5.74313"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="conn_endpoints">
- <dia:point val="33.6778,-1.49998"/>
- <dia:point val="33.5012,-8.65002"/>
+ <dia:point val="34.2161,-5.7989"/>
+ <dia:point val="33.8629,-8.6511"/>
</dia:attribute>
<dia:attribute name="constraint">
<dia:string>#formulaire_param_f_id_fkey#</dia:string>
</dia:attribute>
<dia:attribute name="text_pos">
- <dia:point val="33.5895,-5.075"/>
+ <dia:point val="34.0395,-7.225"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000"/>
@@ -3774,23 +3774,23 @@
</dia:object>
<dia:object type="UML - Constraint" version="0" id="O19">
<dia:attribute name="obj_pos">
- <dia:point val="29.4664,0.870193"/>
+ <dia:point val="30.3669,-2.02719"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="20.4977,-4.24106;93.1264,0.932376"/>
+ <dia:rectangle val="20.5983,-5.68975;93.5766,-1.34874"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="conn_endpoints">
- <dia:point val="29.4664,0.870193"/>
+ <dia:point val="30.3669,-2.02719"/>
<dia:point val="20.6597,-1.75"/>
</dia:attribute>
<dia:attribute name="constraint">
<dia:string>#formulaire_param_t_id_fkey#</dia:string>
</dia:attribute>
<dia:attribute name="text_pos">
- <dia:point val="82.3464,-3.64106"/>
+ <dia:point val="82.7966,-5.08975"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000"/>
@@ -3805,23 +3805,23 @@
</dia:object>
<dia:object type="UML - Constraint" version="0" id="O20">
<dia:attribute name="obj_pos">
- <dia:point val="34.439,7.35496"/>
+ <dia:point val="35.0266,7.35049"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="33.8354,5.69913;47.8138,7.41094"/>
+ <dia:rectangle val="34.4041,1.43464;48.3911,7.40234"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="conn_endpoints">
- <dia:point val="34.439,7.35496"/>
- <dia:point val="34.2385,5.79987"/>
+ <dia:point val="35.0266,7.35049"/>
+ <dia:point val="34.8057,1.49969"/>
</dia:attribute>
<dia:attribute name="constraint">
<dia:string>#formulaire_param_detail_p_id_fkey#</dia:string>
</dia:attribute>
<dia:attribute name="text_pos">
- <dia:point val="34.3388,6.57741"/>
+ <dia:point val="34.9161,4.42509"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000"/>
@@ -3929,23 +3929,23 @@
</dia:object>
<dia:object type="UML - Constraint" version="0" id="O24">
<dia:attribute name="obj_pos">
- <dia:point val="63.6456,20.15"/>
+ <dia:point val="62.3956,3.25"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="57.3435,2.77278;69.5468,20.2135"/>
+ <dia:rectangle val="57.6625,2.5;68.9218,3.35239"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="conn_endpoints">
- <dia:point val="63.6456,20.15"/>
+ <dia:point val="62.3956,3.25"/>
<dia:point val="57.7381,2.95"/>
</dia:attribute>
<dia:attribute name="constraint">
<dia:string>#formulaire_param_fkey#</dia:string>
</dia:attribute>
<dia:attribute name="text_pos">
- <dia:point val="60.6918,11.55"/>
+ <dia:point val="60.0668,3.1"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000"/>
@@ -3959,4 +3959,5 @@
</dia:connections>
</dia:object>
</dia:layer>
+ <dia:layer name="listing" visible="true"/>
</dia:diagram>
Added: trunk/rapport_avance/sql/1-add-listing.sql
===================================================================
--- trunk/rapport_avance/sql/1-add-listing.sql (rev 0)
+++ trunk/rapport_avance/sql/1-add-listing.sql 2013-11-05 16:21:23 UTC (rev
563)
@@ -0,0 +1,29 @@
+create table rapport_advanced.listing
+(
+ l_id serial primary key,
+ l_description text,
+ l_lob oid,
+ l_mimetype text,
+ l_size bigint,
+ fd_id bigint references fiche_def (fd_id) on update cascade on delete null
+);
+create table rapport_advanced.listing_param
+(
+ lp_id serial primary key,
+ l_id bigint constraint fk_listing_param_listing references
rapport_advanced.listing(l_id) on update cascade on delete cascade,
+ lp_code text not null constraint c_lp_code check (length (trim(lp_code))> 0),
+ lp_comment text,
+ l_card int default 0,
+ l_order int
+);
+create table rapport_advanced.listing_param_detail
+(
+ ad_id bigint constraint fk_listing_param_detail_attr_def references
attr_def (ad_id),
+ lp_card_saldo char(1) check (lp_card_saldo in ('C','D','S',NULL)),
+ lp_with_card char (1) check (lp_with_card in ('Y','N')),
+ lp_id bigint constraint fk_listing_param_detail_listing_param references
rapport_advanced.listing_param (lp_id)
+) inherits (rapport_Advanced.formulaire_param_detail);
+
+--ALTER TABLE ONLY rapport_advanced.listing_param_detail
+ -- ADD CONSTRAINT listing_param_detail_p_type_fkey FOREIGN KEY (p_type)
REFERENCES rapport_advanced.type_row(p_type);
+
Deleted: trunk/rapport_avance/sql/1-ajout-col-formulaire-param-detail.sql
===================================================================
--- trunk/rapport_avance/sql/1-ajout-col-formulaire-param-detail.sql
2013-11-05 10:54:27 UTC (rev 562)
+++ trunk/rapport_avance/sql/1-ajout-col-formulaire-param-detail.sql
2013-11-05 16:21:23 UTC (rev 563)
@@ -1,24 +0,0 @@
-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
- AS $$
-declare
- jrn_def_id integer;
-begin
- if NEW.jrn_def_id = -1 then
- jrn_def_id=NULL;
- NEW.jrn_def_id := jrn_def_id;
- end if;
- return NEW;
-end;$$;
-language plpgsql;
-
-CREATE INDEX fki_jrn_def_id ON rapport_advanced.formulaire_param_detail USING
btree (jrn_def_id);
-
-CREATE TRIGGER formulaire_param_detail_trg BEFORE INSERT OR UPDATE OF
jrn_def_id ON rapport_advanced.formulaire_param_detail FOR EACH ROW EXECUTE
PROCEDURE rapport_advanced.formulaire_param_detail_jrn_def_id_ins_upd();
-
-ALTER TABLE rapport_advanced.formulaire_param_detail ADD CONSTRAINT
formulaire_param_detail_jrn_def_id_fkey FOREIGN KEY (jrn_def_id)
REFERENCES jrn_def (jrn_def_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE
SET NULL DEFERRABLE INITIALLY DEFERRED;
-
-
-
Deleted: trunk/rapport_avance/sql/2-date-paiement.sql
===================================================================
--- trunk/rapport_avance/sql/2-date-paiement.sql 2013-11-05 10:54:27 UTC
(rev 562)
+++ trunk/rapport_avance/sql/2-date-paiement.sql 2013-11-05 16:21:23 UTC
(rev 563)
@@ -1,2 +0,0 @@
-alter table rapport_advanced.formulaire_param_detail add column date_paid
integer default 0;
-alter table rapport_advanced.restore_formulaire_param_detail add column
date_paid integer default 0;
---
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] r563 - in trunk/rapport_avance: doc sql,
phpcompta-dev <=