[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [611] trunk/sql
- Subject: SF.net SVN: ledger-smb: [611] trunk/sql
- From: ..hidden..
- Date: Tue, 14 Nov 2006 20:51:45 -0800
Revision: 611
http://svn.sourceforge.net/ledger-smb/?rev=611&view=rev
Author: einhverfr
Date: 2006-11-14 20:51:45 -0800 (Tue, 14 Nov 2006)
Log Message:
-----------
Making sql files internally single transactions
Modified Paths:
--------------
trunk/sql/Australia_General_0000-chart.sql
trunk/sql/Australia_General_00000-chart.sql
trunk/sql/Austria-chart.sql
trunk/sql/Austria-gifi.sql
trunk/sql/Bahasa-Indonesia_Default-chart.sql
trunk/sql/Belgium-chart.sql
trunk/sql/Belgium-gifi.sql
trunk/sql/Brazil_General-chart.sql
trunk/sql/Canada-English-gifi.sql
trunk/sql/Canada-English_General-chart.sql
trunk/sql/Canada-Quebec-UTF8-gifi.sql
trunk/sql/Canada-Quebec-gifi.sql
trunk/sql/Canada-Quebec_General-UTF8-chart.sql
trunk/sql/Canada-Quebec_General-chart.sql
trunk/sql/Colombia-utf8-PUC-chart.sql
trunk/sql/Colombia-utf8-PUC-gifi.sql
trunk/sql/Czech-Republic-chart.sql
trunk/sql/Danish_Default-UTF8-chart.sql
trunk/sql/Danish_Default-chart.sql
trunk/sql/Default-chart.sql
trunk/sql/Dutch_Default-chart.sql
trunk/sql/Dutch_Standard-chart.sql
trunk/sql/Egypt-UTF8-chart.sql
trunk/sql/Egypt-chart.sql
trunk/sql/France-chart.sql
trunk/sql/German-Sample-chart.sql
trunk/sql/German-Sample-gifi.sql
trunk/sql/Germany-DATEV-SKR03-chart.sql
trunk/sql/Germany-DATEV-SKR03-gifi.sql
trunk/sql/Germany-SKR03-chart.sql
trunk/sql/Germany-SKR03-gifi.sql
trunk/sql/Hungary-chart.sql
trunk/sql/Hungary-gifi.sql
trunk/sql/Italy-gifi.sql
trunk/sql/Italy_General-chart.sql
trunk/sql/Italy_cc2424-chart.sql
trunk/sql/Latvia-chart.sql
trunk/sql/NAICS.sql
trunk/sql/Norwegian_Default-chart.sql
trunk/sql/Paraguay-chart.sql
trunk/sql/Paraguay-gifi.sql
trunk/sql/Pg-central.sql
trunk/sql/Pg-database.sql
trunk/sql/Poland-chart.sql
trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql
trunk/sql/Simplified-Chinese_Default-chart.sql
trunk/sql/Spain-ISO-chart.sql
trunk/sql/Spain-UTF8-chart.sql
trunk/sql/Spain-chart.sql
trunk/sql/Sweden-chart.sql
trunk/sql/Sweden-gifi.sql
trunk/sql/Sweden_Agriculture-chart.sql
trunk/sql/Sweden_Church_Society-chart.sql
trunk/sql/Swiss-German-chart.sql
trunk/sql/Swiss-German-gifi.sql
trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql
trunk/sql/Traditional-Chinese_Default-chart.sql
trunk/sql/UCOA-Form990-chart.sql
trunk/sql/UCOA-Form990-gifi.sql
trunk/sql/UCOA-Form990EZ-chart.sql
trunk/sql/UCOA-Form990EZ-gifi.sql
trunk/sql/UK_General-chart.sql
trunk/sql/US_General-chart.sql
trunk/sql/US_Manufacturing-chart.sql
trunk/sql/US_Service_Company-chart.sql
trunk/sql/Venezuela_Default-chart.sql
Modified: trunk/sql/Australia_General_0000-chart.sql
===================================================================
--- trunk/sql/Australia_General_0000-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Australia_General_0000-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Australia_General_00000-chart.sql
===================================================================
--- trunk/sql/Australia_General_00000-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Australia_General_00000-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Australia chart of accounts
-- sample only
--
@@ -88,3 +89,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Austria-chart.sql
===================================================================
--- trunk/sql/Austria-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Austria-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Austria-gifi.sql
===================================================================
--- trunk/sql/Austria-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Austria-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('985', 'SchluÃbilanz');
INSERT INTO gifi (accno, description) VALUES ('989', 'Gewinn- und Verlustrechnung');
INSERT INTO gifi (accno, description) VALUES ('990-999', 'Evidenzkonten');
+commit;
Modified: trunk/sql/Bahasa-Indonesia_Default-chart.sql
===================================================================
--- trunk/sql/Bahasa-Indonesia_Default-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Bahasa-Indonesia_Default-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Belgium-chart.sql
===================================================================
--- trunk/sql/Belgium-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Belgium-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- selon PLAN COMPTABLE MINIMUM NORMALISE BELGE
-- contribu. par Jens-Ingo Brodesser, ..hidden..
-- verified May 19, 2006
@@ -444,3 +445,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR:USD');
+commit;
Modified: trunk/sql/Belgium-gifi.sql
===================================================================
--- trunk/sql/Belgium-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Belgium-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- contribuà par Jens-Ingo Brodesser, ..hidden.., Moving Art Studio ASBL, ALL2ALL The Independent Network
-- le 15/07/2003
@@ -66,3 +67,4 @@
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;
Modified: trunk/sql/Brazil_General-chart.sql
===================================================================
--- trunk/sql/Brazil_General-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Brazil_General-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Canada-English-gifi.sql
===================================================================
--- trunk/sql/Canada-English-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Canada-English-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 @@
-- 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;
Modified: trunk/sql/Canada-English_General-chart.sql
===================================================================
--- trunk/sql/Canada-English_General-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Canada-English_General-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('curr', 'CAD:USD:EUR');
INSERT INTO defaults (setting_key, value) values ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Canada-Quebec-UTF8-gifi.sql
===================================================================
--- trunk/sql/Canada-Quebec-UTF8-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Canada-Quebec-UTF8-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('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;
Modified: trunk/sql/Canada-Quebec-gifi.sql
===================================================================
--- trunk/sql/Canada-Quebec-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Canada-Quebec-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('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;
Modified: trunk/sql/Canada-Quebec_General-UTF8-chart.sql
===================================================================
--- trunk/sql/Canada-Quebec_General-UTF8-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Canada-Quebec_General-UTF8-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('curr', 'CAD:USD:EUR');
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Canada-Quebec_General-chart.sql
===================================================================
--- trunk/sql/Canada-Quebec_General-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Canada-Quebec_General-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('curr', 'CAD:USD:EUR');
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Colombia-utf8-PUC-chart.sql
===================================================================
--- trunk/sql/Colombia-utf8-PUC-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Colombia-utf8-PUC-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Colombia-utf8-PUC-gifi.sql
===================================================================
--- trunk/sql/Colombia-utf8-PUC-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Colombia-utf8-PUC-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
--
--
-- Data for Plan ÃÂnico de Cuentas (PUC) Gifi Table
@@ -2471,3 +2472,4 @@
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;
Modified: trunk/sql/Czech-Republic-chart.sql
===================================================================
--- trunk/sql/Czech-Republic-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Czech-Republic-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Czech chart of accounts
-- ..hidden..
-- Kompletnà ÃÃtovà osnova platnà v roce 2001
@@ -327,3 +328,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Danish_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Danish_Default-UTF8-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Danish_Default-UTF8-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Danish_Default-chart.sql
===================================================================
--- trunk/sql/Danish_Default-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Danish_Default-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Default-chart.sql
===================================================================
--- trunk/sql/Default-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Default-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 @@
VALUES ('curr', 'USD:CAD:EUR');
INSERT INTO defaults (setting_key, value)
VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Dutch_Default-chart.sql
===================================================================
--- trunk/sql/Dutch_Default-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Dutch_Default-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Dutch_Standard-chart.sql
===================================================================
--- trunk/sql/Dutch_Standard-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Dutch_Standard-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ..hidden.. )
@@ -243,3 +244,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Egypt-UTF8-chart.sql
===================================================================
--- trunk/sql/Egypt-UTF8-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Egypt-UTF8-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 accno = '2320'),'0.14',NULL);
INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2330'),'0.3',NULL);
+commit;
Modified: trunk/sql/Egypt-chart.sql
===================================================================
--- trunk/sql/Egypt-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Egypt-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 accno = '2320'),'0.14',NULL);
INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2330'),'0.3',NULL);
+commit;
Modified: trunk/sql/France-chart.sql
===================================================================
--- trunk/sql/France-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/France-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Chart of Accounts for France
-- From: Oscar Buijten <..hidden..>
-- Mon, 6 Aug 2001
@@ -961,3 +962,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/German-Sample-chart.sql
===================================================================
--- trunk/sql/German-Sample-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/German-Sample-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Einfacher Deutscher Kontenrahmen => Very Easy German Default Chart
-- Vorbereitet von / Prepared by Paul Tammes May 9th, 2002. Kommentar / Comments : ..hidden..
-- 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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/German-Sample-gifi.sql
===================================================================
--- trunk/sql/German-Sample-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/German-Sample-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('P2', 'Fremdkapital Langfristig');
INSERT INTO gifi (accno,description) VALUES ('P3', 'Fremdkapital Kurzfristig');
INSERT INTO gifi (accno,description) VALUES ('P4', 'Passive Rechnungsabgrenzung');
+commit;
Modified: trunk/sql/Germany-DATEV-SKR03-chart.sql
===================================================================
--- trunk/sql/Germany-DATEV-SKR03-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Germany-DATEV-SKR03-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 = '0177100'),0.07);
INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '0177500'),0.16);
+commit;
Modified: trunk/sql/Germany-DATEV-SKR03-gifi.sql
===================================================================
--- trunk/sql/Germany-DATEV-SKR03-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Germany-DATEV-SKR03-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('0989800', 'Statistisches Konto AfA (Kalkul.)');
INSERT INTO gifi (accno,description) VALUES ('0989900', 'Statistisches Konto AfA');
INSERT INTO gifi (accno,description) VALUES ('0999999', 'Fehlerauffangkonto');
+commit;
Modified: trunk/sql/Germany-SKR03-chart.sql
===================================================================
--- trunk/sql/Germany-SKR03-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Germany-SKR03-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Germany-SKR03-gifi.sql
===================================================================
--- trunk/sql/Germany-SKR03-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Germany-SKR03-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('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;
Modified: trunk/sql/Hungary-chart.sql
===================================================================
--- trunk/sql/Hungary-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Hungary-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('curr', 'HUF:EUR:USD');
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Hungary-gifi.sql
===================================================================
--- trunk/sql/Hungary-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Hungary-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('8','RÃFORDÃTÃSOK');
INSERT INTO gifi (accno,description) VALUES ('9','BEVÃTELEK');
--
+commit;
Modified: trunk/sql/Italy-gifi.sql
===================================================================
--- trunk/sql/Italy-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Italy-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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.22', 'Imposte sul reddito dell\'esercizio');
INSERT INTO gifi (accno,description) VALUES ('3.E.26', 'Utile o perdita di esercizio');
+commit;
Modified: trunk/sql/Italy_General-chart.sql
===================================================================
--- trunk/sql/Italy_General-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Italy_General-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
--
-- Chart of Accounts for Italy
--
@@ -189,3 +190,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Italy_cc2424-chart.sql
===================================================================
--- trunk/sql/Italy_cc2424-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Italy_cc2424-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
--
-- Chart of Accounts for Italy
--
@@ -268,3 +269,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Latvia-chart.sql
===================================================================
--- trunk/sql/Latvia-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Latvia-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Latvian COA
-- prepared by Kaspars Melkis <..hidden..>
-- Sept. 14, 2003
@@ -263,3 +264,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/NAICS.sql
===================================================================
--- trunk/sql/NAICS.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/NAICS.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('928110','National Security');
INSERT INTO sic (code,description) VALUES ('92812','International Affairs');
INSERT INTO sic (code,description) VALUES ('928120','International Affairs');
+commit;
Modified: trunk/sql/Norwegian_Default-chart.sql
===================================================================
--- trunk/sql/Norwegian_Default-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Norwegian_Default-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Paraguay-chart.sql
===================================================================
--- trunk/sql/Paraguay-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Paraguay-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
--
-- LedgerSMB Sample COA - Paraguay
-- Version: 2.4.6
@@ -264,3 +265,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Paraguay-gifi.sql
===================================================================
--- trunk/sql/Paraguay-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Paraguay-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Paraguay GIFI
-- Plan de Cuentas Fiscal para Paraguay
--
@@ -106,3 +107,4 @@
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;
Modified: trunk/sql/Pg-central.sql
===================================================================
--- trunk/sql/Pg-central.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Pg-central.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 @@
users_id INTEGER -- NOT NULL references users(id)
);
+commit;
Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Pg-database.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
--
CREATE SEQUENCE id start 10000;
SELECT nextval ('id');
@@ -1134,3 +1135,4 @@
END;
' LANGUAGE PLPGSQL;
-- end function
+commit;
Modified: trunk/sql/Poland-chart.sql
===================================================================
--- trunk/sql/Poland-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Poland-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Chart of Account for Poland
-- From: Peter Dabrowski <..hidden..>
-- Sun, 23 March 2003
@@ -345,3 +346,4 @@
--
+commit;
Modified: trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Simplified-Chinese_Default-chart.sql
===================================================================
--- trunk/sql/Simplified-Chinese_Default-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Simplified-Chinese_Default-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Spain-ISO-chart.sql
===================================================================
--- trunk/sql/Spain-ISO-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Spain-ISO-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad espaÃol)
-- From: Federico Montesino Pouzols <..hidden..>
-- 23 Apr 2002
@@ -142,3 +143,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'Kg');
--
+commit;
Modified: trunk/sql/Spain-UTF8-chart.sql
===================================================================
--- trunk/sql/Spain-UTF8-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Spain-UTF8-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad espaÃol)
-- From: Federico Montesino Pouzols <..hidden..>
-- 23 Apr 2002
@@ -142,3 +143,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit' , 'Kg';
--
+commit;
Modified: trunk/sql/Spain-chart.sql
===================================================================
--- trunk/sql/Spain-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Spain-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad espaÃol)
-- From: Federico Montesino Pouzols <..hidden..>
-- 23 Apr 2002
@@ -142,3 +143,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit' , 'Kg';
--
+commit;
Modified: trunk/sql/Sweden-chart.sql
===================================================================
--- trunk/sql/Sweden-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Sweden-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- May 7, 2006
-- Johan Hambraeus
--
@@ -1148,3 +1149,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Sweden-gifi.sql
===================================================================
--- trunk/sql/Sweden-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Sweden-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('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;
Modified: trunk/sql/Sweden_Agriculture-chart.sql
===================================================================
--- trunk/sql/Sweden_Agriculture-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Sweden_Agriculture-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- COA for Agriculture
-- Johan Hambraeus
-- May 7, 2006
@@ -1311,3 +1312,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Sweden_Church_Society-chart.sql
===================================================================
--- trunk/sql/Sweden_Church_Society-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Sweden_Church_Society-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Johan Hambraeus
-- May 7, 2006
--
@@ -241,3 +242,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
Modified: trunk/sql/Swiss-German-chart.sql
===================================================================
--- trunk/sql/Swiss-German-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Swiss-German-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Swiss-German-gifi.sql
===================================================================
--- trunk/sql/Swiss-German-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Swiss-German-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('92000','BILANZ');
INSERT INTO gifi (accno,description) VALUES ('93000','GEWINNVERWENDUNG');
INSERT INTO gifi (accno,description) VALUES ('99000','SAMMEL- UND FEHLBUCHUNGEN');
+commit;
Modified: trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/Traditional-Chinese_Default-chart.sql
===================================================================
--- trunk/sql/Traditional-Chinese_Default-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Traditional-Chinese_Default-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
--
+commit;
Modified: trunk/sql/UCOA-Form990-chart.sql
===================================================================
--- trunk/sql/UCOA-Form990-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/UCOA-Form990-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'lbs');
+commit;
Modified: trunk/sql/UCOA-Form990-gifi.sql
===================================================================
--- trunk/sql/UCOA-Form990-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/UCOA-Form990-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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', 'Part IV-A');
INSERT INTO gifi (accno, description) VALUES ('capitalized', 'capitalized');
INSERT INTO gifi (accno, description) VALUES ('contra1a', 'contra Line 1a');
+commit;
Modified: trunk/sql/UCOA-Form990EZ-chart.sql
===================================================================
--- trunk/sql/UCOA-Form990EZ-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/UCOA-Form990EZ-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'lbs');
+commit;
Modified: trunk/sql/UCOA-Form990EZ-gifi.sql
===================================================================
--- trunk/sql/UCOA-Form990EZ-gifi.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/UCOA-Form990EZ-gifi.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('6a', 'Line 6a');
INSERT INTO gifi (accno, description) VALUES ('8', 'Line 8');
INSERT INTO gifi (accno, description) VALUES ('capitalized', 'capitalized');
+commit;
Modified: trunk/sql/UK_General-chart.sql
===================================================================
--- trunk/sql/UK_General-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/UK_General-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -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 ('weightunit', 'kg');
+commit;
Modified: trunk/sql/US_General-chart.sql
===================================================================
--- trunk/sql/US_General-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/US_General-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- US_General COA
-- modify as needed
--
@@ -100,3 +101,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
--
+commit;
Modified: trunk/sql/US_Manufacturing-chart.sql
===================================================================
--- trunk/sql/US_Manufacturing-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/US_Manufacturing-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- US_Manufacturing COA
-- modify as needed
--
@@ -92,3 +93,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
+commit;
Modified: trunk/sql/US_Service_Company-chart.sql
===================================================================
--- trunk/sql/US_Service_Company-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/US_Service_Company-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- US_Service_Company COA
-- modify as needed
--
@@ -78,3 +79,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'lbs');
--
+commit;
Modified: trunk/sql/Venezuela_Default-chart.sql
===================================================================
--- trunk/sql/Venezuela_Default-chart.sql 2006-11-15 04:49:45 UTC (rev 610)
+++ trunk/sql/Venezuela_Default-chart.sql 2006-11-15 04:51:45 UTC (rev 611)
@@ -1,3 +1,4 @@
+begin;
-- Venezuela General COA
-- modify as needed
--
@@ -98,3 +99,4 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
+commit;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.