SF.net SVN: ledger-smb:[2968] trunk/sql/modules/test/data/Reconciliation. sql

[..hidden..]

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

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

Modified Paths:
--------------
    trunk/sql/modules/test/data/Reconciliation.sql

Modified: trunk/sql/modules/test/data/Reconciliation.sql
===================================================================
--- trunk/sql/modules/test/data/Reconciliation.sql	2010-03-15 19:26:12 UTC (rev 2967)
+++ trunk/sql/modules/test/data/Reconciliation.sql	2010-03-16 16:36:34 UTC (rev 2968)
@@ -1,8 +1,11 @@
 -- To run from other transaction test scripts!
 
-INSERT INTO chart (id, accno, description, category, charttype) values (-200, '-11111', 'Test Acct 1', 'A', 'A');
-INSERT INTO chart (id, accno, description, category, charttype) values (-201, '-11112', 'Test Acct 2', 'A', 'A');
+INSERT INTO account(id, accno, description, category, heading, contra)
+values (-200, '-11111', 'Test Act 1', 'A', (select id from account_heading WHERE accno  = '000000000000000000000'), false);
 
+INSERT INTO account(id, accno, description, category, heading, contra)
+values (-201, '-11112', 'Test Act 1', 'A', (select id from account_heading WHERE accno  = '000000000000000000000'), false);
+
 INSERT INTO entity (id, control_code, name, entity_class, country_id) values (-201, '-11111', 'Test 1', 1, 242);
 
 INSERT INTO entity_credit_account (entity_id, id, meta_number, entity_class, ar_ap_account_id) values (-201, -200, 'T-11111', 1, -1000);


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