kivitendo/sql/Pg-upgrade2/project_defaults.sql @ bf5e6c6a
| 19e40226 | Jan Büren | -- @tag: add_project_defaults
|
||
| d3007329 | Geoffrey Richardson | -- @description: Standardprojekttyp und Standardprojectstatus
|
||
| 19e40226 | Jan Büren | -- @depends: release_3_3_0
|
||
| d3007329 | Geoffrey Richardson | ALTER TABLE defaults ADD COLUMN order_always_project boolean DEFAULT false;
|
||
ALTER TABLE defaults ADD COLUMN project_status_id integer;
|
||||
ALTER TABLE defaults ADD COLUMN project_type_id integer;
|
||||
ALTER TABLE defaults ADD FOREIGN KEY (project_status_id) REFERENCES project_statuses (id);
|
||||
ALTER TABLE defaults ADD FOREIGN KEY (project_type_id) REFERENCES project_types (id);
|