Mercurial > ~dholland > hg > swallowtail > index.cgi
diff database/schema/bugs.sql @ 38:68a4f2d8930e
Add stuff for automatic feedback timeout.
author | David A. Holland |
---|---|
date | Sun, 15 Jun 2014 17:21:54 -0400 (2014-06-15) |
parents | 7458a278cb64 |
children | 45bb7b516edb |
line wrap: on
line diff
--- a/database/schema/bugs.sql Sun Jun 15 17:13:50 2014 -0400 +++ b/database/schema/bugs.sql Sun Jun 15 17:21:54 2014 -0400 @@ -24,6 +24,18 @@ -- should always return empty. -- (no PR should be locked unless it is closed) + -- Timeouts cause bugs to automatically change state in the + -- future. This is intended to be used for e.g. "feedback + -- timeout". + -- + -- States that should have a timeout installed are tagged + -- accordingly in the states table. When changing the state of + -- a PR, if the new state expects a timeout the PR should be + -- given a non-null timeout; otherwise, the timeout field + -- should be nulled. + timeout_date timestamp null, + timeout_state text null references states (name), + -- fixed-size history arrival_schemaversion int not null, arrival_date timestamp not null,