-- @tag: project_bob_attributes
-- @description: Projekte: Zusätzliche Tabellen und Spalten
-- @depends: project_customer_type_valid
--- @charset: utf-8
-- changes over bob:
-- no scon/support_contract values here
-- no include or expclude flags for workload
--- statuses renamed to status (we dont use rails weird plurals)
-- created_at/updated_at renamed to itime/mtime,
-- varchars retyped to text
-- hours (numeric) changed to minutes (integer) since the code already calculates in minutes
-- note: flags changing the behaviour of hours are still called so and not minutes
--- no refcounts. we use adhoc counts to decide wether delete is possible or not
+-- no refcounts. we use adhoc counts to decide whether delete is possible or not
-- no hour_approval
-- nothing relevant to notifications
name TEXT NOT NULL,
description TEXT NOT NULL,
position INTEGER NOT NULL,
- itime TIMESTAMP DEFAULT 'now()',
+ itime TIMESTAMP DEFAULT now(),
mtime TIMESTAMP
);
budget_cost NUMERIC (15,5) NOT NULL DEFAULT 0,
general_minutes INTEGER NOT NULL DEFAULT 0,
general_cost_per_hour NUMERIC (15,5) NOT NULL DEFAULT 0,
- itime TIMESTAMP DEFAULT 'now()',
+ itime TIMESTAMP DEFAULT now(),
mtime TIMESTAMP
);
name TEXT NOT NULL,
description TEXT NOT NULL,
position INTEGER NOT NULL,
- itime TIMESTAMP DEFAULT 'now()',
+ itime TIMESTAMP DEFAULT now(),
mtime TIMESTAMP
);
project_role_id INTEGER NOT NULL REFERENCES project_roles(id),
minutes INTEGER NOT NULL DEFAULT 0,
cost_per_hour NUMERIC (15,5),
- itime TIMESTAMP DEFAULT 'now()',
+ itime TIMESTAMP DEFAULT now(),
mtime TIMESTAMP
);
project_role_id INTEGER NOT NULL REFERENCES project_roles(id),
minutes INTEGER NOT NULL DEFAULT 0,
cost_per_hour NUMERIC (15,5),
- itime TIMESTAMP DEFAULT 'now()',
+ itime TIMESTAMP DEFAULT now(),
mtime TIMESTAMP
);
CREATE TRIGGER mtime_project_roles BEFORE UPDATE ON project_roles FOR EACH ROW EXECUTE PROCEDURE set_mtime();
CREATE TRIGGER mtime_project_participants BEFORE UPDATE ON project_participants FOR EACH ROW EXECUTE PROCEDURE set_mtime();
CREATE TRIGGER mtime_project_phase_paticipants BEFORE UPDATE ON project_phase_participants FOR EACH ROW EXECUTE PROCEDURE set_mtime();
-