function upgrade_to_0_8_7a()
{
/* add alpha channel to graph items */
db_install_execute("0.8.7a", "ALTER TABLE `graph_templates_item` ADD COLUMN `alpha` CHAR(2) DEFAULT 'FF' AFTER `color_id`;");
/* add units=si as an option */
db_install_execute("0.8.7a", "ALTER TABLE `graph_templates_graph` ADD COLUMN `t_scale_log_units` CHAR(2) DEFAULT 0 AFTER `auto_scale_log`, ADD COLUMN `scale_log_units` CHAR(2) DEFAULT '' AFTER `t_scale_log_units`;");
}
function upgrade_to_0_8_7b()
{
/* add Task Item Id Index */
db_install_execute("0.8.7b", "ALTER TABLE `graph_templates_item` ADD INDEX `task_item_id` ( `task_item_id` )");
/* make CLI more responsive */
db_install_execute("0.8.7b", "ALTER TABLE `data_input_data` ADD INDEX `t_value`(`t_value`)");
}
function upgrade_to_0_8_6d()
{
/* changes for long OID's */
db_install_execute("0.8.6d", "ALTER TABLE `host_snmp_cache` CHANGE `snmp_index` `snmp_index` VARCHAR( 100 ) NOT NULL;");
db_install_execute("0.8.6d", "ALTER TABLE `data_local` CHANGE `snmp_index` `snmp_index` VARCHAR( 100 ) NOT NULL;");
db_install_execute("0.8.6d", "ALTER TABLE `graph_local` CHANGE `snmp_index` `snmp_index` VARCHAR( 100 ) NOT NULL;");
}
function upgrade_to_0_8_6i() {
/* once again, larger fields for OID's and the like */
db_install_execute("0.8.6i", "ALTER TABLE `poller_item` MODIFY COLUMN `arg1` TEXT;");
db_install_execute("0.8.6i", "ALTER TABLE `poller_reindex` MODIFY COLUMN `arg1` VARCHAR(255) NOT NULL;");
db_install_execute("0.8.6i", "ALTER TABLE `host_snmp_cache` MODIFY COLUMN `oid` TEXT NOT NULL;");
/* let's add more graph tree items for those larger installations */
db_install_execute("0.8.6i", "ALTER TABLE `graph_tree_items` MODIFY COLUMN `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;");
/* let's keep track of an important statistical value */
db_install_execute("0.8.6i", "ALTER TABLE `poller_time` ADD COLUMN `pid` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `id`;");
/* add some missing information from default/system data input methods */
/* first we must see if the user was smart enough to add it themselves */
$snmp_get = db_fetch_cell("SELECT id FROM data_input_fields WHERE data_name='snmp_port' AND data_input_id='1'");
$snmp_index = db_fetch_cell("SELECT id FROM data_input_fields WHERE data_name='snmp_port' AND data_input_id='2'");
if ($snmp_index > 0) {
db_install_execute("0.8.6i", "REPLACE INTO `data_input_fields` VALUES ($snmp_index, 'c1f36ee60c3dc98945556d57f26e475b',2,'SNMP Port','snmp_port','in','',0,'snmp_port','','');");
}else{
db_install_execute("0.8.6i", "REPLACE INTO `data_input_fields` VALUES (0, 'c1f36ee60c3dc98945556d57f26e475b',2,'SNMP Port','snmp_port','in','',0,'snmp_port','','');");
}
if ($snmp_get > 0) {
db_install_execute("0.8.6i", "REPLACE INTO `data_input_fields` VALUES ($snmp_get, 'fc64b99742ec417cc424dbf8c7692d36',1,'SNMP Port','snmp_port','in','',0,'snmp_port','','');");
}else{
db_install_execute("0.8.6i", "REPLACE INTO `data_input_fields` VALUES (0, 'fc64b99742ec417cc424dbf8c7692d36',1,'SNMP Port','snmp_port','in','',0,'snmp_port','','');");
}
}
function upgrade_to_0_8_7c() {
/* speed up the UI, missed in 0.8.7b upgrade, avoid failures if index already exists */
$result = db_fetch_assoc("SHOW INDEX FROM `data_local`") or die (mysql_error());
$indices = array();
foreach($result as $index => $arr) {
$indices[] = $arr["Key_name"];
}
if (!in_array('host_id', $indices)) {
db_install_execute("0.8.7c", "ALTER TABLE `data_local` ADD INDEX `host_id`(`host_id`)");
}
$result = db_fetch_assoc("SHOW INDEX FROM `host_snmp_cache`") or die (mysql_error());
$indices = array();
foreach($result as $index => $arr) {
$indices[] = $arr["Key_name"];
}
if (!in_array('field_name', $indices)) {
db_install_execute("0.8.7c", "ALTER TABLE `host_snmp_cache` ADD INDEX `field_name`(`field_name`)");
}
if (!in_array('field_value', $indices)) {
db_install_execute("0.8.7c", "ALTER TABLE `host_snmp_cache` ADD INDEX `field_value`(`field_value`)");
}
/* speed up graph automations some more */
db_install_execute("0.8.7c", "ALTER TABLE `data_input_fields` ADD INDEX `input_output`(`input_output`)");
/* increase the width of the settings field, but only if MySQL is >= 5 */
if (substr(db_fetch_cell("SELECT @@version"), 0, 1) >= 5) {
db_install_execute("0.8.7c", "ALTER TABLE `settings` MODIFY COLUMN `name` VARCHAR(512) NOT NULL DEFAULT ''");
}
/* add a default for NOT NULL columns */
db_install_execute("0.8.7c", "ALTER TABLE `data_local` MODIFY COLUMN `snmp_index` VARCHAR(255) NOT NULL DEFAULT '';");
db_install_execute("0.8.7c", "ALTER TABLE `graph_local` MODIFY COLUMN `snmp_index` VARCHAR(255) NOT NULL DEFAULT '';");
db_install_execute("0.8.7c", "ALTER TABLE `graph_templates_graph` MODIFY COLUMN `upper_limit` VARCHAR(20) NOT NULL DEFAULT '0';");
db_install_execute("0.8.7c", "ALTER TABLE `graph_templates_graph` MODIFY COLUMN `lower_limit` VARCHAR(20) NOT NULL DEFAULT '0';");
db_install_execute("0.8.7c", "ALTER TABLE `graph_templates_graph` MODIFY COLUMN `scale_log_units` CHAR(2) DEFAULT NULL;");
db_install_execute("0.8.7c", "ALTER TABLE `host` MODIFY COLUMN `availability` DECIMAL(8,5) NOT NULL DEFAULT '100.00000';");
db_install_execute("0.8.7c", "ALTER TABLE `host_snmp_cache` MODIFY COLUMN `snmp_index` VARCHAR(255) NOT NULL DEFAULT '';");
db_install_execute("0.8.7c", "ALTER TABLE `host_snmp_cache` MODIFY COLUMN `oid` TEXT NOT NULL;");
db_install_execute("0.8.7c", "ALTER TABLE `poller_item` MODIFY COLUMN `snmp_auth_protocol` VARCHAR(5) NOT NULL DEFAULT '';");
db_install_execute("0.8.7c", "ALTER TABLE `poller_item` MODIFY COLUMN `snmp_priv_passphrase` VARCHAR(200) NOT NULL DEFAULT '';");
db_install_execute("0.8.7c", "ALTER TABLE `poller_item` MODIFY COLUMN `snmp_priv_protocol` VARCHAR(6) NOT NULL DEFAULT '';");
db_install_execute("0.8.7c", "ALTER TABLE `poller_item` MODIFY COLUMN `rrd_next_step` MEDIUMINT(8) NOT NULL DEFAULT '0';");
db_install_execute("0.8.7c", "ALTER TABLE `poller_item` MODIFY COLUMN `arg1` TEXT DEFAULT NULL;");
db_install_execute("0.8.7c", "ALTER TABLE `poller_reindex` MODIFY COLUMN `arg1` VARCHAR(255) NOT NULL DEFAULT '';");
db_install_execute("0.8.7c", "ALTER TABLE `user_auth` MODIFY COLUMN `enabled` CHAR(2) NOT NULL DEFAULT 'on';");
db_install_execute("0.8.7c", "ALTER TABLE `user_log` MODIFY COLUMN `ip` VARCHAR(40) NOT NULL DEFAULT '';");
/* change size of columns to match current cacti.sql file */
db_install_execute("0.8.7c", "ALTER TABLE `poller_item` MODIFY COLUMN `rrd_step` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '300';");
db_install_execute("0.8.7c", "ALTER TABLE `poller_time` MODIFY COLUMN `pid` INT(11) UNSIGNED NOT NULL DEFAULT '0';");
/* Update deletion verification setting */
db_install_execute("0.8.7c", "UPDATE settings SET name = 'deletion_verification' WHERE name = 'remove_verification'");
/* Correct issue where rrd_next_step goes large in a positive way instead of the way it should go */
db_install_execute("0.8.7c", "ALTER TABLE `poller_item` MODIFY COLUMN `rrd_step` MEDIUMINT(8) NOT NULL DEFAULT 300");
}
function upgrade_to_0_8_6g() {
/* changes for even longer OID's */
db_install_execute("0.8.6g", "ALTER TABLE `host_snmp_cache` CHANGE `snmp_index` `snmp_index` VARCHAR( 255 ) NOT NULL;");
db_install_execute("0.8.6g", "ALTER TABLE `data_local` CHANGE `snmp_index` `snmp_index` VARCHAR( 255 ) NOT NULL;");
db_install_execute("0.8.6g", "ALTER TABLE `graph_local` CHANGE `snmp_index` `snmp_index` VARCHAR( 255 ) NOT NULL;");
db_install_execute("0.8.6g", "ALTER TABLE `graph_templates_graph` CHANGE `lower_limit` `lower_limit` VARCHAR ( 20 ) DEFAULT '0';");
db_install_execute("0.8.6g", "ALTER TABLE `graph_templates_graph` CHANGE `upper_limit` `upper_limit` VARCHAR ( 20 ) DEFAULT '0';");
}
function upgrade_to_0_8_2() {
db_install_execute("0.8.2", "ALTER TABLE `data_input_data_cache` ADD `host_id` MEDIUMINT( 8 ) NOT NULL AFTER `local_data_id`;");
db_install_execute("0.8.2", "ALTER TABLE `host` ADD `disabled` CHAR( 2 ) , ADD `status` TINYINT( 2 ) NOT NULL;");
db_install_execute("0.8.2", "UPDATE host_snmp_cache set field_name='ifName' where field_name='ifAlias' and snmp_query_id=1;");
db_install_execute("0.8.2", "UPDATE snmp_query_graph_rrd_sv set text = REPLACE(text,'ifAlias','ifName') where (snmp_query_graph_id=1 or snmp_query_graph_id=13 or snmp_query_graph_id=14 or snmp_query_graph_id=16 or snmp_query_graph_id=9 or snmp_query_graph_id=2 or snmp_query_graph_id=3 or snmp_query_graph_id=4);");
db_install_execute("0.8.2", "UPDATE snmp_query_graph_sv set text = REPLACE(text,'ifAlias','ifName') where (snmp_query_graph_id=1 or snmp_query_graph_id=13 or snmp_query_graph_id=14 or snmp_query_graph_id=16 or snmp_query_graph_id=9 or snmp_query_graph_id=2 or snmp_query_graph_id=3 or snmp_query_graph_id=4);");
db_install_execute("0.8.2", "UPDATE host set disabled = '';");
}
function upgrade_to_0_8_6e() {
/* changes for logarithmic rrd files */
db_install_execute("0.8.6e", "ALTER TABLE `data_template_rrd` CHANGE `rrd_minimum` `rrd_minimum` VARCHAR( 20 ) NOT NULL;");
db_install_execute("0.8.6e", "ALTER TABLE `data_template_rrd` CHANGE `rrd_maximum` `rrd_maximum` VARCHAR( 20 ) NOT NULL;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_templates_graph` CHANGE `upper_limit` `upper_limit` VARCHAR( 20 ) NOT NULL;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_templates_graph` CHANGE `lower_limit` `lower_limit` VARCHAR( 20 ) NOT NULL;");
db_install_execute("0.8.6e", "ALTER TABLE `poller_item` ADD `rrd_step` MEDIUMINT( 8 ) UNSIGNED AFTER `rrd_num`, ADD `rrd_next_step` MEDIUMINT( 8 ) AFTER `rrd_step`;");
/* increase size of ping status field to handle more extensive messages */
db_install_execute("0.8.6e", "ALTER TABLE `host` CHANGE `status_last_error` `status_last_error` VARCHAR( 100 );");
/* missing key's to improve Treeview performance */
db_install_execute("0.8.6e", "ALTER TABLE `graph_local` ADD KEY host_id (host_id), ADD KEY graph_template_id (graph_template_id), ADD KEY snmp_query_id (snmp_query_id), ADD KEY snmp_index (snmp_index);");
db_install_execute("0.8.6e", "ALTER TABLE `graph_templates_graph` ADD KEY title_cache (title_cache);");
db_install_execute("0.8.6e", "ALTER TABLE `graph_tree_items` ADD KEY host_id (host_id), ADD KEY local_graph_id (local_graph_id), ADD KEY order_key (order_key);");
db_install_execute("0.8.6e", "ALTER TABLE `graph_templates` ADD KEY name (name);");
db_install_execute("0.8.6e", "ALTER TABLE `snmp_query` ADD KEY name (name);");
db_install_execute("0.8.6e", "ALTER TABLE `host_snmp_cache` ADD KEY snmp_query_id (snmp_query_id);");
/* missing key's to improve Clear Poller Cache performance */
db_install_execute("0.8.6e", "ALTER TABLE `snmp_query_graph_rrd` ADD KEY data_template_rrd_id (data_template_rrd_id);");
db_install_execute("0.8.6e", "ALTER TABLE `snmp_query_graph_rrd` ADD KEY data_template_id (data_template_id);");
db_install_execute("0.8.6e", "ALTER TABLE `data_template_rrd` ADD KEY local_data_template_rrd_id (local_data_template_rrd_id);");
db_install_execute("0.8.6e", "ALTER TABLE `data_input_fields` ADD KEY type_code (type_code);");
/* remove NVA indexes from database */
db_install_execute("0.8.6e", "ALTER TABLE `cdef` DROP INDEX ID, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `cdef_items` DROP INDEX ID;");
db_install_execute("0.8.6e", "ALTER TABLE `colors` DROP INDEX ID, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `data_input` DROP INDEX ID, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `data_input_data` DROP INDEX data_input_field_id");
db_install_execute("0.8.6e", "ALTER TABLE `data_input_fields` DROP INDEX ID, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `data_local` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `data_template` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `data_template_data` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `data_template_rrd` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_local` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_template_input` DROP INDEX id, DROP INDEX id_2, DROP INDEX id_3;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_templates` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_templates_gprint` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_templates_graph` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_templates_item` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_tree` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `graph_tree_items` DROP INDEX ID, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `host` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `host_template` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `rra` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `settings` DROP INDEX Name, DROP INDEX name_2;");
db_install_execute("0.8.6e", "ALTER TABLE `settings_graphs` DROP INDEX user_id;");
db_install_execute("0.8.6e", "ALTER TABLE `snmp_query` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `snmp_query_graph` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `snmp_query_graph_rrd_sv` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `snmp_query_graph_sv` DROP INDEX id, DROP INDEX id_2;");
db_install_execute("0.8.6e", "ALTER TABLE `user_auth` DROP INDEX ID, DROP INDEX id_2;");
}
function upgrade_to_0_8_6h()
{
/* changes for ping result times */
db_install_execute("0.8.6h", "ALTER TABLE `host` MODIFY COLUMN `min_time` DECIMAL(10,5) DEFAULT 9.99999;");
db_install_execute("0.8.6h", "ALTER TABLE `host` MODIFY COLUMN `max_time` DECIMAL(10,5) DEFAULT 0.00000;");
db_install_execute("0.8.6h", "ALTER TABLE `host` MODIFY COLUMN `cur_time` DECIMAL(10,5) DEFAULT 0.00000;");
db_install_execute("0.8.6h", "ALTER TABLE `host` MODIFY COLUMN `avg_time` DECIMAL(10,5) DEFAULT 0.00000;");
/* Changes to user_log */
db_install_execute("0.8.6h", "ALTER TABLE `user_log` MODIFY COLUMN `ip` VARCHAR(40);");
/* Fixes broken graphs that have graph items with legend text but no color assigned */
db_install_execute("0.8.6h", "UPDATE graph_templates_item SET text_format = '' WHERE local_graph_id <> 0 AND color_id = 0 AND graph_type_id IN(4,5,6,7,8) AND text_format <> '';");
}
function upgrade_to_0_8_8()
{
/* speed up the joins */
$_columns = array_rekey(db_fetch_assoc("SHOW COLUMNS FROM `poller_item`"), "Field", "Field");
if (in_array("host_id", $_columns)) {
db_install_execute("0.8.8", "ALTER TABLE `poller_item` MODIFY COLUMN `host_id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'");
cacti_log(__FUNCTION__ . " upgrade table poller_item", false, "UPGRADE");
}
$_keys = array_rekey(db_fetch_assoc("SHOW KEYS FROM `poller_output`"), "Key_name", "Key_name");
if (in_array("PRIMARY", $_keys)) {
db_install_execute("0.8.8", "ALTER TABLE `poller_output` DROP PRIMARY KEY");
cacti_log(__FUNCTION__ . " table poller_output: dropping old PRIMARY KEY", false, "UPGRADE");
}
/* now the KEY we want to create is definitively NOT present
* MySQL < 5.00.60 requires a different syntax, this was fixed in MySQL 5.00.60, so take care */
db_install_execute("0.8.8", "ALTER TABLE `poller_output` ADD PRIMARY KEY (`local_data_id`, `rrd_name`, `time`) /*!50060 USING BTREE */");
cacti_log(__FUNCTION__ . " upgrade table poller_output", false, "UPGRADE");
/* speed up user management */
$_keys = array_rekey(db_fetch_assoc("SHOW KEYS FROM `user_log`"), "Key_name", "Key_name");
if (!in_array("user_id", $_keys)) {
db_install_execute("0.8.8", "ALTER TABLE `user_log` ADD KEY `user_id` (`user_id`)");
cacti_log(__FUNCTION__ . " upgrade table user_log", false, "UPGRADE");
}
/* Plugin Architecture
* be prepared to find those data already present
* in case of upgrade of a cacti+PIA installation */
$sql = "CREATE TABLE IF NOT EXISTS `plugin_config` (\n\t\t\t\t`id` \t\tint(8) unsigned NOT NULL auto_increment,\n\t\t\t\t`directory` varchar(32) \tNOT NULL default '',\n\t\t\t\t`name` \t\tvarchar(64) \tNOT NULL default '',\n\t\t\t\t`status`\ttinyint(2) \t\tNOT NULL default 0,\n\t\t\t\t`author`\tvarchar(64) \tNOT NULL default '',\n\t\t\t\t`webpage`\tvarchar(255) \tNOT NULL default '',\n\t\t\t\t`version`\tvarchar(8) \t\tNOT NULL default '',\n\t\t\t\tPRIMARY KEY (`id`),\n\t\t\t\tKEY `status` (`status`),\n\t\t\t\tKEY `directory` (`directory`)\n\t\t\t\t) ENGINE=MyISAM COMMENT='Plugin Configuration'";
db_install_execute("0.8.8", $sql);
cacti_log(__FUNCTION__ . " install table plugin_config", false, "UPGRADE");
$sql = "CREATE TABLE IF NOT EXISTS `plugin_db_changes` (\n\t\t\t\t`id` \t\tint(10) unsigned NOT NULL auto_increment,\n\t\t\t\t`plugin` \tvarchar(16) \tNOT NULL default '',\n\t\t\t\t`table` \tvarchar(64) \tNOT NULL default '',\n\t\t\t\t`column`\tvarchar(64) \tNOT NULL default '',\n\t\t\t\t`method` \tvarchar(16) \tNOT NULL default '',\n\t\t\t\tPRIMARY KEY (`id`),\n\t\t\t\tKEY `plugin` (`plugin`),\n\t\t\t\tKEY `method` (`method`)\n\t\t\t\t) ENGINE=MyISAM COMMENT='Plugin Database Changes'";
db_install_execute("0.8.8", $sql);
cacti_log(__FUNCTION__ . " install table plugin_db_changes", false, "UPGRADE");
$sql = "CREATE TABLE IF NOT EXISTS `plugin_hooks` (\n\t\t\t\t`id` \t\tint(8) unsigned NOT NULL auto_increment,\n\t\t\t\t`name` \t\tvarchar(32) \tNOT NULL default '',\n\t\t\t\t`hook` \t\tvarchar(64) \tNOT NULL default '',\n\t\t\t\t`file`\t\tvarchar(255) \tNOT NULL default '',\n\t\t\t\t`function` \tvarchar(128) \tNOT NULL default '',\n\t\t\t\t`status`\tint(8) \t\t\tNOT NULL default 0,\n\t\t\t\tPRIMARY KEY (`id`),\n\t\t\t\tKEY `hook` (`hook`),\n\t\t\t\tKEY `status` (`status`)\n\t\t\t\t) ENGINE=MyISAM COMMENT='Plugin Hooks'";
db_install_execute("0.8.8", $sql);
cacti_log(__FUNCTION__ . " install table plugin_hooks", false, "UPGRADE");
$sql = "CREATE TABLE IF NOT EXISTS `plugin_realms` (\n\t\t\t\t`id` \t\tint(8) unsigned NOT NULL auto_increment,\n\t\t\t\t`plugin` \tvarchar(32) \tNOT NULL default '',\n\t\t\t\t`file`\t\ttext\t\t \tNOT NULL,\n\t\t\t\t`display` \tvarchar(64) \tNOT NULL default '',\n\t\t\t\tPRIMARY KEY (`id`),\n\t\t\t\tKEY `plugin` (`plugin`)\n\t\t\t\t) ENGINE=MyISAM COMMENT='Plugin Realms'";
db_install_execute("0.8.8", $sql);
cacti_log(__FUNCTION__ . " install table plugin_realms", false, "UPGRADE");
/* fill initial data into plugin tables
* be prepared to find those data already present
* in case of upgrade of a cacti+PIA installation */
db_install_execute("0.8.8", "REPLACE INTO `plugin_realms` VALUES (1, 'internal', 'plugins.php', 'Plugin Management')");
db_install_execute("0.8.8", "REPLACE INTO `plugin_hooks` VALUES (1, 'internal', 'config_arrays', '', 'plugin_config_arrays', 1)");
db_install_execute("0.8.8", "REPLACE INTO `plugin_hooks` VALUES (2, 'internal', 'draw_navigation_text', '', 'plugin_draw_navigation_text', 1)");
/* allow admin user to access Plugin Management */
db_install_execute("0.8.8", "REPLACE INTO user_auth_realm VALUES (101,1)");
/* create index on data_template_data on data_input_id */
$_keys = array_rekey(db_fetch_assoc("SHOW KEYS FROM `data_template_data`"), "Key_name", "Key_name");
if (!in_array("data_input_id", $_keys)) {
db_install_execute("0.8.8", "ALTER TABLE `data_template_data` ADD KEY `data_input_id` (`data_input_id`)");
cacti_log(__FUNCTION__ . " upgrade table data_template_data", false, "UPGRADE");
}
}
function upgrade_to_0_8_1()
{
db_install_execute("0.8.1", "ALTER TABLE user_log add user_id mediumint(8) not null after username;");
db_install_execute("0.8.1", "ALTER TABLE user_log change time time datetime not null;");
db_install_execute("0.8.1", "ALTER TABLE user_log drop primary key;");
db_install_execute("0.8.1", "ALTER TABLE user_log add primary key (username, user_id, time);");
db_install_execute("0.8.1", "ALTER TABLE user_auth add realm mediumint(8) not null after password;");
db_install_execute("0.8.1", "UPDATE user_auth set realm = 1 where full_name='ldap user';");
$_src = db_fetch_assoc("select id, username from user_auth");
if (sizeof($_src) > 0) {
foreach ($_src as $item) {
db_install_execute("0.8.1", "UPDATE user_log set user_id = " . $item["id"] . " where username = '******';");
}
}
}
function upgrade_to_0_8_3()
{
include "../lib/template.php";
db_install_execute("0.8.3", "ALTER TABLE `user_auth` CHANGE `graph_policy` `policy_graphs` TINYINT( 1 ) UNSIGNED DEFAULT '1' NOT NULL;");
db_install_execute("0.8.3", "ALTER TABLE `user_auth` ADD `policy_trees` TINYINT( 1 ) UNSIGNED DEFAULT '1' NOT NULL, ADD `policy_hosts` TINYINT( 1 ) UNSIGNED DEFAULT '1' NOT NULL, ADD `policy_graph_templates` TINYINT( 1 ) UNSIGNED DEFAULT '1' NOT NULL;");
db_install_execute("0.8.3", "ALTER TABLE `graph_tree_items` ADD `host_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AFTER `title`;");
db_install_execute("0.8.3", "ALTER TABLE `rra` ADD `timespan` INT( 12 ) UNSIGNED NOT NULL;");
db_install_execute("0.8.3", "UPDATE rra set timespan=(rows*steps*144);");
db_install_execute("0.8.3", "CREATE TABLE `user_auth_perms` (\n\t\t`user_id` mediumint(8) unsigned NOT NULL default '0',\n\t\t`item_id` mediumint(8) unsigned NOT NULL default '0',\n\t\t`type` tinyint(2) unsigned NOT NULL default '0',\n\t\tPRIMARY KEY (`user_id`,`item_id`,`type`),\n\t\tKEY `user_id` (`user_id`,`type`)\n\t\t) TYPE=MyISAM;");
$auth_graph = db_fetch_assoc("select user_id,local_graph_id from user_auth_graph");
/* update to new 'user_auth_perms' table */
if (sizeof($auth_graph) > 0) {
foreach ($auth_graph as $item) {
db_install_execute("0.8.3", "replace into user_auth_perms (user_id,item_id,type) values (" . $item["user_id"] . "," . $item["local_graph_id"] . ",1);");
}
}
$auth_tree = db_fetch_assoc("select user_id,tree_id from user_auth_tree");
/* update to new 'user_auth_perms' table */
if (sizeof($auth_tree) > 0) {
foreach ($auth_tree as $item) {
db_install_execute("0.8.3", "replace into user_auth_perms (user_id,item_id,type) values (" . $item["user_id"] . "," . $item["tree_id"] . ",2);");
}
}
$users = db_fetch_assoc("select id from user_auth");
/* default all current users to tree view mode 1 (single pane) */
if (sizeof($users) > 0) {
foreach ($users as $item) {
db_install_execute("0.8.3", "replace into settings_graphs (user_id,name,value) values (" . $item["id"] . ",'default_tree_view_mode',1);");
}
}
/* drop unused tables */
db_install_execute("0.8.3", "DROP TABLE `user_auth_graph`;");
db_install_execute("0.8.3", "DROP TABLE `user_auth_tree`;");
db_install_execute("0.8.3", "DROP TABLE `user_auth_hosts`;");
/* bug#72 */
db_install_execute("0.8.3", "UPDATE graph_templates_item set cdef_id=15 where id=25;");
db_install_execute("0.8.3", "UPDATE graph_templates_item set cdef_id=15 where id=26;");
db_install_execute("0.8.3", "UPDATE graph_templates_item set cdef_id=15 where id=27;");
db_install_execute("0.8.3", "UPDATE graph_templates_item set cdef_id=15 where id=28;");
push_out_graph_item(25);
push_out_graph_item(26);
push_out_graph_item(27);
push_out_graph_item(28);
/* too many people had problems with the poller cache in 0.8.2a... */
db_install_execute("0.8.3", "DROP TABLE `data_input_data_cache`");
db_install_execute("0.8.3", "CREATE TABLE `data_input_data_cache` (\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL default '0',\n\t\t`host_id` mediumint(8) NOT NULL default '0',\n\t\t`data_input_id` mediumint(8) unsigned NOT NULL default '0',\n\t\t`action` tinyint(2) NOT NULL default '1',\n\t\t`command` varchar(255) NOT NULL default '',\n\t\t`management_ip` varchar(15) NOT NULL default '',\n\t\t`snmp_community` varchar(100) NOT NULL default '',\n\t\t`snmp_version` tinyint(1) NOT NULL default '0',\n\t\t`snmp_username` varchar(50) NOT NULL default '',\n\t\t`snmp_password` varchar(50) NOT NULL default '',\n\t\t`rrd_name` varchar(19) NOT NULL default '',\n\t\t`rrd_path` varchar(255) NOT NULL default '',\n\t\t`rrd_num` tinyint(2) unsigned NOT NULL default '0',\n\t\t`arg1` varchar(255) default NULL,\n\t\t`arg2` varchar(255) default NULL,\n\t\t`arg3` varchar(255) default NULL,\n\t\tPRIMARY KEY (`local_data_id`,`rrd_name`),\n\t\tKEY `local_data_id` (`local_data_id`)\n\t\t) TYPE=MyISAM;");
}
function upgrade_to_0_8_5() {
/* bug#109 */
db_install_execute("0.8.5", "UPDATE host_snmp_cache set field_name='ifDescr' where field_name='ifDesc' and snmp_query_id=1;");
db_install_execute("0.8.5", "UPDATE snmp_query_graph_rrd_sv set text = REPLACE(text,'ifDesc','ifDescr') where (snmp_query_graph_id=1 or snmp_query_graph_id=13 or snmp_query_graph_id=14 or snmp_query_graph_id=16 or snmp_query_graph_id=9 or snmp_query_graph_id=2 or snmp_query_graph_id=3 or snmp_query_graph_id=4 or snmp_query_graph_id=20 or snmp_query_graph_id=21 or snmp_query_graph_id=22);");
db_install_execute("0.8.5", "UPDATE snmp_query_graph_sv set text = REPLACE(text,'ifDesc','ifDescr') where (snmp_query_graph_id=1 or snmp_query_graph_id=13 or snmp_query_graph_id=14 or snmp_query_graph_id=16 or snmp_query_graph_id=9 or snmp_query_graph_id=2 or snmp_query_graph_id=3 or snmp_query_graph_id=4 or snmp_query_graph_id=20 or snmp_query_graph_id=21 or snmp_query_graph_id=22);");
db_install_execute("0.8.5", "UPDATE data_template_data set name = REPLACE(name,'ifDesc','ifDescr') where data_template_id=1;");
db_install_execute("0.8.5", "UPDATE data_template_data set name = REPLACE(name,'ifDesc','ifDescr') where data_template_id=2;");
db_install_execute("0.8.5", "UPDATE data_template_data set name = REPLACE(name,'ifDesc','ifDescr') where data_template_id=38;");
db_install_execute("0.8.5", "UPDATE data_template_data set name = REPLACE(name,'ifDesc','ifDescr') where data_template_id=39;");
db_install_execute("0.8.5", "UPDATE data_template_data set name = REPLACE(name,'ifDesc','ifDescr') where data_template_id=40;");
db_install_execute("0.8.5", "UPDATE data_template_data set name = REPLACE(name,'ifDesc','ifDescr') where data_template_id=41;");
$data_templates = db_fetch_assoc("select id from data_template_data where (data_template_id=1 or data_template_id=2 or data_template_id=38 or data_template_id=39 or data_template_id=40 or data_template_id=41);");
if (sizeof($data_templates) > 0) {
foreach ($data_templates as $item) {
db_install_execute("0.8.5", "UPDATE data_input_data set value='ifDescr' where value='ifDesc' and data_template_data_id=" . $item["id"] . ";");
}
}
db_install_execute("0.8.5", "UPDATE graph_templates_graph set title = REPLACE(title,'ifDesc','ifDescr') where graph_template_id=22;");
db_install_execute("0.8.5", "UPDATE graph_templates_graph set title = REPLACE(title,'ifDesc','ifDescr') where graph_template_id=24;");
db_install_execute("0.8.5", "UPDATE graph_templates_graph set title = REPLACE(title,'ifDesc','ifDescr') where graph_template_id=1;");
db_install_execute("0.8.5", "UPDATE graph_templates_graph set title = REPLACE(title,'ifDesc','ifDescr') where graph_template_id=2;");
db_install_execute("0.8.5", "UPDATE graph_templates_graph set title = REPLACE(title,'ifDesc','ifDescr') where graph_template_id=31;");
db_install_execute("0.8.5", "UPDATE graph_templates_graph set title = REPLACE(title,'ifDesc','ifDescr') where graph_template_id=32;");
db_install_execute("0.8.5", "UPDATE graph_templates_graph set title = REPLACE(title,'ifDesc','ifDescr') where graph_template_id=25;");
db_install_execute("0.8.5", "UPDATE graph_templates_graph set title = REPLACE(title,'ifDesc','ifDescr') where graph_template_id=33;");
db_install_execute("0.8.5", "UPDATE graph_templates_graph set title = REPLACE(title,'ifDesc','ifDescr') where graph_template_id=23;");
db_install_execute("0.8.5", "CREATE TABLE `host_graph` (`host_id` mediumint(8) unsigned NOT NULL default '0', `graph_template_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`host_id`,`graph_template_id`)) TYPE=MyISAM;");
/* typo */
db_install_execute("0.8.5", "UPDATE settings set name='snmp_version' where name='smnp_version';");
/* allow 'Unit Exponent Value' = 0 */
db_install_execute("0.8.5", "ALTER TABLE `graph_templates_graph` CHANGE `unit_exponent_value` `unit_exponent_value` VARCHAR( 5 ) NOT NULL;");
db_install_execute("0.8.5", "UPDATE graph_templates_graph set unit_exponent_value='' where unit_exponent_value='0';");
/* allow larger rrd steps */
db_install_execute("0.8.5", "ALTER TABLE `data_template_data` CHANGE `rrd_step` `rrd_step` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NOT NULL;");
}
function upgrade_to_0_8_7h()
{
global $config;
require_once $config["base_path"] . "/lib/poller.php";
/* speed up the reindexing */
$_columns = array_rekey(db_fetch_assoc("SHOW COLUMNS FROM host_snmp_cache"), "Field", "Field");
if (!in_array("present", $_columns)) {
db_install_execute("0.8.7h", "ALTER TABLE host_snmp_cache ADD COLUMN present tinyint NOT NULL DEFAULT '1' AFTER `oid`");
db_install_execute("0.8.7h", "ALTER TABLE host_snmp_cache ADD INDEX present (present)");
cacti_log(__FUNCTION__ . " upgrade table host_snmp_cache", false, "UPGRADE");
}
$_columns = array_rekey(db_fetch_assoc("SHOW COLUMNS FROM poller_item"), "Field", "Field");
if (!in_array("present", $_columns)) {
db_install_execute("0.8.7h", "ALTER TABLE poller_item ADD COLUMN present tinyint NOT NULL DEFAULT '1' AFTER `action`");
db_install_execute("0.8.7h", "ALTER TABLE poller_item ADD INDEX present (present)");
cacti_log(__FUNCTION__ . " upgrade table poller_item", false, "UPGRADE");
}
$_columns = array_rekey(db_fetch_assoc("SHOW COLUMNS FROM poller_reindex"), "Field", "Field");
if (!in_array("present", $_columns)) {
db_install_execute("0.8.7h", "ALTER TABLE poller_reindex ADD COLUMN present tinyint NOT NULL DEFAULT '1' AFTER `action`");
db_install_execute("0.8.7h", "ALTER TABLE poller_reindex ADD INDEX present (present)");
cacti_log(__FUNCTION__ . " upgrade table poller_reindex", false, "UPGRADE");
}
$_columns = array_rekey(db_fetch_assoc("SHOW COLUMNS FROM host"), "Field", "Field");
if (!in_array("device_threads", $_columns)) {
db_install_execute("0.8.7h", "ALTER TABLE host ADD COLUMN device_threads tinyint(2) unsigned NOT NULL DEFAULT '1' AFTER max_oids;");
cacti_log(__FUNCTION__ . " upgrade table host", false, "UPGRADE");
}
$_keys = array_rekey(db_fetch_assoc("SHOW KEYS FROM data_template_rrd"), "Key_name", "Key_name");
if (!in_array("duplicate_dsname_contraint", $_keys)) {
db_install_execute("0.8.7h", "ALTER TABLE `data_template_rrd` ADD UNIQUE INDEX `duplicate_dsname_contraint` (`local_data_id`, `data_source_name`, `data_template_id`)");
cacti_log(__FUNCTION__ . " upgrade table data_template_rrd", false, "UPGRADE");
}
/* update the reindex cache, as we now introduced more options for "index count changed" */
$command_string = read_config_option("path_php_binary");
$extra_args = "-q \"" . $config["base_path"] . "/cli/poller_reindex_hosts.php\" --id=all";
exec_background($command_string, "{$extra_args}");
cacti_log(__FUNCTION__ . " running {$command_string} {$extra_args}", false, "UPGRADE");
}
function upgrade_to_0_8_7()
{
/* add slope mode as an option */
db_install_execute("0.8.7", "ALTER TABLE `graph_templates_graph` ADD COLUMN `t_slope_mode` CHAR(2) DEFAULT 0 AFTER `vertical_label`, ADD COLUMN `slope_mode` CHAR(2) DEFAULT 'on' AFTER `t_slope_mode`;");
/* change the width of the last error field */
db_install_execute("0.8.7", "ALTER TABLE `host` MODIFY COLUMN `status_last_error` VARCHAR(255);");
/* fix rrd min and max values for data templates */
db_install_execute("0.8.7", "ALTER TABLE `data_template_rrd` MODIFY COLUMN `rrd_maximum` VARCHAR(20) NOT NULL DEFAULT 0, MODIFY COLUMN `rrd_minimum` VARCHAR(20) NOT NULL DEFAULT 0");
/* speed up the poller */
db_install_execute("0.8.7", "ALTER TABLE `host` ADD INDEX `disabled`(`disabled`)");
db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD INDEX `rrd_next_step`(`rrd_next_step`)");
/* speed up the UI */
db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD INDEX `action`(`action`)");
db_install_execute("0.8.7", "ALTER TABLE `user_auth` ADD INDEX `username`(`username`)");
db_install_execute("0.8.7", "ALTER TABLE `user_auth` ADD INDEX `realm`(`realm`)");
db_install_execute("0.8.7", "ALTER TABLE `user_log` ADD INDEX `username`(`username`)");
db_install_execute("0.8.7", "ALTER TABLE `data_input` ADD INDEX `name`(`name`)");
/* Add enable/disable to users */
db_install_execute("0.8.7", "ALTER TABLE `user_auth` ADD COLUMN `enabled` CHAR(2) DEFAULT 'on'");
db_install_execute("0.8.7", "ALTER TABLE `user_auth` ADD INDEX `enabled`(`enabled`)");
/* add additional fields to the host table */
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `availability_method` SMALLINT(5) UNSIGNED NOT NULL default '2' AFTER `snmp_timeout`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `ping_method` SMALLINT(5) UNSIGNED default '0' AFTER `availability_method`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `ping_port` INT(12) UNSIGNED default '0' AFTER `ping_method`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `ping_timeout` INT(12) UNSIGNED default '500' AFTER `ping_port`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `ping_retries` INT(12) UNSIGNED default '2' AFTER `ping_timeout`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `max_oids` INT(12) UNSIGNED default '10' AFTER `ping_retries`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `notes` TEXT AFTER `hostname`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `snmp_auth_protocol` CHAR(5) default '' AFTER `snmp_password`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `snmp_priv_passphrase` varchar(200) default '' AFTER `snmp_auth_protocol`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `snmp_priv_protocol` CHAR(6) default '' AFTER `snmp_priv_passphrase`");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `snmp_context` VARCHAR(64) default '' AFTER `snmp_priv_protocol`");
/* additional poller items fields required */
db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD COLUMN `snmp_auth_protocol` CHAR(5) default '' AFTER `snmp_password`");
db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD COLUMN `snmp_priv_passphrase` varchar(200) default '' AFTER `snmp_auth_protocol`");
db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD COLUMN `snmp_priv_protocol` CHAR(6) default '' AFTER `snmp_priv_passphrase`");
db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD COLUMN `snmp_context` VARCHAR(64) default '' AFTER `snmp_priv_protocol`");
/* Convert to new authentication system */
$global_auth = "on";
$global_auth_db = db_fetch_row("SELECT value FROM settings WHERE name = 'global_auth'");
if (sizeof($global_auth_db)) {
$global_auth = $global_auth_db["value"];
}
$ldap_enabled = "";
$ldap_enabled_db = db_fetch_row("SELECT value FROM settings WHERE name = 'ldap_enabled'");
if (sizeof($ldap_enabled_db)) {
$ldap_enabled = $ldap_enabled_db["value"];
}
if ($global_auth == "on") {
if ($ldap_enabled == "on") {
db_install_execute("0.8.7", "INSERT INTO settings VALUES ('auth_method','3')");
} else {
db_install_execute("0.8.7", "INSERT INTO settings VALUES ('auth_method','1')");
}
} else {
db_install_execute("0.8.7", "INSERT INTO settings VALUES ('auth_method','0')");
}
db_install_execute("0.8.7", "UPDATE `settings` SET value = '0' WHERE name = 'guest_user' and value = ''");
db_install_execute("0.8.7", "UPDATE `settings` SET name = 'user_template' WHERE name = 'ldap_template'");
db_install_execute("0.8.7", "UPDATE `settings` SET value = '0' WHERE name = 'user_template' and value = ''");
db_install_execute("0.8.7", "DELETE FROM `settings` WHERE name = 'global_auth'");
db_install_execute("0.8.7", "DELETE FROM `settings` WHERE name = 'ldap_enabled'");
/* host settings for availability */
$ping_method = read_config_option("ping_method");
$ping_retries = read_config_option("ping_retries");
$ping_timeout = read_config_option("ping_timeout");
$availability_method = read_config_option("availability_method");
$hosts = db_fetch_assoc("SELECT id, snmp_community, snmp_version FROM host");
if (sizeof($hosts)) {
foreach ($hosts as $host) {
if (strlen($host["snmp_community"] != 0)) {
if ($host["snmp_version"] == "3") {
if ($availability_method == AVAIL_SNMP) {
db_install_execute("0.8.7", "UPDATE host SET snmp_priv_protocol='[None]', snmp_auth_protocol='MD5', availability_method=" . AVAIL_SNMP . ", ping_method=" . PING_UDP . ",ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
} else {
if ($availability_method == AVAIL_SNMP_AND_PING) {
if ($ping_method == PING_ICMP) {
db_install_execute("0.8.7", "UPDATE host SET snmp_priv_protocol='[None]', availability_method=" . AVAIL_SNMP_AND_PING . ", ping_method=" . $ping_method . ", ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
} else {
db_install_execute("0.8.7", "UPDATE host SET snmp_priv_protocol='[None]', availability_method=" . AVAIL_SNMP_AND_PING . ", ping_method=" . $ping_method . ", ping_port=33439, ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
}
} else {
if ($ping_method == PING_ICMP) {
db_install_execute("0.8.7", "UPDATE host SET snmp_priv_protocol='[None]', availability_method=" . AVAIL_PING . ", ping_method=" . $ping_method . ", ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
} else {
db_install_execute("0.8.7", "UPDATE host SET snmp_priv_protocol='[None]', availability_method=" . AVAIL_PING . ", ping_method=" . $ping_method . ", ping_port=33439, ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
}
}
}
} else {
if ($availability_method == AVAIL_SNMP) {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_SNMP . ", ping_method=" . PING_UDP . ",ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
} else {
if ($availability_method == AVAIL_SNMP_AND_PING) {
if ($ping_method == PING_ICMP) {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_SNMP_AND_PING . ", ping_method=" . $ping_method . ", ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
} else {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_SNMP_AND_PING . ", ping_method=" . $ping_method . ", ping_port=33439, ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
}
} else {
if ($ping_method == PING_ICMP) {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_PING . ", ping_method=" . $ping_method . ", ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
} else {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_PING . ", ping_method=" . $ping_method . ", ping_port=33439, ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
}
}
}
}
} else {
if ($availability_method == AVAIL_SNMP) {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_SNMP . ", ping_method=" . PING_UDP . ", ping_timeout = " . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
} else {
if ($availability_method == AVAIL_SNMP_AND_PING) {
if ($ping_method == PING_ICMP) {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_SNMP_AND_PING . ", ping_method=" . $ping_method . ", ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
} else {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_SNMP_AND_PING . ", ping_method=" . $ping_method . ", ping_port=33439, ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
}
} else {
if ($ping_method == PING_ICMP) {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_PING . ", ping_method=" . $ping_method . ", ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
} else {
db_install_execute("0.8.7", "UPDATE host SET availability_method=" . AVAIL_PING . ", ping_method=" . $ping_method . ", ping_port=33439, ping_timeout=" . $ping_timeout . ", ping_retries=" . $ping_retries . " WHERE id=" . $host["id"]);
}
}
}
}
}
}
/* Add SNMPv3 to SNMP Input Methods */
db_install_execute("0.8.7", "INSERT INTO data_input_fields VALUES (DEFAULT, '20832ce12f099c8e54140793a091af90',1,'SNMP Authenticaion Protocol (v3)','snmp_auth_protocol','in','',0,'snmp_auth_protocol','','')");
db_install_execute("0.8.7", "INSERT INTO data_input_fields VALUES (DEFAULT, 'c60c9aac1e1b3555ea0620b8bbfd82cb',1,'SNMP Privacy Passphrase (v3)','snmp_priv_passphrase','in','',0,'snmp_priv_passphrase','','')");
db_install_execute("0.8.7", "INSERT INTO data_input_fields VALUES (DEFAULT, 'feda162701240101bc74148415ef415a',1,'SNMP Privacy Protocol (v3)','snmp_priv_protocol','in','',0,'snmp_priv_protocol','','')");
db_install_execute("0.8.7", "INSERT INTO data_input_fields VALUES (DEFAULT, '2cf7129ad3ff819a7a7ac189bee48ce8',2,'SNMP Authenticaion Protocol (v3)','snmp_auth_protocol','in','',0,'snmp_auth_protocol','','')");
db_install_execute("0.8.7", "INSERT INTO data_input_fields VALUES (DEFAULT, '6b13ac0a0194e171d241d4b06f913158',2,'SNMP Privacy Passphrase (v3)','snmp_priv_passphrase','in','',0,'snmp_priv_passphrase','','')");
db_install_execute("0.8.7", "INSERT INTO data_input_fields VALUES (DEFAULT, '3a33d4fc65b8329ab2ac46a36da26b72',2,'SNMP Privacy Protocol (v3)','snmp_priv_protocol','in','',0,'snmp_priv_protocol','','')");
/* Add 1 min rra */
db_install_execute("0.8.7", "INSERT INTO rra VALUES (DEFAULT,'283ea2bf1634d92ce081ec82a634f513','Hourly (1 Minute Average)',0.5,1,500,14400)");
$rrd_id = mysql_insert_id();
db_install_execute("0.8.7", "INSERT INTO `rra_cf` VALUES ({$rrd_id},1), ({$rrd_id},3)");
/* rename cactid path to spine path */
db_install_execute("0.8.7", "UPDATE settings SET name='path_spine' WHERE name='path_cactid'");
}
function upgrade_to_0_8_8() {
require_once("../lib/import.php");
/*
* Authenication System upgrade
*/
/* Create new tables */
db_install_execute("0.8.8","
CREATE TABLE `auth_control` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`description` varchar(255) default NULL,
`object_type` int(8) unsigned NOT NULL default '0',
`enabled` int(1) unsigned NOT NULL default '1',
`updated_when` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_by` varchar(100) NOT NULL default '',
`created_when` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `constraint_index` (`name`,`object_type`),
KEY `name` (`name`),
KEY `enabled` (`enabled`),
KEY `object_type` (`object_type`)
) TYPE=MyISAM");
db_install_execute("0.8.8","
CREATE TABLE `auth_data` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`control_id` mediumint(8) unsigned NOT NULL default '0',
`plugin_id` mediumint(8) unsigned NOT NULL default '0',
`category` varchar(25) NOT NULL default 'SYSTEM',
`name` varchar(100) NOT NULL default '',
`value` varchar(255) default NULL,
`enable_user_edit` int(1) unsigned NOT NULL default '0',
`updated_when` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_by` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `constraint_index` (`control_id`,`plugin_id`,`category`,`name`),
KEY `control_id` (`control_id`),
KEY `name` (`name`),
KEY `plugin_id` (`plugin_id`),
KEY `category` (`category`)
) TYPE=MyISAM");
db_install_execute("0.8.8","
CREATE TABLE `auth_graph_perms` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`item_id` mediumint(8) unsigned NOT NULL default '0',
`type` mediumint(8) unsigned NOT NULL default '0',
`control_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`),
KEY `type` (`type`),
KEY `control_id` (`control_id`)
) TYPE=MyISAM");
db_install_execute("0.8.8","
CREATE TABLE `auth_link` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`control_id` mediumint(8) unsigned NOT NULL default '0',
`parent_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `control_id` (`control_id`),
KEY `parent_id` (`parent_id`)
) TYPE=MyISAM");
db_install_execute("0.8.8","
CREATE TABLE `auth_perm` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`category` varchar(100) default NULL,
`plugin_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `plugin_id` (`plugin_id`),
KEY `category` (`category`)
) TYPE=MyISAM");
db_install_execute("0.8.8","
CREATE TABLE `auth_perm_link` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`control_id` mediumint(8) unsigned NOT NULL default '0',
`perm_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `control_id` (`control_id`),
KEY `perm_id` (`perm_id`)
) TYPE=MyISAM");
/* Upgrade current users and permissions */
/* add the poller id for hosts to allow for multiple pollers */
db_install_execute("0.8.8", "ALTER TABLE `host` ADD COLUMN `poller_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER id, ADD INDEX `poller_id`(`poller_id`);");
/* add the poller id for poller_output to allow for multiple pollers */
db_install_execute("0.8.8", "ALTER TABLE poller_output ADD COLUMN `poller_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `time`, ADD INDEX `poller_id`(`poller_id`);");
/* add the poller id for hosts to allow for multiple pollers */
db_install_execute("0.8.8", "ALTER TABLE `poller` ADD COLUMN `disabled` CHAR(2) DEFAULT '' AFTER `id`, ADD COLUMN `description` VARCHAR(45) NOT NULL DEFAULT '' AFTER `disabled`;");
/* add rrd_compute_rpn for data source items */
db_install_execute("0.8.8", "ALTER TABLE `data_template_rrd` ADD COLUMN `t_rrd_compute_rpn` CHAR(2) DEFAULT NULL AFTER `rrd_minimum`, ADD COLUMN `rrd_compute_rpn` VARCHAR(150) DEFAULT '' AFTER `t_rrd_compute_rpn`;");
/* add --alt-y-grid as an option */
db_install_execute("0.8.8", "ALTER TABLE `graph_templates_graph` ADD COLUMN `t_alt_y_grid` CHAR(2) DEFAULT 0 AFTER `auto_scale_rigid`, ADD COLUMN `alt_y_grid` CHAR(2) DEFAULT '' AFTER `t_alt_y_grid`;");
/* increase size for upper/lower limit for use with |query_*| variables */
db_install_execute("0.8.8", "ALTER TABLE `graph_templates_graph` MODIFY `lower_limit` VARCHAR(255)");
db_install_execute("0.8.8", "ALTER TABLE `graph_templates_graph` MODIFY `upper_limit` VARCHAR(255)");
/* add some fields required for hosts to table host_template */
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_community` VARCHAR(100) DEFAULT NULL AFTER `name`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_version` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1' AFTER `snmp_community`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_username` VARCHAR(50) DEFAULT NULL AFTER `snmp_version`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_password` VARCHAR(50) DEFAULT NULL AFTER `snmp_username`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_auth_protocol` CHAR(5) DEFAULT '' AFTER `snmp_password`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_priv_passphrase` VARCHAR(200) DEFAULT '' AFTER `snmp_auth_protocol`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_priv_protocol` CHAR(6) DEFAULT '' AFTER `snmp_priv_passphrase`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_context` VARCHAR(64) DEFAULT '' AFTER `snmp_priv_protocol`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_port` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '161' AFTER `snmp_context`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `snmp_timeout` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '500' AFTER `snmp_port`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `availability_method` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1' AFTER `snmp_timeout`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `ping_method` SMALLINT(5) UNSIGNED DEFAULT '0' AFTER `availability_method`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `ping_port` INT(12) UNSIGNED DEFAULT '0' AFTER `ping_method`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `ping_timeout` INT(12) UNSIGNED DEFAULT '500' AFTER `ping_port`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `ping_retries` INT(12) UNSIGNED DEFAULT '2' AFTER `ping_timeout`");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `max_oids` INT(12) UNSIGNED DEFAULT '10' AFTER `ping_retries`");
/* create a sites table */
db_install_execute("0.8.8", "CREATE TABLE `sites` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`address1` varchar(100) default '',
`address2` varchar(100) default '',
`city` varchar(50) default '',
`state` varchar(20) default '',
`postal_code` varchar(20) default '',
`country` varchar(30) default '',
`timezone` varchar(40) default '',
`alternate_id` varchar(30) default '',
`notes` text,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `city` (`city`),
KEY `state` (`state`),
KEY `postal_code` (`postal_code`),
KEY `country` (`country`),
KEY `alternate_id` (`alternate_id`)
) ENGINE=MyISAM;");
/* add a site column to the host table */
db_install_execute("0.8.8", "ALTER TABLE `host` ADD COLUMN `site_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER id, ADD INDEX `site_id`(`site_id`);");
/*
* now update current entries of table host_template
* make sure to use current global default settings in order not to change
* current behaviour when creating new hosts from those templates
*/
$snmp_community = read_config_option("snmp_community", true);
$snmp_version = read_config_option("snmp_ver", true);
$snmp_username = read_config_option("snmp_username", true);
$snmp_password = read_config_option("snmp_password", true);
$snmp_auth_protocol = read_config_option("snmp_auth_protocol", true);
$snmp_priv_passphrase = read_config_option("snmp_priv_passphrase", true);
$snmp_priv_protocol = read_config_option("snmp_priv_protocol", true);
$snmp_context = read_config_option("snmp_context", true);
$snmp_port = read_config_option("snmp_port", true);
$snmp_timeout = read_config_option("snmp_timeout", true);
$availability_method = read_config_option("availability_method", true);
$ping_method = read_config_option("ping_method", true);
$ping_port = read_config_option("ping_port", true);
$ping_timeout = read_config_option("ping_timeout", true);
$ping_retries = read_config_option("ping_retries", true);
$max_oids = read_config_option("max_get_size", true);
db_install_execute("0.8.8", "UPDATE `host_template` " .
"SET `snmp_community` = '" . $snmp_community . "' ," .
" `snmp_version` = $snmp_version," .
" `snmp_username` = '" . $snmp_username . "' ," .
" `snmp_password` = '" . $snmp_password . "' ," .
" `snmp_auth_protocol` = '" . $snmp_auth_protocol . "' ," .
" `snmp_priv_passphrase` = '" . $snmp_priv_passphrase . "' ," .
" `snmp_priv_protocol` = '" . $snmp_priv_protocol . "' ," .
" `snmp_context` = '" . $snmp_context . "' ," .
" `snmp_port` = $snmp_port," .
" `snmp_timeout` = $snmp_timeout," .
" `availability_method` = $availability_method," .
" `ping_method` = $ping_method," .
" `ping_port` = $ping_port," .
" `ping_timeout` = $ping_timeout," .
" `ping_retries` = $ping_retries," .
" `max_oids` = $max_oids");
/* add reindexing to host_template_snmp_query */
db_install_execute("0.8.8", "ALTER TABLE `host_template_snmp_query` ADD COLUMN `reindex_method` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `snmp_query_id`");
db_install_execute("0.8.8", "UPDATE `host_template_snmp_query` SET `reindex_method` = '1'");
/*
* Plugin Architecture
*/
/* Create new tables */
db_install_execute("0.8.8","
CREATE TABLE `plugin_config` (
`id` int(8) NOT NULL auto_increment,
`directory` varchar(32) NOT NULL default '',
`name` varchar(64) NOT NULL default '',
`status` tinyint(2) NOT NULL default '0',
`author` varchar(64) NOT NULL default '',
`webpage` varchar(255) NOT NULL default '',
`version` varchar(8) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `status` (`status`),
KEY `directory` (`directory`)
) TYPE=MyISAM");
db_install_execute("0.8.8","
CREATE TABLE `plugin_db_changes` (
`id` int(10) NOT NULL auto_increment,
`plugin` varchar(16) NOT NULL default '',
`table` varchar(64) NOT NULL default '',
`column` varchar(64) NOT NULL default '',
`method` varchar(16) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `plugin` (`plugin`),
KEY `method` (`method`)
) TYPE=MyISAM");
db_install_execute("0.8.8","
CREATE TABLE `plugin_hooks` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`hook` varchar(64) NOT NULL default '',
`file` varchar(255) NOT NULL default '',
`function` varchar(128) NOT NULL default '',
`status` int(8) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `hook` (`hook`),
KEY `status` (`status`)
) TYPE=MyISAM");
db_install_execute("0.8.8", "INSERT INTO `plugin_hooks` VALUES (1, 'internal', 'config_arrays', '', 'plugin_config_arrays', 1)");
db_install_execute("0.8.8", "INSERT INTO `plugin_hooks` VALUES (2, 'internal', 'draw_navigation_text', '', 'plugin_draw_navigation_text', 1)");
db_install_execute("0.8.8","
CREATE TABLE `plugin_realms` (
`id` int(8) NOT NULL auto_increment,
`plugin` varchar(32) NOT NULL default '',
`file` text NOT NULL default '',
`display` varchar(64) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `plugin` (`plugin`)
) TYPE=MyISAM");
db_install_execute("0.8.8", "INSERT INTO `plugin_realms` VALUES (1, 'internal', 'plugins.php', 'Plugin Management')");
/* wrong lower limit for generic OID graph template */
db_install_execute("0.8.8", "UPDATE graph_templates_graph SET lower_limit='0', vertical_label='' WHERE id=47");
/* rename templates */
/* graph templates */
db_install_execute("0.8.8", "UPDATE graph_templates SET name='UCD-SNMP - diskTable - Hard Drive Space' where name='ucd/net - Available Disk Space'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='UCD-SNMP - systemStats - CPU Usage' where name='ucd/net - CPU Usage'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='Linux Localhost - ICMP - Ping Host' where name='Unix - Ping Latency'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='Linux Localhost - ps ax - Processes' where name='Unix - Processes'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='Linux Localhost - Uptime - Load Average' where name='Unix - Load Average'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='Linux Localhost - who - Logged in Users' where name='Unix - Logged in Users'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='UCD-SNMP - loadTable - Load Average' where name='ucd/net - Load Average'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='Linux Localhost - meminfo - Memory' where name='Linux - Memory Usage'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='UCD-SNMP - memory - Memory Usage' where name='ucd/net - Memory Usage'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='Linux Localhost - df - Hard Drive Space' where name='Unix - Available Disk Space'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='HOST-RESSOURCES - hrStorageTable - Hard Drive Space' where name='Host MIB - Available Disk Space'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='HOST-RESSOURCES - hrProcessorTable - CPU Utilization' where name='Host MIB - CPU Utilization'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='HOST-RESSOURCES - hrSystemNumUsers - Logged in Users' where name='Host MIB - Logged in Users'");
db_install_execute("0.8.8", "UPDATE graph_templates SET name='HOST-RESSOURCES - hrSystemProcesses - Processes' where name='Host MIB - Processes'");
/* data templates */
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - diskTable - Hard Drive Space' WHERE name='ucd/net - Hard Drive Space'");
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - systemStats - CPU Usage: System' WHERE name='ucd/net - CPU Usage - System'");
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - systemStats - CPU Usage: User' WHERE name='ucd/net - CPU Usage - User'");
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - systemStats - CPU Usage: Nice' WHERE name='ucd/net - CPU Usage - Nice'");
db_install_execute("0.8.8", "UPDATE data_template SET name='Linux Localhost - Uptime - Load Average' WHERE name='Unix - Load Average'");
db_install_execute("0.8.8", "UPDATE data_template SET name='Linux Localhost - meminfo - Memory: Free' WHERE name='Linux - Memory - Free'");
db_install_execute("0.8.8", "UPDATE data_template SET name='Linux Localhost - meminfo - Memory: Free Swap' WHERE name='Linux - Memory - Free Swap'");
db_install_execute("0.8.8", "UPDATE data_template SET name='Linux Localhost - ps ax - Processes' WHERE name='Unix - Processes'");
db_install_execute("0.8.8", "UPDATE data_template SET name='Linux Localhost - who - Logged in Users' WHERE name='Unix - Logged in Users'");
db_install_execute("0.8.8", "UPDATE data_template SET name='Linux Localhost - ICMP - Ping Host' WHERE name='Unix - Ping Host'");
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - loadTable - Load Average: 1 Minute' WHERE name='ucd/net - Load Average - 1 Minute'");
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - loadTable - Load Average: 5 Minutes' WHERE name='ucd/net - Load Average - 5 Minute'");
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - loadTable - Load Average: 15 Minutes' WHERE name='ucd/net - Load Average - 15 Minute'");
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - memory - Buffers' WHERE name='ucd/net - Memory - Buffers'");
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - memory - Free' WHERE name='ucd/net - Memory - Free'");
db_install_execute("0.8.8", "UPDATE data_template SET name='Linux Localhost - df - Hard Drive Space' WHERE name='Unix - Hard Drive Space'");
db_install_execute("0.8.8", "UPDATE data_template SET name='HOST-RESSOURCES - hrStorageTable - Hard Drive Space' WHERE name='Host MIB - Hard Drive Space'");
db_install_execute("0.8.8", "UPDATE data_template SET name='HOST-RESSOURCES - hrProcessorTable - CPU Utilization' WHERE name='Host MIB - CPU Utilization'");
db_install_execute("0.8.8", "UPDATE data_template SET name='HOST-RESSOURCES - hrSystemProcesses - Processes' WHERE name='Host MIB - Processes'");
db_install_execute("0.8.8", "UPDATE data_template SET name='HOST-RESSOURCES - hrSystemNumUsers - Logged in Users' WHERE name='Host MIB - Logged in Users'");
db_install_execute("0.8.8", "UPDATE data_template SET name='UCD-SNMP - memory - Cache' WHERE name='ucd/net - Memory - Cache'");
/* data queries */
db_install_execute("0.8.8", "UPDATE snmp_query SET name='UCD-SNMP - diskTable - Hard Drive Space' where name='ucd/net - Get Monitored Partitions'");
db_install_execute("0.8.8", "UPDATE snmp_query SET name='Linux Localhost - df - Hard Drive Space' where name='Unix - Get Mounted Partitions'");
db_install_execute("0.8.8", "UPDATE snmp_query SET name='HOST-RESSOURCES - hrStorageTable - Hard Drive Space' where name='SNMP - Get Mounted Partitions'");
db_install_execute("0.8.8", "UPDATE snmp_query SET name='HOST-RESSOURCES - hrProcessorTable - CPU Utilization' where name='SNMP - Get Processor Information'");
/* enable lossless reindexing in Cacti */
db_install_execute("0.8.8", "ALTER TABLE host_snmp_cache ADD COLUMN present tinyint NOT NULL DEFAULT '1' AFTER `oid`, ADD INDEX present USING BTREE (present)");
db_install_execute("0.8.8", "ALTER TABLE poller_item ADD COLUMN present tinyint NOT NULL DEFAULT '1' AFTER `action`, ADD INDEX present USING BTREE (present)");
db_install_execute("0.8.8", "ALTER TABLE poller_reindex ADD COLUMN present tinyint NOT NULL DEFAULT '1' AFTER `action`, ADD INDEX present USING BTREE (present)");
/* add image storage to graph templates, data queries, and device templates */
db_install_execute("0.8.8", "ALTER TABLE `data_template` ADD COLUMN `description` varchar(255) NOT NULL AFTER `name`;");
db_install_execute("0.8.8", "ALTER TABLE `graph_templates` ADD COLUMN `description` varchar(255) NOT NULL AFTER `name`;");
db_install_execute("0.8.8", "ALTER TABLE `graph_templates` ADD COLUMN `image` varchar(64) NOT NULL AFTER `description`");
db_install_execute("0.8.8", "ALTER TABLE `snmp_query` ADD COLUMN `image` varchar(64) NOT NULL AFTER `description`;");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `description` varchar(255) NOT NULL AFTER `name`;");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `image` varchar(64) NOT NULL AFTER `description`;");
/* changes for template propagation */
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `override_defaults` CHAR(2) NOT NULL DEFAULT '' AFTER `image`;");
db_install_execute("0.8.8", "ALTER TABLE `host_template` ADD COLUMN `override_permitted` CHAR(2) NOT NULL DEFAULT 'on' AFTER `override_defaults`;");
db_install_execute("0.8.8", "ALTER TABLE `host` ADD COLUMN `template_enabled` CHAR(2) NOT NULL DEFAULT '' AFTER `host_template_id`;");
/* Add SNMPv3 Context to SNMP Input Methods */
/* first we must see if the user was smart enough to add it themselves */
$context1 = db_fetch_row("SELECT id FROM data_input_fields WHERE data_input_id=1 AND data_name='snmp_context' AND input_output='in' AND type_code='snmp_context'");
if ($context1 > 0) {
# nop
} else {
db_install_execute("0.8.8", "INSERT INTO data_input_fields VALUES (DEFAULT, '8e42450d52c46ebe76a57d7e51321d36',1,'SNMP Context (v3)','snmp_context','in','',0,'snmp_context','','')");
}
$context2 = db_fetch_row("SELECT id FROM data_input_fields WHERE data_input_id=2 AND data_name='snmp_context' AND input_output='in' AND type_code='snmp_context'");
if ($context2 > 0) {
# nop
} else {
db_install_execute("0.8.8", "INSERT INTO data_input_fields VALUES (DEFAULT, 'b5ce68ca4e9e36d221459758ede01484',2,'SNMP Context (v3)','snmp_context','in','',0,'snmp_context','','')");
}
db_install_execute("0.8.8", "UPDATE data_input_fields SET name='SNMP Authentication Protocol (v3)' WHERE name='SNMP Authenticaion Protocol (v3)'");
db_install_execute("0.8.8", "ALTER TABLE host ADD COLUMN polling_time decimal(10,5) NOT NULL DEFAULT '0.00000' AFTER `avg_time`");
# graph_templates_graph
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_right_axis char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN right_axis varchar(20) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_right_axis_label char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN right_axis_label varchar(200) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_right_axis_format char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN right_axis_format mediumint(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_only_graph char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN only_graph char(2) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_full_size_mode char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN full_size_mode char(2) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_no_gridfit char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN no_gridfit char(2) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_x_grid char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN x_grid mediumint(8) unsigned NOT NULL default '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_unit_length char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN unit_length varchar(10) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_back char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_back char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_canvas char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_canvas char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_shadea char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_shadea char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_shadeb char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_shadeb char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_grid char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_grid char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_mgrid char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_mgrid char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_font char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_font char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_axis char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_axis char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_frame char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_frame char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_colortag_arrow char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN colortag_arrow char(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_font_render_mode char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN font_render_mode varchar(10) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_font_smoothing_threshold char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN font_smoothing_threshold int(8) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_graph_render_mode char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN graph_render_mode varchar(10) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_pango_markup char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN pango_markup char(2) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_interlaced char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN interlaced char(2) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_tab_width char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN tab_width mediumint(4) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_watermark char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN watermark varchar(255) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_force_rules_legend char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN force_rules_legend char(2) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_legend_position char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN legend_position varchar(10) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_legend_direction char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN legend_direction varchar(10) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_grid_dash char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN grid_dash varchar(10) DEFAULT NULL");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN t_border char(2) DEFAULT '0'");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_graph ADD COLUMN border char(2) DEFAULT NULL");
# create new table graph_templates_xaxis
db_install_execute("0.8.8","
CREATE TABLE `graph_templates_xaxis` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Table Id',
`hash` varchar(32) NOT NULL DEFAULT '' COMMENT 'Unique Hash',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name of X-Axis Preset',
PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='X-Axis Presets'");
db_install_execute("0.8.8", "INSERT INTO `graph_templates_xaxis` VALUES(1, 'a09c5cab07a6e10face1710cec45e82f', 'Default')");
# create new table graph_templates_xaxis_items
db_install_execute("0.8.8","
CREATE TABLE `graph_templates_xaxis_items` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Row Id',
`hash` varchar(32) NOT NULL DEFAULT '' COMMENT 'Unique Hash',
`item_name` varchar(100) NOT NULL COMMENT 'Name of this Item',
`xaxis_id` int(12) unsigned NOT NULL DEFAULT '0' COMMENT 'Id of related X-Axis Preset',
`timespan` int(12) unsigned NOT NULL DEFAULT '0' COMMENT 'Graph Timespan that shall match this Item',
`gtm` VARCHAR( 10 ) NOT NULL DEFAULT '' COMMENT 'Global Grid Timespan',
`gst` smallint(4) unsigned NOT NULL COMMENT 'Global Grid Timespan Steps',
`mtm` VARCHAR( 10 ) NOT NULL DEFAULT '' COMMENT 'Major Grid Timespan',
`mst` smallint(4) unsigned NOT NULL COMMENT 'Major Grid Timespan Steps',
`ltm` VARCHAR( 10 ) NOT NULL DEFAULT '' COMMENT 'Label Grid Timespan',
`lst` smallint(4) unsigned NOT NULL COMMENT 'Label Grid Timespan Steps',
`lpr` int(12) unsigned NOT NULL COMMENT 'Label Placement Relative',
`lfm` varchar(100) NOT NULL COMMENT 'Label Format',
PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='Items for X-Axis Presets'");
db_install_execute("0.8.8", "INSERT INTO `graph_templates_xaxis_items` VALUES(1, '60c2066a1c45fab021d32fe72cbf4f49', 'Day', 1, 86400, 'HOUR', 4, 'HOUR', 2, 'HOUR', 2, 23200, '%H')");
db_install_execute("0.8.8", "INSERT INTO `graph_templates_xaxis_items` VALUES(2, 'd867f8fc2730af212d0fd6708385cf89', 'Week', 1, 604800, 'DAY', 1, 'DAY', 1, 'DAY', 1, 259200, '%d')");
db_install_execute("0.8.8", "INSERT INTO `graph_templates_xaxis_items` VALUES(3, '06304a1840da88f3e0438ac147219003', 'Month', 1, 2678400, 'WEEK', 1, 'WEEK', 1, 'WEEK', 1, 1296000, '%W')");
db_install_execute("0.8.8", "INSERT INTO `graph_templates_xaxis_items` VALUES(4, '33ac10e60fd855e74736bee43bda4134', 'Year', 1, 31622400, 'MONTH', 2, 'MONTH', 1, 'MONTH', 2, 15811200, '%m')");
/* upgrade to the graph trees */
db_install_execute("0.8.8", "ALTER TABLE `graph_tree_items`
ADD COLUMN `parent_id` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0' AFTER `id`,
ADD COLUMN `site_id` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0' AFTER `title`;");
/* make tree's a per user object. System tree's have a user_id of 0 */
db_install_execute("0.8.8", "ALTER TABLE `graph_tree` ADD COLUMN `user_id` INTEGER UNSIGNED NOT NULL DEFAULT '0' AFTER `id`, ADD INDEX `user_id`(`user_id`);");
/* get all nodes whose parent_id is not 0 */
$tree_items = db_fetch_assoc("SELECT * FROM graph_tree_items WHERE order_key NOT LIKE '___000%';");
if (sizeof($tree_items)) {
foreach($tree_items AS $item) {
$translated_key = rtrim($item["order_key"], "0\r\n");
$missing_len = strlen($translated_key) % CHARS_PER_TIER;
if ($missing_len > 0) {
$translated_key .= substr("000", 0, $missing_len);
}
$parent_key_len = strlen($translated_key) - CHARS_PER_TIER;
$parent_key = substr($translated_key, 0, $parent_key_len);
$parent_id = db_fetch_cell("SELECT id FROM graph_tree_items WHERE graph_tree_id=" . $item["graph_tree_id"] . " AND order_key LIKE '" . $parent_key . "000%'");
if ($parent_id != "") {
db_execute("UPDATE graph_tree_items SET parent_id=$parent_id WHERE id=" . $item["id"]);
}else{
cacti_log("Some error occurred processing children", false);
}
}
}
/* make the poller's ip address varchar() */
db_install_execute("0.8.8", "ALTER TABLE poller CHANGE COLUMN ip_address ip_address varchar(30) not null default ''");
/* insert the default poller into the database */
db_install_execute("0.8.8", "INSERT INTO `poller` VALUES (1,'','Main Poller','localhost','127.0.0.1','0000-00-00 00:00:00');");
/* update all devices to use poller 1, or the main poller */
db_install_execute("0.8.8", "UPDATE host SET poller_id=1 WHERE poller_id=0");
/* update the poller_items table to reflect the host change */
db_install_execute("0.8.8", "UPDATE poller_item SET poller_id=1 WHERE poller_id=0");
/* rename host -> device for tables and columns
* we have some updates to those tables in this file already
* so please take care not to change sequence */
$_indexes = db_fetch_assoc("SHOW INDEX FROM data_local WHERE `Column_name`='host_id'");
if (sizeof($_indexes)) {
foreach($_indexes as $_index) {
db_install_execute("0.8.8", "ALTER TABLE data_local DROP INDEX " . $_index["Key_name"]);
}
}
db_install_execute("0.8.8", "ALTER TABLE data_local CHANGE `host_id` `device_id` MEDIUMINT(8) UNSIGNED NOT NULL, ADD INDEX `device_id` ( `device_id` )");
db_install_execute("0.8.8", "ALTER TABLE graph_local DROP INDEX `host_id`");
db_install_execute("0.8.8", "ALTER TABLE graph_local CHANGE `host_id` `device_id` MEDIUMINT(8) UNSIGNED NOT NULL, ADD INDEX `device_id` ( `device_id` )");
db_install_execute("0.8.8", "ALTER TABLE graph_tree_items DROP INDEX `host_id`");
db_install_execute("0.8.8", "ALTER TABLE graph_tree_items CHANGE `host_id` `device_id` MEDIUMINT(8) UNSIGNED NOT NULL, ADD INDEX `device_id` ( `device_id` ), CHANGE `host_grouping_type` `device_grouping_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT 1");
db_install_execute("0.8.8", "RENAME TABLE `host` TO `device`");
db_install_execute("0.8.8", "ALTER TABLE `device` CHANGE `host_template_id` `device_template_id` MEDIUMINT(8) UNSIGNED NOT NULL");
db_install_execute("0.8.8", "RENAME TABLE `host_graph` TO `device_graph`");
db_install_execute("0.8.8", "ALTER TABLE device_graph CHANGE `host_id` `device_id` MEDIUMINT(8) UNSIGNED NOT NULL");
db_install_execute("0.8.8", "RENAME TABLE `host_snmp_cache` TO `device_snmp_cache`");
db_install_execute("0.8.8", "ALTER TABLE device_snmp_cache DROP INDEX `host_id`");
db_install_execute("0.8.8", "ALTER TABLE device_snmp_cache CHANGE `host_id` `device_id` MEDIUMINT(8) UNSIGNED NOT NULL, ADD INDEX `device_id` ( `device_id` )");
db_install_execute("0.8.8", "RENAME TABLE `host_snmp_query` TO `device_snmp_query`");
db_install_execute("0.8.8", "ALTER TABLE device_snmp_query DROP INDEX `host_id`");
db_install_execute("0.8.8", "ALTER TABLE device_snmp_query CHANGE `host_id` `device_id` MEDIUMINT(8) UNSIGNED NOT NULL, ADD INDEX `device_id` ( `device_id` )");
db_install_execute("0.8.8", "RENAME TABLE `host_template` TO `device_template`");
db_install_execute("0.8.8", "RENAME TABLE `host_template_graph` TO `device_template_graph`");
db_install_execute("0.8.8", "ALTER TABLE device_template_graph DROP INDEX `host_template_id`");
db_install_execute("0.8.8", "ALTER TABLE device_template_graph CHANGE `host_template_id` `device_template_id` MEDIUMINT(8) UNSIGNED NOT NULL, ADD INDEX `device_template_id` ( `device_template_id` )");
db_install_execute("0.8.8", "RENAME TABLE `host_template_snmp_query` TO `device_template_snmp_query`");
db_install_execute("0.8.8", "ALTER TABLE device_template_snmp_query DROP INDEX `host_template_id`");
db_install_execute("0.8.8", "ALTER TABLE device_template_snmp_query CHANGE `host_template_id` `device_template_id` MEDIUMINT(8) UNSIGNED NOT NULL, ADD INDEX `device_template_id` ( `device_template_id` )");
db_install_execute("0.8.8", "ALTER TABLE poller_item DROP INDEX `host_id`");
db_install_execute("0.8.8", "ALTER TABLE poller_item CHANGE `host_id` `device_id` MEDIUMINT(8) UNSIGNED NOT NULL, ADD INDEX `device_id` ( `device_id` )");
db_install_execute("0.8.8", "ALTER TABLE poller_reindex CHANGE `host_id` `device_id` MEDIUMINT(8) UNSIGNED NOT NULL");
db_install_execute("0.8.8", "ALTER TABLE user_auth CHANGE `policy_hosts` `policy_devices` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1");
# table column updates using REPLACE
db_install_execute("0.8.8", "UPDATE data_template_data SET name=REPLACE(name,'|host_','|device_') WHERE name like '%%|host_%%'");
db_install_execute("0.8.8", "UPDATE graph_templates_graph SET title=REPLACE(title,'|host_','|device_') WHERE title like '%%|host_%%'");
db_install_execute("0.8.8", "UPDATE graph_templates_graph SET upper_limit=REPLACE(upper_limit,'|host_','|device_') WHERE upper_limit like '%%|host_%%'");
db_install_execute("0.8.8", "UPDATE graph_templates_graph SET lower_limit=REPLACE(lower_limit,'|host_','|device_') WHERE lower_limit like '%%|host_%%'");
db_install_execute("0.8.8", "UPDATE graph_templates_graph SET vertical_label=REPLACE(vertical_label,'|host_','|device_') WHERE vertical_label like '%%|host_%%'");
db_install_execute("0.8.8", "UPDATE snmp_query_graph_rrd_sv SET `text`=REPLACE(`text`,'|host_','|device_') WHERE `text` like '%%|host_%%'");
db_install_execute("0.8.8", "UPDATE snmp_query_graph_sv SET `text`=REPLACE(`text`,'|host_','|device_') WHERE `text` like '%%|host_%%'");
/* New Indexes */
db_install_execute("0.8.8","ALTER TABLE `data_input_data` ADD INDEX `data_template_data_id` (`data_template_data_id`)");
db_install_execute("0.8.8","ALTER TABLE `data_local` ADD INDEX `device_id_snmp_query_id_snmp_index` (`device_id`,`snmp_query_id`,`snmp_index`)");
db_install_execute("0.8.8","ALTER TABLE `data_template_data` ADD INDEX `data_source_path` (`data_source_path`)");
db_install_execute("0.8.8","ALTER TABLE `data_template_rrd` ADD INDEX `local_data_id_data_source_name` (`local_data_id`,`data_source_name`)");
db_install_execute("0.8.8","ALTER TABLE `device_snmp_cache` ADD INDEX `device_id_snmp_query_id_snmp_index` (`device_id`,`snmp_query_id`,`snmp_index`)");
db_install_execute("0.8.8","ALTER TABLE `device_snmp_cache` ADD INDEX `device_id_snmp_query_id` (`device_id`,`snmp_query_id`)");
db_install_execute("0.8.8","ALTER TABLE `graph_templates_item` ADD INDEX `graph_template_id_local_graph_id` (`graph_template_id`,`local_graph_id`)");
db_install_execute("0.8.8","ALTER TABLE `graph_templates_item` ADD INDEX `local_graph_template_item_id` (`local_graph_template_item_id`)");
db_install_execute("0.8.8","ALTER TABLE `poller_item` ADD INDEX `local_data_id_rrd_path` (`local_data_id`,`rrd_path`)");
db_install_execute("0.8.8","ALTER TABLE `poller_item` ADD INDEX `device_id_rrd_next_step` (`device_id`,`rrd_next_step`)");
db_install_execute("0.8.8","ALTER TABLE `poller_item` ADD INDEX `device_id_snmp_port` (`device_id`,`snmp_port`)");
db_install_execute("0.8.8","ALTER TABLE `user_log` ADD INDEX `user_id` (`user_id`)");
/* Create new tables */
db_install_execute("0.8.8","CREATE TABLE `log` (
`id` bigint(20) unsigned NOT NULL default '0',
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`facility` tinyint(1) unsigned NOT NULL default '0',
`severity` int(1) NOT NULL default '0',
`poller_id` smallint(5) unsigned NOT NULL default '0',
`device_id` mediumint(8) unsigned NOT NULL default '0',
`data_id` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default 'system',
`source` varchar(50) NOT NULL default 'localhost',
`plugin_name` varchar(64) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`id`),
KEY `facility` (`facility`),
KEY `severity` (`severity`),
KEY `device_id` (`device_id`),
KEY `data_id` (`data_id`),
KEY `poller_id` (`poller_id`),
KEY `username` (`username`),
KEY `timestamp` (`timestamp`),
KEY `plugin_name` (`plugin_name`)
) TYPE=MyISAM");
/* changes to insert VDEF into table graph_templates_item just behind CDEF */
db_install_execute("0.8.8", "ALTER TABLE `graph_templates_item` ADD `vdef_id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0 AFTER `cdef_id`");
/* create new table VDEF */
db_install_execute("0.8.8", "CREATE TABLE vdef (
id mediumint(8) unsigned NOT NULL auto_increment,
hash varchar(32) NOT NULL default '',
name varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;");
/* fill table VDEF */
db_install_execute("0.8.8", "INSERT INTO `vdef` VALUES (1, 'e06ed529238448773038601afb3cf278', 'Maximum');");
db_install_execute("0.8.8", "INSERT INTO `vdef` VALUES (2, 'e4872dda82092393d6459c831a50dc3b', 'Minimum');");
db_install_execute("0.8.8", "INSERT INTO `vdef` VALUES (3, '5ce1061a46bb62f36840c80412d2e629', 'Average');");
db_install_execute("0.8.8", "INSERT INTO `vdef` VALUES (4, '06bd3cbe802da6a0745ea5ba93af554a', 'Last (Current)');");
db_install_execute("0.8.8", "INSERT INTO `vdef` VALUES (5, '631c1b9086f3979d6dcf5c7a6946f104', 'First');");
db_install_execute("0.8.8", "INSERT INTO `vdef` VALUES (6, '6b5335843630b66f858ce6b7c61fc493', 'Total: Current Data Source');");
db_install_execute("0.8.8", "INSERT INTO `vdef` VALUES (7, 'c80d12b0f030af3574da68b28826cd39', '95th Percentage: Current Data Source');");
/* create new table VDEF_ITEMS */
db_install_execute("0.8.8", "CREATE TABLE vdef_items (
id mediumint(8) unsigned NOT NULL auto_increment,
hash varchar(32) NOT NULL default '',
vdef_id mediumint(8) unsigned NOT NULL default 0,
sequence mediumint(8) unsigned NOT NULL default 0,
type tinyint(2) NOT NULL default 0,
value varchar(150) NOT NULL default '',
PRIMARY KEY (id),
KEY vdef_id (vdef_id)
) TYPE=MyISAM;");
/* fill table VDEF */
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (1, '88d33bf9271ac2bdf490cf1784a342c1', 1, 1, 4, 'CURRENT_DATA_SOURCE');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (2, 'a307afab0c9b1779580039e3f7c4f6e5', 1, 2, 1, '1');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (3, '0945a96068bb57c80bfbd726cf1afa02', 2, 1, 4, 'CURRENT_DATA_SOURCE');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (4, '95a8df2eac60a89e8a8ca3ea3d019c44', 2, 2, 1, '2');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (5, 'cc2e1c47ec0b4f02eb13708cf6dac585', 3, 1, 4, 'CURRENT_DATA_SOURCE');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (6, 'a2fd796335b87d9ba54af6a855689507', 3, 2, 1, '3');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (7, 'a1d7974ee6018083a2053e0d0f7cb901', 4, 1, 4, 'CURRENT_DATA_SOURCE');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (8, '26fccba1c215439616bc1b83637ae7f3', 4, 2, 1, '5');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (9, 'a8993b265f4c5398f4a47c44b5b37a07', 5, 1, 4, 'CURRENT_DATA_SOURCE');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (10, '5a380d469d611719057c3695ce1e4eee', 5, 2, 1, '6');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (11, '65cfe546b17175fad41fcca98c057feb', 6, 1, 4, 'CURRENT_DATA_SOURCE');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (12, 'f330b5633c3517d7c62762cef091cc9e', 6, 2, 1, '7');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (13, 'f1bf2ecf54ca0565cf39c9c3f7e5394b', 7, 1, 4, 'CURRENT_DATA_SOURCE');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (14, '11a26f18feba3919be3af426670cba95', 7, 2, 6, '95');");
db_install_execute("0.8.8", "INSERT INTO `vdef_items` VALUES (15, 'e7ae90275bc1efada07c19ca3472d9db', 7, 3, 1, '8');");
# graph_templates_items: split LINEx into LINE and a line_width of x
db_install_execute("0.8.8", "ALTER TABLE graph_templates_item ADD COLUMN line_width DECIMAL(4,2) DEFAULT 0 AFTER graph_type_id");
db_install_execute("0.8.8", "UPDATE graph_templates_item SET `line_width`=1 WHERE `graph_type_id`=4"); # LINE1
db_install_execute("0.8.8", "UPDATE graph_templates_item SET `line_width`=2 WHERE `graph_type_id`=5"); # LINE2
db_install_execute("0.8.8", "UPDATE graph_templates_item SET `line_width`=3 WHERE `graph_type_id`=6"); # LINE3
# graph_templates_items: add DASHES and DASH-OFFSET
db_install_execute("0.8.8", "ALTER TABLE graph_templates_item ADD COLUMN dashes varchar(20) DEFAULT NULL AFTER line_width");
db_install_execute("0.8.8", "ALTER TABLE graph_templates_item ADD COLUMN dash_offset mediumint(4) DEFAULT NULL AFTER dashes");
# graph_templates_items: add TEXTALIGN
db_install_execute("0.8.8", "ALTER TABLE graph_templates_item ADD COLUMN textalign varchar(10) default NULL AFTER consolidation_function_id");
# graph_templates_items: add SHIFT
db_install_execute("0.8.8", "ALTER TABLE graph_templates_item ADD COLUMN shift char(2) default NULL AFTER vdef_id");
/* implement per device threads setting for spine */
db_install_execute("0.8.8", "ALTER TABLE device ADD COLUMN device_threads tinyint(2) unsigned NOT NULL default '1' AFTER max_oids");
db_install_execute("0.8.8", "ALTER TABLE device_template ADD COLUMN device_threads tinyint(2) unsigned NOT NULL default '1' AFTER max_oids");
/* new cdef's for background colorization */
$cdef_id = db_fetch_cell("SELECT id FROM cdef WHERE hash='2544acefc5fef30366c71336166ed141';");
if ($cdef_id == 0) {
db_install_execute("0.8.8", "INSERT INTO `cdef` VALUES(DEFAULT, '2544acefc5fef30366c71336166ed141', 'Time: Daytime')");
$cdef_id = db_fetch_cell("SELECT id FROM cdef WHERE hash='2544acefc5fef30366c71336166ed141';");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'ac0dea239ef3279c9b5ee04990fd4ec0', $cdef_id, 1, 1, '42')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '12f2bd71d5cbc078b9712c54d21c4f59', $cdef_id, 2, 6, '86400')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'bf35d7e5ae6df56398ea0f34a77311fc', $cdef_id, 3, 2, '5')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '31a9b3ff3b402f0446e6f6454b4d47c2', $cdef_id, 4, 4, 'TIME_SHIFT_START')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '996b718fc70353deb676e9037af9eadd', $cdef_id, 5, 1, '23')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '9c48bd2133670fd5158264ac25df6bb6', $cdef_id, 6, 1, '42')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '50c205e8bd5bb19b7fbee0ec2dee44cb', $cdef_id, 7, 6, '86400')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '14ee4ad2c7f91ab6406e1ecec6f4bcdc', $cdef_id, 8, 2, '5')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '38023f18060f2586e3504bbdd2634cc3', $cdef_id, 9, 4, 'TIME_SHIFT_END')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '1dbfee1b96a11492e58128ee8de93925', $cdef_id, 10, 1, '21')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '6979b0680858c8d153530d9390f6a4e9', $cdef_id, 11, 1, '37')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'f9d37c6480c3555c9d6d2d8910ef2da7', $cdef_id, 12, 1, '36')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '6c2604fd53780532c93c16d82c0337fd', $cdef_id, 13, 4, 'CURRENT_DATA_SOURCE')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'c2652379ba1c6523dc036e0a312536c4', $cdef_id, 14, 2, '3')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '63bf07a965b64fc41faa4bf01ae8a39d', $cdef_id, 15, 1, '29')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '2a9dea57a4f5d12cd0e2e66a31186a35', $cdef_id, 16, 1, '36')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '014839ebf8261c501d1da6c2c5217a0c', $cdef_id, 17, 4, 'CURRENT_DATA_SOURCE')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '01c946b79d68fad871e6e9437cba924f', $cdef_id, 18, 2, '3')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '4d0879e3c65c5af4e35d41a1631dcbe5', $cdef_id, 19, 1, '29')");
}
$cdef_id = db_fetch_cell("SELECT id FROM cdef WHERE hash='8bd388f585b624a7bbad97101a2b7ee9';");
if ($cdef_id == 0) {
db_install_execute("0.8.8", "INSERT INTO `cdef` VALUES(DEFAULT, '8bd388f585b624a7bbad97101a2b7ee9', 'Time: Nighttime')");
$cdef_id = db_fetch_cell("SELECT id FROM cdef WHERE hash='8bd388f585b624a7bbad97101a2b7ee9';");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '1c9452055499efaddded29c74ee21880', $cdef_id, 1, 1, '42')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '36af4d7c5a8acf09bda1a3a5f1409979', $cdef_id, 2, 6, '86400')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '74cf8897d5ada9da271c64e82a1384ac', $cdef_id, 3, 2, '5')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '053c5efacd6787b6e41ed109043ba256', $cdef_id, 4, 4, 'TIME_SHIFT_START')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'da39b6410ab37833842511f46182717d', $cdef_id, 5, 1, '21')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '652afbee7025a256b8dc3c49e75b27fc', $cdef_id, 6, 1, '37')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '26a63ba997e1f904c71bb7c9eb5e76e5', $cdef_id, 7, 1, '42')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '6f83ed61e0743176f03dd790f31521ea', $cdef_id, 8, 6, '86400')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '6b49d9dc72576a7ada160f0befc77c85', $cdef_id, 9, 2, '5')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '22f0dd9a5e0e189424ea29fe1383e29d', $cdef_id, 10, 4, 'TIME_SHIFT_END')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'd3f3a319e8fcfac10bd06fb247d236af', $cdef_id, 11, 1, '23')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '1cf7208bfa84c61f788f327500b712a6', $cdef_id, 12, 1, '37')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'c29025779a287d2f7b946e9ffbba3c24', $cdef_id, 13, 1, '36')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '690852ea78bf45796ef21947e27528be', $cdef_id, 14, 4, 'CURRENT_DATA_SOURCE')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '09061dcd9762280ffd3994c8274b19f8', $cdef_id, 15, 2, '3')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '60be0afe23bef9fdb7e6cabd9067eb32', $cdef_id, 16, 1, '29')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'f4a6609839d199ecb12c2f05b5d3a7b6', $cdef_id, 17, 1, '29')");
}
$cdef_id = db_fetch_cell("SELECT id FROM cdef WHERE hash='b4ef0a1c5e471dc6bae6a13ace5c57e7';");
if ($cdef_id == 0) {
db_install_execute("0.8.8", "INSERT INTO `cdef` VALUES(DEFAULT, 'b4ef0a1c5e471dc6bae6a13ace5c57e7', 'Time: Weekend')");
$cdef_id = db_fetch_cell("SELECT id FROM cdef WHERE hash='b4ef0a1c5e471dc6bae6a13ace5c57e7';");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'd4f93d57657e6c3ae2053a4a760a0c7b', $cdef_id, 1, 1, '42')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '00a793341980c41728c6ee665718001c', $cdef_id, 2, 6, '604800')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '0a7eaf7192e5e44a425f5e8986850190', $cdef_id, 3, 2, '5')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'ceb07e26bf15c561b12004c5e32d7f1f', $cdef_id, 4, 6, '172800')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '3a3bfafebd173fdbbd8c07d2e2dd661f', $cdef_id, 5, 1, '23')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '4c080ecaaa7260886ea148869d4d0456', $cdef_id, 6, 1, '42')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'bd57afcd9879e29e29bb796ba8d6188d', $cdef_id, 7, 6, '604800')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'cd14cd9adfbae04973a75b90880e7d64', $cdef_id, 8, 2, '5')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '3bed46dd43a64d54acc4f0723cff0bc7', $cdef_id, 9, 6, '345600')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '6fa62ee12bb8ba8936e39ea4303f92fd', $cdef_id, 10, 1, '21')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'f26848c08c2fb385126f90107494ce64', $cdef_id, 11, 1, '37')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'b8a5dde83327cac6705cdaa58300153b', $cdef_id, 12, 1, '36')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'f6aa118b35e269101ca3049cc4a323db', $cdef_id, 13, 4, 'CURRENT_DATA_SOURCE')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '967beb159b1ea744460ff3439ab205eb', $cdef_id, 14, 2, '3')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'f30028a71a1f4333703c70f8e499b03a', $cdef_id, 15, 1, '29')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '6888be191630a0964fdb9eaeb01cecaf', $cdef_id, 16, 1, '36')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '77c456204e43a9053c68b51750d5df75', $cdef_id, 17, 4, 'CURRENT_DATA_SOURCE')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, 'ce271b7a9809646a1fe4a7cd286fd98a', $cdef_id, 18, 2, '3')");
db_install_execute("0.8.8", "INSERT INTO `cdef_items` VALUES(DEFAULT, '8bcd193850b37953ffe940fdf2a26aa6', $cdef_id, 19, 1, '29')");
}
/* adjust GPRINTs
* here's the deal
* All GPRINTs following an CF=AVERAGE/MAX/MIN/LAST non-GPRINT have to be changed to CF=AVERAGE/MAX/MIN/LAST
* (this is called the "parent" CF)
* the graph_type_id has to be changed as well according to:
* old CF | old GPRINT | new CF | new GPRINT
* AVG | GPRINT | parent | GRPINT_AVG
* MAX | GPRINT | parent | GRPINT_MAX
* MIN | GPRINT | parent | GRPINT_MIN
* LAST | GPRINT | parent | GRPINT_LAST
*/
# first, handle templated graphs
$graph_templates = db_fetch_assoc("SELECT id FROM graph_templates ORDER BY id ASC");
if (sizeof($graph_templates)) {
foreach ($graph_templates as $template) {
$graph_template_items = db_fetch_assoc("SELECT * " .
"FROM graph_templates_item " .
"WHERE local_graph_id = 0 " .
"AND graph_template_id = " . $template["id"] . " " .
"ORDER BY graph_template_id ASC, sequence ASC");
update_pre_088_graph_items($graph_template_items);
}
}
# now handle non-templated graphs
$graphs = db_fetch_assoc("SELECT id FROM graph_local WHERE graph_template_id = 0 ORDER BY id ASC");
if (sizeof($graphs)) {
foreach ($graphs as $graph) {
$graph_items = db_fetch_assoc("SELECT * " .
"FROM graph_templates_item " .
"WHERE local_graph_id = " . $graph["id"] . " " .
"AND graph_template_id = 0 " .
"ORDER BY local_graph_id ASC, sequence ASC");
update_pre_088_graph_items($graph_items);
}
}
/* change the name and description for data input method "Unix - Get Load Average" from 10min to 15min */
$dim_id = db_fetch_cell("SELECT id FROM `data_input` WHERE input_string LIKE '%%scripts/loadavg_multi.pl%%' LIMIT 0,1");
$field_id = db_fetch_cell("SELECT id FROM `data_input_fields` WHERE data_name LIKE '%%10min%%' AND data_input_id =" . $dim_id . " LIMIT 0,1");
db_install_execute("0.8.8", "UPDATE data_input_fields SET `name`='15 Minute Average', `data_name`='15min' WHERE `id`=" . $field_id);
}
function upgrade_to_0_8_6()
{
include "../lib/data_query.php";
include "../lib/tree.php";
include "../lib/import.php";
include "../lib/poller.php";
db_install_execute("0.8.6", "DROP TABLE `snmp_query_field`;");
db_install_execute("0.8.6", "DROP TABLE `data_input_data_cache`;");
db_install_execute("0.8.6", "DROP TABLE `data_input_data_fcache`;");
/* distributed poller support */
db_install_execute("0.8.6", "CREATE TABLE `poller` (`id` smallint(5) unsigned NOT NULL auto_increment, `hostname` varchar(250) NOT NULL default '', `ip_address` int(11) unsigned NOT NULL default '0', `last_update` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`)) TYPE=MyISAM;");
db_install_execute("0.8.6", "CREATE TABLE `poller_command` (`poller_id` smallint(5) unsigned NOT NULL default '0', `time` datetime NOT NULL default '0000-00-00 00:00:00', `action` tinyint(3) unsigned NOT NULL default '0', `command` varchar(200) NOT NULL default '', PRIMARY KEY (`poller_id`,`action`,`command`)) TYPE=MyISAM;");
db_install_execute("0.8.6", "CREATE TABLE `poller_item` (`local_data_id` mediumint(8) unsigned NOT NULL default '0', `poller_id` smallint(5) unsigned NOT NULL default '0', `host_id` mediumint(8) NOT NULL default '0', `action` tinyint(2) unsigned NOT NULL default '1', `hostname` varchar(250) NOT NULL default '', `snmp_community` varchar(100) NOT NULL default '', `snmp_version` tinyint(1) unsigned NOT NULL default '0', `snmp_username` varchar(50) NOT NULL default '', `snmp_password` varchar(50) NOT NULL default '', `snmp_port` mediumint(5) unsigned NOT NULL default '161', `snmp_timeout` mediumint(8) unsigned NOT NULL default '0', `rrd_name` varchar(19) NOT NULL default '', `rrd_path` varchar(255) NOT NULL default '', `rrd_num` tinyint(2) unsigned NOT NULL default '0', `arg1` varchar(255) default NULL, `arg2` varchar(255) default NULL, `arg3` varchar(255) default NULL, PRIMARY KEY (`local_data_id`,`rrd_name`), KEY `local_data_id` (`local_data_id`), KEY `host_id` (`host_id`)) TYPE=MyISAM;");
db_install_execute("0.8.6", "CREATE TABLE `poller_output` (`local_data_id` mediumint(8) unsigned NOT NULL default '0', `rrd_name` varchar(19) NOT NULL default '', `time` datetime NOT NULL default '0000-00-00 00:00:00', `output` text NOT NULL, PRIMARY KEY (`local_data_id`,`rrd_name`,`time`)) TYPE=MyISAM;");
db_install_execute("0.8.6", "CREATE TABLE `poller_reindex` (`host_id` mediumint(8) unsigned NOT NULL default '0', `data_query_id` mediumint(8) unsigned NOT NULL default '0', `action` tinyint(3) unsigned NOT NULL default '0', `op` char(1) NOT NULL default '', `assert_value` varchar(100) NOT NULL default '', `arg1` varchar(100) NOT NULL default '', PRIMARY KEY (`host_id`,`data_query_id`,`arg1`)) TYPE=MyISAM;");
db_install_execute("0.8.6", "CREATE TABLE `poller_time` (`id` mediumint(8) unsigned NOT NULL auto_increment, `poller_id` smallint(5) unsigned NOT NULL default '0', `start_time` datetime NOT NULL default '0000-00-00 00:00:00', `end_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`)) TYPE=MyISAM;");
db_install_execute("0.8.6", "ALTER TABLE `graph_tree_items` ADD `host_grouping_type` TINYINT( 3 ) UNSIGNED DEFAULT '1' NOT NULL, ADD `sort_children_type` TINYINT( 3 ) UNSIGNED DEFAULT '1' NOT NULL;");
db_install_execute("0.8.6", "ALTER TABLE `host_snmp_query` ADD `sort_field` VARCHAR( 50 ) NOT NULL, ADD `title_format` VARCHAR( 50 ) NOT NULL, ADD `reindex_method` TINYINT( 3 ) UNSIGNED DEFAULT '1' NOT NULL;");
db_install_execute("0.8.6", "ALTER TABLE `graph_tree` CHANGE `user_id` `sort_type` TINYINT( 3 ) UNSIGNED DEFAULT '1' NOT NULL;");
db_install_execute("0.8.6", "ALTER TABLE `graph_tree_items` CHANGE `order_key` `order_key` VARCHAR( 100 ) DEFAULT '0' NOT NULL;");
db_install_execute("0.8.6", "ALTER TABLE `host` ADD `status_event_count` mediumint(8) unsigned NOT NULL default '0', ADD `status_fail_date` datetime NOT NULL default '0000-00-00 00:00:00', ADD `status_rec_date` datetime NOT NULL default '0000-00-00 00:00:00', ADD `status_last_error` varchar(50) default '', ADD `min_time` decimal(7,5) default '9.99999', ADD `max_time` decimal(7,5) default '0.00000', ADD `cur_time` decimal(7,5) default '0.00000', ADD `avg_time` decimal(7,5) default '0.00000', ADD `total_polls` int(12) unsigned default '0', ADD `failed_polls` int(12) unsigned default '0', ADD `availability` decimal(7,5) default '100.000' NOT NULL;");
db_install_execute("0.8.6", "UPDATE snmp_query_graph_rrd_sv set text = REPLACE(text,' (In)','') where snmp_query_graph_id = 2;");
db_install_execute("0.8.6", "UPDATE graph_tree set sort_type = '1';");
/* update the sort cache */
$host_snmp_query = db_fetch_assoc("select host_id,snmp_query_id from host_snmp_query");
if (sizeof($host_snmp_query) > 0) {
foreach ($host_snmp_query as $item) {
update_data_query_sort_cache($item["host_id"], $item["snmp_query_id"]);
update_reindex_cache($item["host_id"], $item["snmp_query_id"]);
}
}
/* script query data input methods */
$xml_data = "<cacti>\n\t\t\t<hash_030003332111d8b54ac8ce939af87a7eac0c06>\n\t\t\t\t<name>Get Script Server Data (Indexed)</name>\n\t\t\t\t<type_id>6</type_id>\n\t\t\t\t<input_string></input_string>\n\t\t\t\t<fields>\n\t\t\t\t\t<hash_070003172b4b0eacee4948c6479f587b62e512>\n\t\t\t\t\t\t<name>Index Type</name>\n\t\t\t\t\t\t<update_rra></update_rra>\n\t\t\t\t\t\t<regexp_match></regexp_match>\n\t\t\t\t\t\t<allow_nulls></allow_nulls>\n\t\t\t\t\t\t<type_code>index_type</type_code>\n\t\t\t\t\t\t<input_output>in</input_output>\n\t\t\t\t\t\t<data_name>index_type</data_name>\n\t\t\t\t\t</hash_070003172b4b0eacee4948c6479f587b62e512>\n\t\t\t\t\t<hash_07000330fb5d5bcf3d66bb5abe88596f357c26>\n\t\t\t\t\t\t<name>Index Value</name>\n\t\t\t\t\t\t<update_rra></update_rra>\n\t\t\t\t\t\t<regexp_match></regexp_match>\n\t\t\t\t\t\t<allow_nulls></allow_nulls>\n\t\t\t\t\t\t<type_code>index_value</type_code>\n\t\t\t\t\t\t<input_output>in</input_output>\n\t\t\t\t\t\t<data_name>index_value</data_name>\n\t\t\t\t\t</hash_07000330fb5d5bcf3d66bb5abe88596f357c26>\n\t\t\t\t\t<hash_07000331112c85ae4ff821d3b288336288818c>\n\t\t\t\t\t\t<name>Output Type ID</name>\n\t\t\t\t\t\t<update_rra></update_rra>\n\t\t\t\t\t\t<regexp_match></regexp_match>\n\t\t\t\t\t\t<allow_nulls></allow_nulls>\n\t\t\t\t\t\t<type_code>output_type</type_code>\n\t\t\t\t\t\t<input_output>in</input_output>\n\t\t\t\t\t\t<data_name>output_type</data_name>\n\t\t\t\t\t</hash_07000331112c85ae4ff821d3b288336288818c>\n\t\t\t\t\t<hash_0700035be8fa85472d89c621790b43510b5043>\n\t\t\t\t\t\t<name>Output Value</name>\n\t\t\t\t\t\t<update_rra>on</update_rra>\n\t\t\t\t\t\t<regexp_match></regexp_match>\n\t\t\t\t\t\t<allow_nulls></allow_nulls>\n\t\t\t\t\t\t<type_code></type_code>\n\t\t\t\t\t\t<input_output>out</input_output>\n\t\t\t\t\t\t<data_name>output</data_name>\n\t\t\t\t\t</hash_0700035be8fa85472d89c621790b43510b5043>\n\t\t\t\t</fields>\n\t\t\t</hash_030003332111d8b54ac8ce939af87a7eac0c06>\n\t\t</cacti>";
import_xml_data($xml_data);
/* update trees to three characters per tier */
$trees = db_fetch_assoc("select id from graph_tree");
if (sizeof($trees) > 0) {
foreach ($trees as $tree) {
$tree_items = db_fetch_assoc("select\n\t\t\t\tgraph_tree_items.id,\n\t\t\t\tgraph_tree_items.order_key\n\t\t\t\tfrom graph_tree_items\n\t\t\t\twhere graph_tree_items.graph_tree_id='" . $tree["id"] . "'\n\t\t\t\torder by graph_tree_items.order_key");
if (sizeof($tree_items) > 0) {
$_tier = 0;
/* only do the upgrade once */
if ($tree_items[0]["order_key"] == "001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000") {
return;
}
foreach ($tree_items as $tree_item) {
$tier = tree_tier($tree_item["order_key"], 2);
/* back off */
if ($tier < $_tier) {
for ($i = $_tier; $i > $tier; $i--) {
$tier_counter[$i] = 0;
}
}
/* we key tier==0 off of '1' and tier>0 off of '0' */
if (!isset($tier_counter[$tier])) {
$tier_counter[$tier] = 1;
} else {
$tier_counter[$tier]++;
}
$search_key = preg_replace("/0+\$/", "", $tree_item["order_key"]);
if (strlen($search_key) % 2 != 0) {
$search_key .= "0";
}
$new_search_key = "";
for ($i = 1; $i < $tier; $i++) {
$new_search_key .= str_pad(strval($tier_counter[$i]), 3, '0', STR_PAD_LEFT);
}
/* build the new order key string */
$key = str_pad($new_search_key . str_pad(strval($tier_counter[$tier]), 3, '0', STR_PAD_LEFT), 90, '0', STR_PAD_RIGHT);
db_execute("update graph_tree_items set order_key='{$key}' where id=" . $tree_item["id"]);
$_tier = $tier;
}
}
}
}
}
function upgrade_to_0_8_7()
{
// ALTER TABLE `data_input_fields` DROP `sequence`;
/* Format bug from 0.8.6x */
db_install_execute("0.8.7", "ALTER TABLE `host` CHANGE `min_time` `min_time` decimal(9,5) default '99999.99', CHANGE `max_time` `max_time` decimal(9,5) default '0.00000', CHANGE `cur_time` `cur_time` decimal(9,5) default '0.00000', CHANGE `avg_time` `avg_time` decimal(9,5) default '0.00000';");
/* Host Specific Availability Checking Feature */
db_install_execute("0.8.7", "ALTER TABLE `host` ADD `poller_id` smallint(5) unsigned NOT NULL default '1' AFTER `id`;");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD `availability_method` smallint(5) unsigned NOT NULL default '1' AFTER `snmp_timeout`;");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD `ping_method` smallint(5) unsigned default '' AFTER `availability_method`;");
db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD `availability_method` smallint(5) unsigned NOT NULL default '1' AFTER `snmp_timeout`;");
db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD `ping_method` smallint(5) unsigned default '' AFTER `availability_method`;");
/* Start the Creation of Reserved/Hidden Items in Tables */
db_install_execute("0.8.7", "ALTER TABLE `data_input` ADD `reserved` tinyint unsigned NOT NULL default '0' AFTER `id`;");
db_install_execute("0.8.7", "UPDATE `data_input` set reserved = '1' where hash = '3eb92bb845b9660a7445cf9740726522' or hash = 'bf566c869ac6443b0c75d1c32b5a350e' or hash = '80e9e4c4191a5da189ae26d0e237f015' or hash = '332111d8b54ac8ce939af87a7eac0c06';");
/* Multi Poller Architecture Changes */
db_install_execute("0.8.7", "ALTER TABLE `poller` ADD `active` varchar(5) default 'On' AFTER `id`;");
db_install_execute("0.8.7", "ALTER TABLE `poller` ADD `run_state` varchar(20) default 'Wait' AFTER `id`;");
db_install_execute("0.8.7", "ALTER TABLE `poller` CHANGE `ip_address` `name` varchar(150) NOT NULL default 'Description';");
db_install_execute("0.8.7", "ALTER TABLE `poller` ADD `status_event_count` mediumint(8) NOT NULL default '0', ADD `status_fail_date` datetime NOT NULL default '0000-00-00 00:00:00', ADD `status_rec_date` datetime NOT NULL default '0000-00-00 00:00:00', ADD `status_last_error` varchar(50) NOT NULL default '';");
db_install_execute("0.8.7", "ALTER TABLE `poller` ADD `min_time` DECIMAL(9,5) NOT NULL default '9999.99', ADD `max_time` DECIMAL(9,5) NOT NULL default '0.00', ADD `cur_time` DECIMAL(9,5) NOT NULL default '0.00', ADD `avg_time` DECIMAL(9,5) NOT NULL default '0.00';");
db_install_execute("0.8.7", "ALTER TABLE `poller` ADD `total_polls` BIGINT(20) NOT NULL default '0', ADD `failed_polls` BIGINT(20) NOT NULL default '0.00', ADD `availability` DECIMAL(7,5) NOT NULL default '100.00';");
/* New Graph Template Options */
db_install_execute("0.8.7", "ALTER TABLE `graph_templates_graph` ADD `t_x_grid` char(2) default '0' AFTER `width`, ADD `x_grid` varchar(50) default NULL AFTER `t_x_grid`;");
db_install_execute("0.8.7", "ALTER TABLE `graph_templates_graph` ADD `t_y_grid` char(2) default '0' AFTER `x_grid`, ADD `y_grid` varchar(50) default NULL AFTER `t_y_grid`;");
db_install_execute("0.8.7", "ALTER TABLE `graph_templates_graph` ADD `t_y_grid_alt` char(2) default '0' AFTER `y_grid`, ADD `y_grid_alt` char(2) default NULL AFTER `t_y_grid_alt`;");
db_install_execute("0.8.7", "ALTER TABLE `graph_templates_graph` ADD `t_no_minor` char(2) default '0' AFTER `y_grid_alt`, ADD `no_minor` char(2) default NULL AFTER `t_no_minor`;");
db_install_execute("0.8.7", "ALTER TABLE `graph_templates_graph` ADD `t_unit_length` char(2) default '0' AFTER `unit_value`, ADD `unit_length` varchar(5) default '' AFTER `t_unit_length`;");
/* snmpv3 Support Added */
db_install_execute("0.8.7", "ALTER TABLE `host` CHANGE `snmp_username` `snmpv3_auth_username` varchar(50), CHANGE `snmp_password` `snmpv3_auth_password` varchar(50);");
db_install_execute("0.8.7", "ALTER TABLE `host` ADD `snmpv3_auth_protocol` varchar(10) AFTER `snmpv3_auth_password`, ADD `snmpv3_priv_passphrase` varchar(200) AFTER `snmpv3_auth_protocol`, ADD `snmpv3_priv_protocol` varchar(10) AFTER `snmpv3_priv_passphrase`;");
db_install_execute("0.8.7", "ALTER TABLE `poller_item` CHANGE `snmp_username` `snmpv3_auth_username` varchar(50), CHANGE `snmp_password` `snmpv3_auth_password` varchar(50);");
db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD `snmpv3_auth_protocol` varchar(10) AFTER `snmpv3_auth_password`, ADD `snmpv3_priv_passphrase` varchar(200) AFTER `snmpv3_auth_protocol`, ADD `snmpv3_priv_protocol` varchar(10) AFTER `snmpv3_priv_passphrase`;");
db_install_execute("0.8.7", "UPDATE `data_input_fields` SET `name` = 'SNMP Authorization Password (v3)' WHERE `name` = 'SNMP Password';");
db_install_execute("0.8.7", "UPDATE `data_input_fields` SET `name` = 'SNMP Authorization Username (v3)' WHERE `name` = 'SNMP Username';");
db_install_execute("0.8.7", "UPDATE `data_input_fields` SET `data_name` = 'snmpv3_auth_username' WHERE `data_name` = 'snmp_username';");
db_install_execute("0.8.7", "UPDATE `data_input_fields` SET `data_name` = 'snmpv3_auth_password' WHERE `data_name` = 'snmp_password';");
db_install_execute("0.8.7", "UPDATE `data_input_fields` SET `type_code` = 'snmpv3_auth_username' WHERE `type_code` = 'snmp_username';");
db_install_execute("0.8.7", "UPDATE `data_input_fields` SET `type_code` = 'snmpv3_auth_password' WHERE `type_code` = 'snmp_password';");
db_install_execute("0.8.7", "INSERT INTO `data_input_fields` (hash,data_input_id,name,data_name,input_output,update_rra,sequence,type_code,regexp_match,allow_nulls) VALUES ('0979c0fb287db7db9fa9adddbb399aa3','1','SNMP Authorization Protocol (v3)','snmpv3_auth_protocol','in','','0','snmpv3_auth_protocol','','on');");
db_install_execute("0.8.7", "INSERT INTO `data_input_fields` (hash,data_input_id,name,data_name,input_output,update_rra,sequence,type_code,regexp_match,allow_nulls) VALUES ('a5dfa3c1fe626393994a4f28d83d0c63','1','SNMP Privacy Passphrase (v3)','snmpv3_priv_passphrase','in','','0','snmpv3_priv_passphrase','','on');");
db_install_execute("0.8.7", "INSERT INTO `data_input_fields` (hash,data_input_id,name,data_name,input_output,update_rra,sequence,type_code,regexp_match,allow_nulls) VALUES ('f986f1acfd61582c3bf035ecd985b49f','1','SNMP Privacy Protocol (v3)','snmpv3_priv_protocol','in','','0','snmpv3_priv_protocol','','on');");
db_install_execute("0.8.7", "INSERT INTO `data_input_fields` (hash,data_input_id,name,data_name,input_output,update_rra,sequence,type_code,regexp_match,allow_nulls) VALUES ('aa9632293ac20ecd87f5e4691fc244f6','2','SNMP Authorization Protocol (v3)','snmpv3_auth_protocol','in','','0','snmpv3_auth_protocol','','on');");
db_install_execute("0.8.7", "INSERT INTO `data_input_fields` (hash,data_input_id,name,data_name,input_output,update_rra,sequence,type_code,regexp_match,allow_nulls) VALUES ('b9a06e0ff7c042506a0adf013db5a533','2','SNMP Privacy Passphrase (v3)','snmpv3_priv_passphrase','in','','0','snmpv3_priv_passphrase','','on');");
db_install_execute("0.8.7", "INSERT INTO `data_input_fields` (hash,data_input_id,name,data_name,input_output,update_rra,sequence,type_code,regexp_match,allow_nulls) VALUES ('7c3011fb886b6345ed761a173dffd120','2','SNMP Privacy Protocol (v3)','snmpv3_priv_protocol','in','','0','snmpv3_priv_protocol','','on');");
/* Convert to new authentication system */
db_install_execute("0.8.7", "ALTER TABLE `user_auth` ADD `enabled` tinyint(1) unsigned NOT NULL default '1', ADD `created` datetime NOT NULL, ADD `password_expire_length` int(4) unsigned NOT NULL default '0', ADD `password_change_last` datetime NOT NULL;");
db_install_execute("0.8.7", "UPDATE `user_auth` SET `created` = NOW() WHERE `created` = '0000-00-00 00:00:00';");
if (!sizeof(db_fetch_cell("SELECT `value` FROM `settings` WHERE `name` = 'auth_method';"))) {
if (db_fetch_cell("SELECT `value` FROM `settings` WHERE `name` = 'global_auth';") == "on") {
if (db_fetch_cell("SELECT `value` FROM `settings` WHERE `name` = 'ldap_enable';") == "on") {
db_install_execute("0.8.7", "INSERT INTO settings VALUES ('auth_method','3');");
} else {
db_install_execute("0.8.7", "INSERT INTO settings VALUES ('auth_method','1');");
}
} else {
db_install_execute("0.8.7", "INSERT INTO settings VALUES ('auth_method','0');");
}
}
db_install_execute("0.8.7", "REPLACE INTO `user_auth_realm` VALUES (18,1);");
db_install_execute("0.8.7", "REPLACE INTO `user_auth_realm` VALUES (19,1);");
db_install_execute("0.8.7", "DELETE FROM `settings` WHERE name = 'global_auth';");
db_install_execute("0.8.7", "DELETE FROM `settings` WHERE name = 'ldap_enabled';");
db_install_execute("0.8.7", "UPDATE `settings` SET name = 'user_template' WHERE name = 'ldap_template';");
db_install_execute("0.8.7", "ALTER TABLE `user_auth` ADD `current_theme` varchar(25) NOT NULL default 'default',ADD `email_address_primary` varchar(255) NOT NULL default '',ADD `email_address_secondary` varchar(255) NOT NULL default '';");
db_install_execute("0.8.7", "ALTER TABLE `user_auth` ADD `last_login` datetime NOT NULL default '0000-00-00 00:00:00' ,ADD `last_login_ip` varchar(15) NOT NULL default '0.0.0.0';");
/* New Logging table */
db_install_execute("0.8.7", "CREATE TABLE `log` ( `id` bigint(20) unsigned NOT NULL auto_increment, `logdate` datetime NOT NULL default '0000-00-00 00:00:00', `facility` tinyint(1) unsigned NOT NULL default '0', `severity` int(1) NOT NULL default '0', `poller_id` smallint(5) unsigned NOT NULL default '0', `host_id` mediumint(8) unsigned NOT NULL default '0', `user_id` mediumint(8) unsigned NOT NULL default '0', `username` varchar(50) NOT NULL default 'system', `source` varchar(50) NOT NULL default 'localhost', `plugin` varchar(30) NOT NULL default 'N/A', `message` text NOT NULL, PRIMARY KEY (`id`), KEY `facility` (`facility`), KEY `severity` (`severity`), KEY `host_id` (`host_id`), KEY `poller_id` (`poller_id`), KEY `user_id` (`user_id`), KEY `username` (`username`), KEY `logdate` (`logdate`)) TYPE=MyISAM");
}
function db_add_column($table, $column, $log = TRUE, $db_conn = FALSE)
{
$result = db_fetch_assoc('show columns from `' . $table . '`');
$columns = array();
foreach ($result as $index => $arr) {
foreach ($arr as $t) {
$columns[] = $t;
}
}
if (isset($column['name']) && !in_array($column['name'], $columns)) {
$sql = 'ALTER TABLE `' . $table . '` ADD `' . $column['name'] . '`';
if (isset($column['type'])) {
$sql .= ' ' . $column['type'];
}
if (isset($column['unsigned'])) {
$sql .= ' unsigned';
}
if (isset($column['NULL']) && $column['NULL'] == false) {
$sql .= ' NOT NULL';
}
if (isset($column['NULL']) && $column['NULL'] == true && !isset($column['default'])) {
$sql .= ' default NULL';
}
if (isset($column['default'])) {
$sql .= ' default ' . (is_numeric($column['default']) ? $column['default'] : "'" . $column['default'] . "'");
}
if (isset($column['auto_increment'])) {
$sql .= ' auto_increment';
}
if (isset($column['after'])) {
$sql .= ' AFTER ' . $column['after'];
}
return db_install_execute($sql, $log, $db_conn);
}
return true;
}
function upgrade_to_0_8_4() {
db_install_execute("0.8.4", "DROP TABLE `user_realm`;");
db_install_execute("0.8.4", "DROP TABLE `user_realm_filename`;");
db_install_execute("0.8.4", "DROP TABLE `host_template_data_sv`;");
db_install_execute("0.8.4", "DROP TABLE `host_template_graph_sv`;");
db_install_execute("0.8.4", "UPDATE `host` set hostname=management_ip;");
db_install_execute("0.8.4", "UPDATE `data_input_fields` set type_code='hostname' where type_code='management_ip';");
db_install_execute("0.8.4", "ALTER TABLE `data_input_data_cache` CHANGE `management_ip` `hostname` VARCHAR( 250 ) NOT NULL, ADD `snmp_port` MEDIUMINT( 5 ) UNSIGNED DEFAULT '161' NOT NULL AFTER `snmp_password`, ADD `snmp_timeout` MEDIUMINT( 8 ) UNSIGNED NOT NULL AFTER `snmp_port`;");
db_install_execute("0.8.4", "ALTER TABLE `host` ADD `snmp_port` MEDIUMINT( 5 ) UNSIGNED DEFAULT '161' NOT NULL AFTER `snmp_password`, ADD `snmp_timeout` MEDIUMINT( 8 ) UNSIGNED DEFAULT '500' NOT NULL AFTER `snmp_port`, DROP `management_ip`;");
db_install_execute("0.8.4", "ALTER TABLE `data_input` DROP `output_string`;");
db_install_execute("0.8.4", "ALTER TABLE `host_snmp_cache` DROP PRIMARY KEY;");
db_install_execute("0.8.4", "ALTER TABLE `host_snmp_cache` ADD PRIMARY KEY ( `host_id` , `snmp_query_id` , `field_name` , `snmp_index` );");
/* hash columns for xml export/import code */
db_install_execute("0.8.4", "ALTER TABLE `data_input_fields` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `data_template_rrd` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `graph_template_input` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `graph_templates_item` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `host_template` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `snmp_query_graph` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `snmp_query_graph_rrd_sv` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `snmp_query_graph_sv` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `cdef_items` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `cdef` ADD `hash` CHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `data_input` ADD `hash` CHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `data_template` ADD `hash` CHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `graph_templates` ADD `hash` CHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `graph_templates_gprint` ADD `hash` CHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `snmp_query` ADD `hash` CHAR( 32 ) NOT NULL AFTER `id`;");
db_install_execute("0.8.4", "ALTER TABLE `rra` ADD `hash` VARCHAR( 32 ) NOT NULL AFTER `id`;");
/* new realms */
$users = db_fetch_assoc("select id from user_auth");
if (sizeof($users) > 0) {
foreach ($users as $user) {
if (sizeof(db_fetch_assoc("select realm_id from user_auth_realm where user_id=" . $user["id"])) == 13) {
db_install_execute("0.8.4", "insert into user_auth_realm (user_id,realm_id) values (" . $user["id"] . ",4)");
db_install_execute("0.8.4", "insert into user_auth_realm (user_id,realm_id) values (" . $user["id"] . ",16)");
db_install_execute("0.8.4", "insert into user_auth_realm (user_id,realm_id) values (" . $user["id"] . ",17)");
}
}
}
/* there are a LOT of hashes to set */
db_execute("update cdef set hash='73f95f8b77b5508157d64047342c421e' where id=2;");
db_execute("update cdef_items set hash='9bbf6b792507bb9bb17d2af0970f9be9' where id=7;");
db_execute("update cdef_items set hash='a4b8eb2c3bf4920a3ef571a7a004be53' where id=9;");
db_execute("update cdef_items set hash='caa4e023ac2d7b1c4b4c8c4adfd55dfe' where id=8;");
db_execute("update cdef set hash='3d352eed9fa8f7b2791205b3273708c7' where id=3;");
db_execute("update cdef_items set hash='c888c9fe6b62c26c4bfe23e18991731d' where id=10;");
db_execute("update cdef_items set hash='1e1d0b29a94e08b648c8f053715442a0' where id=11;");
db_execute("update cdef_items set hash='4355c197998c7f8b285be7821ddc6da4' where id=12;");
db_execute("update cdef set hash='e961cc8ec04fda6ed4981cf5ad501aa5' where id=4;");
db_execute("update cdef_items set hash='40bb7a1143b0f2e2efca14eb356236de' where id=13;");
db_execute("update cdef_items set hash='42686ea0925c0220924b7d333599cd67' where id=14;");
db_execute("update cdef_items set hash='faf1b148b2c0e0527362ed5b8ca1d351' where id=15;");
db_execute("update cdef set hash='f1ac79f05f255c02f914c920f1038c54' where id=12;");
db_execute("update cdef_items set hash='0ef6b8a42dc83b4e43e437960fccd2ea' where id=16;");
db_execute("update cdef set hash='634a23af5e78af0964e8d33b1a4ed26b' where id=14;");
db_execute("update cdef_items set hash='86370cfa0008fe8c56b28be80ee39a40' where id=18;");
db_execute("update cdef_items set hash='9a35cc60d47691af37f6fddf02064e20' where id=19;");
db_execute("update cdef_items set hash='5d7a7941ec0440b257e5598a27dd1688' where id=20;");
db_execute("update cdef set hash='068984b5ccdfd2048869efae5166f722' where id=15;");
db_execute("update cdef_items set hash='44fd595c60539ff0f5817731d9f43a85' where id=21;");
db_execute("update cdef_items set hash='aa38be265e5ac31783e57ce6f9314e9a' where id=22;");
db_execute("update cdef_items set hash='204423d4b2598f1f7252eea19458345c' where id=23;");
db_execute("update graph_templates_gprint set hash='e9c43831e54eca8069317a2ce8c6f751' where id=2;");
db_execute("update graph_templates_gprint set hash='19414480d6897c8731c7dc6c5310653e' where id=3;");
db_execute("update graph_templates_gprint set hash='304a778405392f878a6db435afffc1e9' where id=4;");
db_execute("update data_input set hash='3eb92bb845b9660a7445cf9740726522' where id=1;");
db_execute("update data_input_fields set hash='92f5906c8dc0f964b41f4253df582c38' where id=1;");
db_execute("update data_input_fields set hash='32285d5bf16e56c478f5e83f32cda9ef' where id=2;");
db_execute("update data_input_fields set hash='ad14ac90641aed388139f6ba86a2e48b' where id=3;");
db_execute("update data_input_fields set hash='9c55a74bd571b4f00a96fd4b793278c6' where id=4;");
db_execute("update data_input_fields set hash='012ccb1d3687d3edb29c002ea66e72da' where id=5;");
db_execute("update data_input_fields set hash='4276a5ec6e3fe33995129041b1909762' where id=6;");
db_execute("update data_input set hash='bf566c869ac6443b0c75d1c32b5a350e' where id=2;");
db_execute("update data_input_fields set hash='617cdc8a230615e59f06f361ef6e7728' where id=7;");
db_execute("update data_input_fields set hash='acb449d1451e8a2a655c2c99d31142c7' where id=8;");
db_execute("update data_input_fields set hash='f4facc5e2ca7ebee621f09bc6d9fc792' where id=9;");
db_execute("update data_input_fields set hash='1cc1493a6781af2c478fa4de971531cf' where id=10;");
db_execute("update data_input_fields set hash='b5c23f246559df38662c255f4aa21d6b' where id=11;");
db_execute("update data_input_fields set hash='6027a919c7c7731fbe095b6f53ab127b' where id=12;");
db_execute("update data_input_fields set hash='cbbe5c1ddfb264a6e5d509ce1c78c95f' where id=13;");
db_execute("update data_input_fields set hash='e6deda7be0f391399c5130e7c4a48b28' where id=14;");
db_execute("update data_input set hash='274f4685461170b9eb1b98d22567ab5e' where id=3;");
db_execute("update data_input_fields set hash='edfd72783ad02df128ff82fc9324b4b9' where id=15;");
db_execute("update data_input_fields set hash='8b75fb61d288f0b5fc0bd3056af3689b' where id=16;");
db_execute("update data_input set hash='95ed0993eb3095f9920d431ac80f4231' where id=4;");
db_execute("update data_input_fields set hash='363588d49b263d30aecb683c52774f39' where id=17;");
db_execute("update data_input_fields set hash='ad139a9e1d69881da36fca07889abf58' where id=18;");
db_execute("update data_input_fields set hash='5db9fee64824c08258c7ff6f8bc53337' where id=19;");
db_execute("update data_input set hash='79a284e136bb6b061c6f96ec219ac448' where id=5;");
db_execute("update data_input_fields set hash='c0cfd0beae5e79927c5a360076706820' where id=20;");
db_execute("update data_input_fields set hash='52c58ad414d9a2a83b00a7a51be75a53' where id=21;");
db_execute("update data_input set hash='362e6d4768937c4f899dd21b91ef0ff8' where id=6;");
db_execute("update data_input_fields set hash='05eb5d710f0814871b8515845521f8d7' where id=22;");
db_execute("update data_input_fields set hash='86cb1cbfde66279dbc7f1144f43a3219' where id=23;");
db_execute("update data_input set hash='a637359e0a4287ba43048a5fdf202066' where id=7;");
db_execute("update data_input_fields set hash='d5a8dd5fbe6a5af11667c0039af41386' where id=24;");
db_execute("update data_input set hash='47d6bfe8be57a45171afd678920bd399' where id=8;");
db_execute("update data_input_fields set hash='8848cdcae831595951a3f6af04eec93b' where id=25;");
db_execute("update data_input_fields set hash='3d1288d33008430ce354e8b9c162f7ff' where id=26;");
db_execute("update data_input set hash='cc948e4de13f32b6aea45abaadd287a3' where id=9;");
db_execute("update data_input_fields set hash='c6af570bb2ed9c84abf32033702e2860' where id=27;");
db_execute("update data_input_fields set hash='f9389860f5c5340c9b27fca0b4ee5e71' where id=28;");
db_execute("update data_input set hash='8bd153aeb06e3ff89efc73f35849a7a0' where id=10;");
db_execute("update data_input_fields set hash='5fbadb91ad66f203463c1187fe7bd9d5' where id=29;");
db_execute("update data_input_fields set hash='6ac4330d123c69067d36a933d105e89a' where id=30;");
db_execute("update data_input set hash='80e9e4c4191a5da189ae26d0e237f015' where id=11;");
db_execute("update data_input_fields set hash='d39556ecad6166701bfb0e28c5a11108' where id=31;");
db_execute("update data_input_fields set hash='3b7caa46eb809fc238de6ef18b6e10d5' where id=32;");
db_execute("update data_input_fields set hash='74af2e42dc12956c4817c2ef5d9983f9' where id=33;");
db_execute("update data_input_fields set hash='8ae57f09f787656bf4ac541e8bd12537' where id=34;");
db_execute("update data_template set hash='c8a8f50f5f4a465368222594c5709ede' where id=3;");
db_execute("update data_template_rrd set hash='2d53f9c76767a2ae8909f4152fd473a4' where id=3;");
db_execute("update data_template_rrd set hash='93d91aa7a3cc5473e7b195d5d6e6e675' where id=4;");
db_execute("update data_template set hash='cdfed2d401723d2f41fc239d4ce249c7' where id=4;");
db_execute("update data_template_rrd set hash='7bee7987bbf30a3bc429d2a67c6b2595' where id=5;");
db_execute("update data_template set hash='a27e816377d2ac6434a87c494559c726' where id=5;");
db_execute("update data_template_rrd set hash='ddccd7fbdece499da0235b4098b87f9e' where id=6;");
db_execute("update data_template set hash='c06c3d20eccb9598939dc597701ff574' where id=6;");
db_execute("update data_template_rrd set hash='122ab2097f8c6403b7b90cde7b9e2bc2' where id=7;");
db_execute("update data_template set hash='a14f2d6f233b05e64263ff03a5b0b386' where id=7;");
db_execute("update data_template_rrd set hash='34f50c820092ea0fecba25b4b94a7946' where id=8;");
db_execute("update data_template set hash='def1a9019d888ed2ad2e106aa9595ede' where id=8;");
db_execute("update data_template_rrd set hash='830b811d1834e5ba0e2af93bd92db057' where id=9;");
db_execute("update data_template set hash='513a99ae3c9c4413609c1534ffc36eab' where id=9;");
db_execute("update data_template_rrd set hash='2f1b016a2465eef3f7369f6313cd4a94' where id=10;");
db_execute("update data_template set hash='77404ae93c9cc410f1c2c717e7117378' where id=10;");
db_execute("update data_template_rrd set hash='28ffcecaf8b50e49f676f2d4a822685d' where id=11;");
db_execute("update data_template set hash='9e72511e127de200733eb502eb818e1d' where id=11;");
db_execute("update data_template_rrd set hash='8175ca431c8fe50efff5a1d3ae51b55d' where id=12;");
db_execute("update data_template_rrd set hash='a2eeb8acd6ea01cd0e3ac852965c0eb6' where id=13;");
db_execute("update data_template_rrd set hash='9f951b7fb3b19285a411aebb5254a831' where id=14;");
db_execute("update data_template set hash='dc33aa9a8e71fb7c61ec0e7a6da074aa' where id=13;");
db_execute("update data_template_rrd set hash='a4df3de5238d3beabee1a2fe140d3d80' where id=16;");
db_execute("update data_template set hash='41f55087d067142d702dd3c73c98f020' where id=15;");
db_execute("update data_template_rrd set hash='7fea6acc9b1a19484b4cb4cef2b6c5da' where id=18;");
db_execute("update data_template set hash='9b8c92d3c32703900ff7dd653bfc9cd8' where id=16;");
db_execute("update data_template_rrd set hash='f1ba3a5b17b95825021241398bb0f277' where id=19;");
db_execute("update data_template set hash='c221c2164c585b6da378013a7a6a2c13' where id=17;");
db_execute("update data_template_rrd set hash='46a5afe8e6c0419172c76421dc9e304a' where id=20;");
db_execute("update data_template set hash='a30a81cb1de65b52b7da542c8df3f188' where id=18;");
db_execute("update data_template_rrd set hash='962fd1994fe9cae87fb36436bdb8a742' where id=21;");
db_execute("update data_template set hash='0de466a1b81dfe581d44ac014b86553a' where id=19;");
db_execute("update data_template_rrd set hash='7a8dd1111a8624369906bf2cd6ea9ca9' where id=22;");
db_execute("update data_template set hash='bbe2da0708103029fbf949817d3a4537' where id=20;");
db_execute("update data_template_rrd set hash='ddb6e74d34d2f1969ce85f809dbac23d' where id=23;");
db_execute("update data_template set hash='e4ac5d5fe73e3c773671c6d0498a8d9d' where id=22;");
db_execute("update data_template_rrd set hash='289311d10336941d33d9a1c48a7b11ee' where id=25;");
db_execute("update data_template set hash='f29f8c998425eedd249be1e7caf90ceb' where id=23;");
db_execute("update data_template_rrd set hash='02216f036cca04655ee2f67fedb6f4f0' where id=26;");
db_execute("update data_template set hash='7a6216a113e19881e35565312db8a371' where id=24;");
db_execute("update data_template_rrd set hash='9e402c0f29131ef7139c20bd500b4e8a' where id=27;");
db_execute("update data_template set hash='1dbd1251c8e94b334c0e6aeae5ca4b8d' where id=25;");
db_execute("update data_template_rrd set hash='46717dfe3c8c030d8b5ec0874f9dbdca' where id=28;");
db_execute("update data_template set hash='1a4c5264eb27b5e57acd3160af770a61' where id=26;");
db_execute("update data_template_rrd set hash='7a88a60729af62561812c43bde61dfc1' where id=29;");
db_execute("update data_template set hash='e9def3a0e409f517cb804dfeba4ccd90' where id=27;");
db_execute("update data_template_rrd set hash='3c0fd1a188b64a662dfbfa985648397b' where id=30;");
db_execute("update data_template set hash='4e00eeac4938bc51985ad71ae85c0df5' where id=28;");
db_execute("update data_template_rrd set hash='82b26f81d81fa14e9159618cfa6b4ba8' where id=31;");
db_execute("update data_template set hash='1fd08cfd5825b8273ffaa2c4ac0d7919' where id=29;");
db_execute("update data_template_rrd set hash='f888bdbbe48a17cbb343fefabbc74064' where id=32;");
db_execute("update data_template set hash='9b82d44eb563027659683765f92c9757' where id=30;");
db_execute("update data_template_rrd set hash='ed44c2438ef7e46e2aeed2b6c580815c' where id=33;");
db_execute("update data_template set hash='87847714d19f405ff3c74f3341b3f940' where id=31;");
db_execute("update data_template_rrd set hash='9b3a00c9e3530d9e58895ac38271361e' where id=34;");
db_execute("update data_template set hash='308ac157f24e2763f8cd828a80b3e5ff' where id=32;");
db_execute("update data_template_rrd set hash='6746c2ed836ecc68a71bbddf06b0e5d9' where id=35;");
db_execute("update data_template set hash='797a3e92b0039841b52e441a2823a6fb' where id=33;");
db_execute("update data_template_rrd set hash='9835d9e1a8c78aa2475d752e8fa74812' where id=36;");
db_execute("update data_template set hash='fa15932d3cab0da2ab94c69b1a9f5ca7' where id=34;");
db_execute("update data_template_rrd set hash='9c78dc1981bcea841b8c827c6dc0d26c' where id=37;");
db_execute("update data_template set hash='6ce4ab04378f9f3b03ee0623abb6479f' where id=35;");
db_execute("update data_template_rrd set hash='62a56dc76fe4cd8566a31b5df0274cc3' where id=38;");
db_execute("update data_template_rrd set hash='2e366ab49d0e0238fb4e3141ea5a88c3' where id=39;");
db_execute("update data_template_rrd set hash='dceedc84718dd93a5affe4b190bca810' where id=40;");
db_execute("update data_template set hash='03060555fab086b8412bbf9951179cd9' where id=36;");
db_execute("update data_template_rrd set hash='93330503f1cf67db00d8fe636035e545' where id=42;");
db_execute("update data_template_rrd set hash='6b0fe4aa6aaf22ef9cfbbe96d87fa0d7' where id=43;");
db_execute("update data_template set hash='e4ac6919d4f6f21ec5b281a1d6ac4d4e' where id=37;");
db_execute("update data_template_rrd set hash='4c82df790325d789d304e6ee5cd4ab7d' where id=44;");
db_execute("update data_template_rrd set hash='07175541991def89bd02d28a215f6fcc' where id=56;");
db_execute("update data_template set hash='36335cd98633963a575b70639cd2fdad' where id=38;");
db_execute("update data_template_rrd set hash='c802e2fd77f5b0a4c4298951bf65957c' where id=46;");
db_execute("update data_template_rrd set hash='4e2a72240955380dc8ffacfcc8c09874' where id=47;");
db_execute("update data_template_rrd set hash='13ebb33f9cbccfcba828db1075a8167c' where id=50;");
db_execute("update data_template_rrd set hash='31399c3725bee7e09ec04049e3d5cd17' where id=51;");
db_execute("update data_template set hash='2f654f7d69ac71a5d56b1db8543ccad3' where id=39;");
db_execute("update data_template_rrd set hash='636672962b5bb2f31d86985e2ab4bdfe' where id=48;");
db_execute("update data_template_rrd set hash='18ce92c125a236a190ee9dd948f56268' where id=49;");
db_execute("update data_template set hash='c84e511401a747409053c90ba910d0fe' where id=40;");
db_execute("update data_template_rrd set hash='7be68cbc4ee0b2973eb9785f8c7a35c7' where id=52;");
db_execute("update data_template_rrd set hash='93e2b6f59b10b13f2ddf2da3ae98b89a' where id=53;");
db_execute("update data_template set hash='6632e1e0b58a565c135d7ff90440c335' where id=41;");
db_execute("update data_template_rrd set hash='2df25c57022b0c7e7d0be4c035ada1a0' where id=54;");
db_execute("update data_template_rrd set hash='721c0794526d1ac1c359f27dc56faa49' where id=55;");
db_execute("update data_template set hash='1d17325f416b262921a0b55fe5f7e31d' where id=42;");
db_execute("update data_template_rrd set hash='07492e5cace6d74e7db3cb1fc005a3f3' where id=76;");
db_execute("update data_template set hash='d814fa3b79bd0f8933b6e0834d3f16d0' where id=43;");
db_execute("update data_template_rrd set hash='165a0da5f461561c85d092dfe96b9551' where id=92;");
db_execute("update data_template_rrd set hash='0ee6bb54957f6795a5369a29f818d860' where id=78;");
db_execute("update data_template set hash='f6e7d21c19434666bbdac00ccef9932f' where id=44;");
db_execute("update data_template_rrd set hash='9825aaf7c0bdf1554c5b4b86680ac2c0' where id=79;");
db_execute("update data_template set hash='f383db441d1c246cff8482f15e184e5f' where id=45;");
db_execute("update data_template_rrd set hash='50ccbe193c6c7fc29fb9f726cd6c48ee' where id=80;");
db_execute("update data_template set hash='2ef027cc76d75720ee5f7a528f0f1fda' where id=46;");
db_execute("update data_template_rrd set hash='9464c91bcff47f23085ae5adae6ab987' where id=81;");
db_execute("update graph_templates set hash='5deb0d66c81262843dce5f3861be9966' where id=2;");
db_execute("update graph_templates_item set hash='0470b2427dbfadb6b8346e10a71268fa' where id=9;");
db_execute("update graph_templates_item set hash='84a5fe0db518550266309823f994ce9c' where id=10;");
db_execute("update graph_templates_item set hash='2f222f28084085cd06a1f46e4449c793' where id=11;");
db_execute("update graph_templates_item set hash='55acbcc33f46ee6d754e8e81d1b54808' where id=12;");
db_execute("update graph_templates_item set hash='fdaf2321fc890e355711c2bffc07d036' where id=13;");
db_execute("update graph_templates_item set hash='768318f42819217ed81196d2179d3e1b' where id=14;");
db_execute("update graph_templates_item set hash='cb3aa6256dcb3acd50d4517b77a1a5c3' where id=15;");
db_execute("update graph_templates_item set hash='671e989be7cbf12c623b4e79d91c7bed' where id=16;");
db_execute("update graph_template_input set hash='e9d4191277fdfd7d54171f153da57fb0' where id=3;");
db_execute("update graph_template_input set hash='7b361722a11a03238ee8ab7ce44a1037' where id=4;");
db_execute("update graph_templates set hash='abb5e813c9f1e8cd6fc1e393092ef8cb' where id=3;");
db_execute("update graph_templates_item set hash='b561ed15b3ba66d277e6d7c1640b86f7' where id=17;");
db_execute("update graph_templates_item set hash='99ef051057fa6adfa6834a7632e9d8a2' where id=18;");
db_execute("update graph_templates_item set hash='3986695132d3f4716872df4c6fbccb65' where id=19;");
db_execute("update graph_templates_item set hash='0444300017b368e6257f010dca8bbd0d' where id=20;");
db_execute("update graph_templates_item set hash='4d6a0b9063124ca60e2d1702b3e15e41' where id=21;");
db_execute("update graph_templates_item set hash='181b08325e4d00cd50b8cdc8f8ae8e77' where id=22;");
db_execute("update graph_templates_item set hash='bba0a9ff1357c990df50429d64314340' where id=23;");
db_execute("update graph_templates_item set hash='d4a67883d53bc1df8aead21c97c0bc52' where id=24;");
db_execute("update graph_templates_item set hash='253c9ec2d66905245149c1c2dc8e536e' where id=25;");
db_execute("update graph_templates_item set hash='ea9ea883383f4eb462fec6aa309ba7b5' where id=26;");
db_execute("update graph_templates_item set hash='83b746bcaba029eeca170a9f77ec4864' where id=27;");
db_execute("update graph_templates_item set hash='82e01dd92fd37887c0696192efe7af65' where id=28;");
db_execute("update graph_template_input set hash='b33eb27833614056e06ee5952c3e0724' where id=5;");
db_execute("update graph_template_input set hash='ef8799e63ee00e8904bcc4228015784a' where id=6;");
db_execute("update graph_templates set hash='e334bdcf821cd27270a4cc945e80915e' where id=4;");
db_execute("update graph_templates_item set hash='ff0a6125acbb029b814ed1f271ad2d38' where id=29;");
db_execute("update graph_templates_item set hash='f0776f7d6638bba76c2c27f75a424f0f' where id=30;");
db_execute("update graph_templates_item set hash='39f4e021aa3fed9207b5f45a82122b21' where id=31;");
db_execute("update graph_templates_item set hash='800f0b067c06f4ec9c2316711ea83c1e' where id=32;");
db_execute("update graph_templates_item set hash='9419dd5dbf549ba4c5dc1462da6ee321' where id=33;");
db_execute("update graph_templates_item set hash='e461dd263ae47657ea2bf3fd82bec096' where id=34;");
db_execute("update graph_templates_item set hash='f2d1fbb8078a424ffc8a6c9d44d8caa0' where id=35;");
db_execute("update graph_templates_item set hash='e70a5de639df5ba1705b5883da7fccfc' where id=36;");
db_execute("update graph_templates_item set hash='85fefb25ce9fd0317da2706a5463fc42' where id=37;");
db_execute("update graph_templates_item set hash='a1cb26878776999db16f1de7577b3c2a' where id=38;");
db_execute("update graph_templates_item set hash='7d0f9bf64a0898a0095f099674754273' where id=39;");
db_execute("update graph_templates_item set hash='b2879248a522d9679333e1f29e9a87c3' where id=40;");
db_execute("update graph_templates_item set hash='d800aa59eee45383b3d6d35a11cdc864' where id=41;");
db_execute("update graph_templates_item set hash='cab4ae79a546826288e273ca1411c867' where id=42;");
db_execute("update graph_templates_item set hash='d44306ae85622fec971507460be63f5c' where id=43;");
db_execute("update graph_templates_item set hash='aa5c2118035bb83be497d4e099afcc0d' where id=44;");
db_execute("update graph_template_input set hash='4d52e112a836d4c9d451f56602682606' where id=32;");
db_execute("update graph_template_input set hash='f0310b066cc919d2f898b8d1ebf3b518' where id=33;");
db_execute("update graph_template_input set hash='d9eb6b9eb3d7dd44fd14fdefb4096b54' where id=34;");
db_execute("update graph_templates set hash='280e38336d77acde4672879a7db823f3' where id=5;");
db_execute("update graph_templates_item set hash='4aa34ea1b7542b770ace48e8bc395a22' where id=45;");
db_execute("update graph_templates_item set hash='22f118a9d81d0a9c8d922efbbc8a9cc1' where id=46;");
db_execute("update graph_templates_item set hash='229de0c4b490de9d20d8f8d41059f933' where id=47;");
db_execute("update graph_templates_item set hash='cd17feb30c02fd8f21e4d4dcde04e024' where id=48;");
db_execute("update graph_templates_item set hash='8723600cfd0f8a7b3f7dc1361981aabd' where id=49;");
db_execute("update graph_templates_item set hash='cb06be2601b5abfb7a42fc07586de1c2' where id=50;");
db_execute("update graph_templates_item set hash='55a2ee0fd511e5210ed85759171de58f' where id=51;");
db_execute("update graph_templates_item set hash='704459564c84e42462e106eef20db169' where id=52;");
db_execute("update graph_template_input set hash='2662ef4fbb0bf92317ffd42c7515af37' where id=7;");
db_execute("update graph_template_input set hash='a6edef6624c796d3a6055305e2e3d4bf' where id=8;");
db_execute("update graph_template_input set hash='b0e902db1875e392a9d7d69bfbb13515' where id=9;");
db_execute("update graph_template_input set hash='24632b1d4a561e937225d0a5fbe65e41' where id=10;");
db_execute("update graph_templates set hash='3109d88e6806d2ce50c025541b542499' where id=6;");
db_execute("update graph_templates_item set hash='aaebb19ec522497eaaf8c87a631b7919' where id=53;");
db_execute("update graph_templates_item set hash='8b54843ac9d41bce2fcedd023560ed64' where id=54;");
db_execute("update graph_templates_item set hash='05927dc83e07c7d9cffef387d68f35c9' where id=55;");
db_execute("update graph_templates_item set hash='d11e62225a7e7a0cdce89242002ca547' where id=56;");
db_execute("update graph_templates_item set hash='6397b92032486c476b0e13a35b727041' where id=57;");
db_execute("update graph_templates_item set hash='cdfa5f8f82f4c479ff7f6f54160703f6' where id=58;");
db_execute("update graph_templates_item set hash='ce2a309fb9ef64f83f471895069a6f07' where id=59;");
db_execute("update graph_templates_item set hash='9cbfbf57ebde435b27887f27c7d3caea' where id=60;");
db_execute("update graph_template_input set hash='6d078f1d58b70ad154a89eb80fe6ab75' where id=11;");
db_execute("update graph_template_input set hash='878241872dd81c68d78e6ff94871d97d' where id=12;");
db_execute("update graph_template_input set hash='f8fcdc3a3f0e8ead33bd9751895a3462' where id=13;");
db_execute("update graph_template_input set hash='394ab4713a34198dddb5175aa40a2b4a' where id=14;");
db_execute("update graph_templates set hash='cf96dfb22b58e08bf101ca825377fa4b' where id=7;");
db_execute("update graph_templates_item set hash='80e0aa956f50c261e5143273da58b8a3' where id=61;");
db_execute("update graph_templates_item set hash='48fdcae893a7b7496e1a61efc3453599' where id=62;");
db_execute("update graph_templates_item set hash='22f43e5fa20f2716666ba9ed9a7d1727' where id=63;");
db_execute("update graph_templates_item set hash='3e86d497bcded7af7ab8408e4908e0d8' where id=64;");
db_execute("update graph_template_input set hash='433f328369f9569446ddc59555a63eb8' where id=15;");
db_execute("update graph_template_input set hash='a1a91c1514c65152d8cb73522ea9d4e6' where id=16;");
db_execute("update graph_template_input set hash='2fb4deb1448379b27ddc64e30e70dc42' where id=17;");
db_execute("update graph_templates set hash='9fe8b4da353689d376b99b2ea526cc6b' where id=8;");
db_execute("update graph_templates_item set hash='ba00ecd28b9774348322ff70a96f2826' where id=65;");
db_execute("update graph_templates_item set hash='8d76de808efd73c51e9a9cbd70579512' where id=66;");
db_execute("update graph_templates_item set hash='304244ca63d5b09e62a94c8ec6fbda8d' where id=67;");
db_execute("update graph_templates_item set hash='da1ba71a93d2ed4a2a00d54592b14157' where id=68;");
db_execute("update graph_template_input set hash='592cedd465877bc61ab549df688b0b2a' where id=18;");
db_execute("update graph_template_input set hash='1d51dbabb200fcea5c4b157129a75410' where id=19;");
db_execute("update graph_templates set hash='fe5edd777a76d48fc48c11aded5211ef' where id=9;");
db_execute("update graph_templates_item set hash='93ad2f2803b5edace85d86896620b9da' where id=69;");
db_execute("update graph_templates_item set hash='e28736bf63d3a3bda03ea9f1e6ecb0f1' where id=70;");
db_execute("update graph_templates_item set hash='bbdfa13adc00398eed132b1ccb4337d2' where id=71;");
db_execute("update graph_templates_item set hash='2c14062c7d67712f16adde06132675d6' where id=72;");
db_execute("update graph_templates_item set hash='9cf6ed48a6a54b9644a1de8c9929bd4e' where id=73;");
db_execute("update graph_templates_item set hash='c9824064305b797f38feaeed2352e0e5' where id=74;");
db_execute("update graph_templates_item set hash='fa1bc4eff128c4da70f5247d55b8a444' where id=75;");
db_execute("update graph_template_input set hash='8cb8ed3378abec21a1819ea52dfee6a3' where id=20;");
db_execute("update graph_template_input set hash='5dfcaf9fd771deb8c5430bce1562e371' where id=21;");
db_execute("update graph_template_input set hash='6f3cc610315ee58bc8e0b1f272466324' where id=22;");
db_execute("update graph_templates set hash='63610139d44d52b195cc375636653ebd' where id=10;");
db_execute("update graph_templates_item set hash='5c94ac24bc0d6d2712cc028fa7d4c7d2' where id=76;");
db_execute("update graph_templates_item set hash='8bc7f905526f62df7d5c2d8c27c143c1' where id=77;");
db_execute("update graph_templates_item set hash='cd074cd2b920aab70d480c020276d45b' where id=78;");
db_execute("update graph_templates_item set hash='415630f25f5384ba0c82adbdb05fe98b' where id=79;");
db_execute("update graph_template_input set hash='b457a982bf46c6760e6ef5f5d06d41fb' where id=23;");
db_execute("update graph_template_input set hash='bd4a57adf93c884815b25a8036b67f98' where id=24;");
db_execute("update graph_templates set hash='5107ec0206562e77d965ce6b852ef9d4' where id=11;");
db_execute("update graph_templates_item set hash='d77d2050be357ab067666a9485426e6b' where id=80;");
db_execute("update graph_templates_item set hash='13d22f5a0eac6d97bf6c97d7966f0a00' where id=81;");
db_execute("update graph_templates_item set hash='8580230d31d2851ec667c296a665cbf9' where id=82;");
db_execute("update graph_templates_item set hash='b5b7d9b64e7640aa51dbf58c69b86d15' where id=83;");
db_execute("update graph_templates_item set hash='2ec10edf4bfaa866b7efd544d4c3f446' where id=84;");
db_execute("update graph_templates_item set hash='b65666f0506c0c70966f493c19607b93' where id=85;");
db_execute("update graph_templates_item set hash='6c73575c74506cfc75b89c4276ef3455' where id=86;");
db_execute("update graph_template_input set hash='d7cdb63500c576e0f9f354de42c6cf3a' where id=25;");
db_execute("update graph_template_input set hash='a23152f5ec02e7762ca27608c0d89f6c' where id=26;");
db_execute("update graph_template_input set hash='2cc5d1818da577fba15115aa18f64d85' where id=27;");
db_execute("update graph_templates set hash='6992ed4df4b44f3d5595386b8298f0ec' where id=12;");
db_execute("update graph_templates_item set hash='5fa7c2317f19440b757ab2ea1cae6abc' where id=95;");
db_execute("update graph_templates_item set hash='b1d18060bfd3f68e812c508ff4ac94ed' where id=96;");
db_execute("update graph_templates_item set hash='780b6f0850aaf9431d1c246c55143061' where id=97;");
db_execute("update graph_templates_item set hash='2d54a7e7bb45e6c52d97a09e24b7fba7' where id=98;");
db_execute("update graph_templates_item set hash='40206367a3c192b836539f49801a0b15' where id=99;");
db_execute("update graph_templates_item set hash='7ee72e2bb3722d4f8a7f9c564e0dd0d0' where id=100;");
db_execute("update graph_templates_item set hash='c8af33b949e8f47133ee25e63c91d4d0' where id=101;");
db_execute("update graph_templates_item set hash='568128a16723d1195ce6a234d353ce00' where id=102;");
db_execute("update graph_template_input set hash='6273c71cdb7ed4ac525cdbcf6180918c' where id=30;");
db_execute("update graph_template_input set hash='5e62dbea1db699f1bda04c5863e7864d' where id=31;");
db_execute("update graph_templates set hash='be275639d5680e94c72c0ebb4e19056d' where id=13;");
db_execute("update graph_templates_item set hash='7517a40d478e28ed88ba2b2a65e16b57' where id=103;");
db_execute("update graph_templates_item set hash='df0c8b353d26c334cb909dc6243957c5' where id=104;");
db_execute("update graph_templates_item set hash='c41a4cf6fefaf756a24f0a9510580724' where id=105;");
db_execute("update graph_templates_item set hash='9efa8f01c6ed11364a21710ff170f422' where id=106;");
db_execute("update graph_templates_item set hash='95d6e4e5110b456f34324f7941d08318' where id=107;");
db_execute("update graph_templates_item set hash='0c631bfc0785a9cca68489ea87a6c3da' where id=108;");
db_execute("update graph_templates_item set hash='3468579d3b671dfb788696df7dcc1ec9' where id=109;");
db_execute("update graph_templates_item set hash='c3ddfdaa65449f99b7f1a735307f9abe' where id=110;");
db_execute("update graph_template_input set hash='f45def7cad112b450667aa67262258cb' where id=35;");
db_execute("update graph_template_input set hash='f8c361a8c8b7ad80e8be03ba7ea5d0d6' where id=36;");
db_execute("update graph_templates set hash='f17e4a77b8496725dc924b8c35b60036' where id=14;");
db_execute("update graph_templates_item set hash='4c64d5c1ce8b5d8b94129c23b46a5fd6' where id=111;");
db_execute("update graph_templates_item set hash='5c1845c9bd1af684a3c0ad843df69e3e' where id=112;");
db_execute("update graph_templates_item set hash='e5169563f3f361701902a8da3ac0c77f' where id=113;");
db_execute("update graph_templates_item set hash='35e87262efa521edbb1fd27f09c036f5' where id=114;");
db_execute("update graph_templates_item set hash='53069d7dba4c31b338f609bea4cd16f3' where id=115;");
db_execute("update graph_templates_item set hash='d9c102579839c5575806334d342b50de' where id=116;");
db_execute("update graph_templates_item set hash='dc1897c3249dbabe269af49cee92f8c0' where id=117;");
db_execute("update graph_templates_item set hash='ccd21fe0b5a8c24057f1eff4a6b66391' where id=118;");
db_execute("update graph_template_input set hash='03d11dce695963be30bd744bd6cbac69' where id=37;");
db_execute("update graph_template_input set hash='9cbc515234779af4bf6cdf71a81c556a' where id=38;");
db_execute("update graph_templates set hash='46bb77f4c0c69671980e3c60d3f22fa9' where id=15;");
db_execute("update graph_templates_item set hash='ab09d41c358f6b8a9d0cad4eccc25529' where id=119;");
db_execute("update graph_templates_item set hash='5d5b8d8fbe751dc9c86ee86f85d7433b' where id=120;");
db_execute("update graph_templates_item set hash='4822a98464c6da2afff10c6d12df1831' where id=121;");
db_execute("update graph_templates_item set hash='fc6fbf2a964bea0b3c88ed0f18616aa7' where id=122;");
db_execute("update graph_template_input set hash='2c4d561ee8132a8dda6de1104336a6ec' where id=39;");
db_execute("update graph_template_input set hash='31fed1f9e139d4897d0460b10fb7be94' where id=44;");
db_execute("update graph_templates set hash='8e77a3036312fd0fda32eaea2b5f141b' where id=16;");
db_execute("update graph_templates_item set hash='e4094625d5443b4c87f9a87ba616a469' where id=123;");
db_execute("update graph_templates_item set hash='ae68425cd10e8a6623076b2e6859a6aa' where id=124;");
db_execute("update graph_templates_item set hash='40b8e14c6568b3f6be6a5d89d6a9f061' where id=125;");
db_execute("update graph_templates_item set hash='4afbdc3851c03e206672930746b1a5e2' where id=126;");
db_execute("update graph_templates_item set hash='ea47d2b5516e334bc5f6ce1698a3ae76' where id=127;");
db_execute("update graph_templates_item set hash='899c48a2f79ea3ad4629aff130d0f371' where id=128;");
db_execute("update graph_templates_item set hash='ab474d7da77e9ec1f6a1d45c602580cd' where id=129;");
db_execute("update graph_templates_item set hash='e143f8b4c6d4eeb6a28b052e6b8ce5a9' where id=130;");
db_execute("update graph_template_input set hash='6e1cf7addc0cc419aa903552e3eedbea' where id=40;");
db_execute("update graph_template_input set hash='7ea2aa0656f7064d25a36135dd0e9082' where id=41;");
db_execute("update graph_templates set hash='5892c822b1bb2d38589b6c27934b9936' where id=17;");
db_execute("update graph_templates_item set hash='facfeeb6fc2255ba2985b2d2f695d78a' where id=131;");
db_execute("update graph_templates_item set hash='2470e43034a5560260d79084432ed14f' where id=132;");
db_execute("update graph_templates_item set hash='e9e645f07bde92b52d93a7a1f65efb30' where id=133;");
db_execute("update graph_templates_item set hash='bdfe0d66103211cfdaa267a44a98b092' where id=134;");
db_execute("update graph_template_input set hash='63480bca78a38435f24a5b5d5ed050d7' where id=42;");
db_execute("update graph_templates set hash='9a5e6d7781cc1bd6cf24f64dd6ffb423' where id=18;");
db_execute("update graph_templates_item set hash='098b10c13a5701ddb7d4d1d2e2b0fdb7' where id=139;");
db_execute("update graph_templates_item set hash='1dbda412a9926b0ee5c025aa08f3b230' where id=140;");
db_execute("update graph_templates_item set hash='725c45917146807b6a4257fc351f2bae' where id=141;");
db_execute("update graph_templates_item set hash='4e336fdfeb84ce65f81ded0e0159a5e0' where id=142;");
db_execute("update graph_template_input set hash='bb9d83a02261583bc1f92d9e66ea705d' where id=45;");
db_execute("update graph_template_input set hash='51196222ed37b44236d9958116028980' where id=46;");
db_execute("update graph_templates set hash='0dd0438d5e6cad6776f79ecaa96fb708' where id=19;");
db_execute("update graph_templates_item set hash='7dab7a3ceae2addd1cebddee6c483e7c' where id=143;");
db_execute("update graph_templates_item set hash='aea239f3ceea8c63d02e453e536190b8' where id=144;");
db_execute("update graph_templates_item set hash='a0efae92968a6d4ae099b676e0f1430e' where id=145;");
db_execute("update graph_templates_item set hash='4fd5ba88be16e3d513c9231b78ccf0e1' where id=146;");
db_execute("update graph_templates_item set hash='d2e98e51189e1d9be8888c3d5c5a4029' where id=147;");
db_execute("update graph_templates_item set hash='12829294ee3958f4a31a58a61228e027' where id=148;");
db_execute("update graph_templates_item set hash='4b7e8755b0f2253723c1e9fb21fd37b1' where id=149;");
db_execute("update graph_templates_item set hash='cbb19ffd7a0ead2bf61512e86d51ee8e' where id=150;");
db_execute("update graph_templates_item set hash='37b4cbed68f9b77e49149343069843b4' where id=151;");
db_execute("update graph_templates_item set hash='5eb7532200f2b5cc93e13743a7db027c' where id=152;");
db_execute("update graph_templates_item set hash='b0f9f602fbeaaff090ea3f930b46c1c7' where id=153;");
db_execute("update graph_templates_item set hash='06477f7ea46c63272cee7253e7cd8760' where id=154;");
db_execute("update graph_template_input set hash='fd26b0f437b75715d6dff983e7efa710' where id=47;");
db_execute("update graph_template_input set hash='a463dd46862605c90ea60ccad74188db' where id=48;");
db_execute("update graph_template_input set hash='9977dd7a41bcf0f0c02872b442c7492e' where id=49;");
db_execute("update graph_templates set hash='b18a3742ebea48c6198412b392d757fc' where id=20;");
db_execute("update graph_templates_item set hash='6877a2a5362a9390565758b08b9b37f7' where id=159;");
db_execute("update graph_templates_item set hash='a978834f3d02d833d3d2def243503bf2' where id=160;");
db_execute("update graph_templates_item set hash='7422d87bc82de20a4333bd2f6460b2d4' where id=161;");
db_execute("update graph_templates_item set hash='4d52762859a3fec297ebda0e7fd760d9' where id=162;");
db_execute("update graph_templates_item set hash='999d4ed1128ff03edf8ea47e56d361dd' where id=163;");
db_execute("update graph_templates_item set hash='3dfcd7f8c7a760ac89d34398af79b979' where id=164;");
db_execute("update graph_templates_item set hash='217be75e28505c8f8148dec6b71b9b63' where id=165;");
db_execute("update graph_templates_item set hash='69b89e1c5d6fc6182c93285b967f970a' where id=166;");
db_execute("update graph_template_input set hash='a7a69bbdf6890d6e6eaa7de16e815ec6' where id=51;");
db_execute("update graph_template_input set hash='0072b613a33f1fae5ce3e5903dec8fdb' where id=52;");
db_execute("update graph_templates set hash='8e7c8a511652fe4a8e65c69f3d34779d' where id=21;");
db_execute("update graph_templates_item set hash='a751838f87068e073b95be9555c57bde' where id=171;");
db_execute("update graph_templates_item set hash='3b13eb2e542fe006c9bf86947a6854fa' where id=170;");
db_execute("update graph_templates_item set hash='8ef3e7fb7ce962183f489725939ea40f' where id=169;");
db_execute("update graph_templates_item set hash='6ca2161c37b0118786dbdb46ad767e5d' where id=167;");
db_execute("update graph_templates_item set hash='5d6dff9c14c71dc1ebf83e87f1c25695' where id=172;");
db_execute("update graph_templates_item set hash='b27cb9a158187d29d17abddc6fdf0f15' where id=173;");
db_execute("update graph_templates_item set hash='6c0555013bb9b964e51d22f108dae9b0' where id=174;");
db_execute("update graph_templates_item set hash='42ce58ec17ef5199145fbf9c6ee39869' where id=175;");
db_execute("update graph_templates_item set hash='9bdff98f2394f666deea028cbca685f3' where id=176;");
db_execute("update graph_templates_item set hash='fb831fefcf602bc31d9d24e8e456c2e6' where id=177;");
db_execute("update graph_templates_item set hash='5a958d56785a606c08200ef8dbf8deef' where id=178;");
db_execute("update graph_templates_item set hash='5ce67a658cec37f526dc84ac9e08d6e7' where id=179;");
db_execute("update graph_template_input set hash='940beb0f0344e37f4c6cdfc17d2060bc' where id=53;");
db_execute("update graph_template_input set hash='7b0674dd447a9badf0d11bec688028a8' where id=54;");
db_execute("update graph_templates set hash='06621cd4a9289417cadcb8f9b5cfba80' where id=22;");
db_execute("update graph_templates_item set hash='7e04a041721df1f8828381a9ea2f2154' where id=180;");
db_execute("update graph_templates_item set hash='afc8bca6b1b3030a6d71818272336c6c' where id=181;");
db_execute("update graph_templates_item set hash='6ac169785f5aeaf1cc5cdfd38dfcfb6c' where id=182;");
db_execute("update graph_templates_item set hash='178c0a0ce001d36a663ff6f213c07505' where id=183;");
db_execute("update graph_templates_item set hash='8e3268c0abde7550616bff719f10ee2f' where id=184;");
db_execute("update graph_templates_item set hash='18891392b149de63b62c4258a68d75f8' where id=185;");
db_execute("update graph_templates_item set hash='dfc9d23de0182c9967ae3dabdfa55a16' where id=186;");
db_execute("update graph_templates_item set hash='c47ba64e2e5ea8bf84aceec644513176' where id=187;");
db_execute("update graph_templates_item set hash='617d10dff9bbc3edd9d733d9c254da76' where id=204;");
db_execute("update graph_templates_item set hash='9269a66502c34d00ac3c8b1fcc329ac6' where id=205;");
db_execute("update graph_templates_item set hash='d45deed7e1ad8350f3b46b537ae0a933' where id=206;");
db_execute("update graph_templates_item set hash='2f64cf47dc156e8c800ae03c3b893e3c' where id=207;");
db_execute("update graph_templates_item set hash='57434bef8cb21283c1a73f055b0ada19' where id=208;");
db_execute("update graph_templates_item set hash='660a1b9365ccbba356fd142faaec9f04' where id=209;");
db_execute("update graph_templates_item set hash='28c5297bdaedcca29acf245ef4bbed9e' where id=210;");
db_execute("update graph_templates_item set hash='99098604fd0c78fd7dabac8f40f1fb29' where id=211;");
db_execute("update graph_template_input set hash='fa83cd3a3b4271b644cb6459ea8c35dc' where id=55;");
db_execute("update graph_template_input set hash='7946e8ee1e38a65462b85e31a15e35e5' where id=56;");
db_execute("update graph_template_input set hash='e5acdd5368137c408d56ecf55b0e077c' where id=61;");
db_execute("update graph_template_input set hash='a028e586e5fae667127c655fe0ac67f0' where id=62;");
db_execute("update graph_templates set hash='e0d1625a1f4776a5294583659d5cee15' where id=23;");
db_execute("update graph_templates_item set hash='9d052e7d632c479737fbfaced0821f79' where id=188;");
db_execute("update graph_templates_item set hash='9b9fa6268571b6a04fa4411d8e08c730' where id=189;");
db_execute("update graph_templates_item set hash='8e8f2fbeb624029cbda1d2a6ddd991ba' where id=190;");
db_execute("update graph_templates_item set hash='c76495beb1ed01f0799838eb8a893124' where id=191;");
db_execute("update graph_templates_item set hash='d4e5f253f01c3ea77182c5a46418fc44' where id=192;");
db_execute("update graph_templates_item set hash='526a96add143da021c5f00d8764a6c12' where id=193;");
db_execute("update graph_templates_item set hash='81eeb46f451212f00fd7caee42a81c0b' where id=194;");
db_execute("update graph_templates_item set hash='089e4d1c3faeb00fd5dcc9622b06d656' where id=195;");
db_execute("update graph_template_input set hash='00ae916640272f5aca54d73ae34c326b' where id=57;");
db_execute("update graph_template_input set hash='1bc1652f82488ebfb7242c65d2ffa9c7' where id=58;");
db_execute("update graph_templates set hash='10ca5530554da7b73dc69d291bf55d38' where id=24;");
db_execute("update graph_templates_item set hash='fe66cb973966d22250de073405664200' where id=196;");
db_execute("update graph_templates_item set hash='1ba3fc3466ad32fdd2669cac6cad6faa' where id=197;");
db_execute("update graph_templates_item set hash='f810154d3a934c723c21659e66199cdf' where id=198;");
db_execute("update graph_templates_item set hash='98a161df359b01304346657ff1a9d787' where id=199;");
db_execute("update graph_templates_item set hash='d5e55eaf617ad1f0516f6343b3f07c5e' where id=200;");
db_execute("update graph_templates_item set hash='9fde6b8c84089b9f9044e681162e7567' where id=201;");
db_execute("update graph_templates_item set hash='9a3510727c3d9fa7e2e7a015783a99b3' where id=202;");
db_execute("update graph_templates_item set hash='451afd23f2cb59ab9b975fd6e2735815' where id=203;");
db_execute("update graph_template_input set hash='e3177d0e56278de320db203f32fb803d' where id=59;");
db_execute("update graph_template_input set hash='4f20fba2839764707f1c3373648c5fef' where id=60;");
db_execute("update graph_templates set hash='df244b337547b434b486662c3c5c7472' where id=25;");
db_execute("update graph_templates_item set hash='de3eefd6d6c58afabdabcaf6c0168378' where id=212;");
db_execute("update graph_templates_item set hash='1a80fa108f5c46eecb03090c65bc9a12' where id=213;");
db_execute("update graph_templates_item set hash='fe458892e7faa9d232e343d911e845f3' where id=214;");
db_execute("update graph_templates_item set hash='175c0a68689bebc38aad2fbc271047b3' where id=215;");
db_execute("update graph_templates_item set hash='1bf2283106510491ddf3b9c1376c0b31' where id=216;");
db_execute("update graph_templates_item set hash='c5202f1690ffe45600c0d31a4a804f67' where id=217;");
db_execute("update graph_templates_item set hash='eb9794e3fdafc2b74f0819269569ed40' where id=218;");
db_execute("update graph_templates_item set hash='6bcedd61e3ccf7518ca431940c93c439' where id=219;");
db_execute("update graph_template_input set hash='2764a4f142ba9fd95872106a1b43541e' where id=63;");
db_execute("update graph_template_input set hash='f73f7ddc1f4349356908122093dbfca2' where id=64;");
db_execute("update graph_templates set hash='7489e44466abee8a7d8636cb2cb14a1a' where id=26;");
db_execute("update graph_templates_item set hash='b7b381d47972f836785d338a3bef6661' where id=303;");
db_execute("update graph_templates_item set hash='36fa8063df3b07cece878d54443db727' where id=304;");
db_execute("update graph_templates_item set hash='2c35b5cae64c5f146a55fcb416dd14b5' where id=305;");
db_execute("update graph_templates_item set hash='16d6a9a7f608762ad65b0841e5ef4e9c' where id=306;");
db_execute("update graph_templates_item set hash='d80e4a4901ab86ee39c9cc613e13532f' where id=307;");
db_execute("update graph_templates_item set hash='567c2214ee4753aa712c3d101ea49a5d' where id=308;");
db_execute("update graph_templates_item set hash='ba0b6a9e316ef9be66abba68b80f7587' where id=309;");
db_execute("update graph_templates_item set hash='4b8e4a6bf2757f04c3e3a088338a2f7a' where id=310;");
db_execute("update graph_template_input set hash='86bd8819d830a81d64267761e1fd8ec4' where id=65;");
db_execute("update graph_template_input set hash='6c8967850102202de166951e4411d426' where id=66;");
db_execute("update graph_templates set hash='c6bb62bedec4ab97f9db9fd780bd85a6' where id=27;");
db_execute("update graph_templates_item set hash='8536e034ab5268a61473f1ff2f6bd88f' where id=317;");
db_execute("update graph_templates_item set hash='d478a76de1df9edf896c9ce51506c483' where id=316;");
db_execute("update graph_templates_item set hash='42537599b5fb8ea852240b58a58633de' where id=315;");
db_execute("update graph_templates_item set hash='87e10f9942b625aa323a0f39b60058e7' where id=318;");
db_execute("update graph_template_input set hash='bdad718851a52b82eca0a310b0238450' where id=67;");
db_execute("update graph_template_input set hash='e7b578e12eb8a82627557b955fd6ebd4' where id=68;");
db_execute("update graph_templates set hash='e8462bbe094e4e9e814d4e681671ea82' where id=28;");
db_execute("update graph_templates_item set hash='38f6891b0db92aa8950b4ce7ae902741' where id=319;");
db_execute("update graph_templates_item set hash='af13152956a20aa894ef4a4067b88f63' where id=320;");
db_execute("update graph_templates_item set hash='1b2388bbede4459930c57dc93645284e' where id=321;");
db_execute("update graph_templates_item set hash='6407dc226db1d03be9730f4d6f3eeccf' where id=322;");
db_execute("update graph_template_input set hash='37d09fb7ce88ecec914728bdb20027f3' where id=69;");
db_execute("update graph_template_input set hash='699bd7eff7ba0c3520db3692103a053d' where id=70;");
db_execute("update graph_templates set hash='62205afbd4066e5c4700338841e3901e' where id=29;");
db_execute("update graph_templates_item set hash='fca6a530c8f37476b9004a90b42ee988' where id=323;");
db_execute("update graph_templates_item set hash='5acebbde3dc65e02f8fda03955852fbe' where id=324;");
db_execute("update graph_templates_item set hash='311079ffffac75efaab2837df8123122' where id=325;");
db_execute("update graph_templates_item set hash='724d27007ebf31016cfa5530fee1b867' where id=326;");
db_execute("update graph_template_input set hash='df905e159d13a5abed8a8a7710468831' where id=71;");
db_execute("update graph_template_input set hash='8ca9e3c65c080dbf74a59338d64b0c14' where id=72;");
db_execute("update graph_templates set hash='e3780a13b0f7a3f85a44b70cd4d2fd36' where id=30;");
db_execute("update graph_templates_item set hash='5258970186e4407ed31cca2782650c45' where id=360;");
db_execute("update graph_templates_item set hash='da26dd92666cb840f8a70e2ec5e90c07' where id=359;");
db_execute("update graph_templates_item set hash='803b96bcaec33148901b4b562d9d2344' where id=358;");
db_execute("update graph_templates_item set hash='7d08b996bde9cdc7efa650c7031137b4' where id=361;");
db_execute("update graph_template_input set hash='69ad68fc53af03565aef501ed5f04744' where id=73;");
db_execute("update graph_templates set hash='1742b2066384637022d178cc5072905a' where id=31;");
db_execute("update graph_templates_item set hash='918e6e7d41bb4bae0ea2937b461742a4' where id=362;");
db_execute("update graph_templates_item set hash='f19fbd06c989ea85acd6b4f926e4a456' where id=363;");
db_execute("update graph_templates_item set hash='fc150a15e20c57e11e8d05feca557ef9' where id=364;");
db_execute("update graph_templates_item set hash='ccbd86e03ccf07483b4d29e63612fb18' where id=365;");
db_execute("update graph_templates_item set hash='964c5c30cd05eaf5a49c0377d173de86' where id=366;");
db_execute("update graph_templates_item set hash='b1a6fb775cf62e79e1c4bc4933c7e4ce' where id=367;");
db_execute("update graph_templates_item set hash='721038182a872ab266b5cf1bf7f7755c' where id=368;");
db_execute("update graph_templates_item set hash='2302f80c2c70b897d12182a1fc11ecd6' where id=369;");
db_execute("update graph_templates_item set hash='4ffc7af8533d103748316752b70f8e3c' where id=370;");
db_execute("update graph_templates_item set hash='64527c4b6eeeaf627acc5117ff2180fd' where id=371;");
db_execute("update graph_templates_item set hash='d5bbcbdbf83ae858862611ac6de8fc62' where id=372;");
db_execute("update graph_template_input set hash='562726cccdb67d5c6941e9e826ef4ef5' where id=74;");
db_execute("update graph_template_input set hash='82426afec226f8189c8928e7f083f80f' where id=75;");
db_execute("update graph_templates set hash='13b47e10b2d5db45707d61851f69c52b' where id=32;");
db_execute("update graph_templates_item set hash='0e715933830112c23c15f7e3463f77b6' where id=380;");
db_execute("update graph_templates_item set hash='979fff9d691ca35e3f4b3383d9cae43f' where id=379;");
db_execute("update graph_templates_item set hash='5bff63207c7bf076d76ff3036b5dad54' where id=378;");
db_execute("update graph_templates_item set hash='4a381a8e87d4db1ac99cf8d9078266d3' where id=377;");
db_execute("update graph_templates_item set hash='88d3094d5dc2164cbf2f974aeb92f051' where id=376;");
db_execute("update graph_templates_item set hash='54782f71929e7d1734ed5ad4b8dda50d' where id=375;");
db_execute("update graph_templates_item set hash='55083351cd728b82cc4dde68eb935700' where id=374;");
db_execute("update graph_templates_item set hash='1995d8c23e7d8e1efa2b2c55daf3c5a7' where id=373;");
db_execute("update graph_templates_item set hash='db7c15d253ca666601b3296f2574edc9' where id=384;");
db_execute("update graph_templates_item set hash='5b43e4102600ad75379c5afd235099c4' where id=383;");
db_execute("update graph_template_input set hash='f28013abf8e5813870df0f4111a5e695' where id=77;");
db_execute("update graph_template_input set hash='69a23877302e7d142f254b208c58b596' where id=76;");
db_execute("update graph_templates set hash='8ad6790c22b693680e041f21d62537ac' where id=33;");
db_execute("update graph_templates_item set hash='fdaec5b9227522c758ad55882c483a83' where id=385;");
db_execute("update graph_templates_item set hash='6824d29c3f13fe1e849f1dbb8377d3f1' where id=386;");
db_execute("update graph_templates_item set hash='54e3971b3dd751dd2509f62721c12b41' where id=387;");
db_execute("update graph_templates_item set hash='cf8c9f69878f0f595d583eac109a9be1' where id=388;");
db_execute("update graph_templates_item set hash='de265acbbfa99eb4b3e9f7e90c7feeda' where id=389;");
db_execute("update graph_templates_item set hash='777aa88fb0a79b60d081e0e3759f1cf7' where id=390;");
db_execute("update graph_templates_item set hash='66bfdb701c8eeadffe55e926d6e77e71' where id=391;");
db_execute("update graph_templates_item set hash='3ff8dba1ca6279692b3fcabed0bc2631' where id=392;");
db_execute("update graph_templates_item set hash='d6041d14f9c8fb9b7ddcf3556f763c03' where id=393;");
db_execute("update graph_templates_item set hash='76ae747365553a02313a2d8a0dd55c8a' where id=394;");
db_execute("update graph_template_input set hash='8644b933b6a09dde6c32ff24655eeb9a' where id=78;");
db_execute("update graph_template_input set hash='49c4b4800f3e638a6f6bb681919aea80' where id=79;");
db_execute("update snmp_query set hash='d75e406fdeca4fcef45b8be3a9a63cbc' where id=1;");
db_execute("update snmp_query_graph set hash='a4b829746fb45e35e10474c36c69c0cf' where id=2;");
db_execute("update snmp_query_graph_rrd_sv set hash='6537b3209e0697fbec278e94e7317b52' where id=49;");
db_execute("update snmp_query_graph_rrd_sv set hash='6d3f612051016f48c951af8901720a1c' where id=50;");
db_execute("update snmp_query_graph_rrd_sv set hash='62bc981690576d0b2bd0041ec2e4aa6f' where id=51;");
db_execute("update snmp_query_graph_rrd_sv set hash='adb270d55ba521d205eac6a21478804a' where id=52;");
db_execute("update snmp_query_graph_sv set hash='299d3434851fc0d5c0e105429069709d' where id=21;");
db_execute("update snmp_query_graph_sv set hash='8c8860b17fd67a9a500b4cb8b5e19d4b' where id=22;");
db_execute("update snmp_query_graph_sv set hash='d96360ae5094e5732e7e7496ceceb636' where id=23;");
db_execute("update snmp_query_graph set hash='01e33224f8b15997d3d09d6b1bf83e18' where id=3;");
db_execute("update snmp_query_graph_rrd_sv set hash='77065435f3bbb2ff99bc3b43b81de8fe' where id=54;");
db_execute("update snmp_query_graph_rrd_sv set hash='240d8893092619c97a54265e8d0b86a1' where id=55;");
db_execute("update snmp_query_graph_rrd_sv set hash='4b200ecf445bdeb4c84975b74991df34' where id=56;");
db_execute("update snmp_query_graph_rrd_sv set hash='d6da3887646078e4d01fe60a123c2179' where id=57;");
db_execute("update snmp_query_graph_sv set hash='750a290cadc3dc60bb682a5c5f47df16' where id=24;");
db_execute("update snmp_query_graph_sv set hash='bde195eecc256c42ca9725f1f22c1dc0' where id=25;");
db_execute("update snmp_query_graph_sv set hash='d9e97d22689e4ffddaca23b46f2aa306' where id=26;");
db_execute("update snmp_query_graph set hash='1e6edee3115c42d644dbd014f0577066' where id=4;");
db_execute("update snmp_query_graph_rrd_sv set hash='ce7769b97d80ca31d21f83dc18ba93c2' where id=59;");
db_execute("update snmp_query_graph_rrd_sv set hash='1ee1f9717f3f4771f7f823ca5a8b83dd' where id=60;");
db_execute("update snmp_query_graph_rrd_sv set hash='a7dbd54604533b592d4fae6e67587e32' where id=61;");
db_execute("update snmp_query_graph_rrd_sv set hash='b148fa7199edcf06cd71c89e5c5d7b63' where id=62;");
db_execute("update snmp_query_graph_sv set hash='48ceaba62e0c2671a810a7f1adc5f751' where id=27;");
db_execute("update snmp_query_graph_sv set hash='d6258884bed44abe46d264198adc7c5d' where id=28;");
db_execute("update snmp_query_graph_sv set hash='6eb58d9835b2b86222306d6ced9961d9' where id=29;");
db_execute("update snmp_query_graph set hash='ab93b588c29731ab15db601ca0bc9dec' where id=9;");
db_execute("update snmp_query_graph_rrd_sv set hash='e1be83d708ed3c0b8715ccb6517a0365' where id=88;");
db_execute("update snmp_query_graph_rrd_sv set hash='c582d3b37f19e4a703d9bf4908dc6548' where id=86;");
db_execute("update snmp_query_graph_rrd_sv set hash='57a9ae1f197498ca8dcde90194f61cbc' where id=89;");
db_execute("update snmp_query_graph_rrd_sv set hash='0110e120981c7ff15304e4a85cb42cbe' where id=90;");
db_execute("update snmp_query_graph_rrd_sv set hash='ce0b9c92a15759d3ddbd7161d26a98b7' where id=91;");
db_execute("update snmp_query_graph_sv set hash='0a5eb36e98c04ad6be8e1ef66caeed3c' where id=34;");
db_execute("update snmp_query_graph_sv set hash='4c4386a96e6057b7bd0b78095209ddfa' where id=35;");
db_execute("update snmp_query_graph_sv set hash='fd3a384768b0388fa64119fe2f0cc113' where id=36;");
db_execute("update snmp_query_graph set hash='ae34f5f385bed8c81a158bf3030f1089' where id=13;");
db_execute("update snmp_query_graph_rrd_sv set hash='7e093c535fa3d810fa76fc3d8c80c94b' where id=75;");
db_execute("update snmp_query_graph_rrd_sv set hash='084efd82bbddb69fb2ac9bd0b0f16ac6' where id=74;");
db_execute("update snmp_query_graph_rrd_sv set hash='14aa2dead86bbad0f992f1514722c95e' where id=72;");
db_execute("update snmp_query_graph_rrd_sv set hash='70390712158c3c5052a7d830fb456489' where id=73;");
db_execute("update snmp_query_graph_rrd_sv set hash='87a659326af8c75158e5142874fd74b0' where id=70;");
db_execute("update snmp_query_graph_sv set hash='49dca5592ac26ff149a4fbd18d690644' where id=15;");
db_execute("update snmp_query_graph_sv set hash='bda15298139ad22bdc8a3b0952d4e3ab' where id=16;");
db_execute("update snmp_query_graph_sv set hash='29e48483d0471fcd996bfb702a5960aa' where id=17;");
db_execute("update snmp_query_graph set hash='1e16a505ddefb40356221d7a50619d91' where id=14;");
db_execute("update snmp_query_graph_rrd_sv set hash='8d820d091ec1a9683cfa74a462f239ee' where id=82;");
db_execute("update snmp_query_graph_rrd_sv set hash='2e8b27c63d98249096ad5bc320787f43' where id=81;");
db_execute("update snmp_query_graph_rrd_sv set hash='e85ddc56efa677b70448f9e931360b77' where id=85;");
db_execute("update snmp_query_graph_rrd_sv set hash='37bb8c5b38bb7e89ec88ea7ccacf44d4' where id=84;");
db_execute("update snmp_query_graph_rrd_sv set hash='62a47c18be10f273a5f5a13a76b76f54' where id=83;");
db_execute("update snmp_query_graph_sv set hash='3f42d358965cb94ce4f708b59e04f82b' where id=18;");
db_execute("update snmp_query_graph_sv set hash='45f44b2f811ea8a8ace1cbed8ef906f1' where id=19;");
db_execute("update snmp_query_graph_sv set hash='69c14fbcc23aecb9920b3cdad7f89901' where id=20;");
db_execute("update snmp_query_graph set hash='d1e0d9b8efd4af98d28ce2aad81a87e7' where id=16;");
db_execute("update snmp_query_graph_rrd_sv set hash='2347e9f53564a54d43f3c00d4b60040d' where id=79;");
db_execute("update snmp_query_graph_rrd_sv set hash='27eb220995925e1a5e0e41b2582a2af6' where id=80;");
db_execute("update snmp_query_graph_rrd_sv set hash='3a0f707d1c8fd0e061b70241541c7e2e' where id=78;");
db_execute("update snmp_query_graph_rrd_sv set hash='8ef8ae2ef548892ab95bb6c9f0b3170e' where id=77;");
db_execute("update snmp_query_graph_rrd_sv set hash='c7ee2110bf81639086d2da03d9d88286' where id=76;");
db_execute("update snmp_query_graph_sv set hash='809c2e80552d56b65ca496c1c2fff398' where id=33;");
db_execute("update snmp_query_graph_sv set hash='e403f5a733bf5c8401a110609683deb3' where id=32;");
db_execute("update snmp_query_graph_sv set hash='7fb4a267065f960df81c15f9022cd3a4' where id=31;");
db_execute("update snmp_query_graph set hash='ed7f68175d7bb83db8ead332fc945720' where id=20;");
db_execute("update snmp_query_graph_rrd_sv set hash='7e87efd0075caba9908e2e6e569b25b0' where id=95;");
db_execute("update snmp_query_graph_rrd_sv set hash='dd28d96a253ab86846aedb25d1cca712' where id=96;");
db_execute("update snmp_query_graph_rrd_sv set hash='ce425fed4eb3174e4f1cde9713eeafa0' where id=97;");
db_execute("update snmp_query_graph_rrd_sv set hash='d0d05156ddb2c65181588db4b64d3907' where id=98;");
db_execute("update snmp_query_graph_rrd_sv set hash='3b018f789ff72cc5693ef79e3a794370' where id=99;");
db_execute("update snmp_query_graph_sv set hash='f434ec853c479d424276f367e9806a75' where id=41;");
db_execute("update snmp_query_graph_sv set hash='9b085245847444c5fb90ebbf4448e265' where id=42;");
db_execute("update snmp_query_graph_sv set hash='5977863f28629bd8eb93a2a9cbc3e306' where id=43;");
db_execute("update snmp_query_graph set hash='f85386cd2fc94634ef167c7f1e5fbcd0' where id=21;");
db_execute("update snmp_query_graph_rrd_sv set hash='b225229dbbb48c1766cf90298674ceed' where id=100;");
db_execute("update snmp_query_graph_rrd_sv set hash='c79248ddbbd195907260887b021a055d' where id=101;");
db_execute("update snmp_query_graph_rrd_sv set hash='12a6750d973b7f14783f205d86220082' where id=102;");
db_execute("update snmp_query_graph_rrd_sv set hash='25b151fcfe093812cb5c208e36dd697e' where id=103;");
db_execute("update snmp_query_graph_rrd_sv set hash='e9ab404a294e406c20fdd30df766161f' where id=104;");
db_execute("update snmp_query_graph_sv set hash='37b6711af3930c56309cf8956d8bbf14' where id=44;");
db_execute("update snmp_query_graph_sv set hash='cc435c5884a75421329a9b08207c1c90' where id=45;");
db_execute("update snmp_query_graph_sv set hash='82edeea1ec249c9818773e3145836492' where id=46;");
db_execute("update snmp_query_graph set hash='7d309bf200b6e3cdb59a33493c2e58e0' where id=22;");
db_execute("update snmp_query_graph_rrd_sv set hash='119578a4f01ab47e820b0e894e5e5bb3' where id=105;");
db_execute("update snmp_query_graph_rrd_sv set hash='940e57d24b2623849c77b59ed05931b9' where id=106;");
db_execute("update snmp_query_graph_rrd_sv set hash='0f045eab01bbc4437b30da568ed5cb03' where id=107;");
db_execute("update snmp_query_graph_rrd_sv set hash='bd70bf71108d32f0bf91b24c85b87ff0' where id=108;");
db_execute("update snmp_query_graph_rrd_sv set hash='fdc4cb976c4b9053bfa2af791a21c5b5' where id=109;");
db_execute("update snmp_query_graph_sv set hash='87522150ee8a601b4d6a1f6b9e919c47' where id=47;");
db_execute("update snmp_query_graph_sv set hash='993a87c04f550f1209d689d584aa8b45' where id=48;");
db_execute("update snmp_query_graph_sv set hash='183bb486c92a566fddcb0585ede37865' where id=49;");
db_execute("update snmp_query set hash='3c1b27d94ad208a0090f293deadde753' where id=2;");
db_execute("update snmp_query_graph set hash='da43655bf1f641b07579256227806977' where id=6;");
db_execute("update snmp_query_graph_rrd_sv set hash='5d3a8b2f4a454e5b0a1494e00fe7d424' where id=10;");
db_execute("update snmp_query_graph_sv set hash='437918b8dcd66a64625c6cee481fff61' where id=7;");
db_execute("update snmp_query set hash='59aab7b0feddc7860002ed9303085ba5' where id=3;");
db_execute("update snmp_query_graph set hash='1cc468ef92a5779d37a26349e27ef3ba' where id=7;");
db_execute("update snmp_query_graph_rrd_sv set hash='d0b49af67a83c258ef1eab3780f7b3dc' where id=11;");
db_execute("update snmp_query_graph_rrd_sv set hash='bf6b966dc369f3df2ea640a90845e94c' where id=12;");
db_execute("update snmp_query_graph_sv set hash='2ddc61ff4bd9634f33aedce9524b7690' where id=5;");
db_execute("update snmp_query_graph set hash='bef2dc94bc84bf91827f45424aac8d2a' where id=8;");
db_execute("update snmp_query_graph_rrd_sv set hash='5c3616603a7ac9d0c1cb9556b377a74f' where id=13;");
db_execute("update snmp_query_graph_rrd_sv set hash='080f0022f77044a512b083e3a8304e8b' where id=14;");
db_execute("update snmp_query_graph_sv set hash='c72e2da7af2cdbd6b44a5eb42c5b4758' where id=6;");
db_execute("update snmp_query set hash='ad06f46e22e991cb47c95c7233cfaee8' where id=4;");
db_execute("update snmp_query_graph set hash='5a5ce35edb4b195cbde99fd0161dfb4e' where id=10;");
db_execute("update snmp_query_graph_rrd_sv set hash='8fc9a94a5f6ef902a3de0fa7549e7476' where id=29;");
db_execute("update snmp_query_graph_sv set hash='a412c5dfa484b599ec0f570979fdbc9e' where id=11;");
db_execute("update snmp_query_graph set hash='c1c2cfd33eaf5064300e92e26e20bc56' where id=11;");
db_execute("update snmp_query_graph_rrd_sv set hash='8132fa9c446e199732f0102733cb1714' where id=30;");
db_execute("update snmp_query_graph_sv set hash='48f4792dd49fefd7d640ec46b1d7bdb3' where id=12;");
db_execute("update snmp_query set hash='8ffa36c1864124b38bcda2ae9bd61f46' where id=6;");
db_execute("update snmp_query_graph set hash='a0b3e7b63c2e66f9e1ea24a16ff245fc' where id=15;");
db_execute("update snmp_query_graph_rrd_sv set hash='cb09784ba05e401a3f1450126ed1e395' where id=69;");
db_execute("update snmp_query_graph_sv set hash='f21b23df740bc4a2d691d2d7b1b18dba' where id=30;");
db_execute("update snmp_query set hash='30ec734bc0ae81a3d995be82c73f46c1' where id=7;");
db_execute("update snmp_query_graph set hash='f6db4151aa07efa401a0af6c9b871844' where id=17;");
db_execute("update snmp_query_graph_rrd_sv set hash='42277993a025f1bfd85374d6b4deeb60' where id=92;");
db_execute("update snmp_query_graph_sv set hash='d99f8db04fd07bcd2260d246916e03da' where id=40;");
db_execute("update snmp_query set hash='9343eab1f4d88b0e61ffc9d020f35414' where id=8;");
db_execute("update snmp_query_graph set hash='46c4ee688932cf6370459527eceb8ef3' where id=18;");
db_execute("update snmp_query_graph_rrd_sv set hash='a3f280327b1592a1a948e256380b544f' where id=93;");
db_execute("update snmp_query_graph_sv set hash='9852782792ede7c0805990e506ac9618' where id=38;");
db_execute("update snmp_query set hash='0d1ab53fe37487a5d0b9e1d3ee8c1d0d' where id=9;");
db_execute("update snmp_query_graph set hash='4a515b61441ea5f27ab7dee6c3cb7818' where id=19;");
db_execute("update snmp_query_graph_rrd_sv set hash='b5a724edc36c10891fa2a5c370d55b6f' where id=94;");
db_execute("update snmp_query_graph_sv set hash='fa2f07ab54fce72eea684ba893dd9c95' where id=39;");
db_execute("update host_template set hash='4855b0e3e553085ed57219690285f91f' where id=1;");
db_execute("update host_template set hash='07d3fe6a52915f99e642d22e27d967a4' where id=3;");
db_execute("update host_template set hash='4e5dc8dd115264c2e9f3adb725c29413' where id=4;");
db_execute("update host_template set hash='cae6a879f86edacb2471055783bec6d0' where id=5;");
db_execute("update host_template set hash='9ef418b4251751e09c3c416704b01b01' where id=6;");
db_execute("update host_template set hash='5b8300be607dce4f030b026a381b91cd' where id=7;");
db_execute("update host_template set hash='2d3e47f416738c2d22c87c40218cc55e' where id=8;");
db_execute("update rra set hash='c21df5178e5c955013591239eb0afd46' where id=1;");
db_execute("update rra set hash='0d9c0af8b8acdc7807943937b3208e29' where id=2;");
db_execute("update rra set hash='6fc2d038fb42950138b0ce3e9874cc60' where id=3;");
db_execute("update rra set hash='e36f3adb9f152adfa5dc50fd2b23337e' where id=4;");
$item = db_fetch_assoc("select id from cdef");
for ($i=0; $i<count($item); $i++) {
db_execute("update cdef set hash='" . get_hash_cdef($item[$i]["id"]) . "' where id=" . $item[$i]["id"] . ";");
$item2 = db_fetch_assoc("select id from cdef_items where cdef_id=" . $item[$i]["id"]);
for ($j=0; $j<count($item2); $j++) {
db_execute("update cdef_items set hash='" . get_hash_cdef($item2[$j]["id"], "cdef_item") . "' where id=" . $item2[$j]["id"] . ";");
}
}
$item = db_fetch_assoc("select id from graph_templates_gprint");
for ($i=0; $i<count($item); $i++) {
db_execute("update graph_templates_gprint set hash='" . get_hash_gprint($item[$i]["id"]) . "' where id=" . $item[$i]["id"] . ";");
}
$item = db_fetch_assoc("select id from data_input");
for ($i=0; $i<count($item); $i++) {
db_execute("update data_input set hash='" . get_hash_data_input($item[$i]["id"]) . "' where id=" . $item[$i]["id"] . ";");
$item2 = db_fetch_assoc("select id from data_input_fields where data_input_id=" . $item[$i]["id"]);
for ($j=0; $j<count($item2); $j++) {
db_execute("update data_input_fields set hash='" . get_hash_data_input($item2[$j]["id"], "data_input_field") . "' where id=" . $item2[$j]["id"] . ";");
}
}
$item = db_fetch_assoc("select id from data_template");
for ($i=0; $i<count($item); $i++) {
db_execute("update data_template set hash='" . get_hash_data_template($item[$i]["id"]) . "' where id=" . $item[$i]["id"] . ";");
$item2 = db_fetch_assoc("select id from data_template_rrd where data_template_id=" . $item[$i]["id"] . " and local_data_id=0");
for ($j=0; $j<count($item2); $j++) {
db_execute("update data_template_rrd set hash='" . get_hash_data_template($item2[$j]["id"], "data_template_item") . "' where id=" . $item2[$j]["id"] . ";");
}
}
$item = db_fetch_assoc("select id from graph_templates");
for ($i=0; $i<count($item); $i++) {
db_execute("update graph_templates set hash='" . get_hash_graph_template($item[$i]["id"]) . "' where id=" . $item[$i]["id"] . ";");
$item2 = db_fetch_assoc("select id from graph_templates_item where graph_template_id=" . $item[$i]["id"] . " and local_graph_id=0");
for ($j=0; $j<count($item2); $j++) {
db_execute("update graph_templates_item set hash='" . get_hash_graph_template($item2[$j]["id"], "graph_template_item") . "' where id=" . $item2[$j]["id"] . ";");
}
$item2 = db_fetch_assoc("select id from graph_template_input where graph_template_id=" . $item[$i]["id"]);
for ($j=0; $j<count($item2); $j++) {
db_execute("update graph_template_input set hash='" . get_hash_graph_template($item2[$j]["id"], "graph_template_input") . "' where id=" . $item2[$j]["id"] . ";");
}
}
$item = db_fetch_assoc("select id from snmp_query");
for ($i=0; $i<count($item); $i++) {
db_execute("update snmp_query set hash='" . get_hash_data_query($item[$i]["id"]) . "' where id=" . $item[$i]["id"] . ";");
$item2 = db_fetch_assoc("select id from snmp_query_graph where snmp_query_id=" . $item[$i]["id"]);
for ($j=0; $j<count($item2); $j++) {
db_execute("update snmp_query_graph set hash='" . get_hash_data_query($item2[$j]["id"], "data_query_graph") . "' where id=" . $item2[$j]["id"] . ";");
$item3 = db_fetch_assoc("select id from snmp_query_graph_rrd_sv where snmp_query_graph_id=" . $item2[$j]["id"]);
for ($k=0; $k<count($item3); $k++) {
db_execute("update snmp_query_graph_rrd_sv set hash='" . get_hash_data_query($item3[$k]["id"], "data_query_sv_data_source") . "' where id=" . $item3[$k]["id"] . ";");
}
$item3 = db_fetch_assoc("select id from snmp_query_graph_sv where snmp_query_graph_id=" . $item2[$j]["id"]);
for ($k=0; $k<count($item3); $k++) {
db_execute("update snmp_query_graph_sv set hash='" . get_hash_data_query($item3[$k]["id"], "data_query_sv_graph") . "' where id=" . $item3[$k]["id"] . ";");
}
}
}
$item = db_fetch_assoc("select id from host_template");
for ($i=0; $i<count($item); $i++) {
db_execute("update host_template set hash='" . get_hash_host_template($item[$i]["id"]) . "' where id=" . $item[$i]["id"] . ";");
}
$item = db_fetch_assoc("select id from rra");
for ($i=0; $i<count($item); $i++) {
db_execute("update rra set hash='" . get_hash_round_robin_archive($item[$i]["id"]) . "' where id=" . $item[$i]["id"] . ";");
}
}
function upgrade_to_0_8_8d()
{
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `user_auth_group` (\n\t\t`id` int(10) unsigned NOT NULL auto_increment,\n\t\t`name` varchar(20) NOT NULL,\n\t\t`description` varchar(255) NOT NULL default '',\n\t\t`graph_settings` varchar(2) DEFAULT NULL,\n\t\t`login_opts` tinyint(1) NOT NULL DEFAULT '1',\n\t\t`show_tree` varchar(2) DEFAULT 'on',\n\t\t`show_list` varchar(2) DEFAULT 'on',\n\t\t`show_preview` varchar(2) NOT NULL DEFAULT 'on',\n\t\t`policy_graphs` tinyint(1) unsigned NOT NULL DEFAULT '1',\n\t\t`policy_trees` tinyint(1) unsigned NOT NULL DEFAULT '1',\n\t\t`policy_hosts` tinyint(1) unsigned NOT NULL DEFAULT '1',\n\t\t`policy_graph_templates` tinyint(1) unsigned NOT NULL DEFAULT '1',\n\t\t`enabled` char(2) NOT NULL DEFAULT 'on',\n\t\tPRIMARY KEY (`id`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Table that Contains User Groups';");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `user_auth_group_perms` (\n\t\t`group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',\n\t\t`item_id` mediumint(8) unsigned NOT NULL DEFAULT '0',\n\t\t`type` tinyint(2) unsigned NOT NULL DEFAULT '0',\n\t\tPRIMARY KEY (`group_id`,`item_id`,`type`),\n\t\tKEY `group_id` (`group_id`,`type`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Table that Contains User Group Permissions';");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `user_auth_group_realm` (\n\t\t`group_id` int(10) unsigned NOT NULL,\n\t\t`realm_id` int(10) unsigned NOT NULL,\n\t\tPRIMARY KEY (`group_id`, `realm_id`),\n\t\tKEY `group_id` (`group_id`),\n\t\tKEY `realm_id` (`realm_id`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Table that Contains User Group Realm Permissions';");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `user_auth_group_members` (\n\t\t`group_id` int(10) unsigned NOT NULL,\n\t\t`user_id` int(10) unsigned NOT NULL,\n\t\tPRIMARY KEY (`group_id`, `user_id`),\n\t\tKEY `group_id` (`group_id`),\n\t\tKEY `realm_id` (`user_id`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Table that Contains User Group Members';");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `settings_graphs_group` (\n\t\t`group_id` smallint(8) unsigned NOT NULL DEFAULT '0',\n\t\t`name` varchar(50) NOT NULL DEFAULT '',\n\t\t`value` varchar(255) NOT NULL DEFAULT '',\n\t\tPRIMARY KEY (`group_id`,`name`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Stores the Default User Group Graph Settings';");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `data_source_stats_daily` (\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL,\n\t\t`rrd_name` varchar(19) NOT NULL,\n\t\t`average` DOUBLE DEFAULT NULL,\n\t\t`peak` DOUBLE DEFAULT NULL,\n\t\tPRIMARY KEY (`local_data_id`,`rrd_name`)\n\t\t) ENGINE=MyISAM;");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `data_source_stats_hourly` (\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL,\n\t\t`rrd_name` varchar(19) NOT NULL,\n\t\t`average` DOUBLE DEFAULT NULL,\n\t\t`peak` DOUBLE DEFAULT NULL,\n\t\tPRIMARY KEY (`local_data_id`,`rrd_name`)\n\t\t) ENGINE=MyISAM;");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `data_source_stats_hourly_cache` (\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL,\n\t\t`rrd_name` varchar(19) NOT NULL,\n\t\t`time` timestamp NOT NULL default '0000-00-00 00:00:00',\n\t\t`value` DOUBLE DEFAULT NULL,\n\t\tPRIMARY KEY (`local_data_id`,`time`,`rrd_name`),\n\t\tKEY `time` USING BTREE (`time`)\n\t\t) ENGINE=MEMORY;");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `data_source_stats_hourly_last` (\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL,\n\t\t`rrd_name` varchar(19) NOT NULL,\n\t\t`value` DOUBLE DEFAULT NULL,\n\t\t`calculated` DOUBLE DEFAULT NULL,\n\t\tPRIMARY KEY (`local_data_id`,`rrd_name`)\n\t\t) ENGINE=MEMORY;");
if (!sizeof(db_fetch_row("SHOW COLUMNS from data_source_stats_hourly_last where Field='calculated'"))) {
db_install_execute('0.8.8d', "ALTER TABLE data_source_stats_hourly_last ADD calculated DOUBLE DEFAULT NULL AFTER `value`");
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `data_source_stats_monthly` (\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL,\n\t\t`rrd_name` varchar(19) NOT NULL,\n\t\t`average` DOUBLE DEFAULT NULL,\n\t\t`peak` DOUBLE DEFAULT NULL,\n\t\tPRIMARY KEY (`local_data_id`,`rrd_name`)\n\t\t) ENGINE=MyISAM;");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `data_source_stats_weekly` (\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL,\n\t\t`rrd_name` varchar(19) NOT NULL,\n\t\t`average` DOUBLE DEFAULT NULL,\n\t\t`peak` DOUBLE DEFAULT NULL,\n\t\tPRIMARY KEY (`local_data_id`,`rrd_name`)\n\t\t) ENGINE=MyISAM;");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `data_source_stats_yearly` (\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL,\n\t\t`rrd_name` varchar(19) NOT NULL,\n\t\t`average` DOUBLE DEFAULT NULL,\n\t\t`peak` DOUBLE DEFAULT NULL,\n\t\tPRIMARY KEY (`local_data_id`,`rrd_name`)\n\t\t) ENGINE=MyISAM;");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `poller_output_boost` (\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL default '0',\n\t\t`rrd_name` varchar(19) NOT NULL default '',\n\t\t`time` datetime NOT NULL default '0000-00-00 00:00:00',\n\t\t`output` varchar(512) NOT NULL,\n\t\tPRIMARY KEY USING BTREE (`local_data_id`,`time`,`rrd_name`))\n\t\tENGINE=MEMORY;");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `poller_output_boost_processes` (\n\t\t`sock_int_value` bigint(20) unsigned NOT NULL auto_increment,\n\t\t`status` varchar(255) default NULL,\n\t\tPRIMARY KEY (`sock_int_value`))\n\t\tENGINE=MEMORY;");
if (db_table_exists('plugin_domains')) {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_domains TO user_domains');
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `user_domains` (\n\t\t`domain_id` int(10) unsigned NOT NULL auto_increment,\n\t\t`domain_name` varchar(20) NOT NULL,\n\t\t`type` int(10) UNSIGNED NOT NULL DEFAULT '0',\n\t\t`enabled` char(2) NOT NULL DEFAULT 'on',\n\t\t`defdomain` tinyint(3) NOT NULL DEFAULT '0',\n\t\t`user_id` int(10) unsigned NOT NULL default '0',\n\t\tPRIMARY KEY (`domain_id`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Table to Hold Login Domains';");
if (db_table_exists('plugin_domains_ldsp')) {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_domains_ldsp TO user_domains_ldap');
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `user_domains_ldap` (\n\t\t`domain_id` int(10) unsigned NOT NULL,\n\t\t`server` varchar(128) NOT NULL,\n\t\t`port` int(10) unsigned NOT NULL,\n\t\t`port_ssl` int(10) unsigned NOT NULL,\n\t\t`proto_version` tinyint(3) unsigned NOT NULL,\n\t\t`encryption` tinyint(3) unsigned NOT NULL,\n\t\t`referrals` tinyint(3) unsigned NOT NULL,\n\t\t`mode` tinyint(3) unsigned NOT NULL,\n\t\t`dn` varchar(128) NOT NULL,\n\t\t`group_require` char(2) NOT NULL,\n\t\t`group_dn` varchar(128) NOT NULL,\n\t\t`group_attrib` varchar(128) NOT NULL,\n\t\t`group_member_type` tinyint(3) unsigned NOT NULL,\n\t\t`search_base` varchar(128) NOT NULL,\n\t\t`search_filter` varchar(128) NOT NULL,\n\t\t`specific_dn` varchar(128) NOT NULL,\n\t\t`specific_password` varchar(128) NOT NULL,\n\t\tPRIMARY KEY (`domain_id`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Table to Hold Login Domains for LDAP';");
if (db_table_exists('plugin_snmpagent_cache')) {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_snmpagent_cache TO snmpagent_cache');
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `snmpagent_cache` (\n\t\t`oid` varchar(255) NOT NULL,\n\t\t`name` varchar(255) NOT NULL,\n\t\t`mib` varchar(255) NOT NULL,\n\t\t`type` varchar(255) NOT NULL DEFAULT '',\n\t\t`otype` varchar(255) NOT NULL DEFAULT '',\n\t\t`kind` varchar(255) NOT NULL DEFAULT '',\n\t\t`max-access` varchar(255) NOT NULL DEFAULT 'not-accessible',\n\t\t`value` varchar(255) NOT NULL DEFAULT '',\n\t\t`description` varchar(5000) NOT NULL DEFAULT '',\n\t\tPRIMARY KEY (`oid`),\n\t\tKEY `name` (`name`),\n\t\tKEY `mib` (`mib`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='SNMP MIB CACHE';");
if (db_table_exists('plugin_snmpagent_mibs')) {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_snmpagent_mibs TO snmpagent_mibs');
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `snmpagent_mibs` (\n\t\t`id` int(8) NOT NULL AUTO_INCREMENT,\n\t\t`name` varchar(32) NOT NULL DEFAULT '',\n\t\t`file` varchar(255) NOT NULL DEFAULT '',\n\t\tPRIMARY KEY (`id`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Registered MIB files';");
if (db_table_exists('plugin_snmpagent_cache_notifications')) {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_snmpagent_cache_notifications TO snmpagent_cache_notifications');
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `snmpagent_cache_notifications` (\n\t\t`name` varchar(255) NOT NULL,\n\t\t`mib` varchar(255) NOT NULL,\n\t\t`attribute` varchar(255) NOT NULL,\n\t\t`sequence_id` smallint(6) NOT NULL,\n\t\tKEY `name` (`name`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Notifcations and related attributes';");
if (db_table_exists('plugin_snmpagent_cache_textual_conventions')) {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_snmpagent_cache_textual_conventions TO snmpagent_cache_textual_conventions');
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `snmpagent_cache_textual_conventions` (\n\t\t`name` varchar(255) NOT NULL,\n\t\t`mib` varchar(255) NOT NULL,\n\t\t`type` varchar(255) NOT NULL DEFAULT '',\n\t\t`description` varchar(5000) NOT NULL DEFAULT '',\n\t\tKEY `name` (`name`),\n\t\tKEY `mib` (`mib`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='Textual conventions';");
if (db_table_exists('plugin_snmpagent_managers')) {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_snmpagent_managers TO snmpagent_managers');
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `snmpagent_managers` (\n\t\t`id` int(8) NOT NULL AUTO_INCREMENT,\n\t\t`hostname` varchar(255) NOT NULL,\n\t\t`description` varchar(255) NOT NULL,\n\t\t`disabled` char(2) DEFAULT NULL,\n\t\t`max_log_size` tinyint(1) NOT NULL,\n\t\t`snmp_version` varchar(255) NOT NULL,\n\t\t`snmp_community` varchar(255) NOT NULL,\n\t\t`snmp_username` varchar(255) NOT NULL,\n\t\t`snmp_auth_password` varchar(255) NOT NULL,\n\t\t`snmp_auth_protocol` varchar(255) NOT NULL,\n\t\t`snmp_priv_password` varchar(255) NOT NULL,\n\t\t`snmp_priv_protocol` varchar(255) NOT NULL,\n\t\t`snmp_port` varchar(255) NOT NULL,\n\t\t`snmp_message_type` tinyint(1) NOT NULL,\n\t\t`notes` text,\n\t\tPRIMARY KEY (`id`),\n\t\tKEY `hostname` (`hostname`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='snmp notification receivers';");
if (db_table_exists('plugin_snmpagent_managers_notifications')) {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_snmpagent_managers_notifications TO snmpagent_managers_notifications');
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `snmpagent_managers_notifications` (\n\t\t`manager_id` int(8) NOT NULL,\n\t\t`notification` varchar(255) NOT NULL,\n\t\t`mib` varchar(255) NOT NULL,\n\t\tKEY `mib` (`mib`),\n\t\tKEY `manager_id` (`manager_id`),\n\t\tKEY `manager_id2` (`manager_id`,`notification`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='snmp notifications to receivers';");
if (db_table_exists('plugin_snmpagent_notifications_log')) {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_snmpagent_notifications_log TO snmpagent_notifications_log');
}
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `snmpagent_notifications_log` (\n\t\t`id` int(12) NOT NULL AUTO_INCREMENT,\n\t\t`time` int(24) NOT NULL,\n\t\t`severity` tinyint(1) NOT NULL,\n\t\t`manager_id` int(8) NOT NULL,\n\t\t`notification` varchar(255) NOT NULL,\n\t\t`mib` varchar(255) NOT NULL,\n\t\t`varbinds` varchar(5000) NOT NULL,\n\t\tPRIMARY KEY (`id`),\n\t\tKEY `time` (`time`),\n\t\tKEY `severity` (`severity`),\n\t\tKEY `manager_id` (`manager_id`),\n\t\tKEY `manager_id2` (`manager_id`,`notification`))\n\t\tENGINE=MyISAM\n\t\tCOMMENT='logs snmp notifications to receivers';");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `data_source_purge_temp` (\n\t\t`id` integer UNSIGNED auto_increment,\n\t\t`name_cache` varchar(255) NOT NULL default '',\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL default '0',\n\t\t`name` varchar(128) NOT NULL default '',\n\t\t`size` integer UNSIGNED NOT NULL default '0',\n\t\t`last_mod` TIMESTAMP NOT NULL default '0000-00-00 00:00:00',\n\t\t`in_cacti` tinyint NOT NULL default '0',\n\t\t`data_template_id` mediumint(8) unsigned NOT NULL default '0',\n\t\tPRIMARY KEY (`id`),\n\t\tUNIQUE KEY name (`name`), \n\t\tKEY local_data_id (`local_data_id`), \n\t\tKEY in_cacti (`in_cacti`), \n\t\tKEY data_template_id (`data_template_id`)) \n\t\tENGINE=MyISAM \n\t\tCOMMENT='RRD Cleaner File Repository';");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `data_source_purge_action` (\n\t\t`id` integer UNSIGNED auto_increment,\n\t\t`name` varchar(128) NOT NULL default '',\n\t\t`local_data_id` mediumint(8) unsigned NOT NULL default '0',\n\t\t`action` tinyint(2) NOT NULL default 0,\n\t\tPRIMARY KEY (`id`),\n\t\tUNIQUE KEY name (`name`))\n\t\tENGINE=MyISAM \n\t\tCOMMENT='RRD Cleaner File Actions';");
db_install_execute('0.8.8d', "ALTER TABLE graph_tree \n\t\tADD COLUMN enabled char(2) DEFAULT 'on' AFTER id,\n\t\tADD COLUMN locked TINYINT default '0' AFTER enabled, \n\t\tADD COLUMN locked_date TIMESTAMP default '0000-00-00' AFTER locked, \n\t\tADD COLUMN last_modified TIMESTAMP default '0000-00-00' AFTER name, \n\t\tADD COLUMN user_id INT UNSIGNED default '1' AFTER name, \n\t\tADD COLUMN modified_by INT UNSIGNED default '1'");
db_install_execute('0.8.8d', "ALTER TABLE graph_tree_items \n\t\tMODIFY COLUMN id BIGINT UNSIGNED NOT NULL auto_increment, \n\t\tADD COLUMN parent BIGINT UNSIGNED default NULL AFTER id, \n\t\tADD COLUMN position int UNSIGNED default NULL AFTER parent,\n\t\tADD INDEX parent (parent)");
db_install_execute('0.8.8d', "CREATE TABLE IF NOT EXISTS `user_auth_cache` (\n\t\t`user_id` int(10) unsigned NOT NULL DEFAULT '0',\n\t\t`hostname` varchar(64) NOT NULL DEFAULT '',\n\t\t`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n\t\t`token` varchar(1024) NOT NULL DEFAULT '') \n\t\tENGINE=MyISAM \n\t\tCOMMENT='Caches Remember Me Details'");
// Add secpass fields
db_install_add_column('0.8.8d', 'user_auth', array('name' => 'lastchange', 'type' => 'int(12)', 'NULL' => false, 'default' => '-1'));
db_install_add_column('0.8.8d', 'user_auth', array('name' => 'lastlogin', 'type' => 'int(12)', 'NULL' => false, 'default' => '-1'));
db_install_add_column('0.8.8d', 'user_auth', array('name' => 'password_history', 'type' => 'text', 'NULL' => false, 'default' => ''));
db_install_add_column('0.8.8d', 'user_auth', array('name' => 'locked', 'type' => 'varchar(3)', 'NULL' => false, 'default' => ''));
db_install_add_column('0.8.8d', 'user_auth', array('name' => 'failed_attempts', 'type' => 'int(5)', 'NULL' => false, 'default' => '0'));
db_install_add_column('0.8.8d', 'user_auth', array('name' => 'lastfail', 'type' => 'int(12)', 'NULL' => false, 'default' => '0'));
// Convert all trees to new format, but never run more than once
$columns = array_rekey(db_fetch_assoc("SHOW COLUMNS FROM graph_tree_items"), "Field", array("Type", "Null", "Key", "Default", "Extra"));
if (isset($columns['order_key'])) {
$trees = db_fetch_assoc("SELECT id FROM graph_tree ORDER BY id");
if (sizeof($trees)) {
foreach ($trees as $t) {
$tree_items = db_fetch_assoc("SELECT * \n\t\t\t\tFROM graph_tree_items \n\t\t\t\tWHERE graph_tree_id=" . $t['id'] . " \n\t\t\t\tAND order_key NOT LIKE '___000%' \n\t\t\t\tORDER BY order_key");
/* reset the position variable in case we run more than once */
db_execute("UPDATE graph_tree_items SET position=0 WHERE graph_tree_id=" . $t['id']);
$prev_parent = 0;
$prev_id = 0;
$position = 0;
if (sizeof($tree_items)) {
foreach ($tree_items as $item) {
$translated_key = rtrim($item["order_key"], "0\r\n");
$missing_len = strlen($translated_key) % CHARS_PER_TIER;
if ($missing_len > 0) {
$translated_key .= substr("000", 0, $missing_len);
}
$parent_key_len = strlen($translated_key) - CHARS_PER_TIER;
$parent_key = substr($translated_key, 0, $parent_key_len);
$parent_id = db_fetch_cell("SELECT id FROM graph_tree_items WHERE graph_tree_id=" . $item["graph_tree_id"] . " AND order_key LIKE '" . $parent_key . "000%'");
if (!empty($parent_id)) {
/* get order */
if ($parent_id != $prev_parent) {
$position = 0;
}
$position = db_fetch_cell("SELECT MAX(position) \n\t\t\t\t\t\t\tFROM graph_tree_items \n\t\t\t\t\t\t\tWHERE graph_tree_id=" . $item['graph_tree_id'] . " \n\t\t\t\t\t\t\tAND parent=" . $parent_id) + 1;
db_execute("UPDATE graph_tree_items SET parent={$parent_id}, position={$position} WHERE id=" . $item["id"]);
} else {
db_execute("UPDATE graph_tree_items SET parent=0, position={$position} WHERE id=" . $item["id"]);
}
$prev_parent = $parent_id;
}
}
/* get base tree items and set position */
$tree_items = db_fetch_assoc("SELECT * \n\t\t\t\tFROM graph_tree_items\n\t\t\t\tWHERE graph_tree_id=" . $t['id'] . " \n\t\t\t\tAND order_key LIKE '___000%' \n\t\t\t\tORDER BY order_key");
$position = 0;
if (sizeof($tree_items)) {
foreach ($tree_items as $item) {
db_execute("UPDATE graph_tree_items SET parent=0, position={$position} WHERE id=" . $item['id']);
$position++;
}
}
}
}
db_install_execute('0.8.8d', "ALTER TABLE graph_tree_items DROP COLUMN order_key");
}
/* merge of clog */
/* clog user = 19 */
/* dlog admin = 18 */
$realms = db_fetch_assoc("SELECT * FROM plugin_realms WHERE plugin = 'clog'");
if (sizeof($realms)) {
foreach ($realms as $r) {
if ($r['file'] == 'clog.php') {
db_execute("UPDATE user_auth_realm SET realm_id=18 WHERE realm_id=" . ($r['id'] + 100));
} elseif ($r['file'] == 'clog_user.php') {
db_execute("UPDATE user_auth_realm SET realm_id=19 WHERE realm_id=" . ($r['id'] + 100));
}
}
}
db_install_execute('0.8.8d', "DELETE FROM plugin_realms WHERE file LIKE 'clog%'");
db_install_execute('0.8.8d', "DELETE FROM plugin_config WHERE directory='clog'");
db_install_execute('0.8.8d', "DELETE FROM plugin_hooks WHERE name='clog'");
snmpagent_cache_install();
// Adding email column for future user
db_install_add_column('0.8.8d', 'user_auth', array('name' => 'email_address', 'type' => 'varchar(128)', 'NULL' => true, 'after' => 'full_name'));
db_install_execute('0.8.8d', 'DROP TABLE IF EXISTS poller_output_realtime');
db_install_execute('0.8.8d', "CREATE TABLE poller_output_realtime (\n\t\tlocal_data_id mediumint(8) unsigned NOT NULL default '0',\n\t\trrd_name varchar(19) NOT NULL default '',\n\t\ttime timestamp NOT NULL default '0000-00-00 00:00:00',\n\t\toutput text NOT NULL,\n\t\tpoller_id varchar(30) NOT NULL default '',\n\t\tPRIMARY KEY (local_data_id,rrd_name,`time`),\n\t\tKEY poller_id(poller_id)) \n\t\tENGINE=MyISAM");
db_install_execute('0.8.8d', 'DROP TABLE IF EXISTS poller_output_rt');
db_install_execute('0.8.8d', "DELETE FROM plugin_realms WHERE file LIKE '%graph_image_rt%'");
db_install_execute('0.8.8d', "DELETE FROM plugin_config WHERE directory='realtime'");
db_install_execute('0.8.8d', "DELETE FROM plugin_hooks WHERE name='realtime'");
// If we have never install Nectar before, we can simply install
if (!sizeof(db_fetch_row("SHOW TABLES LIKE '%plugin_nectar%'"))) {
db_install_execute('0.8.8d', "CREATE TABLE `reports` (\n\t\t\t`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n\t\t\t`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',\n\t\t\t`name` varchar(100) NOT NULL DEFAULT '',\n\t\t\t`cformat` char(2) NOT NULL DEFAULT '',\n\t\t\t`format_file` varchar(255) NOT NULL DEFAULT '',\n\t\t\t`font_size` smallint(2) unsigned NOT NULL DEFAULT '0',\n\t\t\t`alignment` smallint(2) unsigned NOT NULL DEFAULT '0',\n\t\t\t`graph_linked` char(2) NOT NULL DEFAULT '',\n\t\t\t`intrvl` smallint(2) unsigned NOT NULL DEFAULT '0',\n\t\t\t`count` smallint(2) unsigned NOT NULL DEFAULT '0',\n\t\t\t`offset` int(12) unsigned NOT NULL DEFAULT '0',\n\t\t\t`mailtime` bigint(20) unsigned NOT NULL DEFAULT '0',\n\t\t\t`subject` varchar(64) NOT NULL DEFAULT '',\n\t\t\t`from_name` varchar(40) NOT NULL,\n\t\t\t`from_email` text NOT NULL,\n\t\t\t`email` text NOT NULL,\n\t\t\t`bcc` text NOT NULL,\n\t\t\t`attachment_type` smallint(2) unsigned NOT NULL DEFAULT '1',\n\t\t\t`graph_height` smallint(2) unsigned NOT NULL DEFAULT '0',\n\t\t\t`graph_width` smallint(2) unsigned NOT NULL DEFAULT '0',\n\t\t\t`graph_columns` smallint(2) unsigned NOT NULL DEFAULT '0',\n\t\t\t`thumbnails` char(2) NOT NULL DEFAULT '',\n\t\t\t`lastsent` bigint(20) unsigned NOT NULL DEFAULT '0',\n\t\t\t`enabled` char(2) DEFAULT '',\n\t\t\tPRIMARY KEY (`id`),\n\t\t\tKEY `mailtime` (`mailtime`)) \n\t\t\tENGINE=MyISAM \n\t\t\tCOMMENT='Cacri Reporting Reports'");
db_install_execute('0.8.8d', "CREATE TABLE `reports_items` (\n\t\t\t`id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n\t\t\t`report_id` int(10) unsigned NOT NULL DEFAULT '0',\n\t\t\t`item_type` tinyint(1) unsigned NOT NULL DEFAULT '1',\n\t\t\t`tree_id` int(10) unsigned NOT NULL DEFAULT '0',\n\t\t\t`branch_id` int(10) unsigned NOT NULL DEFAULT '0',\n\t\t\t`tree_cascade` char(2) NOT NULL DEFAULT '',\n\t\t\t`graph_name_regexp` varchar(128) NOT NULL DEFAULT '',\n\t\t\t`host_template_id` int(10) unsigned NOT NULL DEFAULT '0',\n\t\t\t`host_id` int(10) unsigned NOT NULL DEFAULT '0',\n\t\t\t`graph_template_id` int(10) unsigned NOT NULL DEFAULT '0',\n\t\t\t`local_graph_id` int(10) unsigned NOT NULL DEFAULT '0',\n\t\t\t`timespan` int(10) unsigned NOT NULL DEFAULT '0',\n\t\t\t`align` tinyint(1) unsigned NOT NULL DEFAULT '1',\n\t\t\t`item_text` text NOT NULL,\n\t\t\t`font_size` smallint(2) unsigned NOT NULL DEFAULT '10',\n\t\t\t`sequence` smallint(5) unsigned NOT NULL DEFAULT '0',\n\t\t\tPRIMARY KEY (`id`),\n\t\t\tKEY `report_id` (`report_id`)) \n\t\t\tENGINE=MyISAM \n\t\t\tCOMMENT='Cacti Reporting Items'");
} else {
db_install_execute('0.8.8d', 'RENAME TABLE plugin_nectar TO reports');
db_install_execute('0.8.8d', 'RENAME TABLE plugin_nectar_items TO reports_items');
db_install_execute('0.8.8d', "UPDATE settings SET name=REPLACE(name, 'nectar','reports') WHERE name LIKE '%nectar%'");
db_install_add_column('0.8.8d', 'reports', array('name' => 'bcc', 'type' => 'TEXT', 'after' => 'email'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'from_name', 'type' => 'VARCHAR(40)', 'NULL' => false, 'default' => '', 'after' => 'mailtime'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'user_id', 'type' => 'mediumint(8)', 'unsigned' => true, 'NULL' => false, 'default' => '0', 'after' => 'id'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'graph_width', 'type' => 'smallint(2)', 'unsigned' => true, 'NULL' => false, 'default' => '0', 'after' => 'attachment_type'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'graph_height', 'type' => 'smallint(2)', 'unsigned' => true, 'NULL' => false, 'default' => '0', 'after' => 'graph_width'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'graph_columns', 'type' => 'smallint(2)', 'unsigned' => true, 'NULL' => false, 'default' => '0', 'after' => 'graph_height'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'thumbnails', 'type' => 'char(2)', 'NULL' => false, 'default' => '', 'after' => 'graph_columns'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'font_size', 'type' => 'smallint(2)', 'NULL' => false, 'default' => '16', 'after' => 'name'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'alignment', 'type' => 'smallint(2)', 'NULL' => false, 'default' => '0', 'after' => 'font_size'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'cformat', 'type' => 'char(2)', 'NULL' => false, 'default' => '', 'after' => 'name'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'format_file', 'type' => 'varchar(255)', 'NULL' => false, 'default' => '', 'after' => 'cformat'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'graph_linked', 'type' => 'char(2)', 'NULL' => false, 'default' => '', 'after' => 'alignment'));
db_install_add_column('0.8.8d', 'reports', array('name' => 'subject', 'type' => 'varchar(64)', 'NULL' => false, 'default' => '', 'after' => 'mailtime'));
/* plugin_reports_items upgrade */
db_install_add_column('0.8.8d', 'reports_items', array('name' => 'host_template_id', 'type' => 'int(10)', 'unsigned' => true, 'NULL' => false, 'default' => '0', 'after' => 'item_type'));
db_install_add_column('0.8.8d', 'reports_items', array('name' => 'graph_template_id', 'type' => 'int(10)', 'unsigned' => true, 'NULL' => false, 'default' => '0', 'after' => 'host_id'));
db_install_add_column('0.8.8d', 'reports_items', array('name' => 'tree_id', 'type' => 'int(10)', 'unsigned' => true, 'NULL' => false, 'default' => '0', 'after' => 'item_type'));
db_install_add_column('0.8.8d', 'reports_items', array('name' => 'branch_id', 'type' => 'int(10)', 'unsigned' => true, 'NULL' => false, 'default' => '0', 'after' => 'tree_id'));
db_install_add_column('0.8.8d', 'reports_items', array('name' => 'tree_cascade', 'type' => 'char(2)', 'NULL' => false, 'default' => '', 'after' => 'branch_id'));
db_install_add_column('0.8.8d', 'reports_items', array('name' => 'graph_name_regexp', 'type' => 'varchar(128)', 'NULL' => false, 'default' => '', 'after' => 'tree_cascade'));
/* fix host templates and graph template ids */
$items = db_fetch_assoc("SELECT * FROM reports_items WHERE item_type=1");
if (sizeof($items)) {
foreach ($items as $row) {
$host = db_fetch_row("SELECT host.* \n\t\t\t\tFROM graph_local \n\t\t\t\tLEFT JOIN host \n\t\t\t\tON (graph_local.host_id=host.id) \n\t\t\t\tWHERE graph_local.id=" . $row["local_graph_id"]);
$graph_template = db_fetch_cell("SELECT graph_template_id \n\t\t\t\tFROM graph_local \n\t\t\t\tWHERE id=" . $row["local_graph_id"]);
db_execute("UPDATE reports_items SET " . " host_id='" . $host["id"] . "', " . " host_template_id='" . $host["host_template_id"] . "', " . " graph_template_id='" . $graph_template . "' " . " WHERE id=" . $row["id"]);
}
}
}
db_install_add_column('0.8.8d', 'host', array('name' => 'snmp_sysDescr', 'type' => 'varchar(300)', 'NULL' => false, 'default' => '', 'after' => 'snmp_timeout'));
db_install_add_column('0.8.8d', 'host', array('name' => 'snmp_sysObjectID', 'type' => 'varchar(64)', 'NULL' => false, 'default' => '', 'after' => 'snmp_sysDescr'));
db_install_add_column('0.8.8d', 'host', array('name' => 'snmp_sysUpTimeInstance', 'type' => 'int', 'NULL' => false, 'default' => '0', 'after' => 'snmp_sysObjectID', 'unsigned' => true));
db_install_add_column('0.8.8d', 'host', array('name' => 'snmp_sysContact', 'type' => 'varchar(300)', 'NULL' => false, 'default' => '', 'after' => 'snmp_sysUpTimeInstance'));
db_install_add_column('0.8.8d', 'host', array('name' => 'snmp_sysName', 'type' => 'varchar(300)', 'NULL' => false, 'default' => '', 'after' => 'snmp_sysContact'));
db_install_add_column('0.8.8d', 'host', array('name' => 'snmp_sysLocation', 'type' => 'varchar(300)', 'NULL' => false, 'default' => '', 'after' => 'snmp_sysName'));
db_install_add_column('0.8.8d', 'host', array('name' => 'polling_time', 'type' => 'DOUBLE', 'default' => '0', 'after' => 'avg_time'));
}
function db_install_add_column($cacti_version, $table, $column)
{
// Example: db_install_add_column ('plugin_config', array('name' => 'test' . rand(1, 200), 'type' => 'varchar (255)', 'NULL' => false));
global $config, $database_default;
$result = db_fetch_assoc('show columns from `' . $table . '`');
$columns = array();
foreach ($result as $index => $arr) {
foreach ($arr as $t) {
$columns[] = $t;
}
}
$sql = 'ALTER TABLE `' . $table . '` ADD `' . $column['name'] . '`';
if (isset($column['type'])) {
$sql .= ' ' . $column['type'];
}
if (isset($column['unsigned'])) {
$sql .= ' unsigned';
}
if (isset($column['NULL']) && $column['NULL'] == false) {
$sql .= ' NOT NULL';
}
if (isset($column['NULL']) && $column['NULL'] == true && !isset($column['default'])) {
$sql .= ' default NULL';
}
if (isset($column['default'])) {
$sql .= ' default ' . (is_numeric($column['default']) ? $column['default'] : "'" . $column['default'] . "'");
}
if (isset($column['auto_increment'])) {
$sql .= ' auto_increment';
}
if (isset($column['after'])) {
$sql .= ' AFTER ' . $column['after'];
}
if (isset($column['name']) && !in_array($column['name'], $columns)) {
db_install_execute($cacti_version, $sql);
} else {
$sql_install_cache = isset($_SESSION["sess_sql_install_cache"]) ? $_SESSION["sess_sql_install_cache"] : array();
$sql_install_cache[sizeof($sql_install_cache)][$cacti_version][2] = $sql;
$_SESSION["sess_sql_install_cache"] = $sql_install_cache;
}
}
function upgrade_to_0_8_2a()
{
db_install_execute("0.8.2a", "ALTER TABLE `data_input_data_cache` ADD `rrd_num` TINYINT( 2 ) UNSIGNED NOT NULL AFTER `rrd_path`;");
}
