From 428f6a8085fdef7360473a4c9328766064475324 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Wed, 9 Jan 2008 22:35:21 +0000 Subject: Correcting trial balance and gl report not to pull unapproved transactions git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2031 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 1fedb884..b42293f6 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -475,7 +475,7 @@ CREATE TABLE entity_credit_account ( primary_contact int references person(id), ar_ap_account_id int references chart(id), cash_account_id int references chart(id), - PRIMARY KEY(entity_id, meta_number, entity_class), + PRIMARY KEY(entity_id, meta_number, entity_class) ); CREATE UNIQUE INDEX entity_credit_ar_accno_idx_u @@ -489,7 +489,7 @@ $$This index is used to ensure that AR accounts are not reused.$$; INSERT INTO entity (name, entity_class) values ('Inventory Entity', 1); INSERT INTO company (legal_name, entity_id) -values ('Inventory Entity', currval('entity_id_seq'); +values ('Inventory Entity', currval('entity_id_seq')); INSERT INTO entity_credit_account (entity_id, meta_number, entity_class) VALUES -- cgit v1.2.3