diff options
Diffstat (limited to 'sql')
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; |