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

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

Revision: 418
          http://svn.sourceforge.net/ledger-smb/?rev=418&view=rev
Author:   einhverfr
Date:     2006-10-30 20:23:28 -0800 (Mon, 30 Oct 2006)

Log Message:
-----------
Finished converting CoA's...

Modified Paths:
--------------
    trunk/sql/Bahasa-Indonesia_Default-chart.sql
    trunk/sql/Belgium-chart.sql
    trunk/sql/Brazil_General-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/Italy_cc2424-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_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/Bahasa-Indonesia_Default-chart.sql
===================================================================
--- trunk/sql/Bahasa-Indonesia_Default-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Bahasa-Indonesia_Default-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -69,5 +69,17 @@
 --insert into tax (chart_id,rate) values ((select id from chart where accno = '2320'),0.14);
 --insert into tax (chart_id,rate) values ((select id from chart where accno = '2330'),0.3);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'IDR:USD:CAD:EUR', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '5010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'IDR:USD:CAD:EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Belgium-chart.sql
===================================================================
--- trunk/sql/Belgium-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Belgium-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -430,5 +430,16 @@
 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);
 --
-UPDATE defaults SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '340'), income_accno_id = (SELECT id FROM chart WHERE accno = '743200'), expense_accno_id = (SELECT id FROM chart WHERE accno = '604'), fxgain_accno_id = (SELECT id FROM chart WHERE accno = '755000'), fxloss_accno_id = (SELECT id FROM chart WHERE accno = '655000'), weightunit = 'kg', curr = 'EUR:USD';
+ 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 = '743200'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '604'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '755000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '655000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR:USD');
+

Modified: trunk/sql/Brazil_General-chart.sql
===================================================================
--- trunk/sql/Brazil_General-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Brazil_General-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -66,5 +66,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2320'),0.08);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'R  :EUR:USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '5010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'R  :EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/German-Sample-chart.sql
===================================================================
--- trunk/sql/German-Sample-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/German-Sample-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -212,5 +212,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '3805'),0.16);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '3806'),0.15);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1140'), income_accno_id = (select id from chart where accno = '8120'), expense_accno_id = (select id from chart where accno = '5800'), fxgain_accno_id = (select id from chart where accno = '8840'), fxloss_accno_id = (select id from chart where accno = '6880'), curr = 'EUR', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '5800'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '8840'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '6880'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Germany-DATEV-SKR03-chart.sql
===================================================================
--- trunk/sql/Germany-DATEV-SKR03-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Germany-DATEV-SKR03-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -218,7 +218,19 @@
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0840000','Erl\xF6se 16% USt.','A','I','AR_amount:IC_sale:IC_income','0840000');
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('950','R\xFCckstellungen','H','L','','');
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '0398000'), income_accno_id = (select id from chart where accno = '0840000'), expense_accno_id = (select id from chart where accno = '0399000'), fxgain_accno_id = (select id from chart where accno = '0266000'), fxloss_accno_id = (select id from chart where accno = '0215000'), curr = 'EUR:USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '0399000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '0266000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '0215000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
 INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '0157100'),0.07);
 INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '0157500'),0.16);

Modified: trunk/sql/Germany-SKR03-chart.sql
===================================================================
--- trunk/sql/Germany-SKR03-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Germany-SKR03-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -260,5 +260,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '3400'),0.16);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '8400'),0.16);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '7140'), income_accno_id = (select id from chart where accno = '8400'), expense_accno_id = (select id from chart where accno = '4700'), fxgain_accno_id = (select id from chart where accno = '8840'), fxloss_accno_id = (select id from chart where accno = '8840'), curr = 'EUR:USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '4700'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '8840'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '8840'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Hungary-chart.sql
===================================================================
--- trunk/sql/Hungary-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Hungary-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -45,4 +45,16 @@
 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','');
 --
-UPDATE defaults SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '2110'), income_accno_id = (SELECT id FROM chart WHERE accno = '9110'), expense_accno_id = (SELECT id FROM chart WHERE accno = '8140'), fxgain_accno_id = (SELECT id FROM chart WHERE accno = '9700'), fxloss_accno_id = (SELECT id FROM chart WHERE accno = '8700'), curr = 'HUF:EUR:USD', weightunit = 'kg';
+ 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 = '9110'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '8140'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '9700'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '8700'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'HUF:EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');

