ABillS

CREATE TABLE `equipment_models` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`type_id` tinyint(6) unsigned NOT NULL DEFAULT '0',
`vendor_id` smallint(6) unsigned NOT NULL DEFAULT '0',
`model_name` varchar(50) NOT NULL DEFAULT '',
`site` varchar(150) NOT NULL DEFAULT '',
`ports` tinyint(6) unsigned NOT NULL DEFAULT '0',
`manage_web` varchar(50) NOT NULL DEFAULT '',
`manage_ssh` varchar(50) NOT NULL DEFAULT '',
`snmp_tpl` varchar(50) NOT NULL DEFAULT '',
`comments` text NOT NULL,
`rows_count` int(11) unsigned NOT NULL DEFAULT '1',
`block_size` int(11) unsigned DEFAULT '0',
`port_numbering` tinyint(1) unsigned DEFAULT '0' COMMENT 'FALSE is ROWS, TRUE is COLUMNS',
`first_position` tinyint(1) unsigned DEFAULT '0' COMMENT 'FALSE is UP, TRUE is DOWN',
`extra_port1` smallint(6) unsigned DEFAULT '0',
`extra_port2` smallint(6) unsigned DEFAULT '0',
`extra_port3` smallint(6) unsigned DEFAULT '0',
`extra_port4` smallint(6) unsigned DEFAULT '0',
`ports_type` smallint(5) unsigned DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8 COMMENT='Equipment models';