Page History

#DROP DATABASE IF EXISTS `downsites`;
#CREATE DATABASE `downsites`;

DROP TABLE IF EXISTS `downsites`;
CREATE TABLE `downsites`
(
  `MonitoringSite``down_timestamp`             INT(10) UNSIGNED DEFAULT 0,
  `up_timestamp`               varcharINT(5010) NOTUNSIGNED DEFAULT NULL0,
  `monitoring_site`    `RemoteSite`        VARCHAR(50) NOT NULL,
  `minrtt`,
  `remote_site`                VARCHAR(50),
  `site_status`              FLOAT NOT NULLVARCHAR(50),
  `regminrtt``downdays`                 FLOAT NOT NULL,
  `sdrtt`             FLOAT NOT NULL,
  `anomalydate`       DATE NOT NULL,
  `MonitoringCountry` VARCHAR(50) NOT NULL,
  `RemoteCountry`     VARCHAR(50) NOT NULL,
  `MonitoringRegion`  VARCHAR(50) NOT NULL,
  `RemoteRegion`      VARCHAR(50) NOT NULL,
  PRIMARY KEY (`username`)
);
INT(10),

);

mysql> desc downsites;
+--------------------+------------------+------+-----+---------+-------+
| Field              | 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 |
+---------------+-------------+------+-----+---------+-------+
| site          | varchar(50) |      | PRI |         |       |
| beacon_status | varchar(50) |      | PRI |         |       |
+---------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

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)