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