mirror of
https://github.com/Cacti/cacti.git
synced 2026-10-23 03:27:02 +09:00
5403cf75bb
* feature: user-defined filter layouts with administrator publishing
Add a render_layouts toggle to the CactiTableFilter class so list pages
offer Save / New / Rename / Delete controls for saved filter layouts,
modelled on the monitor plugin. Layouts persist to a new user_layouts
table (id, user_id, page, name, url). The toggle defaults on for every
page except the Console > Presets pages (CDEFs, VDEFs, Colors, GPRINTs,
Data Profiles, SNMP), where it is off.
Each user manages their own layouts from any filter. Administrators who
hold the Settings/Utilities realm can publish a layout to all users
(moving it to user_id = 0) from the filter, and from a new
Console > Presets > Filters management page (layouts.php) where they can
view and manage every user's layouts. Published layouts appear for all
users on that page.
Layout create/rename/delete/publish requests are handled centrally by
filter_layouts_handle_request(), invoked from include/auth.php after the
user has been authorized for the current page, so the controls work on any
filter page while publishing stays gated on the realm. layouts.php itself
is mapped to the Settings/Utilities realm so the Presets > Filters menu
pick is administrator-only.
Schema added to cacti.sql, install/upgrades/1_3_0.php, and
docs/audit_schema.sql. Adds tests/Unit/FilterLayoutsTest.php covering the
URL-safety validation, preset-page defaults, and the request/permission
wiring.
* changelog: 8185.feature fragment for filter layouts
* chore: enforce LF line endings via .gitattributes and normalize new files
* fix: address review - attribute-escape layout options, honor failed/non-editable layout ops, regenerate cacti.pot, move test to Unit/Ui/Html
* chore: renormalize pre-existing CRLF files to LF per .gitattributes
* chore: keep vendored JS (big.js, tablesorter) byte-identical to upstream and exclude from LF normalization
* style: apply php-cs-fixer formatting and resolve PHPStan level 8 findings in filter layouts
* ci: re-trigger checks on current head
* refactor: store filter layouts as a versioned JSON document in a TEXT data column
Replace the user_layouts.url varchar(1024) column with a data TEXT column holding a versioned {version,page,filter} document. The navigable url is rebuilt server-side from the document (page basename + rebuilt query) plus the filter_layout marker, removing the stored-url redirect/XSS surface and making the backend forward-compatible with a structured query builder without a further schema change.
* feature: add Modern/Legacy page filter format with an Edit dialog for filters
Modern (default) collapses the filter to a Layouts selector plus an Edit dialog holding the Filter Name and all filter fields; Save and Publish live in the dialog, with Edit/Rename/Delete/Save As on the bar and time controls/refresh kept on the bar. Legacy keeps the classic inline filter. The format is a per-user General setting (page_filter_format). Field rendering is factored into emit_field() so both layouts share one source.
* fix: render page-action buttons (import, export, sort) on the modern filter bar
Import, Export, Purge, Save, and sort ascending/descending are page actions, not filter inputs, so they render on the bar beside the Layouts selector instead of inside the Edit dialog. Only go/clear are dropped from the bar; the dialog keeps the Search/Clear footer.
* feature: render the modern Edit dialog one filter variable per row
The dialog no longer mirrors the inline filter's multi-field row packing; each filter variable renders on its own row (label + control) for a clean, responsive form. Hidden/validate fields stay in the form without an empty visible row. Rows carry a cactiFilterEditRow hook for label-column alignment styling.
* feature: align the modern edit dialog one-per-row and skin it per theme
Render all dialog fields in a single table so the label column aligns via the existing table-cell layout. Tag the dialog widget with cactiFilterDialog and add a scoped skin to the modern theme (slate titlebar, styled button pane, accented primary action). Add a bar separator between layout and page-action buttons.
* feature: skin the modern filter Edit dialog across the classic themes
Add the scoped .cactiFilterDialog skin (accent titlebar, white title/close, styled button pane with an accented primary action) to cacti, carrot, dark, hollyberry, paper-plane, paw, raspberry, and sunrise, each using its own brand accent. The skin is accent-only and inherits each theme's dialog surface, so it works on light and dark themes. MidWinter is intentionally skipped (its variable-based CSS is handled in a separate Epic).
* fix: delete a user's saved filter layouts when the user is removed
user_remove() now deletes the user's own user_layouts rows alongside their other per-user data. Scoped to user_id so published (user_id = 0) layouts remain available to everyone.
* fix: address PR review — PHPStan return type, escaping, callbacks, SQL columns, mb truncation, contrast, POT
- create_filter(): cast both ob_get_clean() returns to string and drop the now-unused PHPStan baseline entry (fixes Level 6 failure).
- Edit dialog title now uses html_escape_attr() (attribute-context double-encoding).
- Modern Search/Clear honor the page's configured go/clear callbacks instead of hardcoding applyFilter()/clearFilter().
- filter_layouts_get() and layouts.php select explicit columns instead of *.
- Layout name truncation uses mb_substr() to avoid cutting multibyte codepoints.
- layouts.php management callback checks result.ok before reloading.
- carrot/paper-plane dialog accents darkened to meet WCAG AA (>=4.5:1) with white text.
- Added the new translatable msgids (Page Filter Format, Filters, Edit Filter, Filter Name, Save As, ...) to cacti.pot.
* fix: resolve Semgrep reflected-xss by reading filter_layout inside layout_select
The request var is no longer passed into layout_select() as a parameter (which Semgrep tracked parameter-to-return to the print sink); it is read internally like create_filter(), and the option markup remains escaped. No behavior change.
---------
Co-authored-by: TheWitness <copilot@users.noreply.github.com>
Co-authored-by: TheWitness <TheWitness@users.noreply.github.com>
1774 lines
181 KiB
SQL
1774 lines
181 KiB
SQL
/*
|
|
+-------------------------------------------------------------------------+
|
|
| Copyright (C) 2004-2026 The Cacti Group |
|
|
| |
|
|
| This program is free software; you can redistribute it and/or |
|
|
| modify it under the terms of the GNU General Public License |
|
|
| as published by the Free Software Foundation; either version 2 |
|
|
| of the License, or (at your option) any later version. |
|
|
| |
|
|
| This program is distributed in the hope that it will be useful, |
|
|
| but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
|
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
|
| GNU General Public License for more details. |
|
|
+-------------------------------------------------------------------------+
|
|
| Cacti: The Complete RRDTool-based Graphing Solution |
|
|
+-------------------------------------------------------------------------+
|
|
| This code is designed, written, and maintained by the Cacti Group. See |
|
|
| about.php and/or the AUTHORS file for specific developer information. |
|
|
+-------------------------------------------------------------------------+
|
|
| http://www.cacti.net/ |
|
|
+-------------------------------------------------------------------------+
|
|
*/
|
|
|
|
/*M!999999\- enable the sandbox mode */
|
|
-- MariaDB dump 10.19 Distrib 10.5.29-MariaDB, for Linux (x86_64)
|
|
--
|
|
-- Host: localhost Database: cacti
|
|
-- ------------------------------------------------------
|
|
-- Server version 10.5.29-MariaDB
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8mb4 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Table structure for table `table_columns`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `table_columns`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `table_columns` (
|
|
`table_name` varchar(50) NOT NULL,
|
|
`table_sequence` int(10) unsigned NOT NULL,
|
|
`table_field` varchar(50) NOT NULL,
|
|
`table_type` varchar(50) DEFAULT NULL,
|
|
`table_null` varchar(10) DEFAULT NULL,
|
|
`table_key` varchar(4) DEFAULT NULL,
|
|
`table_default` varchar(50) DEFAULT NULL,
|
|
`table_extra` varchar(128) DEFAULT NULL,
|
|
PRIMARY KEY (`table_name`,`table_sequence`,`table_field`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Holds Default Cacti Table Definitions';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `table_columns`
|
|
--
|
|
|
|
LOCK TABLES `table_columns` WRITE;
|
|
/*!40000 ALTER TABLE `table_columns` DISABLE KEYS */;
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',2,'name','varchar(64)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',3,'graph_template_id','int(10) unsigned','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',4,'gprint_prefix','varchar(64)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',5,'gprint_format','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',6,'graph_type','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',7,'total','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',8,'total_type','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',9,'total_prefix','varchar(64)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',10,'order_type','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',11,'created','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',12,'user_id','int(10) unsigned','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',13,'graphs','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',1,'aggregate_template_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',2,'t_image_format_id','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',3,'image_format_id','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',4,'t_height','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',5,'height','mediumint(8)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',6,'t_width','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',7,'width','mediumint(8)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',8,'t_upper_limit','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',9,'upper_limit','varchar(20)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',10,'t_lower_limit','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',11,'lower_limit','varchar(20)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',12,'t_vertical_label','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',13,'vertical_label','varchar(200)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',14,'t_slope_mode','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',15,'slope_mode','char(2)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',16,'t_auto_scale','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',17,'auto_scale','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',18,'t_auto_scale_opts','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',19,'auto_scale_opts','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',20,'t_auto_scale_log','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',21,'auto_scale_log','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',22,'t_scale_log_units','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',23,'scale_log_units','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',24,'t_auto_scale_rigid','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',25,'auto_scale_rigid','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',26,'t_auto_padding','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',27,'auto_padding','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',28,'t_base_value','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',29,'base_value','mediumint(8)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',30,'t_grouping','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',31,'grouping','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',32,'t_unit_value','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',33,'unit_value','varchar(20)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',34,'t_unit_exponent_value','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',35,'unit_exponent_value','varchar(5)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',36,'t_alt_y_grid','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',37,'alt_y_grid','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',38,'t_right_axis','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',39,'right_axis','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',40,'t_right_axis_label','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',41,'right_axis_label','varchar(200)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',42,'t_right_axis_format','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',43,'right_axis_format','mediumint(8)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',44,'t_right_axis_formatter','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',45,'right_axis_formatter','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',46,'t_left_axis_format','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',47,'left_axis_format','mediumint(8)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',48,'t_left_axis_formatter','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',49,'left_axis_formatter','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',50,'t_no_gridfit','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',51,'no_gridfit','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',52,'t_unit_length','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',53,'unit_length','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',54,'t_tab_width','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',55,'tab_width','varchar(20)','YES','','30','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',56,'t_dynamic_labels','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',57,'dynamic_labels','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',58,'t_force_rules_legend','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',59,'force_rules_legend','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',60,'t_legend_position','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',61,'legend_position','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',62,'t_legend_direction','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',63,'legend_direction','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',1,'aggregate_template_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',2,'graph_templates_item_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',3,'sequence','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',4,'color_template','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',5,'t_graph_type_id','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',6,'graph_type_id','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',7,'t_cdef_id','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',8,'cdef_id','mediumint(8) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',9,'item_skip','char(2)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',10,'item_total','char(2)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',2,'aggregate_template_id','int(10) unsigned','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',3,'template_propogation','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',4,'local_graph_id','int(10) unsigned','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',5,'title_format','varchar(128)','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',6,'graph_template_id','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',7,'gprint_prefix','varchar(64)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',8,'gprint_format','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',9,'graph_type','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',10,'total','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',11,'total_type','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',12,'total_prefix','varchar(64)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',13,'order_type','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',14,'created','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs',15,'user_id','int(10) unsigned','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',1,'aggregate_graph_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',2,'graph_templates_item_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',3,'sequence','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',4,'color_template','int(10) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',5,'t_graph_type_id','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',6,'graph_type_id','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',7,'t_cdef_id','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',8,'cdef_id','mediumint(8) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',9,'item_skip','char(2)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',10,'item_total','char(2)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',1,'aggregate_graph_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',2,'local_graph_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',3,'sequence','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',1,'id','bigint(20) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',2,'network_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',3,'host_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',4,'hostname','varchar(100)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',5,'ip','varchar(17)','NO','UNI','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',6,'snmp_community','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',7,'snmp_version','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',8,'snmp_port','mediumint(8) unsigned','NO','','161','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',9,'snmp_username','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',10,'snmp_password','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',11,'snmp_auth_protocol','char(6)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',12,'snmp_priv_passphrase','varchar(200)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',13,'snmp_priv_protocol','char(7)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',14,'snmp_context','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',15,'snmp_engine_id','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',16,'sysName','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',17,'sysLocation','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',18,'sysContact','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',19,'sysDescr','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',20,'sysUptime','bigint(20) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',21,'os','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',22,'snmp','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',23,'known','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',24,'up','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_devices',25,'time','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',3,'rule_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',4,'sequence','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',5,'operation','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',6,'field','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',7,'operator','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',8,'pattern','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rules',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rules',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rules',3,'name','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rules',4,'snmp_query_id','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rules',5,'graph_type_id','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_graph_rules',6,'enabled','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_ips',1,'ip_address','varchar(20)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_ips',2,'hostname','varchar(100)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_ips',3,'network_id','int(10) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_ips',4,'pid','int(10) unsigned','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_ips',5,'status','int(10) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_ips',6,'thread','int(10) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',3,'rule_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',4,'rule_type','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',5,'sequence','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',6,'operation','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',7,'field','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',8,'operator','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_match_rule_items',9,'pattern','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',3,'poller_id','int(10) unsigned','YES','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',4,'site_id','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',5,'name','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',6,'subnet_range','varchar(1024)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',7,'ignore_ips','varchar(1024)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',8,'dns_servers','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',9,'enabled','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',10,'notification_enabled','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',11,'notification_email','varchar(255)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',12,'notification_fromname','varchar(32)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',13,'notification_fromemail','varchar(128)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',14,'snmp_id','int(10) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',15,'enable_netbios','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',16,'add_to_cacti','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',17,'same_sysname','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',18,'total_ips','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',19,'up_hosts','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',20,'snmp_hosts','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',21,'ping_method','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',22,'ping_port','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',23,'ping_timeout','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',24,'ping_retries','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',25,'sched_type','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',26,'threads','int(10) unsigned','YES','','2','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',27,'run_limit','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',28,'start_at','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',29,'next_start','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',30,'recur_every','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',31,'day_of_week','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',32,'month','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',33,'day_of_month','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',34,'monthly_week','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',35,'monthly_day','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',36,'last_runtime','double','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',37,'last_started','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',38,'last_status','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_networks',39,'rerun_data_queries','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_processes',1,'pid','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_processes',2,'poller_id','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_processes',3,'network_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_processes',4,'task','varchar(20)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_processes',5,'status','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_processes',6,'command','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_processes',7,'up_hosts','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_processes',8,'snmp_hosts','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_processes',9,'heartbeat','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp',3,'name','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',3,'snmp_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',4,'sequence','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',5,'snmp_version','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',6,'snmp_community','varchar(100)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',7,'snmp_port','mediumint(8) unsigned','NO','','161','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',8,'snmp_timeout','int(10) unsigned','NO','','500','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',9,'snmp_retries','tinyint(3) unsigned','NO','','3','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',10,'max_oids','int(10) unsigned','YES','','10','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',11,'bulk_walk_size','int(11)','YES','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',12,'snmp_username','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',13,'snmp_password','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',14,'snmp_auth_protocol','char(6)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',15,'snmp_priv_passphrase','varchar(200)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',16,'snmp_priv_protocol','char(7)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',17,'snmp_context','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_snmp_items',18,'snmp_engine_id','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',3,'host_template','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',4,'availability_method','int(10) unsigned','YES','','2','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',5,'sysDescr','varchar(255)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',6,'sysName','varchar(255)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',7,'sysOid','varchar(60)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',8,'description_pattern','varchar(128)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',9,'populate_location','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates',10,'sequence','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates_rules',1,'id','int(10) unsigned','NO','MUL',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates_rules',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates_rules',3,'template_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates_rules',4,'rule_type','tinyint(3) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates_rules',5,'rule_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates_rules',6,'sequence','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('automation_templates_rules',7,'exit_rules','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',3,'rule_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',4,'sequence','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',5,'field','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',6,'sort_type','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',7,'propagate_changes','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',8,'search_pattern','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',9,'replace_pattern','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',3,'name','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',4,'tree_id','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',5,'tree_item_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',6,'leaf_type','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',7,'host_grouping_type','smallint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('automation_tree_rules',8,'enabled','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('cdef',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('cdef',2,'hash','varchar(32)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('cdef',3,'system','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('cdef',4,'name','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('cdef',5,'graphs','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('cdef',6,'templates','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('cdef_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('cdef_items',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('cdef_items',3,'cdef_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('cdef_items',4,'sequence','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('cdef_items',5,'type','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('cdef_items',6,'value','varchar(150)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('color_template_items',1,'color_template_item_id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('color_template_items',2,'color_template_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('color_template_items',3,'color_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('color_template_items',4,'sequence','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('color_templates',1,'color_template_id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('color_templates',2,'name','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('color_templates',3,'graphs','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('color_templates',4,'templates','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('colors',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('colors',2,'name','varchar(40)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('colors',3,'hex','varchar(6)','NO','UNI','','');
|
|
INSERT INTO `table_columns` VALUES ('colors',4,'read_only','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('colors',5,'graphs','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('colors',6,'templates','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_debug',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_debug',2,'started','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_debug',3,'done','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_debug',4,'user','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_debug',5,'datasource','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_debug',6,'info','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_debug',7,'issue','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_input',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_input',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_input',3,'name','varchar(200)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('data_input',4,'input_string','varchar(512)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_input',5,'type_id','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input',6,'data_sources','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input',7,'templates','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_data',1,'data_input_field_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_data',2,'data_template_data_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_data',3,'data_template_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_data',4,'local_data_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_data',5,'host_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_data',6,'t_value','char(2)','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_input_data',7,'value','text','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',3,'data_input_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',4,'name','varchar(200)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',5,'data_name','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',6,'input_output','char(3)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',7,'update_rra','char(2)','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',8,'sequence','smallint(5)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',9,'type_code','varchar(40)','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',10,'regexp_match','varchar(200)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_input_fields',11,'allow_nulls','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_local',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_local',2,'data_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_local',3,'host_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_local',4,'snmp_query_id','mediumint(8)','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_local',5,'snmp_index','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('data_local',6,'orphan','tinyint(3) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_local',7,'errored','tinyint(3) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles',3,'name','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles',4,'step','int(10) unsigned','NO','','300','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles',5,'heartbeat','int(10) unsigned','NO','','600','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles',6,'x_files_factor','double','YES','','0.5','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles',7,'default','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles',8,'data_sources','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles',9,'templates','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles_cf',1,'data_source_profile_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles_cf',2,'consolidation_function_id','smallint(5) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',2,'data_source_profile_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',3,'name','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',4,'steps','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',5,'rows','int(10) unsigned','NO','','700','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',6,'timespan','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_action',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_action',2,'name','varchar(128)','NO','UNI','','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_action',3,'local_data_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_action',4,'action','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',2,'name_cache','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',3,'local_data_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',4,'name','varchar(128)','NO','UNI','','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',5,'size','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',6,'last_mod','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',7,'in_cacti','tinyint(3) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',8,'data_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_command_cache',1,'local_data_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_command_cache',2,'stats_command','blob','NO','','\'\'','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',2,'rrd_name','varchar(19)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',3,'cf','tinyint(3) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',4,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',5,'peak','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',6,'p95n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',7,'p90n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',8,'p75n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',9,'p50n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',10,'p25n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',11,'sum','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',12,'stddev','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',13,'lslslope','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',14,'lslint','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',15,'lslcorrel','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',2,'rrd_name','varchar(19)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',3,'cf','tinyint(3) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',4,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',5,'peak','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',2,'rrd_name','varchar(19)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',4,'value','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_last',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_last',2,'rrd_name','varchar(19)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_last',3,'value','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_last',4,'calculated','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',2,'rrd_name','varchar(19)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',3,'cf','tinyint(3) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',4,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',5,'peak','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',6,'p95n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',7,'p90n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',8,'p75n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',9,'p50n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',10,'p25n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',11,'sum','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',12,'stddev','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',13,'lslslope','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',14,'lslint','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_monthly',15,'lslcorrel','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',2,'rrd_name','varchar(19)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',3,'cf','tinyint(3) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',4,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',5,'peak','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',6,'p95n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',7,'p90n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',8,'p75n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',9,'p50n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',10,'p25n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',11,'sum','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',12,'stddev','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',13,'lslslope','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',14,'lslint','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_weekly',15,'lslcorrel','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',1,'local_data_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',2,'rrd_name','varchar(19)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',3,'cf','tinyint(3) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',4,'average','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',5,'peak','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',6,'p95n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',7,'p90n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',8,'p75n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',9,'p50n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',10,'p25n','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',11,'sum','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',12,'stddev','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',13,'lslslope','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',14,'lslint','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_source_stats_yearly',15,'lslcorrel','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_template',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_template',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template',3,'name','varchar(150)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template',4,'data_sources','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template',5,'templates','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template',6,'last_updated','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',2,'local_data_template_data_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',3,'local_data_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',4,'data_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',5,'data_input_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',6,'t_name','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',7,'name','varchar(250)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',8,'name_cache','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',9,'data_source_path','varchar(255)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',10,'t_active','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',11,'active','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',12,'t_rrd_step','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',13,'rrd_step','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',14,'t_data_source_profile_id','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_data',15,'data_source_profile_id','mediumint(8) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',3,'local_data_template_rrd_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',4,'local_data_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',5,'data_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',6,'t_rrd_maximum','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',7,'rrd_maximum','varchar(20)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',8,'t_rrd_minimum','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',9,'rrd_minimum','varchar(20)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',10,'t_rrd_heartbeat','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',11,'rrd_heartbeat','mediumint(6)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',12,'t_data_source_type_id','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',13,'data_source_type_id','smallint(5)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',14,'t_data_source_name','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',15,'data_source_name','varchar(19)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',16,'t_data_input_field_id','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('data_template_rrd',17,'data_input_field_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('external_links',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('external_links',2,'sortorder','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('external_links',3,'enabled','char(2)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('external_links',4,'contentfile','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('external_links',5,'title','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('external_links',6,'style','varchar(10)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('external_links',7,'extendedstyle','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('external_links',8,'refresh','int(10) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_local',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('graph_local',2,'graph_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_local',3,'host_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_local',4,'snmp_query_id','mediumint(8)','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_local',5,'snmp_query_graph_id','mediumint(8)','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_local',6,'snmp_index','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_template_input',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('graph_template_input',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_template_input',3,'graph_template_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_template_input',4,'name','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_template_input',5,'description','text','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_template_input',6,'column_name','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_template_input_defs',1,'graph_template_input_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_template_input_defs',2,'graph_template_item_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',2,'hash','char(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',3,'name','char(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',4,'class','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',5,'version','varchar(10)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',6,'multiple','char(2)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',7,'test_source','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',8,'graphs','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates',9,'last_updated','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',3,'name','varchar(100)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',4,'gprint_text','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',5,'graphs','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',6,'templates','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',2,'local_graph_template_graph_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',3,'local_graph_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',4,'graph_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',5,'t_image_format_id','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',6,'image_format_id','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',7,'t_title','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',8,'title','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',9,'title_cache','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',10,'t_height','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',11,'height','mediumint(8)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',12,'t_width','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',13,'width','mediumint(8)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',14,'t_upper_limit','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',15,'upper_limit','varchar(20)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',16,'t_lower_limit','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',17,'lower_limit','varchar(20)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',18,'t_vertical_label','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',19,'vertical_label','varchar(200)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',20,'t_slope_mode','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',21,'slope_mode','char(2)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',22,'t_auto_scale','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',23,'auto_scale','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',24,'t_auto_scale_opts','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',25,'auto_scale_opts','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',26,'t_auto_scale_log','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',27,'auto_scale_log','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',28,'t_scale_log_units','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',29,'scale_log_units','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',30,'t_auto_scale_rigid','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',31,'auto_scale_rigid','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',32,'t_auto_padding','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',33,'auto_padding','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',34,'t_base_value','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',35,'base_value','mediumint(8)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',36,'t_grouping','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',37,'grouping','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',38,'t_unit_value','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',39,'unit_value','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',40,'t_unit_exponent_value','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',41,'unit_exponent_value','varchar(5)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',42,'t_alt_y_grid','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',43,'alt_y_grid','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',44,'t_right_axis','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',45,'right_axis','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',46,'t_right_axis_label','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',47,'right_axis_label','varchar(200)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',48,'t_right_axis_format','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',49,'right_axis_format','mediumint(8)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',50,'t_right_axis_formatter','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',51,'right_axis_formatter','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',52,'t_left_axis_format','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',53,'left_axis_format','mediumint(8)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',54,'t_left_axis_formatter','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',55,'left_axis_formatter','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',56,'t_no_gridfit','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',57,'no_gridfit','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',58,'t_unit_length','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',59,'unit_length','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',60,'t_tab_width','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',61,'tab_width','varchar(20)','YES','','30','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',62,'t_dynamic_labels','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',63,'dynamic_labels','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',64,'t_force_rules_legend','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',65,'force_rules_legend','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',66,'t_legend_position','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',67,'legend_position','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',68,'t_legend_direction','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_graph',69,'legend_direction','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',3,'local_graph_template_item_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',4,'local_graph_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',5,'graph_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',6,'task_item_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',7,'color_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',8,'alpha','char(2)','YES','','FF','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',9,'color2_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',10,'alpha2','char(2)','YES','','FF','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',11,'gradheight','tinyint(4)','NO','','50','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',12,'graph_type_id','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',13,'line_width','decimal(4,2)','YES','','0.00','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',14,'dashes','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',15,'dash_offset','mediumint(4)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',16,'cdef_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',17,'vdef_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',18,'shift','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',19,'consolidation_function_id','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',20,'textalign','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',21,'text_format','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',22,'legend','varchar(30)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',23,'value','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',24,'hard_return','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',25,'gprint_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_templates_item',26,'sequence','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',1,'id','smallint(5) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',2,'enabled','char(2)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',3,'locked','tinyint(3) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',4,'locked_date','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',5,'sort_type','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',6,'name','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',7,'sequence','int(10) unsigned','YES','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',8,'user_id','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',9,'last_modified','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree',10,'modified_by','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',1,'id','bigint(20) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',2,'parent','bigint(20) unsigned','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',3,'position','int(10) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',4,'graph_tree_id','smallint(5) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',5,'local_graph_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',6,'title','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',7,'host_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',8,'site_id','int(10) unsigned','YES','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',9,'host_grouping_type','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',10,'sort_children_type','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',11,'graph_regex','varchar(60)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('graph_tree_items',12,'host_regex','varchar(60)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('host',2,'poller_id','int(10) unsigned','NO','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('host',3,'site_id','int(10) unsigned','NO','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('host',4,'host_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',5,'description','varchar(150)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',6,'hostname','varchar(100)','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',7,'location','varchar(40)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',8,'notes','text','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',9,'external_id','varchar(40)','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',10,'snmp_options','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',11,'snmp_community','varchar(100)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',12,'snmp_version','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('host',13,'snmp_username','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',14,'snmp_password','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host',15,'snmp_auth_protocol','char(6)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',16,'snmp_priv_passphrase','varchar(200)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',17,'snmp_priv_protocol','char(7)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',18,'snmp_context','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',19,'snmp_engine_id','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',20,'snmp_port','mediumint(8) unsigned','NO','','161','');
|
|
INSERT INTO `table_columns` VALUES ('host',21,'snmp_timeout','mediumint(8) unsigned','NO','','500','');
|
|
INSERT INTO `table_columns` VALUES ('host',22,'snmp_retries','tinyint(3) unsigned','NO','','3','');
|
|
INSERT INTO `table_columns` VALUES ('host',23,'snmp_sysDescr','varchar(300)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',24,'snmp_sysObjectID','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',25,'snmp_sysUpTimeInstance','bigint(20) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',26,'snmp_sysContact','varchar(300)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',27,'snmp_sysName','varchar(300)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',28,'snmp_sysLocation','varchar(300)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',29,'availability_method','smallint(5) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('host',30,'ping_method','smallint(5) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',31,'ping_port','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',32,'ping_timeout','int(10) unsigned','YES','','500','');
|
|
INSERT INTO `table_columns` VALUES ('host',33,'ping_retries','int(10) unsigned','YES','','2','');
|
|
INSERT INTO `table_columns` VALUES ('host',34,'max_oids','int(10) unsigned','YES','','10','');
|
|
INSERT INTO `table_columns` VALUES ('host',35,'bulk_walk_size','int(11)','YES','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('host',36,'device_threads','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('host',37,'deleted','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',38,'disabled','char(2)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('host',39,'graphs','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',40,'data_sources','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',41,'status','tinyint(3) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',42,'status_event_count','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',43,'status_fail_date','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('host',44,'status_rec_date','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('host',45,'status_options_date','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('host',46,'status_last_error','varchar(255)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('host',47,'min_time','decimal(10,5)','YES','','9.99999','');
|
|
INSERT INTO `table_columns` VALUES ('host',48,'max_time','decimal(10,5)','YES','','0.00000','');
|
|
INSERT INTO `table_columns` VALUES ('host',49,'cur_time','decimal(10,5)','YES','','0.00000','');
|
|
INSERT INTO `table_columns` VALUES ('host',50,'avg_time','decimal(10,5)','YES','','0.00000','');
|
|
INSERT INTO `table_columns` VALUES ('host',51,'polling_time','double','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',52,'current_errors','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',53,'total_polls','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',54,'failed_polls','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host',55,'availability','decimal(8,5)','NO','','100.00000','');
|
|
INSERT INTO `table_columns` VALUES ('host',56,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()');
|
|
INSERT INTO `table_columns` VALUES ('host',57,'created','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('host_errors',1,'host_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_errors',2,'poller_id','int(10) unsigned','NO','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('host_errors',3,'errors','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_errors',4,'local_data_ids','text','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host_graph',1,'host_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_graph',2,'graph_template_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_cache',1,'host_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_cache',2,'snmp_query_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_cache',3,'field_name','varchar(50)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_cache',4,'field_value','varchar(512)','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_cache',5,'snmp_index','varchar(255)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_cache',6,'oid','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_cache',7,'present','tinyint(3) unsigned','NO','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_cache',8,'last_updated','timestamp','NO','MUL','current_timestamp()','on update current_timestamp()');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_query',1,'host_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_query',2,'snmp_query_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_query',3,'sort_field','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_query',4,'title_format','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_query',5,'reindex_method','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_query',6,'reindex_last_runtime','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('host_snmp_query',7,'reindex_last_duration','double unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('host_template',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',3,'name','varchar(100)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',4,'version','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',5,'class','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',6,'tags','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',7,'author','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',8,'email','varchar(60)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',9,'homepage','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',10,'copyright','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',11,'installation','varchar(1024)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template',12,'devices','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',2,'host_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',3,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',4,'name','varchar(100)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',5,'version','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',6,'class','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',7,'tags','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',8,'author','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',9,'email','varchar(60)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',10,'homepage','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',11,'copyright','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',12,'installation','varchar(1024)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',13,'archive_note','varchar(256)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',14,'archive_date','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',15,'archive_md5sum','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_archive',16,'archive','longblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('host_template_graph',1,'host_template_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_graph',2,'graph_template_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_snmp_query',1,'host_template_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_template_snmp_query',2,'snmp_query_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_value_cache',1,'host_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('host_value_cache',2,'dimension','varchar(40)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('host_value_cache',3,'value','varchar(8192)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('host_value_cache',4,'time_to_live','int(11)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('host_value_cache',5,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()');
|
|
INSERT INTO `table_columns` VALUES ('package_public_keys',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('package_public_keys',2,'md5sum','varchar(32)','NO','UNI','','');
|
|
INSERT INTO `table_columns` VALUES ('package_public_keys',3,'author','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('package_public_keys',4,'homepage','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('package_public_keys',5,'email_address','varchar(60)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('package_public_keys',6,'public_key','varchar(1024)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('package_repositories',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('package_repositories',2,'name','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('package_repositories',3,'enabled','char(2)','NO','','on','');
|
|
INSERT INTO `table_columns` VALUES ('package_repositories',4,'default','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('package_repositories',5,'repo_type','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('package_repositories',6,'repo_location','varchar(128)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('package_repositories',7,'repo_branch','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('package_repositories',8,'repo_api_key','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',2,'plugin','varchar(32)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',3,'description','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',4,'author','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',5,'webpage','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',6,'user_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',7,'version','varchar(10)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',8,'requires','varchar(128)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',9,'compat','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',10,'dir_md5sum','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',11,'last_updated','timestamp','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',12,'archive_note','varchar(256)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_archive',13,'archive','longblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',1,'plugin','varchar(32)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',2,'description','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',3,'author','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',4,'webpage','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',5,'tag_name','varchar(20)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',6,'published_at','timestamp','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',7,'compat','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',8,'requires','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',9,'body','blob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',10,'info','blob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',11,'readme','blob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',12,'changelog','blob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',13,'archive','longblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_available',14,'last_updated','timestamp','YES','','current_timestamp()','on update current_timestamp()');
|
|
INSERT INTO `table_columns` VALUES ('plugin_config',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('plugin_config',2,'directory','varchar(32)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_config',3,'name','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_config',4,'status','tinyint(3) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_config',5,'author','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_config',6,'webpage','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_config',7,'version','varchar(10)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_config',8,'last_updated','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_db_changes',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('plugin_db_changes',2,'plugin','varchar(16)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_db_changes',3,'table','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_db_changes',4,'column','varchar(64)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_db_changes',5,'method','varchar(16)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_hooks',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('plugin_hooks',2,'name','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_hooks',3,'hook','varchar(64)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_hooks',4,'file','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_hooks',5,'function','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_hooks',6,'status','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_realms',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('plugin_realms',2,'plugin','varchar(32)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('plugin_realms',3,'file','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('plugin_realms',4,'display','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',1,'id','smallint(5) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('poller',2,'disabled','char(2)','YES','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',3,'name','varchar(30)','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',4,'notes','varchar(1024)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',5,'status','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',6,'log_level','int(10)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('poller',7,'timezone','varchar(40)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',8,'hostname','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',9,'dbdefault','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',10,'dbhost','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',11,'dbuser','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',12,'dbpass','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',13,'dbport','int(10) unsigned','YES','','3306','');
|
|
INSERT INTO `table_columns` VALUES ('poller',14,'dbretries','int(10) unsigned','YES','','2','');
|
|
INSERT INTO `table_columns` VALUES ('poller',15,'dbssl','char(3)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller',16,'dbsslkey','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',17,'dbsslcert','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',18,'dbsslca','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',19,'dbsslcapath','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',20,'dbsslverifyservercert','char(3)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('poller',21,'total_time','double','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',22,'max_time','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',23,'min_time','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',24,'avg_time','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller',25,'total_polls','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',26,'processes','int(10) unsigned','YES','','2','');
|
|
INSERT INTO `table_columns` VALUES ('poller',27,'threads','int(10) unsigned','YES','','2','');
|
|
INSERT INTO `table_columns` VALUES ('poller',28,'sync_interval','int(10) unsigned','YES','','7200','');
|
|
INSERT INTO `table_columns` VALUES ('poller',29,'devices','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',30,'snmp','mediumint(8) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',31,'script','mediumint(8) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',32,'server','mediumint(8) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller',33,'last_update','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller',34,'last_status','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller',35,'last_sync','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller',36,'requires_sync','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_command',1,'poller_id','smallint(5) unsigned','NO','PRI','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller_command',2,'time','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller_command',3,'action','tinyint(3) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_command',4,'command','varchar(191)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_command',5,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()');
|
|
INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',1,'data_template_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',2,'data_name','varchar(40)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',3,'data_source_names','varchar(125)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',4,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',1,'local_data_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',2,'poller_id','int(10) unsigned','NO','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',3,'host_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',4,'action','tinyint(3) unsigned','NO','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',5,'present','tinyint(3) unsigned','NO','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',6,'last_updated','timestamp','NO','','current_timestamp()','on update current_timestamp()');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',7,'hostname','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',8,'snmp_community','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',9,'snmp_version','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',10,'snmp_username','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',11,'snmp_password','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',12,'snmp_auth_protocol','char(6)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',13,'snmp_priv_passphrase','varchar(200)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',14,'snmp_priv_protocol','char(7)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',15,'snmp_context','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',16,'snmp_engine_id','varchar(64)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',17,'snmp_port','mediumint(8) unsigned','NO','','161','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',18,'snmp_timeout','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',19,'snmp_retries','tinyint(3) unsigned','NO','','3','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',20,'rrd_name','varchar(19)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',21,'rrd_path','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',22,'rrd_num','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',23,'rrd_step','mediumint(8)','NO','','300','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',24,'rrd_next_step','mediumint(8)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',25,'arg1','text','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',26,'arg2','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_item',27,'arg3','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_output',1,'local_data_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output',2,'rrd_name','varchar(19)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output',4,'output','varchar(512)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost',1,'local_data_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost',2,'rrd_name','varchar(19)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost',4,'output','varchar(512)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost',5,'last_updated','timestamp','NO','MUL','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost_local_data_ids',1,'local_data_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost_local_data_ids',2,'process_handler','int(10) unsigned','YES','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',1,'sock_int_value','bigint(20) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',2,'run_id','char(32)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',3,'child_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',4,'status','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_realtime',1,'local_data_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_realtime',2,'rrd_name','varchar(19)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_realtime',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_realtime',4,'output','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_output_realtime',5,'poller_id','varchar(256)','NO','PRI','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller_reindex',1,'host_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_reindex',2,'data_query_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_reindex',3,'action','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_reindex',4,'present','tinyint(3) unsigned','NO','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller_reindex',5,'op','char(1)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_reindex',6,'assert_value','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_reindex',7,'arg1','varchar(255)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('poller_resource_cache',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('poller_resource_cache',2,'resource_type','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_resource_cache',3,'md5sum','varchar(32)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_resource_cache',4,'path','varchar(191)','YES','UNI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_resource_cache',5,'update_time','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller_resource_cache',6,'contents','longblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_resource_cache',7,'attributes','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_time',1,'id','bigint(20) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('poller_time',2,'pid','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('poller_time',3,'poller_id','int(10) unsigned','NO','MUL','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller_time',4,'start_time','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller_time',5,'end_time','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('poller_time_stats',1,'id','bigint(20) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('poller_time_stats',2,'poller_id','int(10) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('poller_time_stats',3,'total_time','double','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('poller_time_stats',4,'time','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('processes',1,'id','bigint(20) unsigned','NO','MUL',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('processes',2,'pid','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('processes',3,'tasktype','varchar(20)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('processes',4,'taskname','varchar(40)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('processes',5,'taskid','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('processes',6,'timeout','int(10) unsigned','YES','','300','');
|
|
INSERT INTO `table_columns` VALUES ('processes',7,'started','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('processes',8,'last_update','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('reports',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('reports',2,'user_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',3,'name','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',4,'enabled','char(2)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',5,'sched_type','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',6,'run_limit','int(10) unsigned','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',7,'start_at','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',8,'next_start','timestamp','NO','MUL','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('reports',9,'recur_every','int(10) unsigned','YES','','1','');
|
|
INSERT INTO `table_columns` VALUES ('reports',10,'day_of_week','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',11,'month','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',12,'day_of_month','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',13,'monthly_week','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',14,'monthly_day','varchar(45)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',15,'last_runtime','double','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',16,'last_started','timestamp','NO','MUL','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('reports',17,'last_status','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',18,'cformat','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',19,'format_file','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',20,'font_size','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',21,'alignment','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',22,'graph_linked','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',23,'subject','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports',24,'from_name','varchar(40)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',25,'from_email','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',26,'email','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',27,'bcc','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports',28,'notify_list','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',29,'attachment_type','smallint(2) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('reports',30,'graph_height','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',31,'graph_width','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',32,'graph_columns','smallint(2) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports',33,'thumbnails','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',2,'report_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',3,'item_type','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',4,'tree_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',5,'branch_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',6,'tree_cascade','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',7,'graph_name_regexp','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',8,'site_id','int(11)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',9,'host_template_id','int(11)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',10,'host_id','int(11)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',11,'graph_template_id','int(11)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',12,'local_graph_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',13,'timespan','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',14,'align','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',15,'item_text','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',16,'font_size','smallint(2) unsigned','NO','','10','');
|
|
INSERT INTO `table_columns` VALUES ('reports_items',17,'sequence','smallint(5) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',2,'name','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',3,'source','varchar(20)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',4,'source_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',5,'report_output_type','varchar(5)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',6,'report_raw_data','longblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',7,'report_raw_output','longblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',8,'report_txt_output','longblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',9,'report_html_output','longblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',10,'report_attachments','longblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',11,'notification','blob','NO','','\'\'','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',12,'send_type','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',13,'send_time','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',14,'run_time','double','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',15,'sent_by','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_log',16,'sent_id','int(11)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',2,'name','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',3,'source','varchar(20)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',4,'source_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',5,'status','varchar(10)','NO','','pending','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',6,'scheduled_time','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',7,'start_time','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',8,'run_command','varchar(512)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',9,'run_timeout','int(11)','NO','','60','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',10,'notification','blob','NO','','\'\'','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',11,'request_type','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',12,'requested_by','varchar(20)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('reports_queued',13,'requested_id','int(11)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('rrdcheck',1,'local_data_id','mediumint(8) unsigned','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('rrdcheck',2,'test_date','timestamp','NO','','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('rrdcheck',3,'message','varchar(250)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('sessions',1,'id','varchar(32)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('sessions',2,'remote_addr','varchar(25)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('sessions',3,'access','int(10) unsigned','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('sessions',4,'data','mediumblob','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('sessions',5,'user_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('sessions',6,'user_agent','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('sessions',7,'start_time','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('sessions',8,'transactions','int(10) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('settings',1,'name','varchar(255)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('settings',2,'value','varchar(4096)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('settings_tree',1,'user_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('settings_tree',2,'graph_tree_item_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('settings_tree',3,'status','tinyint(4)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('settings_user',1,'user_id','smallint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('settings_user',2,'name','varchar(255)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('settings_user',3,'value','varchar(4096)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('settings_user_group',1,'group_id','smallint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('settings_user_group',2,'name','varchar(50)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('settings_user_group',3,'value','varchar(2048)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('sites',2,'name','varchar(100)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',3,'disabled','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',4,'address1','varchar(100)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',5,'address2','varchar(100)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',6,'city','varchar(50)','YES','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',7,'state','varchar(20)','YES','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('sites',8,'postal_code','varchar(20)','YES','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',9,'country','varchar(30)','YES','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',10,'region','varchar(30)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',11,'timezone','varchar(40)','YES','','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',12,'latitude','decimal(13,10)','NO','','0.0000000000','');
|
|
INSERT INTO `table_columns` VALUES ('sites',13,'longitude','decimal(13,10)','NO','','0.0000000000','');
|
|
INSERT INTO `table_columns` VALUES ('sites',14,'zoom','tinyint(3) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('sites',15,'alternate_id','varchar(30)','YES','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('sites',16,'notes','varchar(1024)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('sites',17,'devices','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',3,'xml_path','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',4,'name','varchar(100)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',5,'description','varchar(255)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',6,'graph_template_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',7,'data_input_id','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',8,'graphs','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',9,'templates','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query',10,'last_updated','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph',3,'snmp_query_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph',4,'name','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph',5,'graph_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd',1,'snmp_query_graph_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd',2,'data_template_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd',3,'data_template_rrd_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd',4,'snmp_field_name','varchar(50)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',3,'snmp_query_graph_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',4,'data_template_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',5,'sequence','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',6,'field_name','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_rrd_sv',7,'text','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',3,'snmp_query_graph_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',4,'sequence','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',5,'field_name','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmp_query_graph_sv',6,'text','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache',1,'oid','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache',2,'name','varchar(50)','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache',3,'mib','varchar(50)','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache',4,'type','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache',5,'otype','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache',6,'kind','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache',7,'max-access','varchar(50)','NO','','not-accessible','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache',8,'value','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache',9,'description','varchar(5000)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',1,'name','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',2,'mib','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',3,'attribute','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',4,'sequence_id','smallint(6)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',1,'name','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',2,'mib','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',3,'type','varchar(50)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',4,'description','varchar(5000)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',2,'hostname','varchar(100)','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',3,'description','varchar(255)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',4,'disabled','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',5,'max_log_size','tinyint(4)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',6,'snmp_version','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',7,'snmp_community','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',8,'snmp_username','varchar(50)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',9,'snmp_password','varchar(50)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',10,'snmp_auth_protocol','char(6)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',11,'snmp_priv_passphrase','varchar(200)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',12,'snmp_priv_protocol','char(7)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',13,'snmp_engine_id','varchar(64)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',14,'snmp_port','mediumint(8) unsigned','NO','','161','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',15,'snmp_message_type','tinyint(4)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers',16,'notes','text','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',1,'manager_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',2,'notification','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',3,'mib','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_mibs',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_mibs',2,'name','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_mibs',3,'file','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',2,'time','int(24)','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',3,'severity','tinyint(4)','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',4,'manager_id','int(10) unsigned','NO','MUL',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',5,'notification','varchar(190)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',6,'mib','varchar(50)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',7,'varbinds','varchar(5000)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_columns',1,'table_name','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_columns',2,'table_sequence','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_columns',3,'table_field','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_columns',4,'table_type','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_columns',5,'table_null','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_columns',6,'table_key','varchar(4)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_columns',7,'table_default','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_columns',8,'table_extra','varchar(128)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',1,'idx_table_name','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',2,'idx_non_unique','int(10) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',3,'idx_key_name','varchar(128)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',4,'idx_seq_in_index','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',5,'idx_column_name','varchar(50)','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',6,'idx_collation','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',7,'idx_cardinality','int(10) unsigned','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',8,'idx_sub_part','varchar(50)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',9,'idx_packed','varchar(128)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',10,'idx_null','varchar(10)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',11,'idx_index_type','varchar(20)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('table_indexes',12,'idx_comment','varchar(128)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',2,'username','varchar(50)','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',3,'password','varchar(256)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',4,'realm','mediumint(8)','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',5,'full_name','varchar(100)','YES','','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',6,'email_address','varchar(128)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',7,'must_change_password','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',8,'password_change','char(2)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',9,'show_tree','char(2)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',10,'show_list','char(2)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',11,'show_preview','char(2)','NO','','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',12,'graph_settings','char(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',13,'login_opts','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',14,'policy_graphs','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',15,'policy_trees','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',16,'policy_hosts','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',17,'policy_graph_templates','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',18,'enabled','char(2)','NO','MUL','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',19,'lastchange','int(11)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',20,'lastlogin','int(11)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',21,'password_history','varchar(4096)','NO','','-1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',22,'locked','varchar(3)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',23,'failed_attempts','int(5)','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',24,'lastfail','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',25,'reset_perms','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',26,'tfa_enabled','char(3)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth',27,'tfa_secret','char(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_cache',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_cache',2,'user_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_cache',3,'hostname','varchar(100)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_cache',4,'last_update','timestamp','NO','MUL','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_cache',5,'token','varchar(191)','NO','UNI','','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',2,'name','varchar(20)','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',3,'description','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',4,'graph_settings','varchar(2)','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',5,'login_opts','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',6,'show_tree','varchar(2)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',7,'show_list','varchar(2)','YES','','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',8,'show_preview','varchar(2)','NO','','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',9,'policy_graphs','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',10,'policy_trees','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',11,'policy_hosts','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',12,'policy_graph_templates','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group',13,'enabled','char(2)','NO','','on','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group_members',1,'group_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group_members',2,'user_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group_perms',1,'group_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group_perms',2,'item_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group_perms',3,'type','tinyint(3) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group_realm',1,'group_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_group_realm',2,'realm_id','int(10) unsigned','NO','PRI',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_perms',1,'user_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_perms',2,'item_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_perms',3,'type','tinyint(3) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_realm',1,'realm_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_realm',2,'user_id','mediumint(8) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_reset_hashes',1,'user_id','int(10) unsigned','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_reset_hashes',2,'hash','varchar(100)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_reset_hashes',3,'expiry','timestamp','NO','PRI','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_row_cache',1,'user_id','mediumint(8)','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_row_cache',2,'class','varchar(20)','NO','PRI','','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_row_cache',3,'hash','varchar(32)','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_row_cache',4,'total_rows','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_auth_row_cache',5,'time','timestamp','NO','','current_timestamp()','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',2,'name','varchar(64)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',3,'description','varchar(255)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',4,'type','tinyint(3) unsigned','NO','','1','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',5,'button_label','varchar(50)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',6,'enabled','char(2)','NO','','on','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',7,'debug','char(2)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',8,'is_default','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',9,'allow_auth_cookies','char(2)','NO','','on','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',10,'user_id','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('login_providers',11,'parameters','longtext','YES','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_layouts',1,'id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('user_layouts',2,'user_id','int(10) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_layouts',3,'page','varchar(64)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('user_layouts',4,'name','varchar(128)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('user_layouts',5,'data','text','NO','',NULL,'');
|
|
INSERT INTO `table_columns` VALUES ('user_log',1,'username','varchar(50)','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_log',2,'user_id','mediumint(8)','NO','PRI','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_log',3,'time','timestamp','NO','PRI','0000-00-00 00:00:00','');
|
|
INSERT INTO `table_columns` VALUES ('user_log',4,'result','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('user_log',5,'ip','varchar(40)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('vdef',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('vdef',2,'hash','varchar(32)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('vdef',3,'name','varchar(255)','NO','MUL','','');
|
|
INSERT INTO `table_columns` VALUES ('vdef',4,'graphs','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('vdef',5,'templates','int(10) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('vdef_items',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
|
|
INSERT INTO `table_columns` VALUES ('vdef_items',2,'hash','varchar(32)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('vdef_items',3,'vdef_id','mediumint(8) unsigned','NO','MUL','0','');
|
|
INSERT INTO `table_columns` VALUES ('vdef_items',4,'sequence','mediumint(8) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('vdef_items',5,'type','tinyint(3) unsigned','NO','','0','');
|
|
INSERT INTO `table_columns` VALUES ('vdef_items',6,'value','varchar(150)','NO','','','');
|
|
INSERT INTO `table_columns` VALUES ('version',1,'cacti','char(30)','NO','PRI','','');
|
|
/*!40000 ALTER TABLE `table_columns` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `table_indexes`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `table_indexes`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `table_indexes` (
|
|
`idx_table_name` varchar(50) NOT NULL,
|
|
`idx_non_unique` int(10) unsigned DEFAULT NULL,
|
|
`idx_key_name` varchar(128) NOT NULL,
|
|
`idx_seq_in_index` int(10) unsigned NOT NULL,
|
|
`idx_column_name` varchar(50) NOT NULL,
|
|
`idx_collation` varchar(10) DEFAULT NULL,
|
|
`idx_cardinality` int(10) unsigned DEFAULT NULL,
|
|
`idx_sub_part` varchar(50) DEFAULT NULL,
|
|
`idx_packed` varchar(128) DEFAULT NULL,
|
|
`idx_null` varchar(10) DEFAULT NULL,
|
|
`idx_index_type` varchar(20) DEFAULT NULL,
|
|
`idx_comment` varchar(128) DEFAULT NULL,
|
|
PRIMARY KEY (`idx_table_name`,`idx_key_name`,`idx_seq_in_index`,`idx_column_name`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Holds Default Cacti Index Definitions';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `table_indexes`
|
|
--
|
|
|
|
LOCK TABLES `table_indexes` WRITE;
|
|
/*!40000 ALTER TABLE `table_indexes` DISABLE KEYS */;
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates',1,'graph_template_id',1,'graph_template_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates_graph',0,'PRIMARY',1,'aggregate_template_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates_item',0,'PRIMARY',1,'aggregate_template_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graph_templates_item',0,'PRIMARY',2,'graph_templates_item_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graphs',1,'aggregate_template_id',1,'aggregate_template_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graphs',1,'local_graph_id',1,'local_graph_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graphs',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graphs',1,'title_format',1,'title_format','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graphs',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graphs_graph_item',0,'PRIMARY',1,'aggregate_graph_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graphs_graph_item',0,'PRIMARY',2,'graph_templates_item_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graphs_items',0,'PRIMARY',1,'aggregate_graph_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('aggregate_graphs_items',0,'PRIMARY',2,'local_graph_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_devices',1,'hostname',1,'hostname','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_devices',0,'ip',1,'ip','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_devices',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_graph_rule_items',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_graph_rules',1,'name',1,'name','A',0,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_graph_rules',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_ips',1,'pid',1,'pid',NULL,0,NULL,NULL,'YES','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_ips',0,'PRIMARY',1,'ip_address',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_match_rule_items',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_networks',1,'poller_id',1,'poller_id','A',0,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_networks',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_processes',0,'PRIMARY',1,'pid',NULL,NULL,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_processes',0,'PRIMARY',2,'network_id',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_snmp',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_snmp_items',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_snmp_items',0,'PRIMARY',2,'snmp_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_templates',0,'PRIMARY',1,'id','A',3,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_templates_rules',1,'id',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_templates_rules',0,'PRIMARY',1,'template_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_templates_rules',0,'PRIMARY',2,'rule_type','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_templates_rules',0,'PRIMARY',3,'rule_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_tree_rule_items',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_tree_rules',1,'name',1,'name','A',0,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('automation_tree_rules',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef',1,'hash',1,'hash','A',62,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef',1,'name',1,'name','A',62,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef',0,'PRIMARY',1,'id','A',62,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef_items',1,'cdef_id_sequence',1,'cdef_id','A',160,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef_items',1,'cdef_id_sequence',2,'sequence','A',160,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('cdef_items',0,'PRIMARY',1,'id','A',160,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('color_template_items',0,'PRIMARY',1,'color_template_item_id','A',44,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('color_templates',0,'PRIMARY',1,'color_template_id','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('colors',0,'hex',1,'hex','A',464,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('colors',0,'PRIMARY',1,'id','A',464,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_debug',1,'datasource',1,'datasource','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_debug',1,'done',1,'done','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_debug',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_debug',1,'started',1,'started','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_debug',1,'user',1,'user','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input',1,'name_type_id',1,'name','A',47,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input',1,'name_type_id',2,'type_id','A',47,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input',0,'PRIMARY',1,'id','A',47,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',1,'data_template_data_id',1,'data_template_data_id','A',797,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',1,'data_template_id',1,'data_template_id','A',797,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',1,'host_id',1,'host_id','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',1,'local_data_id',1,'local_data_id','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',0,'PRIMARY',1,'data_input_field_id','A',151,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',0,'PRIMARY',2,'data_template_data_id','A',3190,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_data',1,'t_value',1,'t_value','A',6,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_fields',1,'data_input_id',1,'data_input_id','A',100,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_fields',1,'input_output',1,'input_output','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_fields',0,'PRIMARY',1,'id','A',201,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_fields',1,'type_code_data_input_id',1,'type_code','A',33,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_input_fields',1,'type_code_data_input_id',2,'data_input_id','A',201,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_local',1,'data_template_id',1,'data_template_id','A',7,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_local',1,'errored',1,'errored','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_local',1,'host_id_snmp_query_id',1,'host_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_local',1,'host_id_snmp_query_id',2,'snmp_query_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_local',1,'orphan',1,'orphan','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_local',0,'PRIMARY',1,'id','A',7,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_local',1,'snmp_index',1,'snmp_index','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_local',1,'snmp_query_id',1,'snmp_query_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles',1,'name',1,'name','A',6,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles',0,'PRIMARY',1,'id','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles_cf',0,'PRIMARY',1,'data_source_profile_id','A',12,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles_cf',0,'PRIMARY',2,'consolidation_function_id','A',24,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles_rra',1,'data_source_profile_id',1,'data_source_profile_id','A',12,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_profiles_rra',0,'PRIMARY',1,'id','A',24,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_purge_action',0,'name',1,'name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_purge_action',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',1,'data_template_id',1,'data_template_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',1,'in_cacti',1,'in_cacti','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',1,'local_data_id',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',0,'name',1,'name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_purge_temp',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_command_cache',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_daily',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_daily',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_daily',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',0,'PRIMARY',2,'time','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',0,'PRIMARY',3,'rrd_name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_cache',1,'time',1,'time','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_last',0,'PRIMARY',1,'local_data_id',NULL,NULL,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_hourly_last',0,'PRIMARY',2,'rrd_name',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_monthly',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_monthly',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_monthly',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_weekly',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_weekly',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_weekly',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_yearly',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_yearly',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_source_stats_yearly',0,'PRIMARY',3,'cf','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template',1,'name',1,'name','A',366,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template',0,'PRIMARY',1,'id','A',366,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',1,'data_input_id',1,'data_input_id','A',93,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',1,'data_template_id',1,'data_template_id','A',373,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',1,'local_data_id',1,'local_data_id','A',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',1,'name_cache',1,'name_cache','A',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_data',0,'PRIMARY',1,'id','A',373,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',1,'data_template_id',1,'data_template_id','A',667,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'duplicate_dsname_contraint',1,'local_data_id','A',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'duplicate_dsname_contraint',2,'data_source_name','A',667,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'duplicate_dsname_contraint',3,'data_template_id','A',667,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',1,'local_data_template_rrd_id',1,'local_data_template_rrd_id','A',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('data_template_rrd',0,'PRIMARY',1,'id','A',667,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('external_links',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_local',1,'graph_template_id',1,'graph_template_id','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_local',1,'host_id',1,'host_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_local',0,'PRIMARY',1,'id','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_local',1,'snmp_index',1,'snmp_index','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_local',1,'snmp_query_graph_id',1,'snmp_query_graph_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_local',1,'snmp_query_id',1,'snmp_query_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_template_input',0,'PRIMARY',1,'id','A',698,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_template_input_defs',0,'PRIMARY',1,'graph_template_input_id','A',1523,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_template_input_defs',0,'PRIMARY',2,'graph_template_item_id','A',3047,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates',1,'multiple_name',1,'multiple','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates',1,'multiple_name',2,'name','A',301,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates',1,'name',1,'name','A',301,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates',0,'PRIMARY',1,'id','A',301,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_gprint',1,'name',1,'name','A',12,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_gprint',0,'PRIMARY',1,'id','A',12,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_graph',1,'graph_template_id',1,'graph_template_id','A',307,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_graph',1,'local_graph_id',1,'local_graph_id','A',10,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_graph',0,'PRIMARY',1,'id','A',307,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_graph',1,'title_cache',1,'title_cache','A',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'cdef_id',1,'cdef_id','A',124,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'color_id',1,'color_id','A',323,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'gprint_id',1,'gprint_id','A',24,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'graph_template_id',1,'graph_template_id','A',647,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'lgi_gti',1,'local_graph_id','A',10,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'lgi_gti',2,'graph_template_id','A',647,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'local_graph_id_sequence',1,'local_graph_id','A',10,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'local_graph_id_sequence',2,'sequence','A',140,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'local_graph_template_item_id',1,'local_graph_template_item_id','A',40,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',0,'PRIMARY',1,'id','A',3238,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'task_item_id',1,'task_item_id','A',1619,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_templates_item',1,'vdef_id',1,'vdef_id','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree',1,'name',1,'name','A',0,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree',1,'sequence',1,'sequence','A',0,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'graph_tree_id',1,'graph_tree_id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'host_id',1,'host_id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'local_graph_id',1,'local_graph_id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'parent_position',1,'parent','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'parent_position',2,'position','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',0,'PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('graph_tree_items',1,'site_id',1,'site_id','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'current_errors',1,'current_errors','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'disabled',1,'disabled','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'external_id',1,'external_id','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'host_template_id',1,'host_template_id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'hostname',1,'hostname','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'poller_id_disabled',1,'poller_id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'poller_id_disabled',2,'disabled','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'poller_id_last_updated',1,'poller_id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'poller_id_last_updated',2,'last_updated','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',0,'PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'site_id_location',1,'site_id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'site_id_location',2,'location','A',1,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host',1,'status',1,'status','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_errors',1,'poller_id',1,'poller_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_errors',0,'PRIMARY',1,'host_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_graph',0,'PRIMARY',1,'host_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_graph',0,'PRIMARY',2,'graph_template_id','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'field_name',1,'field_name','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'field_value',1,'field_value','A',8,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'host_id',1,'host_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'host_id',2,'field_name','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'last_updated',1,'last_updated','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'present',1,'present','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',0,'PRIMARY',1,'host_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',0,'PRIMARY',2,'snmp_query_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',0,'PRIMARY',3,'field_name','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',0,'PRIMARY',4,'snmp_index','A',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'snmp_index',1,'snmp_index','A',8,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_cache',1,'snmp_query_id',1,'snmp_query_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_query',0,'PRIMARY',1,'host_id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_snmp_query',0,'PRIMARY',2,'snmp_query_id','A',1,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template',1,'name',1,'name','A',27,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template',0,'PRIMARY',1,'id','A',27,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_archive',1,'host_template_id',1,'host_template_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_archive',1,'name',1,'name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_archive',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_graph',0,'PRIMARY',1,'host_template_id','A',58,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_graph',0,'PRIMARY',2,'graph_template_id','A',235,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_snmp_query',0,'PRIMARY',1,'host_template_id','A',85,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_template_snmp_query',0,'PRIMARY',2,'snmp_query_id','A',85,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_value_cache',0,'PRIMARY',1,'host_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('host_value_cache',0,'PRIMARY',2,'dimension','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('package_public_keys',0,'md5sum',1,'md5sum','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('package_public_keys',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('package_repositories',0,'location_branch',1,'repo_location','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('package_repositories',0,'location_branch',2,'repo_branch','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('package_repositories',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_archive',1,'directory',1,'plugin','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_archive',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_available',0,'PRIMARY',1,'plugin','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_available',0,'PRIMARY',2,'tag_name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_config',1,'directory',1,'directory','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_config',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_config',1,'status',1,'status','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_db_changes',1,'method',1,'method','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_db_changes',1,'plugin',1,'plugin','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_db_changes',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_hooks',1,'hook',1,'hook','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_hooks',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_hooks',1,'status',1,'status','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_realms',1,'plugin',1,'plugin','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('plugin_realms',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller',1,'disabled',1,'disabled','A',0,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller',1,'name',1,'name','A',0,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_command',1,'poller_id_last_updated',1,'poller_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_command',1,'poller_id_last_updated',2,'last_updated','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_command',0,'PRIMARY',1,'poller_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_command',0,'PRIMARY',2,'action','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_command',0,'PRIMARY',3,'command','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_data_template_field_mappings',0,'PRIMARY',1,'data_template_id','A',133,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_data_template_field_mappings',0,'PRIMARY',2,'data_name','A',133,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_data_template_field_mappings',0,'PRIMARY',3,'data_source_names','A',133,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'action',1,'action','A',7,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'host_id',1,'host_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_action',1,'poller_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_action',2,'action','A',7,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_host_id',1,'poller_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_host_id',2,'host_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_last_updated',1,'poller_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_last_updated',2,'last_updated','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_rrd_next_step',1,'poller_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'poller_id_rrd_next_step',2,'rrd_next_step','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',1,'present',1,'present','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',0,'PRIMARY',1,'local_data_id','A',7,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_item',0,'PRIMARY',2,'rrd_name','A',7,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output',0,'PRIMARY',1,'local_data_id','A',NULL,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output',0,'PRIMARY',2,'rrd_name','A',NULL,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output',0,'PRIMARY',3,'time','A',NULL,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost',1,'last_updated',1,'last_updated','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost',0,'PRIMARY',2,'time','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost',0,'PRIMARY',3,'rrd_name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost',1,'time',1,'time','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost_local_data_ids',0,'PRIMARY',1,'local_data_id',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost_local_data_ids',1,'process_handler',1,'process_handler',NULL,0,NULL,NULL,'YES','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost_processes',0,'PRIMARY',1,'sock_int_value',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost_processes',0,'run_child',1,'run_id',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_boost_processes',0,'run_child',2,'child_id',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_realtime',1,'poller_id',1,'poller_id','A',0,'191',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_realtime',0,'PRIMARY',1,'local_data_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_realtime',0,'PRIMARY',2,'rrd_name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_realtime',0,'PRIMARY',3,'time','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_realtime',0,'PRIMARY',4,'poller_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_output_realtime',1,'time',1,'time','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_reindex',1,'present',1,'present','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_reindex',0,'PRIMARY',1,'host_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_reindex',0,'PRIMARY',2,'data_query_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_reindex',0,'PRIMARY',3,'arg1','A',0,'187',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_resource_cache',0,'path',1,'path','A',0,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_resource_cache',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_time',1,'poller_id_end_time',1,'poller_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_time',1,'poller_id_end_time',2,'end_time','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_time',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('poller_time_stats',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('processes',1,'id',1,'id',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('processes',0,'PRIMARY',1,'pid',NULL,NULL,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('processes',0,'PRIMARY',2,'tasktype',NULL,NULL,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('processes',0,'PRIMARY',3,'taskname',NULL,NULL,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('processes',0,'PRIMARY',4,'taskid',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('processes',1,'tasktype',1,'tasktype',NULL,0,NULL,NULL,'','HASH','');
|
|
INSERT INTO `table_indexes` VALUES ('reports',1,'last_started',1,'last_started','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports',1,'next_start',1,'next_start','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports_items',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports_items',1,'report_id',1,'report_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports_log',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports_log',1,'source',1,'source','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports_log',1,'source_id',1,'source_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports_queued',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports_queued',1,'source',1,'source','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('reports_queued',1,'source_id',1,'source_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sessions',1,'access',1,'access','A',0,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sessions',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sessions',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('settings',0,'PRIMARY',1,'name','A',285,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('settings_tree',0,'PRIMARY',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('settings_tree',0,'PRIMARY',2,'graph_tree_item_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('settings_user',0,'PRIMARY',1,'user_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('settings_user',0,'PRIMARY',2,'name','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('settings_user_group',0,'PRIMARY',1,'group_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('settings_user_group',0,'PRIMARY',2,'name','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sites',1,'alternate_id',1,'alternate_id','A',2,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sites',1,'city',1,'city','A',2,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sites',1,'country',1,'country','A',2,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sites',1,'name',1,'name','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sites',1,'postal_code',1,'postal_code','A',2,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sites',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('sites',1,'state',1,'state','A',2,NULL,NULL,'YES','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query',1,'name',1,'name','A',68,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query',0,'PRIMARY',1,'id','A',68,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'graph_template_id_name',1,'graph_template_id','A',170,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'graph_template_id_name',2,'name','A',170,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',0,'PRIMARY',1,'id','A',170,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'snmp_query_id_name',1,'snmp_query_id','A',170,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph',1,'snmp_query_id_name',2,'name','A',170,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',1,'data_template_rrd_id',1,'data_template_rrd_id','A',420,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',0,'PRIMARY',1,'snmp_query_graph_id','A',420,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',0,'PRIMARY',2,'data_template_id','A',420,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd',0,'PRIMARY',3,'data_template_rrd_id','A',420,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd_sv',1,'data_template_id',1,'data_template_id','A',139,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd_sv',0,'PRIMARY',1,'id','A',139,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_rrd_sv',1,'snmp_query_graph_id',1,'snmp_query_graph_id','A',139,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_sv',0,'PRIMARY',1,'id','A',126,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmp_query_graph_sv',1,'snmp_query_graph_id',1,'snmp_query_graph_id','A',126,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache',1,'mib_name',1,'mib','A',6,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache',1,'mib_name',2,'name','A',166,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache',1,'name',1,'name','A',166,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache',0,'PRIMARY',1,'oid','A',166,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache_notifications',0,'PRIMARY',1,'name','A',17,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache_notifications',0,'PRIMARY',2,'mib','A',17,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache_notifications',0,'PRIMARY',3,'attribute','A',17,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache_notifications',0,'PRIMARY',4,'sequence_id','A',17,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache_textual_conventions',1,'mib',1,'mib','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache_textual_conventions',0,'PRIMARY',1,'name','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache_textual_conventions',0,'PRIMARY',2,'mib','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_cache_textual_conventions',0,'PRIMARY',3,'type','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_managers',1,'hostname',1,'hostname','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_managers',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_managers_notifications',1,'mib',1,'mib','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_managers_notifications',0,'PRIMARY',1,'manager_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_managers_notifications',0,'PRIMARY',2,'notification','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_managers_notifications',0,'PRIMARY',3,'mib','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_mibs',0,'PRIMARY',1,'id','A',3,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',1,'manager_id_notification',1,'manager_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',1,'manager_id_notification',2,'notification','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',1,'severity',1,'severity','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('snmpagent_notifications_log',1,'time',1,'time','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('table_columns',0,'PRIMARY',1,'table_name','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('table_columns',0,'PRIMARY',2,'table_sequence','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('table_columns',0,'PRIMARY',3,'table_field','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('table_indexes',0,'PRIMARY',1,'idx_table_name','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('table_indexes',0,'PRIMARY',2,'idx_key_name','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('table_indexes',0,'PRIMARY',3,'idx_seq_in_index','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('table_indexes',0,'PRIMARY',4,'idx_column_name','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth',1,'enabled',1,'enabled','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth',0,'PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth',1,'realm',1,'realm','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth',1,'username',1,'username','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_cache',1,'hostname',1,'hostname','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_cache',1,'last_update',1,'last_update','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_cache',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_cache',0,'tokenkey',1,'token','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_cache',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_members',0,'PRIMARY',1,'group_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_members',0,'PRIMARY',2,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_members',1,'realm_id',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',1,'group_id',1,'group_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',1,'group_id',2,'type','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',0,'PRIMARY',1,'group_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',0,'PRIMARY',2,'item_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_perms',0,'PRIMARY',3,'type','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_realm',0,'PRIMARY',1,'group_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_realm',0,'PRIMARY',2,'realm_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_group_realm',1,'realm_id',1,'realm_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_perms',0,'PRIMARY',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_perms',0,'PRIMARY',2,'item_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_perms',0,'PRIMARY',3,'type','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_perms',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_perms',1,'user_id',2,'type','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_realm',0,'PRIMARY',1,'realm_id','A',31,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_realm',0,'PRIMARY',2,'user_id','A',31,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_realm',1,'user_id',1,'user_id','A',4,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_reset_hashes',0,'PRIMARY',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_reset_hashes',0,'PRIMARY',2,'expiry','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_row_cache',0,'PRIMARY',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_row_cache',0,'PRIMARY',2,'class','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_auth_row_cache',0,'PRIMARY',3,'hash','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('login_providers',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_layouts',1,'page',1,'page','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_layouts',0,'PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_layouts',1,'user_id',1,'user_id','A',0,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_log',0,'PRIMARY',1,'username','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_log',0,'PRIMARY',2,'user_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_log',0,'PRIMARY',3,'time','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('user_log',1,'user_id',1,'user_id','A',2,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('vdef',1,'hash',1,'hash','A',7,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('vdef',1,'name',1,'name','A',7,'171',NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('vdef',0,'PRIMARY',1,'id','A',7,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('vdef_items',0,'PRIMARY',1,'id','A',15,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('vdef_items',1,'vdef_id_sequence',1,'vdef_id','A',15,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('vdef_items',1,'vdef_id_sequence',2,'sequence','A',15,NULL,NULL,'','BTREE','');
|
|
INSERT INTO `table_indexes` VALUES ('version',0,'PRIMARY',1,'cacti','A',1,NULL,NULL,'','BTREE','');
|
|
/*!40000 ALTER TABLE `table_indexes` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2026-02-12 22:48:58
|