COnverted all Canadian, Colombian, and Czech CoA's

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@415 4979c152-3d1c-0410-bac9-87ea11338e46

4 files changed, 52 insertions, 4 deletions

diff --git a/sql/Canada-Quebec_General-UTF8-chart.sql b/sql/Canada-Quebec_General-UTF8-chart.sql
index 46ab02d9..274f5b8d 100755
--- a/sql/Canada-Quebec_General-UTF8-chart.sql
+++ b/sql/Canada-Quebec_General-UTF8-chart.sql
@@ -75,4 +75,16 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.06);
 insert into tax (chart_id,rate,pass) values ((select id from chart where accno = '2320'),0.075,1);
 --
-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 = '4450'), curr = 'CAD:USD: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 = '4450'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CAD:USD:EUR');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
diff --git a/sql/Colombia-PUC-chart.sql b/sql/Colombia-PUC-chart.sql
index 82087d75..035e249a 100755
--- a/sql/Colombia-PUC-chart.sql
+++ b/sql/Colombia-PUC-chart.sql
@@ -769,5 +769,17 @@ INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '24
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100001'), 0.16);
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100002'), 0.07);
 
-UPDATE defaults SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '141005001'), income_accno_id = (SELECT id FROM chart WHERE accno = '412027001'), expense_accno_id = (SELECT id FROM chart WHERE accno = '5250150001'), fxgain_accno_id = (SELECT id FROM chart WHERE accno = '4705400001'), fxloss_accno_id = (SELECT id FROM chart WHERE accno = '530520001'), curr = 'COP', weightunit = 'kg';
+ SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '141005001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5250150001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '4705400001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '530520001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'COP');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
diff --git a/sql/Colombia-utf8-PUC-chart.sql b/sql/Colombia-utf8-PUC-chart.sql
index 759bea9b..072207b4 100755
--- a/sql/Colombia-utf8-PUC-chart.sql
+++ b/sql/Colombia-utf8-PUC-chart.sql
@@ -769,5 +769,17 @@ INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '24
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100001'), 0.16);
 INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100002'), 0.07);
 
-UPDATE defaults SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '141005001'), income_accno_id = (SELECT id FROM chart WHERE accno = '412027001'), expense_accno_id = (SELECT id FROM chart WHERE accno = '5250150001'), fxgain_accno_id = (SELECT id FROM chart WHERE accno = '4705400001'), fxloss_accno_id = (SELECT id FROM chart WHERE accno = '530520001'), curr = 'COP', weightunit = 'kg';
+ SET inventory_accno_id = (SELECT id FROM chart WHERE accno = '141005001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5250150001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '4705400001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '530520001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'COP');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
  
diff --git a/sql/Czech-Republic-chart.sql b/sql/Czech-Republic-chart.sql
index 6cb20522..30d63265 100755
--- a/sql/Czech-Republic-chart.sql
+++ b/sql/Czech-Republic-chart.sql
@@ -313,5 +313,17 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '343
 insert into tax (chart_id,rate) values ((select id from chart where accno = '34321'),0.05);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '34322'),0.22);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '13200'), income_accno_id = (select id from chart where accno = '60000'), expense_accno_id = (select id from chart where accno = '50000'), fxgain_accno_id = (select id from chart where accno = '99998'), fxloss_accno_id = (select id from chart where accno = '99999'), curr = 'Kč ', weightunit = 'kg';
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '13200'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '60000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '50000'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '99998'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '99999'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'Kč ');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --