/* +-------------------------------------------------------------------------+ | Copyright (C) 2004-2026 The Cacti Group | | | | This program is free software; you can redistribute it and/or | | modify it under the terms of the GNU General Public License | | as published by the Free Software Foundation; either version 2 | | of the License, or (at your option) any later version. | | | | This program is distributed in the hope that it will be useful, | | but WITHOUT ANY WARRANTY; without even the implied warranty of | | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | | GNU General Public License for more details. | +-------------------------------------------------------------------------+ | Cacti: The Complete RRDTool-based Graphing Solution | +-------------------------------------------------------------------------+ | This code is designed, written, and maintained by the Cacti Group. See | | about.php and/or the AUTHORS file for specific developer information. | +-------------------------------------------------------------------------+ | http://www.cacti.net/ | +-------------------------------------------------------------------------+ */ /*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.5.29-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: cacti -- ------------------------------------------------------ -- Server version 10.5.29-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `table_columns` -- DROP TABLE IF EXISTS `table_columns`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `table_columns` ( `table_name` varchar(50) NOT NULL, `table_sequence` int(10) unsigned NOT NULL, `table_field` varchar(50) NOT NULL, `table_type` varchar(50) DEFAULT NULL, `table_null` varchar(10) DEFAULT NULL, `table_key` varchar(4) DEFAULT NULL, `table_default` varchar(50) DEFAULT NULL, `table_extra` varchar(128) DEFAULT NULL, PRIMARY KEY (`table_name`,`table_sequence`,`table_field`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Holds Default Cacti Table Definitions'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `table_columns` -- LOCK TABLES `table_columns` WRITE; /*!40000 ALTER TABLE `table_columns` DISABLE KEYS */; INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',2,'name','varchar(64)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',3,'graph_template_id','int(10) unsigned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',4,'gprint_prefix','varchar(64)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',5,'gprint_format','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',6,'graph_type','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',7,'total','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',8,'total_type','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',9,'total_prefix','varchar(64)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',10,'order_type','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',11,'created','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',12,'user_id','int(10) unsigned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',13,'graphs','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',1,'aggregate_template_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',2,'t_image_format_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',3,'image_format_id','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',4,'t_height','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',5,'height','mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',6,'t_width','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',7,'width','mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',8,'t_upper_limit','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',9,'upper_limit','varchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',10,'t_lower_limit','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',11,'lower_limit','varchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',12,'t_vertical_label','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',13,'vertical_label','varchar(200)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',14,'t_slope_mode','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',15,'slope_mode','char(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',16,'t_auto_scale','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',17,'auto_scale','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',18,'t_auto_scale_opts','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',19,'auto_scale_opts','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',20,'t_auto_scale_log','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',21,'auto_scale_log','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',22,'t_scale_log_units','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',23,'scale_log_units','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',24,'t_auto_scale_rigid','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',25,'auto_scale_rigid','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',26,'t_auto_padding','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',27,'auto_padding','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',28,'t_base_value','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',29,'base_value','mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',30,'t_grouping','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',31,'grouping','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',32,'t_unit_value','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',33,'unit_value','varchar(20)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',34,'t_unit_exponent_value','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',35,'unit_exponent_value','varchar(5)','NO','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',36,'t_alt_y_grid','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',37,'alt_y_grid','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',38,'t_right_axis','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',39,'right_axis','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',40,'t_right_axis_label','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',41,'right_axis_label','varchar(200)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',42,'t_right_axis_format','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',43,'right_axis_format','mediumint(8)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',44,'t_right_axis_formatter','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',45,'right_axis_formatter','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',46,'t_left_axis_format','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',47,'left_axis_format','mediumint(8)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',48,'t_left_axis_formatter','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',49,'left_axis_formatter','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',50,'t_no_gridfit','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',51,'no_gridfit','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',52,'t_unit_length','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',53,'unit_length','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',54,'t_tab_width','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',55,'tab_width','varchar(20)','YES','','30',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',56,'t_dynamic_labels','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',57,'dynamic_labels','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',58,'t_force_rules_legend','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',59,'force_rules_legend','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',60,'t_legend_position','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',61,'legend_position','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',62,'t_legend_direction','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',63,'legend_direction','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',1,'aggregate_template_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',2,'graph_templates_item_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',3,'sequence','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',4,'color_template','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',5,'t_graph_type_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',6,'graph_type_id','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',7,'t_cdef_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',8,'cdef_id','mediumint(8) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',9,'item_skip','char(2)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',10,'item_total','char(2)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('aggregate_graphs',2,'aggregate_template_id','int(10) unsigned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',3,'template_propogation','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',4,'local_graph_id','int(10) unsigned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',5,'title_format','varchar(128)','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',6,'graph_template_id','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',7,'gprint_prefix','varchar(64)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',8,'gprint_format','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',9,'graph_type','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',10,'total','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',11,'total_type','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',12,'total_prefix','varchar(64)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',13,'order_type','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',14,'created','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',15,'user_id','int(10) unsigned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',1,'aggregate_graph_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',2,'graph_templates_item_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',3,'sequence','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',4,'color_template','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',5,'t_graph_type_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',6,'graph_type_id','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',7,'t_cdef_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',8,'cdef_id','mediumint(8) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',9,'item_skip','char(2)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',10,'item_total','char(2)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',1,'aggregate_graph_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',2,'local_graph_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',3,'sequence','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_devices',1,'id','bigint(20) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_devices',2,'network_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_devices',3,'host_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_devices',4,'hostname','varchar(100)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('automation_devices',5,'ip','varchar(17)','NO','UNI','',''); INSERT INTO `table_columns` VALUES ('automation_devices',6,'snmp_community','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',7,'snmp_version','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('automation_devices',8,'snmp_port','mediumint(8) unsigned','NO','','161',''); INSERT INTO `table_columns` VALUES ('automation_devices',9,'snmp_username','varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_devices',10,'snmp_password','varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_devices',11,'snmp_auth_protocol','char(6)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',12,'snmp_priv_passphrase','varchar(200)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',13,'snmp_priv_protocol','char(7)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',14,'snmp_context','varchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',15,'snmp_engine_id','varchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',16,'sysName','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',17,'sysLocation','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',18,'sysContact','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',19,'sysDescr','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',20,'sysUptime','bigint(20) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_devices',21,'os','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',22,'snmp','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_devices',23,'known','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_devices',24,'up','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_devices',25,'time','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',3,'rule_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',4,'sequence','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',5,'operation','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',6,'field','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',7,'operator','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',8,'pattern','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_graph_rules',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_graph_rules',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_graph_rules',3,'name','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('automation_graph_rules',4,'snmp_query_id','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rules',5,'graph_type_id','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rules',6,'enabled','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_ips',1,'ip_address','varchar(20)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('automation_ips',2,'hostname','varchar(100)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_ips',3,'network_id','int(10) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_ips',4,'pid','int(10) unsigned','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('automation_ips',5,'status','int(10) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_ips',6,'thread','int(10) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_match_rule_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_match_rule_items',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_match_rule_items',3,'rule_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_match_rule_items',4,'rule_type','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_match_rule_items',5,'sequence','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_match_rule_items',6,'operation','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_match_rule_items',7,'field','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_match_rule_items',8,'operator','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_match_rule_items',9,'pattern','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_networks',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',3,'poller_id','int(10) unsigned','YES','MUL','1',''); INSERT INTO `table_columns` VALUES ('automation_networks',4,'site_id','int(10) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('automation_networks',5,'name','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',6,'subnet_range','varchar(1024)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',7,'ignore_ips','varchar(1024)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',8,'dns_servers','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',9,'enabled','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',10,'notification_enabled','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',11,'notification_email','varchar(255)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',12,'notification_fromname','varchar(32)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',13,'notification_fromemail','varchar(128)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',14,'snmp_id','int(10) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',15,'enable_netbios','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',16,'add_to_cacti','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',17,'same_sysname','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',18,'total_ips','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',19,'up_hosts','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',20,'snmp_hosts','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',21,'ping_method','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',22,'ping_port','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',23,'ping_timeout','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',24,'ping_retries','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',25,'sched_type','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',26,'threads','int(10) unsigned','YES','','2',''); INSERT INTO `table_columns` VALUES ('automation_networks',27,'run_limit','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',28,'start_at','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',29,'next_start','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('automation_networks',30,'recur_every','int(10) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('automation_networks',31,'day_of_week','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',32,'month','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',33,'day_of_month','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',34,'monthly_week','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',35,'monthly_day','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',36,'last_runtime','double','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',37,'last_started','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('automation_networks',38,'last_status','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',39,'rerun_data_queries','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_processes',1,'pid','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('automation_processes',2,'poller_id','int(10) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('automation_processes',3,'network_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('automation_processes',4,'task','varchar(20)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_processes',5,'status','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_processes',6,'command','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_processes',7,'up_hosts','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('automation_processes',8,'snmp_hosts','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('automation_processes',9,'heartbeat','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('automation_snmp',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_snmp',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp',3,'name','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_snmp_items',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',3,'snmp_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',4,'sequence','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',5,'snmp_version','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',6,'snmp_community','varchar(100)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',7,'snmp_port','mediumint(8) unsigned','NO','','161',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',8,'snmp_timeout','int(10) unsigned','NO','','500',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',9,'snmp_retries','tinyint(3) unsigned','NO','','3',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',10,'max_oids','int(10) unsigned','YES','','10',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',11,'bulk_walk_size','int(11)','YES','','-1',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',12,'snmp_username','varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',13,'snmp_password','varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',14,'snmp_auth_protocol','char(6)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',15,'snmp_priv_passphrase','varchar(200)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',16,'snmp_priv_protocol','char(7)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',17,'snmp_context','varchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',18,'snmp_engine_id','varchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_templates',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',3,'host_template','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_templates',4,'availability_method','int(10) unsigned','YES','','2',''); INSERT INTO `table_columns` VALUES ('automation_templates',5,'sysDescr','varchar(255)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',6,'sysName','varchar(255)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',7,'sysOid','varchar(60)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',8,'description_pattern','varchar(128)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',9,'populate_location','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',10,'sequence','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('automation_templates_rules',1,'id','int(10) unsigned','NO','MUL',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_templates_rules',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_templates_rules',3,'template_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('automation_templates_rules',4,'rule_type','tinyint(3) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('automation_templates_rules',5,'rule_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('automation_templates_rules',6,'sequence','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('automation_templates_rules',7,'exit_rules','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',3,'rule_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',4,'sequence','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',5,'field','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',6,'sort_type','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',7,'propagate_changes','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',8,'search_pattern','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',9,'replace_pattern','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rules',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_tree_rules',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rules',3,'name','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rules',4,'tree_id','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rules',5,'tree_item_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rules',6,'leaf_type','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rules',7,'host_grouping_type','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rules',8,'enabled','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('cdef',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('cdef',2,'hash','varchar(32)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('cdef',3,'system','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('cdef',4,'name','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('cdef',5,'graphs','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('cdef',6,'templates','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('cdef_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('cdef_items',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('cdef_items',3,'cdef_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('cdef_items',4,'sequence','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('cdef_items',5,'type','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('cdef_items',6,'value','varchar(150)','NO','','',''); INSERT INTO `table_columns` VALUES ('color_template_items',1,'color_template_item_id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('color_template_items',2,'color_template_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('color_template_items',3,'color_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('color_template_items',4,'sequence','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('color_templates',1,'color_template_id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('color_templates',2,'name','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('color_templates',3,'graphs','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('color_templates',4,'templates','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('colors',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('colors',2,'name','varchar(40)','YES','','',''); INSERT INTO `table_columns` VALUES ('colors',3,'hex','varchar(6)','NO','UNI','',''); INSERT INTO `table_columns` VALUES ('colors',4,'read_only','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('colors',5,'graphs','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('colors',6,'templates','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_debug',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_debug',2,'started','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_debug',3,'done','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_debug',4,'user','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_debug',5,'datasource','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_debug',6,'info','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('data_debug',7,'issue','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('data_input',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_input',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_input',3,'name','varchar(200)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('data_input',4,'input_string','varchar(512)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_input',5,'type_id','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_input',6,'data_sources','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_input',7,'templates','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_input_data',1,'data_input_field_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_input_data',2,'data_template_data_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_input_data',3,'data_template_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_input_data',4,'local_data_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_input_data',5,'host_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_input_data',6,'t_value','char(2)','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('data_input_data',7,'value','text','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_input_fields',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_input_fields',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_input_fields',3,'data_input_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_input_fields',4,'name','varchar(200)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_input_fields',5,'data_name','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_input_fields',6,'input_output','char(3)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('data_input_fields',7,'update_rra','char(2)','YES','','0',''); INSERT INTO `table_columns` VALUES ('data_input_fields',8,'sequence','smallint(5)','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_input_fields',9,'type_code','varchar(40)','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('data_input_fields',10,'regexp_match','varchar(200)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_input_fields',11,'allow_nulls','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_local',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_local',2,'data_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_local',3,'host_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_local',4,'snmp_query_id','mediumint(8)','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_local',5,'snmp_index','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('data_local',6,'orphan','tinyint(3) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_local',7,'errored','tinyint(3) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_source_profiles',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',3,'name','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',4,'step','int(10) unsigned','NO','','300',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',5,'heartbeat','int(10) unsigned','NO','','600',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',6,'x_files_factor','double','YES','','0.5',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',7,'default','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',8,'data_sources','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',9,'templates','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_cf',1,'data_source_profile_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_cf',2,'consolidation_function_id','smallint(5) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',2,'data_source_profile_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',3,'name','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',4,'steps','int(10) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',5,'rows','int(10) unsigned','NO','','700',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',6,'timespan','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_action',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_source_purge_action',2,'name','varchar(128)','NO','UNI','',''); INSERT INTO `table_columns` VALUES ('data_source_purge_action',3,'local_data_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_action',4,'action','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',2,'name_cache','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',3,'local_data_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',4,'name','varchar(128)','NO','UNI','',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',5,'size','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',6,'last_mod','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',7,'in_cacti','tinyint(3) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',8,'data_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_source_stats_command_cache',1,'local_data_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_stats_command_cache',2,'stats_command','blob','NO','','\'\'',''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',2,'rrd_name','varchar(19)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',3,'cf','tinyint(3) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',4,'average','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',5,'peak','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',6,'p95n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',7,'p90n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',8,'p75n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',9,'p50n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',10,'p25n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',11,'sum','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',12,'stddev','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',13,'lslslope','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',14,'lslint','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',15,'lslcorrel','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',2,'rrd_name','varchar(19)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',3,'cf','tinyint(3) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',4,'average','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',5,'peak','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',2,'rrd_name','varchar(19)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',4,'value','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_last',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_last',2,'rrd_name','varchar(19)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_last',3,'value','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_last',4,'calculated','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',2,'rrd_name','varchar(19)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',3,'cf','tinyint(3) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',4,'average','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',5,'peak','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',6,'p95n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',7,'p90n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',8,'p75n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',9,'p50n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',10,'p25n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',11,'sum','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',12,'stddev','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',13,'lslslope','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',14,'lslint','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',15,'lslcorrel','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',2,'rrd_name','varchar(19)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',3,'cf','tinyint(3) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',4,'average','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',5,'peak','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',6,'p95n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',7,'p90n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',8,'p75n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',9,'p50n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',10,'p25n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',11,'sum','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',12,'stddev','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',13,'lslslope','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',14,'lslint','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',15,'lslcorrel','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',2,'rrd_name','varchar(19)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',3,'cf','tinyint(3) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',4,'average','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',5,'peak','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',6,'p95n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',7,'p90n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',8,'p75n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',9,'p50n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',10,'p25n','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',11,'sum','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',12,'stddev','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',13,'lslslope','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',14,'lslint','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',15,'lslcorrel','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_template',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_template',3,'name','varchar(150)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('data_template',4,'data_sources','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template',5,'templates','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template',6,'last_updated','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('data_template_data',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_template_data',2,'local_data_template_data_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_data',3,'local_data_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_template_data',4,'data_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_template_data',5,'data_input_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_template_data',6,'t_name','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_data',7,'name','varchar(250)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_template_data',8,'name_cache','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('data_template_data',9,'data_source_path','varchar(255)','YES','','',''); INSERT INTO `table_columns` VALUES ('data_template_data',10,'t_active','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('data_template_data',11,'active','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_data',12,'t_rrd_step','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('data_template_data',13,'rrd_step','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_data',14,'t_data_source_profile_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('data_template_data',15,'data_source_profile_id','mediumint(8) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_template_rrd',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',3,'local_data_template_rrd_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',4,'local_data_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',5,'data_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',6,'t_rrd_maximum','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',7,'rrd_maximum','varchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',8,'t_rrd_minimum','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',9,'rrd_minimum','varchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',10,'t_rrd_heartbeat','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',11,'rrd_heartbeat','mediumint(6)','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',12,'t_data_source_type_id','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',13,'data_source_type_id','smallint(5)','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',14,'t_data_source_name','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',15,'data_source_name','varchar(19)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',16,'t_data_input_field_id','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',17,'data_input_field_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('external_links',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('external_links',2,'sortorder','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('external_links',3,'enabled','char(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('external_links',4,'contentfile','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('external_links',5,'title','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('external_links',6,'style','varchar(10)','NO','','',''); INSERT INTO `table_columns` VALUES ('external_links',7,'extendedstyle','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('external_links',8,'refresh','int(10) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_local',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_local',2,'graph_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_local',3,'host_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_local',4,'snmp_query_id','mediumint(8)','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_local',5,'snmp_query_graph_id','mediumint(8)','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_local',6,'snmp_index','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_template_input',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_template_input',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_template_input',3,'graph_template_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_template_input',4,'name','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_template_input',5,'description','text','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_template_input',6,'column_name','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_template_input_defs',1,'graph_template_input_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('graph_template_input_defs',2,'graph_template_item_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('graph_templates',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_templates',2,'hash','char(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates',3,'name','char(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_templates',4,'class','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates',5,'version','varchar(10)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates',6,'multiple','char(2)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_templates',7,'test_source','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates',8,'graphs','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates',9,'last_updated','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',3,'name','varchar(100)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',4,'gprint_text','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',5,'graphs','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',6,'templates','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_templates_graph',2,'local_graph_template_graph_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',3,'local_graph_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',4,'graph_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',5,'t_image_format_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',6,'image_format_id','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',7,'t_title','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',8,'title','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',9,'title_cache','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',10,'t_height','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',11,'height','mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',12,'t_width','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',13,'width','mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',14,'t_upper_limit','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',15,'upper_limit','varchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',16,'t_lower_limit','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',17,'lower_limit','varchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',18,'t_vertical_label','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',19,'vertical_label','varchar(200)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',20,'t_slope_mode','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',21,'slope_mode','char(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',22,'t_auto_scale','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',23,'auto_scale','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',24,'t_auto_scale_opts','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',25,'auto_scale_opts','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',26,'t_auto_scale_log','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',27,'auto_scale_log','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',28,'t_scale_log_units','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',29,'scale_log_units','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',30,'t_auto_scale_rigid','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',31,'auto_scale_rigid','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',32,'t_auto_padding','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',33,'auto_padding','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',34,'t_base_value','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',35,'base_value','mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',36,'t_grouping','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',37,'grouping','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',38,'t_unit_value','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',39,'unit_value','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',40,'t_unit_exponent_value','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',41,'unit_exponent_value','varchar(5)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',42,'t_alt_y_grid','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',43,'alt_y_grid','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',44,'t_right_axis','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',45,'right_axis','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',46,'t_right_axis_label','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',47,'right_axis_label','varchar(200)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',48,'t_right_axis_format','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',49,'right_axis_format','mediumint(8)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',50,'t_right_axis_formatter','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',51,'right_axis_formatter','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',52,'t_left_axis_format','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',53,'left_axis_format','mediumint(8)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',54,'t_left_axis_formatter','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',55,'left_axis_formatter','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',56,'t_no_gridfit','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',57,'no_gridfit','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',58,'t_unit_length','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',59,'unit_length','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',60,'t_tab_width','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',61,'tab_width','varchar(20)','YES','','30',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',62,'t_dynamic_labels','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',63,'dynamic_labels','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',64,'t_force_rules_legend','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',65,'force_rules_legend','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',66,'t_legend_position','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',67,'legend_position','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',68,'t_legend_direction','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',69,'legend_direction','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_templates_item',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',3,'local_graph_template_item_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',4,'local_graph_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',5,'graph_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',6,'task_item_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',7,'color_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',8,'alpha','char(2)','YES','','FF',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',9,'color2_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',10,'alpha2','char(2)','YES','','FF',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',11,'gradheight','tinyint(4)','NO','','50',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',12,'graph_type_id','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',13,'line_width','decimal(4,2)','YES','','0.00',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',14,'dashes','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',15,'dash_offset','mediumint(4)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',16,'cdef_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',17,'vdef_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',18,'shift','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',19,'consolidation_function_id','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',20,'textalign','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',21,'text_format','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',22,'legend','varchar(30)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',23,'value','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',24,'hard_return','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',25,'gprint_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',26,'sequence','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_tree',1,'id','smallint(5) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_tree',2,'enabled','char(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('graph_tree',3,'locked','tinyint(3) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('graph_tree',4,'locked_date','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('graph_tree',5,'sort_type','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('graph_tree',6,'name','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_tree',7,'sequence','int(10) unsigned','YES','MUL','1',''); INSERT INTO `table_columns` VALUES ('graph_tree',8,'user_id','int(10) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('graph_tree',9,'last_modified','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('graph_tree',10,'modified_by','int(10) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('graph_tree_items',1,'id','bigint(20) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_tree_items',2,'parent','bigint(20) unsigned','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('graph_tree_items',3,'position','int(10) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_tree_items',4,'graph_tree_id','smallint(5) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_tree_items',5,'local_graph_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_tree_items',6,'title','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_tree_items',7,'host_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_tree_items',8,'site_id','int(10) unsigned','YES','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_tree_items',9,'host_grouping_type','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('graph_tree_items',10,'sort_children_type','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_tree_items',11,'graph_regex','varchar(60)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_tree_items',12,'host_regex','varchar(60)','YES','','',''); INSERT INTO `table_columns` VALUES ('host',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('host',2,'poller_id','int(10) unsigned','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('host',3,'site_id','int(10) unsigned','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('host',4,'host_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('host',5,'description','varchar(150)','NO','','',''); INSERT INTO `table_columns` VALUES ('host',6,'hostname','varchar(100)','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('host',7,'location','varchar(40)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('host',8,'notes','text','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('host',9,'external_id','varchar(40)','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('host',10,'snmp_options','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host',11,'snmp_community','varchar(100)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('host',12,'snmp_version','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('host',13,'snmp_username','varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('host',14,'snmp_password','varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('host',15,'snmp_auth_protocol','char(6)','YES','','',''); INSERT INTO `table_columns` VALUES ('host',16,'snmp_priv_passphrase','varchar(200)','YES','','',''); INSERT INTO `table_columns` VALUES ('host',17,'snmp_priv_protocol','char(7)','YES','','',''); INSERT INTO `table_columns` VALUES ('host',18,'snmp_context','varchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('host',19,'snmp_engine_id','varchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('host',20,'snmp_port','mediumint(8) unsigned','NO','','161',''); INSERT INTO `table_columns` VALUES ('host',21,'snmp_timeout','mediumint(8) unsigned','NO','','500',''); INSERT INTO `table_columns` VALUES ('host',22,'snmp_retries','tinyint(3) unsigned','NO','','3',''); INSERT INTO `table_columns` VALUES ('host',23,'snmp_sysDescr','varchar(300)','NO','','',''); INSERT INTO `table_columns` VALUES ('host',24,'snmp_sysObjectID','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('host',25,'snmp_sysUpTimeInstance','bigint(20) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host',26,'snmp_sysContact','varchar(300)','NO','','',''); INSERT INTO `table_columns` VALUES ('host',27,'snmp_sysName','varchar(300)','NO','','',''); INSERT INTO `table_columns` VALUES ('host',28,'snmp_sysLocation','varchar(300)','NO','','',''); INSERT INTO `table_columns` VALUES ('host',29,'availability_method','smallint(5) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('host',30,'ping_method','smallint(5) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('host',31,'ping_port','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('host',32,'ping_timeout','int(10) unsigned','YES','','500',''); INSERT INTO `table_columns` VALUES ('host',33,'ping_retries','int(10) unsigned','YES','','2',''); INSERT INTO `table_columns` VALUES ('host',34,'max_oids','int(10) unsigned','YES','','10',''); INSERT INTO `table_columns` VALUES ('host',35,'bulk_walk_size','int(11)','YES','','-1',''); INSERT INTO `table_columns` VALUES ('host',36,'device_threads','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('host',37,'deleted','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('host',38,'disabled','char(2)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('host',39,'graphs','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host',40,'data_sources','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host',41,'status','tinyint(3) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('host',42,'status_event_count','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host',43,'status_fail_date','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('host',44,'status_rec_date','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('host',45,'status_options_date','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('host',46,'status_last_error','varchar(255)','YES','','',''); INSERT INTO `table_columns` VALUES ('host',47,'min_time','decimal(10,5)','YES','','9.99999',''); INSERT INTO `table_columns` VALUES ('host',48,'max_time','decimal(10,5)','YES','','0.00000',''); INSERT INTO `table_columns` VALUES ('host',49,'cur_time','decimal(10,5)','YES','','0.00000',''); INSERT INTO `table_columns` VALUES ('host',50,'avg_time','decimal(10,5)','YES','','0.00000',''); INSERT INTO `table_columns` VALUES ('host',51,'polling_time','double','YES','','0',''); INSERT INTO `table_columns` VALUES ('host',52,'current_errors','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('host',53,'total_polls','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('host',54,'failed_polls','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('host',55,'availability','decimal(8,5)','NO','','100.00000',''); INSERT INTO `table_columns` VALUES ('host',56,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('host',57,'created','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('host_errors',1,'host_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_errors',2,'poller_id','int(10) unsigned','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('host_errors',3,'errors','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host_errors',4,'local_data_ids','text','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('host_graph',1,'host_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_graph',2,'graph_template_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',1,'host_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',2,'snmp_query_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',3,'field_name','varchar(50)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',4,'field_value','varchar(512)','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',5,'snmp_index','varchar(255)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',6,'oid','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',7,'present','tinyint(3) unsigned','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',8,'last_updated','timestamp','NO','MUL','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('host_snmp_query',1,'host_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',2,'snmp_query_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',3,'sort_field','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',4,'title_format','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',5,'reindex_method','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',6,'reindex_last_runtime','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',7,'reindex_last_duration','double unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host_template',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('host_template',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template',3,'name','varchar(100)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('host_template',4,'version','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template',5,'class','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template',6,'tags','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template',7,'author','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template',8,'email','varchar(60)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template',9,'homepage','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template',10,'copyright','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template',11,'installation','varchar(1024)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template',12,'devices','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host_template_archive',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('host_template_archive',2,'host_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('host_template_archive',3,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',4,'name','varchar(100)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',5,'version','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',6,'class','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',7,'tags','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',8,'author','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',9,'email','varchar(60)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',10,'homepage','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',11,'copyright','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',12,'installation','varchar(1024)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',13,'archive_note','varchar(256)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',14,'archive_date','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('host_template_archive',15,'archive_md5sum','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_template_archive',16,'archive','longblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('host_template_graph',1,'host_template_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_template_graph',2,'graph_template_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_template_snmp_query',1,'host_template_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_template_snmp_query',2,'snmp_query_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_value_cache',1,'host_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_value_cache',2,'dimension','varchar(40)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('host_value_cache',3,'value','varchar(8192)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_value_cache',4,'time_to_live','int(11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('host_value_cache',5,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('package_public_keys',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('package_public_keys',2,'md5sum','varchar(32)','NO','UNI','',''); INSERT INTO `table_columns` VALUES ('package_public_keys',3,'author','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('package_public_keys',4,'homepage','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('package_public_keys',5,'email_address','varchar(60)','NO','','',''); INSERT INTO `table_columns` VALUES ('package_public_keys',6,'public_key','varchar(1024)','YES','','',''); INSERT INTO `table_columns` VALUES ('package_repositories',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('package_repositories',2,'name','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('package_repositories',3,'enabled','char(2)','NO','','on',''); INSERT INTO `table_columns` VALUES ('package_repositories',4,'default','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('package_repositories',5,'repo_type','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('package_repositories',6,'repo_location','varchar(128)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('package_repositories',7,'repo_branch','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('package_repositories',8,'repo_api_key','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('plugin_archive',2,'plugin','varchar(32)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',3,'description','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',4,'author','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',5,'webpage','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',6,'user_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('plugin_archive',7,'version','varchar(10)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',8,'requires','varchar(128)','YES','','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',9,'compat','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',10,'dir_md5sum','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',11,'last_updated','timestamp','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_archive',12,'archive_note','varchar(256)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_archive',13,'archive','longblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_available',1,'plugin','varchar(32)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('plugin_available',2,'description','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_available',3,'author','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_available',4,'webpage','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_available',5,'tag_name','varchar(20)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('plugin_available',6,'published_at','timestamp','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_available',7,'compat','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_available',8,'requires','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_available',9,'body','blob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_available',10,'info','blob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_available',11,'readme','blob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_available',12,'changelog','blob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_available',13,'archive','longblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_available',14,'last_updated','timestamp','YES','','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('plugin_config',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('plugin_config',2,'directory','varchar(32)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_config',3,'name','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_config',4,'status','tinyint(3) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('plugin_config',5,'author','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_config',6,'webpage','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_config',7,'version','varchar(10)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_config',8,'last_updated','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('plugin_db_changes',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('plugin_db_changes',2,'plugin','varchar(16)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_db_changes',3,'table','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_db_changes',4,'column','varchar(64)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_db_changes',5,'method','varchar(16)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('plugin_hooks',2,'name','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',3,'hook','varchar(64)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',4,'file','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',5,'function','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',6,'status','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('plugin_realms',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('plugin_realms',2,'plugin','varchar(32)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_realms',3,'file','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_realms',4,'display','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller',1,'id','smallint(5) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('poller',2,'disabled','char(2)','YES','MUL','',''); INSERT INTO `table_columns` VALUES ('poller',3,'name','varchar(30)','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('poller',4,'notes','varchar(1024)','YES','','',''); INSERT INTO `table_columns` VALUES ('poller',5,'status','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller',6,'log_level','int(10)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('poller',7,'timezone','varchar(40)','YES','','',''); INSERT INTO `table_columns` VALUES ('poller',8,'hostname','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller',9,'dbdefault','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller',10,'dbhost','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller',11,'dbuser','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller',12,'dbpass','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller',13,'dbport','int(10) unsigned','YES','','3306',''); INSERT INTO `table_columns` VALUES ('poller',14,'dbretries','int(10) unsigned','YES','','2',''); INSERT INTO `table_columns` VALUES ('poller',15,'dbssl','char(3)','YES','','',''); INSERT INTO `table_columns` VALUES ('poller',16,'dbsslkey','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller',17,'dbsslcert','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller',18,'dbsslca','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller',19,'dbsslcapath','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller',20,'dbsslverifyservercert','char(3)','YES','','on',''); INSERT INTO `table_columns` VALUES ('poller',21,'total_time','double','YES','','0',''); INSERT INTO `table_columns` VALUES ('poller',22,'max_time','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller',23,'min_time','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller',24,'avg_time','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller',25,'total_polls','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('poller',26,'processes','int(10) unsigned','YES','','2',''); INSERT INTO `table_columns` VALUES ('poller',27,'threads','int(10) unsigned','YES','','2',''); INSERT INTO `table_columns` VALUES ('poller',28,'sync_interval','int(10) unsigned','YES','','7200',''); INSERT INTO `table_columns` VALUES ('poller',29,'devices','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller',30,'snmp','mediumint(8) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('poller',31,'script','mediumint(8) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('poller',32,'server','mediumint(8) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('poller',33,'last_update','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller',34,'last_status','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller',35,'last_sync','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller',36,'requires_sync','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('poller_command',1,'poller_id','smallint(5) unsigned','NO','PRI','1',''); INSERT INTO `table_columns` VALUES ('poller_command',2,'time','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_command',3,'action','tinyint(3) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_command',4,'command','varchar(191)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_command',5,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',1,'data_template_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',2,'data_name','varchar(40)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',3,'data_source_names','varchar(125)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',4,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('poller_item',1,'local_data_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_item',2,'poller_id','int(10) unsigned','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('poller_item',3,'host_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('poller_item',4,'action','tinyint(3) unsigned','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('poller_item',5,'present','tinyint(3) unsigned','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('poller_item',6,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('poller_item',7,'hostname','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',8,'snmp_community','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',9,'snmp_version','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_item',10,'snmp_username','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',11,'snmp_password','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',12,'snmp_auth_protocol','char(6)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',13,'snmp_priv_passphrase','varchar(200)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',14,'snmp_priv_protocol','char(7)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',15,'snmp_context','varchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('poller_item',16,'snmp_engine_id','varchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('poller_item',17,'snmp_port','mediumint(8) unsigned','NO','','161',''); INSERT INTO `table_columns` VALUES ('poller_item',18,'snmp_timeout','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_item',19,'snmp_retries','tinyint(3) unsigned','NO','','3',''); INSERT INTO `table_columns` VALUES ('poller_item',20,'rrd_name','varchar(19)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_item',21,'rrd_path','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',22,'rrd_num','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_item',23,'rrd_step','mediumint(8)','NO','','300',''); INSERT INTO `table_columns` VALUES ('poller_item',24,'rrd_next_step','mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_item',25,'arg1','text','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_item',26,'arg2','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_item',27,'arg3','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_output',1,'local_data_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_output',2,'rrd_name','varchar(19)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_output',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_output',4,'output','varchar(512)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_output_boost',1,'local_data_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_output_boost',2,'rrd_name','varchar(19)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_output_boost',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_output_boost',4,'output','varchar(512)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_output_boost',5,'last_updated','timestamp','NO','MUL','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('poller_output_boost_local_data_ids',1,'local_data_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_output_boost_local_data_ids',2,'process_handler','int(10) unsigned','YES','MUL','0',''); INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',1,'sock_int_value','bigint(20) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',2,'run_id','char(32)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',3,'child_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',4,'status','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',1,'local_data_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',2,'rrd_name','varchar(19)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',4,'output','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',5,'poller_id','varchar(256)','NO','PRI','1',''); INSERT INTO `table_columns` VALUES ('poller_reindex',1,'host_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_reindex',2,'data_query_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_reindex',3,'action','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_reindex',4,'present','tinyint(3) unsigned','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('poller_reindex',5,'op','char(1)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_reindex',6,'assert_value','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_reindex',7,'arg1','varchar(255)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('poller_resource_cache',2,'resource_type','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',3,'md5sum','varchar(32)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',4,'path','varchar(191)','YES','UNI',NULL,''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',5,'update_time','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',6,'contents','longblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',7,'attributes','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('poller_time',1,'id','bigint(20) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('poller_time',2,'pid','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_time',3,'poller_id','int(10) unsigned','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('poller_time',4,'start_time','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_time',5,'end_time','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_time_stats',1,'id','bigint(20) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('poller_time_stats',2,'poller_id','int(10) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('poller_time_stats',3,'total_time','double','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_time_stats',4,'time','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('processes',1,'id','bigint(20) unsigned','NO','MUL',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('processes',2,'pid','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('processes',3,'tasktype','varchar(20)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('processes',4,'taskname','varchar(40)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('processes',5,'taskid','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('processes',6,'timeout','int(10) unsigned','YES','','300',''); INSERT INTO `table_columns` VALUES ('processes',7,'started','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('processes',8,'last_update','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('reports',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('reports',2,'user_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',3,'name','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports',4,'enabled','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('reports',5,'sched_type','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',6,'run_limit','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('reports',7,'start_at','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',8,'next_start','timestamp','NO','MUL','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('reports',9,'recur_every','int(10) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('reports',10,'day_of_week','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',11,'month','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',12,'day_of_month','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',13,'monthly_week','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',14,'monthly_day','varchar(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',15,'last_runtime','double','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',16,'last_started','timestamp','NO','MUL','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('reports',17,'last_status','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports',18,'cformat','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports',19,'format_file','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports',20,'font_size','smallint(2) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',21,'alignment','smallint(2) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',22,'graph_linked','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports',23,'subject','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports',24,'from_name','varchar(40)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',25,'from_email','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',26,'email','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',27,'bcc','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',28,'notify_list','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',29,'attachment_type','smallint(2) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('reports',30,'graph_height','smallint(2) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',31,'graph_width','smallint(2) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',32,'graph_columns','smallint(2) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',33,'thumbnails','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_items',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('reports_items',2,'report_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('reports_items',3,'item_type','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('reports_items',4,'tree_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_items',5,'branch_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_items',6,'tree_cascade','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_items',7,'graph_name_regexp','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_items',8,'site_id','int(11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('reports_items',9,'host_template_id','int(11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('reports_items',10,'host_id','int(11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('reports_items',11,'graph_template_id','int(11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('reports_items',12,'local_graph_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_items',13,'timespan','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_items',14,'align','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('reports_items',15,'item_text','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('reports_items',16,'font_size','smallint(2) unsigned','NO','','10',''); INSERT INTO `table_columns` VALUES ('reports_items',17,'sequence','smallint(5) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_log',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('reports_log',2,'name','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_log',3,'source','varchar(20)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('reports_log',4,'source_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('reports_log',5,'report_output_type','varchar(5)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_log',6,'report_raw_data','longblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports_log',7,'report_raw_output','longblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports_log',8,'report_txt_output','longblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports_log',9,'report_html_output','longblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports_log',10,'report_attachments','longblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('reports_log',11,'notification','blob','NO','','\'\'',''); INSERT INTO `table_columns` VALUES ('reports_log',12,'send_type','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_log',13,'send_time','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('reports_log',14,'run_time','double','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_log',15,'sent_by','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_log',16,'sent_id','int(11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('reports_queued',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('reports_queued',2,'name','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_queued',3,'source','varchar(20)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('reports_queued',4,'source_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('reports_queued',5,'status','varchar(10)','NO','','pending',''); INSERT INTO `table_columns` VALUES ('reports_queued',6,'scheduled_time','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('reports_queued',7,'start_time','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('reports_queued',8,'run_command','varchar(512)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_queued',9,'run_timeout','int(11)','NO','','60',''); INSERT INTO `table_columns` VALUES ('reports_queued',10,'notification','blob','NO','','\'\'',''); INSERT INTO `table_columns` VALUES ('reports_queued',11,'request_type','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_queued',12,'requested_by','varchar(20)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_queued',13,'requested_id','int(11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('rrdcheck',1,'local_data_id','mediumint(8) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('rrdcheck',2,'test_date','timestamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('rrdcheck',3,'message','varchar(250)','YES','','',''); INSERT INTO `table_columns` VALUES ('sessions',1,'id','varchar(32)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('sessions',2,'remote_addr','varchar(25)','NO','','',''); INSERT INTO `table_columns` VALUES ('sessions',3,'access','int(10) unsigned','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('sessions',4,'data','mediumblob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('sessions',5,'user_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('sessions',6,'user_agent','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('sessions',7,'start_time','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('sessions',8,'transactions','int(10) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('settings',1,'name','varchar(255)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('settings',2,'value','varchar(4096)','NO','','',''); INSERT INTO `table_columns` VALUES ('settings_tree',1,'user_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('settings_tree',2,'graph_tree_item_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('settings_tree',3,'status','tinyint(4)','NO','','0',''); INSERT INTO `table_columns` VALUES ('settings_user',1,'user_id','smallint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('settings_user',2,'name','varchar(255)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('settings_user',3,'value','varchar(4096)','NO','','',''); INSERT INTO `table_columns` VALUES ('settings_user_group',1,'group_id','smallint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('settings_user_group',2,'name','varchar(50)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('settings_user_group',3,'value','varchar(2048)','NO','','',''); INSERT INTO `table_columns` VALUES ('sites',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('sites',2,'name','varchar(100)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('sites',3,'disabled','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('sites',4,'address1','varchar(100)','YES','','',''); INSERT INTO `table_columns` VALUES ('sites',5,'address2','varchar(100)','YES','','',''); INSERT INTO `table_columns` VALUES ('sites',6,'city','varchar(50)','YES','MUL','',''); INSERT INTO `table_columns` VALUES ('sites',7,'state','varchar(20)','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('sites',8,'postal_code','varchar(20)','YES','MUL','',''); INSERT INTO `table_columns` VALUES ('sites',9,'country','varchar(30)','YES','MUL','',''); INSERT INTO `table_columns` VALUES ('sites',10,'region','varchar(30)','YES','','',''); INSERT INTO `table_columns` VALUES ('sites',11,'timezone','varchar(40)','YES','','',''); INSERT INTO `table_columns` VALUES ('sites',12,'latitude','decimal(13,10)','NO','','0.0000000000',''); INSERT INTO `table_columns` VALUES ('sites',13,'longitude','decimal(13,10)','NO','','0.0000000000',''); INSERT INTO `table_columns` VALUES ('sites',14,'zoom','tinyint(3) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('sites',15,'alternate_id','varchar(30)','YES','MUL','',''); INSERT INTO `table_columns` VALUES ('sites',16,'notes','varchar(1024)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('sites',17,'devices','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('snmp_query',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmp_query',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmp_query',3,'xml_path','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmp_query',4,'name','varchar(100)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('snmp_query',5,'description','varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('snmp_query',6,'graph_template_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('snmp_query',7,'data_input_id','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('snmp_query',8,'graphs','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('snmp_query',9,'templates','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('snmp_query',10,'last_updated','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmp_query_graph',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph',3,'snmp_query_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph',4,'name','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph',5,'graph_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd',1,'snmp_query_graph_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd',2,'data_template_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd',3,'data_template_rrd_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd',4,'snmp_field_name','varchar(50)','NO','','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',3,'snmp_query_graph_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',4,'data_template_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',5,'sequence','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',6,'field_name','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',7,'text','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',3,'snmp_query_graph_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',4,'sequence','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',5,'field_name','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',6,'text','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',1,'oid','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',2,'name','varchar(50)','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',3,'mib','varchar(50)','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',4,'type','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',5,'otype','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',6,'kind','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',7,'max-access','varchar(50)','NO','','not-accessible',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',8,'value','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',9,'description','varchar(5000)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',1,'name','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',2,'mib','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',3,'attribute','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',4,'sequence_id','smallint(6)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',1,'name','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',2,'mib','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',3,'type','varchar(50)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',4,'description','varchar(5000)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmpagent_managers',2,'hostname','varchar(100)','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',3,'description','varchar(255)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',4,'disabled','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',5,'max_log_size','tinyint(4)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',6,'snmp_version','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',7,'snmp_community','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',8,'snmp_username','varchar(50)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',9,'snmp_password','varchar(50)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',10,'snmp_auth_protocol','char(6)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',11,'snmp_priv_passphrase','varchar(200)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',12,'snmp_priv_protocol','char(7)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',13,'snmp_engine_id','varchar(64)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',14,'snmp_port','mediumint(8) unsigned','NO','','161',''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',15,'snmp_message_type','tinyint(4)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',16,'notes','text','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',1,'manager_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',2,'notification','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',3,'mib','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_mibs',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmpagent_mibs',2,'name','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_mibs',3,'file','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',2,'time','int(24)','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',3,'severity','tinyint(4)','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',4,'manager_id','int(10) unsigned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',5,'notification','varchar(190)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',6,'mib','varchar(50)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',7,'varbinds','varchar(5000)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',1,'table_name','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',2,'table_sequence','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',3,'table_field','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',4,'table_type','varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',5,'table_null','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',6,'table_key','varchar(4)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',7,'table_default','varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',8,'table_extra','varchar(128)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',1,'idx_table_name','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',2,'idx_non_unique','int(10) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',3,'idx_key_name','varchar(128)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',4,'idx_seq_in_index','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',5,'idx_column_name','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',6,'idx_collation','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',7,'idx_cardinality','int(10) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',8,'idx_sub_part','varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',9,'idx_packed','varchar(128)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',10,'idx_null','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',11,'idx_index_type','varchar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_indexes',12,'idx_comment','varchar(128)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('user_auth',2,'username','varchar(50)','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('user_auth',3,'password','varchar(256)','NO','','',''); INSERT INTO `table_columns` VALUES ('user_auth',4,'realm','mediumint(8)','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('user_auth',5,'full_name','varchar(100)','YES','','0',''); INSERT INTO `table_columns` VALUES ('user_auth',6,'email_address','varchar(128)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth',7,'must_change_password','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth',8,'password_change','char(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('user_auth',9,'show_tree','char(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('user_auth',10,'show_list','char(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('user_auth',11,'show_preview','char(2)','NO','','on',''); INSERT INTO `table_columns` VALUES ('user_auth',12,'graph_settings','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth',13,'login_opts','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth',14,'policy_graphs','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth',15,'policy_trees','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth',16,'policy_hosts','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth',17,'policy_graph_templates','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth',18,'enabled','char(2)','NO','MUL','on',''); INSERT INTO `table_columns` VALUES ('user_auth',19,'lastchange','int(11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('user_auth',20,'lastlogin','int(11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('user_auth',21,'password_history','varchar(4096)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('user_auth',22,'locked','varchar(3)','NO','','',''); INSERT INTO `table_columns` VALUES ('user_auth',23,'failed_attempts','int(5)','NO','','0',''); INSERT INTO `table_columns` VALUES ('user_auth',24,'lastfail','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('user_auth',25,'reset_perms','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('user_auth',26,'tfa_enabled','char(3)','NO','','',''); INSERT INTO `table_columns` VALUES ('user_auth',27,'tfa_secret','char(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('user_auth_cache',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('user_auth_cache',2,'user_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('user_auth_cache',3,'hostname','varchar(100)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('user_auth_cache',4,'last_update','timestamp','NO','MUL','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('user_auth_cache',5,'token','varchar(191)','NO','UNI','',''); INSERT INTO `table_columns` VALUES ('user_auth_group',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('user_auth_group',2,'name','varchar(20)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group',3,'description','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('user_auth_group',4,'graph_settings','varchar(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group',5,'login_opts','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth_group',6,'show_tree','varchar(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('user_auth_group',7,'show_list','varchar(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('user_auth_group',8,'show_preview','varchar(2)','NO','','on',''); INSERT INTO `table_columns` VALUES ('user_auth_group',9,'policy_graphs','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth_group',10,'policy_trees','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth_group',11,'policy_hosts','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth_group',12,'policy_graph_templates','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth_group',13,'enabled','char(2)','NO','','on',''); INSERT INTO `table_columns` VALUES ('user_auth_group_members',1,'group_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group_members',2,'user_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group_perms',1,'group_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_group_perms',2,'item_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_group_perms',3,'type','tinyint(3) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_group_realm',1,'group_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group_realm',2,'realm_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_perms',1,'user_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_perms',2,'item_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_perms',3,'type','tinyint(3) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_realm',1,'realm_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_realm',2,'user_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_reset_hashes',1,'user_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_reset_hashes',2,'hash','varchar(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('user_auth_reset_hashes',3,'expiry','timestamp','NO','PRI','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('user_auth_row_cache',1,'user_id','mediumint(8)','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_row_cache',2,'class','varchar(20)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('user_auth_row_cache',3,'hash','varchar(32)','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_row_cache',4,'total_rows','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('user_auth_row_cache',5,'time','timestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('login_providers',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('login_providers',2,'name','varchar(64)','NO','','',''); INSERT INTO `table_columns` VALUES ('login_providers',3,'description','varchar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('login_providers',4,'type','tinyint(3) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('login_providers',5,'button_label','varchar(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('login_providers',6,'enabled','char(2)','NO','','on',''); INSERT INTO `table_columns` VALUES ('login_providers',7,'debug','char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('login_providers',8,'is_default','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('login_providers',9,'allow_auth_cookies','char(2)','NO','','on',''); INSERT INTO `table_columns` VALUES ('login_providers',10,'user_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('login_providers',11,'parameters','longtext','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_layouts',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('user_layouts',2,'user_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('user_layouts',3,'page','varchar(64)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('user_layouts',4,'name','varchar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('user_layouts',5,'data','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_log',1,'username','varchar(50)','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_log',2,'user_id','mediumint(8)','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_log',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('user_log',4,'result','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('user_log',5,'ip','varchar(40)','NO','','',''); INSERT INTO `table_columns` VALUES ('vdef',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('vdef',2,'hash','varchar(32)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('vdef',3,'name','varchar(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('vdef',4,'graphs','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('vdef',5,'templates','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('vdef_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('vdef_items',2,'hash','varchar(32)','NO','','',''); INSERT INTO `table_columns` VALUES ('vdef_items',3,'vdef_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('vdef_items',4,'sequence','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('vdef_items',5,'type','tinyint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('vdef_items',6,'value','varchar(150)','NO','','',''); INSERT INTO `table_columns` VALUES ('version',1,'cacti','char(30)','NO','PRI','',''); /*!40000 ALTER TABLE `table_columns` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `table_indexes` -- DROP TABLE IF EXISTS `table_indexes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `table_indexes` ( `idx_table_name` varchar(50) NOT NULL, `idx_non_unique` int(10) unsigned DEFAULT NULL, `idx_key_name` varchar(128) NOT NULL, `idx_seq_in_index` int(10) unsigned NOT NULL, `idx_column_name` varchar(50) NOT NULL, `idx_collation` varchar(10) DEFAULT NULL, `idx_cardinality` int(10) unsigned DEFAULT NULL, `idx_sub_part` varchar(50) DEFAULT NULL, `idx_packed` varchar(128) DEFAULT NULL, `idx_null` varchar(10) DEFAULT NULL, `idx_index_type` varchar(20) DEFAULT NULL, `idx_comment` varchar(128) DEFAULT NULL, PRIMARY KEY (`idx_table_name`,`idx_key_name`,`idx_seq_in_index`,`idx_column_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Holds Default Cacti Index Definitions'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `table_indexes` -- LOCK TABLES `table_indexes` WRITE; /*!40000 ALTER TABLE `table_indexes` DISABLE KEYS */; INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates',1,'graph_template_id',1,'graph_template_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates_graph',0,'PRIMARY',1,'aggregate_template_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates_item',0,'PRIMARY',1,'aggregate_template_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates_item',0,'PRIMARY',2,'graph_templates_item_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graphs',1,'aggregate_template_id',1,'aggregate_template_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graphs',1,'local_graph_id',1,'local_graph_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graphs',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graphs',1,'title_format',1,'title_format','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graphs',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graphs_graph_item',0,'PRIMARY',1,'aggregate_graph_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graphs_graph_item',0,'PRIMARY',2,'graph_templates_item_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graphs_items',0,'PRIMARY',1,'aggregate_graph_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('aggregate_graphs_items',0,'PRIMARY',2,'local_graph_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_devices',1,'hostname',1,'hostname','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_devices',0,'ip',1,'ip','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_devices',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_graph_rule_items',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_graph_rules',1,'name',1,'name','A',0,'171',NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_graph_rules',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_ips',1,'pid',1,'pid',NULL,0,NULL,NULL,'YES','HASH',''); INSERT INTO `table_indexes` VALUES ('automation_ips',0,'PRIMARY',1,'ip_address',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('automation_match_rule_items',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_networks',1,'poller_id',1,'poller_id','A',0,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_networks',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_processes',0,'PRIMARY',1,'pid',NULL,NULL,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('automation_processes',0,'PRIMARY',2,'network_id',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('automation_snmp',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_snmp_items',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_snmp_items',0,'PRIMARY',2,'snmp_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_templates',0,'PRIMARY',1,'id','A',3,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_templates_rules',1,'id',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_templates_rules',0,'PRIMARY',1,'template_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_templates_rules',0,'PRIMARY',2,'rule_type','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_templates_rules',0,'PRIMARY',3,'rule_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_tree_rule_items',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_tree_rules',1,'name',1,'name','A',0,'171',NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('automation_tree_rules',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('cdef',1,'hash',1,'hash','A',62,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('cdef',1,'name',1,'name','A',62,'171',NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('cdef',0,'PRIMARY',1,'id','A',62,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('cdef_items',1,'cdef_id_sequence',1,'cdef_id','A',160,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('cdef_items',1,'cdef_id_sequence',2,'sequence','A',160,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('cdef_items',0,'PRIMARY',1,'id','A',160,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('color_template_items',0,'PRIMARY',1,'color_template_item_id','A',44,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('color_templates',0,'PRIMARY',1,'color_template_id','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('colors',0,'hex',1,'hex','A',464,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('colors',0,'PRIMARY',1,'id','A',464,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_debug',1,'datasource',1,'datasource','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_debug',1,'done',1,'done','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_debug',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_debug',1,'started',1,'started','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_debug',1,'user',1,'user','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input',1,'name_type_id',1,'name','A',47,'171',NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input',1,'name_type_id',2,'type_id','A',47,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input',0,'PRIMARY',1,'id','A',47,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_data',1,'data_template_data_id',1,'data_template_data_id','A',797,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_data',1,'data_template_id',1,'data_template_id','A',797,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_data',1,'host_id',1,'host_id','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_data',1,'local_data_id',1,'local_data_id','A',6,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_data',0,'PRIMARY',1,'data_input_field_id','A',151,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_data',0,'PRIMARY',2,'data_template_data_id','A',3190,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_data',1,'t_value',1,'t_value','A',6,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_fields',1,'data_input_id',1,'data_input_id','A',100,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_fields',1,'input_output',1,'input_output','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_fields',0,'PRIMARY',1,'id','A',201,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_fields',1,'type_code_data_input_id',1,'type_code','A',33,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_input_fields',1,'type_code_data_input_id',2,'data_input_id','A',201,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_local',1,'data_template_id',1,'data_template_id','A',7,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_local',1,'errored',1,'errored','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_local',1,'host_id_snmp_query_id',1,'host_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_local',1,'host_id_snmp_query_id',2,'snmp_query_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_local',1,'orphan',1,'orphan','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_local',0,'PRIMARY',1,'id','A',7,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_local',1,'snmp_index',1,'snmp_index','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_local',1,'snmp_query_id',1,'snmp_query_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_profiles',1,'name',1,'name','A',6,'171',NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_profiles',0,'PRIMARY',1,'id','A',6,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_profiles_cf',0,'PRIMARY',1,'data_source_profile_id','A',12,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_profiles_cf',0,'PRIMARY',2,'consolidation_function_id','A',24,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_profiles_rra',1,'data_source_profile_id',1,'data_source_profile_id','A',12,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_profiles_rra',0,'PRIMARY',1,'id','A',24,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_purge_action',0,'name',1,'name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_purge_action',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',1,'data_template_id',1,'data_template_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',1,'in_cacti',1,'in_cacti','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',1,'local_data_id',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',0,'name',1,'name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_command_cache',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_daily',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_daily',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_daily',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',0,'PRIMARY',2,'time','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',0,'PRIMARY',3,'rrd_name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',1,'time',1,'time','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_last',0,'PRIMARY',1,'local_data_id',NULL,NULL,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_last',0,'PRIMARY',2,'rrd_name',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_monthly',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_monthly',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_monthly',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_weekly',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_weekly',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_weekly',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_yearly',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_yearly',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_source_stats_yearly',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template',1,'name',1,'name','A',366,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template',0,'PRIMARY',1,'id','A',366,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_data',1,'data_input_id',1,'data_input_id','A',93,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_data',1,'data_template_id',1,'data_template_id','A',373,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_data',1,'local_data_id',1,'local_data_id','A',8,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_data',1,'name_cache',1,'name_cache','A',8,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_data',0,'PRIMARY',1,'id','A',373,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_rrd',1,'data_template_id',1,'data_template_id','A',667,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'duplicate_dsname_contraint',1,'local_data_id','A',8,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'duplicate_dsname_contraint',2,'data_source_name','A',667,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'duplicate_dsname_contraint',3,'data_template_id','A',667,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_rrd',1,'local_data_template_rrd_id',1,'local_data_template_rrd_id','A',8,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'PRIMARY',1,'id','A',667,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('external_links',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_local',1,'graph_template_id',1,'graph_template_id','A',6,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_local',1,'host_id',1,'host_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_local',0,'PRIMARY',1,'id','A',6,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_local',1,'snmp_index',1,'snmp_index','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_local',1,'snmp_query_graph_id',1,'snmp_query_graph_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_local',1,'snmp_query_id',1,'snmp_query_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_template_input',0,'PRIMARY',1,'id','A',698,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_template_input_defs',0,'PRIMARY',1,'graph_template_input_id','A',1523,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_template_input_defs',0,'PRIMARY',2,'graph_template_item_id','A',3047,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates',1,'multiple_name',1,'multiple','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates',1,'multiple_name',2,'name','A',301,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates',1,'name',1,'name','A',301,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates',0,'PRIMARY',1,'id','A',301,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_gprint',1,'name',1,'name','A',12,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_gprint',0,'PRIMARY',1,'id','A',12,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_graph',1,'graph_template_id',1,'graph_template_id','A',307,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_graph',1,'local_graph_id',1,'local_graph_id','A',10,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_graph',0,'PRIMARY',1,'id','A',307,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_graph',1,'title_cache',1,'title_cache','A',8,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'cdef_id',1,'cdef_id','A',124,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'color_id',1,'color_id','A',323,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'gprint_id',1,'gprint_id','A',24,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'graph_template_id',1,'graph_template_id','A',647,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'lgi_gti',1,'local_graph_id','A',10,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'lgi_gti',2,'graph_template_id','A',647,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'local_graph_id_sequence',1,'local_graph_id','A',10,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'local_graph_id_sequence',2,'sequence','A',140,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'local_graph_template_item_id',1,'local_graph_template_item_id','A',40,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',0,'PRIMARY',1,'id','A',3238,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'task_item_id',1,'task_item_id','A',1619,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'vdef_id',1,'vdef_id','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree',1,'name',1,'name','A',0,'171',NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree',1,'sequence',1,'sequence','A',0,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'graph_tree_id',1,'graph_tree_id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'host_id',1,'host_id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'local_graph_id',1,'local_graph_id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'parent_position',1,'parent','A',1,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'parent_position',2,'position','A',1,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree_items',0,'PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'site_id',1,'site_id','A',1,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'current_errors',1,'current_errors','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'disabled',1,'disabled','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'external_id',1,'external_id','A',1,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'host_template_id',1,'host_template_id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'hostname',1,'hostname','A',1,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'poller_id_disabled',1,'poller_id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'poller_id_disabled',2,'disabled','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'poller_id_last_updated',1,'poller_id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'poller_id_last_updated',2,'last_updated','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',0,'PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'site_id_location',1,'site_id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'site_id_location',2,'location','A',1,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('host',1,'status',1,'status','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_errors',1,'poller_id',1,'poller_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_errors',0,'PRIMARY',1,'host_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_graph',0,'PRIMARY',1,'host_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_graph',0,'PRIMARY',2,'graph_template_id','A',6,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'field_name',1,'field_name','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'field_value',1,'field_value','A',8,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'host_id',1,'host_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'host_id',2,'field_name','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'last_updated',1,'last_updated','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'present',1,'present','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',0,'PRIMARY',1,'host_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',0,'PRIMARY',2,'snmp_query_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',0,'PRIMARY',3,'field_name','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',0,'PRIMARY',4,'snmp_index','A',8,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'snmp_index',1,'snmp_index','A',8,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'snmp_query_id',1,'snmp_query_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_query',0,'PRIMARY',1,'host_id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_snmp_query',0,'PRIMARY',2,'snmp_query_id','A',1,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_template',1,'name',1,'name','A',27,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_template',0,'PRIMARY',1,'id','A',27,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_template_archive',1,'host_template_id',1,'host_template_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_template_archive',1,'name',1,'name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_template_archive',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_template_graph',0,'PRIMARY',1,'host_template_id','A',58,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_template_graph',0,'PRIMARY',2,'graph_template_id','A',235,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_template_snmp_query',0,'PRIMARY',1,'host_template_id','A',85,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_template_snmp_query',0,'PRIMARY',2,'snmp_query_id','A',85,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_value_cache',0,'PRIMARY',1,'host_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('host_value_cache',0,'PRIMARY',2,'dimension','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('package_public_keys',0,'md5sum',1,'md5sum','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('package_public_keys',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('package_repositories',0,'location_branch',1,'repo_location','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('package_repositories',0,'location_branch',2,'repo_branch','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('package_repositories',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_archive',1,'directory',1,'plugin','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_archive',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_available',0,'PRIMARY',1,'plugin','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_available',0,'PRIMARY',2,'tag_name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_config',1,'directory',1,'directory','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_config',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_config',1,'status',1,'status','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_db_changes',1,'method',1,'method','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_db_changes',1,'plugin',1,'plugin','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_db_changes',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_hooks',1,'hook',1,'hook','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_hooks',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_hooks',1,'status',1,'status','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_realms',1,'plugin',1,'plugin','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('plugin_realms',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller',1,'disabled',1,'disabled','A',0,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller',1,'name',1,'name','A',0,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_command',1,'poller_id_last_updated',1,'poller_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_command',1,'poller_id_last_updated',2,'last_updated','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_command',0,'PRIMARY',1,'poller_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_command',0,'PRIMARY',2,'action','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_command',0,'PRIMARY',3,'command','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_data_template_field_mappings',0,'PRIMARY',1,'data_template_id','A',133,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_data_template_field_mappings',0,'PRIMARY',2,'data_name','A',133,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_data_template_field_mappings',0,'PRIMARY',3,'data_source_names','A',133,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'action',1,'action','A',7,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'host_id',1,'host_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_action',1,'poller_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_action',2,'action','A',7,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_host_id',1,'poller_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_host_id',2,'host_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_last_updated',1,'poller_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_last_updated',2,'last_updated','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_rrd_next_step',1,'poller_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_rrd_next_step',2,'rrd_next_step','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',1,'present',1,'present','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',0,'PRIMARY',1,'local_data_id','A',7,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_item',0,'PRIMARY',2,'rrd_name','A',7,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output',0,'PRIMARY',1,'local_data_id','A',NULL,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output',0,'PRIMARY',2,'rrd_name','A',NULL,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output',0,'PRIMARY',3,'time','A',NULL,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost',1,'last_updated',1,'last_updated','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost',0,'PRIMARY',2,'time','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost',0,'PRIMARY',3,'rrd_name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost',1,'time',1,'time','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost_local_data_ids',0,'PRIMARY',1,'local_data_id',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost_local_data_ids',1,'process_handler',1,'process_handler',NULL,0,NULL,NULL,'YES','HASH',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost_processes',0,'PRIMARY',1,'sock_int_value',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost_processes',0,'run_child',1,'run_id',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('poller_output_boost_processes',0,'run_child',2,'child_id',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('poller_output_realtime',1,'poller_id',1,'poller_id','A',0,'191',NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_realtime',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_realtime',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_realtime',0,'PRIMARY',3,'time','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_realtime',0,'PRIMARY',4,'poller_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_output_realtime',1,'time',1,'time','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_reindex',1,'present',1,'present','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_reindex',0,'PRIMARY',1,'host_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_reindex',0,'PRIMARY',2,'data_query_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_reindex',0,'PRIMARY',3,'arg1','A',0,'187',NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_resource_cache',0,'path',1,'path','A',0,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_resource_cache',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_time',1,'poller_id_end_time',1,'poller_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_time',1,'poller_id_end_time',2,'end_time','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_time',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('poller_time_stats',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('processes',1,'id',1,'id',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('processes',0,'PRIMARY',1,'pid',NULL,NULL,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('processes',0,'PRIMARY',2,'tasktype',NULL,NULL,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('processes',0,'PRIMARY',3,'taskname',NULL,NULL,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('processes',0,'PRIMARY',4,'taskid',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('processes',1,'tasktype',1,'tasktype',NULL,0,NULL,NULL,'','HASH',''); INSERT INTO `table_indexes` VALUES ('reports',1,'last_started',1,'last_started','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports',1,'next_start',1,'next_start','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports_items',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports_items',1,'report_id',1,'report_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports_log',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports_log',1,'source',1,'source','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports_log',1,'source_id',1,'source_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports_queued',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports_queued',1,'source',1,'source','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('reports_queued',1,'source_id',1,'source_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('sessions',1,'access',1,'access','A',0,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('sessions',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('sessions',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('settings',0,'PRIMARY',1,'name','A',285,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('settings_tree',0,'PRIMARY',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('settings_tree',0,'PRIMARY',2,'graph_tree_item_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('settings_user',0,'PRIMARY',1,'user_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('settings_user',0,'PRIMARY',2,'name','A',6,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('settings_user_group',0,'PRIMARY',1,'group_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('settings_user_group',0,'PRIMARY',2,'name','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('sites',1,'alternate_id',1,'alternate_id','A',2,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('sites',1,'city',1,'city','A',2,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('sites',1,'country',1,'country','A',2,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('sites',1,'name',1,'name','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('sites',1,'postal_code',1,'postal_code','A',2,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('sites',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('sites',1,'state',1,'state','A',2,NULL,NULL,'YES','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query',1,'name',1,'name','A',68,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query',0,'PRIMARY',1,'id','A',68,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'graph_template_id_name',1,'graph_template_id','A',170,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'graph_template_id_name',2,'name','A',170,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph',0,'PRIMARY',1,'id','A',170,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'snmp_query_id_name',1,'snmp_query_id','A',170,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'snmp_query_id_name',2,'name','A',170,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',1,'data_template_rrd_id',1,'data_template_rrd_id','A',420,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',0,'PRIMARY',1,'snmp_query_graph_id','A',420,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',0,'PRIMARY',2,'data_template_id','A',420,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',0,'PRIMARY',3,'data_template_rrd_id','A',420,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd_sv',1,'data_template_id',1,'data_template_id','A',139,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd_sv',0,'PRIMARY',1,'id','A',139,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd_sv',1,'snmp_query_graph_id',1,'snmp_query_graph_id','A',139,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph_sv',0,'PRIMARY',1,'id','A',126,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmp_query_graph_sv',1,'snmp_query_graph_id',1,'snmp_query_graph_id','A',126,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache',1,'mib_name',1,'mib','A',6,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache',1,'mib_name',2,'name','A',166,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache',1,'name',1,'name','A',166,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache',0,'PRIMARY',1,'oid','A',166,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache_notifications',0,'PRIMARY',1,'name','A',17,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache_notifications',0,'PRIMARY',2,'mib','A',17,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache_notifications',0,'PRIMARY',3,'attribute','A',17,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache_notifications',0,'PRIMARY',4,'sequence_id','A',17,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache_textual_conventions',1,'mib',1,'mib','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache_textual_conventions',0,'PRIMARY',1,'name','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache_textual_conventions',0,'PRIMARY',2,'mib','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_cache_textual_conventions',0,'PRIMARY',3,'type','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_managers',1,'hostname',1,'hostname','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_managers',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_managers_notifications',1,'mib',1,'mib','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_managers_notifications',0,'PRIMARY',1,'manager_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_managers_notifications',0,'PRIMARY',2,'notification','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_managers_notifications',0,'PRIMARY',3,'mib','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_mibs',0,'PRIMARY',1,'id','A',3,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',1,'manager_id_notification',1,'manager_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',1,'manager_id_notification',2,'notification','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',1,'severity',1,'severity','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',1,'time',1,'time','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('table_columns',0,'PRIMARY',1,'table_name','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('table_columns',0,'PRIMARY',2,'table_sequence','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('table_columns',0,'PRIMARY',3,'table_field','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('table_indexes',0,'PRIMARY',1,'idx_table_name','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('table_indexes',0,'PRIMARY',2,'idx_key_name','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('table_indexes',0,'PRIMARY',3,'idx_seq_in_index','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('table_indexes',0,'PRIMARY',4,'idx_column_name','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth',1,'enabled',1,'enabled','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth',1,'realm',1,'realm','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth',1,'username',1,'username','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_cache',1,'hostname',1,'hostname','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_cache',1,'last_update',1,'last_update','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_cache',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_cache',0,'tokenkey',1,'token','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_cache',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_members',0,'PRIMARY',1,'group_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_members',0,'PRIMARY',2,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_members',1,'realm_id',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',1,'group_id',1,'group_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',1,'group_id',2,'type','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',0,'PRIMARY',1,'group_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',0,'PRIMARY',2,'item_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',0,'PRIMARY',3,'type','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_realm',0,'PRIMARY',1,'group_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_realm',0,'PRIMARY',2,'realm_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_group_realm',1,'realm_id',1,'realm_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_perms',0,'PRIMARY',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_perms',0,'PRIMARY',2,'item_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_perms',0,'PRIMARY',3,'type','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_perms',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_perms',1,'user_id',2,'type','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_realm',0,'PRIMARY',1,'realm_id','A',31,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_realm',0,'PRIMARY',2,'user_id','A',31,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_realm',1,'user_id',1,'user_id','A',4,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_reset_hashes',0,'PRIMARY',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_reset_hashes',0,'PRIMARY',2,'expiry','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_row_cache',0,'PRIMARY',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_row_cache',0,'PRIMARY',2,'class','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_auth_row_cache',0,'PRIMARY',3,'hash','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('login_providers',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_layouts',1,'page',1,'page','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_layouts',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_layouts',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_log',0,'PRIMARY',1,'username','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_log',0,'PRIMARY',2,'user_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_log',0,'PRIMARY',3,'time','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('user_log',1,'user_id',1,'user_id','A',2,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('vdef',1,'hash',1,'hash','A',7,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('vdef',1,'name',1,'name','A',7,'171',NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('vdef',0,'PRIMARY',1,'id','A',7,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('vdef_items',0,'PRIMARY',1,'id','A',15,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('vdef_items',1,'vdef_id_sequence',1,'vdef_id','A',15,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('vdef_items',1,'vdef_id_sequence',2,'sequence','A',15,NULL,NULL,'','BTREE',''); INSERT INTO `table_indexes` VALUES ('version',0,'PRIMARY',1,'cacti','A',1,NULL,NULL,'','BTREE',''); /*!40000 ALTER TABLE `table_indexes` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-02-12 22:48:58