-- pridani moznosti nastaveni rychlosti vehiclu
SET @STATUS_ID = 1;

DELIMITER //

CREATE PROCEDURE `alter_mq_vehicle_data_1`()
BEGIN
DECLARE cnt INT;
SET cnt = (SELECT count(id) FROM mq_status WHERE id = @STATUS_ID);
IF cnt = 0 THEN
    insert into mq_status values (@STATUS_ID, 'pridani sloupcu speed_walk az speed_pitch_rate do mq_vehicle_data');
    alter table mq_vehicle_data add column speed_walk float not null default 1.0;
    alter table mq_vehicle_data add column speed_run float not null default 1.0;
    alter table mq_vehicle_data add column speed_run_back float not null default 1.0;
    alter table mq_vehicle_data add column speed_swim float not null default 1.0;
    alter table mq_vehicle_data add column speed_swim_back float not null default 1.0;
    alter table mq_vehicle_data add column speed_turn_rate float not null default 1.0;
    alter table mq_vehicle_data add column speed_flight float not null default 1.0;
    alter table mq_vehicle_data add column speed_flight_back float not null default 1.0;
    alter table mq_vehicle_data add column speed_pitch_rate float not null default 1.0;

    -- nastaveni speed podle creature_template
    update mq_vehicle_data, creature_template set mq_vehicle_data.speed_walk = creature_template.speed_walk, mq_vehicle_data.speed_run = creature_template.speed_run  where mq_vehicle_data.entry = creature_template.vehicleid;
END IF;
    END //

DELIMITER ;

CALL `alter_mq_vehicle_data_1`();
DROP PROCEDURE IF EXISTS `alter_mq_vehicle_data_1`;