SF.net SVN: ledger-smb:[2969] trunk/sql/modules/test/Voucher.sql

[..hidden..]

Revision: 2969
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2969&view=rev
Author:   einhverfr
Date:     2010-03-16 16:47:20 +0000 (Tue, 16 Mar 2010)

Log Message:
-----------
Correcting Alexey's error in voucher tests

Modified Paths:
--------------
    trunk/sql/modules/test/Voucher.sql

Modified: trunk/sql/modules/test/Voucher.sql
===================================================================
--- trunk/sql/modules/test/Voucher.sql	2010-03-16 16:36:34 UTC (rev 2968)
+++ trunk/sql/modules/test/Voucher.sql	2010-03-16 16:47:20 UTC (rev 2969)
@@ -12,9 +12,11 @@
 
 INSERT INTO entity_employee(entity_id) values (-3);
 
-INSERT INTO chart (id, accno, description, link, charttype, category)
-VALUES ('-5', '-21111', 'Testing AP', 'AP', 'A', 'A');
+INSERT INTO account(id, accno, description, category, heading, contra)
+values (-5, '-21111', 'Testing AP', 'A', (select id from account_heading WHERE accno  = '000000000000000000000'), false);
 
+INSERT INTO account_link(account_id, description) values (-5, 'AP');
+
 INSERT INTO ap (id, invnumber, amount, curr, approved, entity_credit_account)
 VALUES (-5, 'test1', '1000', 'USD', false, -1);
 


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