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

[..hidden..]

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

Log Message:
-----------
Danish and Dutch CoA's...

Modified Paths:
--------------
    trunk/sql/Danish_Default-chart.sql
    trunk/sql/Dutch_Default-chart.sql
    trunk/sql/Dutch_Standard-chart.sql

Modified: trunk/sql/Danish_Default-chart.sql
===================================================================
--- trunk/sql/Danish_Default-chart.sql	2006-10-31 04:07:04 UTC (rev 415)
+++ trunk/sql/Danish_Default-chart.sql	2006-10-31 04:08:18 UTC (rev 416)
@@ -71,5 +71,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '1210'),0.25);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.25);
 --
-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 = 'DKK', 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', 'DKK');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Dutch_Default-chart.sql
===================================================================
--- trunk/sql/Dutch_Default-chart.sql	2006-10-31 04:07:04 UTC (rev 415)
+++ trunk/sql/Dutch_Default-chart.sql	2006-10-31 04:08:18 UTC (rev 416)
@@ -76,5 +76,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.19);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.06);
 --
-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 = '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', 'EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --

Modified: trunk/sql/Dutch_Standard-chart.sql
===================================================================
--- trunk/sql/Dutch_Standard-chart.sql	2006-10-31 04:07:04 UTC (rev 415)
+++ trunk/sql/Dutch_Standard-chart.sql	2006-10-31 04:08:18 UTC (rev 416)
@@ -229,5 +229,17 @@
 insert into tax (chart_id,rate) values ((select id from chart where accno = '1810'),0.19);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '1811'),0.06);
 --
-update defaults set inventory_accno_id = (select id from chart where accno = '7001'), income_accno_id = (select id from chart where accno = '8520'), expense_accno_id = (select id from chart where accno = '8010'), fxgain_accno_id = (select id from chart where accno = '9220'), fxloss_accno_id = (select id from chart where accno = '9220'), curr = 'EUR:USD', weightunit = 'kg';
+INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '7001'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '8520'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '8010'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '9220'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '9220'));
+
+ INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR:USD');
+
+ INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --


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