...
No Format |
---|
#DROP DATABASE IF EXISTS `downsites`; #CREATE DATABASE `downsites`; DROP TABLE IF EXISTS `downsites`; CREATE TABLE `downsites` ( `down_timestamp` INT(10) UNSIGNED DEFAULT 0, `up_timestamp` INT(10) UNSIGNED DEFAULT 0, `monitoring_site` VARCHAR(50), `remote_site` VARCHAR(50), `site_status` VARCHAR(50), `downdays` INT(10) UNSIGNED DEFAULT 0, `monitoring_country` VARCHAR(50), ); mysql> desc downsites; +--------------------+------------------+------+-----+---------+-------+ | Field `remote_country` VARCHAR(50), `monitoring_region` VARCHAR(50), `remote_region` | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+-------+ | down_timestamp | int(10) unsigned | | PRI | 0 | | | up_timestamp | int(10) unsigned | | | 0 | | | monitoring_site | varchar(50) | | PRI | | | | remote_site | varchar(50) | | PRI | | | | site_status | varchar(50) | | | | | | downdays | int(10) unsigned | | PRI | 0 | | | monitoring_country | varchar(50) | | | | | | remote_country | varchar(50) | | | | | | monitoring_region | varchar(50) | | | | | | remote_region | varchar(50) | | | | | | remote_node | varchar(50) | | | | | | beacon_status | varchar(50) | | | | | +--------------------+------------------+------+-----+---------+-------+ 12 rows in set (0.00 sec) mysql> desc beacons; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | siteVARCHAR(50), `remote_node` | varcharVARCHAR(50), `beacon_status` | | PRI | VARCHAR(50), PRIMARY KEY | | | beacon_status | varchar(50) | (`down_timestamp`, `monitoring_site`, `remote_site`, `downdays`) ); DROP TABLE IF EXISTS `beacons`; CREATE TABLE `beacons` ( `site` | PRI | | | +---------------+-------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)VARCHAR(50), `beacon_status` VARCHAR(50), PRIMARY KEY (`site`, `beacon_status`) ); mysql> desc dbminrtt; +-------------------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+----------------+------+-----+---------+-------+ | MonitoringSite | varchar(50) | | PRI | | | | RemoteSite | varchar(50) | | PRI | | | | minrtt | float unsigned | | | 0 | | | regminrtt | float unsigned | | | 0 | | | sdrtt | float unsigned | | | 0 | | | anomalydate | varchar(50) | | PRI | | | | MonitoringCountry | varchar(50) | | | | | | RemoteCountry | varchar(50) | | | | | | MonitoringRegion | varchar(50) | | | | | | RemoteRegion | varchar(50) | | | | | +-------------------+----------------+------+-----+---------+-------+ 10 rows in set (0.00 sec) mysql> desc downsites_new; +--------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------+------+-----+---------+-------+ | down_timestamp | int(10) | | PRI | 0 | | | up_timestamp | int(10) | | | 0 | | | monitoring_site | varchar(50) | | PRI | | | | remote_site | varchar(50) | | PRI | | | | site_status | varchar(50) | | | | | | downdays | int(10) | | PRI | 0 | | | monitoring_country | varchar(50) | | | | | | remote_country | varchar(50) | | | | | | monitoring_region | varchar(50) | | | | | | remote_region | varchar(50) | | | | | | remote_node | varchar(50) | | | | | | beacon_status | varchar(50) | | | | | | remote_node_type | varchar(5) | YES | | NULL | | +--------------------+-------------+------+-----+---------+-------+ 13 rows in set (0.00 sec) |