# MySQL dump 4.0
#
# Host: localhost    Database: keystone
#--------------------------------------------------------

#
# Table structure for table 'slips'
#
CREATE TABLE slips (
  sid int(11) DEFAULT '0' NOT NULL auto_increment,
  spid int(11) DEFAULT '0' NOT NULL,
  depend int(11),
  o_date int(11),
  o_tech varchar(50),
  c_date int(11),
  c_tech varchar(10),
  currtech varchar(10),
  state char(1),
  status char(1),
  priority int(11),
	severity char(1),
  ctag varchar(20),
  problem varchar(80),
  summary blob,
  so_date int(11),
  sc_date int(11),
  grp varchar(10),
  is_public char(1),
  l_activity int(11),
  l_tech varchar(50),
  num_children int(2),
  num_follows int(2),
  timespent int(5),
  spolicy int(2),
  caddlabel varchar(10),
  cphonelabel varchar(10),
  resource varchar(10),
  KEY sid (sid),
  KEY spid (spid),
  PRIMARY KEY (sid)
);

