Making sql files internally single transactions

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

66 files changed, 132 insertions, 0 deletions

diff --git a/sql/Australia_General_0000-chart.sql b/sql/Australia_General_0000-chart.sql
index 9c2a70b9..045879a1 100755
--- a/sql/Australia_General_0000-chart.sql
+++ b/sql/Australia_General_0000-chart.sql
@@ -1,3 +1,4 @@
+begin;
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2000', 'CURRENT LIABILITIES', 'H', 'L', '', '');
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2600', 'LONG TERM LIABILITIES', 'H', 'L', '', '');
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4000', 'SALES REVENUE', 'H', 'I', '', '');
@@ -123,3 +124,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Australia_General_00000-chart.sql b/sql/Australia_General_00000-chart.sql
index 4d15e812..b66591d2 100755
--- a/sql/Australia_General_00000-chart.sql
+++ b/sql/Australia_General_00000-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Australia chart of accounts
 -- sample only
 --
@@ -88,3 +89,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
+commit;
diff --git a/sql/Austria-chart.sql b/sql/Austria-chart.sql
index f49c3897..477cce83 100755
--- a/sql/Austria-chart.sql
+++ b/sql/Austria-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Kontoplan für Österreich
 -- Ferdinand Gassauer, Tue, 5 Feb 2002
 -- checked and completed, Thu, 7 Feb 2002, Dieter Simader
@@ -152,3 +153,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Austria-gifi.sql b/sql/Austria-gifi.sql
index 00c4d95a..0acec465 100755
--- a/sql/Austria-gifi.sql
+++ b/sql/Austria-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- Österreichischer Einheitskontenrahmen / Kontenplan (ÖSV Österreichischer Steuerverein)
 --
 INSERT INTO gifi (accno, description) VALUES ('0', 'Anlagevermögen und Aufwendungen für das Ingangsetzen und Erweitern eines Betriebes');
@@ -332,3 +333,4 @@ INSERT INTO gifi (accno, description) VALUES ('980', 'Eröffnungsbilanz');
 INSERT INTO gifi (accno, description) VALUES ('985', 'Schlußbilanz');
 INSERT INTO gifi (accno, description) VALUES ('989', 'Gewinn- und Verlustrechnung');
 INSERT INTO gifi (accno, description) VALUES ('990-999', 'Evidenzkonten');
+commit;
diff --git a/sql/Bahasa-Indonesia_Default-chart.sql b/sql/Bahasa-Indonesia_Default-chart.sql
index 57963724..0388a177 100755
--- a/sql/Bahasa-Indonesia_Default-chart.sql
+++ b/sql/Bahasa-Indonesia_Default-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Default chart of accounts
 -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','AKTIVA LANCAR','H','','A','');
@@ -83,3 +84,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Belgium-chart.sql b/sql/Belgium-chart.sql
index 1881a0a1..035c4071 100755
--- a/sql/Belgium-chart.sql
+++ b/sql/Belgium-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- selon PLAN COMPTABLE MINIMUM NORMALISE BELGE
 -- contribu. par Jens-Ingo Brodesser, jens-ingo@all2all.org
 -- verified May 19, 2006
@@ -444,3 +445,4 @@ id FROM chart WHERE accno = '340'));
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
  INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR:USD');
 
+commit;
diff --git a/sql/Belgium-gifi.sql b/sql/Belgium-gifi.sql
index c29a759b..47619de1 100755
--- a/sql/Belgium-gifi.sql
+++ b/sql/Belgium-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- contribué par Jens-Ingo Brodesser, jens-ingo@all2all.org, Moving Art Studio ASBL, ALL2ALL The Independent Network
 -- le 15/07/2003
 
@@ -66,3 +67,4 @@ INSERT INTO gifi (accno,description) VALUES ('76','Produits exceptionnels');
 INSERT INTO gifi (accno,description) VALUES ('77','Régularisations d''impôts et reprises provisions fiscales');
 INSERT INTO gifi (accno,description) VALUES ('78','Prélèvements s/réserves immunisées et impôts différés');
 INSERT INTO gifi (accno,description) VALUES ('79','Affectations et prélèvements');
+commit;
diff --git a/sql/Brazil_General-chart.sql b/sql/Brazil_General-chart.sql
index b255a229..c12e5d42 100755
--- a/sql/Brazil_General-chart.sql
+++ b/sql/Brazil_General-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- General Brazilien Portuguese COA
 -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','RECURSOS ATUAIS','H','','A','');
