mirror of
https://github.com/Cacti/cacti.git
synced 2026-10-27 23:27:44 +09:00
1462 lines
150 KiB
SQL
1462 lines
150 KiB
SQL
-- MariaDB dump 10.19 Distrib 10.5.18-MariaDB, for Linux (x86_64)
|
|
--
|
|
-- Host: localhost Database: cacti
|
|
-- ------------------------------------------------------
|
|
-- Server version 10.5.18-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 = utf8 */;
|
|
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_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_formatter','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',47,'left_axis_formatter','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',48,'t_no_gridfit','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',49,'no_gridfit','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',50,'t_unit_length','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',51,'unit_length','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',52,'t_tab_width','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',53,'tab_width','varchar(20)','YES','','30','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',54,'t_dynamic_labels','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',55,'dynamic_labels','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',56,'t_force_rules_legend','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',57,'force_rules_legend','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',58,'t_legend_position','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',59,'legend_position','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',60,'t_legend_direction','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',61,'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()','on update 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,'hostname','varchar(100)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',4,'ip','varchar(17)','NO','UNI','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',5,'snmp_community','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',6,'snmp_version','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',7,'snmp_port','mediumint(8) unsigned','NO','','161','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',8,'snmp_username','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',9,'snmp_password','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',10,'snmp_auth_protocol','char(6)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',11,'snmp_priv_passphrase','varchar(200)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',12,'snmp_priv_protocol','char(6)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',13,'snmp_context','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',14,'snmp_engine_id','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',15,'sysName','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',16,'sysLocation','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',17,'sysContact','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',18,'sysDescr','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',19,'sysUptime','bigint(20) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',20,'os','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',21,'snmp','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',22,'known','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',23,'up','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',24,'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,'rule_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',3,'sequence','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',4,'operation','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',5,'field','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',6,'operator','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',7,'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,'name','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rules',3,'snmp_query_id','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rules',4,'graph_type_id','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rules',5,'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,'rule_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',3,'rule_type','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',4,'sequence','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',5,'operation','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',6,'field','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',7,'operator','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',8,'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,'poller_id','int(10) unsigned','YES','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',3,'site_id','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',4,'name','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',5,'subnet_range','varchar(1024)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',6,'dns_servers','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',7,'enabled','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',8,'notification_enabled','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',9,'notification_email','varchar(255)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',10,'notification_fromname','varchar(32)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',11,'notification_fromemail','varchar(128)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',12,'snmp_id','int(10) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',13,'enable_netbios','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',14,'add_to_cacti','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',15,'same_sysname','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',16,'total_ips','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',17,'up_hosts','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',18,'snmp_hosts','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',19,'ping_method','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',20,'ping_port','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',21,'ping_timeout','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',22,'ping_retries','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',23,'sched_type','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',24,'threads','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',25,'run_limit','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',26,'start_at','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',27,'next_start','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',28,'recur_every','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',29,'day_of_week','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',30,'month','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',31,'day_of_month','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',32,'monthly_week','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',33,'monthly_day','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',34,'last_runtime','double','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',35,'last_started','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',36,'last_status','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',37,'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,'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,'snmp_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',3,'sequence','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',4,'snmp_version','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',5,'snmp_community','varchar(100)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',6,'snmp_port','mediumint(8) unsigned','NO','','161','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',7,'snmp_timeout','int(10) unsigned','NO','','500','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',8,'snmp_retries','tinyint(3) unsigned','NO','','3','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',9,'max_oids','int(10) unsigned','YES','','10','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',10,'bulk_walk_size','int(11)','YES','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',11,'snmp_username','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',12,'snmp_password','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',13,'snmp_auth_protocol','char(6)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',14,'snmp_priv_passphrase','varchar(200)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',15,'snmp_priv_protocol','char(6)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',16,'snmp_context','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',17,'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,'host_template','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',3,'availability_method','int(10) unsigned','YES','','2','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',4,'sysDescr','varchar(255)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',5,'sysName','varchar(255)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',6,'sysOid','varchar(60)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',7,'sequence','int(10) unsigned','YES','','0','');
|
|
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,'rule_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',3,'sequence','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',4,'field','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',5,'sort_type','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',6,'propagate_changes','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',7,'search_pattern','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',8,'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,'name','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',3,'tree_id','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',4,'tree_item_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',5,'leaf_type','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',6,'host_grouping_type','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',7,'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_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 ('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 ('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_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,'t_value','char(2)','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_input_data',4,'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','','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_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_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,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',4,'peak','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,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',4,'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,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',4,'peak','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,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',4,'peak','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,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',4,'peak','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_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,'multiple','char(2)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',5,'test_source','char(2)','NO','','','');
|
|
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_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_formatter','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',53,'left_axis_formatter','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',54,'t_no_gridfit','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',55,'no_gridfit','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',56,'t_unit_length','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',57,'unit_length','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',58,'t_tab_width','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',59,'tab_width','varchar(20)','YES','','30','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',60,'t_dynamic_labels','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',61,'dynamic_labels','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',62,'t_force_rules_legend','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',63,'force_rules_legend','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',64,'t_legend_position','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',65,'legend_position','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',66,'t_legend_direction','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',67,'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,'graph_type_id','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',10,'line_width','decimal(4,2)','YES','','0.00','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',11,'dashes','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',12,'dash_offset','mediumint(4)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',13,'cdef_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',14,'vdef_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',15,'shift','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',16,'consolidation_function_id','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',17,'textalign','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',18,'text_format','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',19,'value','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',20,'hard_return','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',21,'gprint_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',22,'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','','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_community','varchar(100)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',11,'snmp_version','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('host',12,'snmp_username','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',13,'snmp_password','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',14,'snmp_auth_protocol','char(6)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',15,'snmp_priv_passphrase','varchar(200)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',16,'snmp_priv_protocol','char(6)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',17,'snmp_context','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',18,'snmp_engine_id','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',19,'snmp_port','mediumint(8) unsigned','NO','','161','');
|
|
INSERT INTO `table_columns` VALUES ('host',20,'snmp_timeout','mediumint(8) unsigned','NO','','500','');
|
|
INSERT INTO `table_columns` VALUES ('host',21,'snmp_sysDescr','varchar(300)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',22,'snmp_sysObjectID','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',23,'snmp_sysUpTimeInstance','bigint(20) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',24,'snmp_sysContact','varchar(300)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',25,'snmp_sysName','varchar(300)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',26,'snmp_sysLocation','varchar(300)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',27,'availability_method','smallint(5) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('host',28,'ping_method','smallint(5) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',29,'ping_port','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',30,'ping_timeout','int(10) unsigned','YES','','500','');
|
|
INSERT INTO `table_columns` VALUES ('host',31,'ping_retries','int(10) unsigned','YES','','2','');
|
|
INSERT INTO `table_columns` VALUES ('host',32,'max_oids','int(10) unsigned','YES','','10','');
|
|
INSERT INTO `table_columns` VALUES ('host',33,'bulk_walk_size','int(11)','YES','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('host',34,'device_threads','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('host',35,'deleted','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',36,'disabled','char(2)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('host',37,'status','tinyint(3) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',38,'status_event_count','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',39,'status_fail_date','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('host',40,'status_rec_date','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('host',41,'status_last_error','varchar(255)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',42,'min_time','decimal(10,5)','YES','','9.99999','');
|
|
INSERT INTO `table_columns` VALUES ('host',43,'max_time','decimal(10,5)','YES','','0.00000','');
|
|
INSERT INTO `table_columns` VALUES ('host',44,'cur_time','decimal(10,5)','YES','','0.00000','');
|
|
INSERT INTO `table_columns` VALUES ('host',45,'avg_time','decimal(10,5)','YES','','0.00000','');
|
|
INSERT INTO `table_columns` VALUES ('host',46,'polling_time','double','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',47,'total_polls','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',48,'failed_polls','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',49,'availability','decimal(8,5)','NO','','100.00000','');
|
|
INSERT INTO `table_columns` VALUES ('host',50,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()');
|
|
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_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,'class','varchar(40)','NO','','','');
|
|
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 ('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_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,'timezone','varchar(40)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',7,'hostname','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',8,'dbdefault','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',9,'dbhost','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',10,'dbuser','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',11,'dbpass','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',12,'dbport','int(10) unsigned','YES','','3306','');
|
|
INSERT INTO `table_columns` VALUES ('poller',13,'dbretries','int(10) unsigned','YES','','2','');
|
|
INSERT INTO `table_columns` VALUES ('poller',14,'dbssl','char(3)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',15,'dbsslkey','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',16,'dbsslcert','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',17,'dbsslca','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',18,'total_time','double','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',19,'max_time','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',20,'min_time','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',21,'avg_time','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',22,'total_polls','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',23,'processes','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller',24,'threads','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller',25,'sync_interval','int(10) unsigned','YES','','7200','');
|
|
INSERT INTO `table_columns` VALUES ('poller',26,'snmp','mediumint(8) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',27,'script','mediumint(8) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',28,'server','mediumint(8) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',29,'last_update','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller',30,'last_status','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller',31,'last_sync','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller',32,'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(6)','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,'rrd_name','varchar(19)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',20,'rrd_path','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',21,'rrd_num','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',22,'rrd_step','mediumint(8)','NO','','300','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',23,'rrd_next_step','mediumint(8)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',24,'arg1','text','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',25,'arg2','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',26,'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_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,'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 ('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,'cformat','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',5,'format_file','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',6,'font_size','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',7,'alignment','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',8,'graph_linked','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',9,'intrvl','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',10,'count','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',11,'offset','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',12,'mailtime','bigint(20) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',13,'subject','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',14,'from_name','varchar(40)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',15,'from_email','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',16,'email','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',17,'bcc','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',18,'attachment_type','smallint(2) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('reports',19,'graph_height','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',20,'graph_width','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',21,'graph_columns','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',22,'thumbnails','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',23,'lastsent','bigint(20) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',24,'enabled','char(2)','YES','','','');
|
|
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 ('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','',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','','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(75)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('settings',2,'value','varchar(2048)','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(75)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('settings_user',3,'value','varchar(2048)','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,'address1','varchar(100)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',4,'address2','varchar(100)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',5,'city','varchar(50)','YES','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',6,'state','varchar(20)','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('sites',7,'postal_code','varchar(20)','YES','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',8,'country','varchar(30)','YES','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',9,'timezone','varchar(40)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',10,'latitude','decimal(13,10)','NO','','0.0000000000','');
|
|
INSERT INTO `table_columns` VALUES ('sites',11,'longitude','decimal(13,10)','NO','','0.0000000000','');
|
|
INSERT INTO `table_columns` VALUES ('sites',12,'zoom','tinyint(3) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('sites',13,'alternate_id','varchar(30)','YES','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',14,'notes','varchar(1024)','YES','',NULL,'');
|
|
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_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(6)','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_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_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 ('user_domains',1,'domain_id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('user_domains',2,'domain_name','varchar(20)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains',3,'type','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_domains',4,'enabled','char(2)','NO','','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_domains',5,'defdomain','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_domains',6,'user_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',1,'domain_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',2,'server','varchar(128)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',3,'port','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',4,'port_ssl','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',5,'proto_version','tinyint(3) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',6,'encryption','tinyint(3) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',7,'referrals','tinyint(3) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',8,'mode','tinyint(3) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',9,'dn','varchar(128)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',10,'group_require','char(2)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',11,'group_dn','varchar(128)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',12,'group_attrib','varchar(128)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',13,'group_member_type','tinyint(3) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',14,'search_base','varchar(128)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',15,'search_filter','varchar(512)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',16,'specific_dn','varchar(128)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',17,'specific_password','varchar(128)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',18,'cn_full_name','varchar(50)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('user_domains_ldap',19,'cn_email','varchar(50)','YES','','','');
|
|
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_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(20)','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 = utf8 */;
|
|
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',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_graph_rules',1,'name',1,'name','A',3,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_graph_rules',0,'PRIMARY',1,'id','A',3,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',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_networks',1,'poller_id',1,'poller_id','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_networks',0,'PRIMARY',1,'id','A',1,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',1,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',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_tree_rule_items',0,'PRIMARY',1,'id','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_tree_rules',1,'name',1,'name','A',2,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_tree_rules',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef',1,'hash',1,'hash','A',47,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef',1,'name',1,'name','A',47,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef',0,'PRIMARY',1,'id','A',47,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef_items',1,'cdef_id_sequence',1,'cdef_id','A',104,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef_items',1,'cdef_id_sequence',2,'sequence','A',104,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef_items',0,'PRIMARY',1,'id','A',104,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',444,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('colors',0,'PRIMARY',1,'id','A',444,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',39,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input',1,'name_type_id',2,'type_id','A',39,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input',0,'PRIMARY',1,'id','A',39,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',1,'data_template_data_id',1,'data_template_data_id','A',442,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',0,'PRIMARY',1,'data_input_field_id','A',93,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',0,'PRIMARY',2,'data_template_data_id','A',1771,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',1,'t_value',1,'t_value','A',4,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_fields',1,'data_input_id',1,'data_input_id','A',135,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',135,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',135,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_local',1,'data_template_id',1,'data_template_id','A',5,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',0,'PRIMARY',1,'id','A',5,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',3,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles',0,'PRIMARY',1,'id','A',3,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles_cf',0,'PRIMARY',1,'data_source_profile_id','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles_cf',0,'PRIMARY',2,'consolidation_function_id','A',12,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles_rra',1,'data_source_profile_id',1,'data_source_profile_id','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles_rra',0,'PRIMARY',1,'id','A',12,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_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_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_cache',0,'PRIMARY',1,'local_data_id',NULL,NULL,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',0,'PRIMARY',2,'time',NULL,NULL,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',0,'PRIMARY',3,'rrd_name',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',1,'time',1,'time','A',NULL,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_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_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_template',1,'name',1,'name','A',198,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template',0,'PRIMARY',1,'id','A',198,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',1,'data_input_id',1,'data_input_id','A',101,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',1,'data_template_id',1,'data_template_id','A',203,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',1,'local_data_id',1,'local_data_id','A',12,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',1,'name_cache',1,'name_cache','A',12,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',0,'PRIMARY',1,'id','A',203,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',1,'data_template_id',1,'data_template_id','A',286,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'duplicate_dsname_contraint',1,'local_data_id','A',12,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'duplicate_dsname_contraint',2,'data_source_name','A',286,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'duplicate_dsname_contraint',3,'data_template_id','A',286,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',1,'local_data_template_rrd_id',1,'local_data_template_rrd_id','A',16,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'PRIMARY',1,'id','A',286,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',4,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',4,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',309,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_template_input_defs',0,'PRIMARY',1,'graph_template_input_id','A',698,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_template_input_defs',0,'PRIMARY',2,'graph_template_item_id','A',1397,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates',1,'multiple_name',1,'multiple','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates',1,'multiple_name',2,'name','A',152,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates',1,'name',1,'name','A',152,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates',0,'PRIMARY',1,'id','A',152,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_gprint',1,'name',1,'name','A',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_gprint',0,'PRIMARY',1,'id','A',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_graph',1,'graph_template_id',1,'graph_template_id','A',156,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',156,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_graph',1,'title_cache',1,'title_cache','A',10,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'cdef_id',1,'cdef_id','A',95,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'color_id',1,'color_id','A',218,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'gprint_id',1,'gprint_id','A',16,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'graph_template_id',1,'graph_template_id','A',305,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',382,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',169,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'local_graph_template_item_id',1,'local_graph_template_item_id','A',69,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',0,'PRIMARY',1,'id','A',1529,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'task_item_id',1,'task_item_id','A',764,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',1,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree',0,'PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree',1,'sequence',1,'sequence','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'graph_tree_id',1,'graph_tree_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'host_id',1,'host_id','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'local_graph_id',1,'local_graph_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'parent_position',1,'parent','A',4,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'parent_position',2,'position','A',4,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',0,'PRIMARY',1,'id','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'site_id',1,'site_id','A',2,NULL,NULL,'YES','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,'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_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',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'field_name',1,'field_name','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'field_value',1,'field_value','A',6,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',6,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',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',0,'PRIMARY',4,'snmp_index','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'snmp_index',1,'snmp_index','A',6,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',10,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template',0,'PRIMARY',1,'id','A',10,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_graph',0,'PRIMARY',1,'host_template_id','A',24,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_graph',0,'PRIMARY',2,'graph_template_id','A',96,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_snmp_query',0,'PRIMARY',1,'host_template_id','A',18,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_snmp_query',0,'PRIMARY',2,'snmp_query_id','A',37,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',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_realms',0,'PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller',1,'disabled',1,'disabled','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller',1,'name',1,'name','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller',0,'PRIMARY',1,'id','A',1,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',83,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_data_template_field_mappings',0,'PRIMARY',2,'data_name','A',83,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_data_template_field_mappings',0,'PRIMARY',3,'data_source_names','A',83,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'action',1,'action','A',2,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',2,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',5,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',0,'PRIMARY',2,'rrd_name','A',5,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',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_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_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 ('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,'mailtime',1,'mailtime','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 ('sessions',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('settings',0,'PRIMARY',1,'name','A',32,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',2,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',27,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query',0,'PRIMARY',1,'id','A',27,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'graph_template_id_name',1,'graph_template_id','A',83,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'graph_template_id_name',2,'name','A',83,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',0,'PRIMARY',1,'id','A',83,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'snmp_query_id_name',1,'snmp_query_id','A',83,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'snmp_query_id_name',2,'name','A',83,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',1,'data_template_rrd_id',1,'data_template_rrd_id','A',149,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',0,'PRIMARY',1,'snmp_query_graph_id','A',149,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',0,'PRIMARY',2,'data_template_id','A',149,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',0,'PRIMARY',3,'data_template_rrd_id','A',149,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd_sv',1,'data_template_id',1,'data_template_id','A',13,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd_sv',0,'PRIMARY',1,'id','A',78,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd_sv',1,'snmp_query_graph_id',1,'snmp_query_graph_id','A',39,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_sv',0,'PRIMARY',1,'id','A',67,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_sv',1,'snmp_query_graph_id',1,'snmp_query_graph_id','A',67,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',30,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_realm',0,'PRIMARY',2,'user_id','A',30,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_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 ('user_domains',0,'PRIMARY',1,'domain_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_domains_ldap',0,'PRIMARY',1,'domain_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_log',0,'PRIMARY',1,'username','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_log',0,'PRIMARY',2,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_log',0,'PRIMARY',3,'time','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_log',1,'user_id',1,'user_id','A',0,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 2023-01-28 15:03:03
|