Modified: trunk/sql/Italy_General-chart.sql
===================================================================
--- trunk/sql/Italy_General-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Italy_General-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -175,5 +175,17 @@
 --
 -- update defaults
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '3020005'), income_accno_id = (select id from chart where accno = '8005005'), expense_accno_id = (select id from chart where accno = '7005005'), fxgain_accno_id = (select id from chart where accno = '9990000'), fxloss_accno_id = (select id from chart where accno = '9990010'), curr = 'EUR', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '7005005'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '9990000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '9990010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Italy_cc2424-chart.sql
===================================================================
--- trunk/sql/Italy_cc2424-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Italy_cc2424-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -259,11 +259,12 @@
 -- update defaults
 --
 
-UPDATE DEFAULTS SET inventory_accno_id = (select id from chart where accno = '105001');
-UPDATE DEFAULTS SET income_accno_id = (select id from chart where accno = '541001');
-UPDATE DEFAULTS SET expense_accno_id = (select id from chart where accno = '645001');
-UPDATE DEFAULTS SET fxgain_accno_id = (select id from chart where accno = '756011');
-UPDATE DEFAULTS SET fxloss_accno_id = (select id from chart where accno = '655011');
-UPDATE DEFAULTS SET curr = 'EUR';
-UPDATE DEFAULTS SET weightunit = 'kg';
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', 
+	(select id from chart where accno = '105001'));
+INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '541001'));
+INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '645001'));
+INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '756011'));
+INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '655011'));
+INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
+INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 

Modified: trunk/sql/Latvia-chart.sql
===================================================================
--- trunk/sql/Latvia-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Latvia-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -249,5 +249,17 @@
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2352'),'0.18','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2354'),'0.18','');
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1230'), income_accno_id = (select id from chart where accno = '6010'), expense_accno_id = (select id from chart where accno = '7110'), fxgain_accno_id = (select id from chart where accno = '8170'), fxloss_accno_id = (select id from chart where accno = '8270'), curr = 'LVL', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '7110'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '8170'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '8270'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'LVL');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+

Modified: trunk/sql/Norwegian_Default-chart.sql
===================================================================
--- trunk/sql/Norwegian_Default-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Norwegian_Default-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -293,5 +293,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2720'),0.24);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2725'),0.12);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1250'), income_accno_id = (select id from chart where accno = '3010'), expense_accno_id = (select id from chart where accno = '4010'), fxgain_accno_id = (select id from chart where accno = '8080'), fxloss_accno_id = (select id from chart where accno = '8180'), curr = 'NOK:EUR:USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '4010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '8080'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '8180'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'NOK:EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Paraguay-chart.sql
===================================================================
--- trunk/sql/Paraguay-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Paraguay-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -249,5 +249,17 @@
 --
 INSERT INTO tax (chart_id,rate) VALUES ((select id from chart where accno = '2.151'),'0.1');
 --
-UPDATE defaults SET inventory_accno_id = (select id from chart where accno = '1.141'), income_accno_id = (select id from chart where accno = '4.110'), expense_accno_id = (select id from chart where accno = '5.110.01'), fxgain_accno_id = (select id from chart where accno = '4.340'), fxloss_accno_id = (select id from chart where accno = '5.340'), curr = 'PYG:USD:EUR', weightunit = 'kg';
+ 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 = '4.110'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5.110.01'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4.340'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5.340'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'PYG:USD:EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Poland-chart.sql
===================================================================
--- trunk/sql/Poland-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Poland-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -331,7 +331,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '223030200'),0.07);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '223030300'),0);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '333000000'), income_accno_id = (select id from chart where accno = '773010000'), expense_accno_id = (select id from chart where accno = '773110000'), fxgain_accno_id = (select id from chart where accno = '775060000'), fxloss_accno_id = (select id from chart where accno = '775140000'), invnumber = '1000', sonumber = '1000', ponumber = '1000', curr = 'PLN:USD:EUR', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '773110000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '775060000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '775140000'), invnumber = '1000', sonumber = '1000', ponumber = '1000', curr = 'PLN:USD:EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
 
 

