3 lines
1.1 KiB
SQL
3 lines
1.1 KiB
SQL
ALTER TABLE `devices` ADD `status_type` ENUM('ping','snmp','dns','ok') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'ok' AFTER `status`;
|
|
ALTER TABLE `devices` CHANGE `snmp_authlevel` `snmp_authlevel` ENUM('noAuthNoPriv','authNoPriv','authPriv') CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL, CHANGE `snmp_authalgo` `snmp_authalgo` ENUM('MD5','SHA') CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL, CHANGE `snmp_cryptoalgo` `snmp_cryptoalgo` ENUM('AES','DES') CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL, CHANGE `snmp_version` `snmp_version` ENUM('v1','v2c','v3') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'v2c', CHANGE `snmp_transport` `snmp_transport` ENUM('udp','tcp','udp6','tcp6') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'udp', CHANGE `snmpEngineID` `snmpEngineID` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL, CHANGE `sysObjectID` `sysObjectID` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL;
|