mfv_tables.sql

DROP TABLE tags;
CREATE TABLE tags(
    md5 CHAR(32) NOT NULL,
	type VARCHAR(255) NOT NULL,
	value VARCHAR(255) NOT NULL,
	UNIQUE INDEX (md5, type, value)
);

DROP TABLE vectors;
CREATE TABLE vectors(
    md5 CHAR(32) NOT NULL,
	machine VARCHAR(255) NOT NULL,
	task_id INT UNSIGNED NOT NULL,
	type VARCHAR(255)NOT NULL,
	value INT NOT NULL,
	UNIQUE INDEX (md5, machine, task_id, type, value)
);


DROP TABLE archetypes;
CREATE TABLE archetypes (
	label VARCHAR(255) UNIQUE,
	mean_features LONGTEXT,
	stddev_features LONGTEXT,
	max_value_features LONGTEXT
);