Exile Mod SQL Events

-- ----------------------------
-- Procedure structure for `BP`
-- ----------------------------
DROP PROCEDURE IF EXISTS `BP`;
DELIMITER ;;
CREATE DEFINER=`user`@`localhost` PROCEDURE `BP`()
BEGIN
DELETE FROM player WHERE damage = 1;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `BV`
-- ----------------------------
DROP PROCEDURE IF EXISTS `BV`;
DELIMITER ;;
CREATE DEFINER=`user`@`localhost` PROCEDURE `BV`()
BEGIN
DELETE FROM `vehicle` WHERE `damage` = 1;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `DD`
-- ----------------------------
DROP PROCEDURE IF EXISTS `DD`;
DELIMITER ;;
CREATE DEFINER=`user`@`localhost` PROCEDURE `DD`()
BEGIN
DELETE FROM player_history WHERE died_at < now() - INTERVAL 1 DAY;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `DF`
-- ----------------------------
DROP PROCEDURE IF EXISTS `DF`;
DELIMITER ;;
CREATE DEFINER=`user`@`localhost` PROCEDURE `DF`()
BEGIN
DELETE FROM construction WHERE class = 'Exile_Construction_CampFire_Static' and last_updated_at < now() - INTERVAL 3 DAY;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `DW`
-- ----------------------------
DROP PROCEDURE IF EXISTS `DW`;
DELIMITER ;;
CREATE DEFINER=`user`@`localhost` PROCEDURE `DW`()
BEGIN
DELETE FROM construction WHERE class = 'Exile_Construction_WorkBench_Static' and last_updated_at < now() - INTERVAL 3 DAY;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `NC`
-- ----------------------------
DROP PROCEDURE IF EXISTS `NC`;
DELIMITER ;;
CREATE DEFINER=`user`@`localhost` PROCEDURE `NC`()
DELETE FROM container WHERE last_updated_at <= NOW() - INTERVAL 72 HOUR AND territory_id IS NULL
;
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `NT`
-- ----------------------------
DROP PROCEDURE IF EXISTS `NT`;
DELIMITER ;;
CREATE DEFINER=`user`@`localhost` PROCEDURE `NT`()
BEGIN
DELETE FROM construction WHERE territory_id IS NULL and spawned_at < now() - INTERVAL 7 DAY;
END
;;
DELIMITER ;

-- ----------------------------
-- Event structure for `deletedead`
-- ----------------------------
DROP EVENT IF EXISTS `deletedead`;
DELIMITER ;;
CREATE DEFINER=`user`@`localhost` EVENT `deletedead` ON SCHEDULE EVERY 1 MINUTE STARTS '2015-12-28 13:57:26' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
DELETE FROM player WHERE damage = 1;
END
;;
DELIMITER ;

-- ----------------------------
-- Event structure for `pmainnew`
-- ----------------------------
DROP EVENT IF EXISTS `pmainnew`;
DELIMITER ;;
CREATE DEFINER=`user`@`localhost` EVENT `pmainnew` ON SCHEDULE EVERY 15 MINUTE STARTS '2016-03-06 16:24:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
    CALL BP;
    CALL BV;
    CALL DD;
    CALL DF;
    CALL DW;
    CALL NT;
    CALL NC;
END
;;
DELIMITER ;