Page History

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