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

[..hidden..]

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

Log Message:
-----------
COnverted all Canadian, Colombian, and Czech CoA's

Modified Paths:
--------------
    trunk/sql/Canada-Quebec_General-UTF8-chart.sql
    trunk/sql/Colombia-PUC-chart.sql
    trunk/sql/Colombia-utf8-PUC-chart.sql
    trunk/sql/Czech-Republic-chart.sql

Modified: trunk/sql/Canada-Quebec_General-UTF8-chart.sql
===================================================================
--- trunk/sql/Canada-Quebec_General-UTF8-chart.sql	2006-10-31 04:04:09 UTC (rev 414)
+++ trunk/sql/Canada-Quebec_General-UTF8-chart.sql	2006-10-31 04:07:04 UTC (rev 415)
@@ -75,4 +75,16 @@
 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');

Modified: trunk/sql/Colombia-PUC-chart.sql
===================================================================
--- trunk/sql/Colombia-PUC-chart.sql	2006-10-31 04:04:09 UTC (rev 414)
+++ trunk/sql/Colombia-PUC-chart.sql	2006-10-31 04:07:04 UTC (rev 415)
@@ -769,5 +769,17 @@
 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');
+

Modified: trunk/sql/Colombia-utf8-PUC-chart.sql
===================================================================
--- trunk/sql/Colombia-utf8-PUC-chart.sql	2006-10-31 04:04:09 UTC (rev 414)
+++ trunk/sql/Colombia-utf8-PUC-chart.sql	2006-10-31 04:07:04 UTC (rev 415)
@@ -769,5 +769,17 @@
 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');
  

Modified: trunk/sql/Czech-Republic-chart.sql
===================================================================
--- trunk/sql/Czech-Republic-chart.sql	2006-10-31 04:04:09 UTC (rev 414)
+++ trunk/sql/Czech-Republic-chart.sql	2006-10-31 04:07:04 UTC (rev 415)
@@ -313,5 +313,17 @@
 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\xE8 ', 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\xE8 ');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --


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