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

annotate database/schema/config.sql @ 29:cd36b49f4437

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix. now loads into postgresql92
author David A. Holland
date Sun, 26 May 2013 23:24:45 -0400
parents d42c0db81e28
children 68a4f2d8930e
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
1 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
2 -- These tables record the allowable values for the various
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
3 -- enumerated settings.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
4 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
5 -- Each entry has the value string (the name), a description field,
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
6 -- and a flag to mark the entry obsolete. Obsolete values are still
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
7 -- allowed to exist in the database, but new uses are not permitted.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
8 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
9
11
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
10 ---- These are now handled in classify.sql
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
11 --
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
12 -- -- Severity ratings of bugs
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
13 -- CREATE TABLE severities (
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
14 -- name text primary key,
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
15 -- obsolete boolean not null,
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
16 -- description text
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
17 -- )
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
18 -- WITHOUT OIDS;
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
19 --
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
20 -- -- Priority ratings of bugs
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
21 -- CREATE TABLE priorities (
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
22 -- name text primary key,
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
23 -- obsolete boolean not null,
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
24 -- description text
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
25 -- )
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
26 -- WITHOUT OIDS;
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
27 --
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
28 -- -- Types of bugs (sw-bug, doc-bug, etc.)
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
29 -- CREATE TABLE classes (
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
30 -- name text primary key,
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
31 -- obsolete boolean not null,
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
32 -- description text
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
33 -- ) WITHOUT OIDS;
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
34 --
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
35 -- -- Categories of bugs (bin, kern, pkg, etc.)
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
36 -- CREATE TABLE categories (
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
37 -- name text primary key,
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
38 -- obsolete boolean not null,
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
39 -- description text
d42c0db81e28 Update the classification stuff.
David A. Holland
parents: 10
diff changeset
40 -- ) WITHOUT OIDS;
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
41
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
42
10
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
43 -- States of bugs
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
44 --
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
45 -- The additional booleans govern the semantics of the defined states.
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
46 -- closed resolved (one way or another)
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
47 -- nagresponsible the "responsible" users should get nag-mail
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
48 -- nagsubmitter the "submitter" users should get nag-mail
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
49 --
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
50 -- It is reasonable for multiple states to have the same settings;
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
51 -- such states presumably mean different things in ways the database
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
52 -- doesn't need to know about.
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
53 --
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
54 -- For example: "open" might be defined as
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
55 -- ("open", false, "bug is unresolved", false, true, false)
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
56 -- and "feedback" as
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
57 -- ("feedback", false, "awaiting submitter feedback", false, false, true)
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
58 --
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
59 CREATE TABLE states (
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
60 name text primary key,
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
61 obsolete boolean not null,
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
62 description text ,
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
63 closed boolean not null,
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
64 nagresponsible boolean not null,
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
65 nagsubmitter boolean not null
1720f45dd495 Replace insane handling of states with something more likely workable.
David A. Holland
parents: 8
diff changeset
66 ) WITHOUT OIDS;