Modified: trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -74,5 +74,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'CAD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '5010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CAD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Simplified-Chinese_Default-chart.sql
===================================================================
--- trunk/sql/Simplified-Chinese_Default-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Simplified-Chinese_Default-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -74,5 +74,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'CAD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '5010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CAD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Spain-ISO-chart.sql
===================================================================
--- trunk/sql/Spain-ISO-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Spain-ISO-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -128,5 +128,17 @@
 --
 -- update defaults
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '300000000'), income_accno_id = (select id from chart where accno = '700000000'), expense_accno_id = (select id from chart where accno = '600000000'), fxgain_accno_id = (select id from chart where accno = '768000000'), fxloss_accno_id = (select id from chart where accno = '668000000'), curr = 'EUR', weightunit = 'Kg';
+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 ('expense_accno_id', (select id from chart where accno = '600000000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '768000000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '668000000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'Kg');
 --

Modified: trunk/sql/Spain-UTF8-chart.sql
===================================================================
--- trunk/sql/Spain-UTF8-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Spain-UTF8-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -128,6 +128,17 @@
 --
 -- update defaults
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '300000000'), income_accno_id = (select id from chart where accno = '700000000'), expense_accno_id = (select id from chart where accno = '600000000'), fxgain_accno_id = (select id from chart where accno = '768000000'), fxloss_accno_id = (select id from chart where accno = '668000000'), curr = 'EUR', weightunit  = 'Kg';
+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 ('expense_accno_id', (select id from chart where accno = '600000000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '768000000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '668000000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit' , 'Kg';
 --
 

Modified: trunk/sql/Sweden-chart.sql
===================================================================
--- trunk/sql/Sweden-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Sweden-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -1134,5 +1134,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2630'),0.06);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2640'),0);
 --
-update defaults set inventory_accno_id = (select id from chart where accno ='1400'), income_accno_id = (select id from chart where accno = '3010'), expense_accno_id = (select id from chart where accno = '4010'), fxgain_accno_id = (select id from chart where accno = '3960'), fxloss_accno_id = (select id from chart where accno = '7960'), curr = 'SEK:EUR:USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '4010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '3960'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '7960'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'SEK:EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+

Modified: trunk/sql/Sweden_Agriculture-chart.sql
===================================================================
--- trunk/sql/Sweden_Agriculture-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Sweden_Agriculture-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -1297,5 +1297,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2641'),0.25);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2645'),0.25);
 
-update defaults set inventory_accno_id = (select id from chart where accno ='1400'), income_accno_id = (select id from chart where accno = '3011'), expense_accno_id = (select id from chart where accno = '4010'), fxgain_accno_id = (select id from chart where accno = '3960'), fxloss_accno_id = (select id from chart where accno = '7960'), curr = 'SEK:EUR:USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '4010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '3960'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '7960'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'SEK:EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+

Modified: trunk/sql/Sweden_Church_Society-chart.sql
===================================================================
--- trunk/sql/Sweden_Church_Society-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Sweden_Church_Society-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -227,5 +227,17 @@
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('899','Redovisat resultat','H','','E','');
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8999','Redovisat resultat','A','','E','');
 --
-update defaults set inventory_accno_id = (select id from chart where accno ='1130'), income_accno_id = (select id from chart where accno = '3400'), expense_accno_id = (select id from chart where accno = '4400'), fxgain_accno_id = (select id from chart where accno = '3960'), fxloss_accno_id = (select id from chart where accno = '7960'), curr = 'SEK:EUR:USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '4400'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '3960'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '7960'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'SEK:EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+

