...
No Format |
---|
/afs/slac/package/pinger/pinger-archive/src/schema-meta-database/schema.tar.gz |
Downsites
The schema of the database is as follows:
No Format |
---|
#DROP DATABASE IF EXISTS `downsites`;
#CREATE DATABASE `downsites`;
DROP TABLE IF EXISTS `downsites`;
CREATE TABLE `downsites`
(
`MonitoringSite` varchar(50) NOT NULL,
`RemoteSite` VARCHAR(50) NOT NULL,
`minrtt` FLOAT NOT NULL,
`regminrtt` 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`)
);
|