2yTaXUpb

1CREATE DATABASE IF NOT EXISTS diamond;
2USE diamond;
3CREATE TABLE metrics (
4	  id int not null auto_increment, 
5    col_time int(11), -- Stored in Seconds
6    col_metric varchar(255) not null, -- Name of metric in diamond form.
7    col_value double not null, -- value of the recorded metric
8    primary key(id)
9    );