From 6fb9913158ea30e4e0d1cd2421df0a5e16ec80e3 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
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

