Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/config.sql @ 8:68cc276ac118
SQL material from old tree, split up for accessibility.
| author | David A. Holland |
|---|---|
| date | Sun, 19 Feb 2012 19:54:48 -0500 |
| parents | |
| children | 1720f45dd495 |
comparison
equal
deleted
inserted
replaced
| 7:c013fb703183 | 8:68cc276ac118 |
|---|---|
| 1 -- | |
| 2 -- These tables record the allowable values for the various | |
| 3 -- enumerated settings. | |
| 4 -- | |
| 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 | |
| 7 -- allowed to exist in the database, but new uses are not permitted. | |
| 8 -- | |
| 9 | |
| 10 -- Severity ratings of bugs | |
| 11 CREATE TABLE severities ( | |
| 12 name text primary key, | |
| 13 obsolete boolean not null, | |
| 14 description text | |
| 15 ) | |
| 16 WITHOUT OIDS; | |
| 17 | |
| 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 |