 
     PRIMARY KEY (id)
 ) ENGINE = InnoDB;
+ALTER TABLE mission_attribute ADD INDEX (mission_id);
 
 CREATE TABLE IF NOT EXISTS mission_event (
     id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,


CREATE PROCEDURE transform_missions()
    INSERT INTO transformed_mission SELECT
        m.id as id
        , DATE_FORMAT(m.created, '%Y-%m-%d %k:%i:%s') AS created
        , name.char_value AS name
        , world.char_value AS world


    PRIMARY KEY (id)
) ENGINE = InnoDB;
ALTER TABLE entity_attribute ADD INDEX (mission_id);
ALTER TABLE entity_attribute ADD INDEX (entity_id);

CREATE TABLE IF NOT EXISTS entity_position (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
