Mercurial > ~dholland > hg > swallowtail > index.cgi

comparison database/schema/bugs.sql @ 38:68a4f2d8930e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add stuff for automatic feedback timeout.
author David A. Holland
date Sun, 15 Jun 2014 17:21:54 -0400
parents 7458a278cb64
children 45bb7b516edb
comparison
equal deleted inserted replaced
37:edf081d0b282 38:68a4f2d8930e
21 -- intended constraint: 21 -- intended constraint:
22 -- select * from PRs, states where PRs.state = states.name 22 -- select * from PRs, states where PRs.state = states.name
23 -- and states.closed = false and PRs.locked = true 23 -- and states.closed = false and PRs.locked = true
24 -- should always return empty. 24 -- should always return empty.
25 -- (no PR should be locked unless it is closed) 25 -- (no PR should be locked unless it is closed)
26
27 -- Timeouts cause bugs to automatically change state in the
28 -- future. This is intended to be used for e.g. "feedback
29 -- timeout".
30 --
31 -- States that should have a timeout installed are tagged
32 -- accordingly in the states table. When changing the state of
33 -- a PR, if the new state expects a timeout the PR should be
34 -- given a non-null timeout; otherwise, the timeout field
35 -- should be nulled.
36 timeout_date timestamp null,
37 timeout_state text null references states (name),
26 38
27 -- fixed-size history 39 -- fixed-size history
28 arrival_schemaversion int not null, 40 arrival_schemaversion int not null,
29 arrival_date timestamp not null, 41 arrival_date timestamp not null,
30 modified_date timestamp not null, 42 modified_date timestamp not null,