WebApps/Observium_CE
1
0
Fork 0
Code Pull Requests Activity
Observium_CE/update/db_schema_mysql.sql

3825 lines
121 KiB
SQL
Raw Permalink Blame History

--
-- Generation Time: Aug 21, 2019 at 03:38 PM
--
--
-- Initial Observium DB schema for clean install
--
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 utf8 */;
-- --------------------------------------------------------
--
-- Table structure for table `accesspoints`
--
CREATE TABLE `accesspoints` (
`accesspoint_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`radio_number` tinyint(4) DEFAULT NULL,
`type` varchar(16) NOT NULL,
`mac_addr` varchar(24) NOT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Access Points';
-- --------------------------------------------------------
--
-- Table structure for table `accesspoints-state`
--
CREATE TABLE `accesspoints-state` (
`accesspoint_id` int(11) NOT NULL,
`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
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Access Points';
-- --------------------------------------------------------
--
-- Table structure for table `alerts_maint`
--
CREATE TABLE `alerts_maint` (
`maint_id` int(11) NOT NULL,
`maint_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`maint_descr` text COLLATE utf8_unicode_ci NOT NULL,
`maint_start` int(11) NOT NULL,
`maint_end` int(11) NOT NULL,
`maint_global` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `alerts_maint_assoc`
--
CREATE TABLE `alerts_maint_assoc` (
`maint_assoc_id` int(11) NOT NULL,
`maint_id` int(11) NOT NULL,
`entity_type` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`entity_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `alert_assoc`
--
CREATE TABLE `alert_assoc` (
`alert_assoc_id` int(11) NOT NULL,
`alert_test_id` int(11) NOT NULL,
`entity_type` varchar(64) CHARACTER SET utf8 NOT NULL,
`device_attribs` text COLLATE utf8_unicode_ci DEFAULT NULL,
`entity_attribs` text CHARACTER SET utf8 DEFAULT NULL,
`enable` tinyint(1) NOT NULL DEFAULT 1,
`alerter` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`severity` int(11) DEFAULT NULL,
`count` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `alert_contacts`
--
CREATE TABLE `alert_contacts` (
`contact_id` int(11) NOT NULL,
`contact_descr` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`contact_method` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`contact_endpoint` text COLLATE utf8_unicode_ci NOT NULL,
`contact_disabled` tinyint(1) NOT NULL DEFAULT 0,
`contact_disabled_until` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `alert_contacts_assoc`
--
CREATE TABLE `alert_contacts_assoc` (
`aca_id` int(11) NOT NULL,
`aca_type` enum('alert','syslog') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'alert',
`alert_checker_id` int(11) NOT NULL,
`contact_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `alert_log`
--
CREATE TABLE `alert_log` (
`event_id` int(11) NOT NULL,
`alert_test_id` int(11) DEFAULT NULL,
`device_id` int(11) NOT NULL DEFAULT 0,
`timestamp` datetime DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci DEFAULT NULL,
`entity_type` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`entity_id` int(11) NOT NULL,
`log_type` enum('ALERT_NOTIFY','FAIL','FAIL_DELAYED','FAIL_SUPPRESSED','OK','RECOVER_NOTIFY','RECOVER_SUPPRESSED') COLLATE utf8_unicode_ci DEFAULT NULL,
`notified` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `alert_table`
--
CREATE TABLE `alert_table` (
`alert_table_id` int(11) NOT NULL,
`alert_test_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`entity_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`entity_id` int(11) NOT NULL,
`alert_assocs` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`delay` int(11) NOT NULL,
`ignore_until` datetime DEFAULT NULL,
`ignore_until_ok` tinyint(1) DEFAULT NULL,
`last_checked` int(10) DEFAULT NULL,
`last_changed` int(10) DEFAULT NULL,
`last_recovered` int(10) DEFAULT NULL,
`last_ok` int(10) DEFAULT NULL,
`last_failed` int(10) DEFAULT NULL,
`has_alerted` tinyint(1) NOT NULL,
`last_message` varchar(128) CHARACTER SET utf8 NOT NULL,
`alert_status` tinyint(4) NOT NULL DEFAULT -1,
`last_alerted` int(11) NOT NULL,
`state` varchar(512) CHARACTER SET utf8 NOT NULL,
`count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `alert_tests`
--
CREATE TABLE `alert_tests` (
`alert_test_id` int(11) NOT NULL,
`entity_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`alert_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`alert_message` text COLLATE utf8_unicode_ci NOT NULL,
`alert_assoc` text COLLATE utf8_unicode_ci DEFAULT NULL,
`conditions` text CHARACTER SET utf8 NOT NULL,
`conditions_warn` text COLLATE utf8_unicode_ci DEFAULT NULL,
`and` tinyint(1) NOT NULL DEFAULT 1,
`severity` enum('crit','err') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'crit',
`delay` int(11) DEFAULT 0,
`alerter` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`enable` tinyint(1) NOT NULL DEFAULT 1,
`show_frontpage` int(1) NOT NULL DEFAULT 1,
`suppress_recovery` tinyint(1) DEFAULT 0,
`ignore_until` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `applications`
--
CREATE TABLE `applications` (
`app_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`app_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`app_instance` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`app_state` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'UNKNOWN',
`app_status` varchar(8) CHARACTER SET utf8 NOT NULL,
`app_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`app_lastpolled` int(11) NOT NULL DEFAULT 0,
`app_json` text COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'JSON array of application data'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `applications-state`
--
CREATE TABLE `applications-state` (
`application_id` int(11) NOT NULL,
`app_last_polled` int(11) NOT NULL,
`app_status` tinyint(1) NOT NULL,
`app_state` varchar(1024) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `authlog`
--
CREATE TABLE `authlog` (
`id` int(11) NOT NULL,
`datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user` text CHARACTER SET utf8 NOT NULL,
`address` text CHARACTER SET utf8 NOT NULL,
`user_agent` text CHARACTER SET utf8 DEFAULT NULL,
`result` text CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `bgpPeers`
--
CREATE TABLE `bgpPeers` (
`bgpPeer_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`local_as` int(10) UNSIGNED DEFAULT NULL,
`astext` varchar(255) CHARACTER SET utf8 NOT NULL,
`reverse_dns` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`peer_device_id` int(10) UNSIGNED DEFAULT NULL,
`bgpPeerIdentifier` varchar(39) CHARACTER SET utf8 NOT NULL,
`bgpPeerRemoteAs` int(11) UNSIGNED NOT NULL,
`bgpPeerState` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',
`bgpPeerAdminStatus` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',
`bgpPeerLocalAddr` varchar(39) CHARACTER SET utf8 NOT NULL,
`bgpPeerRemoteAddr` varchar(39) CHARACTER SET utf8 NOT NULL,
`bgpPeer_polled` int(11) NOT NULL,
`bgpPeerInUpdates` int(11) DEFAULT NULL,
`bgpPeerOutUpdates` int(11) DEFAULT NULL,
`bgpPeerInTotalMessages` int(11) DEFAULT NULL,
`bgpPeerOutTotalMessages` int(11) DEFAULT NULL,
`bgpPeerFsmEstablishedTime` int(11) DEFAULT NULL,
`bgpPeerInUpdateElapsedTime` int(11) DEFAULT NULL,
`bgpPeerInUpdates_delta` int(11) DEFAULT NULL,
`bgpPeerInUpdates_rate` int(11) DEFAULT NULL,
`bgpPeerOutUpdates_delta` int(11) DEFAULT NULL,
`bgpPeerOutUpdates_rate` int(11) DEFAULT NULL,
`bgpPeerInTotalMessages_delta` int(11) DEFAULT NULL,
`bgpPeerInTotalMessages_rate` int(11) DEFAULT NULL,
`bgpPeerOutTotalMessages_delta` int(11) DEFAULT NULL,
`bgpPeerOutTotalMessages_rate` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `bgpPeers_cbgp`
--
CREATE TABLE `bgpPeers_cbgp` (
`cbgp_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`bgpPeer_id` int(11) NOT NULL,
`bgpPeerIndex` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`afi` varchar(16) CHARACTER SET utf8 NOT NULL,
`safi` varchar(16) CHARACTER SET utf8 NOT NULL,
`AcceptedPrefixes` int(11) DEFAULT NULL,
`DeniedPrefixes` int(11) DEFAULT NULL,
`PrefixAdminLimit` int(11) DEFAULT NULL,
`PrefixThreshold` int(11) DEFAULT NULL,
`PrefixClearThreshold` int(11) DEFAULT NULL,
`AdvertisedPrefixes` int(11) DEFAULT NULL,
`SuppressedPrefixes` int(11) DEFAULT NULL,
`WithdrawnPrefixes` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `bills`
--
CREATE TABLE `bills` (
`bill_id` int(11) NOT NULL,
`bill_name` text CHARACTER SET utf8 NOT NULL,
`bill_type` text CHARACTER SET utf8 NOT NULL,
`bill_cdr` bigint(20) DEFAULT NULL,
`bill_day` int(11) NOT NULL DEFAULT 1,
`bill_quota` bigint(20) DEFAULT NULL,
`bill_polled` int(11) 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) CHARACTER SET utf8 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) CHARACTER SET utf8 NOT NULL,
`bill_contact` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`bill_threshold` int(11) DEFAULT NULL,
`bill_notify` tinyint(1) NOT NULL DEFAULT 0,
`bill_ref` varchar(64) CHARACTER SET utf8 NOT NULL,
`bill_notes` varchar(256) CHARACTER SET utf8 NOT NULL,
`bill_autoadded` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `bill_data`
--
CREATE TABLE `bill_data` (
`bill_data_id` int(11) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `bill_entities`
--
CREATE TABLE `bill_entities` (
`bill_ent_id` int(11) NOT NULL,
`bill_id` int(11) NOT NULL,
`entity_id` int(11) NOT NULL,
`bill_port_autoadded` tinyint(1) NOT NULL DEFAULT 0,
`bill_port_polled` int(11) NOT NULL,
`bill_port_period` int(11) NOT NULL,
`bill_port_counter_in` bigint(20) DEFAULT NULL,
`bill_port_delta_in` bigint(20) DEFAULT NULL,
`bill_port_counter_out` bigint(20) DEFAULT NULL,
`bill_port_delta_out` bigint(20) DEFAULT NULL,
`entity_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'port'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `bill_history`
--
CREATE TABLE `bill_history` (
`bill_hist_id` int(11) NOT NULL,
`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 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) 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 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cef_prefix`
--
CREATE TABLE `cef_prefix` (
`cef_pfx_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`entPhysicalIndex` int(11) NOT NULL,
`afi` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
`cef_pfx` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `cef_switching`
--
CREATE TABLE `cef_switching` (
`cef_switching_id` int(11) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `config`
--
CREATE TABLE `config` (
`config_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`config_value` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `counters`
--
CREATE TABLE `counters` (
`counter_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`poller_type` enum('snmp','agent','ipmi') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'snmp',
`counter_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`counter_oid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`counter_mib` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`counter_object` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`counter_index` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`counter_descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`counter_unit` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`counter_multiplier` float NOT NULL DEFAULT 1,
`counter_limit` float DEFAULT NULL,
`counter_limit_warn` float DEFAULT NULL,
`counter_limit_low` float DEFAULT NULL,
`counter_limit_low_warn` float DEFAULT NULL,
`counter_limit_by` enum('sec','min','5min','hour','value') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '5min',
`counter_custom_limit` tinyint(1) NOT NULL DEFAULT 0,
`entPhysicalIndex_measured` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`measured_class` enum('port','outlet','printersupply') COLLATE utf8_unicode_ci DEFAULT NULL,
`measured_entity` int(11) DEFAULT NULL,
`entPhysicalIndex` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`entPhysicalClass` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`counter_ignore` tinyint(1) NOT NULL DEFAULT 0,
`counter_disable` tinyint(1) NOT NULL DEFAULT 0,
`counter_deleted` tinyint(1) NOT NULL DEFAULT 0,
`counter_value` double(14,5) DEFAULT NULL,
`counter_rate` float(14,5) DEFAULT NULL,
`counter_rate_5min` float(14,5) DEFAULT NULL,
`counter_rate_hour` float(14,5) DEFAULT NULL,
`counter_history` text CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`counter_event` enum('ok','warning','alert','ignore') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ignore',
`counter_status` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`counter_polled` int(11) DEFAULT NULL,
`counter_last_change` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `customers`
--
CREATE TABLE `customers` (
`customer_id` int(11) NOT NULL,
`username` char(64) CHARACTER SET utf8 NOT NULL,
`password` char(32) CHARACTER SET utf8 NOT NULL,
`string` char(64) CHARACTER SET utf8 NOT NULL,
`level` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `dashboards`
--
CREATE TABLE `dashboards` (
`dash_id` int(11) NOT NULL,
`dash_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `dash_widgets`
--
CREATE TABLE `dash_widgets` (
`widget_id` int(11) NOT NULL,
`dash_id` int(11) NOT NULL,
`widget_type` varchar(32) NOT NULL,
`widget_config` text NOT NULL,
`x` int(11) DEFAULT NULL,
`y` int(11) DEFAULT NULL,
`width` int(11) NOT NULL,
`height` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `devices`
--
CREATE TABLE `devices` (
`device_id` int(11) NOT NULL,
`poller_id` int(11) NOT NULL DEFAULT 0,
`hostname` varchar(253) COLLATE utf8_unicode_ci NOT NULL,
`sysName` varchar(253) COLLATE utf8_unicode_ci DEFAULT NULL,
`snmp_community` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`snmp_authlevel` enum('noAuthNoPriv','authNoPriv','authPriv') CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`snmp_authname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`snmp_authpass` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`snmp_authalgo` enum('MD5','SHA') CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`snmp_cryptopass` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`snmp_cryptoalgo` enum('AES','DES') CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`snmp_context` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`snmp_version` enum('v1','v2c','v3') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'v2c',
`snmp_port` smallint(5) UNSIGNED NOT NULL DEFAULT 161,
`snmp_timeout` int(11) DEFAULT NULL,
`snmp_retries` int(11) DEFAULT NULL,
`snmp_maxrep` int(11) DEFAULT NULL,
`ssh_port` int(11) NOT NULL DEFAULT 22,
`agent_version` int(11) DEFAULT NULL,
`snmp_transport` enum('udp','tcp','udp6','tcp6') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'udp',
`bgpLocalAs` int(11) UNSIGNED DEFAULT NULL,
`snmpEngineID` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`sysObjectID` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`sysDescr` text COLLATE utf8_unicode_ci DEFAULT NULL,
`sysContact` text COLLATE utf8_unicode_ci DEFAULT NULL,
`version` text COLLATE utf8_unicode_ci DEFAULT NULL,
`hardware` text COLLATE utf8_unicode_ci DEFAULT NULL,
`vendor` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT 'Hardware vendor',
`features` text COLLATE utf8_unicode_ci DEFAULT NULL,
`location` text COLLATE utf8_unicode_ci DEFAULT NULL,
`os` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT 0,
`status_type` enum('ping','snmp','dns','ok') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'ok',
`ignore` tinyint(4) NOT NULL DEFAULT 0,
`ignore_until` datetime DEFAULT NULL,
`asset_tag` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`disabled` tinyint(1) NOT NULL DEFAULT 0,
`uptime` int(11) UNSIGNED DEFAULT NULL,
`last_rebooted` int(10) UNSIGNED DEFAULT NULL,
`force_discovery` tinyint(1) NOT NULL DEFAULT 0,
`last_polled` timestamp NULL DEFAULT NULL,
`last_discovered` timestamp NULL DEFAULT NULL,
`last_alerter` timestamp NULL DEFAULT NULL,
`last_polled_timetaken` double(5,2) DEFAULT NULL,
`last_discovered_timetaken` double(5,2) DEFAULT NULL,
`purpose` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`serial` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`device_state` text COLLATE utf8_unicode_ci DEFAULT NULL,
`distro` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`distro_ver` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`kernel` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`arch` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `devices_locations`
--
CREATE TABLE `devices_locations` (
`location_id` int(11) UNSIGNED NOT NULL,
`device_id` int(11) NOT NULL,
`location` text COLLATE utf8_unicode_ci DEFAULT NULL,
`location_lat` decimal(10,7) DEFAULT NULL,
`location_lon` decimal(10,7) DEFAULT NULL,
`location_country` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`location_state` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`location_county` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`location_city` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`location_geoapi` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`location_status` text COLLATE utf8_unicode_ci DEFAULT NULL,
`location_manual` tinyint(1) NOT NULL DEFAULT 0,
`location_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores geo location information';
-- --------------------------------------------------------
--
-- Table structure for table `devices_mibs`
--
CREATE TABLE `devices_mibs` (
`mib_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`mib` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Latin charset for 1byte chars!',
`object` text CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Table or Object or Numeric. Latin charset for 1byte chars!',
`use` enum('mib','object') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`disabled` tinyint(1) NOT NULL DEFAULT 0,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores disabled MIBs or combination MIB with tables/oids';
-- --------------------------------------------------------
--
-- Table structure for table `device_graphs`
--
CREATE TABLE `device_graphs` (
`device_graph_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`graph` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`enabled` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `eigrp_ases`
--
CREATE TABLE `eigrp_ases` (
`eigrp_as_id` int(11) NOT NULL,
`eigrp_vpn` int(11) NOT NULL,
`eigrp_as` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`cEigrpNbrCount` int(11) NOT NULL,
`cEigrpAsRouterIdType` enum('unknown','ipv4','ipv6','ipv4z','ipv6z','dns') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ipv4',
`cEigrpAsRouterId` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`cEigrpTopoRoutes` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `eigrp_peers`
--
CREATE TABLE `eigrp_peers` (
`eigrp_peer_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`eigrp_vpn` int(11) NOT NULL,
`eigrp_as` int(11) NOT NULL,
`peer_addrtype` enum('unknown','ipv4','ipv6','ipv4z','ipv6z','dns') COLLATE utf8_unicode_ci NOT NULL COMMENT 'inetAddrType',
`peer_addr` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`peer_ifindex` int(11) NOT NULL,
`peer_holdtime` int(11) NOT NULL,
`peer_uptime` int(11) NOT NULL,
`peer_srtt` int(11) NOT NULL,
`peer_rto` int(11) NOT NULL,
`peer_version` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `eigrp_ports`
--
CREATE TABLE `eigrp_ports` (
`eigrp_port_id` int(11) NOT NULL,
`eigrp_vpn` int(11) NOT NULL,
`eigrp_as` int(11) NOT NULL,
`eigrp_ifIndex` int(11) NOT NULL,
`port_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`eigrp_peer_count` int(11) NOT NULL,
`eigrp_MeanSrtt` int(11) NOT NULL,
`eigrp_authmode` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `eigrp_vpns`
--
CREATE TABLE `eigrp_vpns` (
`eigrp_vpn_id` int(11) NOT NULL,
`eigrp_vpn` int(11) NOT NULL,
`eigrp_vpn_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`device_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `entity_attribs`
--
CREATE TABLE `entity_attribs` (
`attrib_id` int(11) NOT NULL,
`device_id` int(11) DEFAULT NULL,
`entity_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`entity_id` int(11) NOT NULL,
`attrib_type` varchar(128) CHARACTER SET utf8 NOT NULL,
`attrib_value` text CHARACTER SET utf8 NOT NULL,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `entity_permissions`
--
CREATE TABLE `entity_permissions` (
`perm_id` int(11) NOT NULL,
`user_id` bigint(20) NOT NULL,
`entity_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`entity_id` int(11) NOT NULL,
`access_level` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `entPhysical`
--
CREATE TABLE `entPhysical` (
`entPhysical_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`inventory_mib` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`entPhysicalIndex` int(11) NOT NULL,
`entPhysicalDescr` text CHARACTER SET utf8 NOT NULL,
`entPhysicalClass` text CHARACTER SET utf8 NOT NULL,
`entPhysicalName` text CHARACTER SET utf8 NOT NULL,
`entPhysicalHardwareRev` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`entPhysicalFirmwareRev` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`entPhysicalSoftwareRev` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`entPhysicalAlias` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
`entPhysicalAssetID` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
`entPhysicalIsFRU` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
`entPhysicalModelName` text CHARACTER SET utf8 NOT NULL,
`entPhysicalVendorType` text CHARACTER SET utf8 DEFAULT NULL,
`entPhysicalSerialNum` text CHARACTER SET utf8 NOT NULL,
`entPhysicalContainedIn` int(11) NOT NULL,
`entPhysicalParentRelPos` int(11) NOT NULL,
`entPhysicalMfgName` text CHARACTER SET utf8 NOT NULL,
`ifIndex` int(11) DEFAULT NULL,
`deleted` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `entPhysical-state`
--
CREATE TABLE `entPhysical-state` (
`entPhysical_state_id` int(11) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `eventlog`
--
CREATE TABLE `eventlog` (
`event_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`message` text CHARACTER SET utf8 DEFAULT NULL,
`entity_type` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
`entity_id` int(64) DEFAULT NULL,
`severity` tinyint(4) NOT NULL DEFAULT 6
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE `groups` (
`group_id` int(11) NOT NULL,
`entity_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`group_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`group_descr` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`group_assoc` text COLLATE utf8_unicode_ci DEFAULT NULL,
`group_menu` tinyint(1) NOT NULL DEFAULT 0,
`group_ignore` tinyint(4) NOT NULL,
`group_ignore_until` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `groups_assoc`
--
CREATE TABLE `groups_assoc` (
`group_assoc_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`entity_type` varchar(64) CHARACTER SET utf8 NOT NULL,
`device_attribs` text COLLATE utf8_unicode_ci DEFAULT NULL,
`entity_attribs` text CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `group_table`
--
CREATE TABLE `group_table` (
`group_table_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`entity_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`entity_id` int(11) NOT NULL,
`group_assocs` varchar(64) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `hrDevice`
--
CREATE TABLE `hrDevice` (
`hrDevice_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`hrDeviceIndex` int(11) NOT NULL,
`hrDeviceDescr` text CHARACTER SET utf8 NOT NULL,
`hrDeviceType` varchar(32) CHARACTER SET utf8 NOT NULL,
`hrDeviceErrors` int(11) NOT NULL,
`hrDeviceStatus` varchar(16) CHARACTER SET utf8 NOT NULL,
`hrProcessorLoad` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ipsec_tunnels`
--
CREATE TABLE `ipsec_tunnels` (
`tunnel_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`tunnel_index` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`tunnel_ike_index` varchar(64) COLLATE utf8_unicode_ci DEFAULT 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,
`tunnel_ike_alive` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
`tunnel_lifetime` int(11) DEFAULT NULL,
`tunnel_ike_lifetime` int(11) DEFAULT NULL,
`tunnel_json` text COLLATE utf8_unicode_ci DEFAULT NULL,
`tunnel_endpoint` text COLLATE utf8_unicode_ci DEFAULT NULL,
`tunnel_endhash` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`tunnel_added` int(11) DEFAULT NULL,
`mib` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`tunnel_deleted` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ipv4_addresses`
--
CREATE TABLE `ipv4_addresses` (
`ipv4_address_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`ipv4_address` varchar(32) CHARACTER SET utf8 NOT NULL,
`ipv4_binary` varbinary(4) DEFAULT NULL,
`ipv4_prefixlen` int(11) NOT NULL,
`ipv4_network_id` int(11) NOT NULL,
`port_id` int(11) NOT NULL DEFAULT 0,
`ifIndex` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ipv4_networks`
--
CREATE TABLE `ipv4_networks` (
`ipv4_network_id` int(11) NOT NULL,
`ipv4_network` varchar(64) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ipv6_addresses`
--
CREATE TABLE `ipv6_addresses` (
`ipv6_address_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`ipv6_address` varchar(128) CHARACTER SET utf8 NOT NULL,
`ipv6_binary` varbinary(16) DEFAULT NULL,
`ipv6_compressed` varchar(128) CHARACTER SET utf8 NOT NULL,
`ipv6_prefixlen` int(11) NOT NULL,
`ipv6_origin` varchar(16) CHARACTER SET utf8 NOT NULL,
`ipv6_network_id` int(11) NOT NULL,
`port_id` int(11) NOT NULL DEFAULT 0,
`ifIndex` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ipv6_networks`
--
CREATE TABLE `ipv6_networks` (
`ipv6_network_id` int(11) NOT NULL,
`ipv6_network` varchar(132) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ip_mac`
--
CREATE TABLE `ip_mac` (
`mac_id` int(11) NOT NULL,
`port_id` int(11) NOT NULL,
`mac_address` char(12) NOT NULL,
`ip_address` varchar(39) NOT NULL,
`ip_version` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `juniAtmVp`
--
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) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `lb_pools`
--
CREATE TABLE `lb_pools` (
`pool_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`pool_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`pool_lb` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`num_members` int(11) NOT NULL,
`active_members` int(11) NOT NULL,
`pool_conns` int(11) NOT NULL,
`pool_bps_in` int(11) NOT NULL,
`pool_bps_out` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `lb_pool_members`
--
CREATE TABLE `lb_pool_members` (
`member_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`member_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`pool_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`member_ip` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`member_port` int(8) NOT NULL,
`member_state` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
`member_enabled` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`member_conns` int(11) NOT NULL,
`member_bps_in` int(11) NOT NULL,
`member_bps_out` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `lb_snatpools`
--
CREATE TABLE `lb_snatpools` (
`snatpool_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`snatpool_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`snatpool_conns` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `lb_virtuals`
--
CREATE TABLE `lb_virtuals` (
`virt_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`virt_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`virt_ip` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`virt_mask` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`virt_port` int(8) NOT NULL,
`virt_proto` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`virt_type` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`virt_pool` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`virt_rules` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
`virt_enabled` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
`virt_state` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`virt_conns` int(11) NOT NULL,
`virt_bps_in` int(11) NOT NULL,
`virt_bps_out` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `loadbalancer_rservers`
--
CREATE TABLE `loadbalancer_rservers` (
`rserver_id` int(11) NOT NULL,
`rserver_index` varchar(128) CHARACTER SET utf8 NOT NULL,
`device_id` int(11) NOT NULL,
`StateDescr` varchar(64) CHARACTER SET utf8 NOT NULL,
`state` text CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `loadbalancer_vservers`
--
CREATE TABLE `loadbalancer_vservers` (
`classmap_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`classmap` varchar(128) CHARACTER SET utf8 NOT NULL,
`classmap_index` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`serverstate` varchar(64) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `mac_accounting`
--
CREATE TABLE `mac_accounting` (
`ma_id` int(11) NOT NULL,
`port_id` int(11) NOT NULL,
`vlan_id` int(11) NOT NULL DEFAULT 0,
`device_id` int(11) NOT NULL,
`mac` varchar(32) CHARACTER SET utf8 NOT NULL,
`bytes_input` bigint(20) DEFAULT NULL,
`bytes_input_delta` bigint(20) DEFAULT NULL,
`bytes_input_rate` int(11) DEFAULT NULL,
`bytes_output` bigint(20) DEFAULT NULL,
`bytes_output_delta` bigint(20) DEFAULT NULL,
`bytes_output_rate` int(11) DEFAULT NULL,
`pkts_input` bigint(20) DEFAULT NULL,
`pkts_input_delta` bigint(20) DEFAULT NULL,
`pkts_input_rate` int(11) DEFAULT NULL,
`pkts_output` bigint(20) DEFAULT NULL,
`pkts_output_delta` bigint(20) DEFAULT NULL,
`pkts_output_rate` int(11) DEFAULT NULL,
`poll_time` int(11) DEFAULT NULL,
`poll_period` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `mempools`
--
CREATE TABLE `mempools` (
`mempool_id` int(11) NOT NULL,
`mempool_index` varchar(64) CHARACTER SET utf8 NOT NULL,
`entPhysicalIndex` int(11) DEFAULT NULL,
`hrDeviceIndex` int(11) DEFAULT NULL,
`mempool_mib` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`mempool_multiplier` float(14,5) NOT NULL DEFAULT 1.00000,
`mempool_hc` tinyint(1) NOT NULL DEFAULT 0,
`mempool_descr` varchar(255) CHARACTER SET utf8 NOT NULL,
`device_id` int(11) NOT NULL,
`mempool_deleted` tinyint(1) NOT NULL DEFAULT 0,
`mempool_warn_limit` int(11) DEFAULT NULL,
`mempool_crit_limit` int(11) DEFAULT NULL,
`mempool_ignore` int(11) DEFAULT NULL,
`mempool_table` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`mempool_polled` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `munin_plugins`
--
CREATE TABLE `munin_plugins` (
`mplug_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`mplug_type` varchar(128) 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 DEFAULT NULL,
`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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `munin_plugins_ds`
--
CREATE TABLE `munin_plugins_ds` (
`mplug_ds_id` int(11) NOT NULL,
`mplug_id` int(11) NOT NULL,
`ds_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_type` enum('COUNTER','ABSOLUTE','DERIVE','GAUGE') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'GAUGE',
`ds_label` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_cdef` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_draw` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_graph` enum('no','yes') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'yes',
`ds_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_extinfo` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_max` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_min` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_negative` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_warning` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_critical` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_colour` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_sum` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_stack` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ds_line` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `neighbours`
--
CREATE TABLE `neighbours` (
`neighbour_id` int(11) NOT NULL,
`device_id` int(11) DEFAULT 0,
`port_id` int(11) DEFAULT NULL,
`remote_port_id` int(11) DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT 1,
`protocol` varchar(11) CHARACTER SET utf8 DEFAULT NULL,
`remote_hostname` varchar(253) CHARACTER SET utf8 NOT NULL,
`remote_port` varchar(128) CHARACTER SET utf8 NOT NULL,
`remote_platform` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
`remote_version` text COLLATE utf8_unicode_ci DEFAULT NULL,
`remote_address` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `netscaler_servicegroupmembers`
--
CREATE TABLE `netscaler_servicegroupmembers` (
`svc_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`svc_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`svc_groupname` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`svc_fullname` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`svc_label` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`svc_ip` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`svc_port` int(8) NOT NULL,
`svc_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`svc_state` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`svc_clients` int(11) NOT NULL,
`svc_server` int(11) NOT NULL,
`svc_req_rate` int(11) NOT NULL,
`svc_bps_in` int(11) NOT NULL,
`svc_bps_out` int(11) NOT NULL,
`svc_ignore` tinyint(1) NOT NULL DEFAULT 0,
`svc_ignore_until` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `netscaler_services`
--
CREATE TABLE `netscaler_services` (
`svc_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`svc_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`svc_fullname` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`svc_label` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`svc_ip` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`svc_port` int(8) NOT NULL,
`svc_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`svc_state` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`svc_clients` int(11) NOT NULL,
`svc_server` int(11) NOT NULL,
`svc_req_rate` int(11) NOT NULL,
`svc_bps_in` int(11) NOT NULL,
`svc_bps_out` int(11) NOT NULL,
`svc_ignore` tinyint(1) NOT NULL DEFAULT 0,
`svc_ignore_until` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `netscaler_services_vservers`
--
CREATE TABLE `netscaler_services_vservers` (
`sv_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`vsvr_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`svc_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`service_weight` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `netscaler_vservers`
--
CREATE TABLE `netscaler_vservers` (
`vsvr_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`vsvr_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`vsvr_fullname` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`vsvr_label` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`vsvr_ip` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`vsvr_ipv6` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`vsvr_port` int(8) NOT NULL,
`vsvr_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`vsvr_entitytype` varchar(32) COLLATE utf8_unicode_ci DEFAULT 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,
`vsvr_ignore` tinyint(1) NOT NULL DEFAULT 0,
`vsvr_ignore_until` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `notifications_queue`
--
CREATE TABLE `notifications_queue` (
`notification_id` bigint(20) UNSIGNED NOT NULL,
`device_id` int(11) DEFAULT NULL,
`log_id` int(10) UNSIGNED NOT NULL,
`aca_type` enum('alert','syslog','web') NOT NULL,
`severity` tinyint(4) NOT NULL DEFAULT 6,
`endpoints` text NOT NULL,
`endpoints_result` text DEFAULT NULL,
`message_tags` text NOT NULL,
`message_graphs` blob DEFAULT NULL,
`notification_added` int(11) NOT NULL,
`notification_lifetime` int(11) NOT NULL DEFAULT 300,
`notification_entry` text DEFAULT NULL,
`notification_locked` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `observium_attribs`
--
CREATE TABLE `observium_attribs` (
`attrib_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`attrib_value` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `observium_attribs`
--
INSERT INTO `observium_attribs` (`attrib_type`, `attrib_value`) VALUES
('dbSchema', '416');
-- --------------------------------------------------------
--
-- Table structure for table `observium_processes`
--
CREATE TABLE `observium_processes` (
`process_id` int(11) UNSIGNED NOT NULL,
`process_pid` int(11) NOT NULL,
`process_ppid` int(11) NOT NULL,
`process_uid` int(11) NOT NULL,
`process_command` text NOT NULL,
`process_name` varchar(32) NOT NULL,
`process_start` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`poller_id` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `oids`
--
CREATE TABLE `oids` (
`oid_id` int(11) NOT NULL,
`oid` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
`oid_type` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
`oid_descr` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`oid_name` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
`oid_unit` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`oid_symbol` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
`oid_logy` tinyint(1) NOT NULL DEFAULT 0,
`oid_kibi` tinyint(1) NOT NULL DEFAULT 0,
`oid_autodiscover` tinyint(1) NOT NULL DEFAULT 1,
`oid_thresh_scheme` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`oid_alert_low` bigint(20) DEFAULT NULL,
`oid_warn_low` bigint(20) DEFAULT NULL,
`oid_warn_high` bigint(20) DEFAULT NULL,
`oid_alert_high` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `oids_entries`
--
CREATE TABLE `oids_entries` (
`oid_entry_id` int(11) NOT NULL,
`oid_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`value` float NOT NULL,
`timestamp` int(11) NOT NULL,
`raw_value` bigint(16) NOT NULL,
`event` enum('ok','warn','alert','ignore') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ignore',
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`alert_low` bigint(20) DEFAULT NULL,
`warn_low` bigint(20) DEFAULT NULL,
`warn_high` bigint(20) DEFAULT NULL,
`alert_high` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ospf_areas`
--
CREATE TABLE `ospf_areas` (
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ospf_instances`
--
CREATE TABLE `ospf_instances` (
`ospf_instance_id` int(11) NOT NULL,
`device_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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ospf_nbrs`
--
CREATE TABLE `ospf_nbrs` (
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ospf_ports`
--
CREATE TABLE `ospf_ports` (
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `p2p_radios`
--
CREATE TABLE `p2p_radios` (
`radio_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`radio_mib` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`radio_index` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`radio_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`radio_standard` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
`radio_modulation` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
`radio_rx_level` float DEFAULT NULL,
`radio_tx_power` float DEFAULT NULL,
`radio_rx_freq` int(11) DEFAULT NULL,
`radio_tx_freq` int(11) DEFAULT NULL,
`radio_bandwidth` int(11) DEFAULT NULL,
`radio_e1t1_channels` int(11) DEFAULT NULL,
`radio_total_capacity` int(11) DEFAULT NULL,
`radio_cur_capacity` int(11) DEFAULT NULL,
`radio_eth_capacity` int(11) DEFAULT NULL,
`radio_loopback` tinyint(1) DEFAULT NULL,
`radio_tx_mute` tinyint(1) DEFAULT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `packages`
--
CREATE TABLE `packages` (
`pkg_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`name` varchar(96) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`manager` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '1',
`status` tinyint(1) NOT NULL,
`version` varchar(96) COLLATE utf8_unicode_ci DEFAULT NULL,
`build` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`arch` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`size` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `pollers`
--
CREATE TABLE `pollers` (
`poller_id` int(11) NOT NULL,
`poller_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`poller_stats` text COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ports`
--
CREATE TABLE `ports` (
`port_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL DEFAULT 0,
`port_64bit` tinyint(1) DEFAULT NULL,
`port_label` varchar(128) DEFAULT NULL,
`port_label_base` varchar(128) DEFAULT NULL,
`port_label_num` varchar(64) DEFAULT NULL,
`port_label_short` varchar(96) DEFAULT NULL,
`port_descr_type` varchar(24) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`port_descr_descr` varchar(255) DEFAULT NULL,
`port_descr_circuit` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`port_descr_speed` varchar(32) DEFAULT NULL,
`port_descr_notes` varchar(255) DEFAULT NULL,
`ifDescr` varchar(255) DEFAULT NULL,
`ifName` varchar(64) DEFAULT NULL,
`ifIndex` int(11) UNSIGNED NOT NULL,
`ifSpeed` bigint(20) DEFAULT NULL,
`ifConnectorPresent` varchar(12) DEFAULT NULL,
`ifPromiscuousMode` varchar(12) DEFAULT NULL,
`ifHighSpeed` int(10) UNSIGNED DEFAULT NULL,
`ifOperStatus` enum('testing','notPresent','dormant','down','lowerLayerDown','unknown','up','monitoring') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ifAdminStatus` enum('down','up','testing') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ifDuplex` varchar(12) DEFAULT NULL,
`ifMtu` int(11) DEFAULT NULL,
`ifType` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ifAlias` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ifPhysAddress` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ifHardType` varchar(64) DEFAULT NULL,
`ifLastChange` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ifVlan` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ifTrunk` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ifVrf` int(16) DEFAULT NULL,
`encrypted` tinyint(1) NOT NULL DEFAULT 0,
`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,
`ifInUcastPkts` bigint(20) UNSIGNED DEFAULT NULL,
`ifInUcastPkts_rate` int(11) UNSIGNED NOT NULL DEFAULT 0,
`ifOutUcastPkts` bigint(20) UNSIGNED DEFAULT NULL,
`ifOutUcastPkts_rate` int(11) UNSIGNED NOT NULL DEFAULT 0,
`ifInErrors` bigint(20) UNSIGNED DEFAULT NULL,
`ifInErrors_rate` float UNSIGNED NOT NULL DEFAULT 0,
`ifOutErrors` bigint(20) UNSIGNED DEFAULT NULL,
`ifOutErrors_rate` float UNSIGNED NOT NULL DEFAULT 0,
`ifOctets_rate` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`ifUcastPkts_rate` int(11) UNSIGNED NOT NULL DEFAULT 0,
`ifErrors_rate` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
`ifInOctets` bigint(20) UNSIGNED DEFAULT NULL,
`ifInOctets_rate` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`ifOutOctets` bigint(20) UNSIGNED DEFAULT NULL,
`ifOutOctets_rate` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`ifInOctets_perc` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
`ifOutOctets_perc` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
`poll_time` int(11) UNSIGNED NOT NULL DEFAULT 0,
`poll_period` int(11) UNSIGNED NOT NULL DEFAULT 300,
`ifInErrors_delta` int(10) UNSIGNED NOT NULL DEFAULT 0,
`ifOutErrors_delta` int(10) UNSIGNED NOT NULL DEFAULT 0,
`ifInNUcastPkts` bigint(20) UNSIGNED DEFAULT NULL,
`ifInNUcastPkts_rate` int(11) UNSIGNED DEFAULT NULL,
`ifOutNUcastPkts` bigint(20) UNSIGNED DEFAULT NULL,
`ifOutNUcastPkts_rate` int(11) UNSIGNED DEFAULT NULL,
`ifInBroadcastPkts` bigint(20) UNSIGNED DEFAULT NULL,
`ifInBroadcastPkts_rate` int(11) UNSIGNED DEFAULT NULL,
`ifOutBroadcastPkts` bigint(20) UNSIGNED DEFAULT NULL,
`ifOutBroadcastPkts_rate` int(11) UNSIGNED DEFAULT NULL,
`ifInMulticastPkts` bigint(20) UNSIGNED DEFAULT NULL,
`ifInMulticastPkts_rate` int(11) UNSIGNED DEFAULT NULL,
`ifOutMulticastPkts` bigint(20) UNSIGNED DEFAULT NULL,
`ifOutMulticastPkts_rate` int(11) UNSIGNED DEFAULT NULL,
`port_mcbc` tinyint(1) DEFAULT NULL,
`ifInDiscards` bigint(20) UNSIGNED DEFAULT NULL,
`ifInDiscards_rate` int(11) UNSIGNED DEFAULT NULL,
`ifOutDiscards` bigint(20) UNSIGNED DEFAULT NULL,
`ifOutDiscards_rate` int(11) UNSIGNED DEFAULT NULL,
`ifDiscards_rate` int(11) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ports_adsl`
--
CREATE TABLE `ports_adsl` (
`port_id` int(11) NOT NULL,
`port_adsl_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`adslLineCoding` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`adslLineType` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`adslAtucInvVendorID` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`adslAtucInvVersionNumber` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`adslAturInvVendorID` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`adslAturInvVersionNumber` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ports_cbqos`
--
CREATE TABLE `ports_cbqos` (
`cbqos_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`port_id` int(11) NOT NULL,
`direction` varchar(16) NOT NULL,
`PrePolicyPkt` bigint(20) NOT NULL,
`PrePolicyPkt_rate` int(11) NOT NULL,
`PrePolicyByte` bigint(20) NOT NULL,
`PrePolicyByte_rate` int(11) NOT NULL,
`PostPolicyByte` bigint(20) NOT NULL,
`PostPolicyByte_rate` int(11) NOT NULL,
`DropPkt` bigint(20) NOT NULL,
`DropPkt_rate` int(11) NOT NULL,
`DropByte` bigint(20) NOT NULL,
`DropByte_rate` int(11) NOT NULL,
`NoBufDropPkt` bigint(20) NOT NULL,
`NoBufDropPkt_rate` int(11) NOT NULL,
`cbqos_lastpolled` int(11) NOT NULL,
`policy_index` int(11) UNSIGNED NOT NULL,
`object_index` int(11) UNSIGNED NOT NULL,
`policy_name` varchar(64) NOT NULL,
`object_name` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ports_stack`
--
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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ports_vlans`
--
CREATE TABLE `ports_vlans` (
`port_vlan_id` int(11) NOT NULL,
`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) CHARACTER SET utf8 NOT NULL,
`cost` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `printersupplies`
--
CREATE TABLE `printersupplies` (
`supply_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL DEFAULT 0,
`supply_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`supply_index` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`supply_mib` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`supply_oid` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`supply_descr` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`supply_colour` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`supply_capacity` int(11) NOT NULL,
`supply_value` int(11) NOT NULL,
`supply_capacity_oid` varchar(64) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `processors`
--
CREATE TABLE `processors` (
`processor_id` int(11) NOT NULL,
`entPhysicalIndex` int(11) DEFAULT NULL,
`hrDeviceIndex` int(11) DEFAULT NULL,
`device_id` int(11) NOT NULL,
`processor_oid` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`processor_index` varchar(64) CHARACTER SET utf8 NOT NULL,
`processor_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`processor_descr` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`processor_returns_idle` tinyint(1) NOT NULL DEFAULT 0,
`processor_precision` int(11) NOT NULL DEFAULT 1,
`processor_warn_limit` int(11) DEFAULT NULL,
`processor_warn_count` int(11) DEFAULT NULL,
`processor_crit_limit` int(11) DEFAULT NULL,
`processor_crit_count` int(11) DEFAULT NULL,
`processor_usage` int(11) NOT NULL,
`processor_polled` int(11) NOT NULL,
`processor_ignore` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `pseudowires`
--
CREATE TABLE `pseudowires` (
`pseudowire_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`mib` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'CISCO-IETF-PW-MIB',
`pwIndex` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`pwID` int(11) NOT NULL,
`pwOutboundLabel` int(11) UNSIGNED NOT NULL,
`pwInboundLabel` int(11) UNSIGNED NOT NULL,
`port_id` int(11) NOT NULL,
`peer_device_id` int(11) DEFAULT NULL,
`peer_addr` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`peer_rdns` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`pwType` varchar(32) CHARACTER SET utf8 NOT NULL,
`pwPsnType` varchar(32) CHARACTER SET utf8 NOT NULL,
`pwLocalIfMtu` int(11) UNSIGNED DEFAULT NULL,
`pwRemoteIfMtu` int(11) UNSIGNED DEFAULT NULL,
`pwDescr` varchar(128) CHARACTER SET utf8 NOT NULL,
`pwRemoteIfString` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`pwRowStatus` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',
`pwOperStatus` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`pwLocalStatus` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`pwRemoteStatus` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`pwUptime` int(11) UNSIGNED NOT NULL,
`event` enum('ok','warning','alert','ignore') COLLATE utf8_unicode_ci NOT NULL,
`last_change` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `sensors`
--
CREATE TABLE `sensors` (
`sensor_id` int(11) NOT NULL,
`sensor_deleted` tinyint(1) NOT NULL DEFAULT 0,
`sensor_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`device_id` int(11) NOT NULL DEFAULT 0,
`poller_type` enum('snmp','agent','ipmi') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'snmp',
`sensor_oid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sensor_mib` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`sensor_object` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`sensor_index` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`sensor_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`sensor_descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`sensor_unit` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`sensor_multiplier` float NOT NULL DEFAULT 1,
`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_custom_limit` tinyint(1) NOT NULL DEFAULT 0,
`entPhysicalIndex_measured` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`measured_class` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`measured_entity` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`entPhysicalIndex` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`entPhysicalClass` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`sensor_ignore` tinyint(1) NOT NULL DEFAULT 0,
`sensor_disable` tinyint(1) NOT NULL DEFAULT 0,
`sensor_value` double(14,5) DEFAULT NULL,
`sensor_event` enum('ok','warning','alert','ignore') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ignore',
`sensor_status` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`sensor_polled` int(11) DEFAULT NULL,
`sensor_last_change` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `services`
--
CREATE TABLE `services` (
`service_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`service_ip` text CHARACTER SET utf8 NOT NULL,
`service_type` varchar(16) CHARACTER SET utf8 NOT NULL,
`service_desc` text CHARACTER SET utf8 NOT NULL,
`service_param` text CHARACTER SET utf8 NOT NULL,
`service_ignore` tinyint(1) NOT NULL,
`service_status` tinyint(4) NOT NULL DEFAULT 0,
`service_checked` int(11) NOT NULL DEFAULT 0,
`service_changed` int(11) NOT NULL DEFAULT 0,
`service_message` text CHARACTER SET utf8 NOT NULL,
`service_disabled` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `slas`
--
CREATE TABLE `slas` (
`sla_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`sla_mib` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT 'cisco-rttmon-mib',
`sla_index` varchar(64) CHARACTER SET utf8 NOT NULL,
`sla_owner` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sla_tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sla_target` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`sla_status` varchar(16) CHARACTER SET utf8 NOT NULL,
`sla_limit_high` int(11) NOT NULL DEFAULT 5000,
`sla_limit_high_warn` int(11) NOT NULL DEFAULT 625,
`sla_graph` enum('echo','jitter') COLLATE utf8_unicode_ci DEFAULT NULL,
`rtt_type` varchar(16) CHARACTER SET utf8 NOT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`rtt_value` decimal(11,2) NOT NULL,
`rtt_sense` varchar(32) CHARACTER SET utf8 NOT NULL,
`rtt_event` enum('ok','warning','alert','ignore') CHARACTER SET utf8 NOT NULL,
`rtt_unixtime` int(11) NOT NULL,
`rtt_last_change` int(11) NOT NULL,
`rtt_minimum` decimal(11,2) DEFAULT NULL,
`rtt_maximum` decimal(11,2) DEFAULT NULL,
`rtt_stddev` decimal(11,3) DEFAULT NULL,
`rtt_success` int(11) DEFAULT NULL,
`rtt_loss` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `snmp_errors`
--
CREATE TABLE `snmp_errors` (
`error_id` int(10) UNSIGNED NOT NULL,
`device_id` int(11) NOT NULL,
`error_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
`error_code` int(11) NOT NULL,
`error_reason` varchar(16) NOT NULL DEFAULT '',
`snmp_cmd_exitcode` tinyint(3) UNSIGNED NOT NULL,
`snmp_cmd` enum('snmpget','snmpwalk') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Latin charset for 1byte chars!',
`snmp_options` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Latin charset for 1byte chars!',
`mib_dir` varchar(256) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Latin charset for 1byte chars!',
`mib` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Latin charset for 1byte chars!',
`oid` text CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Latin charset for 1byte chars!',
`added` int(11) UNSIGNED NOT NULL,
`updated` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `status`
--
CREATE TABLE `status` (
`status_id` int(11) NOT NULL,
`status_deleted` tinyint(1) NOT NULL DEFAULT 0,
`device_id` int(11) NOT NULL DEFAULT 0,
`poller_type` enum('snmp','agent','ipmi') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'snmp',
`status_oid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`status_mib` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`status_object` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`status_index` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`status_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`status_descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`entPhysicalIndex` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`entPhysicalClass` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`entPhysicalIndex_measured` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`measured_class` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`measured_entity` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`status_ignore` tinyint(1) NOT NULL DEFAULT 0,
`status_disable` tinyint(1) NOT NULL DEFAULT 0,
`status_value` int(11) DEFAULT NULL,
`status_polled` int(11) NOT NULL,
`status_last_change` int(11) NOT NULL,
`status_event` enum('ok','warning','alert','ignore') CHARACTER SET utf8 NOT NULL DEFAULT 'ignore',
`status_map` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`status_name` varchar(64) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `storage`
--
CREATE TABLE `storage` (
`storage_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`storage_mib` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`storage_index` varchar(64) CHARACTER SET utf8 NOT NULL,
`storage_type` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
`storage_descr` text CHARACTER SET utf8 NOT NULL,
`storage_hc` tinyint(1) NOT NULL DEFAULT 0,
`storage_deleted` tinyint(1) NOT NULL DEFAULT 0,
`storage_warn_limit` int(11) DEFAULT 0,
`storage_crit_limit` int(11) DEFAULT 0,
`storage_ignore` tinyint(1) NOT NULL DEFAULT 0,
`storage_polled` int(11) NOT NULL,
`storage_size` bigint(20) NOT NULL,
`storage_units` int(11) NOT NULL,
`storage_used` bigint(20) NOT NULL,
`storage_free` bigint(20) NOT NULL,
`storage_perc` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `syslog`
--
CREATE TABLE `syslog` (
`device_id` int(11) DEFAULT NULL,
`host` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT 'Hostname or IP received by syslog server',
`facility` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`priority` tinyint(4) NOT NULL DEFAULT 8,
`level` tinyint(4) NOT NULL DEFAULT 8,
`tag` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`program` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
`msg` text CHARACTER SET utf8 DEFAULT NULL,
`seq` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `syslog_alerts`
--
CREATE TABLE `syslog_alerts` (
`lal_id` int(11) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`device_id` int(11) NOT NULL,
`la_id` int(11) NOT NULL,
`syslog_id` int(11) NOT NULL,
`message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`program` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`sev` tinyint(4) NOT NULL DEFAULT 1,
`ack` tinyint(1) NOT NULL DEFAULT 0,
`notified` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `syslog_rules`
--
CREATE TABLE `syslog_rules` (
`la_id` int(11) NOT NULL,
`la_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`la_descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`la_rule` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`la_severity` int(11) NOT NULL DEFAULT 8,
`la_disable` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `syslog_rules_assoc`
--
CREATE TABLE `syslog_rules_assoc` (
`laa_id` int(11) NOT NULL,
`la_id` int(11) NOT NULL,
`entity_type` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`entity_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ucd_diskio`
--
CREATE TABLE `ucd_diskio` (
`diskio_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`diskio_index` int(11) NOT NULL,
`diskio_descr` varchar(32) CHARACTER SET utf8 NOT NULL,
`diskIONReadX` int(11) NOT NULL,
`diskIONReadX_rate` int(11) NOT NULL,
`diskIONWrittenX` int(11) NOT NULL,
`diskIONWrittenX_rate` int(11) NOT NULL,
`diskIOReads` int(11) NOT NULL,
`diskIOReads_rate` int(11) NOT NULL,
`diskIOWrites` int(11) NOT NULL,
`diskIOWrites_rate` int(11) NOT NULL,
`diskio_polled` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`user_id` bigint(20) NOT NULL,
`username` varchar(72) CHARACTER SET utf8 NOT NULL,
`password` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`realname` varchar(255) CHARACTER SET utf8 NOT NULL,
`email` varchar(255) CHARACTER SET utf8 NOT NULL,
`descr` text CHARACTER SET utf8 NOT NULL,
`level` tinyint(4) NOT NULL DEFAULT 0,
`can_modify_passwd` tinyint(4) NOT NULL DEFAULT 1,
`user_options` text CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `users_ckeys`
--
CREATE TABLE `users_ckeys` (
`user_ckey_id` int(11) NOT NULL,
`user_encpass` text COLLATE utf8_unicode_ci NOT NULL,
`expire` int(11) NOT NULL,
`username` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`user_uniq` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`user_ckey` varchar(32) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `users_prefs`
--
CREATE TABLE `users_prefs` (
`pref_id` int(11) NOT NULL,
`user_id` bigint(20) NOT NULL,
`pref` varchar(32) CHARACTER SET utf8 NOT NULL,
`value` varchar(128) CHARACTER SET utf8 NOT NULL,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `vlans`
--
CREATE TABLE `vlans` (
`vlan_id` int(11) NOT NULL,
`device_id` int(11) DEFAULT NULL,
`ifIndex` int(11) DEFAULT NULL,
`vlan_vlan` int(11) DEFAULT NULL,
`vlan_domain` int(11) DEFAULT NULL,
`vlan_name` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
`vlan_type` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
`vlan_mtu` int(11) DEFAULT NULL,
`vlan_status` varchar(16) CHARACTER SET utf8 NOT NULL,
`vlan_context` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `vlans_fdb`
--
CREATE TABLE `vlans_fdb` (
`fdb_id` bigint(20) UNSIGNED NOT NULL,
`device_id` int(11) NOT NULL,
`vlan_id` int(11) NOT NULL,
`port_id` int(11) DEFAULT NULL,
`mac_address` varchar(32) CHARACTER SET utf8 NOT NULL,
`fdb_status` varchar(32) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `vminfo`
--
CREATE TABLE `vminfo` (
`vm_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`vm_type` varchar(16) NOT NULL DEFAULT 'vmware',
`vm_name` varchar(128) DEFAULT NULL,
`vm_guestos` varchar(128) DEFAULT NULL,
`vm_memory` int(11) DEFAULT NULL,
`vm_cpucount` int(11) DEFAULT NULL,
`vm_state` varchar(128) DEFAULT NULL,
`vm_uuid` varchar(64) DEFAULT NULL,
`vm_source` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `vrfs`
--
CREATE TABLE `vrfs` (
`vrf_id` int(11) NOT NULL,
`vrf_oid` varchar(256) CHARACTER SET utf8 NOT NULL,
`vrf_name` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
`mplsVpnVrfRouteDistinguisher` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
`mplsVpnVrfDescription` text CHARACTER SET utf8 NOT NULL,
`device_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wifi_accesspoints`
--
CREATE TABLE `wifi_accesspoints` (
`wifi_accesspoint_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`ap_number` int(11) DEFAULT NULL,
`name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`serial` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`model` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`location` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`fingerprint` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`delete` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wifi_aps`
--
CREATE TABLE `wifi_aps` (
`wifi_ap_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`ap_mib` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`ap_index` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`ap_number` int(11) DEFAULT NULL,
`ap_address` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`ap_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`ap_serial` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`ap_model` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`ap_location` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`ap_fingerprint` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`ap_status` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
`ap_admin_status` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
`ap_uptime` int(11) NOT NULL,
`ap_control_uptime` int(11) NOT NULL,
`ap_control_latency` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wifi_aps_members`
--
CREATE TABLE `wifi_aps_members` (
`wifi_ap_member_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`ap_index_member` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`ap_name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
`ap_member_state` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
`ap_member_admin_state` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`ap_member_conns` int(11) DEFAULT NULL,
`ap_member_channel` int(11) DEFAULT NULL,
`ap_member_radiotype` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wifi_radios`
--
CREATE TABLE `wifi_radios` (
`wifi_radio_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`radio_mib` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`radio_number` int(11) NOT NULL,
`radio_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`radio_protection` varchar(8) COLLATE utf8_unicode_ci DEFAULT 'none',
`radio_bsstype` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`radio_status` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`radio_ap` int(11) DEFAULT NULL,
`radio_clients` int(11) DEFAULT NULL,
`radio_txpower` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
`radio_channel` int(11) DEFAULT NULL,
`radio_util` int(11) DEFAULT NULL,
`radio_mac` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`radio_assoc_clients` int(11) DEFAULT NULL,
`radio_mon_clients` int(11) DEFAULT NULL,
`radio_ht_mode` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
`radio_ht_extchan` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
`radio_ht_chan` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wifi_sessions`
--
CREATE TABLE `wifi_sessions` (
`wifi_session_id` int(11) NOT NULL,
`device_id` int(11) DEFAULT NULL,
`mac_addr` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`session_id` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`username` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`ipv4_addr` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`ssid` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`timestamp` timestamp NULL DEFAULT NULL,
`radio_id` int(11) DEFAULT NULL,
`uptime` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wifi_stations`
--
CREATE TABLE `wifi_stations` (
`wifi_station_id` int(11) NOT NULL,
`rx_bytes` int(11) NOT NULL,
`uptime` int(11) NOT NULL,
`ap_mac` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`assoc_time` int(11) NOT NULL,
`auth_time` int(11) NOT NULL,
`authorized` int(11) NOT NULL,
`bssid` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`bytes` int(11) NOT NULL,
`ccq` int(11) NOT NULL,
`dhcpend_time` int(11) NOT NULL,
`dhcpstart_time` int(11) NOT NULL,
`essid` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`first_seen` int(11) NOT NULL,
`hostname` int(11) NOT NULL,
`idletime` int(11) NOT NULL,
`ip` int(11) NOT NULL,
`is_guest` int(11) NOT NULL,
`noise` int(11) NOT NULL,
`oui` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`powersave` int(11) NOT NULL,
`qos_policy_applied` int(11) NOT NULL,
`radio` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
`rssi` int(11) NOT NULL,
`rx_crypts` int(11) NOT NULL,
`rx_dropped` int(11) NOT NULL,
`rx_errors` int(11) NOT NULL,
`rx_frags` int(11) NOT NULL,
`rx_mcast` int(11) NOT NULL,
`rx_packets` int(11) NOT NULL,
`rx_rate` int(11) NOT NULL,
`rx_retries` int(11) NOT NULL,
`signal` int(11) NOT NULL,
`site_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`state` int(11) NOT NULL,
`state_ht` int(11) NOT NULL,
`tx_bytes` int(11) NOT NULL,
`tx_dropped` int(11) NOT NULL,
`tx_errors` int(11) NOT NULL,
`tx_packets` int(11) NOT NULL,
`tx_power` int(11) NOT NULL,
`tx_rate` int(11) NOT NULL,
`tx_retries` int(11) NOT NULL,
`user_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wifi_wlans`
--
CREATE TABLE `wifi_wlans` (
`wlan_id` int(11) NOT NULL,
`device_id` int(11) NOT NULL,
`wlan_index` int(11) NOT NULL,
`wlan_name` varchar(128) DEFAULT NULL,
`wlan_admin_status` tinyint(1) DEFAULT 1,
`wlan_ssid` varchar(64) DEFAULT NULL,
`wlan_ssid_bcast` tinyint(1) DEFAULT NULL,
`wlan_bssid` varchar(64) DEFAULT NULL,
`wlan_bss_type` varchar(32) DEFAULT NULL,
`wlan_channel` int(11) DEFAULT NULL,
`wlan_dtim_period` int(11) DEFAULT NULL,
`wlan_beacon_period` int(11) DEFAULT NULL,
`wlan_frag_thresh` int(11) DEFAULT NULL,
`wlan_igmp_snoop` tinyint(1) DEFAULT NULL,
`wlan_prot_mode` varchar(32) DEFAULT NULL,
`wlan_radio_mode` varchar(32) DEFAULT NULL,
`wlan_rts_thresh` int(11) DEFAULT NULL,
`wlan_vlan_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `accesspoints`
--
ALTER TABLE `accesspoints`
ADD PRIMARY KEY (`accesspoint_id`),
ADD KEY `deleted` (`deleted`),
ADD KEY `name` (`name`,`radio_number`);
--
-- Indexes for table `accesspoints-state`
--
ALTER TABLE `accesspoints-state`
ADD PRIMARY KEY (`accesspoint_id`);
--
-- Indexes for table `alerts_maint`
--
ALTER TABLE `alerts_maint`
ADD PRIMARY KEY (`maint_id`),
ADD KEY `maint_cache` (`maint_start`,`maint_end`);
--
-- Indexes for table `alerts_maint_assoc`
--
ALTER TABLE `alerts_maint_assoc`
ADD PRIMARY KEY (`maint_assoc_id`),
ADD UNIQUE KEY `unique` (`maint_id`,`entity_type`,`entity_id`),
ADD KEY `maint_id` (`maint_id`);
--
-- Indexes for table `alert_assoc`
--
ALTER TABLE `alert_assoc`
ADD PRIMARY KEY (`alert_assoc_id`);
--
-- Indexes for table `alert_contacts`
--
ALTER TABLE `alert_contacts`
ADD PRIMARY KEY (`contact_id`);
--
-- Indexes for table `alert_contacts_assoc`
--
ALTER TABLE `alert_contacts_assoc`
ADD PRIMARY KEY (`aca_id`);
--
-- Indexes for table `alert_log`
--
ALTER TABLE `alert_log`
ADD PRIMARY KEY (`event_id`),
ADD KEY `type` (`entity_type`),
ADD KEY `device_id` (`device_id`),
ADD KEY `timestamp` (`timestamp`),
ADD KEY `entity` (`entity_type`,`entity_id`),
ADD KEY `alert_device` (`alert_test_id`,`device_id`);
--
-- Indexes for table `alert_table`
--
ALTER TABLE `alert_table`
ADD PRIMARY KEY (`alert_table_id`),
ADD UNIQUE KEY `alert_id_2` (`alert_test_id`,`entity_type`,`entity_id`),
ADD KEY `device_id` (`device_id`),
ADD KEY `alert_cache` (`alert_table_id`,`alert_test_id`,`device_id`,`entity_type`,`entity_id`,`alert_status`);
--
-- Indexes for table `alert_tests`
--
ALTER TABLE `alert_tests`
ADD PRIMARY KEY (`alert_test_id`),
ADD UNIQUE KEY `alert_name` (`alert_name`);
--
-- Indexes for table `applications`
--
ALTER TABLE `applications`
ADD PRIMARY KEY (`app_id`),
ADD UNIQUE KEY `dev_type_inst` (`device_id`,`app_type`,`app_instance`);
--
-- Indexes for table `applications-state`
--
ALTER TABLE `applications-state`
ADD UNIQUE KEY `application_id` (`application_id`);
--
-- Indexes for table `authlog`
--
ALTER TABLE `authlog`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `bgpPeers`
--
ALTER TABLE `bgpPeers`
ADD PRIMARY KEY (`bgpPeer_id`),
ADD KEY `device_id` (`device_id`),
ADD KEY `bgp_cache` (`bgpPeer_id`,`device_id`,`bgpPeerState`,`bgpPeerAdminStatus`,`bgpPeerRemoteAs`),
ADD KEY `bgp_local_peer` (`device_id`,`bgpPeerLocalAddr`),
ADD KEY `bgp_remote_peer` (`device_id`,`bgpPeerRemoteAs`,`bgpPeerRemoteAddr`);
--
-- Indexes for table `bgpPeers_cbgp`
--
ALTER TABLE `bgpPeers_cbgp`
ADD PRIMARY KEY (`cbgp_id`),
ADD UNIQUE KEY `unique_index` (`bgpPeer_id`,`device_id`,`afi`,`safi`);
--
-- Indexes for table `bills`
--
ALTER TABLE `bills`
ADD UNIQUE KEY `bill_id` (`bill_id`);
--
-- Indexes for table `bill_data`
--
ALTER TABLE `bill_data`
ADD PRIMARY KEY (`bill_data_id`),
ADD KEY `bill_id` (`bill_id`,`timestamp`);
--
-- Indexes for table `bill_entities`
--
ALTER TABLE `bill_entities`
ADD PRIMARY KEY (`bill_ent_id`),
ADD UNIQUE KEY `bill_id_2` (`bill_id`,`entity_id`),
ADD KEY `bill_id` (`bill_id`);
--
-- Indexes for table `bill_history`
--
ALTER TABLE `bill_history`
ADD PRIMARY KEY (`bill_hist_id`),
ADD UNIQUE KEY `unique_index` (`bill_id`,`bill_datefrom`,`bill_dateto`),
ADD KEY `bill_id` (`bill_id`);
--
-- Indexes for table `cef_prefix`
--
ALTER TABLE `cef_prefix`
ADD PRIMARY KEY (`cef_pfx_id`);
--
-- Indexes for table `cef_switching`
--
ALTER TABLE `cef_switching`
ADD PRIMARY KEY (`cef_switching_id`),
ADD UNIQUE KEY `device_id` (`device_id`,`entPhysicalIndex`,`afi`,`cef_index`);
--
-- Indexes for table `config`
--
ALTER TABLE `config`
ADD UNIQUE KEY `config_key` (`config_key`);
--
-- Indexes for table `counters`
--
ALTER TABLE `counters`
ADD PRIMARY KEY (`counter_id`),
ADD KEY `counter_device` (`device_id`),
ADD KEY `counter_class` (`counter_class`),
ADD KEY `counter_oid` (`counter_oid`),
ADD KEY `counter_cache` (`counter_id`,`device_id`,`counter_class`,`counter_ignore`,`counter_disable`);
--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
ADD PRIMARY KEY (`customer_id`),
ADD UNIQUE KEY `username` (`username`);
--
-- Indexes for table `dashboards`
--
ALTER TABLE `dashboards`
ADD PRIMARY KEY (`dash_id`);
--
-- Indexes for table `dash_widgets`
--
ALTER TABLE `dash_widgets`
ADD PRIMARY KEY (`widget_id`);
--
-- Indexes for table `devices`
--
ALTER TABLE `devices`
ADD PRIMARY KEY (`device_id`),
ADD KEY `status` (`status`),
ADD KEY `hostname` (`hostname`),
ADD KEY `sysName` (`sysName`),
ADD KEY `os` (`os`),
ADD KEY `ignore` (`ignore`),
ADD KEY `disabled_lastpolled` (`disabled`,`last_polled_timetaken`);
--
-- Indexes for table `devices_locations`
--
ALTER TABLE `devices_locations`
ADD PRIMARY KEY (`location_id`),
ADD UNIQUE KEY `device_id` (`device_id`);
--
-- Indexes for table `devices_mibs`
--
ALTER TABLE `devices_mibs`
ADD PRIMARY KEY (`mib_id`),
ADD UNIQUE KEY `mib_object` (`device_id`,`mib`,`object`(512));
--
-- Indexes for table `device_graphs`
--
ALTER TABLE `device_graphs`
ADD PRIMARY KEY (`device_graph_id`),
ADD KEY `device_id` (`device_id`),
ADD KEY `graph` (`graph`);
--
-- Indexes for table `eigrp_ases`
--
ALTER TABLE `eigrp_ases`
ADD PRIMARY KEY (`eigrp_as_id`);
--
-- Indexes for table `eigrp_peers`
--
ALTER TABLE `eigrp_peers`
ADD PRIMARY KEY (`eigrp_peer_id`),
ADD UNIQUE KEY `table_unique` (`device_id`,`eigrp_vpn`,`eigrp_as`,`peer_addr`);
--
-- Indexes for table `eigrp_ports`
--
ALTER TABLE `eigrp_ports`
ADD PRIMARY KEY (`eigrp_port_id`),
ADD UNIQUE KEY `eigrp_vpn` (`eigrp_vpn`,`eigrp_as`,`eigrp_ifIndex`,`device_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `eigrp_vpns`
--
ALTER TABLE `eigrp_vpns`
ADD PRIMARY KEY (`eigrp_vpn_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `entity_attribs`
--
ALTER TABLE `entity_attribs`
ADD PRIMARY KEY (`attrib_id`),
ADD KEY `attribs_cache` (`entity_type`,`entity_id`,`attrib_type`(50)),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `entity_permissions`
--
ALTER TABLE `entity_permissions`
ADD PRIMARY KEY (`perm_id`),
ADD KEY `user_id` (`user_id`);
--
-- Indexes for table `entPhysical`
--
ALTER TABLE `entPhysical`
ADD PRIMARY KEY (`entPhysical_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `entPhysical-state`
--
ALTER TABLE `entPhysical-state`
ADD PRIMARY KEY (`entPhysical_state_id`),
ADD KEY `device_id_index` (`device_id`,`entPhysicalIndex`);
--
-- Indexes for table `eventlog`
--
ALTER TABLE `eventlog`
ADD PRIMARY KEY (`event_id`),
ADD KEY `host` (`device_id`),
ADD KEY `datetime` (`timestamp`),
ADD KEY `host_2` (`device_id`,`timestamp`),
ADD KEY `type` (`entity_type`),
ADD KEY `type_device` (`entity_type`,`device_id`),
ADD KEY `eventlog_cache` (`device_id`,`entity_type`,`severity`);
--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
ADD PRIMARY KEY (`group_id`),
ADD UNIQUE KEY `group_name` (`group_name`);
--
-- Indexes for table `groups_assoc`
--
ALTER TABLE `groups_assoc`
ADD PRIMARY KEY (`group_assoc_id`);
--
-- Indexes for table `group_table`
--
ALTER TABLE `group_table`
ADD PRIMARY KEY (`group_table_id`),
ADD UNIQUE KEY `alert_id_2` (`group_id`,`entity_type`,`entity_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `hrDevice`
--
ALTER TABLE `hrDevice`
ADD PRIMARY KEY (`hrDevice_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `ipsec_tunnels`
--
ALTER TABLE `ipsec_tunnels`
ADD PRIMARY KEY (`tunnel_id`),
ADD UNIQUE KEY `unique_index` (`device_id`,`local_addr`,`peer_addr`,`tunnel_endhash`);
--
-- Indexes for table `ipv4_addresses`
--
ALTER TABLE `ipv4_addresses`
ADD PRIMARY KEY (`ipv4_address_id`),
ADD KEY `interface_id` (`port_id`),
ADD KEY `ipv4_address` (`ipv4_address`),
ADD KEY `device_id` (`device_id`),
ADD KEY `ipv4_cache` (`device_id`,`ipv4_address`),
ADD KEY `ipv4_binary` (`device_id`,`ipv4_binary`),
ADD KEY `ifIndex` (`ifIndex`);
--
-- Indexes for table `ipv4_networks`
--
ALTER TABLE `ipv4_networks`
ADD PRIMARY KEY (`ipv4_network_id`);
--
-- Indexes for table `ipv6_addresses`
--
ALTER TABLE `ipv6_addresses`
ADD PRIMARY KEY (`ipv6_address_id`),
ADD KEY `interface_id` (`port_id`),
ADD KEY `device_id` (`device_id`),
ADD KEY `ipv6_binary` (`device_id`,`ipv6_binary`),
ADD KEY `ipv6_address` (`ipv6_address`,`ipv6_compressed`),
ADD KEY `ipv6_cache` (`device_id`,`ipv6_address`,`ipv6_compressed`),
ADD KEY `ifIndex` (`ifIndex`);
--
-- Indexes for table `ipv6_networks`
--
ALTER TABLE `ipv6_networks`
ADD PRIMARY KEY (`ipv6_network_id`);
--
-- Indexes for table `ip_mac`
--
ALTER TABLE `ip_mac`
ADD PRIMARY KEY (`mac_id`),
ADD KEY `port_id` (`port_id`);
--
-- Indexes for table `juniAtmVp`
--
ALTER TABLE `juniAtmVp`
ADD PRIMARY KEY (`juniAtmVp_id`),
ADD KEY `port_id` (`port_id`);
--
-- Indexes for table `lb_pools`
--
ALTER TABLE `lb_pools`
ADD PRIMARY KEY (`pool_id`,`pool_name`);
--
-- Indexes for table `lb_pool_members`
--
ALTER TABLE `lb_pool_members`
ADD PRIMARY KEY (`member_id`,`pool_name`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `lb_snatpools`
--
ALTER TABLE `lb_snatpools`
ADD PRIMARY KEY (`snatpool_id`);
--
-- Indexes for table `lb_virtuals`
--
ALTER TABLE `lb_virtuals`
ADD PRIMARY KEY (`virt_id`);
--
-- Indexes for table `loadbalancer_rservers`
--
ALTER TABLE `loadbalancer_rservers`
ADD PRIMARY KEY (`rserver_id`);
--
-- Indexes for table `loadbalancer_vservers`
--
ALTER TABLE `loadbalancer_vservers`
ADD PRIMARY KEY (`classmap_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `mac_accounting`
--
ALTER TABLE `mac_accounting`
ADD PRIMARY KEY (`ma_id`),
ADD UNIQUE KEY `port_vlan_mac` (`port_id`,`vlan_id`,`mac`),
ADD KEY `device_ma` (`device_id`,`ma_id`);
--
-- Indexes for table `mempools`
--
ALTER TABLE `mempools`
ADD PRIMARY KEY (`mempool_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `munin_plugins`
--
ALTER TABLE `munin_plugins`
ADD PRIMARY KEY (`mplug_id`),
ADD UNIQUE KEY `dev_mplug` (`device_id`,`mplug_type`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `munin_plugins_ds`
--
ALTER TABLE `munin_plugins_ds`
ADD PRIMARY KEY (`mplug_ds_id`),
ADD UNIQUE KEY `splug_id` (`mplug_id`,`ds_name`);
--
-- Indexes for table `neighbours`
--
ALTER TABLE `neighbours`
ADD PRIMARY KEY (`neighbour_id`),
ADD KEY `src_if` (`port_id`),
ADD KEY `dst_if` (`remote_port_id`),
ADD KEY `count` (`port_id`,`active`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `netscaler_servicegroupmembers`
--
ALTER TABLE `netscaler_servicegroupmembers`
ADD PRIMARY KEY (`svc_id`),
ADD KEY `device_id` (`device_id`,`svc_name`);
--
-- Indexes for table `netscaler_services`
--
ALTER TABLE `netscaler_services`
ADD PRIMARY KEY (`svc_id`),
ADD KEY `device_id` (`device_id`,`svc_name`);
--
-- Indexes for table `netscaler_services_vservers`
--
ALTER TABLE `netscaler_services_vservers`
ADD PRIMARY KEY (`sv_id`),
ADD UNIQUE KEY `index` (`device_id`,`vsvr_name`,`svc_name`);
--
-- Indexes for table `netscaler_vservers`
--
ALTER TABLE `netscaler_vservers`
ADD PRIMARY KEY (`vsvr_id`),
ADD KEY `device_id` (`device_id`,`vsvr_name`);
--
-- Indexes for table `notifications_queue`
--
ALTER TABLE `notifications_queue`
ADD PRIMARY KEY (`notification_id`),
ADD KEY `aca_type` (`aca_type`);
--
-- Indexes for table `observium_attribs`
--
ALTER TABLE `observium_attribs`
ADD PRIMARY KEY (`attrib_type`(50));
--
-- Indexes for table `observium_processes`
--
ALTER TABLE `observium_processes`
ADD PRIMARY KEY (`process_id`),
ADD KEY `pid` (`process_pid`,`process_name`,`device_id`),
ADD KEY `name` (`process_name`,`device_id`);
--
-- Indexes for table `oids`
--
ALTER TABLE `oids`
ADD PRIMARY KEY (`oid_id`);
--
-- Indexes for table `oids_entries`
--
ALTER TABLE `oids_entries`
ADD PRIMARY KEY (`oid_entry_id`),
ADD UNIQUE KEY `oids_cache` (`oid_id`,`device_id`);
--
-- Indexes for table `ospf_areas`
--
ALTER TABLE `ospf_areas`
ADD UNIQUE KEY `device_area` (`device_id`,`ospfAreaId`);
--
-- Indexes for table `ospf_instances`
--
ALTER TABLE `ospf_instances`
ADD PRIMARY KEY (`ospf_instance_id`),
ADD UNIQUE KEY `device_id` (`device_id`),
ADD KEY `ospf_cache` (`device_id`,`ospfAdminStat`);
--
-- Indexes for table `ospf_nbrs`
--
ALTER TABLE `ospf_nbrs`
ADD UNIQUE KEY `device_id` (`device_id`,`ospf_nbr_id`);
--
-- Indexes for table `ospf_ports`
--
ALTER TABLE `ospf_ports`
ADD UNIQUE KEY `device_id` (`device_id`,`ospf_port_id`);
--
-- Indexes for table `p2p_radios`
--
ALTER TABLE `p2p_radios`
ADD PRIMARY KEY (`radio_id`),
ADD UNIQUE KEY `unique_index` (`device_id`,`radio_mib`,`radio_index`),
ADD KEY `count` (`deleted`,`device_id`);
--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
ADD PRIMARY KEY (`pkg_id`),
ADD UNIQUE KEY `unique_key` (`device_id`,`name`,`manager`,`arch`,`version`,`build`),
ADD KEY `device_id` (`device_id`),
ADD KEY `name` (`name`);
--
-- Indexes for table `pollers`
--
ALTER TABLE `pollers`
ADD PRIMARY KEY (`poller_id`),
ADD UNIQUE KEY `poller_name` (`poller_name`);
--
-- Indexes for table `ports`
--
ALTER TABLE `ports`
ADD PRIMARY KEY (`port_id`),
ADD UNIQUE KEY `device_ifIndex` (`device_id`,`ifIndex`),
ADD KEY `if_2` (`ifDescr`),
ADD KEY `port_cache` (`port_id`,`device_id`,`ignore`,`deleted`,`ifOperStatus`,`ifAdminStatus`),
ADD KEY `device_cache` (`device_id`,`disabled`,`deleted`);
--
-- Indexes for table `ports_adsl`
--
ALTER TABLE `ports_adsl`
ADD UNIQUE KEY `interface_id` (`port_id`);
--
-- Indexes for table `ports_cbqos`
--
ALTER TABLE `ports_cbqos`
ADD PRIMARY KEY (`cbqos_id`),
ADD UNIQUE KEY `device_id` (`device_id`,`port_id`,`policy_index`,`object_index`),
ADD KEY `port_id` (`port_id`);
--
-- Indexes for table `ports_stack`
--
ALTER TABLE `ports_stack`
ADD UNIQUE KEY `device_id` (`device_id`,`port_id_high`,`port_id_low`);
--
-- Indexes for table `ports_vlans`
--
ALTER TABLE `ports_vlans`
ADD PRIMARY KEY (`port_vlan_id`),
ADD UNIQUE KEY `unique` (`device_id`,`port_id`,`vlan`);
--
-- Indexes for table `printersupplies`
--
ALTER TABLE `printersupplies`
ADD PRIMARY KEY (`supply_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `processors`
--
ALTER TABLE `processors`
ADD PRIMARY KEY (`processor_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `pseudowires`
--
ALTER TABLE `pseudowires`
ADD PRIMARY KEY (`pseudowire_id`),
ADD KEY `port_id` (`port_id`),
ADD KEY `device_id` (`device_id`),
ADD KEY `row_status` (`device_id`,`pwRowStatus`);
--
-- Indexes for table `sensors`
--
ALTER TABLE `sensors`
ADD PRIMARY KEY (`sensor_id`),
ADD KEY `sensor_host` (`device_id`),
ADD KEY `sensor_class` (`sensor_class`),
ADD KEY `sensor_type` (`sensor_type`),
ADD KEY `sensor_cache` (`sensor_id`,`device_id`,`sensor_class`,`sensor_type`,`sensor_ignore`,`sensor_disable`),
ADD KEY `sensor_oid` (`sensor_oid`);
--
-- Indexes for table `services`
--
ALTER TABLE `services`
ADD PRIMARY KEY (`service_id`),
ADD KEY `service_host` (`device_id`);
--
-- Indexes for table `slas`
--
ALTER TABLE `slas`
ADD PRIMARY KEY (`sla_id`),
ADD UNIQUE KEY `unique_key` (`device_id`,`sla_mib`(50),`sla_index`(50),`sla_owner`(50)),
ADD KEY `device_id` (`device_id`),
ADD KEY `count` (`deleted`,`device_id`);
--
-- Indexes for table `snmp_errors`
--
ALTER TABLE `snmp_errors`
ADD PRIMARY KEY (`error_id`),
ADD UNIQUE KEY `error_index` (`device_id`,`error_code`,`snmp_cmd`,`mib`,`oid`(512)) USING BTREE;
--
-- Indexes for table `status`
--
ALTER TABLE `status`
ADD PRIMARY KEY (`status_id`),
ADD KEY `sensor_host` (`device_id`),
ADD KEY `sensor_type` (`status_type`),
ADD KEY `status_cache` (`status_id`,`device_id`,`entPhysicalClass`,`status_ignore`,`status_disable`),
ADD KEY `status_oid` (`status_oid`);
--
-- Indexes for table `storage`
--
ALTER TABLE `storage`
ADD PRIMARY KEY (`storage_id`),
ADD UNIQUE KEY `index_unique` (`device_id`,`storage_mib`,`storage_index`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `syslog`
--
ALTER TABLE `syslog`
ADD PRIMARY KEY (`seq`),
ADD KEY `datetime` (`timestamp`),
ADD KEY `device_id` (`device_id`),
ADD KEY `program` (`program`),
ADD KEY `priority` (`priority`),
ADD KEY `device_priority` (`device_id`,`priority`),
ADD KEY `device_program` (`device_id`,`program`),
ADD KEY `device_timestamp` (`device_id`,`timestamp`);
--
-- Indexes for table `syslog_alerts`
--
ALTER TABLE `syslog_alerts`
ADD PRIMARY KEY (`lal_id`),
ADD KEY `device_id` (`device_id`),
ADD KEY `la_id` (`la_id`);
--
-- Indexes for table `syslog_rules`
--
ALTER TABLE `syslog_rules`
ADD PRIMARY KEY (`la_id`);
--
-- Indexes for table `syslog_rules_assoc`
--
ALTER TABLE `syslog_rules_assoc`
ADD PRIMARY KEY (`laa_id`);
--
-- Indexes for table `ucd_diskio`
--
ALTER TABLE `ucd_diskio`
ADD PRIMARY KEY (`diskio_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`user_id`),
ADD UNIQUE KEY `username` (`username`);
--
-- Indexes for table `users_ckeys`
--
ALTER TABLE `users_ckeys`
ADD PRIMARY KEY (`user_ckey_id`);
--
-- Indexes for table `users_prefs`
--
ALTER TABLE `users_prefs`
ADD PRIMARY KEY (`pref_id`),
ADD UNIQUE KEY `user_id.pref` (`user_id`,`pref`),
ADD KEY `pref` (`pref`);
--
-- Indexes for table `vlans`
--
ALTER TABLE `vlans`
ADD PRIMARY KEY (`vlan_id`),
ADD KEY `device_id` (`device_id`,`vlan_vlan`),
ADD KEY `ifIndex` (`ifIndex`);
--
-- Indexes for table `vlans_fdb`
--
ALTER TABLE `vlans_fdb`
ADD PRIMARY KEY (`fdb_id`),
ADD KEY `device_id` (`device_id`),
ADD KEY `port_id` (`port_id`),
ADD KEY `fdb_cache` (`device_id`,`vlan_id`,`mac_address`,`port_id`) USING BTREE;
--
-- Indexes for table `vminfo`
--
ALTER TABLE `vminfo`
ADD PRIMARY KEY (`vm_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `vrfs`
--
ALTER TABLE `vrfs`
ADD PRIMARY KEY (`vrf_id`),
ADD KEY `device_id` (`device_id`),
ADD KEY `vrf_cache` (`vrf_id`,`device_id`,`mplsVpnVrfRouteDistinguisher`);
--
-- Indexes for table `wifi_accesspoints`
--
ALTER TABLE `wifi_accesspoints`
ADD PRIMARY KEY (`wifi_accesspoint_id`);
--
-- Indexes for table `wifi_aps`
--
ALTER TABLE `wifi_aps`
ADD PRIMARY KEY (`wifi_ap_id`);
--
-- Indexes for table `wifi_radios`
--
ALTER TABLE `wifi_radios`
ADD PRIMARY KEY (`wifi_radio_id`),
ADD UNIQUE KEY `unique_dev_ap_number` (`device_id`,`radio_ap`,`radio_number`);
--
-- Indexes for table `wifi_sessions`
--
ALTER TABLE `wifi_sessions`
ADD PRIMARY KEY (`wifi_session_id`),
ADD KEY `device_id` (`device_id`);
--
-- Indexes for table `wifi_stations`
--
ALTER TABLE `wifi_stations`
ADD PRIMARY KEY (`wifi_station_id`),
ADD UNIQUE KEY `wifi_station_id` (`wifi_station_id`);
--
-- Indexes for table `wifi_wlans`
--
ALTER TABLE `wifi_wlans`
ADD PRIMARY KEY (`wlan_id`),
ADD KEY `device_id` (`device_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `accesspoints`
--
ALTER TABLE `accesspoints`
MODIFY `accesspoint_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `alerts_maint`
--
ALTER TABLE `alerts_maint`
MODIFY `maint_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `alerts_maint_assoc`
--
ALTER TABLE `alerts_maint_assoc`
MODIFY `maint_assoc_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `alert_assoc`
--
ALTER TABLE `alert_assoc`
MODIFY `alert_assoc_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `alert_contacts`
--
ALTER TABLE `alert_contacts`
MODIFY `contact_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `alert_contacts_assoc`
--
ALTER TABLE `alert_contacts_assoc`
MODIFY `aca_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `alert_log`
--
ALTER TABLE `alert_log`
MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `alert_table`
--
ALTER TABLE `alert_table`
MODIFY `alert_table_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `alert_tests`
--
ALTER TABLE `alert_tests`
MODIFY `alert_test_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `applications`
--
ALTER TABLE `applications`
MODIFY `app_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `authlog`
--
ALTER TABLE `authlog`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bgpPeers`
--
ALTER TABLE `bgpPeers`
MODIFY `bgpPeer_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bgpPeers_cbgp`
--
ALTER TABLE `bgpPeers_cbgp`
MODIFY `cbgp_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bills`
--
ALTER TABLE `bills`
MODIFY `bill_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bill_data`
--
ALTER TABLE `bill_data`
MODIFY `bill_data_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bill_entities`
--
ALTER TABLE `bill_entities`
MODIFY `bill_ent_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bill_history`
--
ALTER TABLE `bill_history`
MODIFY `bill_hist_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cef_prefix`
--
ALTER TABLE `cef_prefix`
MODIFY `cef_pfx_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cef_switching`
--
ALTER TABLE `cef_switching`
MODIFY `cef_switching_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `counters`
--
ALTER TABLE `counters`
MODIFY `counter_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `dashboards`
--
ALTER TABLE `dashboards`
MODIFY `dash_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `dash_widgets`
--
ALTER TABLE `dash_widgets`
MODIFY `widget_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `devices`
--
ALTER TABLE `devices`
MODIFY `device_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `devices_locations`
--
ALTER TABLE `devices_locations`
MODIFY `location_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `devices_mibs`
--
ALTER TABLE `devices_mibs`
MODIFY `mib_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `device_graphs`
--
ALTER TABLE `device_graphs`
MODIFY `device_graph_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `eigrp_ases`
--
ALTER TABLE `eigrp_ases`
MODIFY `eigrp_as_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `eigrp_peers`
--
ALTER TABLE `eigrp_peers`
MODIFY `eigrp_peer_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `eigrp_ports`
--
ALTER TABLE `eigrp_ports`
MODIFY `eigrp_port_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `eigrp_vpns`
--
ALTER TABLE `eigrp_vpns`
MODIFY `eigrp_vpn_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `entity_attribs`
--
ALTER TABLE `entity_attribs`
MODIFY `attrib_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `entity_permissions`
--
ALTER TABLE `entity_permissions`
MODIFY `perm_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `entPhysical`
--
ALTER TABLE `entPhysical`
MODIFY `entPhysical_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `entPhysical-state`
--
ALTER TABLE `entPhysical-state`
MODIFY `entPhysical_state_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `eventlog`
--
ALTER TABLE `eventlog`
MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `groups_assoc`
--
ALTER TABLE `groups_assoc`
MODIFY `group_assoc_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `group_table`
--
ALTER TABLE `group_table`
MODIFY `group_table_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hrDevice`
--
ALTER TABLE `hrDevice`
MODIFY `hrDevice_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ipsec_tunnels`
--
ALTER TABLE `ipsec_tunnels`
MODIFY `tunnel_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ipv4_addresses`
--
ALTER TABLE `ipv4_addresses`
MODIFY `ipv4_address_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ipv4_networks`
--
ALTER TABLE `ipv4_networks`
MODIFY `ipv4_network_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ipv6_addresses`
--
ALTER TABLE `ipv6_addresses`
MODIFY `ipv6_address_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ipv6_networks`
--
ALTER TABLE `ipv6_networks`
MODIFY `ipv6_network_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ip_mac`
--
ALTER TABLE `ip_mac`
MODIFY `mac_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `juniAtmVp`
--
ALTER TABLE `juniAtmVp`
MODIFY `juniAtmVp_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lb_pools`
--
ALTER TABLE `lb_pools`
MODIFY `pool_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lb_pool_members`
--
ALTER TABLE `lb_pool_members`
MODIFY `member_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lb_snatpools`
--
ALTER TABLE `lb_snatpools`
MODIFY `snatpool_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lb_virtuals`
--
ALTER TABLE `lb_virtuals`
MODIFY `virt_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `loadbalancer_rservers`
--
ALTER TABLE `loadbalancer_rservers`
MODIFY `rserver_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `loadbalancer_vservers`
--
ALTER TABLE `loadbalancer_vservers`
MODIFY `classmap_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mac_accounting`
--
ALTER TABLE `mac_accounting`
MODIFY `ma_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mempools`
--
ALTER TABLE `mempools`
MODIFY `mempool_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `munin_plugins`
--
ALTER TABLE `munin_plugins`
MODIFY `mplug_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `munin_plugins_ds`
--
ALTER TABLE `munin_plugins_ds`
MODIFY `mplug_ds_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `neighbours`
--
ALTER TABLE `neighbours`
MODIFY `neighbour_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `netscaler_servicegroupmembers`
--
ALTER TABLE `netscaler_servicegroupmembers`
MODIFY `svc_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `netscaler_services`
--
ALTER TABLE `netscaler_services`
MODIFY `svc_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `netscaler_services_vservers`
--
ALTER TABLE `netscaler_services_vservers`
MODIFY `sv_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `netscaler_vservers`
--
ALTER TABLE `netscaler_vservers`
MODIFY `vsvr_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `notifications_queue`
--
ALTER TABLE `notifications_queue`
MODIFY `notification_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `observium_processes`
--
ALTER TABLE `observium_processes`
MODIFY `process_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `oids`
--
ALTER TABLE `oids`
MODIFY `oid_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `oids_entries`
--
ALTER TABLE `oids_entries`
MODIFY `oid_entry_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ospf_instances`
--
ALTER TABLE `ospf_instances`
MODIFY `ospf_instance_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `p2p_radios`
--
ALTER TABLE `p2p_radios`
MODIFY `radio_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
MODIFY `pkg_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pollers`
--
ALTER TABLE `pollers`
MODIFY `poller_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ports`
--
ALTER TABLE `ports`
MODIFY `port_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ports_cbqos`
--
ALTER TABLE `ports_cbqos`
MODIFY `cbqos_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ports_vlans`
--
ALTER TABLE `ports_vlans`
MODIFY `port_vlan_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `printersupplies`
--
ALTER TABLE `printersupplies`
MODIFY `supply_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `processors`
--
ALTER TABLE `processors`
MODIFY `processor_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pseudowires`
--
ALTER TABLE `pseudowires`
MODIFY `pseudowire_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `sensors`
--
ALTER TABLE `sensors`
MODIFY `sensor_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
MODIFY `service_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `slas`
--
ALTER TABLE `slas`
MODIFY `sla_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `snmp_errors`
--
ALTER TABLE `snmp_errors`
MODIFY `error_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `status`
--
ALTER TABLE `status`
MODIFY `status_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `storage`
--
ALTER TABLE `storage`
MODIFY `storage_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `syslog`
--
ALTER TABLE `syslog`
MODIFY `seq` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `syslog_alerts`
--
ALTER TABLE `syslog_alerts`
MODIFY `lal_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `syslog_rules`
--
ALTER TABLE `syslog_rules`
MODIFY `la_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `syslog_rules_assoc`
--
ALTER TABLE `syslog_rules_assoc`
MODIFY `laa_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ucd_diskio`
--
ALTER TABLE `ucd_diskio`
MODIFY `diskio_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `user_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users_ckeys`
--
ALTER TABLE `users_ckeys`
MODIFY `user_ckey_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users_prefs`
--
ALTER TABLE `users_prefs`
MODIFY `pref_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vlans`
--
ALTER TABLE `vlans`
MODIFY `vlan_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vlans_fdb`
--
ALTER TABLE `vlans_fdb`
MODIFY `fdb_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vminfo`
--
ALTER TABLE `vminfo`
MODIFY `vm_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vrfs`
--
ALTER TABLE `vrfs`
MODIFY `vrf_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `wifi_accesspoints`
--
ALTER TABLE `wifi_accesspoints`
MODIFY `wifi_accesspoint_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `wifi_aps`
--
ALTER TABLE `wifi_aps`
MODIFY `wifi_ap_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `wifi_radios`
--
ALTER TABLE `wifi_radios`
MODIFY `wifi_radio_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `wifi_sessions`
--
ALTER TABLE `wifi_sessions`
MODIFY `wifi_session_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `wifi_stations`
--
ALTER TABLE `wifi_stations`
MODIFY `wifi_station_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `wifi_wlans`
--
ALTER TABLE `wifi_wlans`
MODIFY `wlan_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `counters`
--
ALTER TABLE `counters`
ADD CONSTRAINT `counter_devices` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
--
-- Constraints for table `devices_mibs`
--
ALTER TABLE `devices_mibs`
ADD CONSTRAINT `mibs_devices` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
--
-- Constraints for table `snmp_errors`
--
ALTER TABLE `snmp_errors`
ADD CONSTRAINT `snmp_devices` FOREIGN KEY (`device_id`) REFERENCES `devices` (`device_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
/*!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 */;
View Git Blame Copy Permalink