Correcting all load errors for all working scripts on Pg 8.1.x and above.

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2150 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 4 insertions, 2 deletions

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 26f5f29e..fc8e79a1 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -78,7 +78,7 @@ CREATE TABLE transactions (
   id int PRIMARY KEY,
   table_name text,
   locked_by int references "session" (session_id) ON DELETE SET NULL,
-  approved_by int references "users" (entity_id),
+  approved_by int references entity (id),
   approved_at timestamp
 );
 
@@ -504,7 +504,9 @@ values ('Inventory Entity', currval('entity_id_seq'));
 
 INSERT INTO entity_credit_account (entity_id, meta_number, entity_class)
 VALUES 
-(currval('entity_id_seq'), '00000', 1),
+(currval('entity_id_seq'), '00000', 1);
+INSERT INTO entity_credit_account (entity_id, meta_number, entity_class)
+VALUES 
 (currval('entity_id_seq'), '00000', 2);