diff options
Diffstat (limited to 'sql')
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'); + |