1 2-- 3-- Allow MySQL to handle Cacti's legacy syntax 4-- 5 6DELIMITER // 7 8DROP FUNCTION IF EXISTS NOAUTOCREATENEEDED// 9CREATE FUNCTION NOAUTOCREATENEEDED() 10RETURNS BOOL 11READS SQL DATA 12DETERMINISTIC 13BEGIN 14 15DECLARE ret BOOL; 16DECLARE ismaria BOOL; 17 18DECLARE majv INT; 19DECLARE medv INT; 20DECLARE minv INT; 21 22DECLARE realversion VARCHAR(16); 23 24DECLARE majn INT; 25DECLARE medn INT; 26DECLARE minn INT; 27 28SET ret = TRUE; 29 30 31SELECT LOCATE('MariaDB', @@version) > 0 INTO ismaria; 32 33IF ismaria THEN 34 -- MariaDB version NO_AUTO_CREATE_USER started to be default 35 SET majn = 10; 36 SET medn = 1; 37 SET minn = 7; 38ELSE 39 -- MySQL version it started to be default (8.0.11) 40 SET majn = 8; 41 SET medn = 0; 42 SET minn = 11; 43END IF; 44 45SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@@VERSION, '.', 3),'-',1) INTO realversion; 46SELECT CONVERT(SUBSTRING_INDEX(realversion, '.', 1), SIGNED INTEGER) INTO majv; 47SELECT CONVERT(SUBSTRING_INDEX(SUBSTRING_INDEX(realversion, '.', 2), '.', -1), SIGNED INTEGER) INTO medv; 48SELECT CONVERT(SUBSTRING_INDEX(SUBSTRING_INDEX(realversion, '.', 3), '.', -1), SIGNED INTEGER) INTO minv; 49 50IF majv >= majn AND medv >= medn AND minv >= minn THEN 51 SET ret = FALSE; 52END IF; 53 54RETURN ret; 55END // 56 57DELIMITER ; 58 59SET @sqlmode= ""; 60SELECT IF(NOAUTOCREATENEEDED(), 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', 'NO_ENGINE_SUBSTITUTION') INTO @sqlmode; 61SET SESSION sql_mode = @sqlmode; 62 63-- 64-- Table structure for table `aggregate_graph_templates` 65-- 66 67CREATE TABLE `aggregate_graph_templates` ( 68 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 69 `name` varchar(64) NOT NULL, 70 `graph_template_id` int(10) unsigned NOT NULL, 71 `gprint_prefix` varchar(64) NOT NULL, 72 `gprint_format` char(2) DEFAULT '', 73 `graph_type` int(10) unsigned NOT NULL, 74 `total` int(10) unsigned NOT NULL, 75 `total_type` int(10) unsigned NOT NULL, 76 `total_prefix` varchar(64) NOT NULL, 77 `order_type` int(10) unsigned NOT NULL, 78 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 79 `user_id` int(10) unsigned NOT NULL, 80 PRIMARY KEY (`id`), 81 KEY `graph_template_id` (`graph_template_id`), 82 KEY `user_id` (`user_id`) 83) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Template Definitions for Aggregate Graphs'; 84 85-- 86-- Table structure for table `aggregate_graph_templates_graph` 87-- 88CREATE TABLE `aggregate_graph_templates_graph` ( 89 `aggregate_template_id` int(10) unsigned NOT NULL, 90 `t_image_format_id` char(2) DEFAULT '', 91 `image_format_id` tinyint(1) NOT NULL DEFAULT '0', 92 `t_height` char(2) DEFAULT '', 93 `height` mediumint(8) NOT NULL DEFAULT '0', 94 `t_width` char(2) DEFAULT '', 95 `width` mediumint(8) NOT NULL DEFAULT '0', 96 `t_upper_limit` char(2) DEFAULT '', 97 `upper_limit` varchar(20) NOT NULL DEFAULT '0', 98 `t_lower_limit` char(2) DEFAULT '', 99 `lower_limit` varchar(20) NOT NULL DEFAULT '0', 100 `t_vertical_label` char(2) DEFAULT '', 101 `vertical_label` varchar(200) DEFAULT '', 102 `t_slope_mode` char(2) DEFAULT '', 103 `slope_mode` char(2) DEFAULT 'on', 104 `t_auto_scale` char(2) DEFAULT '', 105 `auto_scale` char(2) DEFAULT '', 106 `t_auto_scale_opts` char(2) DEFAULT '', 107 `auto_scale_opts` tinyint(1) NOT NULL DEFAULT '0', 108 `t_auto_scale_log` char(2) DEFAULT '', 109 `auto_scale_log` char(2) DEFAULT '', 110 `t_scale_log_units` char(2) DEFAULT '', 111 `scale_log_units` char(2) DEFAULT '', 112 `t_auto_scale_rigid` char(2) DEFAULT '', 113 `auto_scale_rigid` char(2) DEFAULT '', 114 `t_auto_padding` char(2) DEFAULT '', 115 `auto_padding` char(2) DEFAULT '', 116 `t_base_value` char(2) DEFAULT '', 117 `base_value` mediumint(8) NOT NULL DEFAULT '0', 118 `t_grouping` char(2) DEFAULT '', 119 `grouping` char(2) NOT NULL DEFAULT '', 120 `t_unit_value` char(2) DEFAULT '', 121 `unit_value` varchar(20) DEFAULT '', 122 `t_unit_exponent_value` char(2) DEFAULT '', 123 `unit_exponent_value` varchar(5) NOT NULL DEFAULT '', 124 t_alt_y_grid char(2) default '', 125 alt_y_grid char(2) default NULL, 126 t_right_axis char(2) DEFAULT '', 127 right_axis varchar(20) DEFAULT NULL, 128 t_right_axis_label char(2) DEFAULT '', 129 right_axis_label varchar(200) DEFAULT NULL, 130 t_right_axis_format char(2) DEFAULT '', 131 right_axis_format mediumint(8) DEFAULT NULL, 132 t_right_axis_formatter char(2) DEFAULT '', 133 right_axis_formatter varchar(10) DEFAULT NULL, 134 t_left_axis_formatter char(2) DEFAULT '', 135 left_axis_formatter varchar(10) DEFAULT NULL, 136 t_no_gridfit char(2) DEFAULT '', 137 no_gridfit char(2) DEFAULT NULL, 138 t_unit_length char(2) DEFAULT '', 139 unit_length varchar(10) DEFAULT NULL, 140 t_tab_width char(2) DEFAULT '', 141 tab_width varchar(20) DEFAULT '30', 142 t_dynamic_labels char(2) default '', 143 dynamic_labels char(2) default NULL, 144 t_force_rules_legend char(2) DEFAULT '', 145 force_rules_legend char(2) DEFAULT NULL, 146 t_legend_position char(2) DEFAULT '', 147 legend_position varchar(10) DEFAULT NULL, 148 t_legend_direction char(2) DEFAULT '', 149 legend_direction varchar(10) DEFAULT NULL, 150 PRIMARY KEY (`aggregate_template_id`) 151) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Aggregate Template Graph Data'; 152 153-- 154-- Table structure for table `aggregate_graph_templates_item` 155-- 156 157CREATE TABLE `aggregate_graph_templates_item` ( 158 `aggregate_template_id` int(10) unsigned NOT NULL, 159 `graph_templates_item_id` int(10) unsigned NOT NULL, 160 `sequence` mediumint(8) unsigned NOT NULL DEFAULT '0', 161 `color_template` int(11) NOT NULL, 162 `t_graph_type_id` char(2) DEFAULT '', 163 `graph_type_id` tinyint(3) NOT NULL DEFAULT '0', 164 `t_cdef_id` char(2) DEFAULT '', 165 `cdef_id` mediumint(8) unsigned DEFAULT NULL, 166 `item_skip` char(2) NOT NULL, 167 `item_total` char(2) NOT NULL, 168 PRIMARY KEY (`aggregate_template_id`,`graph_templates_item_id`) 169) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Aggregate Template Graph Items'; 170 171-- 172-- Table structure for table `aggregate_graphs` 173-- 174 175CREATE TABLE `aggregate_graphs` ( 176 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 177 `aggregate_template_id` int(10) unsigned NOT NULL, 178 `template_propogation` char(2) NOT NULL DEFAULT '', 179 `local_graph_id` int(10) unsigned NOT NULL, 180 `title_format` varchar(128) NOT NULL, 181 `graph_template_id` int(10) unsigned NOT NULL, 182 `gprint_prefix` varchar(64) NOT NULL, 183 `gprint_format` char(2) DEFAULT '', 184 `graph_type` int(10) unsigned NOT NULL, 185 `total` int(10) unsigned NOT NULL, 186 `total_type` int(10) unsigned NOT NULL, 187 `total_prefix` varchar(64) NOT NULL, 188 `order_type` int(10) unsigned NOT NULL, 189 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 190 `user_id` int(10) unsigned NOT NULL, 191 PRIMARY KEY (`id`), 192 KEY `aggregate_template_id` (`aggregate_template_id`), 193 KEY `local_graph_id` (`local_graph_id`), 194 KEY `title_format` (`title_format`), 195 KEY `user_id` (`user_id`) 196) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Aggregate Graph Definitions'; 197 198-- 199-- Table structure for table `aggregate_graphs_graph_item` 200-- 201 202CREATE TABLE `aggregate_graphs_graph_item` ( 203 `aggregate_graph_id` int(10) unsigned NOT NULL, 204 `graph_templates_item_id` int(10) unsigned NOT NULL, 205 `sequence` mediumint(8) unsigned NOT NULL DEFAULT '0', 206 `color_template` int(11) unsigned NOT NULL, 207 `t_graph_type_id` char(2) DEFAULT '', 208 `graph_type_id` tinyint(3) NOT NULL DEFAULT '0', 209 `t_cdef_id` char(2) DEFAULT '', 210 `cdef_id` mediumint(8) unsigned DEFAULT NULL, 211 `item_skip` char(2) NOT NULL, 212 `item_total` char(2) NOT NULL, 213 PRIMARY KEY (`aggregate_graph_id`,`graph_templates_item_id`) 214) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Aggregate Graph Graph Items'; 215 216-- 217-- Table structure for table `aggregate_graphs_items` 218-- 219 220CREATE TABLE `aggregate_graphs_items` ( 221 `aggregate_graph_id` int(10) unsigned NOT NULL, 222 `local_graph_id` int(10) unsigned NOT NULL, 223 `sequence` mediumint(8) unsigned NOT NULL DEFAULT '0', 224 PRIMARY KEY (`aggregate_graph_id`,`local_graph_id`) 225) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Aggregate Graph Items'; 226 227-- 228-- Table structure for table `automation_devices` 229-- 230 231CREATE TABLE `automation_devices` ( 232 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 233 `network_id` int(10) unsigned NOT NULL DEFAULT '0', 234 `hostname` varchar(100) NOT NULL DEFAULT '', 235 `ip` varchar(17) NOT NULL DEFAULT '', 236 `snmp_community` varchar(100) NOT NULL DEFAULT '', 237 `snmp_version` tinyint(1) unsigned NOT NULL DEFAULT '1', 238 `snmp_port` mediumint(5) unsigned NOT NULL DEFAULT '161', 239 `snmp_username` varchar(50) DEFAULT NULL, 240 `snmp_password` varchar(50) DEFAULT NULL, 241 `snmp_auth_protocol` char(6) DEFAULT '', 242 `snmp_priv_passphrase` varchar(200) DEFAULT '', 243 `snmp_priv_protocol` char(6) DEFAULT '', 244 `snmp_context` varchar(64) DEFAULT '', 245 `snmp_engine_id` varchar(64) DEFAULT '', 246 `sysName` varchar(100) NOT NULL DEFAULT '', 247 `sysLocation` varchar(255) NOT NULL DEFAULT '', 248 `sysContact` varchar(255) NOT NULL DEFAULT '', 249 `sysDescr` varchar(255) NOT NULL DEFAULT '', 250 `sysUptime` bigint(20) unsigned NOT NULL DEFAULT '0', 251 `os` varchar(64) NOT NULL DEFAULT '', 252 `snmp` tinyint(4) NOT NULL DEFAULT '0', 253 `known` tinyint(4) NOT NULL DEFAULT '0', 254 `up` tinyint(4) NOT NULL DEFAULT '0', 255 `time` int(11) NOT NULL DEFAULT '0', 256 PRIMARY KEY (`id`), 257 UNIQUE KEY `ip` (`ip`), 258 KEY `hostname` (`hostname`) 259) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Table of Discovered Devices'; 260 261-- 262-- Table structure for table `automation_graph_rule_items` 263-- 264 265CREATE TABLE `automation_graph_rule_items` ( 266 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 267 `rule_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 268 `sequence` smallint(3) unsigned NOT NULL DEFAULT '0', 269 `operation` smallint(3) unsigned NOT NULL DEFAULT '0', 270 `field` varchar(255) NOT NULL DEFAULT '', 271 `operator` smallint(3) unsigned NOT NULL DEFAULT '0', 272 `pattern` varchar(255) NOT NULL DEFAULT '', 273 PRIMARY KEY (`id`) 274) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Automation Graph Rule Items'; 275 276-- 277-- Dumping data for table `automation_graph_rule_items` 278-- 279 280INSERT INTO `automation_graph_rule_items` VALUES (1,1,1,0,'ifOperStatus',7,'Up'),(2,1,2,1,'ifIP',16,''),(3,1,3,1,'ifHwAddr',16,''),(4,2,1,0,'ifOperStatus',7,'Up'),(5,2,2,1,'ifIP',16,''),(6,2,3,1,'ifHwAddr',16,''); 281 282-- 283-- Table structure for table `automation_graph_rules` 284-- 285 286CREATE TABLE `automation_graph_rules` ( 287 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 288 `name` varchar(255) NOT NULL DEFAULT '', 289 `snmp_query_id` smallint(3) unsigned NOT NULL DEFAULT '0', 290 `graph_type_id` smallint(3) unsigned NOT NULL DEFAULT '0', 291 `enabled` char(2) DEFAULT '', 292 PRIMARY KEY (`id`), 293 KEY `name` (`name`(171)) 294) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Automation Graph Rules'; 295 296-- 297-- Dumping data for table `automation_graph_rules` 298-- 299 300INSERT INTO `automation_graph_rules` VALUES (1,'Traffic 64 bit Server',1,12,'on'),(2,'Traffic 64 bit Server Linux',1,12,'on'),(3,'Disk Space',3,17,'on'); 301 302-- 303-- Table structure for table `automation_ips` 304-- 305 306CREATE TABLE `automation_ips` ( 307 `ip_address` varchar(20) NOT NULL DEFAULT '', 308 `hostname` varchar(100) DEFAULT NULL, 309 `network_id` int(10) unsigned DEFAULT NULL, 310 `pid` int(10) unsigned DEFAULT NULL, 311 `status` int(10) unsigned DEFAULT NULL, 312 `thread` int(10) unsigned DEFAULT NULL, 313 PRIMARY KEY (`ip_address`), 314 KEY `pid` (`pid`) 315) ENGINE=MEMORY COMMENT='List of discoverable ip addresses used for scanning'; 316 317-- 318-- Table structure for table `automation_match_rule_items` 319-- 320 321CREATE TABLE `automation_match_rule_items` ( 322 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 323 `rule_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 324 `rule_type` smallint(3) unsigned NOT NULL DEFAULT '0', 325 `sequence` smallint(3) unsigned NOT NULL DEFAULT '0', 326 `operation` smallint(3) unsigned NOT NULL DEFAULT '0', 327 `field` varchar(255) NOT NULL DEFAULT '', 328 `operator` smallint(3) unsigned NOT NULL DEFAULT '0', 329 `pattern` varchar(255) NOT NULL DEFAULT '', 330 PRIMARY KEY (`id`) 331) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Automation Match Rule Items'; 332 333-- 334-- Dumping data for table `automation_match_rule_items` 335-- 336 337INSERT INTO `automation_match_rule_items` VALUES (1,1,1,1,0,'h.snmp_sysDescr',8,''),(2,1,1,2,1,'h.snmp_version',12,'2'),(3,1,3,1,0,'ht.name',1,'Linux'),(4,2,1,1,0,'ht.name',1,'Linux'),(5,2,1,2,1,'h.snmp_version',12,'2'),(6,2,3,1,0,'ht.name',1,'SNMP'),(7,2,3,2,1,'gt.name',1,'Traffic'),(8,1,1,3,1,'h.snmp_sysDescr',2,'Windows'); 338 339-- 340-- Table structure for table `automation_networks` 341-- 342 343CREATE TABLE `automation_networks` ( 344 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 345 `poller_id` int(10) unsigned DEFAULT '1', 346 `site_id` int(10) unsigned DEFAULT '1', 347 `name` varchar(128) NOT NULL DEFAULT '' COMMENT 'The name for this network', 348 `subnet_range` varchar(1024) NOT NULL DEFAULT '' COMMENT 'Defined subnet ranges for discovery', 349 `dns_servers` varchar(128) NOT NULL DEFAULT '' COMMENT 'DNS Servers to use for name resolution', 350 `enabled` char(2) DEFAULT '', 351 `notification_enabled` char(2) DEFAULT '', 352 `notification_email` varchar(255) DEFAULT '', 353 `notification_fromname` varchar(32) DEFAULT '', 354 `notification_fromemail` varchar(128) DEFAULT '', 355 `snmp_id` int(10) unsigned DEFAULT NULL, 356 `enable_netbios` char(2) DEFAULT '', 357 `add_to_cacti` char(2) DEFAULT '', 358 `same_sysname` char(2) DEFAULT '', 359 `total_ips` int(10) unsigned DEFAULT '0', 360 `up_hosts` int(10) unsigned NOT NULL DEFAULT '0', 361 `snmp_hosts` int(10) unsigned NOT NULL DEFAULT '0', 362 `ping_method` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The ping method (ICMP:TCP:UDP)', 363 `ping_port` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'For TCP:UDP the port to ping', 364 `ping_timeout` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The ping timeout in seconds', 365 `ping_retries` int(10) unsigned DEFAULT '0', 366 `sched_type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Schedule type: manual or automatic', 367 `threads` int(10) unsigned DEFAULT '1', 368 `run_limit` int(10) unsigned DEFAULT '0' COMMENT 'The maximum runtime for the discovery', 369 `start_at` varchar(20) DEFAULT NULL, 370 `next_start` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 371 `recur_every` int(10) unsigned DEFAULT '1', 372 `day_of_week` varchar(45) DEFAULT NULL COMMENT 'The days of week to run in crontab format', 373 `month` varchar(45) DEFAULT NULL COMMENT 'The months to run in crontab format', 374 `day_of_month` varchar(45) DEFAULT NULL COMMENT 'The days of month to run in crontab format', 375 `monthly_week` varchar(45) DEFAULT NULL, 376 `monthly_day` varchar(45) DEFAULT NULL, 377 `last_runtime` double NOT NULL DEFAULT '0' COMMENT 'The last runtime for discovery', 378 `last_started` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the discovery last started', 379 `last_status` varchar(128) NOT NULL DEFAULT '' COMMENT 'The last exit message if any', 380 `rerun_data_queries` char(2) DEFAULT NULL COMMENT 'Rerun data queries or not for existing hosts', 381 PRIMARY KEY (`id`), 382 KEY `poller_id` (`poller_id`) 383) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Stores scanning subnet definitions'; 384 385-- 386-- Dumping data for table `automation_networks` 387-- 388 389INSERT INTO `automation_networks` VALUES (1,1,0,'Test Network','192.168.1.0/24','','on','','','','',1,'on','on','',254,0,0,1,22,400,1,2,10,1200,'0000-00-00 00:00:00','0000-00-00 00:00:00',2,'4','','','','',0,'0000-00-00 00:00:00','','on'); 390 391-- 392-- Table structure for table `automation_processes` 393-- 394 395CREATE TABLE `automation_processes` ( 396 `pid` int(8) unsigned NOT NULL, 397 `poller_id` int(10) unsigned DEFAULT '1', 398 `network_id` int(10) unsigned NOT NULL DEFAULT '0', 399 `task` varchar(20) DEFAULT '', 400 `status` varchar(20) DEFAULT NULL, 401 `command` varchar(20) DEFAULT NULL, 402 `up_hosts` int(10) unsigned DEFAULT '0', 403 `snmp_hosts` int(10) unsigned DEFAULT '0', 404 `heartbeat` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 405 PRIMARY KEY (`pid`,`network_id`) 406) ENGINE=MEMORY COMMENT='Table tracking active poller processes'; 407 408-- 409-- Table structure for table `automation_snmp` 410-- 411 412CREATE TABLE `automation_snmp` ( 413 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 414 `name` varchar(100) NOT NULL DEFAULT '', 415 PRIMARY KEY (`id`) 416) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Group of SNMP Option Sets'; 417 418-- 419-- Dumping data for table `automation_snmp` 420-- 421 422INSERT INTO `automation_snmp` VALUES (1,'Default Option Set'); 423 424-- 425-- Table structure for table `automation_snmp_items` 426-- 427 428CREATE TABLE `automation_snmp_items` ( 429 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 430 `snmp_id` int(10) unsigned NOT NULL DEFAULT '0', 431 `sequence` int(10) unsigned NOT NULL DEFAULT '0', 432 `snmp_version` tinyint(1) unsigned NOT NULL DEFAULT '1', 433 `snmp_community` varchar(100) NOT NULL, 434 `snmp_port` mediumint(5) unsigned NOT NULL DEFAULT '161', 435 `snmp_timeout` int(10) unsigned NOT NULL DEFAULT '500', 436 `snmp_retries` tinyint(1) unsigned NOT NULL DEFAULT '3', 437 `max_oids` int(12) unsigned DEFAULT '10', 438 `bulk_walk_size` int(11) DEFAULT '-1', 439 `snmp_username` varchar(50) DEFAULT NULL, 440 `snmp_password` varchar(50) DEFAULT NULL, 441 `snmp_auth_protocol` char(6) DEFAULT '', 442 `snmp_priv_passphrase` varchar(200) DEFAULT '', 443 `snmp_priv_protocol` char(6) DEFAULT '', 444 `snmp_context` varchar(64) DEFAULT '', 445 `snmp_engine_id` varchar(64) DEFAULT '', 446 PRIMARY KEY (`id`,`snmp_id`) 447) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Set of SNMP Options'; 448 449-- 450-- Dumping data for table `automation_snmp_items` 451-- 452 453INSERT INTO `automation_snmp_items` VALUES (1,1,1,'2','public',161,1000,3,10,-1,'admin','baseball','MD5','','DES','',''),(2,1,2,'2','private',161,1000,3,10,-1,'admin','baseball','MD5','','DES','',''); 454 455-- 456-- Table structure for table `automation_templates` 457-- 458 459CREATE TABLE `automation_templates` ( 460 `id` int(8) NOT NULL AUTO_INCREMENT, 461 `host_template` int(8) NOT NULL DEFAULT '0', 462 `availability_method` int(10) unsigned DEFAULT '2', 463 `sysDescr` varchar(255) DEFAULT '', 464 `sysName` varchar(255) DEFAULT '', 465 `sysOid` varchar(60) DEFAULT '', 466 `sequence` int(10) unsigned DEFAULT '0', 467 PRIMARY KEY (`id`) 468) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Templates of SNMP Sys variables used for automation'; 469 470-- 471-- Dumping data for table `automation_templates` 472-- 473 474INSERT INTO `automation_templates` VALUES (1,3,2,'Linux','','',2),(2,1,2,'HP ETHERNET','','',1); 475 476-- 477-- Table structure for table `automation_tree_rule_items` 478-- 479 480CREATE TABLE `automation_tree_rule_items` ( 481 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 482 `rule_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 483 `sequence` smallint(3) unsigned NOT NULL DEFAULT '0', 484 `field` varchar(255) NOT NULL DEFAULT '', 485 `sort_type` smallint(3) unsigned NOT NULL DEFAULT '0', 486 `propagate_changes` char(2) DEFAULT '', 487 `search_pattern` varchar(255) NOT NULL DEFAULT '', 488 `replace_pattern` varchar(255) NOT NULL DEFAULT '', 489 PRIMARY KEY (`id`) 490) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Automation Tree Rule Items'; 491 492-- 493-- Dumping data for table `automation_tree_rule_items` 494-- 495 496INSERT INTO `automation_tree_rule_items` VALUES (1,1,1,'ht.name',1,'','^(.*)\\s*Linux\\s*(.*)$','${1}\\n${2}'),(2,1,2,'h.hostname',1,'','^(\\w*)\\s*(\\w*)\\s*(\\w*).*$',''),(3,2,1,'0',2,'on','Traffic',''),(4,2,2,'gtg.title_cache',1,'','^(.*)\\s*-\\s*Traffic -\\s*(.*)$','${1}\\n${2}'); 497 498-- 499-- Table structure for table `automation_tree_rules` 500-- 501 502CREATE TABLE `automation_tree_rules` ( 503 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 504 `name` varchar(255) NOT NULL DEFAULT '', 505 `tree_id` smallint(3) unsigned NOT NULL DEFAULT '0', 506 `tree_item_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 507 `leaf_type` smallint(3) unsigned NOT NULL DEFAULT '0', 508 `host_grouping_type` smallint(3) unsigned NOT NULL DEFAULT '0', 509 `enabled` char(2) DEFAULT '', 510 PRIMARY KEY (`id`), 511 KEY `name` (`name`(171)) 512) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Automation Tree Rules'; 513 514-- 515-- Dumping data for table `automation_tree_rules` 516-- 517 518INSERT INTO `automation_tree_rules` VALUES (1,'New Device',1,0,3,1,'on'),(2,'New Graph',1,0,2,1,''); 519 520-- 521-- Table structure for table `cdef` 522-- 523 524CREATE TABLE cdef ( 525 `id` mediumint(8) unsigned NOT NULL auto_increment, 526 `hash` varchar(32) NOT NULL default '', 527 `system` mediumint(8) unsigned NOT NULL DEFAULT '0', 528 `name` varchar(255) NOT NULL default '', 529 PRIMARY KEY (id), 530 KEY `hash` (`hash`), 531 KEY `name` (`name`(171)) 532) ENGINE=InnoDB ROW_FORMAT=Dynamic; 533 534-- 535-- Dumping data for table `cdef` 536-- 537 538INSERT INTO cdef VALUES (3,'3d352eed9fa8f7b2791205b3273708c7',0,'Make Stack Negative'); 539INSERT INTO cdef VALUES (4,'e961cc8ec04fda6ed4981cf5ad501aa5',0,'Make Per 5 Minutes'); 540INSERT INTO cdef VALUES (12,'f1ac79f05f255c02f914c920f1038c54',0,'Total All Data Sources'); 541INSERT INTO cdef VALUES (2,'73f95f8b77b5508157d64047342c421e',0,'Turn Bytes into Bits'); 542INSERT INTO cdef VALUES (14,'634a23af5e78af0964e8d33b1a4ed26b',0,'Multiply by 1024'); 543INSERT INTO cdef VALUES (15,'068984b5ccdfd2048869efae5166f722',0,'Total All Data Sources, Multiply by 1024'); 544 545-- 546-- Table structure for table `cdef_items` 547-- 548 549CREATE TABLE cdef_items ( 550 id mediumint(8) unsigned NOT NULL auto_increment, 551 hash varchar(32) NOT NULL default '', 552 cdef_id mediumint(8) unsigned NOT NULL default '0', 553 sequence mediumint(8) unsigned NOT NULL default '0', 554 type tinyint(2) NOT NULL default '0', 555 value varchar(150) NOT NULL default '', 556 PRIMARY KEY (id), 557 KEY cdef_id_sequence (`cdef_id`,`sequence`) 558) ENGINE=InnoDB ROW_FORMAT=Dynamic; 559 560-- 561-- Dumping data for table `cdef_items` 562-- 563 564INSERT INTO cdef_items VALUES (7,'9bbf6b792507bb9bb17d2af0970f9be9',2,1,4,'CURRENT_DATA_SOURCE'); 565INSERT INTO cdef_items VALUES (9,'a4b8eb2c3bf4920a3ef571a7a004be53',2,2,6,'8'); 566INSERT INTO cdef_items VALUES (8,'caa4e023ac2d7b1c4b4c8c4adfd55dfe',2,3,2,'3'); 567INSERT INTO cdef_items VALUES (10,'c888c9fe6b62c26c4bfe23e18991731d',3,1,4,'CURRENT_DATA_SOURCE'); 568INSERT INTO cdef_items VALUES (11,'1e1d0b29a94e08b648c8f053715442a0',3,3,2,'3'); 569INSERT INTO cdef_items VALUES (12,'4355c197998c7f8b285be7821ddc6da4',3,2,6,'-1'); 570INSERT INTO cdef_items VALUES (13,'40bb7a1143b0f2e2efca14eb356236de',4,1,4,'CURRENT_DATA_SOURCE'); 571INSERT INTO cdef_items VALUES (14,'42686ea0925c0220924b7d333599cd67',4,3,2,'3'); 572INSERT INTO cdef_items VALUES (15,'faf1b148b2c0e0527362ed5b8ca1d351',4,2,6,'300'); 573INSERT INTO cdef_items VALUES (16,'0ef6b8a42dc83b4e43e437960fccd2ea',12,1,4,'ALL_DATA_SOURCES_NODUPS'); 574INSERT INTO cdef_items VALUES (18,'86370cfa0008fe8c56b28be80ee39a40',14,1,4,'CURRENT_DATA_SOURCE'); 575INSERT INTO cdef_items VALUES (19,'9a35cc60d47691af37f6fddf02064e20',14,2,6,'1024'); 576INSERT INTO cdef_items VALUES (20,'5d7a7941ec0440b257e5598a27dd1688',14,3,2,'3'); 577INSERT INTO cdef_items VALUES (21,'44fd595c60539ff0f5817731d9f43a85',15,1,4,'ALL_DATA_SOURCES_NODUPS'); 578INSERT INTO cdef_items VALUES (22,'aa38be265e5ac31783e57ce6f9314e9a',15,2,6,'1024'); 579INSERT INTO cdef_items VALUES (23,'204423d4b2598f1f7252eea19458345c',15,3,2,'3'); 580 581 582CREATE TABLE `color_templates` ( 583 `color_template_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 584 `name` varchar(255) NOT NULL DEFAULT '', 585 PRIMARY KEY (`color_template_id`) 586) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Color Templates'; 587 588-- 589-- Dumping data for table `color_templates` 590-- 591 592INSERT INTO `color_templates` VALUES (1,'Yellow: light -> dark, 4 colors'); 593INSERT INTO `color_templates` VALUES (2,'Red: light yellow > dark red, 8 colors'); 594INSERT INTO `color_templates` VALUES (3,'Red: light -> dark, 16 colors'); 595INSERT INTO `color_templates` VALUES (4,'Green: dark -> light, 16 colors'); 596 597-- 598-- Table structure for table `color_template_items` 599-- 600 601CREATE TABLE `color_template_items` ( 602 `color_template_item_id` int(12) unsigned NOT NULL AUTO_INCREMENT, 603 `color_template_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 604 `color_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 605 `sequence` mediumint(8) unsigned NOT NULL DEFAULT '0', 606 PRIMARY KEY (`color_template_item_id`) 607) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Color Items for Color Templates'; 608 609-- 610-- Dumping data for table `color_template_items` 611-- 612 613INSERT INTO `color_template_items` VALUES (1,1,4,1); 614INSERT INTO `color_template_items` VALUES (2,1,24,2); 615INSERT INTO `color_template_items` VALUES (3,1,98,3); 616INSERT INTO `color_template_items` VALUES (4,1,25,4); 617INSERT INTO `color_template_items` VALUES (5,2,25,1); 618INSERT INTO `color_template_items` VALUES (6,2,29,2); 619INSERT INTO `color_template_items` VALUES (7,2,30,3); 620INSERT INTO `color_template_items` VALUES (8,2,31,4); 621INSERT INTO `color_template_items` VALUES (9,2,33,5); 622INSERT INTO `color_template_items` VALUES (10,2,35,6); 623INSERT INTO `color_template_items` VALUES (11,2,41,7); 624INSERT INTO `color_template_items` VALUES (12,2,9,8); 625INSERT INTO `color_template_items` VALUES (13,3,15,1); 626INSERT INTO `color_template_items` VALUES (14,3,31,2); 627INSERT INTO `color_template_items` VALUES (15,3,28,3); 628INSERT INTO `color_template_items` VALUES (16,3,8,4); 629INSERT INTO `color_template_items` VALUES (17,3,34,5); 630INSERT INTO `color_template_items` VALUES (18,3,33,6); 631INSERT INTO `color_template_items` VALUES (19,3,35,7); 632INSERT INTO `color_template_items` VALUES (20,3,41,8); 633INSERT INTO `color_template_items` VALUES (21,3,36,9); 634INSERT INTO `color_template_items` VALUES (22,3,42,10); 635INSERT INTO `color_template_items` VALUES (23,3,44,11); 636INSERT INTO `color_template_items` VALUES (24,3,48,12); 637INSERT INTO `color_template_items` VALUES (25,3,9,13); 638INSERT INTO `color_template_items` VALUES (26,3,49,14); 639INSERT INTO `color_template_items` VALUES (27,3,51,15); 640INSERT INTO `color_template_items` VALUES (28,3,52,16); 641INSERT INTO `color_template_items` VALUES (29,4,76,1); 642INSERT INTO `color_template_items` VALUES (30,4,84,2); 643INSERT INTO `color_template_items` VALUES (31,4,89,3); 644INSERT INTO `color_template_items` VALUES (32,4,17,4); 645INSERT INTO `color_template_items` VALUES (33,4,86,5); 646INSERT INTO `color_template_items` VALUES (34,4,88,6); 647INSERT INTO `color_template_items` VALUES (35,4,90,7); 648INSERT INTO `color_template_items` VALUES (36,4,94,8); 649INSERT INTO `color_template_items` VALUES (37,4,96,9); 650INSERT INTO `color_template_items` VALUES (38,4,93,10); 651INSERT INTO `color_template_items` VALUES (39,4,91,11); 652INSERT INTO `color_template_items` VALUES (40,4,22,12); 653INSERT INTO `color_template_items` VALUES (41,4,12,13); 654INSERT INTO `color_template_items` VALUES (42,4,95,14); 655INSERT INTO `color_template_items` VALUES (43,4,6,15); 656INSERT INTO `color_template_items` VALUES (44,4,92,16); 657 658-- 659-- Table structure for table `colors` 660-- 661 662CREATE TABLE colors ( 663 id mediumint(8) unsigned NOT NULL auto_increment, 664 name varchar(40) default '', 665 hex varchar(6) NOT NULL default '', 666 read_only char(2) default '', 667 PRIMARY KEY (id), 668 UNIQUE KEY hex (hex) 669) ENGINE=InnoDB ROW_FORMAT=Dynamic; 670 671-- 672-- Dumping data for table `colors` 673-- 674 675INSERT INTO colors VALUES (1,'Black','000000','on'); 676INSERT INTO colors VALUES (2,'White','FFFFFF','on'); 677INSERT INTO colors VALUES (4,'','FAFD9E',''); 678INSERT INTO colors VALUES (5,'','C0C0C0',''); 679INSERT INTO colors VALUES (6,'','74C366',''); 680INSERT INTO colors VALUES (7,'','6DC8FE',''); 681INSERT INTO colors VALUES (8,'','EA8F00',''); 682INSERT INTO colors VALUES (9,'Red','FF0000','on'); 683INSERT INTO colors VALUES (10,'','4444FF',''); 684INSERT INTO colors VALUES (11,'Magenta','FF00FF','on'); 685INSERT INTO colors VALUES (12,'Green','00FF00','on'); 686INSERT INTO colors VALUES (13,'','8D85F3',''); 687INSERT INTO colors VALUES (14,'','AD3B6E',''); 688INSERT INTO colors VALUES (15,'','EACC00',''); 689INSERT INTO colors VALUES (16,'','12B3B5',''); 690INSERT INTO colors VALUES (17,'','157419',''); 691INSERT INTO colors VALUES (18,'','C4FD3D',''); 692INSERT INTO colors VALUES (19,'','817C4E',''); 693INSERT INTO colors VALUES (20,'','002A97',''); 694INSERT INTO colors VALUES (21,'','0000FF',''); 695INSERT INTO colors VALUES (22,'','00CF00',''); 696INSERT INTO colors VALUES (24,'','F9FD5F',''); 697INSERT INTO colors VALUES (25,'','FFF200',''); 698INSERT INTO colors VALUES (26,'','CCBB00',''); 699INSERT INTO colors VALUES (27,'','837C04',''); 700INSERT INTO colors VALUES (28,'','EAAF00',''); 701INSERT INTO colors VALUES (29,'','FFD660',''); 702INSERT INTO colors VALUES (30,'','FFC73B',''); 703INSERT INTO colors VALUES (31,'','FFAB00',''); 704INSERT INTO colors VALUES (33,'','FF7D00',''); 705INSERT INTO colors VALUES (34,'','ED7600',''); 706INSERT INTO colors VALUES (35,'','FF5700',''); 707INSERT INTO colors VALUES (36,'','EE5019',''); 708INSERT INTO colors VALUES (37,'','B1441E',''); 709INSERT INTO colors VALUES (38,'','FFC3C0',''); 710INSERT INTO colors VALUES (39,'','FF897C',''); 711INSERT INTO colors VALUES (40,'','FF6044',''); 712INSERT INTO colors VALUES (41,'','FF4105',''); 713INSERT INTO colors VALUES (42,'','DA4725',''); 714INSERT INTO colors VALUES (43,'','942D0C',''); 715INSERT INTO colors VALUES (44,'','FF3932',''); 716INSERT INTO colors VALUES (45,'','862F2F',''); 717INSERT INTO colors VALUES (46,'','FF5576',''); 718INSERT INTO colors VALUES (47,'','562B29',''); 719INSERT INTO colors VALUES (48,'','F51D30',''); 720INSERT INTO colors VALUES (49,'','DE0056',''); 721INSERT INTO colors VALUES (50,'','ED5394',''); 722INSERT INTO colors VALUES (51,'','B90054',''); 723INSERT INTO colors VALUES (52,'','8F005C',''); 724INSERT INTO colors VALUES (53,'','F24AC8',''); 725INSERT INTO colors VALUES (54,'','E8CDEF',''); 726INSERT INTO colors VALUES (55,'','D8ACE0',''); 727INSERT INTO colors VALUES (56,'','A150AA',''); 728INSERT INTO colors VALUES (57,'','750F7D',''); 729INSERT INTO colors VALUES (58,'','8D00BA',''); 730INSERT INTO colors VALUES (59,'','623465',''); 731INSERT INTO colors VALUES (60,'','55009D',''); 732INSERT INTO colors VALUES (61,'','3D168B',''); 733INSERT INTO colors VALUES (62,'','311F4E',''); 734INSERT INTO colors VALUES (63,'','D2D8F9',''); 735INSERT INTO colors VALUES (64,'','9FA4EE',''); 736INSERT INTO colors VALUES (65,'','6557D0',''); 737INSERT INTO colors VALUES (66,'','4123A1',''); 738INSERT INTO colors VALUES (67,'','4668E4',''); 739INSERT INTO colors VALUES (68,'','0D006A',''); 740INSERT INTO colors VALUES (69,'','00004D',''); 741INSERT INTO colors VALUES (70,'','001D61',''); 742INSERT INTO colors VALUES (71,'','00234B',''); 743INSERT INTO colors VALUES (72,'','002A8F',''); 744INSERT INTO colors VALUES (73,'','2175D9',''); 745INSERT INTO colors VALUES (74,'','7CB3F1',''); 746INSERT INTO colors VALUES (75,'','005199',''); 747INSERT INTO colors VALUES (76,'','004359',''); 748INSERT INTO colors VALUES (77,'','00A0C1',''); 749INSERT INTO colors VALUES (78,'','007283',''); 750INSERT INTO colors VALUES (79,'','00BED9',''); 751INSERT INTO colors VALUES (80,'','AFECED',''); 752INSERT INTO colors VALUES (81,'','55D6D3',''); 753INSERT INTO colors VALUES (82,'','00BBB4',''); 754INSERT INTO colors VALUES (83,'','009485',''); 755INSERT INTO colors VALUES (84,'','005D57',''); 756INSERT INTO colors VALUES (85,'','008A77',''); 757INSERT INTO colors VALUES (86,'','008A6D',''); 758INSERT INTO colors VALUES (87,'','00B99B',''); 759INSERT INTO colors VALUES (88,'','009F67',''); 760INSERT INTO colors VALUES (89,'','00694A',''); 761INSERT INTO colors VALUES (90,'','00A348',''); 762INSERT INTO colors VALUES (91,'','00BF47',''); 763INSERT INTO colors VALUES (92,'','96E78A',''); 764INSERT INTO colors VALUES (93,'','00BD27',''); 765INSERT INTO colors VALUES (94,'','35962B',''); 766INSERT INTO colors VALUES (95,'','7EE600',''); 767INSERT INTO colors VALUES (96,'','6EA100',''); 768INSERT INTO colors VALUES (97,'','CAF100',''); 769INSERT INTO colors VALUES (98,'','F5F800',''); 770INSERT INTO colors VALUES (99,'','CDCFC4',''); 771INSERT INTO colors VALUES (100,'','BCBEB3',''); 772INSERT INTO colors VALUES (101,'','AAABA1',''); 773INSERT INTO colors VALUES (102,'','8F9286',''); 774INSERT INTO colors VALUES (103,'','797C6E',''); 775INSERT INTO colors VALUES (104,'','2E3127',''); 776INSERT INTO colors VALUES (105,'Night','0C090A','on'); 777INSERT INTO colors VALUES (106,'Gunmetal','2C3539','on'); 778INSERT INTO colors VALUES (107,'Midnight','2B1B17','on'); 779INSERT INTO colors VALUES (108,'Charcoal','34282C','on'); 780INSERT INTO colors VALUES (109,'Dark Slate Grey','25383C','on'); 781INSERT INTO colors VALUES (110,'Oil','3B3131','on'); 782INSERT INTO colors VALUES (111,'Black Cat','413839','on'); 783INSERT INTO colors VALUES (112,'Iridium','3D3C3A','on'); 784INSERT INTO colors VALUES (113,'Black Eel','463E3F','on'); 785INSERT INTO colors VALUES (114,'Black Cow','4C4646','on'); 786INSERT INTO colors VALUES (115,'Gray Wolf','504A4B','on'); 787INSERT INTO colors VALUES (116,'Vampire Gray','565051','on'); 788INSERT INTO colors VALUES (117,'Gray Dolphin','5C5858','on'); 789INSERT INTO colors VALUES (118,'Carbon Gray','625D5D','on'); 790INSERT INTO colors VALUES (119,'Ash Gray','666362','on'); 791INSERT INTO colors VALUES (120,'Cloudy Gray','6D6968','on'); 792INSERT INTO colors VALUES (121,'Smokey Gray','726E6D','on'); 793INSERT INTO colors VALUES (122,'Gray','736F6E','on'); 794INSERT INTO colors VALUES (123,'Granite','837E7C','on'); 795INSERT INTO colors VALUES (124,'Battleship Gray','848482','on'); 796INSERT INTO colors VALUES (125,'Gray Cloud','B6B6B4','on'); 797INSERT INTO colors VALUES (126,'Gray Goose','D1D0CE','on'); 798INSERT INTO colors VALUES (127,'Platinum','E5E4E2','on'); 799INSERT INTO colors VALUES (128,'Metallic Silver','BCC6CC','on'); 800INSERT INTO colors VALUES (129,'Blue Gray','98AFC7','on'); 801INSERT INTO colors VALUES (130,'Light Slate Gray','6D7B8D','on'); 802INSERT INTO colors VALUES (131,'Slate Gray','657383','on'); 803INSERT INTO colors VALUES (132,'Jet Gray','616D7E','on'); 804INSERT INTO colors VALUES (133,'Mist Blue','646D7E','on'); 805INSERT INTO colors VALUES (134,'Marble Blue','566D7E','on'); 806INSERT INTO colors VALUES (135,'Slate Blue','737CA1','on'); 807INSERT INTO colors VALUES (136,'Steel Blue','4863A0','on'); 808INSERT INTO colors VALUES (137,'Blue Jay','2B547E','on'); 809INSERT INTO colors VALUES (138,'Dark Slate Blue','2B3856','on'); 810INSERT INTO colors VALUES (139,'Midnight Blue','151B54','on'); 811INSERT INTO colors VALUES (140,'Navy Blue','000080','on'); 812INSERT INTO colors VALUES (141,'Blue Whale','342D7E','on'); 813INSERT INTO colors VALUES (142,'Lapis Blue','15317E','on'); 814INSERT INTO colors VALUES (143,'Cornflower Blue','151B8D','on'); 815INSERT INTO colors VALUES (144,'Earth Blue','0000A0','on'); 816INSERT INTO colors VALUES (145,'Cobalt Blue','0020C2','on'); 817INSERT INTO colors VALUES (146,'Blueberry Blue','0041C2','on'); 818INSERT INTO colors VALUES (147,'Sapphire Blue','2554C7','on'); 819INSERT INTO colors VALUES (148,'Blue Eyes','1569C7','on'); 820INSERT INTO colors VALUES (149,'Royal Blue','2B60DE','on'); 821INSERT INTO colors VALUES (150,'Blue Orchid','1F45FC','on'); 822INSERT INTO colors VALUES (151,'Blue Lotus','6960EC','on'); 823INSERT INTO colors VALUES (152,'Light Slate Blue','736AFF','on'); 824INSERT INTO colors VALUES (153,'Slate Blue','357EC7','on'); 825INSERT INTO colors VALUES (154,'Glacial Blue Ice','368BC1','on'); 826INSERT INTO colors VALUES (155,'Silk Blue','488AC7','on'); 827INSERT INTO colors VALUES (156,'Blue Ivy','3090C7','on'); 828INSERT INTO colors VALUES (157,'Blue Koi','659EC7','on'); 829INSERT INTO colors VALUES (158,'Columbia Blue','87AFC7','on'); 830INSERT INTO colors VALUES (159,'Baby Blue','95B9C7','on'); 831INSERT INTO colors VALUES (160,'Light Steel Blue','728FCE','on'); 832INSERT INTO colors VALUES (161,'Ocean Blue','2B65EC','on'); 833INSERT INTO colors VALUES (162,'Blue Ribbon','306EFF','on'); 834INSERT INTO colors VALUES (163,'Blue Dress','157DEC','on'); 835INSERT INTO colors VALUES (164,'Dodger Blue','1589FF','on'); 836INSERT INTO colors VALUES (165,'Cornflower Blue','6495ED','on'); 837INSERT INTO colors VALUES (166,'Sky Blue','6698FF','on'); 838INSERT INTO colors VALUES (167,'Butterfly Blue','38ACEC','on'); 839INSERT INTO colors VALUES (168,'Iceberg','56A5EC','on'); 840INSERT INTO colors VALUES (169,'Crystal Blue','5CB3FF','on'); 841INSERT INTO colors VALUES (170,'Deep Sky Blue','3BB9FF','on'); 842INSERT INTO colors VALUES (171,'Denim Blue','79BAEC','on'); 843INSERT INTO colors VALUES (172,'Light Sky Blue','82CAFA','on'); 844INSERT INTO colors VALUES (173,'Day Sky Blue','82CAFF','on'); 845INSERT INTO colors VALUES (174,'Jeans Blue','A0CFEC','on'); 846INSERT INTO colors VALUES (175,'Blue Angel','B7CEEC','on'); 847INSERT INTO colors VALUES (176,'Pastel Blue','B4CFEC','on'); 848INSERT INTO colors VALUES (177,'Sea Blue','C2DFFF','on'); 849INSERT INTO colors VALUES (178,'Powder Blue','C6DEFF','on'); 850INSERT INTO colors VALUES (179,'Coral Blue','AFDCEC','on'); 851INSERT INTO colors VALUES (180,'Light Blue','ADDFFF','on'); 852INSERT INTO colors VALUES (181,'Robin Egg Blue','BDEDFF','on'); 853INSERT INTO colors VALUES (182,'Pale Blue Lily','CFECEC','on'); 854INSERT INTO colors VALUES (183,'Light Cyan','E0FFFF','on'); 855INSERT INTO colors VALUES (184,'Water','EBF4FA','on'); 856INSERT INTO colors VALUES (185,'Alice Blue','F0F8FF','on'); 857INSERT INTO colors VALUES (186,'Azure','F0FFFF','on'); 858INSERT INTO colors VALUES (187,'Light Slate','CCFFFF','on'); 859INSERT INTO colors VALUES (188,'Light Aquamarine','93FFE8','on'); 860INSERT INTO colors VALUES (189,'Electric Blue','9AFEFF','on'); 861INSERT INTO colors VALUES (190,'Aquamarine','7FFFD4','on'); 862INSERT INTO colors VALUES (191,'Cyan or Aqua','00FFFF','on'); 863INSERT INTO colors VALUES (192,'Tron Blue','7DFDFE','on'); 864INSERT INTO colors VALUES (193,'Blue Zircon','57FEFF','on'); 865INSERT INTO colors VALUES (194,'Blue Lagoon','8EEBEC','on'); 866INSERT INTO colors VALUES (195,'Celeste','50EBEC','on'); 867INSERT INTO colors VALUES (196,'Blue Diamond','4EE2EC','on'); 868INSERT INTO colors VALUES (197,'Tiffany Blue','81D8D0','on'); 869INSERT INTO colors VALUES (198,'Cyan Opaque','92C7C7','on'); 870INSERT INTO colors VALUES (199,'Blue Hosta','77BFC7','on'); 871INSERT INTO colors VALUES (200,'Northern Lights Blue','78C7C7','on'); 872INSERT INTO colors VALUES (201,'Medium Turquoise','48CCCD','on'); 873INSERT INTO colors VALUES (202,'Turquoise','43C6DB','on'); 874INSERT INTO colors VALUES (203,'Jellyfish','46C7C7','on'); 875INSERT INTO colors VALUES (204,'Macaw Blue Green','43BFC7','on'); 876INSERT INTO colors VALUES (205,'Light Sea Green','3EA99F','on'); 877INSERT INTO colors VALUES (206,'Dark Turquoise','3B9C9C','on'); 878INSERT INTO colors VALUES (207,'Sea Turtle Green','438D80','on'); 879INSERT INTO colors VALUES (208,'Medium Aquamarine','348781','on'); 880INSERT INTO colors VALUES (209,'Greenish Blue','307D7E','on'); 881INSERT INTO colors VALUES (210,'Grayish Turquoise','5E7D7E','on'); 882INSERT INTO colors VALUES (211,'Beetle Green','4C787E','on'); 883INSERT INTO colors VALUES (212,'Teal','008080','on'); 884INSERT INTO colors VALUES (213,'Sea Green','4E8975','on'); 885INSERT INTO colors VALUES (214,'Camouflage Green','78866B','on'); 886INSERT INTO colors VALUES (215,'Sage Green','848b79','on'); 887INSERT INTO colors VALUES (216,'Hazel Green','617C58','on'); 888INSERT INTO colors VALUES (217,'Venom Green','728C00','on'); 889INSERT INTO colors VALUES (218,'Fern Green','667C26','on'); 890INSERT INTO colors VALUES (219,'Dark Forrest Green','254117','on'); 891INSERT INTO colors VALUES (220,'Medium Sea Green','306754','on'); 892INSERT INTO colors VALUES (221,'Medium Forest Green','347235','on'); 893INSERT INTO colors VALUES (222,'Seaweed Green','437C17','on'); 894INSERT INTO colors VALUES (223,'Pine Green','387C44','on'); 895INSERT INTO colors VALUES (224,'Jungle Green','347C2C','on'); 896INSERT INTO colors VALUES (225,'Shamrock Green','347C17','on'); 897INSERT INTO colors VALUES (226,'Medium Spring Green','348017','on'); 898INSERT INTO colors VALUES (227,'Forest Green','4E9258','on'); 899INSERT INTO colors VALUES (228,'Green Onion','6AA121','on'); 900INSERT INTO colors VALUES (229,'Spring Green','4AA02C','on'); 901INSERT INTO colors VALUES (230,'Lime Green','41A317','on'); 902INSERT INTO colors VALUES (231,'Clover Green','3EA055','on'); 903INSERT INTO colors VALUES (232,'Green Snake','6CBB3C','on'); 904INSERT INTO colors VALUES (233,'Alien Green','6CC417','on'); 905INSERT INTO colors VALUES (234,'Green Apple','4CC417','on'); 906INSERT INTO colors VALUES (235,'Yellow Green','52D017','on'); 907INSERT INTO colors VALUES (236,'Kelly Green','4CC552','on'); 908INSERT INTO colors VALUES (237,'Zombie Green','54C571','on'); 909INSERT INTO colors VALUES (238,'Frog Green','99C68E','on'); 910INSERT INTO colors VALUES (239,'Green Peas','89C35C','on'); 911INSERT INTO colors VALUES (240,'Dollar Bill Green','85BB65','on'); 912INSERT INTO colors VALUES (241,'Dark Sea Green','8BB381','on'); 913INSERT INTO colors VALUES (242,'Iguana Green','9CB071','on'); 914INSERT INTO colors VALUES (243,'Avocado Green','B2C248','on'); 915INSERT INTO colors VALUES (244,'Pistachio Green','9DC209','on'); 916INSERT INTO colors VALUES (245,'Salad Green','A1C935','on'); 917INSERT INTO colors VALUES (246,'Hummingbird Green','7FE817','on'); 918INSERT INTO colors VALUES (247,'Nebula Green','59E817','on'); 919INSERT INTO colors VALUES (248,'Stoplight Go Green','57E964','on'); 920INSERT INTO colors VALUES (249,'Algae Green','64E986','on'); 921INSERT INTO colors VALUES (250,'Jade Green','5EFB6E','on'); 922INSERT INTO colors VALUES (251,'Emerald Green','5FFB17','on'); 923INSERT INTO colors VALUES (252,'Lawn Green','87F717','on'); 924INSERT INTO colors VALUES (253,'Chartreuse','8AFB17','on'); 925INSERT INTO colors VALUES (254,'Dragon Green','6AFB92','on'); 926INSERT INTO colors VALUES (255,'Mint green','98FF98','on'); 927INSERT INTO colors VALUES (256,'Green Thumb','B5EAAA','on'); 928INSERT INTO colors VALUES (257,'Light Jade','C3FDB8','on'); 929INSERT INTO colors VALUES (258,'Tea Green','CCFB5D','on'); 930INSERT INTO colors VALUES (259,'Green Yellow','B1FB17','on'); 931INSERT INTO colors VALUES (260,'Slime Green','BCE954','on'); 932INSERT INTO colors VALUES (261,'Goldenrod','EDDA74','on'); 933INSERT INTO colors VALUES (262,'Harvest Gold','EDE275','on'); 934INSERT INTO colors VALUES (263,'Sun Yellow','FFE87C','on'); 935INSERT INTO colors VALUES (264,'Yellow','FFFF00','on'); 936INSERT INTO colors VALUES (265,'Corn Yellow','FFF380','on'); 937INSERT INTO colors VALUES (266,'Parchment','FFFFC2','on'); 938INSERT INTO colors VALUES (267,'Cream','FFFFCC','on'); 939INSERT INTO colors VALUES (268,'Lemon Chiffon','FFF8C6','on'); 940INSERT INTO colors VALUES (269,'Cornsilk','FFF8DC','on'); 941INSERT INTO colors VALUES (270,'Beige','F5F5DC','on'); 942INSERT INTO colors VALUES (271,'Blonde','FBF6D9','on'); 943INSERT INTO colors VALUES (272,'Antique White','FAEBD7','on'); 944INSERT INTO colors VALUES (273,'Champagne','F7E7CE','on'); 945INSERT INTO colors VALUES (274,'Blanched Almond','FFEBCD','on'); 946INSERT INTO colors VALUES (275,'Vanilla','F3E5AB','on'); 947INSERT INTO colors VALUES (276,'Tan Brown','ECE5B6','on'); 948INSERT INTO colors VALUES (277,'Peach','FFE5B4','on'); 949INSERT INTO colors VALUES (278,'Mustard','FFDB58','on'); 950INSERT INTO colors VALUES (279,'Rubber Ducky Yellow','FFD801','on'); 951INSERT INTO colors VALUES (280,'Bright Gold','FDD017','on'); 952INSERT INTO colors VALUES (281,'Golden Brown','EAC117','on'); 953INSERT INTO colors VALUES (282,'Macaroni and Cheese','F2BB66','on'); 954INSERT INTO colors VALUES (283,'Saffron','FBB917','on'); 955INSERT INTO colors VALUES (284,'Beer','FBB117','on'); 956INSERT INTO colors VALUES (285,'Cantaloupe','FFA62F','on'); 957INSERT INTO colors VALUES (286,'Bee Yellow','E9AB17','on'); 958INSERT INTO colors VALUES (287,'Brown Sugar','E2A76F','on'); 959INSERT INTO colors VALUES (288,'BurlyWood','DEB887','on'); 960INSERT INTO colors VALUES (289,'Deep Peach','FFCBA4','on'); 961INSERT INTO colors VALUES (290,'Ginger Brown','C9BE62','on'); 962INSERT INTO colors VALUES (291,'School Bus Yellow','E8A317','on'); 963INSERT INTO colors VALUES (292,'Sandy Brown','EE9A4D','on'); 964INSERT INTO colors VALUES (293,'Fall Leaf Brown','C8B560','on'); 965INSERT INTO colors VALUES (294,'Orange Gold','D4A017','on'); 966INSERT INTO colors VALUES (295,'Sand','C2B280','on'); 967INSERT INTO colors VALUES (296,'Cookie Brown','C7A317','on'); 968INSERT INTO colors VALUES (297,'Caramel','C68E17','on'); 969INSERT INTO colors VALUES (298,'Brass','B5A642','on'); 970INSERT INTO colors VALUES (299,'Khaki','ADA96E','on'); 971INSERT INTO colors VALUES (300,'Camel Brown','C19A6B','on'); 972INSERT INTO colors VALUES (301,'Bronze','CD7F32','on'); 973INSERT INTO colors VALUES (302,'Tiger Orange','C88141','on'); 974INSERT INTO colors VALUES (303,'Cinnamon','C58917','on'); 975INSERT INTO colors VALUES (304,'Bullet Shell','AF9B60','on'); 976INSERT INTO colors VALUES (305,'Dark Goldenrod','AF7817','on'); 977INSERT INTO colors VALUES (306,'Copper','B87333','on'); 978INSERT INTO colors VALUES (307,'Wood','966F33','on'); 979INSERT INTO colors VALUES (308,'Oak Brown','806517','on'); 980INSERT INTO colors VALUES (309,'Moccasin','827839','on'); 981INSERT INTO colors VALUES (310,'Army Brown','827B60','on'); 982INSERT INTO colors VALUES (311,'Sandstone','786D5F','on'); 983INSERT INTO colors VALUES (312,'Mocha','493D26','on'); 984INSERT INTO colors VALUES (313,'Taupe','483C32','on'); 985INSERT INTO colors VALUES (314,'Coffee','6F4E37','on'); 986INSERT INTO colors VALUES (315,'Brown Bear','835C3B','on'); 987INSERT INTO colors VALUES (316,'Red Dirt','7F5217','on'); 988INSERT INTO colors VALUES (317,'Sepia','7F462C','on'); 989INSERT INTO colors VALUES (318,'Orange Salmon','C47451','on'); 990INSERT INTO colors VALUES (319,'Rust','C36241','on'); 991INSERT INTO colors VALUES (320,'Red Fox','C35817','on'); 992INSERT INTO colors VALUES (321,'Chocolate','C85A17','on'); 993INSERT INTO colors VALUES (322,'Sedona','CC6600','on'); 994INSERT INTO colors VALUES (323,'Papaya Orange','E56717','on'); 995INSERT INTO colors VALUES (324,'Halloween Orange','E66C2C','on'); 996INSERT INTO colors VALUES (325,'Pumpkin Orange','F87217','on'); 997INSERT INTO colors VALUES (326,'Construction Cone Orange','F87431','on'); 998INSERT INTO colors VALUES (327,'Sunrise Orange','E67451','on'); 999INSERT INTO colors VALUES (328,'Mango Orange','FF8040','on'); 1000INSERT INTO colors VALUES (329,'Dark Orange','F88017','on'); 1001INSERT INTO colors VALUES (330,'Coral','FF7F50','on'); 1002INSERT INTO colors VALUES (331,'Basket Ball Orange','F88158','on'); 1003INSERT INTO colors VALUES (332,'Light Salmon','F9966B','on'); 1004INSERT INTO colors VALUES (333,'Tangerine','E78A61','on'); 1005INSERT INTO colors VALUES (334,'Dark Salmon','E18B6B','on'); 1006INSERT INTO colors VALUES (335,'Light Coral','E77471','on'); 1007INSERT INTO colors VALUES (336,'Bean Red','F75D59','on'); 1008INSERT INTO colors VALUES (337,'Valentine Red','E55451','on'); 1009INSERT INTO colors VALUES (338,'Shocking Orange','E55B3C','on'); 1010INSERT INTO colors VALUES (339,'Scarlet','FF2400','on'); 1011INSERT INTO colors VALUES (340,'Ruby Red','F62217','on'); 1012INSERT INTO colors VALUES (341,'Ferrari Red','F70D1A','on'); 1013INSERT INTO colors VALUES (342,'Fire Engine Red','F62817','on'); 1014INSERT INTO colors VALUES (343,'Lava Red','E42217','on'); 1015INSERT INTO colors VALUES (344,'Love Red','E41B17','on'); 1016INSERT INTO colors VALUES (345,'Grapefruit','DC381F','on'); 1017INSERT INTO colors VALUES (346,'Chestnut Red','C34A2C','on'); 1018INSERT INTO colors VALUES (347,'Cherry Red','C24641','on'); 1019INSERT INTO colors VALUES (348,'Mahogany','C04000','on'); 1020INSERT INTO colors VALUES (349,'Chilli Pepper','C11B17','on'); 1021INSERT INTO colors VALUES (350,'Cranberry','9F000F','on'); 1022INSERT INTO colors VALUES (351,'Red Wine','990012','on'); 1023INSERT INTO colors VALUES (352,'Burgundy','8C001A','on'); 1024INSERT INTO colors VALUES (353,'Chestnut','954535','on'); 1025INSERT INTO colors VALUES (354,'Blood Red','7E3517','on'); 1026INSERT INTO colors VALUES (355,'Sienna','8A4117','on'); 1027INSERT INTO colors VALUES (356,'Sangria','7E3817','on'); 1028INSERT INTO colors VALUES (357,'Firebrick','800517','on'); 1029INSERT INTO colors VALUES (358,'Maroon','810541','on'); 1030INSERT INTO colors VALUES (359,'Plum Pie','7D0541','on'); 1031INSERT INTO colors VALUES (360,'Velvet Maroon','7E354D','on'); 1032INSERT INTO colors VALUES (361,'Plum Velvet','7D0552','on'); 1033INSERT INTO colors VALUES (362,'Rosy Finch','7F4E52','on'); 1034INSERT INTO colors VALUES (363,'Puce','7F5A58','on'); 1035INSERT INTO colors VALUES (364,'Dull Purple','7F525D','on'); 1036INSERT INTO colors VALUES (365,'Rosy Brown','B38481','on'); 1037INSERT INTO colors VALUES (366,'Khaki Rose','C5908E','on'); 1038INSERT INTO colors VALUES (367,'Pink Bow','C48189','on'); 1039INSERT INTO colors VALUES (368,'Lipstick Pink','C48793','on'); 1040INSERT INTO colors VALUES (369,'Rose','E8ADAA','on'); 1041INSERT INTO colors VALUES (370,'Desert Sand','EDC9AF','on'); 1042INSERT INTO colors VALUES (371,'Pig Pink','FDD7E4','on'); 1043INSERT INTO colors VALUES (372,'Cotton Candy','FCDFFF','on'); 1044INSERT INTO colors VALUES (373,'Pink Bubblegum','FFDFDD','on'); 1045INSERT INTO colors VALUES (374,'Misty Rose','FBBBB9','on'); 1046INSERT INTO colors VALUES (375,'Pink','FAAFBE','on'); 1047INSERT INTO colors VALUES (376,'Light Pink','FAAFBA','on'); 1048INSERT INTO colors VALUES (377,'Flamingo Pink','F9A7B0','on'); 1049INSERT INTO colors VALUES (378,'Pink Rose','E7A1B0','on'); 1050INSERT INTO colors VALUES (379,'Pink Daisy','E799A3','on'); 1051INSERT INTO colors VALUES (380,'Cadillac Pink','E38AAE','on'); 1052INSERT INTO colors VALUES (381,'Carnation Pink','F778A1','on'); 1053INSERT INTO colors VALUES (382,'Blush Red','E56E94','on'); 1054INSERT INTO colors VALUES (383,'Hot Pink','F660AB','on'); 1055INSERT INTO colors VALUES (384,'Watermelon Pink','FC6C85','on'); 1056INSERT INTO colors VALUES (385,'Violet Red','F6358A','on'); 1057INSERT INTO colors VALUES (386,'Deep Pink','F52887','on'); 1058INSERT INTO colors VALUES (387,'Pink Cupcake','E45E9D','on'); 1059INSERT INTO colors VALUES (388,'Pink Lemonade','E4287C','on'); 1060INSERT INTO colors VALUES (389,'Neon Pink','F535AA','on'); 1061INSERT INTO colors VALUES (390,'Dimorphotheca Magenta','E3319D','on'); 1062INSERT INTO colors VALUES (391,'Bright Neon Pink','F433FF','on'); 1063INSERT INTO colors VALUES (392,'Pale Violet Red','D16587','on'); 1064INSERT INTO colors VALUES (393,'Tulip Pink','C25A7C','on'); 1065INSERT INTO colors VALUES (394,'Medium Violet Red','CA226B','on'); 1066INSERT INTO colors VALUES (395,'Rogue Pink','C12869','on'); 1067INSERT INTO colors VALUES (396,'Burnt Pink','C12267','on'); 1068INSERT INTO colors VALUES (397,'Bashful Pink','C25283','on'); 1069INSERT INTO colors VALUES (398,'Carnation Pink','C12283','on'); 1070INSERT INTO colors VALUES (399,'Plum','B93B8F','on'); 1071INSERT INTO colors VALUES (400,'Viola Purple','7E587E','on'); 1072INSERT INTO colors VALUES (401,'Purple Iris','571B7E','on'); 1073INSERT INTO colors VALUES (402,'Plum Purple','583759','on'); 1074INSERT INTO colors VALUES (403,'Indigo','4B0082','on'); 1075INSERT INTO colors VALUES (404,'Purple Monster','461B7E','on'); 1076INSERT INTO colors VALUES (405,'Purple Haze','4E387E','on'); 1077INSERT INTO colors VALUES (406,'Eggplant','614051','on'); 1078INSERT INTO colors VALUES (407,'Grape','5E5A80','on'); 1079INSERT INTO colors VALUES (408,'Purple Jam','6A287E','on'); 1080INSERT INTO colors VALUES (409,'Dark Orchid','7D1B7E','on'); 1081INSERT INTO colors VALUES (410,'Purple Flower','A74AC7','on'); 1082INSERT INTO colors VALUES (411,'Medium Orchid','B048B5','on'); 1083INSERT INTO colors VALUES (412,'Purple Amethyst','6C2DC7','on'); 1084INSERT INTO colors VALUES (413,'Dark Violet','842DCE','on'); 1085INSERT INTO colors VALUES (414,'Violet','8D38C9','on'); 1086INSERT INTO colors VALUES (415,'Purple Sage Bush','7A5DC7','on'); 1087INSERT INTO colors VALUES (416,'Lovely Purple','7F38EC','on'); 1088INSERT INTO colors VALUES (417,'Purple','8E35EF','on'); 1089INSERT INTO colors VALUES (418,'Aztech Purple','893BFF','on'); 1090INSERT INTO colors VALUES (419,'Medium Purple','8467D7','on'); 1091INSERT INTO colors VALUES (420,'Jasmine Purple','A23BEC','on'); 1092INSERT INTO colors VALUES (421,'Purple Daffodil','B041FF','on'); 1093INSERT INTO colors VALUES (422,'Tyrian Purple','C45AEC','on'); 1094INSERT INTO colors VALUES (423,'Crocus Purple','9172EC','on'); 1095INSERT INTO colors VALUES (424,'Purple Mimosa','9E7BFF','on'); 1096INSERT INTO colors VALUES (425,'Heliotrope Purple','D462FF','on'); 1097INSERT INTO colors VALUES (426,'Crimson','E238EC','on'); 1098INSERT INTO colors VALUES (427,'Purple Dragon','C38EC7','on'); 1099INSERT INTO colors VALUES (428,'Lilac','C8A2C8','on'); 1100INSERT INTO colors VALUES (429,'Blush Pink','E6A9EC','on'); 1101INSERT INTO colors VALUES (430,'Mauve','E0B0FF','on'); 1102INSERT INTO colors VALUES (431,'Wisteria Purple','C6AEC7','on'); 1103INSERT INTO colors VALUES (432,'Blossom Pink','F9B7FF','on'); 1104INSERT INTO colors VALUES (433,'Thistle','D2B9D3','on'); 1105INSERT INTO colors VALUES (434,'Periwinkle','E9CFEC','on'); 1106INSERT INTO colors VALUES (435,'Lavender Pinocchio','EBDDE2','on'); 1107INSERT INTO colors VALUES (436,'Lavender Blue','E3E4FA','on'); 1108INSERT INTO colors VALUES (437,'Pearl','FDEEF4','on'); 1109INSERT INTO colors VALUES (438,'SeaShell','FFF5EE','on'); 1110INSERT INTO colors VALUES (439,'Milk White','FEFCFF','on'); 1111 1112-- 1113-- Table structure for table `data_input` 1114-- 1115 1116CREATE TABLE data_input ( 1117 id mediumint(8) unsigned NOT NULL auto_increment, 1118 hash varchar(32) NOT NULL default '', 1119 name varchar(200) NOT NULL default '', 1120 input_string varchar(512) default NULL, 1121 type_id tinyint(2) NOT NULL default '0', 1122 PRIMARY KEY (id), 1123 KEY `name_type_id` (`name`(171), `type_id`) 1124) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1125 1126-- 1127-- Dumping data for table `data_input` 1128-- 1129 1130INSERT INTO data_input VALUES (1,'3eb92bb845b9660a7445cf9740726522','Get SNMP Data','',2); 1131INSERT INTO data_input VALUES (2,'bf566c869ac6443b0c75d1c32b5a350e','Get SNMP Data (Indexed)','',3); 1132INSERT INTO data_input VALUES (3,'274f4685461170b9eb1b98d22567ab5e','Unix - Get Free Disk Space','<path_cacti>/scripts/diskfree.sh <partition>',1); 1133INSERT INTO data_input VALUES (4,'95ed0993eb3095f9920d431ac80f4231','Unix - Get Load Average','perl <path_cacti>/scripts/loadavg_multi.pl',1); 1134INSERT INTO data_input VALUES (5,'79a284e136bb6b061c6f96ec219ac448','Unix - Get Logged In Users','perl <path_cacti>/scripts/unix_users.pl <username>',1); 1135INSERT INTO data_input VALUES (6,'362e6d4768937c4f899dd21b91ef0ff8','Linux - Get Memory Usage','perl <path_cacti>/scripts/linux_memory.pl <grepstr>',1); 1136INSERT INTO data_input VALUES (7,'a637359e0a4287ba43048a5fdf202066','Unix - Get System Processes','perl <path_cacti>/scripts/unix_processes.pl',1); 1137INSERT INTO data_input VALUES (8,'47d6bfe8be57a45171afd678920bd399','Unix - Get TCP Connections','perl <path_cacti>/scripts/unix_tcp_connections.pl <grepstr>',1); 1138INSERT INTO data_input VALUES (9,'cc948e4de13f32b6aea45abaadd287a3','Unix - Get Web Hits','perl <path_cacti>/scripts/webhits.pl <log_path>',1); 1139INSERT INTO data_input VALUES (10,'8bd153aeb06e3ff89efc73f35849a7a0','Unix - Ping Host','perl <path_cacti>/scripts/ping.pl <ip>',1); 1140INSERT INTO data_input VALUES (11,'80e9e4c4191a5da189ae26d0e237f015','Get Script Data (Indexed)','',4); 1141INSERT INTO data_input VALUES (12,'332111d8b54ac8ce939af87a7eac0c06','Get Script Server Data (Indexed)','',6); 1142 1143-- 1144-- Table structure for table `data_input_data` 1145-- 1146 1147CREATE TABLE data_input_data ( 1148 data_input_field_id mediumint(8) unsigned NOT NULL default '0', 1149 data_template_data_id int(10) unsigned NOT NULL default '0', 1150 t_value char(2) default NULL, 1151 value text, 1152 PRIMARY KEY (data_input_field_id,data_template_data_id), 1153 KEY data_template_data_id (data_template_data_id), 1154 KEY t_value (t_value) 1155) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1156 1157-- 1158-- Dumping data for table `data_input_data` 1159-- 1160 1161INSERT INTO `data_input_data` VALUES (1,4,'',''); 1162INSERT INTO `data_input_data` VALUES (1,5,'',''); 1163INSERT INTO `data_input_data` VALUES (1,6,'',''); 1164INSERT INTO `data_input_data` VALUES (1,19,'',''); 1165INSERT INTO `data_input_data` VALUES (1,20,'',''); 1166INSERT INTO `data_input_data` VALUES (1,22,'',''); 1167INSERT INTO `data_input_data` VALUES (1,23,'',''); 1168INSERT INTO `data_input_data` VALUES (1,24,'',''); 1169INSERT INTO `data_input_data` VALUES (1,25,'',''); 1170INSERT INTO `data_input_data` VALUES (1,26,'',''); 1171INSERT INTO `data_input_data` VALUES (1,27,'',''); 1172INSERT INTO `data_input_data` VALUES (1,30,'',''); 1173INSERT INTO `data_input_data` VALUES (1,31,'',''); 1174INSERT INTO `data_input_data` VALUES (1,32,'',''); 1175INSERT INTO `data_input_data` VALUES (1,33,'',''); 1176INSERT INTO `data_input_data` VALUES (1,34,'',''); 1177INSERT INTO `data_input_data` VALUES (1,58,'',''); 1178INSERT INTO `data_input_data` VALUES (1,59,'',''); 1179INSERT INTO `data_input_data` VALUES (1,68,'',''); 1180INSERT INTO `data_input_data` VALUES (2,4,'',''); 1181INSERT INTO `data_input_data` VALUES (2,5,'',''); 1182INSERT INTO `data_input_data` VALUES (2,6,'',''); 1183INSERT INTO `data_input_data` VALUES (2,19,'',''); 1184INSERT INTO `data_input_data` VALUES (2,20,'',''); 1185INSERT INTO `data_input_data` VALUES (2,22,'',''); 1186INSERT INTO `data_input_data` VALUES (2,23,'',''); 1187INSERT INTO `data_input_data` VALUES (2,24,'',''); 1188INSERT INTO `data_input_data` VALUES (2,25,'',''); 1189INSERT INTO `data_input_data` VALUES (2,26,'',''); 1190INSERT INTO `data_input_data` VALUES (2,27,'',''); 1191INSERT INTO `data_input_data` VALUES (2,30,'',''); 1192INSERT INTO `data_input_data` VALUES (2,31,'',''); 1193INSERT INTO `data_input_data` VALUES (2,32,'',''); 1194INSERT INTO `data_input_data` VALUES (2,33,'',''); 1195INSERT INTO `data_input_data` VALUES (2,34,'',''); 1196INSERT INTO `data_input_data` VALUES (2,58,'',''); 1197INSERT INTO `data_input_data` VALUES (2,59,'',''); 1198INSERT INTO `data_input_data` VALUES (2,68,'',''); 1199INSERT INTO `data_input_data` VALUES (3,4,'',''); 1200INSERT INTO `data_input_data` VALUES (3,5,'',''); 1201INSERT INTO `data_input_data` VALUES (3,6,'',''); 1202INSERT INTO `data_input_data` VALUES (3,19,'',''); 1203INSERT INTO `data_input_data` VALUES (3,20,'',''); 1204INSERT INTO `data_input_data` VALUES (3,22,'',''); 1205INSERT INTO `data_input_data` VALUES (3,23,'',''); 1206INSERT INTO `data_input_data` VALUES (3,24,'',''); 1207INSERT INTO `data_input_data` VALUES (3,25,'',''); 1208INSERT INTO `data_input_data` VALUES (3,26,'',''); 1209INSERT INTO `data_input_data` VALUES (3,27,'',''); 1210INSERT INTO `data_input_data` VALUES (3,30,'',''); 1211 1212-- 1213-- Table structure for table `data_input_fields` 1214-- 1215 1216CREATE TABLE data_input_fields ( 1217 id mediumint(8) unsigned NOT NULL auto_increment, 1218 hash varchar(32) NOT NULL default '', 1219 data_input_id mediumint(8) unsigned NOT NULL default '0', 1220 name varchar(200) NOT NULL default '', 1221 data_name varchar(50) NOT NULL default '', 1222 input_output char(3) NOT NULL default '', 1223 update_rra char(2) default '0', 1224 sequence smallint(5) NOT NULL default '0', 1225 type_code varchar(40) default NULL, 1226 regexp_match varchar(200) default NULL, 1227 allow_nulls char(2) default NULL, 1228 PRIMARY KEY (id), 1229 KEY data_input_id (data_input_id), 1230 KEY input_output (input_output), 1231 KEY type_code_data_input_id (type_code, data_input_id) 1232) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1233 1234-- 1235-- Dumping data for table `data_input_fields` 1236-- 1237 1238INSERT INTO `data_input_fields` VALUES (1,'92f5906c8dc0f964b41f4253df582c38',1,'SNMP IP Address','management_ip','in','',0,'hostname','',''); 1239INSERT INTO `data_input_fields` VALUES (2,'32285d5bf16e56c478f5e83f32cda9ef',1,'SNMP Community','snmp_community','in','',0,'snmp_community','',''); 1240INSERT INTO `data_input_fields` VALUES (3,'ad14ac90641aed388139f6ba86a2e48b',1,'SNMP Username','snmp_username','in','',0,'snmp_username','','on'); 1241INSERT INTO `data_input_fields` VALUES (4,'9c55a74bd571b4f00a96fd4b793278c6',1,'SNMP Password','snmp_password','in','',0,'snmp_password','','on'); 1242INSERT INTO `data_input_fields` VALUES (5,'012ccb1d3687d3edb29c002ea66e72da',1,'SNMP Version (1, 2, or 3)','snmp_version','in','',0,'snmp_version','','on'); 1243INSERT INTO `data_input_fields` VALUES (6,'4276a5ec6e3fe33995129041b1909762',1,'OID','oid','in','',0,'snmp_oid','',''); 1244INSERT INTO `data_input_fields` VALUES (7,'617cdc8a230615e59f06f361ef6e7728',2,'SNMP IP Address','management_ip','in','',0,'hostname','',''); 1245INSERT INTO `data_input_fields` VALUES (8,'acb449d1451e8a2a655c2c99d31142c7',2,'SNMP Community','snmp_community','in','',0,'snmp_community','',''); 1246INSERT INTO `data_input_fields` VALUES (9,'f4facc5e2ca7ebee621f09bc6d9fc792',2,'SNMP Username (v3)','snmp_username','in','',0,'snmp_username','','on'); 1247INSERT INTO `data_input_fields` VALUES (10,'1cc1493a6781af2c478fa4de971531cf',2,'SNMP Password (v3)','snmp_password','in','',0,'snmp_password','','on'); 1248INSERT INTO `data_input_fields` VALUES (11,'b5c23f246559df38662c255f4aa21d6b',2,'SNMP Version (1, 2, or 3)','snmp_version','in','',0,'snmp_version','',''); 1249INSERT INTO `data_input_fields` VALUES (12,'6027a919c7c7731fbe095b6f53ab127b',2,'Index Type','index_type','in','',0,'index_type','',''); 1250INSERT INTO `data_input_fields` VALUES (13,'cbbe5c1ddfb264a6e5d509ce1c78c95f',2,'Index Value','index_value','in','',0,'index_value','',''); 1251INSERT INTO `data_input_fields` VALUES (14,'e6deda7be0f391399c5130e7c4a48b28',2,'Output Type ID','output_type','in','',0,'output_type','',''); 1252INSERT INTO `data_input_fields` VALUES (15,'edfd72783ad02df128ff82fc9324b4b9',3,'Disk Partition','partition','in','',1,'','',''); 1253INSERT INTO `data_input_fields` VALUES (16,'8b75fb61d288f0b5fc0bd3056af3689b',3,'Kilobytes Free','kilobytes','out','on',0,'','',''); 1254INSERT INTO `data_input_fields` VALUES (17,'363588d49b263d30aecb683c52774f39',4,'1 Minute Average','1min','out','on',0,'','',''); 1255INSERT INTO `data_input_fields` VALUES (18,'ad139a9e1d69881da36fca07889abf58',4,'5 Minute Average','5min','out','on',0,'','',''); 1256INSERT INTO `data_input_fields` VALUES (19,'5db9fee64824c08258c7ff6f8bc53337',4,'10 Minute Average','10min','out','on',0,'','',''); 1257INSERT INTO `data_input_fields` VALUES (20,'c0cfd0beae5e79927c5a360076706820',5,'Username (Optional)','username','in','',1,'','','on'); 1258INSERT INTO `data_input_fields` VALUES (21,'52c58ad414d9a2a83b00a7a51be75a53',5,'Logged In Users','users','out','on',0,'','',''); 1259INSERT INTO `data_input_fields` VALUES (22,'05eb5d710f0814871b8515845521f8d7',6,'Grep String','grepstr','in','',1,'','',''); 1260INSERT INTO `data_input_fields` VALUES (23,'86cb1cbfde66279dbc7f1144f43a3219',6,'Result (in Kilobytes)','kilobytes','out','on',0,'','',''); 1261INSERT INTO `data_input_fields` VALUES (24,'d5a8dd5fbe6a5af11667c0039af41386',7,'Number of Processes','proc','out','on',0,'','',''); 1262INSERT INTO `data_input_fields` VALUES (25,'8848cdcae831595951a3f6af04eec93b',8,'Grep String','grepstr','in','',1,'','','on'); 1263INSERT INTO `data_input_fields` VALUES (26,'3d1288d33008430ce354e8b9c162f7ff',8,'Connections','connections','out','on',0,'','',''); 1264INSERT INTO `data_input_fields` VALUES (27,'c6af570bb2ed9c84abf32033702e2860',9,'(Optional) Log Path','log_path','in','',1,'','','on'); 1265INSERT INTO `data_input_fields` VALUES (28,'f9389860f5c5340c9b27fca0b4ee5e71',9,'Web Hits','webhits','out','on',0,'','',''); 1266INSERT INTO `data_input_fields` VALUES (29,'5fbadb91ad66f203463c1187fe7bd9d5',10,'IP Address','ip','in','',1,'hostname','',''); 1267INSERT INTO `data_input_fields` VALUES (30,'6ac4330d123c69067d36a933d105e89a',10,'Milliseconds','out_ms','out','on',0,'','',''); 1268INSERT INTO `data_input_fields` VALUES (31,'d39556ecad6166701bfb0e28c5a11108',11,'Index Type','index_type','in','',0,'index_type','',''); 1269INSERT INTO `data_input_fields` VALUES (32,'3b7caa46eb809fc238de6ef18b6e10d5',11,'Index Value','index_value','in','',0,'index_value','',''); 1270INSERT INTO `data_input_fields` VALUES (33,'74af2e42dc12956c4817c2ef5d9983f9',11,'Output Type ID','output_type','in','',0,'output_type','',''); 1271INSERT INTO `data_input_fields` VALUES (34,'8ae57f09f787656bf4ac541e8bd12537',11,'Output Value','output','out','on',0,'','',''); 1272INSERT INTO `data_input_fields` VALUES (35,'172b4b0eacee4948c6479f587b62e512',12,'Index Type','index_type','in','',0,'index_type','',''); 1273INSERT INTO `data_input_fields` VALUES (36,'30fb5d5bcf3d66bb5abe88596f357c26',12,'Index Value','index_value','in','',0,'index_value','',''); 1274INSERT INTO `data_input_fields` VALUES (37,'31112c85ae4ff821d3b288336288818c',12,'Output Type ID','output_type','in','',0,'output_type','',''); 1275INSERT INTO `data_input_fields` VALUES (38,'5be8fa85472d89c621790b43510b5043',12,'Output Value','output','out','on',0,'','',''); 1276INSERT INTO `data_input_fields` VALUES (39,'c1f36ee60c3dc98945556d57f26e475b',2,'SNMP Port','snmp_port','in','',0,'snmp_port','',''); 1277INSERT INTO `data_input_fields` VALUES (40,'fc64b99742ec417cc424dbf8c7692d36',1,'SNMP Port','snmp_port','in','',0,'snmp_port','',''); 1278INSERT INTO `data_input_fields` VALUES (41,'20832ce12f099c8e54140793a091af90',1,'SNMP Authentication Protocol (v3)','snmp_auth_protocol','in','',0,'snmp_auth_protocol','',''); 1279INSERT INTO `data_input_fields` VALUES (42,'c60c9aac1e1b3555ea0620b8bbfd82cb',1,'SNMP Privacy Passphrase (v3)','snmp_priv_passphrase','in','',0,'snmp_priv_passphrase','',''); 1280INSERT INTO `data_input_fields` VALUES (43,'feda162701240101bc74148415ef415a',1,'SNMP Privacy Protocol (v3)','snmp_priv_protocol','in','',0,'snmp_priv_protocol','',''); 1281INSERT INTO `data_input_fields` VALUES (44,'2cf7129ad3ff819a7a7ac189bee48ce8',2,'SNMP Authentication Protocol (v3)','snmp_auth_protocol','in','',0,'snmp_auth_protocol','',''); 1282INSERT INTO `data_input_fields` VALUES (45,'6b13ac0a0194e171d241d4b06f913158',2,'SNMP Privacy Passphrase (v3)','snmp_priv_passphrase','in','',0,'snmp_priv_passphrase','',''); 1283INSERT INTO `data_input_fields` VALUES (46,'3a33d4fc65b8329ab2ac46a36da26b72',2,'SNMP Privacy Protocol (v3)','snmp_priv_protocol','in','',0,'snmp_priv_protocol','',''); 1284 1285-- 1286-- Table structure for table `data_local` 1287-- 1288 1289CREATE TABLE data_local ( 1290 id int(10) unsigned NOT NULL auto_increment, 1291 data_template_id mediumint(8) unsigned NOT NULL default '0', 1292 host_id mediumint(8) unsigned NOT NULL default '0', 1293 snmp_query_id mediumint(8) NOT NULL default '0', 1294 snmp_index varchar(255) NOT NULL default '', 1295 orphan tinyint(1) unsigned NOT NULL default '0', 1296 PRIMARY KEY (id), 1297 KEY data_template_id (data_template_id), 1298 KEY snmp_query_id (snmp_query_id), 1299 KEY snmp_index (snmp_index), 1300 KEY host_id_snmp_query_id (host_id, snmp_query_id) 1301) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1302 1303-- 1304-- Dumping data for table `data_local` 1305-- 1306 1307-- 1308-- Table structure for table `data_debug` 1309-- 1310 1311CREATE TABLE `data_debug` ( 1312 `id` int(11) unsigned NOT NULL auto_increment, 1313 `started` int(11) NOT NULL default '0', 1314 `done` int(11) NOT NULL default '0', 1315 `user` int(11) NOT NULL default '0', 1316 `datasource` int(11) NOT NULL default '0', 1317 `info` text NOT NULL default '', 1318 `issue` text NOT NULL NULL default '', 1319 PRIMARY KEY (`id`), 1320 KEY `user` (`user`), 1321 KEY `done` (`done`), 1322 KEY `datasource` (`datasource`), 1323 KEY `started` (`started`) 1324) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Datasource Debugger Information'; 1325 1326-- 1327-- Dumping data for table `data_debug` 1328-- 1329 1330-- 1331-- Table structure for table `data_source_profiles` 1332-- 1333 1334CREATE TABLE `data_source_profiles` ( 1335 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 1336 `hash` varchar(32) NOT NULL DEFAULT '', 1337 `name` varchar(255) NOT NULL DEFAULT '', 1338 `step` int(10) unsigned NOT NULL DEFAULT '300', 1339 `heartbeat` int(10) unsigned NOT NULL DEFAULT '600', 1340 `x_files_factor` double DEFAULT '0.5', 1341 `default` char(2) DEFAULT '', 1342 PRIMARY KEY (`id`), 1343 KEY `name` (`name`(171)) 1344) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Stores Data Source Profiles'; 1345 1346-- 1347-- Dumping data for table `data_source_profiles` 1348-- 1349 1350INSERT INTO `data_source_profiles` VALUES (1,'d62c52891f4f9688729a5bc9fad91b18','5 Minute Collection',300,600,0.5,'on'); 1351INSERT INTO `data_source_profiles` VALUES (2,'c0dd0e46b9ca268e7ed4162d329f9215','30 Second Collection',30,1200,0.5,''); 1352INSERT INTO `data_source_profiles` VALUES (3,'66d35da8f75c912ede3dbe901fedcae0','1 Minute Collection',60,600,0.5,''); 1353 1354-- 1355-- Table structure for table `data_source_profiles_cf` 1356-- 1357 1358CREATE TABLE `data_source_profiles_cf` ( 1359 `data_source_profile_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 1360 `consolidation_function_id` smallint(5) unsigned NOT NULL DEFAULT '0', 1361 PRIMARY KEY (`data_source_profile_id`,`consolidation_function_id`), 1362 KEY `data_source_profile_id` (`data_source_profile_id`) 1363) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Maps the Data Source Profile Consolidation Functions'; 1364 1365-- 1366-- Dumping data for table `data_source_profiles_cf` 1367-- 1368 1369INSERT INTO `data_source_profiles_cf` VALUES (1,1); 1370INSERT INTO `data_source_profiles_cf` VALUES (1,2); 1371INSERT INTO `data_source_profiles_cf` VALUES (1,3); 1372INSERT INTO `data_source_profiles_cf` VALUES (1,4); 1373INSERT INTO `data_source_profiles_cf` VALUES (2,1); 1374INSERT INTO `data_source_profiles_cf` VALUES (2,2); 1375INSERT INTO `data_source_profiles_cf` VALUES (2,3); 1376INSERT INTO `data_source_profiles_cf` VALUES (2,4); 1377INSERT INTO `data_source_profiles_cf` VALUES (3,1); 1378INSERT INTO `data_source_profiles_cf` VALUES (3,2); 1379INSERT INTO `data_source_profiles_cf` VALUES (3,3); 1380INSERT INTO `data_source_profiles_cf` VALUES (3,4); 1381 1382-- 1383-- Table structure for table `data_source_profiles_rra` 1384-- 1385 1386CREATE TABLE `data_source_profiles_rra` ( 1387 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 1388 `data_source_profile_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 1389 `name` varchar(255) NOT NULL DEFAULT '', 1390 `steps` int(10) unsigned DEFAULT '1', 1391 `rows` int(10) unsigned NOT NULL DEFAULT '700', 1392 `timespan` int(10) unsigned NOT NULL DEFAULT '0', 1393 PRIMARY KEY (`id`), 1394 KEY `data_source_profile_id` (`data_source_profile_id`) 1395) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Stores RRA Definitions for Data Source Profiles'; 1396 1397-- 1398-- Dumping data for table `data_source_profiles_rra` 1399-- 1400 1401INSERT INTO `data_source_profiles_rra` VALUES (1,1,'Daily (5 Minute Average)',1,600,86400); 1402INSERT INTO `data_source_profiles_rra` VALUES (2,1,'Weekly (30 Minute Average)',6,700,604800); 1403INSERT INTO `data_source_profiles_rra` VALUES (3,1,'Monthly (2 Hour Average)',24,775,2618784); 1404INSERT INTO `data_source_profiles_rra` VALUES (4,1,'Yearly (1 Day Average)',288,797,31536000); 1405INSERT INTO `data_source_profiles_rra` VALUES (5,2,'Daily (30 Second Average)',1,2900,86400); 1406INSERT INTO `data_source_profiles_rra` VALUES (6,2,'Weekly (15 Minute Average)',30,1346,604800); 1407INSERT INTO `data_source_profiles_rra` VALUES (7,2,'Monthly (1 Hour Average)',120,1445,2618784); 1408INSERT INTO `data_source_profiles_rra` VALUES (8,2,'Yearly (4 Hour Average)',480,4380,31536000); 1409INSERT INTO `data_source_profiles_rra` VALUES (9,3,'Daily (1 Minute Average)',1,2900,86400); 1410INSERT INTO `data_source_profiles_rra` VALUES (10,3,'Weekly (15 Minute Average)',15,1440,604800); 1411INSERT INTO `data_source_profiles_rra` VALUES (11,3,'Monthly (1 Hour Average)',60,8784,2618784); 1412INSERT INTO `data_source_profiles_rra` VALUES (12,3,'Yearly (12 Hour Average)',720,7305,31536000); 1413 1414-- 1415-- Table structure for table `data_source_purge_action` 1416-- 1417 1418CREATE TABLE `data_source_purge_action` ( 1419 `id` integer UNSIGNED auto_increment, 1420 `name` varchar(128) NOT NULL default '', 1421 `local_data_id` int(10) unsigned NOT NULL default '0', 1422 `action` tinyint(2) NOT NULL default 0, 1423 PRIMARY KEY (`id`), 1424 UNIQUE KEY name (`name`)) 1425 ENGINE=InnoDB 1426 ROW_FORMAT=Dynamic 1427 COMMENT='RRD Cleaner File Actions'; 1428 1429-- 1430-- Table structure for table `data_source_purge_temp` 1431-- 1432 1433CREATE TABLE `data_source_purge_temp` ( 1434 `id` integer UNSIGNED auto_increment, 1435 `name_cache` varchar(255) NOT NULL default '', 1436 `local_data_id` int(10) unsigned NOT NULL default '0', 1437 `name` varchar(128) NOT NULL default '', 1438 `size` integer UNSIGNED NOT NULL default '0', 1439 `last_mod` TIMESTAMP NOT NULL default '0000-00-00 00:00:00', 1440 `in_cacti` tinyint NOT NULL default '0', 1441 `data_template_id` mediumint(8) unsigned NOT NULL default '0', 1442 PRIMARY KEY (`id`), 1443 UNIQUE KEY name (`name`), 1444 KEY local_data_id (`local_data_id`), 1445 KEY in_cacti (`in_cacti`), 1446 KEY data_template_id (`data_template_id`)) 1447 ENGINE=InnoDB 1448 ROW_FORMAT=Dynamic 1449 COMMENT='RRD Cleaner File Repository'; 1450 1451 1452-- 1453-- Table structure for table `data_source_stats_daily` 1454-- 1455 1456CREATE TABLE `data_source_stats_daily` ( 1457 `local_data_id` int(10) unsigned NOT NULL, 1458 `rrd_name` varchar(19) NOT NULL, 1459 `average` DOUBLE DEFAULT NULL, 1460 `peak` DOUBLE DEFAULT NULL, 1461 PRIMARY KEY (`local_data_id`,`rrd_name`) 1462 ) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1463 1464-- 1465-- Table structure for table `data_source_stats_hourly` 1466-- 1467 1468CREATE TABLE `data_source_stats_hourly` ( 1469 `local_data_id` int(10) unsigned NOT NULL, 1470 `rrd_name` varchar(19) NOT NULL, 1471 `average` DOUBLE DEFAULT NULL, 1472 `peak` DOUBLE DEFAULT NULL, 1473 PRIMARY KEY (`local_data_id`,`rrd_name`) 1474 ) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1475 1476-- 1477-- Table structure for table `data_source_stats_hourly_cache` 1478-- 1479 1480CREATE TABLE `data_source_stats_hourly_cache` ( 1481 `local_data_id` int(10) unsigned NOT NULL, 1482 `rrd_name` varchar(19) NOT NULL, 1483 `time` timestamp NOT NULL default '0000-00-00 00:00:00', 1484 `value` DOUBLE DEFAULT NULL, 1485 PRIMARY KEY (`local_data_id`,`time`,`rrd_name`), 1486 KEY `time` USING BTREE (`time`) 1487 ) ENGINE=MEMORY; 1488 1489-- 1490-- Table structure for table `data_source_stats_hourly_last` 1491-- 1492 1493CREATE TABLE `data_source_stats_hourly_last` ( 1494 `local_data_id` int(10) unsigned NOT NULL, 1495 `rrd_name` varchar(19) NOT NULL, 1496 `value` DOUBLE DEFAULT NULL, 1497 `calculated` DOUBLE DEFAULT NULL, 1498 PRIMARY KEY (`local_data_id`,`rrd_name`) 1499 ) ENGINE=MEMORY; 1500 1501-- 1502-- Table structure for table `data_source_stats_monthly` 1503-- 1504 1505CREATE TABLE `data_source_stats_monthly` ( 1506 `local_data_id` int(10) unsigned NOT NULL, 1507 `rrd_name` varchar(19) NOT NULL, 1508 `average` DOUBLE DEFAULT NULL, 1509 `peak` DOUBLE DEFAULT NULL, 1510 PRIMARY KEY (`local_data_id`,`rrd_name`) 1511 ) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1512 1513-- 1514-- Table structure for table `data_source_stats_weekly` 1515-- 1516 1517CREATE TABLE `data_source_stats_weekly` ( 1518 `local_data_id` int(10) unsigned NOT NULL, 1519 `rrd_name` varchar(19) NOT NULL, 1520 `average` DOUBLE DEFAULT NULL, 1521 `peak` DOUBLE DEFAULT NULL, 1522 PRIMARY KEY (`local_data_id`,`rrd_name`) 1523 ) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1524 1525-- 1526-- Table structure for table `data_source_stats_yearly` 1527-- 1528 1529CREATE TABLE `data_source_stats_yearly` ( 1530 `local_data_id` int(10) unsigned NOT NULL, 1531 `rrd_name` varchar(19) NOT NULL, 1532 `average` DOUBLE DEFAULT NULL, 1533 `peak` DOUBLE DEFAULT NULL, 1534 PRIMARY KEY (`local_data_id`,`rrd_name`) 1535 ) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1536 1537-- 1538-- Table structure for table `data_template` 1539-- 1540 1541CREATE TABLE data_template ( 1542 id mediumint(8) unsigned NOT NULL auto_increment, 1543 hash varchar(32) NOT NULL default '', 1544 name varchar(150) NOT NULL default '', 1545 PRIMARY KEY (id), 1546 KEY `name` (`name`) 1547) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1548 1549-- 1550-- Dumping data for table `data_template` 1551-- 1552 1553-- 1554-- Table structure for table `data_template_data` 1555-- 1556 1557CREATE TABLE data_template_data ( 1558 id int(10) unsigned NOT NULL auto_increment, 1559 local_data_template_data_id int(10) unsigned NOT NULL default '0', 1560 local_data_id int(10) unsigned NOT NULL default '0', 1561 data_template_id mediumint(8) unsigned NOT NULL default '0', 1562 data_input_id mediumint(8) unsigned NOT NULL default '0', 1563 t_name char(2) default NULL, 1564 name varchar(250) NOT NULL default '', 1565 name_cache varchar(255) NOT NULL default '', 1566 data_source_path varchar(255) default '', 1567 t_active char(2) default '', 1568 active char(2) default NULL, 1569 t_rrd_step char(2) default '', 1570 rrd_step mediumint(8) unsigned NOT NULL default '0', 1571 t_data_source_profile_id char(2) default '', 1572 data_source_profile_id mediumint(8) unsigned NOT NULL default '1', 1573 PRIMARY KEY (id), 1574 KEY local_data_id (local_data_id), 1575 KEY data_template_id (data_template_id), 1576 KEY data_input_id (data_input_id), 1577 KEY name_cache (name_cache) 1578) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1579 1580-- 1581-- Dumping data for table `data_template_data` 1582-- 1583 1584-- 1585-- Table structure for table `data_template_rrd` 1586-- 1587 1588CREATE TABLE data_template_rrd ( 1589 id int(10) unsigned NOT NULL auto_increment, 1590 hash varchar(32) NOT NULL default '', 1591 local_data_template_rrd_id int(10) unsigned NOT NULL default '0', 1592 local_data_id int(10) unsigned NOT NULL default '0', 1593 data_template_id mediumint(8) unsigned NOT NULL default '0', 1594 t_rrd_maximum char(2) default NULL, 1595 rrd_maximum varchar(20) NOT NULL default '0', 1596 t_rrd_minimum char(2) default NULL, 1597 rrd_minimum varchar(20) NOT NULL default '0', 1598 t_rrd_heartbeat char(2) default NULL, 1599 rrd_heartbeat mediumint(6) NOT NULL default '0', 1600 t_data_source_type_id char(2) default NULL, 1601 data_source_type_id smallint(5) NOT NULL default '0', 1602 t_data_source_name char(2) default NULL, 1603 data_source_name varchar(19) NOT NULL default '', 1604 t_data_input_field_id char(2) default NULL, 1605 data_input_field_id mediumint(8) unsigned NOT NULL default '0', 1606 PRIMARY KEY (id), 1607 UNIQUE KEY `duplicate_dsname_contraint` (`local_data_id`,`data_source_name`,`data_template_id`), 1608 KEY local_data_id (local_data_id), 1609 KEY data_template_id (data_template_id), 1610 KEY local_data_template_rrd_id (local_data_template_rrd_id) 1611) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1612 1613-- 1614-- Dumping data for table `data_template_rrd` 1615-- 1616 1617CREATE TABLE external_links ( 1618 id int(11) NOT NULL AUTO_INCREMENT, 1619 sortorder int(11) NOT NULL DEFAULT '0', 1620 enabled char(2) DEFAULT 'on', 1621 contentfile varchar(255) NOT NULL default '', 1622 title varchar(20) NOT NULL default '', 1623 style varchar(10) NOT NULL DEFAULT '', 1624 extendedstyle varchar(50) NOT NULL DEFAULT '', 1625 refresh int unsigned default NULL, 1626 PRIMARY KEY (id) 1627) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Contains external links that are embedded into Cacti'; 1628 1629-- 1630-- Table structure for table `graph_local` 1631-- 1632 1633CREATE TABLE graph_local ( 1634 id int(10) unsigned NOT NULL auto_increment, 1635 graph_template_id mediumint(8) unsigned NOT NULL default '0', 1636 host_id mediumint(8) unsigned NOT NULL default '0', 1637 snmp_query_id mediumint(8) NOT NULL default '0', 1638 snmp_query_graph_id mediumint(8) NOT NULL default '0', 1639 snmp_index varchar(255) NOT NULL default '', 1640 PRIMARY KEY (id), 1641 KEY host_id (host_id), 1642 KEY graph_template_id (graph_template_id), 1643 KEY snmp_query_id (snmp_query_id), 1644 KEY snmp_query_graph_id (snmp_query_graph_id), 1645 KEY snmp_index (snmp_index) 1646) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Creates a relationship for each item in a custom graph.'; 1647 1648-- 1649-- Dumping data for table `graph_local` 1650-- 1651 1652-- 1653-- Table structure for table `graph_template_input` 1654-- 1655 1656CREATE TABLE graph_template_input ( 1657 id mediumint(8) unsigned NOT NULL auto_increment, 1658 hash varchar(32) NOT NULL default '', 1659 graph_template_id mediumint(8) unsigned NOT NULL default '0', 1660 name varchar(255) NOT NULL default '', 1661 description text, 1662 column_name varchar(50) NOT NULL default '', 1663 PRIMARY KEY (id) 1664) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Stores the names for graph item input groups.'; 1665 1666-- 1667-- Dumping data for table `graph_template_input` 1668-- 1669 1670-- 1671-- Table structure for table `graph_template_input_defs` 1672-- 1673 1674CREATE TABLE graph_template_input_defs ( 1675 graph_template_input_id int(10) unsigned NOT NULL default '0', 1676 graph_template_item_id int(12) unsigned NOT NULL default '0', 1677 PRIMARY KEY (graph_template_input_id,graph_template_item_id), 1678 KEY graph_template_input_id (graph_template_input_id) 1679) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Stores the relationship for what graph items are associated'; 1680 1681-- 1682-- Dumping data for table `graph_template_input_defs` 1683-- 1684 1685-- 1686-- Table structure for table `graph_templates` 1687-- 1688 1689CREATE TABLE graph_templates ( 1690 `id` mediumint(8) unsigned NOT NULL auto_increment, 1691 `hash` char(32) NOT NULL default '', 1692 `name` char(255) NOT NULL default '', 1693 `multiple` char(2) NOT NULL default '', 1694 `test_source` char(2) NOT NULL default '', 1695 PRIMARY KEY (`id`), 1696 KEY `multiple_name` (`multiple`, `name`), 1697 KEY `name` (`name`) 1698) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Contains each graph template name.'; 1699 1700-- 1701-- Dumping data for table `graph_templates` 1702-- 1703 1704-- 1705-- Table structure for table `graph_templates_gprint` 1706-- 1707 1708CREATE TABLE graph_templates_gprint ( 1709 id mediumint(8) unsigned NOT NULL auto_increment, 1710 hash varchar(32) NOT NULL default '', 1711 name varchar(100) NOT NULL default '', 1712 gprint_text varchar(255) default NULL, 1713 PRIMARY KEY (id), 1714 KEY `name` (`name`) 1715) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1716 1717-- 1718-- Dumping data for table `graph_templates_gprint` 1719-- 1720 1721INSERT INTO graph_templates_gprint VALUES (2,'e9c43831e54eca8069317a2ce8c6f751','Normal','%8.2lf %s'); 1722INSERT INTO graph_templates_gprint VALUES (3,'19414480d6897c8731c7dc6c5310653e','Exact Numbers','%8.0lf'); 1723INSERT INTO graph_templates_gprint VALUES (4,'304a778405392f878a6db435afffc1e9','Load Average','%8.2lf'); 1724 1725-- 1726-- Table structure for table `graph_templates_graph` 1727-- 1728 1729CREATE TABLE graph_templates_graph ( 1730 id int(10) unsigned NOT NULL auto_increment, 1731 local_graph_template_graph_id int(10) unsigned NOT NULL default '0', 1732 local_graph_id int(10) unsigned NOT NULL default '0', 1733 graph_template_id mediumint(8) unsigned NOT NULL default '0', 1734 t_image_format_id char(2) default '', 1735 image_format_id tinyint(1) NOT NULL default '0', 1736 t_title char(2) default '', 1737 title varchar(255) NOT NULL default '', 1738 title_cache varchar(255) NOT NULL default '', 1739 t_height char(2) default '', 1740 height mediumint(8) NOT NULL default '0', 1741 t_width char(2) default '', 1742 width mediumint(8) NOT NULL default '0', 1743 t_upper_limit char(2) default '', 1744 upper_limit varchar(20) NOT NULL default '0', 1745 t_lower_limit char(2) default '', 1746 lower_limit varchar(20) NOT NULL default '0', 1747 t_vertical_label char(2) default '', 1748 vertical_label varchar(200) default NULL, 1749 t_slope_mode char(2) default '', 1750 slope_mode char(2) default 'on', 1751 t_auto_scale char(2) default '', 1752 auto_scale char(2) default NULL, 1753 t_auto_scale_opts char(2) default '', 1754 auto_scale_opts tinyint(1) NOT NULL default '0', 1755 t_auto_scale_log char(2) default '', 1756 auto_scale_log char(2) default NULL, 1757 t_scale_log_units char(2) default '', 1758 scale_log_units char(2) default NULL, 1759 t_auto_scale_rigid char(2) default '', 1760 auto_scale_rigid char(2) default NULL, 1761 t_auto_padding char(2) default '', 1762 auto_padding char(2) default NULL, 1763 t_base_value char(2) default '', 1764 base_value mediumint(8) NOT NULL default '0', 1765 `t_grouping` char(2) default '', 1766 `grouping` char(2) NOT NULL default '', 1767 t_unit_value char(2) default '', 1768 unit_value varchar(20) default NULL, 1769 t_unit_exponent_value char(2) default '', 1770 unit_exponent_value varchar(5) NOT NULL default '', 1771 t_alt_y_grid char(2) default '', 1772 alt_y_grid char(2) default NULL, 1773 t_right_axis char(2) DEFAULT '', 1774 right_axis varchar(20) DEFAULT NULL, 1775 t_right_axis_label char(2) DEFAULT '', 1776 right_axis_label varchar(200) DEFAULT NULL, 1777 t_right_axis_format char(2) DEFAULT '', 1778 right_axis_format mediumint(8) DEFAULT NULL, 1779 t_right_axis_formatter char(2) DEFAULT '', 1780 right_axis_formatter varchar(10) DEFAULT NULL, 1781 t_left_axis_formatter char(2) DEFAULT '', 1782 left_axis_formatter varchar(10) DEFAULT NULL, 1783 t_no_gridfit char(2) DEFAULT '', 1784 no_gridfit char(2) DEFAULT NULL, 1785 t_unit_length char(2) DEFAULT '', 1786 unit_length varchar(10) DEFAULT NULL, 1787 t_tab_width char(2) DEFAULT '', 1788 tab_width varchar(20) DEFAULT '30', 1789 t_dynamic_labels char(2) default '', 1790 dynamic_labels char(2) default NULL, 1791 t_force_rules_legend char(2) DEFAULT '', 1792 force_rules_legend char(2) DEFAULT NULL, 1793 t_legend_position char(2) DEFAULT '', 1794 legend_position varchar(10) DEFAULT NULL, 1795 t_legend_direction char(2) DEFAULT '', 1796 legend_direction varchar(10) DEFAULT NULL, 1797 PRIMARY KEY (id), 1798 KEY local_graph_id (local_graph_id), 1799 KEY graph_template_id (graph_template_id), 1800 KEY title_cache (title_cache) 1801) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Stores the actual graph data.'; 1802 1803-- 1804-- Dumping data for table `graph_templates_graph` 1805-- 1806 1807-- 1808-- Table structure for table `graph_templates_item` 1809-- 1810 1811CREATE TABLE graph_templates_item ( 1812 id int(10) unsigned NOT NULL auto_increment, 1813 hash varchar(32) NOT NULL default '', 1814 local_graph_template_item_id int(10) unsigned NOT NULL default '0', 1815 local_graph_id int(10) unsigned NOT NULL default '0', 1816 graph_template_id mediumint(8) unsigned NOT NULL default '0', 1817 task_item_id int(10) unsigned NOT NULL default '0', 1818 color_id mediumint(8) unsigned NOT NULL default '0', 1819 alpha char(2) default 'FF', 1820 graph_type_id tinyint(3) NOT NULL default '0', 1821 line_width DECIMAL(4,2) DEFAULT 0, 1822 dashes varchar(20) DEFAULT NULL, 1823 dash_offset mediumint(4) DEFAULT NULL, 1824 cdef_id mediumint(8) unsigned NOT NULL default '0', 1825 vdef_id mediumint(8) unsigned NOT NULL default '0', 1826 shift char(2) default NULL, 1827 consolidation_function_id tinyint(2) NOT NULL default '0', 1828 textalign varchar(10) default NULL, 1829 text_format varchar(255) default NULL, 1830 value varchar(255) default NULL, 1831 hard_return char(2) default NULL, 1832 gprint_id mediumint(8) unsigned NOT NULL default '0', 1833 sequence mediumint(8) unsigned NOT NULL default '0', 1834 PRIMARY KEY (id), 1835 KEY graph_template_id (graph_template_id), 1836 KEY local_graph_id_sequence (local_graph_id, sequence), 1837 KEY local_graph_template_item_id (local_graph_template_item_id), 1838 KEY task_item_id (task_item_id), 1839 KEY cdef_id (cdef_id), 1840 KEY vdef_id (vdef_id), 1841 KEY color_id (color_id), 1842 KEY gprint_id (gprint_id), 1843 KEY `lgi_gti` (`local_graph_id`,`graph_template_id`) 1844) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Stores the actual graph item data.'; 1845 1846-- 1847-- Dumping data for table `graph_templates_item` 1848-- 1849 1850-- 1851-- Table structure for table `graph_tree` 1852-- 1853 1854CREATE TABLE graph_tree ( 1855 `id` smallint(5) unsigned NOT NULL auto_increment, 1856 `enabled` char(2) DEFAULT 'on', 1857 `locked` tinyint(4) DEFAULT '0', 1858 `locked_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 1859 `sort_type` tinyint(3) unsigned NOT NULL default '1', 1860 `name` varchar(255) NOT NULL default '', 1861 `sequence` int(10) unsigned DEFAULT '1', 1862 `user_id` int(10) unsigned DEFAULT '1', 1863 `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 1864 `modified_by` int(10) unsigned DEFAULT '1', 1865 PRIMARY KEY (`id`), 1866 KEY `sequence` (`sequence`), 1867 KEY `name` (`name`(171)) 1868) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1869 1870-- 1871-- Dumping data for table `graph_tree` 1872-- 1873 1874INSERT INTO graph_tree VALUES (1,'on',0,'0000-00-00',1,'Default Tree',1,1,'0000-00-00','1'); 1875 1876-- 1877-- Table structure for table `graph_tree_items` 1878-- 1879 1880CREATE TABLE graph_tree_items ( 1881 id bigint(20) unsigned NOT NULL AUTO_INCREMENT, 1882 parent bigint(20) unsigned DEFAULT NULL, 1883 position int(10) unsigned DEFAULT NULL, 1884 graph_tree_id smallint(5) unsigned NOT NULL DEFAULT '0', 1885 local_graph_id int(10) unsigned NOT NULL DEFAULT '0', 1886 title varchar(255) DEFAULT NULL, 1887 host_id mediumint(8) unsigned NOT NULL DEFAULT '0', 1888 site_id int unsigned DEFAULT '0', 1889 host_grouping_type tinyint(3) unsigned NOT NULL DEFAULT '1', 1890 sort_children_type tinyint(3) unsigned NOT NULL DEFAULT '0', 1891 graph_regex varchar(60) DEFAULT '', 1892 host_regex varchar(60) DEFAULT '', 1893 PRIMARY KEY (`id`), 1894 KEY `graph_tree_id` (`graph_tree_id`), 1895 KEY `host_id` (`host_id`), 1896 KEY `site_id` (`site_id`), 1897 KEY `local_graph_id` (`local_graph_id`), 1898 KEY `parent_position`(`parent`, `position`) 1899) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1900 1901-- 1902-- Dumping data for table `graph_tree_items` 1903-- 1904 1905-- 1906-- Table structure for table `host` 1907-- 1908 1909CREATE TABLE host ( 1910 id mediumint(8) unsigned NOT NULL auto_increment, 1911 poller_id int(10) unsigned NOT NULL default '1', 1912 site_id int(10) unsigned NOT NULL default '1', 1913 host_template_id mediumint(8) unsigned NOT NULL default '0', 1914 description varchar(150) NOT NULL default '', 1915 hostname varchar(100) default NULL, 1916 location varchar(40) default NULL, 1917 notes text, 1918 external_id varchar(40) default NULL, 1919 snmp_community varchar(100) default NULL, 1920 snmp_version tinyint(1) unsigned NOT NULL default '1', 1921 snmp_username varchar(50) default NULL, 1922 snmp_password varchar(50) default NULL, 1923 snmp_auth_protocol char(6) default '', 1924 snmp_priv_passphrase varchar(200) default '', 1925 snmp_priv_protocol char(6) default '', 1926 snmp_context varchar(64) default '', 1927 snmp_engine_id varchar(64) default '', 1928 snmp_port mediumint(5) unsigned NOT NULL default '161', 1929 snmp_timeout mediumint(8) unsigned NOT NULL default '500', 1930 snmp_sysDescr varchar(300) NOT NULL default '', 1931 snmp_sysObjectID varchar(128) NOT NULL default '', 1932 snmp_sysUpTimeInstance bigint(20) unsigned NOT NULL default '0', 1933 snmp_sysContact varchar(300) NOT NULL default '', 1934 snmp_sysName varchar(300) NOT NULL default '', 1935 snmp_sysLocation varchar(300) NOT NULL default '', 1936 availability_method smallint(5) unsigned NOT NULL default '1', 1937 ping_method smallint(5) unsigned default '0', 1938 ping_port int(12) unsigned default '0', 1939 ping_timeout int(12) unsigned default '500', 1940 ping_retries int(12) unsigned default '2', 1941 max_oids int(12) unsigned default '10', 1942 bulk_walk_size int(11) DEFAULT '-1', 1943 device_threads tinyint(2) unsigned NOT NULL DEFAULT '1', 1944 deleted char(2) default '', 1945 disabled char(2) default NULL, 1946 status tinyint(2) NOT NULL default '0', 1947 status_event_count mediumint(8) unsigned NOT NULL default '0', 1948 status_fail_date timestamp NOT NULL default '0000-00-00 00:00:00', 1949 status_rec_date timestamp NOT NULL default '0000-00-00 00:00:00', 1950 status_last_error varchar(255) default '', 1951 min_time decimal(10,5) default '9.99999', 1952 max_time decimal(10,5) default '0.00000', 1953 cur_time decimal(10,5) default '0.00000', 1954 avg_time decimal(10,5) default '0.00000', 1955 polling_time DOUBLE default '0', 1956 total_polls int(12) unsigned default '0', 1957 failed_polls int(12) unsigned default '0', 1958 availability decimal(8,5) NOT NULL default '100.00000', 1959 last_updated timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 1960 PRIMARY KEY (id), 1961 KEY poller_id_disabled (poller_id, disabled), 1962 KEY site_id (site_id), 1963 KEY external_id (external_id), 1964 KEY disabled (disabled), 1965 KEY status (status), 1966 KEY site_id_location (site_id, location), 1967 KEY hostname (hostname), 1968 KEY poller_id_last_updated (poller_id, last_updated) 1969) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1970 1971-- 1972-- Dumping data for table `host` 1973-- 1974 1975-- 1976-- Table structure for table `host_graph` 1977-- 1978 1979CREATE TABLE host_graph ( 1980 host_id mediumint(8) unsigned NOT NULL default '0', 1981 graph_template_id mediumint(8) unsigned NOT NULL default '0', 1982 PRIMARY KEY (host_id,graph_template_id) 1983) ENGINE=InnoDB ROW_FORMAT=Dynamic; 1984 1985-- 1986-- Dumping data for table `host_graph` 1987-- 1988 1989-- 1990-- Table structure for table `host_snmp_cache` 1991-- 1992 1993CREATE TABLE host_snmp_cache ( 1994 host_id mediumint(8) unsigned NOT NULL default '0', 1995 snmp_query_id mediumint(8) unsigned NOT NULL default '0', 1996 field_name varchar(50) NOT NULL default '', 1997 field_value varchar(512) default NULL, 1998 snmp_index varchar(255) NOT NULL default '', 1999 oid TEXT NOT NULL, 2000 present tinyint NOT NULL DEFAULT '1', 2001 last_updated timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 2002 PRIMARY KEY (host_id, snmp_query_id, field_name, snmp_index), 2003 KEY host_id (host_id, field_name), 2004 KEY snmp_index (snmp_index), 2005 KEY field_name (field_name), 2006 KEY field_value (field_value), 2007 KEY snmp_query_id (snmp_query_id), 2008 KEY last_updated (last_updated), 2009 KEY present (present) 2010) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2011 2012-- 2013-- Dumping data for table `host_snmp_cache` 2014-- 2015 2016-- 2017-- Table structure for table `host_snmp_query` 2018-- 2019 2020CREATE TABLE host_snmp_query ( 2021 host_id mediumint(8) unsigned NOT NULL default '0', 2022 snmp_query_id mediumint(8) unsigned NOT NULL default '0', 2023 sort_field varchar(50) NOT NULL default '', 2024 title_format varchar(50) NOT NULL default '', 2025 reindex_method tinyint(3) unsigned NOT NULL default '0', 2026 PRIMARY KEY (host_id,snmp_query_id), 2027 KEY host_id (host_id) 2028) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2029 2030-- 2031-- Dumping data for table `host_snmp_query` 2032-- 2033 2034-- 2035-- Table structure for table `host_template` 2036-- 2037 2038CREATE TABLE host_template ( 2039 id mediumint(8) unsigned NOT NULL auto_increment, 2040 hash varchar(32) NOT NULL default '', 2041 name varchar(100) NOT NULL default '', 2042 PRIMARY KEY (id), 2043 KEY `name` (`name`) 2044) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2045 2046-- 2047-- Dumping data for table `host_template` 2048-- 2049 2050-- 2051-- Table structure for table `host_template_graph` 2052-- 2053 2054CREATE TABLE host_template_graph ( 2055 host_template_id mediumint(8) unsigned NOT NULL default '0', 2056 graph_template_id mediumint(8) unsigned NOT NULL default '0', 2057 PRIMARY KEY (host_template_id,graph_template_id), 2058 KEY host_template_id (host_template_id) 2059) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2060 2061-- 2062-- Dumping data for table `host_template_graph` 2063-- 2064 2065-- 2066-- Table structure for table `host_template_snmp_query` 2067-- 2068 2069CREATE TABLE host_template_snmp_query ( 2070 host_template_id mediumint(8) unsigned NOT NULL default '0', 2071 snmp_query_id mediumint(8) unsigned NOT NULL default '0', 2072 PRIMARY KEY (host_template_id, snmp_query_id), 2073 KEY host_template_id (host_template_id) 2074) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2075 2076-- 2077-- Dumping data for table `host_template_snmp_query` 2078-- 2079 2080-- 2081-- Table structure for table `plugin_config` 2082-- 2083 2084CREATE TABLE `plugin_config` ( 2085 `id` mediumint(8) unsigned NOT NULL auto_increment, 2086 `directory` varchar(32) NOT NULL default '', 2087 `name` varchar(64) NOT NULL default '', 2088 `status` tinyint(2) NOT NULL default '0', 2089 `author` varchar(64) NOT NULL default '', 2090 `webpage` varchar(255) NOT NULL default '', 2091 `version` varchar(10) NOT NULL default '', 2092 PRIMARY KEY (`id`), 2093 KEY `status` (`status`), 2094 KEY `directory` (`directory`) 2095) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2096 2097-- 2098-- Table structure for table `plugin_hooks` 2099-- 2100 2101CREATE TABLE `plugin_hooks` ( 2102 `id` mediumint(8) unsigned NOT NULL auto_increment, 2103 `name` varchar(32) NOT NULL default '', 2104 `hook` varchar(64) NOT NULL default '', 2105 `file` varchar(255) NOT NULL default '', 2106 `function` varchar(128) NOT NULL default '', 2107 `status` int(8) NOT NULL default '0', 2108 PRIMARY KEY (`id`), 2109 KEY `hook` (`hook`), 2110 KEY `status` (`status`) 2111) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2112 2113-- 2114-- Table structure for table `plugin_realms` 2115-- 2116 2117CREATE TABLE `plugin_realms` ( 2118 `id` mediumint(8) unsigned NOT NULL auto_increment, 2119 `plugin` varchar(32) NOT NULL default '', 2120 `file` text NOT NULL, 2121 `display` varchar(64) NOT NULL default '', 2122 PRIMARY KEY (`id`), 2123 KEY `plugin` (`plugin`) 2124) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2125 2126-- 2127-- Table structure for table `plugin_db_changes` 2128-- 2129 2130CREATE TABLE `plugin_db_changes` ( 2131 `id` mediumint(8) unsigned NOT NULL auto_increment, 2132 `plugin` varchar(16) NOT NULL default '', 2133 `table` varchar(64) NOT NULL default '', 2134 `column` varchar(64) NOT NULL, 2135 `method` varchar(16) NOT NULL default '', 2136 PRIMARY KEY (`id`), 2137 KEY `plugin` (`plugin`), 2138 KEY `method` (`method`) 2139) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2140 2141REPLACE INTO `plugin_realms` VALUES (1, 'internal', 'plugins.php', 'Plugin Management'); 2142INSERT INTO `plugin_hooks` VALUES (1, 'internal', 'config_arrays', '', 'plugin_config_arrays', 1); 2143INSERT INTO `plugin_hooks` VALUES (2, 'internal', 'draw_navigation_text', '', 'plugin_draw_navigation_text', 1); 2144 2145-- 2146-- Table structure for table `poller` 2147-- 2148 2149CREATE TABLE `poller` ( 2150 `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, 2151 `disabled` char(2) DEFAULT '', 2152 `name` varchar(30) DEFAULT NULL, 2153 `notes` varchar(1024) DEFAULT '', 2154 `status` int(10) unsigned NOT NULL DEFAULT '0', 2155 `timezone` varchar(40) DEFAULT '', 2156 `hostname` varchar(100) NOT NULL DEFAULT '', 2157 `dbdefault` varchar(20) NOT NULL DEFAULT '', 2158 `dbhost` varchar(64) NOT NULL DEFAULT '', 2159 `dbuser` varchar(20) NOT NULL DEFAULT '', 2160 `dbpass` varchar(64) NOT NULL DEFAULT '', 2161 `dbport` int(10) unsigned DEFAULT '3306', 2162 `dbretries` int(10) unsigned DEFAULT '2', 2163 `dbssl` char(3) DEFAULT '', 2164 `dbsslkey` varchar(255) DEFAULT NULL, 2165 `dbsslcert` varchar(255) DEFAULT NULL, 2166 `dbsslca` varchar(255) DEFAULT NULL, 2167 `total_time` double DEFAULT '0', 2168 `max_time` double DEFAULT NULL, 2169 `min_time` double DEFAULT NULL, 2170 `avg_time` double DEFAULT NULL, 2171 `total_polls` int(10) unsigned DEFAULT '0', 2172 `processes` int(10) unsigned DEFAULT '1', 2173 `threads` int(10) unsigned DEFAULT '1', 2174 `sync_interval` int(10) unsigned DEFAULT '7200', 2175 `snmp` mediumint(8) unsigned DEFAULT '0', 2176 `script` mediumint(8) unsigned DEFAULT '0', 2177 `server` mediumint(8) unsigned DEFAULT '0', 2178 `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 2179 `last_status` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 2180 `last_sync` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 2181 `requires_sync` char(2) DEFAULT '', 2182 PRIMARY KEY (`id`), 2183 KEY `name` (`name`), 2184 KEY `disabled` (`disabled`) 2185) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Pollers for Cacti'; 2186 2187INSERT INTO poller (id,name,hostname) VALUES (1,'Main Poller', 'localhost'); 2188 2189-- 2190-- Table structure for table `poller_command` 2191-- 2192 2193CREATE TABLE poller_command ( 2194 poller_id smallint(5) unsigned NOT NULL default '1', 2195 time timestamp NOT NULL default '0000-00-00 00:00:00', 2196 action tinyint(3) unsigned NOT NULL default '0', 2197 command varchar(191) NOT NULL default '', 2198 last_updated timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 2199 PRIMARY KEY (poller_id, action, command), 2200 KEY poller_id_last_updated (poller_id, last_updated) 2201) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2202 2203-- 2204-- Table structure for table `poller_data_template_field_mappings` 2205-- 2206 2207CREATE TABLE `poller_data_template_field_mappings` ( 2208 `data_template_id` int(10) unsigned NOT NULL DEFAULT '0', 2209 `data_name` varchar(40) NOT NULL DEFAULT '', 2210 `data_source_names` varchar(125) NOT NULL DEFAULT '', 2211 `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 2212 PRIMARY KEY (`data_template_id`, `data_name`, `data_source_names`) 2213) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Tracks mapping of Data Templates to their Data Source Names'; 2214 2215-- 2216-- Table structure for table `poller_item` 2217-- 2218 2219CREATE TABLE poller_item ( 2220 `local_data_id` int(10) unsigned NOT NULL default '0', 2221 `poller_id` int(10) unsigned NOT NULL default '1', 2222 `host_id` mediumint(8) unsigned NOT NULL default '0', 2223 `action` tinyint(2) unsigned NOT NULL default '1', 2224 `present` tinyint NOT NULL DEFAULT '1', 2225 `last_updated` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 2226 `hostname` varchar(100) NOT NULL default '', 2227 `snmp_community` varchar(100) NOT NULL default '', 2228 `snmp_version` tinyint(1) unsigned NOT NULL default '0', 2229 `snmp_username` varchar(50) NOT NULL default '', 2230 `snmp_password` varchar(50) NOT NULL default '', 2231 `snmp_auth_protocol` char(6) NOT NULL default '', 2232 `snmp_priv_passphrase` varchar(200) NOT NULL default '', 2233 `snmp_priv_protocol` char(6) NOT NULL default '', 2234 `snmp_context` varchar(64) default '', 2235 `snmp_engine_id` varchar(64) default '', 2236 `snmp_port` mediumint(5) unsigned NOT NULL default '161', 2237 `snmp_timeout` mediumint(8) unsigned NOT NULL default '0', 2238 `rrd_name` varchar(19) NOT NULL default '', 2239 `rrd_path` varchar(255) NOT NULL default '', 2240 `rrd_num` tinyint(2) unsigned NOT NULL default '0', 2241 `rrd_step` mediumint(8) NOT NULL default '300', 2242 `rrd_next_step` mediumint(8) NOT NULL default '0', 2243 `arg1` TEXT default NULL, 2244 `arg2` varchar(255) default NULL, 2245 `arg3` varchar(255) default NULL, 2246 PRIMARY KEY (`local_data_id`,`rrd_name`), 2247 KEY `host_id` (`host_id`), 2248 KEY `action` (`action`), 2249 KEY `present` (`present`), 2250 KEY `poller_id_host_id` (`poller_id`,`host_id`), 2251 KEY `poller_id_rrd_next_step` (`poller_id`,`rrd_next_step`), 2252 KEY `poller_id_action` (`poller_id`,`action`), 2253 KEY `poller_id_last_updated` (`poller_id`, `last_updated`) 2254) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2255 2256-- 2257-- Table structure for table `poller_output` 2258-- 2259 2260CREATE TABLE poller_output ( 2261 local_data_id int(10) unsigned NOT NULL default '0', 2262 rrd_name varchar(19) NOT NULL default '', 2263 time timestamp NOT NULL default '0000-00-00 00:00:00', 2264 output varchar(512) NOT NULL default '', 2265 PRIMARY KEY (local_data_id, rrd_name, time) /*!50060 USING BTREE */ 2266) ENGINE=MEMORY; 2267 2268-- 2269-- Table structure for table `poller_output_boost` 2270-- 2271 2272CREATE TABLE `poller_output_boost` ( 2273 `local_data_id` int(10) unsigned NOT NULL default '0', 2274 `rrd_name` varchar(19) NOT NULL default '', 2275 `time` timestamp NOT NULL default '0000-00-00 00:00:00', 2276 `output` varchar(512) NOT NULL, 2277 PRIMARY KEY USING BTREE (`local_data_id`, `time`, `rrd_name`) 2278) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2279 2280-- 2281-- Table structure for table `poller_output_boost_local_data_ids` 2282-- 2283 2284CREATE TABLE `poller_output_boost_local_data_ids` ( 2285 `local_data_id` int(10) unsigned NOT NULL DEFAULT 0, 2286 `process_handler` int(10) unsigned DEFAULT 0, 2287 PRIMARY KEY (`local_data_id`), 2288 KEY `process_handler` (`process_handler`) 2289) ENGINE=MEMORY; 2290 2291-- 2292-- Table structure for table `poller_output_boost_processes` 2293-- 2294 2295CREATE TABLE `poller_output_boost_processes` ( 2296 `sock_int_value` bigint(20) unsigned NOT NULL auto_increment, 2297 `status` varchar(255) default NULL, 2298 PRIMARY KEY (`sock_int_value`) 2299) ENGINE=MEMORY; 2300 2301-- 2302-- Table structure for table `poller_output_realtime` 2303-- 2304 2305CREATE TABLE poller_output_realtime ( 2306 local_data_id int(10) unsigned NOT NULL default '0', 2307 rrd_name varchar(19) NOT NULL default '', 2308 `time` timestamp NOT NULL default '0000-00-00 00:00:00', 2309 output text NOT NULL, 2310 poller_id varchar(256) NOT NULL default '1', 2311 PRIMARY KEY (local_data_id, rrd_name, time, poller_id), 2312 KEY poller_id (poller_id(191)), 2313 KEY `time` (`time`) 2314) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2315 2316-- 2317-- Table structure for table `poller_reindex` 2318-- 2319 2320CREATE TABLE poller_reindex ( 2321 host_id mediumint(8) unsigned NOT NULL default '0', 2322 data_query_id mediumint(8) unsigned NOT NULL default '0', 2323 action tinyint(3) unsigned NOT NULL default '0', 2324 present tinyint NOT NULL DEFAULT '1', 2325 op char(1) NOT NULL default '', 2326 assert_value varchar(100) NOT NULL default '', 2327 arg1 varchar(255) NOT NULL default '', 2328 PRIMARY KEY (host_id, data_query_id, arg1(187)), 2329 KEY present (present) 2330) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2331 2332-- 2333-- Table structure for table `poller_resource_cache` 2334-- 2335 2336CREATE TABLE poller_resource_cache ( 2337 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2338 `resource_type` varchar(20) DEFAULT NULL, 2339 `md5sum` varchar(32) DEFAULT NULL, 2340 `path` varchar(191) DEFAULT NULL, 2341 `update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 2342 `contents` longblob, 2343 `attributes` INT unsigned DEFAULT '0', 2344 PRIMARY KEY (`id`), 2345 UNIQUE KEY `path` (`path`) 2346) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Caches all scripts, resources files, and plugins'; 2347 2348-- 2349-- Table structure for table `poller_time` 2350-- 2351 2352CREATE TABLE poller_time ( 2353 id bigint(20) unsigned NOT NULL auto_increment, 2354 pid int(11) unsigned NOT NULL default '0', 2355 poller_id int(10) unsigned NOT NULL default '1', 2356 start_time timestamp NOT NULL default '0000-00-00 00:00:00', 2357 end_time timestamp NOT NULL default '0000-00-00 00:00:00', 2358 PRIMARY KEY (id), 2359 KEY `poller_id_end_time` (`poller_id`, `end_time`) 2360) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2361 2362-- 2363-- Table structure for table `processes` 2364-- 2365 2366CREATE TABLE `processes` ( 2367 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 2368 `pid` int(10) unsigned NOT NULL DEFAULT 0, 2369 `tasktype` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', 2370 `taskname` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', 2371 `taskid` int(10) unsigned NOT NULL DEFAULT 0, 2372 `timeout` int(11) DEFAULT 300, 2373 `started` timestamp NOT NULL DEFAULT current_timestamp(), 2374 `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 2375 PRIMARY KEY (`pid`,`tasktype`,`taskname`,`taskid`), 2376 KEY `tasktype` (`tasktype`), 2377 KEY `pid` (`pid`), 2378 KEY `id` (`id`) 2379) ENGINE=MEMORY COMMENT='Stores Process Status for Cacti Background Processes'; 2380 2381-- 2382-- Table structure for table `reports` 2383-- 2384 2385CREATE TABLE `reports` ( 2386 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 2387 `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 2388 `name` varchar(100) NOT NULL DEFAULT '', 2389 `cformat` char(2) NOT NULL DEFAULT '', 2390 `format_file` varchar(255) NOT NULL DEFAULT '', 2391 `font_size` smallint(2) unsigned NOT NULL DEFAULT '0', 2392 `alignment` smallint(2) unsigned NOT NULL DEFAULT '0', 2393 `graph_linked` char(2) NOT NULL DEFAULT '', 2394 `intrvl` smallint(2) unsigned NOT NULL DEFAULT '0', 2395 `count` smallint(2) unsigned NOT NULL DEFAULT '0', 2396 `offset` int(12) unsigned NOT NULL DEFAULT '0', 2397 `mailtime` bigint(20) unsigned NOT NULL DEFAULT '0', 2398 `subject` varchar(64) NOT NULL DEFAULT '', 2399 `from_name` varchar(40) NOT NULL, 2400 `from_email` text NOT NULL, 2401 `email` text NOT NULL, 2402 `bcc` text NOT NULL, 2403 `attachment_type` smallint(2) unsigned NOT NULL DEFAULT '1', 2404 `graph_height` smallint(2) unsigned NOT NULL DEFAULT '0', 2405 `graph_width` smallint(2) unsigned NOT NULL DEFAULT '0', 2406 `graph_columns` smallint(2) unsigned NOT NULL DEFAULT '0', 2407 `thumbnails` char(2) NOT NULL DEFAULT '', 2408 `lastsent` bigint(20) unsigned NOT NULL DEFAULT '0', 2409 `enabled` char(2) DEFAULT '', 2410 PRIMARY KEY (`id`), 2411 KEY `mailtime` (`mailtime`)) 2412 ENGINE=InnoDB 2413 ROW_FORMAT=Dynamic 2414 COMMENT='Cacri Reporting Reports'; 2415 2416-- 2417-- Table structure for table `reports_items` 2418-- 2419 2420CREATE TABLE `reports_items` ( 2421 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2422 `report_id` int(10) unsigned NOT NULL DEFAULT '0', 2423 `item_type` tinyint(1) unsigned NOT NULL DEFAULT '1', 2424 `tree_id` int(10) unsigned NOT NULL DEFAULT '0', 2425 `branch_id` int(10) unsigned NOT NULL DEFAULT '0', 2426 `tree_cascade` char(2) NOT NULL DEFAULT '', 2427 `graph_name_regexp` varchar(128) NOT NULL DEFAULT '', 2428 `host_template_id` int(10) unsigned NOT NULL DEFAULT '0', 2429 `host_id` int(10) unsigned NOT NULL DEFAULT '0', 2430 `graph_template_id` int(10) unsigned NOT NULL DEFAULT '0', 2431 `local_graph_id` int(10) unsigned NOT NULL DEFAULT '0', 2432 `timespan` int(10) unsigned NOT NULL DEFAULT '0', 2433 `align` tinyint(1) unsigned NOT NULL DEFAULT '1', 2434 `item_text` text NOT NULL, 2435 `font_size` smallint(2) unsigned NOT NULL DEFAULT '10', 2436 `sequence` smallint(5) unsigned NOT NULL DEFAULT '0', 2437 PRIMARY KEY (`id`), 2438 KEY `report_id` (`report_id`)) 2439 ENGINE=InnoDB 2440 ROW_FORMAT=Dynamic 2441 COMMENT='Cacti Reporting Items'; 2442 2443-- 2444-- Table structure for table `settings` 2445-- 2446 2447CREATE TABLE settings ( 2448 name varchar(50) NOT NULL default '', 2449 value varchar(2048) NOT NULL default '', 2450 PRIMARY KEY (name) 2451) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2452 2453-- 2454-- Dumping data for table `settings` 2455-- 2456 2457INSERT INTO settings VALUES ('auth_method', 1); 2458INSERT INTO settings VALUES ('selected_theme', 'modern'); 2459 2460-- 2461-- Table structure for table `settings_user` 2462-- 2463 2464CREATE TABLE settings_user ( 2465 user_id smallint(8) unsigned NOT NULL default '0', 2466 name varchar(50) NOT NULL default '', 2467 value varchar(2048) NOT NULL default '', 2468 PRIMARY KEY (user_id, name) 2469) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2470 2471-- 2472-- Dumping data for table `settings_user` 2473-- 2474 2475 2476-- 2477-- Table structure for table `settings_user_group` 2478-- 2479 2480CREATE TABLE settings_user_group ( 2481 group_id smallint(8) unsigned NOT NULL DEFAULT '0', 2482 name varchar(50) NOT NULL DEFAULT '', 2483 value varchar(2048) NOT NULL DEFAULT '', 2484 PRIMARY KEY (group_id, name) 2485) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Stores the Default User Group Graph Settings'; 2486 2487-- 2488-- Table structure for table `settings_tree` 2489-- 2490 2491CREATE TABLE settings_tree ( 2492 user_id mediumint(8) unsigned NOT NULL default '0', 2493 graph_tree_item_id int(10) unsigned NOT NULL default '0', 2494 status tinyint(1) NOT NULL default '0', 2495 PRIMARY KEY (user_id, graph_tree_item_id) 2496) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2497 2498-- 2499-- Dumping data for table `settings_tree` 2500-- 2501 2502 2503-- 2504-- Table structure for table `snmp_query` 2505-- 2506 2507CREATE TABLE snmp_query ( 2508 id mediumint(8) unsigned NOT NULL auto_increment, 2509 hash varchar(32) NOT NULL default '', 2510 xml_path varchar(255) NOT NULL default '', 2511 name varchar(100) NOT NULL default '', 2512 description varchar(255) default NULL, 2513 graph_template_id mediumint(8) unsigned NOT NULL default '0', 2514 data_input_id mediumint(8) unsigned NOT NULL default '0', 2515 PRIMARY KEY (id), 2516 KEY name (name) 2517) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2518 2519-- 2520-- Dumping data for table `snmp_query` 2521-- 2522 2523-- 2524-- Table structure for table `snmp_query_graph` 2525-- 2526 2527CREATE TABLE snmp_query_graph ( 2528 id mediumint(8) unsigned NOT NULL auto_increment, 2529 hash varchar(32) NOT NULL default '', 2530 snmp_query_id mediumint(8) unsigned NOT NULL default '0', 2531 name varchar(100) NOT NULL default '', 2532 graph_template_id mediumint(8) unsigned NOT NULL default '0', 2533 PRIMARY KEY (id), 2534 KEY `graph_template_id_name` (`graph_template_id`, `name`), 2535 KEY `snmp_query_id_name` (`snmp_query_id`, `name`) 2536) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2537 2538-- 2539-- Dumping data for table `snmp_query_graph` 2540-- 2541 2542-- 2543-- Table structure for table `snmp_query_graph_rrd` 2544-- 2545 2546CREATE TABLE snmp_query_graph_rrd ( 2547 snmp_query_graph_id mediumint(8) unsigned NOT NULL default '0', 2548 data_template_id mediumint(8) unsigned NOT NULL default '0', 2549 data_template_rrd_id int(10) unsigned NOT NULL default '0', 2550 snmp_field_name varchar(50) NOT NULL default '0', 2551 PRIMARY KEY (snmp_query_graph_id,data_template_id,data_template_rrd_id), 2552 KEY data_template_rrd_id (data_template_rrd_id), 2553 KEY snmp_query_graph_id (snmp_query_graph_id) 2554) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2555 2556-- 2557-- Dumping data for table `snmp_query_graph_rrd` 2558-- 2559 2560-- 2561-- Table structure for table `snmp_query_graph_rrd_sv` 2562-- 2563 2564CREATE TABLE snmp_query_graph_rrd_sv ( 2565 id mediumint(8) unsigned NOT NULL auto_increment, 2566 hash varchar(32) NOT NULL default '', 2567 snmp_query_graph_id mediumint(8) unsigned NOT NULL default '0', 2568 data_template_id mediumint(8) unsigned NOT NULL default '0', 2569 sequence mediumint(8) unsigned NOT NULL default '0', 2570 field_name varchar(100) NOT NULL default '', 2571 text varchar(255) NOT NULL default '', 2572 PRIMARY KEY (id), 2573 KEY snmp_query_graph_id (snmp_query_graph_id), 2574 KEY data_template_id (data_template_id) 2575) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2576 2577-- 2578-- Dumping data for table `snmp_query_graph_rrd_sv` 2579-- 2580 2581-- 2582-- Table structure for table `snmp_query_graph_sv` 2583-- 2584 2585CREATE TABLE snmp_query_graph_sv ( 2586 id mediumint(8) unsigned NOT NULL auto_increment, 2587 hash varchar(32) NOT NULL default '', 2588 snmp_query_graph_id mediumint(8) unsigned NOT NULL default '0', 2589 sequence mediumint(8) unsigned NOT NULL default '0', 2590 field_name varchar(100) NOT NULL default '', 2591 text varchar(255) NOT NULL default '', 2592 PRIMARY KEY (id), 2593 KEY snmp_query_graph_id (snmp_query_graph_id) 2594) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2595 2596-- 2597-- Dumping data for table `snmp_query_graph_sv` 2598-- 2599 2600-- 2601-- Table structure for table `user_auth` 2602-- 2603 2604CREATE TABLE user_auth ( 2605 `id` mediumint(8) unsigned NOT NULL auto_increment, 2606 `username` varchar(50) NOT NULL default '0', 2607 `password` varchar(256) NOT NULL default '', 2608 `realm` mediumint(8) NOT NULL default '0', 2609 `full_name` varchar(100) default '0', 2610 `email_address` varchar(128) NULL, 2611 `must_change_password` char(2) default NULL, 2612 `password_change` char(2) default 'on', 2613 `show_tree` char(2) default 'on', 2614 `show_list` char(2) default 'on', 2615 `show_preview` char(2) NOT NULL default 'on', 2616 `graph_settings` char(2) default NULL, 2617 `login_opts` tinyint(1) NOT NULL default '1', 2618 `policy_graphs` tinyint(1) unsigned NOT NULL default '1', 2619 `policy_trees` tinyint(1) unsigned NOT NULL default '1', 2620 `policy_hosts` tinyint(1) unsigned NOT NULL default '1', 2621 `policy_graph_templates` tinyint(1) unsigned NOT NULL default '1', 2622 `enabled` char(2) NOT NULL DEFAULT 'on', 2623 `lastchange` int(12) NOT NULL DEFAULT '-1', 2624 `lastlogin` int(12) NOT NULL DEFAULT '-1', 2625 `password_history` varchar(4096) NOT NULL DEFAULT '-1', 2626 `locked` varchar(3) NOT NULL DEFAULT '', 2627 `failed_attempts` int(5) NOT NULL DEFAULT '0', 2628 `lastfail` int(12) NOT NULL DEFAULT '0', 2629 `reset_perms` int(12) UNSIGNED NOT NULL DEFAULT '0', 2630 PRIMARY KEY (`id`), 2631 KEY `username` (`username`), 2632 KEY `realm` (`realm`), 2633 KEY `enabled` (`enabled`) 2634) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2635 2636-- 2637-- Dumping data for table `user_auth` 2638-- 2639 2640INSERT INTO user_auth VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3',0,'Administrator','','on','on','on','on','on','on',2,1,1,1,1,'on',-1,-1,'-1','',0,0,0); 2641INSERT INTO user_auth VALUES (3,'guest','43e9a4ab75570f5b',0,'Guest Account','','on','on','on','on','on',3,1,1,1,1,1,'',-1,-1,'-1','',0,0,0); 2642 2643-- 2644-- Table structure for table `user_auth_cache` 2645-- 2646 2647CREATE TABLE `user_auth_cache` ( 2648 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2649 `user_id` int(10) unsigned NOT NULL DEFAULT '0', 2650 `hostname` varchar(100) NOT NULL DEFAULT '', 2651 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 2652 `token` varchar(191) NOT NULL DEFAULT '', 2653 PRIMARY KEY (`id`), 2654 UNIQUE KEY `tokenkey` (`token`), 2655 KEY `hostname` (`hostname`), 2656 KEY `user_id` (`user_id`), 2657 KEY `last_update` (`last_update`) 2658) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Caches Remember Me Details'; 2659 2660-- 2661-- Dumping data for table `user_auth` 2662-- 2663 2664-- 2665-- Table structure for table `user_auth_group` 2666-- 2667 2668CREATE TABLE `user_auth_group` ( 2669 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2670 `name` varchar(20) NOT NULL, 2671 `description` varchar(255) NOT NULL DEFAULT '', 2672 `graph_settings` varchar(2) DEFAULT NULL, 2673 `login_opts` tinyint(1) NOT NULL DEFAULT '1', 2674 `show_tree` varchar(2) DEFAULT 'on', 2675 `show_list` varchar(2) DEFAULT 'on', 2676 `show_preview` varchar(2) NOT NULL DEFAULT 'on', 2677 `policy_graphs` tinyint(1) unsigned NOT NULL DEFAULT '1', 2678 `policy_trees` tinyint(1) unsigned NOT NULL DEFAULT '1', 2679 `policy_hosts` tinyint(1) unsigned NOT NULL DEFAULT '1', 2680 `policy_graph_templates` tinyint(1) unsigned NOT NULL DEFAULT '1', 2681 `enabled` char(2) NOT NULL DEFAULT 'on', 2682 PRIMARY KEY (`id`) 2683) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Table that Contains User Groups'; 2684 2685-- 2686-- Dumping data for table `user_auth_group` 2687-- 2688 2689-- 2690-- Table structure for table `user_auth_group_members` 2691-- 2692 2693CREATE TABLE `user_auth_group_members` ( 2694 `group_id` int(10) unsigned NOT NULL, 2695 `user_id` int(10) unsigned NOT NULL, 2696 PRIMARY KEY (`group_id`,`user_id`), 2697 KEY `realm_id` (`user_id`) 2698) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Table that Contains User Group Members'; 2699 2700-- 2701-- Dumping data for table `user_auth_group_members` 2702-- 2703 2704-- 2705-- Table structure for table `user_auth_group_perms` 2706-- 2707 2708CREATE TABLE `user_auth_group_perms` ( 2709 `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 2710 `item_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 2711 `type` tinyint(2) unsigned NOT NULL DEFAULT '0', 2712 PRIMARY KEY (`group_id`,`item_id`,`type`), 2713 KEY `group_id` (`group_id`,`type`) 2714) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Table that Contains User Group Permissions'; 2715 2716-- 2717-- Dumping data for table `user_auth_group_perms` 2718-- 2719 2720-- 2721-- Table structure for table `user_auth_group_realm` 2722-- 2723 2724CREATE TABLE `user_auth_group_realm` ( 2725 `group_id` int(10) unsigned NOT NULL, 2726 `realm_id` int(10) unsigned NOT NULL, 2727 PRIMARY KEY (`group_id`,`realm_id`), 2728 KEY `realm_id` (`realm_id`) 2729) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Table that Contains User Group Realm Permissions'; 2730 2731-- 2732-- Dumping data for table `user_auth_group_realm` 2733-- 2734 2735-- 2736-- Table structure for table `user_auth_perms` 2737-- 2738 2739CREATE TABLE user_auth_perms ( 2740 user_id mediumint(8) unsigned NOT NULL default '0', 2741 item_id mediumint(8) unsigned NOT NULL default '0', 2742 type tinyint(2) unsigned NOT NULL default '0', 2743 PRIMARY KEY (user_id,item_id,type), 2744 KEY user_id (user_id,type) 2745) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2746 2747-- 2748-- Dumping data for table `user_auth_perms` 2749-- 2750 2751 2752-- 2753-- Table structure for table `user_auth_realm` 2754-- 2755 2756CREATE TABLE user_auth_realm ( 2757 realm_id mediumint(8) unsigned NOT NULL default '0', 2758 user_id mediumint(8) unsigned NOT NULL default '0', 2759 PRIMARY KEY (realm_id,user_id), 2760 KEY user_id (user_id) 2761) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2762 2763-- 2764-- Dumping data for table `user_auth_realm` 2765-- 2766 2767INSERT INTO user_auth_realm VALUES (1,1); 2768INSERT INTO user_auth_realm VALUES (2,1); 2769INSERT INTO user_auth_realm VALUES (3,1); 2770INSERT INTO user_auth_realm VALUES (4,1); 2771INSERT INTO user_auth_realm VALUES (5,1); 2772INSERT INTO user_auth_realm VALUES (7,1); 2773INSERT INTO user_auth_realm VALUES (7,3); 2774INSERT INTO user_auth_realm VALUES (8,1); 2775INSERT INTO user_auth_realm VALUES (9,1); 2776INSERT INTO user_auth_realm VALUES (10,1); 2777INSERT INTO user_auth_realm VALUES (11,1); 2778INSERT INTO user_auth_realm VALUES (12,1); 2779INSERT INTO user_auth_realm VALUES (13,1); 2780INSERT INTO user_auth_realm VALUES (14,1); 2781INSERT INTO user_auth_realm VALUES (15,1); 2782INSERT INTO user_auth_realm VALUES (16,1); 2783INSERT INTO user_auth_realm VALUES (17,1); 2784INSERT INTO user_auth_realm VALUES (18,1); 2785INSERT INTO user_auth_realm VALUES (19,1); 2786INSERT INTO user_auth_realm VALUES (20,1); 2787INSERT INTO user_auth_realm VALUES (21,1); 2788INSERT INTO user_auth_realm VALUES (22,1); 2789INSERT INTO user_auth_realm VALUES (23,1); 2790INSERT INTO user_auth_realm VALUES (24,1); 2791INSERT INTO user_auth_realm VALUES (25,1); 2792INSERT INTO user_auth_realm VALUES (26,1); 2793INSERT INTO user_auth_realm VALUES (101,1); 2794INSERT INTO user_auth_realm VALUES (1043,1); 2795 2796-- 2797-- Table structure for table `user_log` 2798-- 2799 2800CREATE TABLE user_log ( 2801 `username` varchar(50) NOT NULL default '0', 2802 `user_id` mediumint(8) NOT NULL default '0', 2803 `time` timestamp NOT NULL default '0000-00-00 00:00:00', 2804 `result` tinyint(1) NOT NULL default '0', 2805 `ip` varchar(40) NOT NULL default '', 2806 PRIMARY KEY (`username`,`user_id`,`time`), 2807 KEY user_id (`user_id`) 2808) ENGINE=InnoDB ROW_FORMAT=Dynamic; 2809 2810-- 2811-- Dumping data for table `user_log` 2812-- 2813 2814-- 2815-- Table structure for table `user_domains` 2816-- 2817 2818CREATE TABLE `user_domains` ( 2819 `domain_id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2820 `domain_name` varchar(20) NOT NULL, 2821 `type` int(10) unsigned NOT NULL DEFAULT '0', 2822 `enabled` char(2) NOT NULL DEFAULT 'on', 2823 `defdomain` tinyint(3) NOT NULL DEFAULT '0', 2824 `user_id` int(10) unsigned NOT NULL DEFAULT '0', 2825 PRIMARY KEY (`domain_id`) 2826) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Table to Hold Login Domains'; 2827 2828-- 2829-- Dumping data for table `user_domains` 2830-- 2831 2832-- 2833-- Table structure for table `user_domains_ldap` 2834-- 2835 2836CREATE TABLE `user_domains_ldap` ( 2837 `domain_id` int(10) unsigned NOT NULL, 2838 `server` varchar(128) NOT NULL, 2839 `port` int(10) unsigned NOT NULL, 2840 `port_ssl` int(10) unsigned NOT NULL, 2841 `proto_version` tinyint(3) unsigned NOT NULL, 2842 `encryption` tinyint(3) unsigned NOT NULL, 2843 `referrals` tinyint(3) unsigned NOT NULL, 2844 `mode` tinyint(3) unsigned NOT NULL, 2845 `dn` varchar(128) NOT NULL, 2846 `group_require` char(2) NOT NULL, 2847 `group_dn` varchar(128) NOT NULL, 2848 `group_attrib` varchar(128) NOT NULL, 2849 `group_member_type` tinyint(3) unsigned NOT NULL, 2850 `search_base` varchar(128) NOT NULL, 2851 `search_filter` varchar(512) NOT NULL, 2852 `specific_dn` varchar(128) NOT NULL, 2853 `specific_password` varchar(128) NOT NULL, 2854 `cn_full_name` varchar(50) NULL DEFAULT '', 2855 `cn_email` varchar (50) NULL DEFAULT '', 2856 PRIMARY KEY (`domain_id`) 2857) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Table to Hold Login Domains for LDAP'; 2858 2859-- 2860-- Dumping data for table `user_domains_ldap` 2861-- 2862 2863-- 2864-- Table structure for table `sessions` 2865-- 2866 2867CREATE TABLE `sessions` ( 2868 `id` varchar(32) NOT NULL, 2869 `remote_addr` varchar(25) NOT NULL DEFAULT '', 2870 `access` int(10) unsigned DEFAULT NULL, 2871 `data` mediumblob, 2872 `user_id` int(10) unsigned NOT NULL DEFAULT '0', 2873 `user_agent` varchar(128) NOT NULL DEFAULT '', 2874 `start_time` timestamp NOT NULL DEFAULT current_timestamp, 2875 `transactions` int(10) unsigned NOT NULL DEFAULT '1', 2876 PRIMARY KEY (`id`) 2877) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Used for Database based Session Storage'; 2878 2879-- 2880-- Dumping data for table `sessions` 2881-- 2882 2883-- 2884-- Table structure for table `sites` 2885-- 2886 2887CREATE TABLE `sites` ( 2888 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2889 `name` varchar(100) NOT NULL DEFAULT '', 2890 `address1` varchar(100) DEFAULT '', 2891 `address2` varchar(100) DEFAULT '', 2892 `city` varchar(50) DEFAULT '', 2893 `state` varchar(20) DEFAULT NULL, 2894 `postal_code` varchar(20) DEFAULT '', 2895 `country` varchar(30) DEFAULT '', 2896 `timezone` varchar(40) DEFAULT '', 2897 `latitude` decimal(13,10) NOT NULL DEFAULT '0.0000000000', 2898 `longitude` decimal(13,10) NOT NULL DEFAULT '0.0000000000', 2899 `zoom` tinyint unsigned default NULL, 2900 `alternate_id` varchar(30) DEFAULT '', 2901 `notes` varchar(1024), 2902 PRIMARY KEY (`id`), 2903 KEY `name` (`name`), 2904 KEY `city` (`city`), 2905 KEY `state` (`state`), 2906 KEY `postal_code` (`postal_code`), 2907 KEY `country` (`country`), 2908 KEY `alternate_id` (`alternate_id`) 2909) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Contains information about customer sites'; 2910 2911-- 2912-- Dumping data for table `sites` 2913-- 2914 2915INSERT INTO `sites` VALUES (1,'Edge','','','','','','','',0.0000000000,0.0000000000,'','',''); 2916INSERT INTO `sites` VALUES (2,'Core','','','','','','','',0.0000000000,0.0000000000,'','',''); 2917 2918-- 2919-- Table structure for table `snmpagent_cache` 2920-- 2921 2922CREATE TABLE `snmpagent_cache` ( 2923 `oid` varchar(50) NOT NULL, 2924 `name` varchar(50) NOT NULL, 2925 `mib` varchar(50) NOT NULL, 2926 `type` varchar(50) NOT NULL DEFAULT '', 2927 `otype` varchar(50) NOT NULL DEFAULT '', 2928 `kind` varchar(50) NOT NULL DEFAULT '', 2929 `max-access` varchar(50) NOT NULL DEFAULT 'not-accessible', 2930 `value` varchar(255) NOT NULL DEFAULT '', 2931 `description` varchar(5000) NOT NULL DEFAULT '', 2932 PRIMARY KEY (`oid`), 2933 KEY `name` (`name`), 2934 KEY `mib_name` (`mib`,`name`) 2935) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='SNMP MIB CACHE'; 2936 2937-- 2938-- Dumping data for table `snmpagent_cache` 2939-- 2940 2941-- 2942-- Table structure for table `snmpagent_mibs` 2943-- 2944CREATE TABLE `snmpagent_mibs` ( 2945 `id` int(8) NOT NULL AUTO_INCREMENT, 2946 `name` varchar(50) NOT NULL DEFAULT '', 2947 `file` varchar(255) NOT NULL DEFAULT '', 2948 PRIMARY KEY (`id`) 2949) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Registered MIB files'; 2950 2951-- 2952-- Dumping data for table `snmpagent_mibs` 2953-- 2954 2955-- 2956-- Table structure for table `snmpagent_cache_notifications` 2957-- 2958 2959CREATE TABLE `snmpagent_cache_notifications` ( 2960 `name` varchar(50) NOT NULL, 2961 `mib` varchar(50) NOT NULL, 2962 `attribute` varchar(50) NOT NULL, 2963 `sequence_id` smallint(6) NOT NULL, 2964 PRIMARY KEY (`name`,`mib`,`attribute`,`sequence_id`), 2965 KEY `name` (`name`) 2966) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Notifcations and related attributes'; 2967 2968-- 2969-- Dumping data for table `snmpagent_cache_notifications` 2970-- 2971 2972-- 2973-- Table structure for table `snmpagent_cache_textual_conventions` 2974-- 2975 2976CREATE TABLE `snmpagent_cache_textual_conventions` ( 2977 `name` varchar(50) NOT NULL, 2978 `mib` varchar(50) NOT NULL, 2979 `type` varchar(50) NOT NULL DEFAULT '', 2980 `description` varchar(5000) NOT NULL DEFAULT '', 2981 PRIMARY KEY (`name`,`mib`,`type`), 2982 KEY `name` (`name`), 2983 KEY `mib` (`mib`) 2984) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='Textual conventions'; 2985 2986-- 2987-- Dumping data for table `snmpagent_cache_textual_conventions` 2988-- 2989 2990-- 2991-- Table structure for table `snmpagent_managers` 2992-- 2993 2994CREATE TABLE `snmpagent_managers` ( 2995 `id` int(8) NOT NULL AUTO_INCREMENT, 2996 `hostname` varchar(100) NOT NULL, 2997 `description` varchar(255) NOT NULL, 2998 `disabled` char(2) DEFAULT NULL, 2999 `max_log_size` tinyint(1) NOT NULL, 3000 `snmp_version` tinyint(1) unsigned NOT NULL DEFAULT '1', 3001 `snmp_community` varchar(100) NOT NULL DEFAULT '', 3002 `snmp_username` varchar(50) NOT NULL, 3003 `snmp_password` varchar(50) NOT NULL, 3004 `snmp_auth_protocol` char(6) NOT NULL, 3005 `snmp_priv_passphrase` varchar(200) NOT NULL, 3006 `snmp_priv_protocol` char(6) NOT NULL, 3007 `snmp_engine_id` varchar(64) DEFAULT NULL, 3008 `snmp_port` mediumint(5) unsigned NOT NULL DEFAULT '161', 3009 `snmp_message_type` tinyint(1) NOT NULL, 3010 `notes` text, 3011 PRIMARY KEY (`id`), 3012 KEY `hostname` (`hostname`) 3013) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='snmp notification receivers'; 3014 3015-- 3016-- Dumping data for table `snmpagent_managers` 3017-- 3018 3019-- 3020-- Table structure for table `snmpagent_managers_notifications` 3021-- 3022 3023CREATE TABLE `snmpagent_managers_notifications` ( 3024 `manager_id` int(8) NOT NULL, 3025 `notification` varchar(50) NOT NULL, 3026 `mib` varchar(50) NOT NULL, 3027 PRIMARY KEY(`manager_id`,`notification`,`mib`), 3028 KEY `mib` (`mib`), 3029 KEY `manager_id_notification` (`manager_id`,`notification`) 3030) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='snmp notifications to receivers'; 3031 3032-- 3033-- Dumping data for table `snmpagent_managers_notifications` 3034-- 3035 3036-- 3037-- Table structure for table `snmpagent_notifications_log` 3038-- 3039 3040CREATE TABLE `snmpagent_notifications_log` ( 3041 `id` int(12) NOT NULL AUTO_INCREMENT, 3042 `time` int(24) NOT NULL, 3043 `severity` tinyint(1) NOT NULL, 3044 `manager_id` int(8) NOT NULL, 3045 `notification` varchar(190) NOT NULL, 3046 `mib` varchar(50) NOT NULL, 3047 `varbinds` varchar(5000) NOT NULL, 3048 PRIMARY KEY (`id`), 3049 KEY `time` (`time`), 3050 KEY `severity` (`severity`), 3051 KEY `manager_id_notification` (`manager_id`,`notification`) 3052) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='logs snmp notifications to receivers'; 3053 3054-- 3055-- Dumping data for table `snmpagent_notifications_log` 3056-- 3057 3058-- 3059-- Table structure for table `vdef` 3060-- 3061 3062CREATE TABLE vdef ( 3063 id mediumint(8) unsigned NOT NULL auto_increment, 3064 hash varchar(32) NOT NULL default '', 3065 name varchar(255) NOT NULL default '', 3066 PRIMARY KEY (id), 3067 KEY `hash` (`hash`), 3068 KEY `name` (`name`(171)) 3069) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='vdef'; 3070 3071-- 3072-- Dumping data for table `vdef` 3073-- 3074 3075INSERT INTO vdef VALUES(1, 'e06ed529238448773038601afb3cf278', 'Maximum'); 3076INSERT INTO vdef VALUES(2, 'e4872dda82092393d6459c831a50dc3b', 'Minimum'); 3077INSERT INTO vdef VALUES(3, '5ce1061a46bb62f36840c80412d2e629', 'Average'); 3078INSERT INTO vdef VALUES(4, '06bd3cbe802da6a0745ea5ba93af554a', 'Last (Current)'); 3079INSERT INTO vdef VALUES(5, '631c1b9086f3979d6dcf5c7a6946f104', 'First'); 3080INSERT INTO vdef VALUES(6, '6b5335843630b66f858ce6b7c61fc493', 'Total: Current Data Source'); 3081INSERT INTO vdef VALUES(7, 'c80d12b0f030af3574da68b28826cd39', '95th Percentage: Current Data Source'); 3082 3083-- 3084-- Table structure for table `vdef_items` 3085-- 3086 3087CREATE TABLE vdef_items ( 3088 `id` mediumint(8) unsigned NOT NULL auto_increment, 3089 `hash` varchar(32) NOT NULL default '', 3090 `vdef_id` mediumint(8) unsigned NOT NULL default '0', 3091 `sequence` mediumint(8) unsigned NOT NULL default '0', 3092 `type` tinyint(2) NOT NULL default '0', 3093 `value` varchar(150) NOT NULL default '', 3094 PRIMARY KEY (id), 3095 KEY `vdef_id_sequence` (`vdef_id`,`sequence`) 3096) ENGINE=InnoDB ROW_FORMAT=Dynamic COMMENT='vdef items'; 3097 3098-- 3099-- Dumping data for table `vdef_items` 3100-- 3101 3102INSERT INTO vdef_items VALUES(1, '88d33bf9271ac2bdf490cf1784a342c1', 1, 1, 4, 'CURRENT_DATA_SOURCE'); 3103INSERT INTO vdef_items VALUES(2, 'a307afab0c9b1779580039e3f7c4f6e5', 1, 2, 1, '1'); 3104INSERT INTO vdef_items VALUES(3, '0945a96068bb57c80bfbd726cf1afa02', 2, 1, 4, 'CURRENT_DATA_SOURCE'); 3105INSERT INTO vdef_items VALUES(4, '95a8df2eac60a89e8a8ca3ea3d019c44', 2, 2, 1, '2'); 3106INSERT INTO vdef_items VALUES(5, 'cc2e1c47ec0b4f02eb13708cf6dac585', 3, 1, 4, 'CURRENT_DATA_SOURCE'); 3107INSERT INTO vdef_items VALUES(6, 'a2fd796335b87d9ba54af6a855689507', 3, 2, 1, '3'); 3108INSERT INTO vdef_items VALUES(7, 'a1d7974ee6018083a2053e0d0f7cb901', 4, 1, 4, 'CURRENT_DATA_SOURCE'); 3109INSERT INTO vdef_items VALUES(8, '26fccba1c215439616bc1b83637ae7f3', 4, 2, 1, '5'); 3110INSERT INTO vdef_items VALUES(9, 'a8993b265f4c5398f4a47c44b5b37a07', 5, 1, 4, 'CURRENT_DATA_SOURCE'); 3111INSERT INTO vdef_items VALUES(10, '5a380d469d611719057c3695ce1e4eee', 5, 2, 1, '6'); 3112INSERT INTO vdef_items VALUES(11, '65cfe546b17175fad41fcca98c057feb', 6, 1, 4, 'CURRENT_DATA_SOURCE'); 3113INSERT INTO vdef_items VALUES(12, 'f330b5633c3517d7c62762cef091cc9e', 6, 2, 1, '7'); 3114INSERT INTO vdef_items VALUES(13, 'f1bf2ecf54ca0565cf39c9c3f7e5394b', 7, 1, 4, 'CURRENT_DATA_SOURCE'); 3115INSERT INTO vdef_items VALUES(14, '11a26f18feba3919be3af426670cba95', 7, 2, 6, '95'); 3116INSERT INTO vdef_items VALUES(15, 'e7ae90275bc1efada07c19ca3472d9db', 7, 3, 1, '8'); 3117 3118-- 3119-- Table structure for table `version` 3120-- 3121 3122CREATE TABLE version ( 3123 cacti char(20) default '', 3124 PRIMARY KEY (cacti) 3125) ENGINE=InnoDB ROW_FORMAT=Dynamic; 3126 3127-- 3128-- Dumping data for table `version` 3129-- 3130 3131INSERT INTO version VALUES ('new_install'); 3132