Example of a schema used to define a metrics table for diamond to to store data in a MySQL database

diamond-mysql-schema.sql

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