diff 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
line wrap: on
line diff
--- a/database/schema/config.sql	Sun Feb 19 20:21:51 2012 -0500
+++ b/database/schema/config.sql	Thu Mar 15 04:21:20 2012 -0400
@@ -7,35 +7,38 @@
 -- 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;
+---- These are now handled in classify.sql
+-- 
+-- -- 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;
 
--- 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;
 
 -- States of bugs
 --