@@ -80,3 +81,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Canada-English-gifi.sql b/sql/Canada-English-gifi.sql
index 03945dae..6863d968 100755
--- a/sql/Canada-English-gifi.sql
+++ b/sql/Canada-English-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- GIFI codes as set by the Canadian Government
 -- It's a dirty job, but it seems somebody allready did it
 -- PDF Tammes, Tue , 02 Apr 2002
@@ -757,3 +758,4 @@ INSERT INTO gifi (accno,description) VALUES ('9999', 'Net Income/Loss After Taxe
 -- Any amount reported in this item should be equal to the amount reported at Item 3680 - Net income/loss, 
 -- in the retained earnings section. 
 --
+commit;
diff --git a/sql/Canada-English_General-chart.sql b/sql/Canada-English_General-chart.sql
index 99946c9c..26122124 100755
--- a/sql/Canada-English_General-chart.sql
+++ b/sql/Canada-English_General-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- General Canadian COA
 -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','CURRENT ASSETS','H','1000','A','');
@@ -80,3 +81,4 @@ INSERT INTO defaults (setting_key, value) values ('fxloss_accno_id',
 INSERT INTO defaults (setting_key, value) values ('curr', 'CAD:USD:EUR');
 INSERT INTO defaults (setting_key, value) values ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Canada-Quebec-UTF8-gifi.sql b/sql/Canada-Quebec-UTF8-gifi.sql
index 10872f2c..d293ef1b 100755
--- a/sql/Canada-Quebec-UTF8-gifi.sql
+++ b/sql/Canada-Quebec-UTF8-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- French Canadian GIFI
 -- Céline des Ligneris
 -- checked DS. March 3, 2004
@@ -717,3 +718,4 @@ INSERT INTO gifi (accno,description) VALUES ('9985','Éléments inhabituels');
 INSERT INTO gifi (accno,description) VALUES ('9990','Impôts sur le revenu exigibles de l\'exercice');
 INSERT INTO gifi (accno,description) VALUES ('9995','Provision pour impôts sur le revenu différés');
 INSERT INTO gifi (accno,description) VALUES ('9999','Revenu net/perte nette après impôts et éléments');
+commit;
diff --git a/sql/Canada-Quebec-gifi.sql b/sql/Canada-Quebec-gifi.sql
index 10872f2c..d293ef1b 100755
--- a/sql/Canada-Quebec-gifi.sql
+++ b/sql/Canada-Quebec-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- French Canadian GIFI
 -- Céline des Ligneris
 -- checked DS. March 3, 2004
@@ -717,3 +718,4 @@ INSERT INTO gifi (accno,description) VALUES ('9985','Éléments inhabituels');
 INSERT INTO gifi (accno,description) VALUES ('9990','Impôts sur le revenu exigibles de l\'exercice');
 INSERT INTO gifi (accno,description) VALUES ('9995','Provision pour impôts sur le revenu différés');
 INSERT INTO gifi (accno,description) VALUES ('9999','Revenu net/perte nette après impôts et éléments');
+commit;
diff --git a/sql/Canada-Quebec_General-UTF8-chart.sql b/sql/Canada-Quebec_General-UTF8-chart.sql
index 725f0ae8..0cecb424 100755
--- a/sql/Canada-Quebec_General-UTF8-chart.sql
+++ b/sql/Canada-Quebec_General-UTF8-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- General French-Canadian (AKA Québécois) COA
 -- sample only
 
@@ -88,3 +89,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
  INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CAD:USD:EUR');
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
diff --git a/sql/Canada-Quebec_General-chart.sql b/sql/Canada-Quebec_General-chart.sql
index 725f0ae8..0cecb424 100755
--- a/sql/Canada-Quebec_General-chart.sql
+++ b/sql/Canada-Quebec_General-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- General French-Canadian (AKA Québécois) COA
 -- sample only
 
@@ -88,3 +89,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
  INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CAD:USD:EUR');
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
diff --git a/sql/Colombia-utf8-PUC-chart.sql b/sql/Colombia-utf8-PUC-chart.sql
index 469b2333..f3f57aec 100755
--- a/sql/Colombia-utf8-PUC-chart.sql
+++ b/sql/Colombia-utf8-PUC-chart.sql
@@ -1,3 +1,4 @@
+begin;
 --
 -- Plan único de Cuentas de Colombia, elaborado por Rene Real Hernandez (SDI S.A.), Francico Padilla (SDI S.A.), 
 -- Silfredo Godoy Chavez (CaribeNet S.A.),
@@ -784,3 +785,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
  
+commit;
diff --git a/sql/Colombia-utf8-PUC-gifi.sql b/sql/Colombia-utf8-PUC-gifi.sql
index 3b8d7b2e..67317e49 100755
--- a/sql/Colombia-utf8-PUC-gifi.sql
+++ b/sql/Colombia-utf8-PUC-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 --
 --
 -- Data for Plan Único de Cuentas (PUC) Gifi Table
@@ -2471,3 +2472,4 @@ INSERT INTO gifi (accno,description) VALUES ('94', 'RESPONSABILIDADES CONTINGENT
 INSERT INTO gifi (accno,description) VALUES ('95', 'ACREEDORAS FISCALES POR CONTRA (DB) ');
 INSERT INTO gifi (accno,description) VALUES ('96', 'ACREEDORAS DE CONTROL POR CONTRA (DB) ');
 INSERT INTO gifi (accno,description) VALUES ('5', 'GASTOS');
+commit;
diff --git a/sql/Czech-Republic-chart.sql b/sql/Czech-Republic-chart.sql
index acd239a6..e4b666f2 100755
--- a/sql/Czech-Republic-chart.sql
+++ b/sql/Czech-Republic-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Czech chart of accounts
 -- Tomas.Fencl@centrum.cz
 --    Kompletní úètová osnova platná v roce 2001
@@ -327,3 +328,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Danish_Default-UTF8-chart.sql b/sql/Danish_Default-UTF8-chart.sql
index be1e0b64..dddb7493 100755
--- a/sql/Danish_Default-UTF8-chart.sql
+++ b/sql/Danish_Default-UTF8-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Default chart of accounts
 -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','KORTFRISTEDE AKTIVER','H','','A','');
@@ -85,3 +86,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Danish_Default-chart.sql b/sql/Danish_Default-chart.sql
index be1e0b64..dddb7493 100755
--- a/sql/Danish_Default-chart.sql
+++ b/sql/Danish_Default-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Default chart of accounts
 -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','KORTFRISTEDE AKTIVER','H','','A','');
@@ -85,3 +86,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Default-chart.sql b/sql/Default-chart.sql
index c0f103b6..4cebd34d 100755
--- a/sql/Default-chart.sql
+++ b/sql/Default-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Default chart of accounts
 -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','CURRENT ASSETS','H','','A','');
@@ -87,3 +88,4 @@ INSERT INTO defaults (setting_key, value)
 VALUES ('curr', 'USD:CAD:EUR');
 INSERT INTO defaults (setting_key, value) 
 VALUES ('weightunit', 'kg');
+commit;
diff --git a/sql/Dutch_Default-chart.sql b/sql/Dutch_Default-chart.sql
index 30f22aaa..2ef4acb7 100755
--- a/sql/Dutch_Default-chart.sql
+++ b/sql/Dutch_Default-chart.sql
@@ -1,3 +1,4 @@
+begin;
 --
 -- Dutch Chart of Accounts
 -- AJ Hettema, Mon, 20 Aug 2001
@@ -90,3 +91,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Dutch_Standard-chart.sql b/sql/Dutch_Standard-chart.sql
index 9ba7f7d1..ef8df27b 100755
--- a/sql/Dutch_Standard-chart.sql
+++ b/sql/Dutch_Standard-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Nederlandstalig Rekeningschema conform het Decimaal Stelsel.
 -- Dutch Chart of Accounts following the Decimal Standards as set by the famous Philips Accounting Department
 -- PDF Tammes, Fri, 29 Mar 2002 ( remarks or questions to finance@bermuda-holding.com )
@@ -243,3 +244,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Egypt-UTF8-chart.sql b/sql/Egypt-UTF8-chart.sql
index 19627f40..135b2a01 100755
--- a/sql/Egypt-UTF8-chart.sql
+++ b/sql/Egypt-UTF8-chart.sql
@@ -1,3 +1,4 @@
+begin;
 --
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2210','Workers Comp Payable','A','L','','');
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2220','Vacation Pay Payable','A','L','','');
@@ -89,3 +90,4 @@ INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE ac
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2320'),'0.14',NULL);
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2330'),'0.3',NULL);
 
+commit;
diff --git a/sql/Egypt-chart.sql b/sql/Egypt-chart.sql
index 19627f40..135b2a01 100755
--- a/sql/Egypt-chart.sql
+++ b/sql/Egypt-chart.sql
@@ -1,3 +1,4 @@
+begin;
 --
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2210','Workers Comp Payable','A','L','','');
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2220','Vacation Pay Payable','A','L','','');
@@ -89,3 +90,4 @@ INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE ac
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2320'),'0.14',NULL);
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2330'),'0.3',NULL);
 
+commit;
diff --git a/sql/France-chart.sql b/sql/France-chart.sql
index 56d32921..4529a57a 100755
--- a/sql/France-chart.sql
+++ b/sql/France-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Chart of Accounts for France
 -- From: Oscar Buijten <oscar@elbie.com>
 -- Mon, 6 Aug 2001
@@ -961,3 +962,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/German-Sample-chart.sql b/sql/German-Sample-chart.sql
index 64210bfc..aa682d18 100755
--- a/sql/German-Sample-chart.sql
+++ b/sql/German-Sample-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Einfacher Deutscher Kontenrahmen => Very Easy German Default Chart  
 -- Vorbereitet von / Prepared by Paul Tammes May 9th, 2002. Kommentar / Comments : finance@bermuda-holding.com
 -- Englische Texte für eigene Zwecke und um Refernz in LedgerSMB Dokumentation zu erleichtern.
@@ -226,3 +227,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/German-Sample-gifi.sql b/sql/German-Sample-gifi.sql
index 73161140..f2991961 100755
--- a/sql/German-Sample-gifi.sql
+++ b/sql/German-Sample-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- Einfacher Kontoplan für Deutschland
 --
 INSERT INTO gifi (accno,description) VALUES ('A0', 'Anlagevermögen');
@@ -17,3 +18,4 @@ INSERT INTO gifi (accno,description) VALUES ('P1', 'Rückstellungen');
 INSERT INTO gifi (accno,description) VALUES ('P2', 'Fremdkapital Langfristig');
 INSERT INTO gifi (accno,description) VALUES ('P3', 'Fremdkapital Kurzfristig');
 INSERT INTO gifi (accno,description) VALUES ('P4', 'Passive Rechnungsabgrenzung');
+commit;
diff --git a/sql/Germany-DATEV-SKR03-chart.sql b/sql/Germany-DATEV-SKR03-chart.sql
index b8335015..ad2b8377 100755
--- a/sql/Germany-DATEV-SKR03-chart.sql
+++ b/sql/Germany-DATEV-SKR03-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- DATEV SKR03
 --
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0002700','EDV-Software','A','A','','0002700');
@@ -237,3 +238,4 @@ INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '015
 INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '0177100'),0.07);
 INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '0177500'),0.16);
 
