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

[..hidden..]

Revision: 576
          http://svn.sourceforge.net/ledger-smb/?rev=576&view=rev
Author:   tetragon
Date:     2006-11-13 20:07:37 -0800 (Mon, 13 Nov 2006)

Log Message:
-----------
Syntax fixes

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2006-11-14 04:00:21 UTC (rev 575)
+++ trunk/sql/Pg-database.sql	2006-11-14 04:07:37 UTC (rev 576)
@@ -250,7 +250,7 @@
   taxcategory_id serial PRIMARY KEY,
   taxcategoryname text NOT NULL,
   taxmodule_id int NOT NULL,
-  FOREIGN KEY taxmodule_id REFERENCES taxmodule (taxmodule_id)
+  FOREIGN KEY (taxmodule_id) REFERENCES taxmodule (taxmodule_id)
 );
 --
 CREATE TABLE partstax (
@@ -258,9 +258,9 @@
   chart_id int,
   taxcategory_id int,
   PRIMARY KEY (parts_id, chart_id),
-  FOREIGN KEY parts_id REFERENCES parts (id),
-  FOREIGN KEY chart_id REFERENCES chart (id),
-  FOREIGN KEY taxcategory_id REFERENCES taxcategory (taxcategory_id)
+  FOREIGN KEY (parts_id) REFERENCES parts (id),
+  FOREIGN KEY (chart_id) REFERENCES chart (id),
+  FOREIGN KEY (taxcategory_id) REFERENCES taxcategory (taxcategory_id)
 );
 --
 CREATE TABLE tax (
@@ -815,7 +815,6 @@
 --
 create index jcitems_id_key on jcitems (id);
 
-CREATE LANGUAGE plpgsql;
 --
 CREATE FUNCTION del_yearend() RETURNS OPAQUE AS '
 begin


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