-- $Id: wfwl_hostnames_create,v 1.1 2005/04/19 21:58:25 bhockney Exp $
--
-- add hostnames table for webfwlog
--
CREATE TABLE $WFWL_SCHEMA.hostnames (
    refresh integer DEFAULT 1,
    ip_addr bigint DEFAULT 0 NOT NULL,
    hostname character varying(255)
);
CREATE UNIQUE INDEX wfwl_hostname ON $WFWL_SCHEMA.hostnames (ip_addr);