From f62f4e8a8bc9cabe957d06be2f4fc1ddb21260a6 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sat, 17 May 2008 21:38:10 +0000
Subject: 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
---
 sql/Pg-database.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'sql/Pg-database.sql')

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);
 
 
-- 
cgit v1.2.3

