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

[phpcompta-dev]

Author: danydb
Date: 2013-12-10 15:39:08 +0100 (Tue, 10 Dec 2013)
New Revision: 605

Added:
   trunk/rapport_avance/sql/2-listing_compute_historique.sql
Log:
task #932 : Listing Ajout Historique
Create table
Task #932 - Listing : ajout op?\195?\169ration Historique

Added: trunk/rapport_avance/sql/2-listing_compute_historique.sql
===================================================================
--- trunk/rapport_avance/sql/2-listing_compute_historique.sql                   
        (rev 0)
+++ trunk/rapport_avance/sql/2-listing_compute_historique.sql   2013-12-10 
14:39:08 UTC (rev 605)
@@ -0,0 +1,30 @@
+
+ALTER TABLE rapport_advanced.listing_param ADD COLUMN lp_paid text;
+COMMENT ON COLUMN rapport_advanced.listing_param.lp_paid IS 'used by 
Listing_Compute_Historique';
+
+-- Table: rapport_advanced.listing_compute_historique
+
+-- DROP TABLE rapport_advanced.listing_compute_historique;
+
+CREATE TABLE rapport_advanced.listing_compute_historique
+(
+  lh_id bigserial NOT NULL, -- PK
+  ld_id bigint, -- FK to listing_compute_detail
+  jr_id bigint, -- FK to jrn
+  CONSTRAINT listing_compute_historique_pkey PRIMARY KEY (lh_id ),
+  CONSTRAINT listing_compute_historique_jr_id_fkey FOREIGN KEY (jr_id)
+      REFERENCES jrn (jr_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT listing_compute_historique_ld_id_fkey FOREIGN KEY (ld_id)
+      REFERENCES rapport_advanced.listing_compute_detail (ld_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY IMMEDIATE
+)
+WITH (
+  OIDS=FALSE
+);
+COMMENT ON TABLE rapport_advanced.listing_compute_historique
+  IS 'Content : history of operation for a detail';
+COMMENT ON COLUMN rapport_advanced.listing_compute_historique.lh_id IS 'PK';
+COMMENT ON COLUMN rapport_advanced.listing_compute_historique.ld_id IS 'FK to 
listing_compute_detail';
+COMMENT ON COLUMN rapport_advanced.listing_compute_historique.jr_id IS 'FK to 
jrn';
+



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