gistfile1.sql

CREATE TABLE `analytics` (
  `classifier_id` bigint unsigned,
  `ts_msec` bigint unsigned,
  `value` double,
  PRIMARY KEY (`classifier_id`,`ts_msec`),
  KEY `ts_msec` (`ts_msec`)
);

CREATE /*!90618 REFERENCE*/ TABLE `classifiers` (
  `id` bigint(20) unsigned NOT NULL,
  `ts_msec` bigint unsigned,
  `hostname` varchar(255),
  -- ... a small number of "required" fields
  tags JSON not null,
  PRIMARY KEY (`id`),
);