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