1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
-- by: pfalcon
-- purpose: add default due periods (in sec) for tools
--30*24*60*60,
--0*24*60*60,
--15*24*60*60
ALTER TABLE groups ADD COLUMN bug_due_period int;
UPDATE groups SET bug_due_period=(30*24*60*60);
ALTER TABLE groups ALTER COLUMN bug_due_period SET NOT NULL;
ALTER TABLE groups ALTER COLUMN bug_due_period SET DEFAULT 2592000;
ALTER TABLE groups ADD COLUMN patch_due_period int;
UPDATE groups SET patch_due_period=(0*24*60*60);
ALTER TABLE groups ALTER COLUMN patch_due_period SET NOT NULL;
ALTER TABLE groups ALTER COLUMN patch_due_period SET DEFAULT 5184000;
ALTER TABLE groups ADD COLUMN support_due_period int;
UPDATE groups SET support_due_period=(15*24*60*60);
ALTER TABLE groups ALTER COLUMN support_due_period SET NOT NULL;
ALTER TABLE groups ALTER COLUMN support_due_period SET DEFAULT 1296000;
|
