SF.net SVN: ledger-smb: [2150] trunk/sql

[..hidden..]

Revision: 2150
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2150&view=rev
Author:   einhverfr
Date:     2008-05-17 14:38:10 -0700 (Sat, 17 May 2008)

Log Message:
-----------
Correcting all load errors for all working scripts on Pg 8.1.x and above.

Modified Paths:
--------------
    trunk/sql/Pg-database.sql
    trunk/sql/modules/Payment.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2008-05-17 19:17:43 UTC (rev 2149)
+++ trunk/sql/Pg-database.sql	2008-05-17 21:38:10 UTC (rev 2150)
@@ -78,7 +78,7 @@
   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 @@
 
 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);
 
 

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2008-05-17 19:17:43 UTC (rev 2149)
+++ trunk/sql/modules/Payment.sql	2008-05-17 21:38:10 UTC (rev 2150)
@@ -385,8 +385,12 @@
 	
 				CASE WHEN t_voucher_id IS NULL THEN true
 				ELSE false END,
-				t_voucher_id, in_payment_date, in_source),
+				t_voucher_id, in_payment_date, in_source);
 
+		INSERT INTO acc_trans 
+			(trans_id, chart_id, amount, approved, voucher_id,
+			transdate, source)
+		VALUES
 			(in_transactions[out_count][1], 
 				case when in_account_class = 1 THEN t_ar_ap_id
 				WHEN in_account_class = 2 THEN t_cash_id
@@ -743,7 +747,11 @@
 			in_date_reversed, in_source, 'Reversing ' || 
 			COALESCE(in_source, ''), 
 			case when in_batch_id is not null then false 
-			else true end, t_voucher_id),
+			else true end, t_voucher_id);
+		INSERT INTO acc_trans
+		(trans_id, chart_id, amount, transdate, source, memo, approved,
+			voucher_id) 
+		VALUES 
 		(pay_row.trans_id, pay_row.ar_ap_account_id, pay_row.amount,
 			in_date_reversed, in_source, 'Reversing ' ||
 			COALESCE(in_source, ''), 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.