- -- 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