create_execution_logs.sql

14 lines | 359 B Blame History Raw Download
CREATE TABLE execution_logs (
	exec_id INT NOT NULL,
	name VARCHAR(128),
	attempt INT,
	enc_type TINYINT,
	start_byte INT,
	end_byte INT,
	log LONGBLOB,
	PRIMARY KEY (exec_id, name, attempt, start_byte),
	INDEX log_attempt (exec_id, name, attempt),
	INDEX log_index (exec_id, name),
	INDEX byte_log_index(exec_id, name, start_byte, end_byte)
) ENGINE=InnoDB;