-- Oracle structures and data for 'severity'
-- (c)2000 Stonekeep Consulting
-- $Id: severity.oracle,v 1.1 2000/06/22 00:20:08 shevett Exp $

CREATE TABLE severity (
  flag char(1) NOT NULL,
  label varchar2(15) NOT NULL,
);

CREATE INDEX severity_flag_idx ON severity (flag) ;
CREATE INDEX severity_label_idx ON severity (label) ;

INSERT INTO severity VALUES ('X','Showstopper!');
INSERT INTO severity VALUES ('C','Critical');
INSERT INTO severity VALUES ('A','Major');
INSERT INTO severity VALUES ('E','Medium');
INSERT INTO severity VALUES ('L','Low');
INSERT INTO severity VALUES ('T','Trivial');
INSERT INTO severity VALUES ('N','Enhancement');

