-- Oracle Table Definition
--
--   $Id: classes.oracle,v 1.1 2000/06/22 00:20:06 shevett Exp $
--

CREATE TABLE classes (
  cl_tag varchar2(2) NOT NULL,
  cl_label varchar2(15) NOT NULL
);

CREATE INDEX classes_tag_idx ON classes (cl_tag) ;

INSERT INTO classes VALUES ('  ','Uncategorized');
INSERT INTO classes VALUES ('CP','CPU');
INSERT INTO classes VALUES ('MO','Monitor');
INSERT INTO classes VALUES ('KB','Keyboard');
INSERT INTO classes VALUES ('PR','Printer');
INSERT INTO classes VALUES ('SP','Speakers');
