-- $Id: wfwl_reports_create 503 2012-12-09 01:48:29Z bhockney $
--
-- 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);
