-- $Id: wfwl_reports_create,v 1.1 2005/04/19 21:58:25 bhockney Exp $
--
-- add reports table for webfwlog
--
CREATE TABLE $WFWL_SCHEMA.reports (
    last_saved bigint DEFAULT 0 NOT NULL,
    last_accessed bigint DEFAULT 0 NOT NULL,
    code character varying(32) DEFAULT '' NOT NULL,
    description character varying(255),
    definition text
);
CREATE UNIQUE INDEX webfwlog_code ON $WFWL_SCHEMA.reports (code);