diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-01-09 22:35:21 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-01-09 22:35:21 +0000 |
| commit | 428f6a8085fdef7360473a4c9328766064475324 (patch) | |
| tree | 0312ff5ff970ecbb4f45aa72da4c5cf2ee76a3f6 /sql | |
| parent | 7f92c3efa77d327d078a4974e0dd89e353662198 (diff) | |
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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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 |