-- PostgreSQL
--
-- RCS Revision
--   $Id: filters.pgsql,v 1.3 1999/01/12 03:23:17 roberts Exp $
--
-- Host: localhost    Database: keystone
----------------------------------------------------------

--
-- Table structure for table 'filters'
--
CREATE SEQUENCE filters_seq START 1;

CREATE TABLE filters (
  _rowid int NOT NULL DEFAULT nextval('filters_seq') PRIMARY KEY,
  uid varchar(20) NOT NULL,
  fdesc varchar(40),
  ftable varchar(10) NOT NULL,
  fpublic int,
  fselect varchar(200)
);

CREATE INDEX filters_uid_idx ON filters (uid);

CREATE INDEX filters_ftable_idx ON filters (ftable);
