Just an FYI, on the latest version I had to create the column "free" in the hosts table to allow modifying a host to show that it was in use. Here is an update to the sql query that comes with the install:
DROP TABLE IF EXISTS `hosts`;
CREATE TABLE `hosts` (
`id` int(11) NOT NULL auto_increment,
`subnet_id` int(11) NOT NULL,
`customer_id` int(11) default NULL,
`addr` int(10) unsigned NOT NULL,
`free` tinyint(1) NOTNULL,
`description` text,
`notes` text,
PRIMARY KEY (`id`),
KEY `subnet_id` (`subnet_id`),
KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Just an FYI, on the latest version I had to create the column "free" in the hosts table to allow modifying a host to show that it was in use. Here is an update to the sql query that comes with the install:
sorry - there should be a space between NOT and NULL - it should read:
`free` tinyint(1) NOT NULL,