[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



Revision: 598
          http://svn.sourceforge.net/ledger-smb/?rev=598&view=rev
Author:   einhverfr
Date:     2006-11-14 13:29:33 -0800 (Tue, 14 Nov 2006)

Log Message:
-----------
Fixed defaults in numerous CoA's

Modified Paths:
--------------
    trunk/sql/Australia_General_0000-chart.sql
    trunk/sql/Australia_General_00000-chart.sql
    trunk/sql/Bahasa-Indonesia_Default-chart.sql
    trunk/sql/Belgium-chart.sql
    trunk/sql/Brazil_General-chart.sql
    trunk/sql/Canada-Quebec_General-UTF8-chart.sql
    trunk/sql/Colombia-PUC-chart.sql
    trunk/sql/Colombia-utf8-PUC-chart.sql
    trunk/sql/Czech-Republic-chart.sql
    trunk/sql/Danish_Default-chart.sql
    trunk/sql/Dutch_Default-chart.sql
    trunk/sql/Dutch_Standard-chart.sql
    trunk/sql/Egypt-UTF8-chart.sql
    trunk/sql/France-chart.sql
    trunk/sql/German-Sample-chart.sql
    trunk/sql/Germany-DATEV-SKR03-chart.sql
    trunk/sql/Germany-SKR03-chart.sql
    trunk/sql/Hungary-chart.sql
    trunk/sql/Italy_General-chart.sql
    trunk/sql/Latvia-chart.sql
    trunk/sql/Norwegian_Default-chart.sql
    trunk/sql/Paraguay-chart.sql
    trunk/sql/Poland-chart.sql
    trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql
    trunk/sql/Simplified-Chinese_Default-chart.sql
    trunk/sql/Spain-ISO-chart.sql
    trunk/sql/Spain-UTF8-chart.sql
    trunk/sql/Sweden-chart.sql
    trunk/sql/Sweden_Agriculture-chart.sql
    trunk/sql/Sweden_Church_Society-chart.sql
    trunk/sql/Swiss-German-chart.sql
    trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql
    trunk/sql/Traditional-Chinese_Default-chart.sql
    trunk/sql/UCOA-Form990-chart.sql
    trunk/sql/UCOA-Form990EZ-chart.sql
    trunk/sql/UK_General-chart.sql
    trunk/sql/US_Manufacturing-chart.sql
    trunk/sql/US_Service_Company-chart.sql
    trunk/sql/Venezuela_Default-chart.sql

Modified: trunk/sql/Australia_General_0000-chart.sql
===================================================================
--- trunk/sql/Australia_General_0000-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Australia_General_0000-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -109,9 +109,9 @@
 INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '1230'), 0.1, '');
 INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2290'), 0.1, '');
 --
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '1520'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5020'));
 

Modified: trunk/sql/Australia_General_00000-chart.sql
===================================================================
--- trunk/sql/Australia_General_00000-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Australia_General_00000-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -76,7 +76,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '15001'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '40001'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '40001'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '50001'));
 

Modified: trunk/sql/Bahasa-Indonesia_Default-chart.sql
===================================================================
--- trunk/sql/Bahasa-Indonesia_Default-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Bahasa-Indonesia_Default-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -71,7 +71,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
 

Modified: trunk/sql/Belgium-chart.sql
===================================================================
--- trunk/sql/Belgium-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Belgium-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -430,9 +430,10 @@
 INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '451541'), 0.21);
 INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '640700'), 0.21);
 --
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '340'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT 
+id FROM chart WHERE accno = '340'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '743200'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '743200'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '604'));
 

Modified: trunk/sql/Brazil_General-chart.sql
===================================================================
--- trunk/sql/Brazil_General-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Brazil_General-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -68,7 +68,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
 

Modified: trunk/sql/Canada-Quebec_General-UTF8-chart.sql
===================================================================
--- trunk/sql/Canada-Quebec_General-UTF8-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Canada-Quebec_General-UTF8-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -77,7 +77,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
 

