SF.net SVN: ledger-smb: [2008] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 2008
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2008&view=rev
Author:   einhverfr
Date:     2007-12-27 15:58:16 -0800 (Thu, 27 Dec 2007)

Log Message:
-----------
Adding missing voucher_id field to Pg-database.sql

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-12-27 21:15:18 UTC (rev 2007)
+++ trunk/sql/Pg-database.sql	2007-12-27 23:58:16 UTC (rev 2008)
@@ -375,6 +375,7 @@
   approved bool default true,
   cleared_on date,
   reconciled_on date,
+  voucher_id int references voucher(id),
   entry_id SERIAL PRIMARY KEY
 );
 --
@@ -688,10 +689,10 @@
   chart_id int PRIMARY KEY,
   rate numeric,
   taxnumber text,
-  validto date,
+  validto timestamp default 'infinity',
   pass integer DEFAULT 0 NOT NULL,
   taxmodule_id int DEFAULT 1 NOT NULL,
-  FOREIGN KEY (chart_id) REFERENCES chart (id),
+  FOREIGN KEY (chart_id) REFERENCES chart (id, validto),
   FOREIGN KEY (taxmodule_id) REFERENCES taxmodule (taxmodule_id)
 );
 --


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.