Modified: trunk/sql/Swiss-German-chart.sql
===================================================================
--- trunk/sql/Swiss-German-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Swiss-German-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -156,5 +156,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '21221'),0.024);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '21224'),0.076);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '11121'), income_accno_id = (select id from chart where accno = '34002'), expense_accno_id = (select id from chart where accno = '42005'), fxgain_accno_id = (select id from chart where accno = '36005'), fxloss_accno_id = (select id from chart where accno = '39006'), curr = 'CHF:EUR:USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '42005'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '36005'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '39006'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CHF:EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -74,5 +74,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '5010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Traditional-Chinese_Default-chart.sql
===================================================================
--- trunk/sql/Traditional-Chinese_Default-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Traditional-Chinese_Default-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -74,5 +74,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '5010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/UCOA-Form990-chart.sql
===================================================================
--- trunk/sql/UCOA-Form990-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/UCOA-Form990-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -225,5 +225,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '8630'),0);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '8650'),0);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1410'), income_accno_id = (select id from chart where accno = '4010'), expense_accno_id = (select id from chart where accno = '7510'), fxgain_accno_id = (select id from chart where accno = '5490'), fxloss_accno_id = (select id from chart where accno = '8590'), curr = 'USD', weightunit = 'lbs';
+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 ('expense_accno_id', (select id from chart where accno = '7510'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '5490'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '8590'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
+

Modified: trunk/sql/UCOA-Form990EZ-chart.sql
===================================================================
--- trunk/sql/UCOA-Form990EZ-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/UCOA-Form990EZ-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -225,5 +225,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '8630'),0);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '8650'),0);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1410'), income_accno_id = (select id from chart where accno = '4010'), expense_accno_id = (select id from chart where accno = '7510'), fxgain_accno_id = (select id from chart where accno = '5490'), fxloss_accno_id = (select id from chart where accno = '8590'), curr = 'USD', weightunit = 'lbs';
+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 ('expense_accno_id', (select id from chart where accno = '7510'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '5490'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '8590'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
+

Modified: trunk/sql/UK_General-chart.sql
===================================================================
--- trunk/sql/UK_General-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/UK_General-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -105,5 +105,17 @@
 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);
 --
-UPDATE defaults SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '1001'), income_accno_id = (SELECT id FROM chart WHERE accno = '4000'), expense_accno_id = (SELECT id FROM chart WHERE accno = '5000'), fxgain_accno_id = (SELECT id FROM chart WHERE accno = '4920'), fxloss_accno_id = (SELECT id FROM chart WHERE accno = '5220'), curr = 'GBP:USD:EUR', weightunit = 'kg';
+ 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 = '4000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '4920'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '5220'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'GBP:USD:EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+

Modified: trunk/sql/US_General-chart.sql
===================================================================
--- trunk/sql/US_General-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/US_General-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -86,5 +86,17 @@
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2150'),0.05);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1510'), income_accno_id = (select id from chart where accno = '4010'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'USD:CAD:EUR', weightunit = 'lbs';
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1510'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('inventory_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 = '5010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD:CAD:EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
 --

Modified: trunk/sql/US_Manufacturing-chart.sql
===================================================================
--- trunk/sql/US_Manufacturing-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/US_Manufacturing-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -78,5 +78,17 @@
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2150'),0.05);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5020'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'USD:CAD:EUR', weightunit = 'lbs';
+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 ('expense_accno_id', (select id from chart where accno = '5020'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD:CAD:EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
+

Modified: trunk/sql/US_Service_Company-chart.sql
===================================================================
--- trunk/sql/US_Service_Company-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/US_Service_Company-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -64,5 +64,17 @@
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2150'),0.05);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4410'), expense_accno_id = (select id from chart where accno = '5020'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'USD:CAD:EUR', weightunit = 'lbs';
+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 ('expense_accno_id', (select id from chart where accno = '5020'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD:CAD:EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
 --

Modified: trunk/sql/Venezuela_Default-chart.sql
===================================================================
--- trunk/sql/Venezuela_Default-chart.sql	2006-10-31 04:10:35 UTC (rev 417)
+++ trunk/sql/Venezuela_Default-chart.sql	2006-10-31 04:23:28 UTC (rev 418)
@@ -84,4 +84,17 @@
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2150'),0.16);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5020'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'VEB:USD', weightunit = 'kg';
+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 ('expense_accno_id', (select id from chart where accno = '5020'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'VEB:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+


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