 
 CREATE PROCEDURE transform_missions()
     INSERT INTO transformed_mission SELECT
-        m.id as id
+        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;

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


    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,
