X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/250fa402a8394de574f8ede1ce2345cef7f8b31b..65b7c724e:/sql/Pg-upgrade2/periodic_invoices.sql

diff --git a/sql/Pg-upgrade2/periodic_invoices.sql b/sql/Pg-upgrade2/periodic_invoices.sql
index 43c3b27cd..fcbb3e8a0 100644
--- a/sql/Pg-upgrade2/periodic_invoices.sql
+++ b/sql/Pg-upgrade2/periodic_invoices.sql
@@ -1,16 +1,19 @@
 -- @tag: periodic_invoices
--- @description: Neue Tabellen und Spalten für Wiederkehrende Rechnungen
+-- @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,
+       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',
+       terminated              boolean               DEFAULT 'f',
+       start_date              date,
+       end_date                date,
+       ar_chart_id             integer     NOT NULL,
+       extend_automatically_by integer,
 
        PRIMARY KEY (id),
        FOREIGN KEY (oe_id)       REFERENCES oe       (id),
@@ -19,11 +22,11 @@ CREATE TABLE periodic_invoices_configs (
 );
 
 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(),
+       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),
