function mactrack_database_upgrade () {
mactrack_add_column("mac_track_interfaces", "ifHighSpeed", "ALTER TABLE `mac_track_interfaces` ADD COLUMN `ifHighSpeed` int(10) unsigned NOT NULL default '0' AFTER `ifSpeed`");
mactrack_add_column("mac_track_interfaces", "ifDuplex", "ALTER TABLE `mac_track_interfaces` ADD COLUMN `ifDuplex` int(10) unsigned NOT NULL default '0' AFTER `ifHighSpeed`");
mactrack_add_column("mac_track_interfaces", "int_ifInDiscards", "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifInDiscards` int(10) unsigned NOT NULL default '0' AFTER `ifOutErrors`");
mactrack_add_column("mac_track_interfaces", "int_ifInErrors", "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifInErrors` int(10) unsigned NOT NULL default '0' AFTER `int_ifInDiscards`");
mactrack_add_column("mac_track_interfaces", "int_ifInUnknownProtos", "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifInUnknownProtos` int(10) unsigned NOT NULL default '0' AFTER `int_ifInErrors`");
mactrack_add_column("mac_track_interfaces", "int_ifOutDiscards", "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifOutDiscards` int(10) unsigned NOT NULL default '0' AFTER `int_ifInUnknownProtos`");
mactrack_add_column("mac_track_interfaces", "int_ifOutErrors", "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifOutErrors` int(10) unsigned NOT NULL default '0' AFTER `int_ifOutDiscards`");
mactrack_add_column("mac_track_devices", "host_id", "ALTER TABLE `mac_track_devices` ADD COLUMN `host_id` int(10) unsigned NOT NULL default '0' AFTER `device_id`");
mactrack_add_column("mac_track_macwatch", "date_last_notif", "ALTER TABLE `mac_track_macwatch` ADD COLUMN `date_last_notif` TIMESTAMP DEFAULT '0000-00-00 00:00:00' AFTER `date_last_seen`");
mactrack_execute_sql("Add length to Device Types Match Fields", "ALTER TABLE `mac_track_device_types` MODIFY COLUMN `sysDescr_match` VARCHAR(100) NOT NULL default '', MODIFY COLUMN `sysObjectID_match` VARCHAR(100) NOT NULL default ''");
mactrack_execute_sql("Correct a Scanning Function Bug", "DELETE FROM mac_track_scanning_functions WHERE scanning_function='Not Applicable - Hub/Switch'");
mactrack_add_column("mac_track_devices", "host_id", "ALTER TABLE `mac_track_devices` ADD COLUMN `host_id` INTEGER UNSIGNED NOT NULL default '0' AFTER `device_id`");
mactrack_add_index("mac_track_devices", "host_id", "ALTER TABLE `mac_track_devices` ADD INDEX `host_id`(`host_id`)");
mactrack_add_index("mac_track_ports", "scan_date", "ALTER TABLE `mac_track_ports` ADD INDEX `scan_date` USING BTREE(`scan_date`)");
if (!mactrack_db_column_exists("mac_track_interfaces", "sysUptime")) {
db_execute("ALTER TABLE mac_track_interfaces
ADD COLUMN `sysUptime` int(10) unsigned NOT NULL default '0' AFTER `device_id`,
ADD COLUMN `ifInOctets` int(10) unsigned NOT NULL default '0' AFTER `vlan_trunk_status`,
ADD COLUMN `ifOutOctets` int(10) unsigned NOT NULL default '0' AFTER `ifInOctets`,
ADD COLUMN `ifHCInOctets` bigint(20) unsigned NOT NULL default '0' AFTER `ifOutOctets`,
ADD COLUMN `ifHCOutOctets` bigint(20) unsigned NOT NULL default '0' AFTER `ifHCInOctets`,
ADD COLUMN `ifInNUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `ifHCOutOctets`,
ADD COLUMN `ifOutNUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `ifInNUcastPkts`,
ADD COLUMN `ifInUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `ifOutNUcastPkts`,
ADD COLUMN `ifOutUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `ifInUcastPkts`,
ADD COLUMN `inBound` double NOT NULL default '0' AFTER `ifOutErrors`,
ADD COLUMN `outBound` double NOT NULL default '0' AFTER `inBound`,
ADD COLUMN `int_ifInOctets` int(10) unsigned NOT NULL default '0' AFTER `outBound`,
ADD COLUMN `int_ifOutOctets` int(10) unsigned NOT NULL default '0' AFTER `int_ifInOctets`,
ADD COLUMN `int_ifHCInOctets` bigint(20) unsigned NOT NULL default '0' AFTER `int_ifOutOctets`,
ADD COLUMN `int_ifHCOutOctets` bigint(20) unsigned NOT NULL default '0' AFTER `int_ifHCInOctets`,
ADD COLUMN `int_ifInNUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `int_ifHCOutOctets`,
ADD COLUMN `int_ifOutNUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `int_ifInNUcastPkts`,
ADD COLUMN `int_ifInUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `int_ifOutNUcastPkts`,
ADD COLUMN `int_ifOutUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `int_ifInUcastPkts`");
}
if (!mactrack_db_key_exists("mac_track_ports", "site_id_device_id")) {
db_execute("ALTER TABLE `mac_track_ports` ADD INDEX `site_id_device_id`(`site_id`, `device_id`);");
}
# new for 2.1.2
# SNMP V3
mactrack_add_column("mac_track_devices", "snmp_options", "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_options` int(10) unsigned NOT NULL default '0' AFTER `user_password`");
mactrack_add_column("mac_track_devices", "snmp_username", "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_username` varchar(50) default NULL AFTER `snmp_status`");
mactrack_add_column("mac_track_devices", "snmp_password", "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_password` varchar(50) default NULL AFTER `snmp_username`");
mactrack_add_column("mac_track_devices", "snmp_auth_protocol", "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_auth_protocol` char(5) default '' AFTER `snmp_password`");
mactrack_add_column("mac_track_devices", "snmp_priv_passphrase", "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_priv_passphrase` varchar(200) default '' AFTER `snmp_auth_protocol`");
mactrack_add_column("mac_track_devices", "snmp_priv_protocol", "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_priv_protocol` char(6) default '' AFTER `snmp_priv_passphrase`");
mactrack_add_column("mac_track_devices", "snmp_context", "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_context` varchar(64) default '' AFTER `snmp_priv_protocol`");
mactrack_add_column("mac_track_devices", "max_oids", "ALTER TABLE `mac_track_devices` ADD COLUMN `max_oids` int(12) unsigned default '10' AFTER `snmp_context`");
if (!mactrack_db_table_exists("mac_track_snmp")) {
mactrack_create_table("mac_track_snmp", "CREATE TABLE `mac_track_snmp` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`))
ENGINE=MyISAM COMMENT='Group of SNMP Option Sets';");
}
if (!mactrack_db_table_exists("mac_track_snmp_items")) {
mactrack_create_table("mac_track_snmp_items", "CREATE TABLE `mac_track_snmp_items` (
`id` int(10) unsigned NOT NULL auto_increment,
`snmp_id` int(10) unsigned NOT NULL default '0',
`sequence` int(10) unsigned NOT NULL default '0',
`snmp_version` varchar(100) NOT NULL default '',
`snmp_readstring` varchar(100) NOT NULL,
`snmp_port` int(10) NOT NULL default '161',
`snmp_timeout` int(10) unsigned NOT NULL default '500',
`snmp_retries` tinyint(11) unsigned NOT NULL default '3',
`max_oids` int(12) unsigned default '10',
`snmp_username` varchar(50) default NULL,
`snmp_password` varchar(50) default NULL,
`snmp_auth_protocol` char(5) default '',
`snmp_priv_passphrase` varchar(200) default '',
`snmp_priv_protocol` char(6) default '',
`snmp_context` varchar(64) default '',
PRIMARY KEY (`id`,`snmp_id`))
ENGINE=MyISAM COMMENT='Set of SNMP Options';");
}
if (!sizeof(db_fetch_row("SHOW TABLES LIKE 'mac_track_interface_graphs'"))) {
db_execute("CREATE TABLE `mac_track_interface_graphs` (
`device_id` int(10) unsigned NOT NULL default '0',
`ifIndex` int(10) unsigned NOT NULL,
`ifName` varchar(20) NOT NULL default '',
`host_id` int(11) NOT NULL default '0',
`local_graph_id` int(10) unsigned NOT NULL,
`snmp_query_id` int(11) NOT NULL default '0',
`graph_template_id` int(11) NOT NULL default '0',
`field_name` varchar(20) NOT NULL default '',
`field_value` varchar(25) NOT NULL default '',
`present` tinyint(4) default '1',
PRIMARY KEY (`local_graph_id`,`device_id`,`ifIndex`, `host_id`),
KEY `host_id` (`host_id`),
KEY `device_id` (`device_id`)
) ENGINE=MyISAM;"
);
}
mactrack_add_column("mac_track_devices",
"term_type",
"ALTER TABLE `mac_track_devices` ADD COLUMN `term_type` tinyint(11) NOT NULL default '1' AFTER `scan_type`");
mactrack_add_column("mac_track_devices",
"private_key_path",
"ALTER TABLE `mac_track_devices` ADD COLUMN `private_key_path` varchar(128) default '' AFTER `user_password`");
mactrack_add_column("mac_track_interfaces",
"ifMauAutoNegAdminStatus",
"ALTER TABLE `mac_track_interfaces` ADD COLUMN `ifMauAutoNegAdminStatus` integer UNSIGNED NOT NULL default '0' AFTER `ifDuplex`");
mactrack_add_column("mac_track_interfaces",
"ifMauAutoNegRemoteSignaling",
"ALTER TABLE `mac_track_interfaces` ADD COLUMN `ifMauAutoNegRemoteSignaling` integer UNSIGNED NOT NULL default '0' AFTER `ifMauAutoNegAdminStatus`");
}
function mactrack_database_upgrade()
{
mactrack_add_column('mac_track_interfaces', 'ifHighSpeed', "ALTER TABLE `mac_track_interfaces` ADD COLUMN `ifHighSpeed` int(10) unsigned NOT NULL default '0' AFTER `ifSpeed`");
mactrack_add_column('mac_track_interfaces', 'ifDuplex', "ALTER TABLE `mac_track_interfaces` ADD COLUMN `ifDuplex` int(10) unsigned NOT NULL default '0' AFTER `ifHighSpeed`");
mactrack_add_column('mac_track_interfaces', 'int_ifInDiscards', "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifInDiscards` int(10) unsigned NOT NULL default '0' AFTER `ifOutErrors`");
mactrack_add_column('mac_track_interfaces', 'int_ifInErrors', "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifInErrors` int(10) unsigned NOT NULL default '0' AFTER `int_ifInDiscards`");
mactrack_add_column('mac_track_interfaces', 'int_ifInUnknownProtos', "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifInUnknownProtos` int(10) unsigned NOT NULL default '0' AFTER `int_ifInErrors`");
mactrack_add_column('mac_track_interfaces', 'int_ifOutDiscards', "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifOutDiscards` int(10) unsigned NOT NULL default '0' AFTER `int_ifInUnknownProtos`");
mactrack_add_column('mac_track_interfaces', 'int_ifOutErrors', "ALTER TABLE `mac_track_interfaces` ADD COLUMN `int_ifOutErrors` int(10) unsigned NOT NULL default '0' AFTER `int_ifOutDiscards`");
mactrack_add_column('mac_track_devices', 'host_id', "ALTER TABLE `mac_track_devices` ADD COLUMN `host_id` int(10) unsigned NOT NULL default '0' AFTER `device_id`");
mactrack_add_column('mac_track_macwatch', 'date_last_notif', "ALTER TABLE `mac_track_macwatch` ADD COLUMN `date_last_notif` TIMESTAMP DEFAULT '0000-00-00 00:00:00' AFTER `date_last_seen`");
mactrack_execute_sql('Add length to Device Types Match Fields', "ALTER TABLE `mac_track_device_types` MODIFY COLUMN `sysDescr_match` VARCHAR(100) NOT NULL default '', MODIFY COLUMN `sysObjectID_match` VARCHAR(100) NOT NULL default ''");
mactrack_execute_sql('Correct a Scanning Function Bug', "DELETE FROM mac_track_scanning_functions WHERE scanning_function='Not Applicable - Hub/Switch'");
mactrack_add_column('mac_track_devices', 'host_id', "ALTER TABLE `mac_track_devices` ADD COLUMN `host_id` INTEGER UNSIGNED NOT NULL default '0' AFTER `device_id`");
mactrack_add_index('mac_track_devices', 'host_id', 'ALTER TABLE `mac_track_devices` ADD INDEX `host_id`(`host_id`)');
mactrack_add_index('mac_track_ports', 'scan_date', 'ALTER TABLE `mac_track_ports` ADD INDEX `scan_date` USING BTREE(`scan_date`)');
if (!mactrack_db_column_exists('mac_track_interfaces', 'sysUptime')) {
db_execute("ALTER TABLE mac_track_interfaces\n\t\t\tADD COLUMN `sysUptime` int(10) unsigned NOT NULL default '0' AFTER `device_id`,\n\t\t\tADD COLUMN `ifInOctets` int(10) unsigned NOT NULL default '0' AFTER `vlan_trunk_status`,\n\t\t\tADD COLUMN `ifOutOctets` int(10) unsigned NOT NULL default '0' AFTER `ifInOctets`,\n\t\t\tADD COLUMN `ifHCInOctets` bigint(20) unsigned NOT NULL default '0' AFTER `ifOutOctets`,\n\t\t\tADD COLUMN `ifHCOutOctets` bigint(20) unsigned NOT NULL default '0' AFTER `ifHCInOctets`,\n\t\t\tADD COLUMN `ifInNUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `ifHCOutOctets`,\n\t\t\tADD COLUMN `ifOutNUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `ifInNUcastPkts`,\n\t\t\tADD COLUMN `ifInUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `ifOutNUcastPkts`,\n\t\t\tADD COLUMN `ifOutUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `ifInUcastPkts`,\n\t\t\tADD COLUMN `inBound` double NOT NULL default '0' AFTER `ifOutErrors`,\n\t\t\tADD COLUMN `outBound` double NOT NULL default '0' AFTER `inBound`,\n\t\t\tADD COLUMN `int_ifInOctets` int(10) unsigned NOT NULL default '0' AFTER `outBound`,\n\t\t\tADD COLUMN `int_ifOutOctets` int(10) unsigned NOT NULL default '0' AFTER `int_ifInOctets`,\n\t\t\tADD COLUMN `int_ifHCInOctets` bigint(20) unsigned NOT NULL default '0' AFTER `int_ifOutOctets`,\n\t\t\tADD COLUMN `int_ifHCOutOctets` bigint(20) unsigned NOT NULL default '0' AFTER `int_ifHCInOctets`,\n\t\t\tADD COLUMN `int_ifInNUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `int_ifHCOutOctets`,\n\t\t\tADD COLUMN `int_ifOutNUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `int_ifInNUcastPkts`,\n\t\t\tADD COLUMN `int_ifInUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `int_ifOutNUcastPkts`,\n\t\t\tADD COLUMN `int_ifOutUcastPkts` int(10) unsigned NOT NULL default '0' AFTER `int_ifInUcastPkts`");
}
if (!mactrack_db_key_exists('mac_track_ports', 'site_id_device_id')) {
db_execute('ALTER TABLE `mac_track_ports` ADD INDEX `site_id_device_id`(`site_id`, `device_id`);');
}
# new for 2.1.2
# SNMP V3
mactrack_add_column('mac_track_devices', 'term_type', "ALTER TABLE `mac_track_devices` ADD COLUMN `term_type` tinyint(11) NOT NULL default '1' AFTER `scan_type`");
mactrack_add_column('mac_track_devices', 'user_name', "ALTER TABLE `mac_track_devices` ADD COLUMN `user_name` varchar(40) default NULL AFTER `term_type`");
mactrack_add_column('mac_track_devices', 'user_password', "ALTER TABLE `mac_track_devices` ADD COLUMN `user_password` varchar(40) default NULL AFTER `user_name`");
mactrack_add_column('mac_track_devices', 'private_key_path', "ALTER TABLE `mac_track_devices` ADD COLUMN `private_key_path` varchar(128) default '' AFTER `user_password`");
mactrack_add_column('mac_track_devices', 'snmp_options', "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_options` int(10) unsigned NOT NULL default '0' AFTER `private_key_path`");
mactrack_add_column('mac_track_devices', 'snmp_username', "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_username` varchar(50) default NULL AFTER `snmp_status`");
mactrack_add_column('mac_track_devices', 'snmp_password', "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_password` varchar(50) default NULL AFTER `snmp_username`");
mactrack_add_column('mac_track_devices', 'snmp_auth_protocol', "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_auth_protocol` char(5) default '' AFTER `snmp_password`");
mactrack_add_column('mac_track_devices', 'snmp_priv_passphrase', "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_priv_passphrase` varchar(200) default '' AFTER `snmp_auth_protocol`");
mactrack_add_column('mac_track_devices', 'snmp_priv_protocol', "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_priv_protocol` char(6) default '' AFTER `snmp_priv_passphrase`");
mactrack_add_column('mac_track_devices', 'snmp_context', "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_context` varchar(64) default '' AFTER `snmp_priv_protocol`");
mactrack_add_column('mac_track_devices', 'max_oids', "ALTER TABLE `mac_track_devices` ADD COLUMN `max_oids` int(12) unsigned default '10' AFTER `snmp_context`");
mactrack_add_column('mac_track_devices', 'snmp_engine_id', "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_engine_id` varchar(30) default '' AFTER `snmp_context`");
mactrack_add_column('mac_track_snmp_items', 'snmp_engine_id', "ALTER TABLE `mac_track_snmp_items` ADD COLUMN `snmp_engine_id` varchar(30) default '' AFTER `snmp_context`");
if (!mactrack_db_table_exists('mac_track_snmp')) {
mactrack_create_table('mac_track_snmp', "CREATE TABLE `mac_track_snmp` (\n\t\t\t`id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t`name` varchar(100) NOT NULL default '',\n\t\t\tPRIMARY KEY (`id`))\n\t\t\tENGINE=InnoDB COMMENT='Group of SNMP Option Sets';");
}
if (!mactrack_db_table_exists('mac_track_snmp_items')) {
mactrack_create_table('mac_track_snmp_items', "CREATE TABLE `mac_track_snmp_items` (\n\t\t\t`id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t`snmp_id` int(10) unsigned NOT NULL default '0',\n\t\t\t`sequence` int(10) unsigned NOT NULL default '0',\n\t\t\t`snmp_version` varchar(100) NOT NULL default '',\n\t\t\t`snmp_readstring` varchar(100) NOT NULL,\n\t\t\t`snmp_port` int(10) NOT NULL default '161',\n\t\t\t`snmp_timeout` int(10) unsigned NOT NULL default '500',\n\t\t\t`snmp_retries` tinyint(11) unsigned NOT NULL default '3',\n\t\t\t`max_oids` int(12) unsigned default '10',\n\t\t\t`snmp_username` varchar(50) default NULL,\n\t\t\t`snmp_password` varchar(50) default NULL,\n\t\t\t`snmp_auth_protocol` char(5) default '',\n\t\t\t`snmp_priv_passphrase` varchar(200) default '',\n\t\t\t`snmp_priv_protocol` char(6) default '',\n\t\t\t`snmp_context` varchar(64) default '',\n\t\t\t`snmp_engine_id` varchar(30) default '',\n\t\t\tPRIMARY KEY (`id`,`snmp_id`))\n\t\t\tENGINE=InnoDB COMMENT='Set of SNMP Options';");
}
if (!sizeof(db_fetch_row("SHOW TABLES LIKE 'mac_track_interface_graphs'"))) {
db_execute("CREATE TABLE `mac_track_interface_graphs` (\n\t\t\t`device_id` int(10) unsigned NOT NULL default '0',\n\t\t\t`ifIndex` int(10) unsigned NOT NULL,\n\t\t\t`ifName` varchar(20) NOT NULL default '',\n\t\t\t`host_id` int(11) NOT NULL default '0',\n\t\t\t`local_graph_id` int(10) unsigned NOT NULL,\n\t\t\t`snmp_query_id` int(11) NOT NULL default '0',\n\t\t\t`graph_template_id` int(11) NOT NULL default '0',\n\t\t\t`field_name` varchar(20) NOT NULL default '',\n\t\t\t`field_value` varchar(25) NOT NULL default '',\n\t\t\t`present` tinyint(4) default '1',\n\t\t\tPRIMARY KEY (`local_graph_id`,`device_id`,`ifIndex`, `host_id`),\n\t\t\tKEY `host_id` (`host_id`),\n\t\t\tKEY `device_id` (`device_id`)\n\t\t\t) ENGINE=InnoDB;");
}
mactrack_add_column('mac_track_devices', 'term_type', "ALTER TABLE `mac_track_devices` ADD COLUMN `term_type` tinyint(11) NOT NULL default '1' AFTER `scan_type`");
mactrack_add_column('mac_track_devices', 'private_key_path', "ALTER TABLE `mac_track_devices` ADD COLUMN `private_key_path` varchar(128) default '' AFTER `user_password`");
mactrack_add_column('mac_track_interfaces', 'ifMauAutoNegAdminStatus', "ALTER TABLE `mac_track_interfaces` ADD COLUMN `ifMauAutoNegAdminStatus` integer UNSIGNED NOT NULL default '0' AFTER `ifDuplex`");
mactrack_add_column('mac_track_interfaces', 'ifMauAutoNegRemoteSignaling', "ALTER TABLE `mac_track_interfaces` ADD COLUMN `ifMauAutoNegRemoteSignaling` integer UNSIGNED NOT NULL default '0' AFTER `ifMauAutoNegAdminStatus`");
mactrack_add_column('mac_track_device_types', 'serial_number_oid', "ALTER TABLE `mac_track_device_types` ADD COLUMN `serial_number_oid` varchar(100) default '' AFTER `ip_scanning_function`");
mactrack_add_column('mac_track_sites', 'customer_contact', "ALTER TABLE `mac_track_sites` ADD COLUMN `customer_contact` varchar(150) default '' AFTER `site_name`");
mactrack_add_column('mac_track_sites', 'netops_contact', "ALTER TABLE `mac_track_sites` ADD COLUMN `netops_contact` varchar(150) default '' AFTER `customer_contact`");
mactrack_add_column('mac_track_sites', 'facilities_contact', "ALTER TABLE `mac_track_sites` ADD COLUMN `facilities_contact` varchar(150) default '' AFTER `netops_contact`");
mactrack_add_column('mac_track_sites', 'site_info', "ALTER TABLE `mac_track_sites` ADD COLUMN `site_info` text AFTER `facilities_contact`");
mactrack_add_column('mac_track_devices', 'device_name', "ALTER TABLE `mac_track_devices` ADD COLUMN `device_name` varchar(100) default '' AFTER `host_id`");
mactrack_add_column('mac_track_devices', 'notes', "ALTER TABLE `mac_track_devices` ADD COLUMN `notes` text AFTER `hostname`");
mactrack_add_column('mac_track_scanning_functions', 'type', "ALTER TABLE `mac_track_scanning_functions` ADD COLUMN `type` int(10) unsigned NOT NULL default '0' AFTER `scanning_function`");
mactrack_add_column('mac_track_temp_ports', 'device_name', "ALTER TABLE `mac_track_temp_ports` ADD COLUMN `device_name` varchar(100) NOT NULL default '' AFTER `hostname`");
mactrack_add_column('mac_track_temp_ports', 'vendor_mac', "ALTER TABLE `mac_track_temp_ports` ADD COLUMN `vendor_mac` varchar(8) default NULL AFTER `mac_address`");
mactrack_add_column('mac_track_temp_ports', 'authorized', "ALTER TABLE `mac_track_temp_ports` ADD COLUMN `authorized` tinyint(3) unsigned NOT NULL default '0' AFTER `updated`");
mactrack_add_column('mac_track_ports', 'device_name', "ALTER TABLE `mac_track_ports` ADD COLUMN `device_name` varchar(100) NOT NULL default '' AFTER `hostname`");
mactrack_add_column('mac_track_ports', 'vendor_mac', "ALTER TABLE `mac_track_ports` ADD COLUMN `vendor_mac` varchar(8) default NULL AFTER `mac_address`");
mactrack_add_column('mac_track_ports', 'authorized', "ALTER TABLE `mac_track_ports` ADD COLUMN `authorized` tinyint(3) unsigned NOT NULL default '0' AFTER `scan_date`");
mactrack_add_column('mac_track_ips', 'mac_track_ips', "ALTER TABLE `mac_track_ips` ADD COLUMN `device_name` varchar(100) NOT NULL default '' AFTER `hostname`");
db_execute("ALTER TABLE mac_track_ips MODIFY COLUMN port_number varchar(20) NOT NULL default ''");
db_execute("ALTER TABLE mac_track_ports MODIFY COLUMN port_number varchar(20) NOT NULL default ''");
db_execute("ALTER TABLE mac_track_temp_ports MODIFY COLUMN port_number varchar(20) NOT NULL default ''");
db_execute("ALTER TABLE mac_track_aggregated_ports MODIFY COLUMN port_number varchar(20) NOT NULL default ''");
}