From 010ef83cd63ad0e583dd33c16422c9c51e5e9660 Mon Sep 17 00:00:00 2001
From: tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Tue, 14 Nov 2006 04:07:37 +0000
Subject: Syntax fixes

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@576 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Pg-database.sql | 9 ++++-----
 1 file changed, 4 insertions(+), 5 deletions(-)

(limited to 'sql')

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index b7d23a3d..5a799b18 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -250,7 +250,7 @@ CREATE TABLE taxcategory (
   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 @@ CREATE TABLE partstax (
   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 unique index language_code_key on language (code);
 --
 create index jcitems_id_key on jcitems (id);
 
-CREATE LANGUAGE plpgsql;
 --
 CREATE FUNCTION del_yearend() RETURNS OPAQUE AS '
 begin
-- 
cgit v1.2.3