SEEC-Paas-Monitor/script/store.sql

use monitor;
CREATE TABLE call_back LIKE call_record;
INSERT INTO call_back SELECT * FROM call_record WHERE create_time<UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL -3 MONTH));

CREATE TABLE error_back LIKE error_record;
INSERT INTO error_back SELECT * FROM error_record WHERE create_time<UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL -3 MONTH));

CREATE TABLE event_back LIKE event_record;
INSERT INTO event_back SELECT * FROM event_record WHERE create_time<UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL -3 MONTH));

CREATE TABLE metric_back LIKE metric_record;
INSERT INTO metric_back SELECT * FROM metric_record WHERE start_time<UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL -3 MONTH));