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

[phpcompta-dev]

Author: danydb
Date: 2013-12-03 21:39:47 +0100 (Tue, 03 Dec 2013)
New Revision: 598

Modified:
   trunk/rapport_avance/sql/
   trunk/rapport_avance/sql/2-listing_compute.sql
   trunk/rapport_avance/sql/2-listing_compute_detail.sql
   trunk/rapport_avance/sql/2-listing_compute_fiche.sql
Log:
backup tables


Property changes on: trunk/rapport_avance/sql
___________________________________________________________________
Name: svn:ignore
   + .2-listing_compute.sql.kate-swp
.2-listing_compute_detail.sql.kate-swp
.2-listing_compute_fiche.sql.kate-swp


Modified: trunk/rapport_avance/sql/2-listing_compute.sql
===================================================================
--- trunk/rapport_avance/sql/2-listing_compute.sql      2013-12-03 04:34:45 UTC 
(rev 597)
+++ trunk/rapport_avance/sql/2-listing_compute.sql      2013-12-03 20:39:47 UTC 
(rev 598)
@@ -31,3 +31,14 @@
 COMMENT ON COLUMN rapport_advanced.listing_compute.l_end IS 'end_date';
 COMMENT ON COLUMN rapport_advanced.listing_compute.l_keep IS 'If yes, it is 
keeped with N it will deleted';
 
+
+-- Trigger: listing_compute_trg on rapport_advanced.listing_compute
+
+-- DROP TRIGGER listing_compute_trg ON rapport_advanced.listing_compute;
+
+CREATE TRIGGER listing_compute_trg
+  BEFORE INSERT OR UPDATE
+  ON rapport_advanced.listing_compute
+  FOR EACH ROW
+  EXECUTE PROCEDURE rapport_advanced.listing_compute_trg();
+

Modified: trunk/rapport_avance/sql/2-listing_compute_detail.sql
===================================================================
--- trunk/rapport_avance/sql/2-listing_compute_detail.sql       2013-12-03 
04:34:45 UTC (rev 597)
+++ trunk/rapport_avance/sql/2-listing_compute_detail.sql       2013-12-03 
20:39:47 UTC (rev 598)
@@ -53,3 +53,5 @@
   USING btree
   (lf_id );
 
+--
+--

Modified: trunk/rapport_avance/sql/2-listing_compute_fiche.sql
===================================================================
--- trunk/rapport_avance/sql/2-listing_compute_fiche.sql        2013-12-03 
04:34:45 UTC (rev 597)
+++ trunk/rapport_avance/sql/2-listing_compute_fiche.sql        2013-12-03 
20:39:47 UTC (rev 598)
@@ -9,7 +9,11 @@
   lf_lob oid, -- Generated file if any
   lf_filename text, -- Name of the generated file. It should be based on the 
name of the template + unique id
   lf_mimetype text, -- Same mimetype as in table listing
+  lc_id bigint,
   CONSTRAINT listing_compute_fiche_pkey PRIMARY KEY (lf_id ),
+  CONSTRAINT fk_listing_compute_lc_id FOREIGN KEY (lc_id)
+      REFERENCES rapport_advanced.listing_compute (lc_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
   CONSTRAINT listing_compute_fiche_f_id_fkey FOREIGN KEY (f_id)
       REFERENCES fiche (f_id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE CASCADE



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