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

comparison database/schema/config.sql @ 39:45bb7b516edb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
document previous better
author David A. Holland
date Sun, 15 Jun 2014 17:28:02 -0400
parents 68a4f2d8930e
children 40f64a96481f
comparison
equal deleted inserted replaced
38:68a4f2d8930e 39:45bb7b516edb
44 -- 44 --
45 -- The additional booleans govern the semantics of the defined states. 45 -- The additional booleans govern the semantics of the defined states.
46 -- closed resolved (one way or another) 46 -- closed resolved (one way or another)
47 -- nagresponsible the "responsible" users should get nag-mail 47 -- nagresponsible the "responsible" users should get nag-mail
48 -- nagsubmitter the "submitter" users should get nag-mail 48 -- nagsubmitter the "submitter" users should get nag-mail
49 -- timeout bugs in this state should time out to another state
49 -- 50 --
50 -- It is reasonable for multiple states to have the same settings; 51 -- It is reasonable for multiple states to have the same settings;
51 -- such states presumably mean different things in ways the database 52 -- such states presumably mean different things in ways the database
52 -- doesn't need to know about. 53 -- doesn't need to know about.
53 -- 54 --
54 -- For example: "open" might be defined as 55 -- For example: "open" might be defined as
55 -- ("open", false, "bug is unresolved", false, true, false) 56 -- ("open", false, "bug is unresolved",
57 -- false, true, false, false)
56 -- and "feedback" as 58 -- and "feedback" as
57 -- ("feedback", false, "awaiting submitter feedback", false, false, true) 59 -- ("feedback", false, "awaiting submitter feedback",
60 -- false, false, true, true)
58 -- 61 --
59 CREATE TABLE states ( 62 CREATE TABLE states (
60 name text primary key, 63 name text primary key,
61 obsolete boolean not null, 64 obsolete boolean not null,
62 description text , 65 description text ,