CREATE TRIGGER IF NOT EXISTS trg_platforms_before_insert
    BEFORE INSERT ON `platforms`
        FOR EACH ROW
            BEGIN
                SET NEW.location = POINT(NEW.longitude, NEW.latitude);
        END;

CREATE TRIGGER IF NOT EXISTS trg_platforms_before_update
    BEFORE UPDATE ON `platforms`
        FOR EACH ROW
            BEGIN
                SET NEW.location = POINT(NEW.longitude, NEW.latitude);
        END;