diff options
| author | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-11-14 04:07:37 +0000 |
|---|---|---|
| committer | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-11-14 04:07:37 +0000 |
| commit | 010ef83cd63ad0e583dd33c16422c9c51e5e9660 (patch) | |
| tree | 950e6464b24771a6e8f6c463a769274c3de1840b /sql | |
| parent | f832ee70ab801487548a610e37690c6bc354b219 (diff) | |
Syntax fixes
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@576 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 9 |
1 files changed, 4 insertions, 5 deletions
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 |