USE mysql;

SET GLOBAL event_scheduler = on ;
SET GLOBAL event_scheduler = 1;

-- -----------------------------------------------------------------------------
--  우편 삭제 대기중인 rows 일괄 삭제
-- -----------------------------------------------------------------------------


DROP EVENT IF EXISTS `delete_post_event_schedule`;

DELIMITER $

CREATE EVENT `delete_post_event_schedule`
ON SCHEDULE EVERY 1 DAY
STARTS '2017-03-10 03:50:00'
DO
BEGIN
	CALL `eod_game`.usp_a_delete_post(100);
END$

DELIMITER;

-- -----------------------------------------------------------------------------
--  장비 삭제 대기중인 rows 일괄 삭제
-- -----------------------------------------------------------------------------


DROP EVENT IF EXISTS `delete_equipment_event_schedule`;

DELIMITER $

CREATE EVENT `delete_equipment_event_schedule`
ON SCHEDULE EVERY 1 DAY
STARTS '2017-03-10 04:00:00'
DO
BEGIN
	CALL `eod_game`.usp_a_delete_equipment(100);
END$

DELIMITER;