-- WeatherStation.ws_nodes definition

CREATE TABLE `ws_nodes` (
  `node_index` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `node_name` varchar(100) NOT NULL,
  `node_fdn` varchar(100) NOT NULL,
  `node_ip_address` varchar(100) NOT NULL,
  `node_fdn_2` varchar(100) DEFAULT NULL,
  `node_ip_address_2` varchar(100) DEFAULT NULL,
  `Description` varchar(100) DEFAULT NULL,
  `has_fans` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`node_index`),
  UNIQUE KEY `node_name` (`node_name`),
  UNIQUE KEY `nod_fdn` (`node_fdn`),
  UNIQUE KEY `node_ip_address` (`node_ip_address`),
  UNIQUE KEY `node_fdn_2` (`node_fdn_2`),
  UNIQUE KEY `node_ip_address_2` (`node_ip_address_2`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
