--
-- These tables record the allowable values for the various
-- enumerated settings.
--
-- Each entry has the value string (the name), a description field,
-- and a flag to mark the entry obsolete. Obsolete values are still
-- allowed to exist in the database, but new uses are not permitted.
--

-- Severity ratings of bugs
CREATE TABLE severities (
	name text		primary key,
	obsolete boolean	not null,
	description text
)
WITHOUT OIDS;

-- Priority ratings of bugs
CREATE TABLE priorities (
	name text		primary key,
	obsolete boolean	not null,
	description text
)
WITHOUT OIDS;

-- Types of bugs (sw-bug, doc-bug, etc.)
create table classes (
	name text		primary key,
	obsolete boolean	not null,
	description text
) without oids;

-- Categories of bugs (bin, kern, pkg, etc.)
create table categories (
	name text		primary key,
	obsolete boolean	not null,
	description text	
) without oids;