-- $Id: wfwl_services_create,v 1.1 2005/04/19 21:58:25 bhockney Exp $
--
-- Create new table `$WFWL_DB.services`
--
CREATE TABLE $WFWL_DB.services (
  id int(10) UNSIGNED NOT NULL auto_increment,
  refresh tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  ip_protocol tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  port smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  service varchar(20) DEFAULT NULL,
  PRIMARY KEY (port,ip_protocol),
  UNIQUE KEY id (id)
);