Database Schema (dbname=pinger)
| 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) ); |