summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xsql/Bahasa-Indonesia_Default-chart.sql14
-rwxr-xr-xsql/Belgium-chart.sql13
-rwxr-xr-xsql/Brazil_General-chart.sql14
-rwxr-xr-xsql/German-Sample-chart.sql14
-rwxr-xr-xsql/Germany-DATEV-SKR03-chart.sql14
-rwxr-xr-xsql/Germany-SKR03-chart.sql14
-rwxr-xr-xsql/Hungary-chart.sql14
-rwxr-xr-xsql/Italy_General-chart.sql14
-rwxr-xr-xsql/Italy_cc2424-chart.sql15
-rwxr-xr-xsql/Latvia-chart.sql14
-rwxr-xr-xsql/Norwegian_Default-chart.sql14
-rwxr-xr-xsql/Paraguay-chart.sql14
-rwxr-xr-xsql/Poland-chart.sql12
-rwxr-xr-xsql/Simplified-Chinese_Default-UTF8-chart.sql14
-rwxr-xr-xsql/Simplified-Chinese_Default-chart.sql14
-rwxr-xr-xsql/Spain-ISO-chart.sql14
-rwxr-xr-xsql/Spain-UTF8-chart.sql13
-rwxr-xr-xsql/Sweden-chart.sql14
-rwxr-xr-xsql/Sweden_Agriculture-chart.sql14
-rwxr-xr-xsql/Sweden_Church_Society-chart.sql14
-rwxr-xr-xsql/Swiss-German-chart.sql14
-rwxr-xr-xsql/Traditional-Chinese_Default-UTF8-chart.sql14
-rwxr-xr-xsql/Traditional-Chinese_Default-chart.sql14
-rwxr-xr-xsql/UCOA-Form990-chart.sql14
-rwxr-xr-xsql/UCOA-Form990EZ-chart.sql14
-rwxr-xr-xsql/UK_General-chart.sql14
-rwxr-xr-xsql/US_General-chart.sql14
-rwxr-xr-xsql/US_Manufacturing-chart.sql14
-rwxr-xr-xsql/US_Service_Company-chart.sql14
-rwxr-xr-xsql/Venezuela_Default-chart.sql15
30 files changed, 382 insertions, 36 deletions
diff --git a/sql/Bahasa-Indonesia_Default-chart.sql b/sql/Bahasa-Indonesia_Default-chart.sql
index 42842dba..e4e0f431 100755
--- a/sql/Bahasa-Indonesia_Default-chart.sql
+++ b/sql/Bahasa-Indonesia_Default-chart.sql
@@ -69,5 +69,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '231
--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');
--
diff --git a/sql/Belgium-chart.sql b/sql/Belgium-chart.sql
index 00053114..af472c7b 100755
--- a/sql/Belgium-chart.sql
+++ b/sql/Belgium-chart.sql
@@ -430,5 +430,16 @@ INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE
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');
diff --git a/sql/Brazil_General-chart.sql b/sql/Brazil_General-chart.sql
index 122406db..93a0a9f4 100755
--- a/sql/Brazil_General-chart.sql
+++ b/sql/Brazil_General-chart.sql
@@ -66,5 +66,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
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');
--
diff --git a/sql/German-Sample-chart.sql b/sql/German-Sample-chart.sql
index fafb5f98..1a157aac 100755
--- a/sql/German-Sample-chart.sql
+++ b/sql/German-Sample-chart.sql
@@ -212,5 +212,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '380
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');
--
diff --git a/sql/Germany-DATEV-SKR03-chart.sql b/sql/Germany-DATEV-SKR03-chart.sql
index bc3faebb..0964a30b 100755
--- a/sql/Germany-DATEV-SKR03-chart.sql
+++ b/sql/Germany-DATEV-SKR03-chart.sql
@@ -218,7 +218,19 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES
INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0840000','Erlöse 16% USt.','A','I','AR_amount:IC_sale:IC_income','0840000');
INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('950','Rückstellungen','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);
diff --git a/sql/Germany-SKR03-chart.sql b/sql/Germany-SKR03-chart.sql
index 1cbcf57e..ee5c4694 100755
--- a/sql/Germany-SKR03-chart.sql
+++ b/sql/Germany-SKR03-chart.sql
@@ -260,5 +260,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '177
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');
--
diff --git a/sql/Hungary-chart.sql b/sql/Hungary-chart.sql
index 35faaaa7..9120937c 100755
--- a/sql/Hungary-chart.sql
+++ b/sql/Hungary-chart.sql
@@ -45,4 +45,16 @@ INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE ac
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');
diff --git a/sql/Italy_General-chart.sql b/sql/Italy_General-chart.sql
index 3132720b..3a10c52c 100755
--- a/sql/Italy_General-chart.sql
+++ b/sql/Italy_General-chart.sql
@@ -175,5 +175,17 @@ INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '64
--
-- 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');
--
diff --git a/sql/Italy_cc2424-chart.sql b/sql/Italy_cc2424-chart.sql
index b8573afe..dbb0c4b7 100755
--- a/sql/Italy_cc2424-chart.sql
+++ b/sql/Italy_cc2424-chart.sql
@@ -259,11 +259,12 @@ INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '22
-- 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');
diff --git a/sql/Latvia-chart.sql b/sql/Latvia-chart.sql
index 0aeb6e32..50e8a71c 100755
--- a/sql/Latvia-chart.sql
+++ b/sql/Latvia-chart.sql
@@ -249,5 +249,17 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES
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');
diff --git a/sql/Norwegian_Default-chart.sql b/sql/Norwegian_Default-chart.sql
index 3a04b4da..9da1cb0d 100755
--- a/sql/Norwegian_Default-chart.sql
+++ b/sql/Norwegian_Default-chart.sql
@@ -293,5 +293,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '271
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');
--
diff --git a/sql/Paraguay-chart.sql b/sql/Paraguay-chart.sql
index 178d039b..db6ad0f1 100755
--- a/sql/Paraguay-chart.sql
+++ b/sql/Paraguay-chart.sql
@@ -249,5 +249,17 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VA
--
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');
--
diff --git a/sql/Poland-chart.sql b/sql/Poland-chart.sql
index 41df38b8..b7793bc5 100755
--- a/sql/Poland-chart.sql
+++ b/sql/Poland-chart.sql
@@ -331,7 +331,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '223
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');
--
diff --git a/sql/Simplified-Chinese_Default-UTF8-chart.sql b/sql/Simplified-Chinese_Default-UTF8-chart.sql
index 1a8513ea..afeabb97 100755
--- a/sql/Simplified-Chinese_Default-UTF8-chart.sql
+++ b/sql/Simplified-Chinese_Default-UTF8-chart.sql
@@ -74,5 +74,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
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');
--
diff --git a/sql/Simplified-Chinese_Default-chart.sql b/sql/Simplified-Chinese_Default-chart.sql
index 307966b0..20d41c81 100755
--- a/sql/Simplified-Chinese_Default-chart.sql
+++ b/sql/Simplified-Chinese_Default-chart.sql
@@ -74,5 +74,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
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');
--
diff --git a/sql/Spain-ISO-chart.sql b/sql/Spain-ISO-chart.sql
index 6b29c478..ac8a20a7 100755
--- a/sql/Spain-ISO-chart.sql
+++ b/sql/Spain-ISO-chart.sql
@@ -128,5 +128,17 @@ INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno
--
-- 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');
--
diff --git a/sql/Spain-UTF8-chart.sql b/sql/Spain-UTF8-chart.sql
index fefdbb7b..9bcad317 100755
--- a/sql/Spain-UTF8-chart.sql
+++ b/sql/Spain-UTF8-chart.sql
@@ -128,6 +128,17 @@ INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno
--
-- 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';
--
diff --git a/sql/Sweden-chart.sql b/sql/Sweden-chart.sql
index bfc6fa72..d721a76d 100755
--- a/sql/Sweden-chart.sql
+++ b/sql/Sweden-chart.sql
@@ -1134,5 +1134,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '262
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');
diff --git a/sql/Sweden_Agriculture-chart.sql b/sql/Sweden_Agriculture-chart.sql
index 96dbc866..2d37732d 100755
--- a/sql/Sweden_Agriculture-chart.sql
+++ b/sql/Sweden_Agriculture-chart.sql
@@ -1297,5 +1297,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '263
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');
diff --git a/sql/Sweden_Church_Society-chart.sql b/sql/Sweden_Church_Society-chart.sql
index 4cee4378..a0869104 100755
--- a/sql/Sweden_Church_Society-chart.sql
+++ b/sql/Sweden_Church_Society-chart.sql
@@ -227,5 +227,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
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');
diff --git a/sql/Swiss-German-chart.sql b/sql/Swiss-German-chart.sql
index 3de8e73b..49761139 100755
--- a/sql/Swiss-German-chart.sql
+++ b/sql/Swiss-German-chart.sql
@@ -156,5 +156,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '212
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');
--
diff --git a/sql/Traditional-Chinese_Default-UTF8-chart.sql b/sql/Traditional-Chinese_Default-UTF8-chart.sql
index b2e9c469..2ffc48d7 100755
--- a/sql/Traditional-Chinese_Default-UTF8-chart.sql
+++ b/sql/Traditional-Chinese_Default-UTF8-chart.sql
@@ -74,5 +74,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
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');
--
diff --git a/sql/Traditional-Chinese_Default-chart.sql b/sql/Traditional-Chinese_Default-chart.sql
index 341200ff..dc92e49d 100755
--- a/sql/Traditional-Chinese_Default-chart.sql
+++ b/sql/Traditional-Chinese_Default-chart.sql
@@ -74,5 +74,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
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');
--
diff --git a/sql/UCOA-Form990-chart.sql b/sql/UCOA-Form990-chart.sql
index 42cbaea2..169086d9 100755
--- a/sql/UCOA-Form990-chart.sql
+++ b/sql/UCOA-Form990-chart.sql
@@ -225,5 +225,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '862
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');
diff --git a/sql/UCOA-Form990EZ-chart.sql b/sql/UCOA-Form990EZ-chart.sql
index 936102d1..6726ee7e 100755
--- a/sql/UCOA-Form990EZ-chart.sql
+++ b/sql/UCOA-Form990EZ-chart.sql
@@ -225,5 +225,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '862
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');
diff --git a/sql/UK_General-chart.sql b/sql/UK_General-chart.sql
index 1e66bc01..131facc6 100755
--- a/sql/UK_General-chart.sql
+++ b/sql/UK_General-chart.sql
@@ -105,5 +105,17 @@ INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES
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');
diff --git a/sql/US_General-chart.sql b/sql/US_General-chart.sql
index a1a6939a..7c7985d3 100755
--- a/sql/US_General-chart.sql
+++ b/sql/US_General-chart.sql
@@ -86,5 +86,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
--
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');
--
diff --git a/sql/US_Manufacturing-chart.sql b/sql/US_Manufacturing-chart.sql
index b293cd17..5ad4240f 100755
--- a/sql/US_Manufacturing-chart.sql
+++ b/sql/US_Manufacturing-chart.sql
@@ -78,5 +78,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
--
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');
diff --git a/sql/US_Service_Company-chart.sql b/sql/US_Service_Company-chart.sql
index a7cd8b23..96b8ca70 100755
--- a/sql/US_Service_Company-chart.sql
+++ b/sql/US_Service_Company-chart.sql
@@ -64,5 +64,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
--
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');
--
diff --git a/sql/Venezuela_Default-chart.sql b/sql/Venezuela_Default-chart.sql
index 99ac8fcc..7232085e 100755
--- a/sql/Venezuela_Default-chart.sql
+++ b/sql/Venezuela_Default-chart.sql
@@ -84,4 +84,17 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values
--
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');
+