+commit;
diff --git a/sql/Germany-DATEV-SKR03-gifi.sql b/sql/Germany-DATEV-SKR03-gifi.sql
index 0c8e5038..183e2462 100755
--- a/sql/Germany-DATEV-SKR03-gifi.sql
+++ b/sql/Germany-DATEV-SKR03-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- DATEV SKR03
 --
 INSERT INTO gifi (accno,description) VALUES ('0000100', 'Aufwand Geschäftsbetrieb');
@@ -548,3 +549,4 @@ INSERT INTO gifi (accno,description) VALUES ('0988900', 'Statistisches Konto AfA
 INSERT INTO gifi (accno,description) VALUES ('0989800', 'Statistisches Konto AfA (Kalkul.)');
 INSERT INTO gifi (accno,description) VALUES ('0989900', 'Statistisches Konto AfA');
 INSERT INTO gifi (accno,description) VALUES ('0999999', 'Fehlerauffangkonto');
+commit;
diff --git a/sql/Germany-SKR03-chart.sql b/sql/Germany-SKR03-chart.sql
index a4f9a154..0a92d154 100755
--- a/sql/Germany-SKR03-chart.sql
+++ b/sql/Germany-SKR03-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- General COA
 --
 INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('420','Büroeinrichtung','A','A','','420');
@@ -274,3 +275,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Germany-SKR03-gifi.sql b/sql/Germany-SKR03-gifi.sql
index 3f75554a..cf54224f 100755
--- a/sql/Germany-SKR03-gifi.sql
+++ b/sql/Germany-SKR03-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- Kontenrahmen für Deutschland
 --
 INSERT INTO gifi (accno,description) VALUES ('0001', 'Aufw. f. die Ingangsetzung u. Erweit. des Geschäftsbetr.');
@@ -1081,3 +1082,4 @@ INSERT INTO gifi (accno,description) VALUES ('9750', 'Sonstige Vergütungen (Tei
 INSERT INTO gifi (accno,description) VALUES ('9790', 'Restanteil (Teilhafter)');
 INSERT INTO gifi (accno,description) VALUES ('9890', 'Statistisches Konto für passive Lohnveredelung');
 INSERT INTO gifi (accno,description) VALUES ('9899', 'Gegenkonto zu 9890');
+commit;
diff --git a/sql/Hungary-chart.sql b/sql/Hungary-chart.sql
index 9cf16fbc..fb3845f2 100755
--- a/sql/Hungary-chart.sql
+++ b/sql/Hungary-chart.sql
@@ -1,3 +1,4 @@
+begin;
 --Hungarian chart of accounts 
 -- Magyar fõkönyvi számlák, amelyek csak példaként szolgálnak
 --
@@ -59,3 +60,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
  INSERT INTO defaults (setting_key, value) VALUES ('curr', 'HUF:EUR:USD');
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
diff --git a/sql/Hungary-gifi.sql b/sql/Hungary-gifi.sql
index 5338fb45..4e45a077 100755
--- a/sql/Hungary-gifi.sql
+++ b/sql/Hungary-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 --Hungarian GIFI / Magyar gyûjtõkódok -- amelyek csak példaként szolgálnak
 INSERT INTO gifi (accno,description) VALUES ('114','Tárgyi eszközök');
 INSERT INTO gifi (accno,description) VALUES ('119','Tárgyi eszközök ÉCS');
@@ -23,3 +24,4 @@ INSERT INTO gifi (accno,description) VALUES ('5','KÖLTSÉGEK');
 INSERT INTO gifi (accno,description) VALUES ('8','RÁFORDÍTÁSOK');
 INSERT INTO gifi (accno,description) VALUES ('9','BEVÉTELEK');
 --
+commit;
diff --git a/sql/Italy-gifi.sql b/sql/Italy-gifi.sql
index 5b4d807c..1be46f0e 100755
--- a/sql/Italy-gifi.sql
+++ b/sql/Italy-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- Oct 8, 2003
 -- verified D Simader
 -- Oct 13, 2003
@@ -138,3 +139,4 @@ INSERT INTO gifi (accno,description) VALUES ('3.E.21', 'oneri straordinari');
 INSERT INTO gifi (accno,description) VALUES ('3.E.22', 'Imposte sul reddito dell\'esercizio');
 INSERT INTO gifi (accno,description) VALUES ('3.E.26', 'Utile o perdita di esercizio');
 
+commit;
diff --git a/sql/Italy_General-chart.sql b/sql/Italy_General-chart.sql
index 434b5277..a2dc0454 100755
--- a/sql/Italy_General-chart.sql
+++ b/sql/Italy_General-chart.sql
@@ -1,3 +1,4 @@
+begin;
 --
 -- Chart of Accounts for Italy
 --
@@ -189,3 +190,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Italy_cc2424-chart.sql b/sql/Italy_cc2424-chart.sql
index 021bcc5f..a6e4d80d 100755
--- a/sql/Italy_cc2424-chart.sql
+++ b/sql/Italy_cc2424-chart.sql
@@ -1,3 +1,4 @@
+begin;
 --
 -- Chart of Accounts for Italy
 --
@@ -268,3 +269,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id
 INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
 INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
+commit;
diff --git a/sql/Latvia-chart.sql b/sql/Latvia-chart.sql
index 58c4551c..0fef5ecb 100755
--- a/sql/Latvia-chart.sql
+++ b/sql/Latvia-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Latvian COA
 -- prepared by Kaspars Melkis <info@isolis.lv>
 -- Sept. 14, 2003
@@ -263,3 +264,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
+commit;
diff --git a/sql/NAICS.sql b/sql/NAICS.sql
index 3fd3f632..42d1c8da 100755
--- a/sql/NAICS.sql
+++ b/sql/NAICS.sql
@@ -1,3 +1,4 @@
+begin;
 -- 1997 NAICS
 -- leave it SIC (Standard Industrial Code)
 -- useful for other countries too
@@ -2343,3 +2344,4 @@ INSERT INTO sic (code,description) VALUES ('92811','National Security');
 INSERT INTO sic (code,description) VALUES ('928110','National Security');
 INSERT INTO sic (code,description) VALUES ('92812','International Affairs');
 INSERT INTO sic (code,description) VALUES ('928120','International Affairs');
+commit;
diff --git a/sql/Norwegian_Default-chart.sql b/sql/Norwegian_Default-chart.sql
index 162f052b..14a57af0 100755
--- a/sql/Norwegian_Default-chart.sql
+++ b/sql/Norwegian_Default-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Default chart of accounts
 -- charset: ISO-8859-1
 --   http://www.nif.idrett.no/ftp/Lover/doc/kontoplan.htm
@@ -307,3 +308,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Paraguay-chart.sql b/sql/Paraguay-chart.sql
index 0ffb9d37..899991aa 100755
--- a/sql/Paraguay-chart.sql
+++ b/sql/Paraguay-chart.sql
@@ -1,3 +1,4 @@
+begin;
 --
 -- LedgerSMB Sample COA - Paraguay
 -- Version: 2.4.6
@@ -264,3 +265,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Paraguay-gifi.sql b/sql/Paraguay-gifi.sql
index 9c95dcd4..395c362b 100755
--- a/sql/Paraguay-gifi.sql
+++ b/sql/Paraguay-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- Paraguay GIFI
 -- Plan de Cuentas Fiscal para Paraguay
 --
@@ -106,3 +107,4 @@ INSERT INTO gifi (accno,description) VALUES ('4-30','Pérdidas');
 INSERT INTO gifi (accno,description) VALUES ('5-10','Más: (o menos) efectos de los precios cambiantes');
 INSERT INTO gifi (accno,description) VALUES ('5-20','Más: (o menos) ajuste de ejercicios anteriores');
 INSERT INTO gifi (accno,description) VALUES ('5-50','Impuesto a la Renta');
+commit;
diff --git a/sql/Pg-central.sql b/sql/Pg-central.sql
index 1b9c755b..4bab66ed 100755
--- a/sql/Pg-central.sql
+++ b/sql/Pg-central.sql
@@ -1,3 +1,4 @@
+begin;
 -- Central DB structure
 -- This is the central database stuff which is used across all datasets
 -- in the ledger-smb.conf it is called 'ledgersmb' by default, but obviously
@@ -77,3 +78,4 @@ last_used TIMESTAMP default now(),
 users_id INTEGER  -- NOT NULL references users(id)
 );
 
+commit;
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 5a799b18..44ea9a10 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -1,3 +1,4 @@
+begin;
 --
 CREATE SEQUENCE id start 10000;
 SELECT nextval ('id');
@@ -1134,3 +1135,4 @@ BEGIN
 END;
 ' LANGUAGE PLPGSQL;
 -- end function
+commit;
diff --git a/sql/Poland-chart.sql b/sql/Poland-chart.sql
index 0688f5f5..c31bc1cf 100755
--- a/sql/Poland-chart.sql
+++ b/sql/Poland-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Chart of Account for Poland
 -- From: Peter Dabrowski <meritage@mail.com>
 -- Sun, 23 March 2003
@@ -345,3 +346,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 --
 
 
+commit;
diff --git a/sql/Simplified-Chinese_Default-UTF8-chart.sql b/sql/Simplified-Chinese_Default-UTF8-chart.sql
index c5a094bd..8999ea81 100755
--- a/sql/Simplified-Chinese_Default-UTF8-chart.sql
+++ b/sql/Simplified-Chinese_Default-UTF8-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Default chart of accounts -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','应付所得税','A','','L','');
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','长期负债','H','','L','');
@@ -88,3 +89,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Simplified-Chinese_Default-chart.sql b/sql/Simplified-Chinese_Default-chart.sql
index c5a094bd..8999ea81 100755
--- a/sql/Simplified-Chinese_Default-chart.sql
+++ b/sql/Simplified-Chinese_Default-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Default chart of accounts -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','应付所得税','A','','L','');
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','长期负债','H','','L','');
@@ -88,3 +89,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Spain-ISO-chart.sql b/sql/Spain-ISO-chart.sql
index 6b3c5b5f..97791427 100755
--- a/sql/Spain-ISO-chart.sql
+++ b/sql/Spain-ISO-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad español)
 -- From: Federico Montesino Pouzols <fedemp@arrok.com>
 -- 23 Apr 2002
