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

comparison database/schema/config.sql @ 11:d42c0db81e28

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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)