X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FLeerer-Kontenrahmen-chart.sql;h=e55ba394b1f126981c31095b2701ae9451a09807;hb=abafb475d9742e3a6c28427477235c923b21eeef;hp=d42c9e46cd8e367c1fe7536a114d12647cec6caa;hpb=f50c1d90ec37816414ae5a28241d854256edba03;p=kivitendo-erp.git

diff --git a/sql/Leerer-Kontenrahmen-chart.sql b/sql/Leerer-Kontenrahmen-chart.sql
index d42c9e46c..e55ba394b 100644
--- a/sql/Leerer-Kontenrahmen-chart.sql
+++ b/sql/Leerer-Kontenrahmen-chart.sql
@@ -1,2 +1,90 @@
--- empty COA
+-- Minimal Chart of Accounts
 
+INSERT INTO chart (
+  id,           accno,           description,         charttype,     category,
+
+  link, -- create links to all forms as default
+  
+  gifi_accno,  taxkey_id,       pos_ustva,            pos_bwa,       pos_bilanz,  
+  pos_eur,     datevautomatik,  new_chart_id,         valid_from
+
+) VALUES (
+
+  0,           '0',             'Nicht zugeordnet',  'A',           'A',
+  'AR:AP:IC:AR_amount:AR_paid:AP_amount:AP_paid:IC_sale:IC_cogs:IC_income:IC_expense',
+  '',          0,               0 ,                   0,             0,          
+  0,           FALSE,           0 ,                   now()  
+);
+
+-- Minimal Tax-o-matic Configuration
+
+INSERT INTO tax (
+        id,   chart_id,  rate,  taxnumber,  taxkey,  taxdescription
+)  VALUES  (
+        '0',  '0',       '0',   '0',        '0',     'ohne Steuerautomatik');
+
+
+INSERT INTO taxkeys (
+        id, chart_id, tax_id, taxkey_id, pos_ustva, startdate
+)  VALUES  (
+        0,  0,        0,      0,         0,         '1970-01-01'
+);
+
+DELETE FROM tax_zones;
+
+INSERT INTO tax_zones (
+        id,  description
+)  VALUES  (
+         0,  'keiner'
+);
+
+
+-- Minimal buchungsgruppen
+INSERT INTO buchungsgruppen (
+        id,                  description,         inventory_accno_id,  
+        income_accno_id_0,   expense_accno_id_0,  income_accno_id_1, 
+        expense_accno_id_1,  income_accno_id_2,   expense_accno_id_2, 
+        income_accno_id_3,   expense_accno_id_3
+)  VALUES   (
+        0,                  'keine',              0, 
+        0,                   0,                   0, 
+        0,                   0,                   0, 
+        0,                   0
+);
+
+-- Minimal
+
+INSERT INTO customer (
+             id,  name
+)  VALUES  (  0,  ' keiner');
+
+INSERT INTO vendor (
+             id,  name
+)  VALUES  (  0,  ' keiner');
+
+
+
+-- Minimal defaults
+
+update defaults set 
+  inventory_accno_id =  0, 
+  income_accno_id    =  0, 
+  expense_accno_id   =  0, 
+  fxgain_accno_id    =  0, 
+  fxloss_accno_id    =  0, 
+  invnumber          = '1', 
+  sonumber           = '1', 
+  ponumber           = '1', 
+  sqnumber           = '1',
+  rfqnumber          = '1',
+  customernumber     = '1',
+  vendornumber       = '1',
+  articlenumber      = '1',
+  servicenumber      = '1',
+  rmanumber          = '1',
+  cnnumber           = '1',
+  coa                = 'Leerer-Kontenrahmen',
+  curr               = 'EUR:USD', 
+  weightunit         = 'kg';
+
+                                                    
\ No newline at end of file