BrunoBlanes

DELIMITER $$
USE zabbix$$

DROP PROCEDURE IF EXISTS manage_partitions$$
CREATE PROCEDURE manage_partitions()
BEGIN
    -- Change these according to your settings
    DECLARE zabbix_db_name VARCHAR(64) DEFAULT 'zabbix';
    DECLARE trends_storage_period INT DEFAULT UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 5 YEAR));
    DECLARE history_storage_period INT DEFAULT UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 YEAR));