1 -- @tag: project_customer_type_valid
2 -- @description: Projekt: Spalten "Kunde", "Typ", "Gültig"
3 -- @depends: release_3_0_0
5 ALTER TABLE project ADD COLUMN customer_id INTEGER;
6 ALTER TABLE project ADD COLUMN type TEXT;
7 ALTER TABLE project ADD COLUMN valid BOOLEAN;
8 ALTER TABLE project ALTER COLUMN valid SET DEFAULT TRUE;
10 ALTER TABLE project ADD FOREIGN KEY (customer_id) REFERENCES customer (id);
12 UPDATE project SET valid = TRUE;