-- $Id: wfwl_hostnames_create 515 2012-12-16 22:09:38Z bhockney $
--
-- add hostnames table for webfwlog
--
CREATE TABLE $WFWL_SCHEMA.hostnames (
    refresh integer DEFAULT 1,
    ip_addr inet NOT NULL,
    hostname character varying(255)
);
CREATE UNIQUE INDEX wfwl_hostname ON $WFWL_SCHEMA.hostnames (ip_addr);
