-- PostgreSQL
--
-- RCS Revision
--   $Id: state.pgsql,v 1.8 1999/12/06 19:43:05 roberts Exp $
--
-- Host: localhost    Database: keystone
----------------------------------------------------------

--
-- Table structure for table 'state'
--
CREATE SEQUENCE state_seq START 1;

CREATE TABLE state (
  _rowid int NOT NULL DEFAULT nextval('state_seq') PRIMARY KEY,
  uid varchar(20) NOT NULL,
  mslip int,
  mcont int,
  mresource int,
  mdataset varchar(10),
  mother int,
  mlibrary int,
  libzoom varchar(40),
  slipzoom int,
  reszoom varchar(10),
  filters int,
  filtlist varchar(200),
  properties varchar(200),
  contzoom varchar(10),
  cbgn int,
  sbgn int,
  resrzoom varchar(10),
  resset varchar(10),
  rabgn int,
  rrbgn int
);

CREATE INDEX state_uid_idx ON state(uid);
