sqlchanges20010112.sql

来自「GForge 3.0 协作开发平台 支持CVS, mailing lists, 」· SQL 代码 · 共 10 行

-- 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 NOT NULL DEFAULT 2592000;
ALTER TABLE groups ADD COLUMN patch_due_period int NOT NULL DEFAULT 5184000;
ALTER TABLE groups ADD COLUMN support_due_period int NOT NULL DEFAULT 1296000;