DELETE FROM mydb.lsports_bet WHERE fixture_start_date < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -30 DAY), '%Y-%m-%d 00:00:00');
DELETE FROM mydb.lsports_fixtures WHERE fixture_start_date < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -30 DAY), '%Y-%m-%d 00:00:00');

delete FROM mydb.member_bet WHERE create_dt < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -90 DAY), '%Y-%m-%d 00:00:00');
delete FROM mydb.member_bet_detail WHERE create_dt < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -90 DAY), '%Y-%m-%d 00:00:00');
delete FROM mydb.mini_game WHERE start_dt < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -90 DAY), '%Y-%m-%d 00:00:00');
delete FROM mydb.mini_game_member_bet WHERE create_dt < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -90 DAY), '%Y-%m-%d 00:00:00');


delete FROM mydb.t_log_cash WHERE reg_time < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -90 DAY), '%Y-%m-%d 00:00:00');
delete FROM mydb.member_money_charge_history WHERE create_dt < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -90 DAY), '%Y-%m-%d 00:00:00');
delete FROM mydb.member_money_charge_sms WHERE create_dt < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -90 DAY), '%Y-%m-%d 00:00:00');
delete FROM mydb.member_money_exchange_history WHERE create_dt < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -90 DAY), '%Y-%m-%d 00:00:00');