@@ -142,3 +143,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'Kg');
 --
+commit;
diff --git a/sql/Spain-UTF8-chart.sql b/sql/Spain-UTF8-chart.sql
index 942357a8..fd292b51 100755
--- a/sql/Spain-UTF8-chart.sql
+++ b/sql/Spain-UTF8-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad español)
 -- From: Federico Montesino Pouzols <fedemp@arrok.com>
 -- 23 Apr 2002
@@ -142,3 +143,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit' , 'Kg';
 --
 
+commit;
diff --git a/sql/Spain-chart.sql b/sql/Spain-chart.sql
index 942357a8..fd292b51 100755
--- a/sql/Spain-chart.sql
+++ b/sql/Spain-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad español)
 -- From: Federico Montesino Pouzols <fedemp@arrok.com>
 -- 23 Apr 2002
@@ -142,3 +143,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit' , 'Kg';
 --
 
+commit;
diff --git a/sql/Sweden-chart.sql b/sql/Sweden-chart.sql
index c2c5fea8..8d7d4c6d 100755
--- a/sql/Sweden-chart.sql
+++ b/sql/Sweden-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- May 7, 2006
 -- Johan Hambraeus
 --
@@ -1148,3 +1149,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
+commit;
diff --git a/sql/Sweden-gifi.sql b/sql/Sweden-gifi.sql
index 45453a6a..b28cad27 100755
--- a/sql/Sweden-gifi.sql
+++ b/sql/Sweden-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 -- Swedish-gifi.sql
 INSERT  INTO gifi (accno,description) VALUES ('200','Kassa och bank ');
 INSERT  INTO gifi (accno,description) VALUES ('202','Aktier och andelar ');
