--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/database/schema/config.sql	Sun Feb 19 19:54:48 2012 -0500
@@ -0,0 +1,39 @@
+--
+-- 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;
+