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

comparison database/schema/config.sql @ 10:1720f45dd495

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Replace insane handling of states with something more likely workable.
author David A. Holland
date Sun, 19 Feb 2012 20:21:51 -0500
parents 68cc276ac118
children d42c0db81e28
comparison
equal deleted inserted replaced
9:efb427d8b704 10:1720f45dd495
22 description text 22 description text
23 ) 23 )
24 WITHOUT OIDS; 24 WITHOUT OIDS;
25 25
26 -- Types of bugs (sw-bug, doc-bug, etc.) 26 -- Types of bugs (sw-bug, doc-bug, etc.)
27 create table classes ( 27 CREATE TABLE classes (
28 name text primary key, 28 name text primary key,
29 obsolete boolean not null, 29 obsolete boolean not null,
30 description text 30 description text
31 ) without oids; 31 ) WITHOUT OIDS;
32 32
33 -- Categories of bugs (bin, kern, pkg, etc.) 33 -- Categories of bugs (bin, kern, pkg, etc.)
34 create table categories ( 34 CREATE TABLE categories (
35 name text primary key, 35 name text primary key,
36 obsolete boolean not null, 36 obsolete boolean not null,
37 description text 37 description text
38 ) without oids; 38 ) WITHOUT OIDS;
39 39
40 -- States of bugs
41 --
42 -- The additional booleans govern the semantics of the defined states.
43 -- closed resolved (one way or another)
44 -- nagresponsible the "responsible" users should get nag-mail
45 -- nagsubmitter the "submitter" users should get nag-mail
46 --
47 -- It is reasonable for multiple states to have the same settings;
48 -- such states presumably mean different things in ways the database
49 -- doesn't need to know about.
50 --
51 -- For example: "open" might be defined as
52 -- ("open", false, "bug is unresolved", false, true, false)
53 -- and "feedback" as
54 -- ("feedback", false, "awaiting submitter feedback", false, false, true)
55 --
56 CREATE TABLE states (
57 name text primary key,
58 obsolete boolean not null,
59 description text ,
60 closed boolean not null,
61 nagresponsible boolean not null,
62 nagsubmitter boolean not null
63 ) WITHOUT OIDS;