Datenbankupgradescript, Rose-Models für Wiederkehrende Rechnungen

[kivitendo-erp.git] / sql / Pg-upgrade2 / periodic_invoices.sql

diff --git a/sql/Pg-upgrade2/periodic_invoices.sql b/sql/Pg-upgrade2/periodic_invoices.sql
new file mode 100644 (file)
index 0000000..43c3b27
--- /dev/null
+++ b/sql/Pg-upgrade2/periodic_invoices.sql
@@ -0,0 +1,31 @@
+-- @tag: periodic_invoices
+-- @description: Neue Tabellen und Spalten für Wiederkehrende Rechnungen
+-- @depends: release_2_6_1
+CREATE TABLE periodic_invoices_configs (
+       id integer              NOT NULL DEFAULT nextval('id'),
+       oe_id integer           NOT NULL,
+       periodicity varchar(10) NOT NULL,
+       print boolean                    DEFAULT 'f',
+       printer_id integer,
+       copies integer,
+       active boolean                   DEFAULT 't',
+       start_date date,
+       ar_chart_id integer     NOT NULL,
+
+       PRIMARY KEY (id),
+       FOREIGN KEY (oe_id)       REFERENCES oe       (id),
+       FOREIGN KEY (printer_id)  REFERENCES printers (id),
+       FOREIGN KEY (ar_chart_id) REFERENCES chart    (id)
+);
+
+CREATE TABLE periodic_invoices (
+       id integer             NOT NULL DEFAULT nextval('id'),
+       config_id integer      NOT NULL,
+       ar_id integer          NOT NULL,
+       period_start_date date NOT NULL,
+       itime timestamp                 DEFAULT now(),
+
+       PRIMARY KEY (id),
+       FOREIGN KEY (config_id) REFERENCES periodic_invoices_configs (id),
+       FOREIGN KEY (ar_id)     REFERENCES ar                        (id)
+);