-- 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';