From c8b11e54fcf197c93dd8dd0c51aa3822dfb857c1 Mon Sep 17 00:00:00 2001 From: Udo Spallek Date: Tue, 30 Jan 2007 03:10:49 +0000 Subject: [PATCH] Leeren Kontenrahmen auf die Basics erweitert. --- sql/Leerer-Kontenrahmen-chart.sql | 40 ++++++++++++++++++++++++++++++- 1 file changed, 39 insertions(+), 1 deletion(-) diff --git a/sql/Leerer-Kontenrahmen-chart.sql b/sql/Leerer-Kontenrahmen-chart.sql index d42c9e46c..d7299620e 100644 --- a/sql/Leerer-Kontenrahmen-chart.sql +++ b/sql/Leerer-Kontenrahmen-chart.sql @@ -1,2 +1,40 @@ --- empty COA +-- changes on system tables +-- TODO Make me Update2 +ALTER TABLE tax ALTER COLUMN taxkey DROP NOT NULL; + +-- Minimal COA + +INSERT INTO chart ( + accno, description, charttype, category, link, + gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, + pos_eur, datevautomatik, new_chart_id, valid_from +) VALUES ( + ' ', 'Nicht zugeordnet' 'A', '', '', + '', 0, 0, 0, 0, + 0, FALSE, 0, now() +); + +-- Minimal Tax Konfiguration + +INSERT INTO tax + (chart_id, rate, taxnumber, taxkey, taxdescription) +VALUES ('0', '0', '0', '0', 'ohne Steuerautomatik'); + + + + + + + + + + + + + + + + + + -- 2.20.1