-- MySQL dump 10.15 Distrib 10.0.29-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: 127.0.0.1 Database: 127.0.0.1 -- ------------------------------------------------------ -- Server version 5.7.19-17-57-log /*!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 `access_points` -- DROP TABLE IF EXISTS `access_points`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `access_points` ( `accesspoint_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `radio_number` tinyint(4) DEFAULT NULL, `type` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `mac_addr` varchar(24) COLLATE utf8_unicode_ci NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', `channel` tinyint(4) unsigned NOT NULL DEFAULT '0', `txpow` tinyint(4) NOT NULL DEFAULT '0', `radioutil` tinyint(4) NOT NULL DEFAULT '0', `numasoclients` smallint(6) NOT NULL DEFAULT '0', `nummonclients` smallint(6) NOT NULL DEFAULT '0', `numactbssid` tinyint(4) NOT NULL DEFAULT '0', `nummonbssid` tinyint(4) NOT NULL DEFAULT '0', `interference` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`accesspoint_id`), KEY `deleted` (`deleted`), KEY `name` (`name`,`radio_number`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Access Points'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `alert_log` -- DROP TABLE IF EXISTS `alert_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alert_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rule_id` int(11) NOT NULL, `device_id` int(11) NOT NULL, `state` int(11) NOT NULL, `details` longblob, `time_logged` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `rule_id` (`rule_id`), KEY `device_id` (`device_id`), KEY `time_logged` (`time_logged`) ) ENGINE=InnoDB AUTO_INCREMENT=11785 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `alert_map` -- DROP TABLE IF EXISTS `alert_map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alert_map` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rule` int(11) NOT NULL DEFAULT '0', `target` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `alert_rules` -- DROP TABLE IF EXISTS `alert_rules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alert_rules` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `rule` text COLLATE utf8_unicode_ci NOT NULL, `severity` enum('ok','warning','critical') COLLATE utf8_unicode_ci NOT NULL, `extra` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `disabled` tinyint(1) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `query` text COLLATE utf8_unicode_ci NOT NULL, `proc` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `alert_schedule` -- DROP TABLE IF EXISTS `alert_schedule`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alert_schedule` ( `schedule_id` int(11) NOT NULL AUTO_INCREMENT, `recurring` tinyint(1) unsigned NOT NULL DEFAULT '0', `start` datetime NOT NULL DEFAULT '1970-01-02 00:00:01', `end` datetime NOT NULL DEFAULT '1970-01-02 00:00:01', `start_recurring_dt` date NOT NULL DEFAULT '1970-01-01', `end_recurring_dt` date DEFAULT NULL, `start_recurring_hr` time NOT NULL DEFAULT '00:00:00', `end_recurring_hr` time NOT NULL DEFAULT '00:00:00', `recurring_day` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `notes` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`schedule_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `alert_schedule_items` -- DROP TABLE IF EXISTS `alert_schedule_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alert_schedule_items` ( `item_id` int(11) NOT NULL AUTO_INCREMENT, `schedule_id` int(11) NOT NULL, `target` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`item_id`), KEY `schedule_id` (`schedule_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `alert_template_map` -- DROP TABLE IF EXISTS `alert_template_map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alert_template_map` ( `id` int(11) NOT NULL AUTO_INCREMENT, `alert_templates_id` int(11) NOT NULL, `alert_rule_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `alert_templates_id` (`alert_templates_id`,`alert_rule_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `alert_templates` -- DROP TABLE IF EXISTS `alert_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alert_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rule_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ',', `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `template` longtext COLLATE utf8_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `title_rec` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `alerts` -- DROP TABLE IF EXISTS `alerts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alerts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `rule_id` int(11) NOT NULL, `state` int(11) NOT NULL, `alerted` int(11) NOT NULL, `open` int(11) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `unique_alert` (`device_id`,`rule_id`), KEY `rule_id` (`rule_id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=859 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `api_tokens` -- DROP TABLE IF EXISTS `api_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `api_tokens` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `token_hash` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `disabled` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `token_hash` (`token_hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `application_metrics` -- DROP TABLE IF EXISTS `application_metrics`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `application_metrics` ( `app_id` int(11) NOT NULL, `metric` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `value` int(11) DEFAULT NULL, `value_prev` int(11) DEFAULT NULL, UNIQUE KEY `application_metrics_app_id_metric_uindex` (`app_id`,`metric`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `applications` -- DROP TABLE IF EXISTS `applications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `applications` ( `app_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `app_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `app_state` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'UNKNOWN', `discovered` tinyint(4) NOT NULL DEFAULT '0', `app_state_prev` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `app_status` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `app_instance` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`app_id`), UNIQUE KEY `unique_index` (`device_id`,`app_type`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `authlog` -- DROP TABLE IF EXISTS `authlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `authlog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `user` text COLLATE utf8_unicode_ci NOT NULL, `address` text COLLATE utf8_unicode_ci NOT NULL, `result` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=592 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bgpPeers` -- DROP TABLE IF EXISTS `bgpPeers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bgpPeers` ( `bgpPeer_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `astext` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `bgpPeerIdentifier` text COLLATE utf8_unicode_ci NOT NULL, `bgpPeerRemoteAs` bigint(20) NOT NULL, `bgpPeerState` text COLLATE utf8_unicode_ci NOT NULL, `bgpPeerAdminStatus` text COLLATE utf8_unicode_ci NOT NULL, `bgpLocalAddr` text COLLATE utf8_unicode_ci NOT NULL, `bgpPeerRemoteAddr` text COLLATE utf8_unicode_ci NOT NULL, `bgpPeerInUpdates` int(11) NOT NULL, `bgpPeerOutUpdates` int(11) NOT NULL, `bgpPeerInTotalMessages` int(11) NOT NULL, `bgpPeerOutTotalMessages` int(11) NOT NULL, `bgpPeerFsmEstablishedTime` int(11) NOT NULL, `bgpPeerInUpdateElapsedTime` int(11) NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`bgpPeer_id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bgpPeers_cbgp` -- DROP TABLE IF EXISTS `bgpPeers_cbgp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bgpPeers_cbgp` ( `device_id` int(11) NOT NULL, `bgpPeerIdentifier` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `afi` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `safi` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `AcceptedPrefixes` int(11) NOT NULL, `DeniedPrefixes` int(11) NOT NULL, `PrefixAdminLimit` int(11) NOT NULL, `PrefixThreshold` int(11) NOT NULL, `PrefixClearThreshold` int(11) NOT NULL, `AdvertisedPrefixes` int(11) NOT NULL, `SuppressedPrefixes` int(11) NOT NULL, `WithdrawnPrefixes` int(11) NOT NULL, `AcceptedPrefixes_delta` int(11) NOT NULL, `AcceptedPrefixes_prev` int(11) NOT NULL, `DeniedPrefixes_delta` int(11) NOT NULL, `DeniedPrefixes_prev` int(11) NOT NULL, `AdvertisedPrefixes_delta` int(11) NOT NULL, `AdvertisedPrefixes_prev` int(11) NOT NULL, `SuppressedPrefixes_delta` int(11) NOT NULL, `SuppressedPrefixes_prev` int(11) NOT NULL, `WithdrawnPrefixes_delta` int(11) NOT NULL, `WithdrawnPrefixes_prev` int(11) NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, UNIQUE KEY `unique_index` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`), KEY `device_id` (`device_id`,`bgpPeerIdentifier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bill_data` -- DROP TABLE IF EXISTS `bill_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bill_data` ( `bill_id` int(11) NOT NULL, `timestamp` datetime NOT NULL, `period` int(11) NOT NULL, `delta` bigint(11) NOT NULL, `in_delta` bigint(11) NOT NULL, `out_delta` bigint(11) NOT NULL, PRIMARY KEY (`bill_id`,`timestamp`), KEY `bill_id` (`bill_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bill_history` -- DROP TABLE IF EXISTS `bill_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bill_history` ( `bill_hist_id` int(11) NOT NULL AUTO_INCREMENT, `bill_id` int(11) NOT NULL, `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `bill_datefrom` datetime NOT NULL, `bill_dateto` datetime NOT NULL, `bill_type` text COLLATE utf8_unicode_ci NOT NULL, `bill_allowed` bigint(20) NOT NULL, `bill_used` bigint(20) NOT NULL, `bill_overuse` bigint(20) NOT NULL, `bill_percent` decimal(10,2) NOT NULL, `rate_95th_in` bigint(20) NOT NULL, `rate_95th_out` bigint(20) NOT NULL, `rate_95th` bigint(20) NOT NULL, `dir_95th` varchar(3) COLLATE utf8_unicode_ci NOT NULL, `rate_average` bigint(20) NOT NULL, `rate_average_in` bigint(20) NOT NULL, `rate_average_out` bigint(20) NOT NULL, `traf_in` bigint(20) NOT NULL, `traf_out` bigint(20) NOT NULL, `traf_total` bigint(20) NOT NULL, `pdf` longblob, PRIMARY KEY (`bill_hist_id`), UNIQUE KEY `unique_index` (`bill_id`,`bill_datefrom`,`bill_dateto`), KEY `bill_id` (`bill_id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bill_perms` -- DROP TABLE IF EXISTS `bill_perms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bill_perms` ( `user_id` int(11) NOT NULL, `bill_id` int(11) NOT NULL, PRIMARY KEY (`user_id`,`bill_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bill_port_counters` -- DROP TABLE IF EXISTS `bill_port_counters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bill_port_counters` ( `port_id` int(11) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `in_counter` bigint(20) DEFAULT NULL, `in_delta` bigint(20) NOT NULL DEFAULT '0', `out_counter` bigint(20) DEFAULT NULL, `out_delta` bigint(20) NOT NULL DEFAULT '0', `bill_id` int(11) NOT NULL, PRIMARY KEY (`port_id`,`bill_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bill_ports` -- DROP TABLE IF EXISTS `bill_ports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bill_ports` ( `bill_id` int(11) NOT NULL, `port_id` int(11) NOT NULL, `bill_port_autoadded` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`bill_id`,`port_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bills` -- DROP TABLE IF EXISTS `bills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bills` ( `bill_id` int(11) NOT NULL AUTO_INCREMENT, `bill_name` text COLLATE utf8_unicode_ci NOT NULL, `bill_type` text COLLATE utf8_unicode_ci NOT NULL, `bill_cdr` bigint(20) DEFAULT NULL, `bill_day` int(11) NOT NULL DEFAULT '1', `bill_quota` bigint(20) DEFAULT NULL, `rate_95th_in` bigint(20) NOT NULL, `rate_95th_out` bigint(20) NOT NULL, `rate_95th` bigint(20) NOT NULL, `dir_95th` varchar(3) COLLATE utf8_unicode_ci NOT NULL, `total_data` bigint(20) NOT NULL, `total_data_in` bigint(20) NOT NULL, `total_data_out` bigint(20) NOT NULL, `rate_average_in` bigint(20) NOT NULL, `rate_average_out` bigint(20) NOT NULL, `rate_average` bigint(20) NOT NULL, `bill_last_calc` datetime NOT NULL, `bill_custid` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `bill_ref` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `bill_notes` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `bill_autoadded` tinyint(1) NOT NULL, UNIQUE KEY `bill_id` (`bill_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `callback` -- DROP TABLE IF EXISTS `callback`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `callback` ( `callback_id` int(11) NOT NULL AUTO_INCREMENT, `name` char(64) COLLATE utf8_unicode_ci NOT NULL, `value` char(64) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`callback_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cef_switching` -- DROP TABLE IF EXISTS `cef_switching`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cef_switching` ( `cef_switching_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `entPhysicalIndex` int(11) NOT NULL, `afi` varchar(4) COLLATE utf8_unicode_ci NOT NULL, `cef_index` int(11) NOT NULL, `cef_path` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `drop` int(11) NOT NULL, `punt` int(11) NOT NULL, `punt2host` int(11) NOT NULL, `drop_prev` int(11) NOT NULL, `punt_prev` int(11) NOT NULL, `punt2host_prev` int(11) NOT NULL, `updated` int(11) NOT NULL, `updated_prev` int(11) NOT NULL, PRIMARY KEY (`cef_switching_id`), UNIQUE KEY `device_id` (`device_id`,`entPhysicalIndex`,`afi`,`cef_index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ciscoASA` -- DROP TABLE IF EXISTS `ciscoASA`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ciscoASA` ( `ciscoASA_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `oid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `data` bigint(20) NOT NULL, `high_alert` bigint(20) NOT NULL, `low_alert` bigint(20) NOT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`ciscoASA_id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `component` -- DROP TABLE IF EXISTS `component`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `component` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID for each component, unique index', `device_id` int(11) unsigned NOT NULL COMMENT 'device_id from the devices table', `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'name from the component_type table', `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Display label for the component', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'The status of the component, retreived from the device', `disabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Should this component be polled', `ignore` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Should this component be alerted on', `error` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Error message if in Alert state', PRIMARY KEY (`id`), KEY `device` (`device_id`), KEY `type` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='components attached to a device.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `component_prefs` -- DROP TABLE IF EXISTS `component_prefs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `component_prefs` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID for each entry', `component` int(11) unsigned NOT NULL COMMENT 'id from the component table', `attribute` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Attribute for the Component', `value` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'Value for the Component', PRIMARY KEY (`id`), KEY `component` (`component`), CONSTRAINT `component_prefs_ibfk_1` FOREIGN KEY (`component`) REFERENCES `component` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='AV Pairs for each component'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `component_statuslog` -- DROP TABLE IF EXISTS `component_statuslog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `component_statuslog` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID for each log entry, unique index', `component_id` int(11) unsigned NOT NULL COMMENT 'id from the component table', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'The status that the component was changed TO', `message` text COLLATE utf8_unicode_ci, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'When the status of the component was changed', PRIMARY KEY (`id`), KEY `device` (`component_id`), CONSTRAINT `component_statuslog_ibfk_1` FOREIGN KEY (`component_id`) REFERENCES `component` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='log of status changes to a component.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `config` ( `config_id` int(11) NOT NULL AUTO_INCREMENT, `config_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `config_value` varchar(512) COLLATE utf8_unicode_ci NOT NULL, `config_default` varchar(512) COLLATE utf8_unicode_ci NOT NULL, `config_descr` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `config_group` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `config_group_order` int(11) NOT NULL DEFAULT '0', `config_sub_group` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `config_sub_group_order` int(11) NOT NULL DEFAULT '0', `config_hidden` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `config_disabled` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`config_id`), UNIQUE KEY `uniqueindex_configname` (`config_name`) ) ENGINE=InnoDB AUTO_INCREMENT=804 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customers` ( `customer_id` int(11) NOT NULL AUTO_INCREMENT, `username` char(64) COLLATE utf8_unicode_ci NOT NULL, `password` char(32) COLLATE utf8_unicode_ci NOT NULL, `string` char(64) COLLATE utf8_unicode_ci NOT NULL, `level` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`customer_id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `dashboards` -- DROP TABLE IF EXISTS `dashboards`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dashboards` ( `dashboard_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `dashboard_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `access` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`dashboard_id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `dbSchema` -- DROP TABLE IF EXISTS `dbSchema`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dbSchema` ( `version` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `device_graphs` -- DROP TABLE IF EXISTS `device_graphs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `device_graphs` ( `device_id` int(11) NOT NULL, `graph` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`device_id`,`graph`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `device_group_device` -- DROP TABLE IF EXISTS `device_group_device`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `device_group_device` ( `device_group_id` int(10) unsigned NOT NULL, `device_id` int(10) unsigned NOT NULL, PRIMARY KEY (`device_group_id`,`device_id`), KEY `device_group_device_device_group_id_index` (`device_group_id`), KEY `device_group_device_device_id_index` (`device_id`), CONSTRAINT `device_group_device_device_group_id_foreign` FOREIGN KEY (`device_group_id`) REFERENCES `device_groups` (`id`) ON DELETE CASCADE, CONSTRAINT `device_group_device_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `device_groups` -- DROP TABLE IF EXISTS `device_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `device_groups` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `pattern` text COLLATE utf8_unicode_ci, `params` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `device_mibs` -- DROP TABLE IF EXISTS `device_mibs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `device_mibs` ( `device_id` int(11) NOT NULL, `module` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `mib` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `included_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`device_id`,`module`,`mib`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Device to MIB mappings'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `device_oids` -- DROP TABLE IF EXISTS `device_oids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `device_oids` ( `device_id` int(11) NOT NULL, `oid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `module` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `mib` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `object_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `numvalue` bigint(20) DEFAULT NULL, `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`device_id`,`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Per-device MIB data'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `device_perf` -- DROP TABLE IF EXISTS `device_perf`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `device_perf` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `timestamp` datetime NOT NULL, `xmt` float NOT NULL, `rcv` float NOT NULL, `loss` float NOT NULL, `min` float NOT NULL, `max` float NOT NULL, `avg` float NOT NULL, PRIMARY KEY (`id`,`device_id`), KEY `id` (`id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3632227 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `device_relationships` -- DROP TABLE IF EXISTS `device_relationships`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `device_relationships` ( `parent_device_id` int(11) unsigned NOT NULL DEFAULT '0', `child_device_id` int(11) unsigned NOT NULL, PRIMARY KEY (`parent_device_id`,`child_device_id`), KEY `device_relationship_child_device_id_fk` (`child_device_id`), CONSTRAINT `device_relationship_child_device_id_fk` FOREIGN KEY (`child_device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE, CONSTRAINT `device_relationship_parent_device_id_fk` FOREIGN KEY (`parent_device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `devices` -- DROP TABLE IF EXISTS `devices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `devices` ( `device_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `hostname` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `sysName` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `ip` varbinary(16) DEFAULT NULL, `community` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `authlevel` enum('noAuthNoPriv','authNoPriv','authPriv') COLLATE utf8_unicode_ci DEFAULT NULL, `authname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `authpass` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `authalgo` enum('MD5','SHA') COLLATE utf8_unicode_ci DEFAULT NULL, `cryptopass` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `cryptoalgo` enum('AES','DES','') COLLATE utf8_unicode_ci DEFAULT NULL, `snmpver` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'v2c', `port` smallint(5) unsigned NOT NULL DEFAULT '161', `transport` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'udp', `timeout` int(11) DEFAULT NULL, `retries` int(11) DEFAULT NULL, `snmp_disable` tinyint(1) NOT NULL DEFAULT '0', `bgpLocalAs` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `sysObjectID` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `sysDescr` text COLLATE utf8_unicode_ci, `sysContact` text COLLATE utf8_unicode_ci, `version` text COLLATE utf8_unicode_ci, `hardware` text COLLATE utf8_unicode_ci, `features` text COLLATE utf8_unicode_ci, `location` text COLLATE utf8_unicode_ci, `os` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT '0', `status_reason` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `ignore` tinyint(4) NOT NULL DEFAULT '0', `disabled` tinyint(1) NOT NULL DEFAULT '0', `uptime` bigint(20) DEFAULT NULL, `agent_uptime` int(11) NOT NULL DEFAULT '0', `last_polled` timestamp NULL DEFAULT NULL, `last_poll_attempted` timestamp NULL DEFAULT NULL, `last_polled_timetaken` double(5,2) DEFAULT NULL, `last_discovered_timetaken` double(5,2) DEFAULT NULL, `last_discovered` timestamp NULL DEFAULT NULL, `last_ping` timestamp NULL DEFAULT NULL, `last_ping_timetaken` double(5,2) DEFAULT NULL, `purpose` text COLLATE utf8_unicode_ci, `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `serial` text COLLATE utf8_unicode_ci, `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `poller_group` int(11) NOT NULL DEFAULT '0', `override_sysLocation` tinyint(1) DEFAULT '0', `notes` text COLLATE utf8_unicode_ci, `port_association_mode` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`device_id`), KEY `status` (`status`), KEY `hostname` (`hostname`), KEY `sysName` (`sysName`), KEY `os` (`os`), KEY `last_polled` (`last_polled`), KEY `last_poll_attempted` (`last_poll_attempted`) ) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `devices_attribs` -- DROP TABLE IF EXISTS `devices_attribs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `devices_attribs` ( `attrib_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `attrib_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `attrib_value` text COLLATE utf8_unicode_ci NOT NULL, `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`attrib_id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=313 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `devices_perms` -- DROP TABLE IF EXISTS `devices_perms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `devices_perms` ( `user_id` int(11) NOT NULL, `device_id` int(11) NOT NULL, `access_level` int(4) NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`,`device_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `entPhysical` -- DROP TABLE IF EXISTS `entPhysical`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `entPhysical` ( `entPhysical_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `entPhysicalIndex` int(11) NOT NULL, `entPhysicalDescr` text COLLATE utf8_unicode_ci NOT NULL, `entPhysicalClass` text COLLATE utf8_unicode_ci NOT NULL, `entPhysicalName` text COLLATE utf8_unicode_ci NOT NULL, `entPhysicalHardwareRev` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `entPhysicalFirmwareRev` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `entPhysicalSoftwareRev` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `entPhysicalAlias` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `entPhysicalAssetID` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `entPhysicalIsFRU` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL, `entPhysicalModelName` text COLLATE utf8_unicode_ci NOT NULL, `entPhysicalVendorType` text COLLATE utf8_unicode_ci, `entPhysicalSerialNum` text COLLATE utf8_unicode_ci NOT NULL, `entPhysicalContainedIn` int(11) NOT NULL, `entPhysicalParentRelPos` int(11) NOT NULL, `entPhysicalMfgName` text COLLATE utf8_unicode_ci NOT NULL, `ifIndex` int(11) DEFAULT NULL, PRIMARY KEY (`entPhysical_id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3073 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `entPhysical_state` -- DROP TABLE IF EXISTS `entPhysical_state`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `entPhysical_state` ( `device_id` int(11) NOT NULL, `entPhysicalIndex` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `subindex` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `group` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `key` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL, KEY `device_id_index` (`device_id`,`entPhysicalIndex`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `entityState` -- DROP TABLE IF EXISTS `entityState`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `entityState` ( `entity_state_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) DEFAULT NULL, `entPhysical_id` int(11) DEFAULT NULL, `entStateLastChanged` datetime DEFAULT NULL, `entStateAdmin` int(11) DEFAULT NULL, `entStateOper` int(11) DEFAULT NULL, `entStateUsage` int(11) DEFAULT NULL, `entStateAlarm` text COLLATE utf8_unicode_ci, `entStateStandby` int(11) DEFAULT NULL, PRIMARY KEY (`entity_state_id`), KEY `entityState_device_id_index` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `eventlog` -- DROP TABLE IF EXISTS `eventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `eventlog` ( `event_id` int(11) NOT NULL AUTO_INCREMENT, `host` int(11) NOT NULL DEFAULT '0', `device_id` int(11) NOT NULL, `datetime` datetime NOT NULL DEFAULT '1970-01-02 00:00:01', `message` text COLLATE utf8_unicode_ci, `type` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `reference` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `username` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `severity` int(1) DEFAULT '2', PRIMARY KEY (`event_id`), KEY `host` (`host`), KEY `datetime` (`datetime`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4948948 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `graph_types` -- DROP TABLE IF EXISTS `graph_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `graph_types` ( `graph_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `graph_subtype` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `graph_section` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `graph_descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `graph_order` int(11) NOT NULL, PRIMARY KEY (`graph_type`,`graph_subtype`,`graph_section`), KEY `graph_type` (`graph_type`), KEY `graph_subtype` (`graph_subtype`), KEY `graph_section` (`graph_section`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `graph_types_dead` -- DROP TABLE IF EXISTS `graph_types_dead`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `graph_types_dead` ( `graph_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `graph_subtype` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `graph_section` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `graph_descr` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `graph_order` int(11) NOT NULL, KEY `graph_type` (`graph_type`), KEY `graph_subtype` (`graph_subtype`), KEY `graph_section` (`graph_section`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hrDevice` -- DROP TABLE IF EXISTS `hrDevice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hrDevice` ( `hrDevice_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `hrDeviceIndex` int(11) NOT NULL, `hrDeviceDescr` text COLLATE utf8_unicode_ci NOT NULL, `hrDeviceType` text COLLATE utf8_unicode_ci NOT NULL, `hrDeviceErrors` int(11) NOT NULL DEFAULT '0', `hrDeviceStatus` text COLLATE utf8_unicode_ci NOT NULL, `hrProcessorLoad` tinyint(4) DEFAULT NULL, PRIMARY KEY (`hrDevice_id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=391 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ipsec_tunnels` -- DROP TABLE IF EXISTS `ipsec_tunnels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ipsec_tunnels` ( `tunnel_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `peer_port` int(11) NOT NULL, `peer_addr` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `local_addr` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `local_port` int(11) NOT NULL, `tunnel_name` varchar(96) COLLATE utf8_unicode_ci NOT NULL, `tunnel_status` varchar(11) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`tunnel_id`), UNIQUE KEY `unique_index` (`device_id`,`peer_addr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ipv4_addresses` -- DROP TABLE IF EXISTS `ipv4_addresses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ipv4_addresses` ( `ipv4_address_id` int(11) NOT NULL AUTO_INCREMENT, `ipv4_address` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ipv4_prefixlen` int(11) NOT NULL, `ipv4_network_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `port_id` int(11) NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`ipv4_address_id`), KEY `interface_id` (`port_id`), KEY `interface_id_2` (`port_id`) ) ENGINE=InnoDB AUTO_INCREMENT=25729 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ipv4_mac` -- DROP TABLE IF EXISTS `ipv4_mac`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ipv4_mac` ( `id` int(11) NOT NULL AUTO_INCREMENT, `port_id` int(11) NOT NULL, `device_id` int(11) DEFAULT NULL, `mac_address` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ipv4_address` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, UNIQUE KEY `id` (`id`), KEY `port_id` (`port_id`), KEY `mac_address` (`mac_address`) ) ENGINE=InnoDB AUTO_INCREMENT=108178 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ipv4_networks` -- DROP TABLE IF EXISTS `ipv4_networks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ipv4_networks` ( `ipv4_network_id` int(11) NOT NULL AUTO_INCREMENT, `ipv4_network` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`ipv4_network_id`) ) ENGINE=InnoDB AUTO_INCREMENT=25570 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ipv6_addresses` -- DROP TABLE IF EXISTS `ipv6_addresses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ipv6_addresses` ( `ipv6_address_id` int(11) NOT NULL AUTO_INCREMENT, `ipv6_address` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `ipv6_compressed` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `ipv6_prefixlen` int(11) NOT NULL, `ipv6_origin` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `ipv6_network_id` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `port_id` int(11) NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`ipv6_address_id`), KEY `interface_id` (`port_id`), KEY `interface_id_2` (`port_id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ipv6_networks` -- DROP TABLE IF EXISTS `ipv6_networks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ipv6_networks` ( `ipv6_network_id` int(11) NOT NULL AUTO_INCREMENT, `ipv6_network` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`ipv6_network_id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `juniAtmVp` -- DROP TABLE IF EXISTS `juniAtmVp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `juniAtmVp` ( `juniAtmVp_id` int(11) NOT NULL, `port_id` int(11) NOT NULL, `vp_id` int(11) NOT NULL, `vp_descr` varchar(32) COLLATE utf8_unicode_ci NOT NULL, KEY `port_id` (`port_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `links` -- DROP TABLE IF EXISTS `links`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `local_port_id` int(11) DEFAULT NULL, `local_device_id` int(11) NOT NULL, `remote_port_id` int(11) DEFAULT NULL, `active` tinyint(4) NOT NULL DEFAULT '1', `protocol` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL, `remote_hostname` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `remote_device_id` int(11) NOT NULL, `remote_port` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `remote_platform` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL, `remote_version` varchar(256) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `src_if` (`local_port_id`), KEY `dst_if` (`remote_port_id`), KEY `local_device_id` (`local_device_id`,`remote_device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=271 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `loadbalancer_rservers` -- DROP TABLE IF EXISTS `loadbalancer_rservers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `loadbalancer_rservers` ( `rserver_id` int(11) NOT NULL AUTO_INCREMENT, `farm_id` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `device_id` int(11) NOT NULL, `StateDescr` varchar(64) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`rserver_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `loadbalancer_vservers` -- DROP TABLE IF EXISTS `loadbalancer_vservers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `loadbalancer_vservers` ( `classmap_id` int(11) NOT NULL, `classmap` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `serverstate` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `device_id` int(11) NOT NULL, KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locations` -- DROP TABLE IF EXISTS `locations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `location` text COLLATE utf8_unicode_ci NOT NULL, `lat` float(10,6) NOT NULL, `lng` float(10,6) NOT NULL, `timestamp` datetime NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mac_accounting` -- DROP TABLE IF EXISTS `mac_accounting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mac_accounting` ( `ma_id` int(11) NOT NULL AUTO_INCREMENT, `port_id` int(11) NOT NULL, `mac` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `in_oid` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `out_oid` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `bps_out` int(11) NOT NULL, `bps_in` int(11) NOT NULL, `cipMacHCSwitchedBytes_input` bigint(20) DEFAULT NULL, `cipMacHCSwitchedBytes_input_prev` bigint(20) DEFAULT NULL, `cipMacHCSwitchedBytes_input_delta` bigint(20) DEFAULT NULL, `cipMacHCSwitchedBytes_input_rate` int(11) DEFAULT NULL, `cipMacHCSwitchedBytes_output` bigint(20) DEFAULT NULL, `cipMacHCSwitchedBytes_output_prev` bigint(20) DEFAULT NULL, `cipMacHCSwitchedBytes_output_delta` bigint(20) DEFAULT NULL, `cipMacHCSwitchedBytes_output_rate` int(11) DEFAULT NULL, `cipMacHCSwitchedPkts_input` bigint(20) DEFAULT NULL, `cipMacHCSwitchedPkts_input_prev` bigint(20) DEFAULT NULL, `cipMacHCSwitchedPkts_input_delta` bigint(20) DEFAULT NULL, `cipMacHCSwitchedPkts_input_rate` int(11) DEFAULT NULL, `cipMacHCSwitchedPkts_output` bigint(20) DEFAULT NULL, `cipMacHCSwitchedPkts_output_prev` bigint(20) DEFAULT NULL, `cipMacHCSwitchedPkts_output_delta` bigint(20) DEFAULT NULL, `cipMacHCSwitchedPkts_output_rate` int(11) DEFAULT NULL, `poll_time` int(11) DEFAULT NULL, `poll_prev` int(11) DEFAULT NULL, `poll_period` int(11) DEFAULT NULL, PRIMARY KEY (`ma_id`), KEY `interface_id` (`port_id`), KEY `interface_id_2` (`port_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mefinfo` -- DROP TABLE IF EXISTS `mefinfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mefinfo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `mefID` int(32) NOT NULL, `mefType` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `mefIdent` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `mefMTU` int(16) NOT NULL DEFAULT '1500', `mefAdmState` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `mefRowState` varchar(128) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `device_id` (`device_id`), KEY `mefID` (`mefID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mempools` -- DROP TABLE IF EXISTS `mempools`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mempools` ( `mempool_id` int(11) NOT NULL AUTO_INCREMENT, `mempool_index` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `entPhysicalIndex` int(11) DEFAULT NULL, `hrDeviceIndex` int(11) DEFAULT NULL, `mempool_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `mempool_precision` int(11) NOT NULL DEFAULT '1', `mempool_descr` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `device_id` int(11) NOT NULL, `mempool_perc` int(11) NOT NULL, `mempool_used` bigint(16) NOT NULL, `mempool_free` bigint(16) NOT NULL, `mempool_total` bigint(16) NOT NULL, `mempool_largestfree` bigint(16) DEFAULT NULL, `mempool_lowestfree` bigint(16) DEFAULT NULL, `mempool_deleted` tinyint(1) NOT NULL DEFAULT '0', `mempool_perc_warn` int(11) DEFAULT '75', PRIMARY KEY (`mempool_id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=262 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mibdefs` -- DROP TABLE IF EXISTS `mibdefs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mibdefs` ( `module` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `mib` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `object_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `oid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `syntax` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `max_access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `included_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`module`,`mib`,`object_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='MIB definitions'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `munin_plugins` -- DROP TABLE IF EXISTS `munin_plugins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `munin_plugins` ( `mplug_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `mplug_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `mplug_instance` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `mplug_category` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `mplug_title` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `mplug_info` text COLLATE utf8_unicode_ci, `mplug_vlabel` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `mplug_args` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL, `mplug_total` binary(1) NOT NULL DEFAULT '0', `mplug_graph` binary(1) NOT NULL DEFAULT '1', PRIMARY KEY (`mplug_id`), UNIQUE KEY `UNIQUE` (`device_id`,`mplug_type`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `munin_plugins_ds` -- DROP TABLE IF EXISTS `munin_plugins_ds`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `munin_plugins_ds` ( `mplug_id` int(11) NOT NULL, `ds_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ds_type` enum('COUNTER','ABSOLUTE','DERIVE','GAUGE') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'GAUGE', `ds_label` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `ds_cdef` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `ds_draw` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `ds_graph` enum('no','yes') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', `ds_info` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `ds_extinfo` text COLLATE utf8_unicode_ci NOT NULL, `ds_max` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ds_min` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ds_negative` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ds_warning` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ds_critical` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ds_colour` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ds_sum` text COLLATE utf8_unicode_ci NOT NULL, `ds_stack` text COLLATE utf8_unicode_ci NOT NULL, `ds_line` varchar(64) COLLATE utf8_unicode_ci NOT NULL, UNIQUE KEY `splug_id` (`mplug_id`,`ds_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `netscaler_vservers` -- DROP TABLE IF EXISTS `netscaler_vservers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `netscaler_vservers` ( `vsvr_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `vsvr_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `vsvr_ip` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `vsvr_port` int(8) NOT NULL, `vsvr_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `vsvr_state` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `vsvr_clients` int(11) NOT NULL, `vsvr_server` int(11) NOT NULL, `vsvr_req_rate` int(11) NOT NULL, `vsvr_bps_in` int(11) NOT NULL, `vsvr_bps_out` int(11) NOT NULL, PRIMARY KEY (`vsvr_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications` ( `notifications_id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `body` text COLLATE utf8_unicode_ci NOT NULL, `severity` int(11) DEFAULT '0' COMMENT '0=ok,1=warning,2=critical', `source` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `checksum` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `datetime` timestamp NOT NULL DEFAULT '1970-01-01 23:00:00', PRIMARY KEY (`notifications_id`), UNIQUE KEY `checksum` (`checksum`), KEY `notifications_severity_index` (`severity`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `notifications_attribs` -- DROP TABLE IF EXISTS `notifications_attribs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications_attribs` ( `attrib_id` int(11) NOT NULL AUTO_INCREMENT, `notifications_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`attrib_id`) ) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ospf_areas` -- DROP TABLE IF EXISTS `ospf_areas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ospf_areas` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `ospfAreaId` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfAuthType` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `ospfImportAsExtern` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `ospfSpfRuns` int(11) NOT NULL, `ospfAreaBdrRtrCount` int(11) NOT NULL, `ospfAsBdrRtrCount` int(11) NOT NULL, `ospfAreaLsaCount` int(11) NOT NULL, `ospfAreaLsaCksumSum` int(11) NOT NULL, `ospfAreaSummary` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `ospfAreaStatus` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, UNIQUE KEY `id` (`id`), UNIQUE KEY `device_area` (`device_id`,`ospfAreaId`,`context_name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ospf_instances` -- DROP TABLE IF EXISTS `ospf_instances`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ospf_instances` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `ospf_instance_id` int(11) NOT NULL, `ospfRouterId` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfAdminStat` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfVersionNumber` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfAreaBdrRtrStatus` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfASBdrRtrStatus` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfExternLsaCount` int(11) NOT NULL, `ospfExternLsaCksumSum` int(11) NOT NULL, `ospfTOSSupport` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfOriginateNewLsas` int(11) NOT NULL, `ospfRxNewLsas` int(11) NOT NULL, `ospfExtLsdbLimit` int(11) DEFAULT NULL, `ospfMulticastExtensions` int(11) DEFAULT NULL, `ospfExitOverflowInterval` int(11) DEFAULT NULL, `ospfDemandExtensions` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, UNIQUE KEY `id` (`id`), UNIQUE KEY `device_id` (`device_id`,`ospf_instance_id`,`context_name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ospf_nbrs` -- DROP TABLE IF EXISTS `ospf_nbrs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ospf_nbrs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `port_id` int(11) NOT NULL, `ospf_nbr_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfNbrIpAddr` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfNbrAddressLessIndex` int(11) NOT NULL, `ospfNbrRtrId` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfNbrOptions` int(11) NOT NULL, `ospfNbrPriority` int(11) NOT NULL, `ospfNbrState` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfNbrEvents` int(11) NOT NULL, `ospfNbrLsRetransQLen` int(11) NOT NULL, `ospfNbmaNbrStatus` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfNbmaNbrPermanence` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfNbrHelloSuppressed` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, UNIQUE KEY `id` (`id`), UNIQUE KEY `device_id` (`device_id`,`ospf_nbr_id`,`context_name`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ospf_ports` -- DROP TABLE IF EXISTS `ospf_ports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ospf_ports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `port_id` int(11) NOT NULL, `ospf_port_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfIfIpAddress` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfAddressLessIf` int(11) NOT NULL, `ospfIfAreaId` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ospfIfType` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `ospfIfAdminStat` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `ospfIfRtrPriority` int(11) DEFAULT NULL, `ospfIfTransitDelay` int(11) DEFAULT NULL, `ospfIfRetransInterval` int(11) DEFAULT NULL, `ospfIfHelloInterval` int(11) DEFAULT NULL, `ospfIfRtrDeadInterval` int(11) DEFAULT NULL, `ospfIfPollInterval` int(11) DEFAULT NULL, `ospfIfState` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `ospfIfDesignatedRouter` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `ospfIfBackupDesignatedRouter` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `ospfIfEvents` int(11) DEFAULT NULL, `ospfIfAuthKey` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `ospfIfStatus` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `ospfIfMulticastForwarding` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `ospfIfDemand` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `ospfIfAuthType` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, UNIQUE KEY `id` (`id`), UNIQUE KEY `device_id` (`device_id`,`ospf_port_id`,`context_name`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `packages` -- DROP TABLE IF EXISTS `packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `packages` ( `pkg_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `manager` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `status` tinyint(1) NOT NULL, `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `build` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `arch` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `size` bigint(20) DEFAULT NULL, PRIMARY KEY (`pkg_id`), UNIQUE KEY `unique_key` (`device_id`,`name`,`manager`,`arch`,`version`,`build`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pdb_ix` -- DROP TABLE IF EXISTS `pdb_ix`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pdb_ix` ( `pdb_ix_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ix_id` int(10) unsigned NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `asn` int(10) unsigned NOT NULL, `timestamp` int(10) unsigned NOT NULL, PRIMARY KEY (`pdb_ix_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pdb_ix_peers` -- DROP TABLE IF EXISTS `pdb_ix_peers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pdb_ix_peers` ( `pdb_ix_peers_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ix_id` int(10) unsigned NOT NULL, `peer_id` int(10) unsigned NOT NULL, `remote_asn` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `remote_ipaddr4` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `remote_ipaddr6` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `timestamp` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`pdb_ix_peers_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `perf_times` -- DROP TABLE IF EXISTS `perf_times`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `perf_times` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `doing` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `start` int(11) NOT NULL, `duration` double(8,2) NOT NULL, `devices` int(11) NOT NULL, `poller` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `type` (`type`) ) ENGINE=InnoDB AUTO_INCREMENT=2443861 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `plugins` -- DROP TABLE IF EXISTS `plugins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `plugins` ( `plugin_id` int(11) NOT NULL AUTO_INCREMENT, `plugin_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `plugin_active` int(11) NOT NULL, PRIMARY KEY (`plugin_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `poller_groups` -- DROP TABLE IF EXISTS `poller_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `poller_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `descr` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pollers` -- DROP TABLE IF EXISTS `pollers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pollers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `poller_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `last_polled` datetime NOT NULL, `devices` int(11) NOT NULL, `time_taken` double NOT NULL, PRIMARY KEY (`poller_name`), KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `port_association_mode` -- DROP TABLE IF EXISTS `port_association_mode`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `port_association_mode` ( `pom_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(12) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`pom_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ports` -- DROP TABLE IF EXISTS `ports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ports` ( `port_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL DEFAULT '0', `port_descr_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `port_descr_descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `port_descr_circuit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `port_descr_speed` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `port_descr_notes` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ifDescr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ifName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `portName` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `ifIndex` bigint(20) DEFAULT '0', `ifSpeed` bigint(20) DEFAULT NULL, `ifConnectorPresent` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL, `ifPromiscuousMode` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL, `ifHighSpeed` int(11) DEFAULT NULL, `ifOperStatus` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `ifOperStatus_prev` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `ifAdminStatus` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `ifAdminStatus_prev` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `ifDuplex` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL, `ifMtu` int(11) DEFAULT NULL, `ifType` text COLLATE utf8_unicode_ci, `ifAlias` text COLLATE utf8_unicode_ci, `ifPhysAddress` text COLLATE utf8_unicode_ci, `ifHardType` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `ifLastChange` bigint(20) unsigned NOT NULL DEFAULT '0', `ifVlan` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `ifTrunk` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `ifVrf` int(11) NOT NULL DEFAULT '0', `counter_in` int(11) DEFAULT NULL, `counter_out` int(11) DEFAULT NULL, `ignore` tinyint(1) NOT NULL DEFAULT '0', `disabled` tinyint(1) NOT NULL DEFAULT '0', `detailed` tinyint(1) NOT NULL DEFAULT '0', `deleted` tinyint(1) NOT NULL DEFAULT '0', `pagpOperationMode` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `pagpPortState` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `pagpPartnerDeviceId` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL, `pagpPartnerLearnMethod` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `pagpPartnerIfIndex` int(11) DEFAULT NULL, `pagpPartnerGroupIfIndex` int(11) DEFAULT NULL, `pagpPartnerDeviceName` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `pagpEthcOperationMode` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `pagpDeviceId` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL, `pagpGroupIfIndex` int(11) DEFAULT NULL, `ifInUcastPkts` bigint(20) DEFAULT NULL, `ifInUcastPkts_prev` bigint(20) DEFAULT NULL, `ifInUcastPkts_delta` bigint(20) DEFAULT NULL, `ifInUcastPkts_rate` int(11) DEFAULT NULL, `ifOutUcastPkts` bigint(20) DEFAULT NULL, `ifOutUcastPkts_prev` bigint(20) DEFAULT NULL, `ifOutUcastPkts_delta` bigint(20) DEFAULT NULL, `ifOutUcastPkts_rate` int(11) DEFAULT NULL, `ifInErrors` bigint(20) DEFAULT NULL, `ifInErrors_prev` bigint(20) DEFAULT NULL, `ifInErrors_delta` bigint(20) DEFAULT NULL, `ifInErrors_rate` int(11) DEFAULT NULL, `ifOutErrors` bigint(20) DEFAULT NULL, `ifOutErrors_prev` bigint(20) DEFAULT NULL, `ifOutErrors_delta` bigint(20) DEFAULT NULL, `ifOutErrors_rate` int(11) DEFAULT NULL, `ifInOctets` bigint(20) DEFAULT NULL, `ifInOctets_prev` bigint(20) DEFAULT NULL, `ifInOctets_delta` bigint(20) DEFAULT NULL, `ifInOctets_rate` bigint(20) DEFAULT NULL, `ifOutOctets` bigint(20) DEFAULT NULL, `ifOutOctets_prev` bigint(20) DEFAULT NULL, `ifOutOctets_delta` bigint(20) DEFAULT NULL, `ifOutOctets_rate` bigint(20) DEFAULT NULL, `poll_time` int(11) DEFAULT NULL, `poll_prev` int(11) DEFAULT NULL, `poll_period` int(11) DEFAULT NULL, PRIMARY KEY (`port_id`), UNIQUE KEY `device_ifIndex` (`device_id`,`ifIndex`), KEY `if_2` (`ifDescr`) ) ENGINE=InnoDB AUTO_INCREMENT=10603 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ports_adsl` -- DROP TABLE IF EXISTS `ports_adsl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ports_adsl` ( `port_id` int(11) NOT NULL, `port_adsl_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `adslLineCoding` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `adslLineType` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `adslAtucInvVendorID` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `adslAtucInvVersionNumber` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `adslAtucCurrSnrMgn` decimal(5,1) NOT NULL, `adslAtucCurrAtn` decimal(5,1) NOT NULL, `adslAtucCurrOutputPwr` decimal(5,1) NOT NULL, `adslAtucCurrAttainableRate` int(11) NOT NULL, `adslAtucChanCurrTxRate` int(11) NOT NULL, `adslAturInvSerialNumber` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `adslAturInvVendorID` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `adslAturInvVersionNumber` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `adslAturChanCurrTxRate` int(11) NOT NULL, `adslAturCurrSnrMgn` decimal(5,1) NOT NULL, `adslAturCurrAtn` decimal(5,1) NOT NULL, `adslAturCurrOutputPwr` decimal(5,1) NOT NULL, `adslAturCurrAttainableRate` int(11) NOT NULL, UNIQUE KEY `interface_id` (`port_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ports_fdb` -- DROP TABLE IF EXISTS `ports_fdb`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ports_fdb` ( `id` int(11) NOT NULL AUTO_INCREMENT, `port_id` int(11) unsigned NOT NULL, `mac_address` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `vlan_id` int(11) unsigned NOT NULL, `device_id` int(11) unsigned NOT NULL, UNIQUE KEY `id` (`id`), KEY `mac_address` (`mac_address`), KEY `ports_fdb_port_id_index` (`port_id`), KEY `ports_fdb_device_id_index` (`device_id`), KEY `ports_fdb_vlan_id_index` (`vlan_id`) ) ENGINE=InnoDB AUTO_INCREMENT=50431 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ports_perms` -- DROP TABLE IF EXISTS `ports_perms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ports_perms` ( `user_id` int(11) NOT NULL, `port_id` int(11) NOT NULL, `access_level` int(11) NOT NULL, PRIMARY KEY (`user_id`,`port_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ports_stack` -- DROP TABLE IF EXISTS `ports_stack`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ports_stack` ( `device_id` int(11) NOT NULL, `port_id_high` int(11) NOT NULL, `port_id_low` int(11) NOT NULL, `ifStackStatus` varchar(32) COLLATE utf8_unicode_ci NOT NULL, UNIQUE KEY `device_id` (`device_id`,`port_id_high`,`port_id_low`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ports_statistics` -- DROP TABLE IF EXISTS `ports_statistics`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ports_statistics` ( `port_id` int(11) NOT NULL, `ifInNUcastPkts` bigint(20) DEFAULT NULL, `ifInNUcastPkts_prev` bigint(20) DEFAULT NULL, `ifInNUcastPkts_delta` bigint(20) DEFAULT NULL, `ifInNUcastPkts_rate` int(11) DEFAULT NULL, `ifOutNUcastPkts` bigint(20) DEFAULT NULL, `ifOutNUcastPkts_prev` bigint(20) DEFAULT NULL, `ifOutNUcastPkts_delta` bigint(20) DEFAULT NULL, `ifOutNUcastPkts_rate` int(11) DEFAULT NULL, `ifInDiscards` bigint(20) DEFAULT NULL, `ifInDiscards_prev` bigint(20) DEFAULT NULL, `ifInDiscards_delta` bigint(20) DEFAULT NULL, `ifInDiscards_rate` int(11) DEFAULT NULL, `ifOutDiscards` bigint(20) DEFAULT NULL, `ifOutDiscards_prev` bigint(20) DEFAULT NULL, `ifOutDiscards_delta` bigint(20) DEFAULT NULL, `ifOutDiscards_rate` int(11) DEFAULT NULL, `ifInUnknownProtos` bigint(20) DEFAULT NULL, `ifInUnknownProtos_prev` bigint(20) DEFAULT NULL, `ifInUnknownProtos_delta` bigint(20) DEFAULT NULL, `ifInUnknownProtos_rate` int(11) DEFAULT NULL, `ifInBroadcastPkts` bigint(20) DEFAULT NULL, `ifInBroadcastPkts_prev` bigint(20) DEFAULT NULL, `ifInBroadcastPkts_delta` bigint(20) DEFAULT NULL, `ifInBroadcastPkts_rate` int(11) DEFAULT NULL, `ifOutBroadcastPkts` bigint(20) DEFAULT NULL, `ifOutBroadcastPkts_prev` bigint(20) DEFAULT NULL, `ifOutBroadcastPkts_delta` bigint(20) DEFAULT NULL, `ifOutBroadcastPkts_rate` int(11) DEFAULT NULL, `ifInMulticastPkts` bigint(20) DEFAULT NULL, `ifInMulticastPkts_prev` bigint(20) DEFAULT NULL, `ifInMulticastPkts_delta` bigint(20) DEFAULT NULL, `ifInMulticastPkts_rate` int(11) DEFAULT NULL, `ifOutMulticastPkts` bigint(20) DEFAULT NULL, `ifOutMulticastPkts_prev` bigint(20) DEFAULT NULL, `ifOutMulticastPkts_delta` bigint(20) DEFAULT NULL, `ifOutMulticastPkts_rate` int(11) DEFAULT NULL, PRIMARY KEY (`port_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ports_stp` -- DROP TABLE IF EXISTS `ports_stp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ports_stp` ( `port_stp_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `port_id` int(11) NOT NULL, `priority` tinyint(3) unsigned NOT NULL, `state` varchar(11) COLLATE utf8_unicode_ci NOT NULL, `enable` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `pathCost` int(10) unsigned NOT NULL, `designatedRoot` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `designatedCost` smallint(5) unsigned NOT NULL, `designatedBridge` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `designatedPort` mediumint(9) NOT NULL, `forwardTransitions` int(10) unsigned NOT NULL, PRIMARY KEY (`port_stp_id`), UNIQUE KEY `device_id` (`device_id`,`port_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3421 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ports_vlans` -- DROP TABLE IF EXISTS `ports_vlans`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ports_vlans` ( `port_vlan_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `port_id` int(11) NOT NULL, `vlan` int(11) NOT NULL, `baseport` int(11) NOT NULL, `priority` bigint(32) NOT NULL, `state` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `cost` int(11) NOT NULL, `untagged` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`port_vlan_id`), UNIQUE KEY `unique` (`device_id`,`port_id`,`vlan`) ) ENGINE=InnoDB AUTO_INCREMENT=9007 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `processes` -- DROP TABLE IF EXISTS `processes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `processes` ( `device_id` int(11) NOT NULL, `pid` int(255) NOT NULL, `vsz` int(255) NOT NULL, `rss` int(255) NOT NULL, `cputime` varchar(12) COLLATE utf8_unicode_ci NOT NULL, `user` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `command` text COLLATE utf8_unicode_ci NOT NULL, KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `processors` -- DROP TABLE IF EXISTS `processors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `processors` ( `processor_id` int(11) NOT NULL AUTO_INCREMENT, `entPhysicalIndex` int(11) NOT NULL DEFAULT '0', `hrDeviceIndex` int(11) DEFAULT NULL, `device_id` int(11) NOT NULL, `processor_oid` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `processor_index` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `processor_type` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `processor_usage` int(11) NOT NULL, `processor_descr` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `processor_precision` int(11) NOT NULL DEFAULT '1', `processor_perc_warn` int(11) DEFAULT '75', PRIMARY KEY (`processor_id`), KEY `device_id` (`device_id`), KEY `device_id_2` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `proxmox` -- DROP TABLE IF EXISTS `proxmox`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `proxmox` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL DEFAULT '0', `vmid` int(11) NOT NULL, `cluster` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `cluster_vm` (`cluster`,`vmid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `proxmox_ports` -- DROP TABLE IF EXISTS `proxmox_ports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `proxmox_ports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `vm_id` int(11) NOT NULL, `port` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `vm_port` (`vm_id`,`port`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pseudowires` -- DROP TABLE IF EXISTS `pseudowires`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pseudowires` ( `pseudowire_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `port_id` int(11) NOT NULL, `peer_device_id` int(11) NOT NULL, `peer_ldp_id` int(11) NOT NULL, `cpwVcID` int(11) NOT NULL, `cpwOid` int(11) NOT NULL, `pw_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `pw_psntype` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `pw_local_mtu` int(11) NOT NULL, `pw_peer_mtu` int(11) NOT NULL, `pw_descr` varchar(128) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`pseudowire_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `route` -- DROP TABLE IF EXISTS `route`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `route` ( `device_id` int(11) NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `ipRouteDest` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `ipRouteIfIndex` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL, `ipRouteMetric` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `ipRouteNextHop` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `ipRouteType` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `ipRouteProto` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `discoveredAt` int(11) NOT NULL, `ipRouteMask` varchar(256) COLLATE utf8_unicode_ci NOT NULL, KEY `device` (`device_id`,`context_name`,`ipRouteDest`(255),`ipRouteNextHop`(255)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sensors` -- DROP TABLE IF EXISTS `sensors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sensors` ( `sensor_id` int(11) NOT NULL AUTO_INCREMENT, `sensor_deleted` tinyint(1) NOT NULL DEFAULT '0', `sensor_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `device_id` int(11) unsigned NOT NULL DEFAULT '0', `poller_type` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'snmp', `sensor_oid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `sensor_index` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `sensor_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `sensor_descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `sensor_divisor` bigint(20) NOT NULL DEFAULT '1', `sensor_multiplier` int(11) NOT NULL DEFAULT '1', `sensor_current` float DEFAULT NULL, `sensor_limit` float DEFAULT NULL, `sensor_limit_warn` float DEFAULT NULL, `sensor_limit_low` float DEFAULT NULL, `sensor_limit_low_warn` float DEFAULT NULL, `sensor_alert` tinyint(1) NOT NULL DEFAULT '1', `sensor_custom` enum('No','Yes') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No', `entPhysicalIndex` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `entPhysicalIndex_measured` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `sensor_prev` float DEFAULT NULL, `user_func` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`sensor_id`), KEY `sensor_host` (`device_id`), KEY `sensor_class` (`sensor_class`), KEY `sensor_type` (`sensor_type`), CONSTRAINT `sensors_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1909 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sensors_to_state_indexes` -- DROP TABLE IF EXISTS `sensors_to_state_indexes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sensors_to_state_indexes` ( `sensors_to_state_translations_id` int(11) NOT NULL AUTO_INCREMENT, `sensor_id` int(11) NOT NULL, `state_index_id` int(11) NOT NULL, PRIMARY KEY (`sensors_to_state_translations_id`), UNIQUE KEY `sensor_id_state_index_id` (`sensor_id`,`state_index_id`), KEY `state_index_id` (`state_index_id`), CONSTRAINT `sensors_to_state_indexes_ibfk_2` FOREIGN KEY (`state_index_id`) REFERENCES `state_indexes` (`state_index_id`), CONSTRAINT `sensors_to_state_indexes_sensor_id_foreign` FOREIGN KEY (`sensor_id`) REFERENCES `sensors` (`sensor_id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=24136 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `services` -- DROP TABLE IF EXISTS `services`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `services` ( `service_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `service_ip` text COLLATE utf8_unicode_ci NOT NULL, `service_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `service_desc` text COLLATE utf8_unicode_ci NOT NULL, `service_param` text COLLATE utf8_unicode_ci NOT NULL, `service_ignore` tinyint(1) NOT NULL, `service_status` tinyint(4) NOT NULL DEFAULT '0', `service_changed` int(11) NOT NULL DEFAULT '0', `service_message` text COLLATE utf8_unicode_ci NOT NULL, `service_disabled` tinyint(1) NOT NULL DEFAULT '0', `service_ds` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Data Sources available for this service', PRIMARY KEY (`service_id`), KEY `service_host` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `session` -- DROP TABLE IF EXISTS `session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `session` ( `session_id` int(11) NOT NULL AUTO_INCREMENT, `session_username` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `session_value` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `session_token` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `session_auth` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `session_expiry` int(11) NOT NULL, PRIMARY KEY (`session_id`), UNIQUE KEY `session_value` (`session_value`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `slas` -- DROP TABLE IF EXISTS `slas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `slas` ( `sla_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `sla_nr` int(11) NOT NULL, `owner` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rtt_type` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(1) NOT NULL, `opstatus` tinyint(1) NOT NULL DEFAULT '0', `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`sla_id`), UNIQUE KEY `unique_key` (`device_id`,`sla_nr`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `state_indexes` -- DROP TABLE IF EXISTS `state_indexes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `state_indexes` ( `state_index_id` int(11) NOT NULL AUTO_INCREMENT, `state_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`state_index_id`), UNIQUE KEY `state_name` (`state_name`) ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `state_translations` -- DROP TABLE IF EXISTS `state_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `state_translations` ( `state_translation_id` int(11) NOT NULL AUTO_INCREMENT, `state_index_id` int(11) NOT NULL, `state_descr` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `state_draw_graph` tinyint(1) NOT NULL, `state_value` smallint(5) NOT NULL DEFAULT '0', `state_generic_value` tinyint(1) NOT NULL, `state_lastupdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`state_translation_id`), UNIQUE KEY `state_index_id_value` (`state_index_id`,`state_value`) ) ENGINE=InnoDB AUTO_INCREMENT=373 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `storage` -- DROP TABLE IF EXISTS `storage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `storage` ( `storage_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `storage_mib` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `storage_index` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `storage_type` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `storage_descr` text COLLATE utf8_unicode_ci NOT NULL, `storage_size` bigint(20) NOT NULL, `storage_units` int(11) NOT NULL, `storage_used` bigint(20) NOT NULL DEFAULT '0', `storage_free` bigint(20) NOT NULL DEFAULT '0', `storage_perc` int(11) NOT NULL DEFAULT '0', `storage_perc_warn` int(11) DEFAULT '60', `storage_deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`storage_id`), UNIQUE KEY `index_unique` (`device_id`,`storage_mib`,`storage_index`), KEY `device_id` (`device_id`), KEY `device_id_2` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=229 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `stp` -- DROP TABLE IF EXISTS `stp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `stp` ( `stp_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `rootBridge` tinyint(1) NOT NULL, `bridgeAddress` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `protocolSpecification` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `priority` mediumint(9) NOT NULL, `timeSinceTopologyChange` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `topChanges` mediumint(9) NOT NULL, `designatedRoot` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `rootCost` mediumint(9) NOT NULL, `rootPort` mediumint(9) NOT NULL, `maxAge` mediumint(9) NOT NULL, `helloTime` mediumint(9) NOT NULL, `holdTime` mediumint(9) NOT NULL, `forwardDelay` mediumint(9) NOT NULL, `bridgeMaxAge` smallint(6) NOT NULL, `bridgeHelloTime` smallint(6) NOT NULL, `bridgeForwardDelay` smallint(6) NOT NULL, PRIMARY KEY (`stp_id`), KEY `stp_host` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `syslog` -- DROP TABLE IF EXISTS `syslog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `syslog` ( `device_id` int(11) DEFAULT NULL, `facility` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `priority` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `level` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `tag` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `program` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `msg` text COLLATE utf8_unicode_ci, `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`seq`), KEY `datetime` (`timestamp`), KEY `device_id` (`device_id`), KEY `program` (`program`), KEY `priority_level` (`priority`,`level`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tnmsneinfo` -- DROP TABLE IF EXISTS `tnmsneinfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tnmsneinfo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `neID` int(32) NOT NULL, `neType` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `neName` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `neLocation` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `neAlarm` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `neOpMode` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `neOpState` varchar(128) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `device_id` (`device_id`), KEY `neID` (`neID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `toner` -- DROP TABLE IF EXISTS `toner`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `toner` ( `toner_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL DEFAULT '0', `toner_index` int(11) NOT NULL, `toner_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `toner_oid` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `toner_descr` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `toner_capacity` int(11) NOT NULL DEFAULT '0', `toner_current` int(11) NOT NULL DEFAULT '0', `toner_capacity_oid` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`toner_id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ucd_diskio` -- DROP TABLE IF EXISTS `ucd_diskio`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ucd_diskio` ( `diskio_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `diskio_index` int(11) NOT NULL, `diskio_descr` varchar(32) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`diskio_id`), KEY `device_id` (`device_id`), KEY `device_id_2` (`device_id`) ) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL, `realname` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `descr` char(30) COLLATE utf8_unicode_ci NOT NULL, `level` tinyint(4) NOT NULL DEFAULT '0', `can_modify_passwd` tinyint(4) NOT NULL DEFAULT '1', `created_at` timestamp NOT NULL DEFAULT '1970-01-01 23:00:01', `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `users_prefs` -- DROP TABLE IF EXISTS `users_prefs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users_prefs` ( `user_id` int(16) NOT NULL, `pref` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `value` varchar(128) COLLATE utf8_unicode_ci NOT NULL, UNIQUE KEY `user_id.pref` (`user_id`,`pref`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `users_widgets` -- DROP TABLE IF EXISTS `users_widgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users_widgets` ( `user_widget_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `widget_id` int(11) NOT NULL, `col` tinyint(4) NOT NULL, `row` tinyint(4) NOT NULL, `size_x` tinyint(4) NOT NULL, `size_y` tinyint(4) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `refresh` tinyint(4) NOT NULL DEFAULT '60', `settings` text COLLATE utf8_unicode_ci NOT NULL, `dashboard_id` int(11) NOT NULL, PRIMARY KEY (`user_widget_id`), KEY `user_id` (`user_id`,`widget_id`) ) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vlans` -- DROP TABLE IF EXISTS `vlans`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vlans` ( `vlan_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) DEFAULT NULL, `vlan_vlan` int(11) DEFAULT NULL, `vlan_domain` int(11) DEFAULT NULL, `vlan_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `vlan_type` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `vlan_mtu` int(11) DEFAULT NULL, PRIMARY KEY (`vlan_id`), KEY `device_id` (`device_id`,`vlan_vlan`) ) ENGINE=InnoDB AUTO_INCREMENT=3289 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vminfo` -- DROP TABLE IF EXISTS `vminfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vminfo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `vm_type` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'vmware', `vmwVmVMID` int(11) NOT NULL, `vmwVmDisplayName` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `vmwVmGuestOS` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `vmwVmMemSize` int(11) NOT NULL, `vmwVmCpus` int(11) NOT NULL, `vmwVmState` varchar(128) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `device_id` (`device_id`), KEY `vmwVmVMID` (`vmwVmVMID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vrf_lite_cisco` -- DROP TABLE IF EXISTS `vrf_lite_cisco`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vrf_lite_cisco` ( `vrf_lite_cisco_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `context_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `intance_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT '', `vrf_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT 'Default', PRIMARY KEY (`vrf_lite_cisco_id`), KEY `vrf` (`vrf_name`), KEY `context` (`context_name`), KEY `device` (`device_id`), KEY `mix` (`device_id`,`context_name`,`vrf_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vrfs` -- DROP TABLE IF EXISTS `vrfs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vrfs` ( `vrf_id` int(11) NOT NULL AUTO_INCREMENT, `vrf_oid` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `vrf_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `mplsVpnVrfRouteDistinguisher` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `mplsVpnVrfDescription` text COLLATE utf8_unicode_ci NOT NULL, `device_id` int(11) NOT NULL, PRIMARY KEY (`vrf_id`), KEY `device_id` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `widgets` -- DROP TABLE IF EXISTS `widgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `widgets` ( `widget_id` int(11) NOT NULL AUTO_INCREMENT, `widget_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `widget` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `base_dimensions` varchar(10) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`widget_id`), UNIQUE KEY `widget` (`widget`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wireless_sensors` -- DROP TABLE IF EXISTS `wireless_sensors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wireless_sensors` ( `sensor_id` int(11) NOT NULL AUTO_INCREMENT, `sensor_deleted` tinyint(1) NOT NULL DEFAULT '0', `sensor_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `device_id` int(11) unsigned NOT NULL DEFAULT '0', `sensor_index` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `sensor_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `sensor_descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `sensor_divisor` int(11) NOT NULL DEFAULT '1', `sensor_multiplier` int(11) NOT NULL DEFAULT '1', `sensor_aggregator` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'sum', `sensor_current` float DEFAULT NULL, `sensor_prev` float DEFAULT NULL, `sensor_limit` float DEFAULT NULL, `sensor_limit_warn` float DEFAULT NULL, `sensor_limit_low` float DEFAULT NULL, `sensor_limit_low_warn` float DEFAULT NULL, `sensor_alert` tinyint(1) NOT NULL DEFAULT '1', `sensor_custom` enum('No','Yes') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No', `entPhysicalIndex` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `entPhysicalIndex_measured` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `sensor_oids` text COLLATE utf8_unicode_ci NOT NULL, `access_point_id` int(11) DEFAULT NULL, PRIMARY KEY (`sensor_id`), KEY `sensor_class` (`sensor_class`), KEY `sensor_host` (`device_id`), KEY `sensor_type` (`sensor_type`), CONSTRAINT `wireless_sensors_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!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 2018-01-24 10:47:54