1 -- @tag: defaults_only_customer_projects_in_sales
2 -- @description: Mandantenkonfiguration: in Verkaufsbelegen nur Projekte des ausgewählten Kunden anbieten
3 -- @depends: release_3_1_0
4 ALTER TABLE defaults ADD COLUMN customer_projects_only_in_sales BOOLEAN;
5 UPDATE defaults SET customer_projects_only_in_sales = FALSE;
7 ALTER COLUMN customer_projects_only_in_sales SET DEFAULT FALSE,
8 ALTER COLUMN customer_projects_only_in_sales SET NOT NULL;