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

[..hidden..]

Revision: 3429
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3429&view=rev
Author:   ehuelsmann
Date:     2011-07-04 20:31:12 +0000 (Mon, 04 Jul 2011)

Log Message:
-----------
Fix database creation on PostgreSQL 8.4 (syntax error in tax_extended table).

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-07-04 19:44:31 UTC (rev 3428)
+++ trunk/sql/Pg-database.sql	2011-07-04 20:31:12 UTC (rev 3429)
@@ -3430,8 +3430,7 @@
 CREATE TABLE tax_extended (
     tax_basis numeric,
     rate numeric,
-    entry_id int primary key,
-    foreign key entry_id references acc_trans(entry_id)
+    entry_id int primary key references acc_trans(entry_id)
 );
 
 COMMENT ON TABLE tax_extended IS 


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