1 -- @tag: project_bob_attributes_itime_default_fix
2 -- @description: Standardwert für 'itime'-Spalten in Bob-Tabellen fixen
3 -- @depends: project_bob_attributes
5 ALTER TABLE project ALTER COLUMN itime SET DEFAULT now();
6 ALTER TABLE project_status ALTER COLUMN itime SET DEFAULT now();
7 ALTER TABLE project_phases ALTER COLUMN itime SET DEFAULT now();
8 ALTER TABLE project_roles ALTER COLUMN itime SET DEFAULT now();
9 ALTER TABLE project_participants ALTER COLUMN itime SET DEFAULT now();
10 ALTER TABLE project_phase_participants ALTER COLUMN itime SET DEFAULT now();