Contents

create database sensumetrics;
use sensumetrics;
create table sensu_historic_metrics( 
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `client_id` VARCHAR(150) NOT NULL,
    `check_name` VARCHAR(100) NOT NULL,
    `issue_time` INT(8) UNSIGNED NOT NULL,
    `output` TEXT,
    `status` INT(2) UNSIGNED,
    INDEX `client_id_idx` (`client_id`),
    INDEX `check_name_idx` (`check_name`),
    INDEX `issue_time_idx` (`issue_time`)
);
GRANT SELECT,INSERT on sensumetrics.sensu_historic_metrics TO sensu_user@'localhost' IDENTIFIED BY 'sensu_user_pass';
FLUSH PRIVILEGES;

Version data entries

27 entries across 27 versions & 3 rubygems

Version	Path
sensu-plugins-mysql-1.2.0	bin/mysql-metrics.sql
sensu-plugins-mysql-1.1.0	bin/mysql-metrics.sql
sensu-plugins-mysql-1.0.0	bin/mysql-metrics.sql
sensu-plugins-mysql-0.0.4	bin/mysql-metrics.sql
sensu-plugins-mysql-0.0.3	bin/mysql-metrics.sql
sensu-plugins-mysql-0.0.2	bin/mysql-metrics.sql
sensu-plugins-mysql-0.0.1	bin/mysql-metrics.sql