Database Schema (dbname=pinger)

 mysql> use pinger
Database changed
mysql> show tables;
+------------------+
| Tables_in_pinger |
+------------------+
| DATA             |
| NODE             |
+------------------+
2 rows in set (0.00 sec)

mysql> desc NODE;
+--------------------------------+---------------+
| Field   | Type            | Null | Key | Default     | Extra          |
+--------------------------------+---------------+
| id        | smallint(6)     | NO   | PRI | NULL    | auto_increment |
| name  |  varchar(100) | YES  |     | NULL      |                |
| ip        | varchar(15)   | YES  |     | NULL       |                |
+--------------------------------+---------------+
3 rows in set (0.01 sec)
mysql> desc DATA;
+--------------------------------------+------+
| Field           |  Type        | Null | Key | Default | Extra |
+--------------------------------------+------+
| source        | smallint(6) | YES  |     | NULL    |       |
| destination  | smallint(6) | YES  |     | NULL    |       |
| packet_size | smallint(6) | YES  |     | NULL    |       |
| epock         | int(11)     | YES  |     | NULL    |       |
| packet_loss | tinyint(4)  | YES  |     | NULL    |       |
| min            | float(4,2)  | YES  |     | NULL    |       |
| avg            | float(4,2)  | YES  |     | NULL    |       |
| max           | float(4,2)  | YES  |     | NULL    |       |
+-------------------------------------+------+
8 rows in set (0.00 sec)

The source file for creating these tables is located here