Database Schema (dbname=pinger)
...
mysql> use pinger
Database changed
mysql> show tables;
+------------------+
| Tables_in_pinger |
+------------------+
| DATA |
| NODE |
+------------------+
2 rows in set (0.00 sec)
...
Code Block |
---|
CREATE DATABASE PINGER;
CREATE TABLE NODE ( id SMALLINT NOT NULL AUTO_INCREMENT,name VARCHAR(100), ip VARCHAR(15),
PRIMARY KEY(id), KEY(id)) ;
CREATE TABLE DATA ( source SMALLINT, destination SMALL INT, packet_size SMALLINT, epock INT, packet_loss TINYINT, min FLOAT(4,2),
avg FLOAT(4,2), max FLOAT(4,2) );
|
...