From 6fb9913158ea30e4e0d1cd2421df0a5e16ec80e3 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Tue, 14 Nov 2006 21:29:33 +0000 Subject: Fixed defaults in numerous CoA's git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@598 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Colombia-PUC-chart.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'sql/Colombia-PUC-chart.sql') diff --git a/sql/Colombia-PUC-chart.sql b/sql/Colombia-PUC-chart.sql index 035e249a..271de336 100755 --- a/sql/Colombia-PUC-chart.sql +++ b/sql/Colombia-PUC-chart.sql @@ -769,9 +769,10 @@ 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); - 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 = '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 ('income_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')); -- cgit v1.2.3