Modified: trunk/sql/Colombia-PUC-chart.sql
===================================================================
--- trunk/sql/Colombia-PUC-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Colombia-PUC-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -769,9 +769,10 @@
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100001'), 0.16);
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100002'), 0.07);
 
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '141005001'));
+ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', 
+SELECT id FROM chart WHERE accno = '141005001'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5250150001'));
 

Modified: trunk/sql/Colombia-utf8-PUC-chart.sql
===================================================================
--- trunk/sql/Colombia-utf8-PUC-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Colombia-utf8-PUC-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -769,9 +769,10 @@
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100001'), 0.16);
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100002'), 0.07);
 
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '141005001'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', 
+(SELECT id FROM chart WHERE accno = '141005001'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5250150001'));
 

Modified: trunk/sql/Czech-Republic-chart.sql
===================================================================
--- trunk/sql/Czech-Republic-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Czech-Republic-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -315,7 +315,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '13200'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '60000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '60000'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '50000'));
 

Modified: trunk/sql/Danish_Default-chart.sql
===================================================================
--- trunk/sql/Danish_Default-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Danish_Default-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -73,7 +73,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
 

Modified: trunk/sql/Dutch_Default-chart.sql
===================================================================
--- trunk/sql/Dutch_Default-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Dutch_Default-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -78,7 +78,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
 

Modified: trunk/sql/Dutch_Standard-chart.sql
===================================================================
--- trunk/sql/Dutch_Standard-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Dutch_Standard-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -231,7 +231,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '7001'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '8520'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '8520'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '8010'));
 

Modified: trunk/sql/Egypt-UTF8-chart.sql
===================================================================
--- trunk/sql/Egypt-UTF8-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Egypt-UTF8-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -72,9 +72,9 @@
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5790','ÙØØÙÙ','A','E','AP_amount','');
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2280','ØØØØØ ÙØØØØØ ÙØØØÙØ','A','L','','');
 
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '1520'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5010'));
 

Modified: trunk/sql/France-chart.sql
===================================================================
--- trunk/sql/France-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/France-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -949,7 +949,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '681730'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '707000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '707000'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '601000'));
 

Modified: trunk/sql/German-Sample-chart.sql
===================================================================
--- trunk/sql/German-Sample-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/German-Sample-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -214,7 +214,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1140'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '8120'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '8120'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5800'));
 

Modified: trunk/sql/Germany-DATEV-SKR03-chart.sql
===================================================================
--- trunk/sql/Germany-DATEV-SKR03-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Germany-DATEV-SKR03-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -220,7 +220,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '0398000'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '0840000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '0840000'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '0399000'));
 

Modified: trunk/sql/Germany-SKR03-chart.sql
===================================================================
--- trunk/sql/Germany-SKR03-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Germany-SKR03-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -262,7 +262,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '7140'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '8400'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '8400'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4700'));
 

Modified: trunk/sql/Hungary-chart.sql
===================================================================
--- trunk/sql/Hungary-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Hungary-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -45,9 +45,10 @@
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4672'),'0.05','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4673'),'0','');
 --
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '2110'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', 
+(SELECT id FROM chart WHERE accno = '2110'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '9110'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '9110'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '8140'));
 

Modified: trunk/sql/Italy_General-chart.sql
===================================================================
--- trunk/sql/Italy_General-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Italy_General-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -177,7 +177,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3020005'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '8005005'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '8005005'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7005005'));
 

Modified: trunk/sql/Latvia-chart.sql
===================================================================
--- trunk/sql/Latvia-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Latvia-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -251,7 +251,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1230'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '6010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '6010'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7110'));
 

Modified: trunk/sql/Norwegian_Default-chart.sql
===================================================================
--- trunk/sql/Norwegian_Default-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Norwegian_Default-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -295,7 +295,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1250'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '3010'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4010'));
 

Modified: trunk/sql/Paraguay-chart.sql
===================================================================
--- trunk/sql/Paraguay-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Paraguay-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -249,9 +249,10 @@
 --
 INSERT INTO tax (chart_id,rate) VALUES ((select id from chart where accno = '2.151'),'0.1');
 --
