summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rwxr-xr-xsql/Australia_General_0000-chart.sql2
-rwxr-xr-xsql/Australia_General_00000-chart.sql2
-rwxr-xr-xsql/Austria-chart.sql2
-rwxr-xr-xsql/Austria-gifi.sql2
-rwxr-xr-xsql/Bahasa-Indonesia_Default-chart.sql2
-rwxr-xr-xsql/Belgium-chart.sql2
-rwxr-xr-xsql/Belgium-gifi.sql2
-rwxr-xr-xsql/Brazil_General-chart.sql2
-rwxr-xr-xsql/Canada-English-gifi.sql2
-rwxr-xr-xsql/Canada-English_General-chart.sql2
-rwxr-xr-xsql/Canada-Quebec-UTF8-gifi.sql2
-rwxr-xr-xsql/Canada-Quebec-gifi.sql2
-rwxr-xr-xsql/Canada-Quebec_General-UTF8-chart.sql2
-rwxr-xr-xsql/Canada-Quebec_General-chart.sql2
-rwxr-xr-xsql/Colombia-utf8-PUC-chart.sql2
-rwxr-xr-xsql/Colombia-utf8-PUC-gifi.sql2
-rwxr-xr-xsql/Czech-Republic-chart.sql2
-rwxr-xr-xsql/Danish_Default-UTF8-chart.sql2
-rwxr-xr-xsql/Danish_Default-chart.sql2
-rwxr-xr-xsql/Default-chart.sql2
-rwxr-xr-xsql/Dutch_Default-chart.sql2
-rwxr-xr-xsql/Dutch_Standard-chart.sql2
-rwxr-xr-xsql/Egypt-UTF8-chart.sql2
-rwxr-xr-xsql/Egypt-chart.sql2
-rwxr-xr-xsql/France-chart.sql2
-rwxr-xr-xsql/German-Sample-chart.sql2
-rwxr-xr-xsql/German-Sample-gifi.sql2
-rwxr-xr-xsql/Germany-DATEV-SKR03-chart.sql2
-rwxr-xr-xsql/Germany-DATEV-SKR03-gifi.sql2
-rwxr-xr-xsql/Germany-SKR03-chart.sql2
-rwxr-xr-xsql/Germany-SKR03-gifi.sql2
-rwxr-xr-xsql/Hungary-chart.sql2
-rwxr-xr-xsql/Hungary-gifi.sql2
-rwxr-xr-xsql/Italy-gifi.sql2
-rwxr-xr-xsql/Italy_General-chart.sql2
-rwxr-xr-xsql/Italy_cc2424-chart.sql2
-rwxr-xr-xsql/Latvia-chart.sql2
-rwxr-xr-xsql/NAICS.sql2
-rwxr-xr-xsql/Norwegian_Default-chart.sql2
-rwxr-xr-xsql/Paraguay-chart.sql2
-rwxr-xr-xsql/Paraguay-gifi.sql2
-rwxr-xr-xsql/Pg-central.sql2
-rw-r--r--sql/Pg-database.sql2
-rwxr-xr-xsql/Poland-chart.sql2
-rwxr-xr-xsql/Simplified-Chinese_Default-UTF8-chart.sql2
-rwxr-xr-xsql/Simplified-Chinese_Default-chart.sql2
-rwxr-xr-xsql/Spain-ISO-chart.sql2
-rwxr-xr-xsql/Spain-UTF8-chart.sql2
-rwxr-xr-xsql/Spain-chart.sql2
-rwxr-xr-xsql/Sweden-chart.sql2
-rwxr-xr-xsql/Sweden-gifi.sql2
-rwxr-xr-xsql/Sweden_Agriculture-chart.sql2
-rwxr-xr-xsql/Sweden_Church_Society-chart.sql2
-rwxr-xr-xsql/Swiss-German-chart.sql2
-rwxr-xr-xsql/Swiss-German-gifi.sql2
-rwxr-xr-xsql/Traditional-Chinese_Default-UTF8-chart.sql2
-rwxr-xr-xsql/Traditional-Chinese_Default-chart.sql2
-rwxr-xr-xsql/UCOA-Form990-chart.sql2
-rwxr-xr-xsql/UCOA-Form990-gifi.sql2
-rwxr-xr-xsql/UCOA-Form990EZ-chart.sql2
-rwxr-xr-xsql/UCOA-Form990EZ-gifi.sql2
-rwxr-xr-xsql/UK_General-chart.sql2
-rwxr-xr-xsql/US_General-chart.sql2
-rwxr-xr-xsql/US_Manufacturing-chart.sql2
-rwxr-xr-xsql/US_Service_Company-chart.sql2
-rwxr-xr-xsql/Venezuela_Default-chart.sql2
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;