@@ -97,3 +98,4 @@ INSERT  INTO gifi (accno,description) VALUES ('594','Övriga avgående bokslutsd
 INSERT  INTO gifi (accno,description) VALUES ('596','Redovisad förlust enligt bokföringen');
 INSERT  INTO gifi (accno,description) VALUES ('598','Skatter');
 INSERT  INTO gifi (accno,description) VALUES ('599','Redovisad vinst enligt bokföringen');
+commit;
diff --git a/sql/Sweden_Agriculture-chart.sql b/sql/Sweden_Agriculture-chart.sql
index d8bf216f..4d5f5617 100755
--- a/sql/Sweden_Agriculture-chart.sql
+++ b/sql/Sweden_Agriculture-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- COA for Agriculture
 -- Johan Hambraeus
 -- May 7, 2006
@@ -1311,3 +1312,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
+commit;
diff --git a/sql/Sweden_Church_Society-chart.sql b/sql/Sweden_Church_Society-chart.sql
index 1697ca70..11b64e20 100755
--- a/sql/Sweden_Church_Society-chart.sql
+++ b/sql/Sweden_Church_Society-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Johan Hambraeus
 -- May 7, 2006
 --
@@ -241,3 +242,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
+commit;
diff --git a/sql/Swiss-German-chart.sql b/sql/Swiss-German-chart.sql
index 65378bf3..ad24d155 100755
--- a/sql/Swiss-German-chart.sql
+++ b/sql/Swiss-German-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Swiss chart of accounts
 -- adapted to numeric representation of chart no.
 --
@@ -170,3 +171,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Swiss-German-gifi.sql b/sql/Swiss-German-gifi.sql
index d3b71bb0..814030f1 100755
--- a/sql/Swiss-German-gifi.sql
+++ b/sql/Swiss-German-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 --
 INSERT INTO gifi (accno,description) VALUES ('1','AKTIVEN');
 INSERT INTO gifi (accno,description) VALUES ('2','PASSIVEN');
@@ -53,3 +54,4 @@ INSERT INTO gifi (accno,description) VALUES ('91000','ERFOLGSRECHNUNG');
 INSERT INTO gifi (accno,description) VALUES ('92000','BILANZ');
 INSERT INTO gifi (accno,description) VALUES ('93000','GEWINNVERWENDUNG');
 INSERT INTO gifi (accno,description) VALUES ('99000','SAMMEL- UND FEHLBUCHUNGEN');
+commit;
diff --git a/sql/Traditional-Chinese_Default-UTF8-chart.sql b/sql/Traditional-Chinese_Default-UTF8-chart.sql
index 5e46dc79..e93c70f8 100755
--- a/sql/Traditional-Chinese_Default-UTF8-chart.sql
+++ b/sql/Traditional-Chinese_Default-UTF8-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Default chart of accounts -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','應付所得稅','A','','L','');
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','長期負債','H','','L','');
@@ -88,3 +89,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/Traditional-Chinese_Default-chart.sql b/sql/Traditional-Chinese_Default-chart.sql
index 5e46dc79..e93c70f8 100755
--- a/sql/Traditional-Chinese_Default-chart.sql
+++ b/sql/Traditional-Chinese_Default-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Default chart of accounts -- sample only
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','應付所得稅','A','','L','');
 insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','長期負債','H','','L','');
@@ -88,3 +89,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 --
+commit;
diff --git a/sql/UCOA-Form990-chart.sql b/sql/UCOA-Form990-chart.sql
index d9b73e8f..005acc93 100755
--- a/sql/UCOA-Form990-chart.sql
+++ b/sql/UCOA-Form990-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- UCOA Form 990
 --
 INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('1000','Cash','H','','A','');
@@ -239,3 +240,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
 
+commit;
diff --git a/sql/UCOA-Form990-gifi.sql b/sql/UCOA-Form990-gifi.sql
index ac40c13b..4a2c994e 100755
--- a/sql/UCOA-Form990-gifi.sql
+++ b/sql/UCOA-Form990-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 INSERT INTO gifi (accno, description) VALUES ('PartIV-B,82b', 'Part IV-B, 82b');
 INSERT INTO gifi (accno, description) VALUES ('10a&102', 'Line 10a & 102');
 INSERT INTO gifi (accno, description) VALUES ('10b&102', 'Line 10b & 102');
@@ -82,3 +83,4 @@ INSERT INTO gifi (accno, description) VALUES ('PartIV-A&82b', 'Part IV-A & 82b')
 INSERT INTO gifi (accno, description) VALUES ('PartIV-A', 'Part IV-A');
 INSERT INTO gifi (accno, description) VALUES ('capitalized', 'capitalized');
 INSERT INTO gifi (accno, description) VALUES ('contra1a', 'contra Line 1a');
+commit;
diff --git a/sql/UCOA-Form990EZ-chart.sql b/sql/UCOA-Form990EZ-chart.sql
index db29307d..bedf8571 100755
--- a/sql/UCOA-Form990EZ-chart.sql
+++ b/sql/UCOA-Form990EZ-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- UCOA Form 990EZ
 --
 INSERT INTO chart (accno, description, charttype, gifi_accno, category, link) VALUES ('1000','Cash','H','','A','');
@@ -239,3 +240,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
 
+commit;
diff --git a/sql/UCOA-Form990EZ-gifi.sql b/sql/UCOA-Form990EZ-gifi.sql
index 74f95c60..db1960ee 100755
--- a/sql/UCOA-Form990EZ-gifi.sql
+++ b/sql/UCOA-Form990EZ-gifi.sql
@@ -1,3 +1,4 @@
+begin;
 INSERT INTO gifi (accno, description) VALUES ('1&(6a)', 'Line 1 & (6a)');
 INSERT INTO gifi (accno, description) VALUES ('1', 'Line 1');
 INSERT INTO gifi (accno, description) VALUES ('10', 'Line 10');
@@ -20,3 +21,4 @@ INSERT INTO gifi (accno, description) VALUES ('5b', 'Line 5b');
 INSERT INTO gifi (accno, description) VALUES ('6a', 'Line 6a');
 INSERT INTO gifi (accno, description) VALUES ('8', 'Line 8');
 INSERT INTO gifi (accno, description) VALUES ('capitalized', 'capitalized');
+commit;
diff --git a/sql/UK_General-chart.sql b/sql/UK_General-chart.sql
index 3aca9ec3..e65cc286 100755
--- a/sql/UK_General-chart.sql
+++ b/sql/UK_General-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- sample COA for UK
 --
 INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('0010','Freehold Property','A','','A','');
@@ -119,3 +120,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',  (SELECT
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
+commit;
diff --git a/sql/US_General-chart.sql b/sql/US_General-chart.sql
index fc5ef754..485d5206 100755
--- a/sql/US_General-chart.sql
+++ b/sql/US_General-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- US_General COA
 -- modify as needed
 --
@@ -100,3 +101,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
 --
+commit;
diff --git a/sql/US_Manufacturing-chart.sql b/sql/US_Manufacturing-chart.sql
index f7225843..d82f3463 100755
--- a/sql/US_Manufacturing-chart.sql
+++ b/sql/US_Manufacturing-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- US_Manufacturing COA
 -- modify as needed
 --
@@ -92,3 +93,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
 
+commit;
diff --git a/sql/US_Service_Company-chart.sql b/sql/US_Service_Company-chart.sql
index 1318d8b5..abe55776 100755
--- a/sql/US_Service_Company-chart.sql
+++ b/sql/US_Service_Company-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- US_Service_Company COA
 -- modify as needed
 --
@@ -78,3 +79,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
 --
+commit;
diff --git a/sql/Venezuela_Default-chart.sql b/sql/Venezuela_Default-chart.sql
index f9c3fb3a..84656e5e 100755
--- a/sql/Venezuela_Default-chart.sql
+++ b/sql/Venezuela_Default-chart.sql
@@ -1,3 +1,4 @@
+begin;
 -- Venezuela General COA
 -- modify as needed
 --
@@ -98,3 +99,4 @@ INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select
 
  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
 
+commit;