Store procedures for deleting dummies users

sp.sql

# Change delimiter // so SP can be created
DELIMITER //
CREATE PROCEDURE selectXamplifierUsers()
    BEGIN
        select id from users where is_system_user = 0 and email like "%xamplifier%";
    END
//

CREATE PROCEDURE deleteXamplifierUsers()
    BEGIN
        delete from referral_program_user_surveys where user_id in (select id from users where is_system_user = 0 and email like "%xamplifier%");
        delete from referral_program_users where user_id in (select id from users where is_system_user = 0 and email like "%xamplifier%");
        delete from referral_links where user_id in (select id from users where is_system_user = 0 and email like "%xamplifier%");
        delete from user_rewards where user_id in (select id from users where is_system_user = 0 and email like "%xamplifier%");
        delete from users where is_system_user = 0 and email like "%xamplifier%";
    END
//
# Change delimiter back to normal
DELIMETER;

# Run by using: call selectXamplifierUsers, call deleteXamplifierUsers