[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [598] trunk/sql
- Subject: SF.net SVN: ledger-smb: [598] trunk/sql
- From: ..hidden..
- Date: Tue, 14 Nov 2006 13:29:33 -0800
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.