Database Schema (dbname=pinger)

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) );
  • No labels