Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/config.sql @ 11:d42c0db81e28
Update the classification stuff.
There are still some rough edges but it should be mostly workable now.
author | David A. Holland |
---|---|
date | Thu, 15 Mar 2012 04:21:20 -0400 |
parents | 1720f45dd495 |
children | 68a4f2d8930e |
comparison
equal
deleted
inserted
replaced
10:1720f45dd495 | 11:d42c0db81e28 |
---|---|
5 -- Each entry has the value string (the name), a description field, | 5 -- Each entry has the value string (the name), a description field, |
6 -- and a flag to mark the entry obsolete. Obsolete values are still | 6 -- and a flag to mark the entry obsolete. Obsolete values are still |
7 -- allowed to exist in the database, but new uses are not permitted. | 7 -- allowed to exist in the database, but new uses are not permitted. |
8 -- | 8 -- |
9 | 9 |
10 -- Severity ratings of bugs | 10 ---- These are now handled in classify.sql |
11 CREATE TABLE severities ( | 11 -- |
12 name text primary key, | 12 -- -- Severity ratings of bugs |
13 obsolete boolean not null, | 13 -- CREATE TABLE severities ( |
14 description text | 14 -- name text primary key, |
15 ) | 15 -- obsolete boolean not null, |
16 WITHOUT OIDS; | 16 -- description text |
17 -- ) | |
18 -- WITHOUT OIDS; | |
19 -- | |
20 -- -- Priority ratings of bugs | |
21 -- CREATE TABLE priorities ( | |
22 -- name text primary key, | |
23 -- obsolete boolean not null, | |
24 -- description text | |
25 -- ) | |
26 -- WITHOUT OIDS; | |
27 -- | |
28 -- -- Types of bugs (sw-bug, doc-bug, etc.) | |
29 -- CREATE TABLE classes ( | |
30 -- name text primary key, | |
31 -- obsolete boolean not null, | |
32 -- description text | |
33 -- ) WITHOUT OIDS; | |
34 -- | |
35 -- -- Categories of bugs (bin, kern, pkg, etc.) | |
36 -- CREATE TABLE categories ( | |
37 -- name text primary key, | |
38 -- obsolete boolean not null, | |
39 -- description text | |
40 -- ) WITHOUT OIDS; | |
17 | 41 |
18 -- Priority ratings of bugs | |
19 CREATE TABLE priorities ( | |
20 name text primary key, | |
21 obsolete boolean not null, | |
22 description text | |
23 ) | |
24 WITHOUT OIDS; | |
25 | |
26 -- Types of bugs (sw-bug, doc-bug, etc.) | |
27 CREATE TABLE classes ( | |
28 name text primary key, | |
29 obsolete boolean not null, | |
30 description text | |
31 ) WITHOUT OIDS; | |
32 | |
33 -- Categories of bugs (bin, kern, pkg, etc.) | |
34 CREATE TABLE categories ( | |
35 name text primary key, | |
36 obsolete boolean not null, | |
37 description text | |
38 ) WITHOUT OIDS; | |
39 | 42 |
40 -- States of bugs | 43 -- States of bugs |
41 -- | 44 -- |
42 -- The additional booleans govern the semantics of the defined states. | 45 -- The additional booleans govern the semantics of the defined states. |
43 -- closed resolved (one way or another) | 46 -- closed resolved (one way or another) |