-- PostgreSQL
--
-- RCS Revision
--   $Id: slips.pgsql,v 1.17 2000/06/09 04:20:48 billf Exp $
--
-- Host: localhost    Database: keystone
----------------------------------------------------------

--
-- Table structure for table 'slips'
--
CREATE SEQUENCE slips_seq START 1;

CREATE TABLE slips (
  sid int NOT NULL DEFAULT nextval('slips_seq') PRIMARY KEY,
  spid int NOT NULL DEFAULT 0,
  depend int,
  o_date int,
  o_tech varchar(50),
  c_date int,
  c_tech varchar(10),
  currtech varchar(10),
  status char(1),
  priority int,
	severity char(1),
  ctag varchar(20),
  problem varchar(80),
  summary text,
  so_date int,
  sc_date int,
  grp varchar(10),
  is_public char(1),
  l_activity int,
  l_tech varchar(50),
  num_children int,
  num_follows int,
  timespent int,
  spolicy int,
  caddlabel varchar(10),
  cphonelabel varchar(10),
  resource varchar(10)
);

CREATE INDEX spid_idx ON slips (spid);