- SET inventory_accno_id = (select id from chart where accno = '1.141'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', 
+(select id from chart where accno = '1.141'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4.110'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4.110'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5.110.01'));
 

Modified: trunk/sql/Poland-chart.sql
===================================================================
--- trunk/sql/Poland-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Poland-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -333,7 +333,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '333000000'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '773010000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '773010000'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '773110000'));
 

Modified: trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -76,7 +76,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
 

Modified: trunk/sql/Simplified-Chinese_Default-chart.sql
===================================================================
--- trunk/sql/Simplified-Chinese_Default-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Simplified-Chinese_Default-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -76,7 +76,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
 

Modified: trunk/sql/Spain-ISO-chart.sql
===================================================================
--- trunk/sql/Spain-ISO-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Spain-ISO-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -130,7 +130,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '300000000'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '700000000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '700000000'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '600000000'));
 

Modified: trunk/sql/Spain-UTF8-chart.sql
===================================================================
--- trunk/sql/Spain-UTF8-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Spain-UTF8-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -130,7 +130,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '300000000'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '700000000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '700000000'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '600000000'));
 

Modified: trunk/sql/Sweden-chart.sql
===================================================================
--- trunk/sql/Sweden-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Sweden-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -1136,7 +1136,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno ='1400'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '3010'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4010'));
 

Modified: trunk/sql/Sweden_Agriculture-chart.sql
===================================================================
--- trunk/sql/Sweden_Agriculture-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Sweden_Agriculture-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -1299,7 +1299,7 @@
 
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno ='1400'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3011'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '3011'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4010'));
 

Modified: trunk/sql/Sweden_Church_Society-chart.sql
===================================================================
--- trunk/sql/Sweden_Church_Society-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Sweden_Church_Society-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -229,7 +229,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno ='1130'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3400'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '3400'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4400'));
 

Modified: trunk/sql/Swiss-German-chart.sql
===================================================================
--- trunk/sql/Swiss-German-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Swiss-German-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -158,7 +158,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '11121'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '34002'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '34002'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '42005'));
 

Modified: trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -76,7 +76,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
 

Modified: trunk/sql/Traditional-Chinese_Default-chart.sql
===================================================================
--- trunk/sql/Traditional-Chinese_Default-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Traditional-Chinese_Default-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -76,7 +76,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
 

Modified: trunk/sql/UCOA-Form990-chart.sql
===================================================================
--- trunk/sql/UCOA-Form990-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/UCOA-Form990-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -227,7 +227,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1410'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4010'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7510'));
 

Modified: trunk/sql/UCOA-Form990EZ-chart.sql
===================================================================
--- trunk/sql/UCOA-Form990EZ-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/UCOA-Form990EZ-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -227,7 +227,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1410'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4010'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4010'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7510'));
 

Modified: trunk/sql/UK_General-chart.sql
===================================================================
--- trunk/sql/UK_General-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/UK_General-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -105,9 +105,9 @@
 INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '2200'),0.175);
 INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '2205'),0.05);
 --
- SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '1001'));
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',  (SELECT id FROM chart WHERE accno = '1001'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '4000'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '4000'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5000'));
 

Modified: trunk/sql/US_Manufacturing-chart.sql
===================================================================
--- trunk/sql/US_Manufacturing-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/US_Manufacturing-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -80,7 +80,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5020'));
 

Modified: trunk/sql/US_Service_Company-chart.sql
===================================================================
--- trunk/sql/US_Service_Company-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/US_Service_Company-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -66,7 +66,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4410'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4410'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5020'));
 

Modified: trunk/sql/Venezuela_Default-chart.sql
===================================================================
--- trunk/sql/Venezuela_Default-chart.sql	2006-11-14 20:24:51 UTC (rev 597)
+++ trunk/sql/Venezuela_Default-chart.sql	2006-11-14 21:29:33 UTC (rev 598)
@@ -86,7 +86,7 @@
 --
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
 
- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));
+ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
 
  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5020'));
 


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