Revision f49ad7f1
Von Moritz Bunkus vor fast 14 Jahren hinzugefügt
| sql/Pg-upgrade2/periodic_invoices.sql | ||
|---|---|---|
| 2 | 2 |
-- @description: Neue Tabellen und Spalten f?r Wiederkehrende Rechnungen |
| 3 | 3 |
-- @depends: release_2_6_1 |
| 4 | 4 |
CREATE TABLE periodic_invoices_configs ( |
| 5 |
id integer NOT NULL DEFAULT nextval('id'),
|
|
| 6 |
oe_id integer NOT NULL, |
|
| 7 |
periodicity varchar(10) NOT NULL, |
|
| 8 |
print boolean DEFAULT 'f', |
|
| 9 |
printer_id integer, |
|
| 10 |
copies integer, |
|
| 11 |
active boolean DEFAULT 't', |
|
| 12 |
start_date date, |
|
| 13 |
ar_chart_id integer NOT NULL, |
|
| 5 |
id integer NOT NULL DEFAULT nextval('id'),
|
|
| 6 |
oe_id integer NOT NULL, |
|
| 7 |
periodicity varchar(10) NOT NULL, |
|
| 8 |
print boolean DEFAULT 'f', |
|
| 9 |
printer_id integer, |
|
| 10 |
copies integer, |
|
| 11 |
active boolean DEFAULT 't', |
|
| 12 |
terminated boolean DEFAULT 'f', |
|
| 13 |
start_date date, |
|
| 14 |
end_date date, |
|
| 15 |
ar_chart_id integer NOT NULL, |
|
| 16 |
extend_automatically_by integer, |
|
| 14 | 17 |
|
| 15 | 18 |
PRIMARY KEY (id), |
| 16 | 19 |
FOREIGN KEY (oe_id) REFERENCES oe (id), |
| ... | ... | |
| 19 | 22 |
); |
| 20 | 23 |
|
| 21 | 24 |
CREATE TABLE periodic_invoices ( |
| 22 |
id integer NOT NULL DEFAULT nextval('id'),
|
|
| 23 |
config_id integer NOT NULL,
|
|
| 24 |
ar_id integer NOT NULL,
|
|
| 25 |
period_start_date date NOT NULL, |
|
| 26 |
itime timestamp DEFAULT now(),
|
|
| 25 |
id integer NOT NULL DEFAULT nextval('id'),
|
|
| 26 |
config_id integer NOT NULL,
|
|
| 27 |
ar_id integer NOT NULL,
|
|
| 28 |
period_start_date date NOT NULL,
|
|
| 29 |
itime timestamp DEFAULT now(),
|
|
| 27 | 30 |
|
| 28 | 31 |
PRIMARY KEY (id), |
| 29 | 32 |
FOREIGN KEY (config_id) REFERENCES periodic_invoices_configs (id), |
Auch abrufbar als: Unified diff
Felder end_date, terminated, extend_automatically_by ergänzt