パーティションテーブル 1年に1回年末に必ず翌年の設定をしてください

■rocaket-la
result_datas
<code>
ALTER TABLE result_datas ADD PARTITION (
	PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB,
	PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB,
	PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB,
	PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB,
	PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB,
	PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB,
	PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB,
	PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB,
	PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB,
	PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB,
	PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB,
	PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB
);
</code>
result_error_datas
<code>
ALTER TABLE result_error_datas ADD PARTITION (
	PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB,
	PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB,
	PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB,
	PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB,
	PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB,
	PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB,
	PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB,
	PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB,
	PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB,
	PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB,
	PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB,
	PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB
);
</code>
unsubscribe_datas
<code>
ALTER TABLE unsubscribe_datas ADD PARTITION (
	PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB,
	PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB,
	PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB,
	PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB,
	PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB,
	PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB,
	PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB,
	PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB,
	PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB,
	PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB,
	PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB,
	PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB
);
</code>
■rocaket-api
click_records
<code>
ALTER TABLE click_records ADD PARTITION (
	PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB,
	PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB,
	PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB,
	PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB,
	PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB,
	PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB,
	PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB,
	PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB,
	PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB,
	PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB,
	PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB,
	PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB
);
</code>
click_records_test
<code>
ALTER TABLE click_records_test ADD PARTITION (
	PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB,
	PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB,
	PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB,
	PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB,
	PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB,
	PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB,
	PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB,
	PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB,
	PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB,
	PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB,
	PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB,
	PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB
);
</code>
result_records
<code>
ALTER TABLE result_records ADD PARTITION (
	PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB,
	PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB,
	PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB,
	PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB,
	PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB,
	PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB,
	PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB,
	PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB,
	PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB,
	PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB,
	PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB,
	PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB
);
</code>
result_records_test
<code>
ALTER TABLE result_records_test  ADD PARTITION (
	PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB,
	PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB,
	PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB,
	PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB,
	PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB,
	PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB,
	PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB,
	PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB,
	PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB,
	PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB,
	PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB,
	PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB
);
</code>
unsubscribe_records
<code>
ALTER TABLE unsubscribe_records  ADD PARTITION (
	PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB,
	PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB,
	PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB,
	PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB,
	PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB,
	PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB,
	PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB,
	PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB,
	PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB,
	PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB,
	PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB,
	PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB
);
</code>
unsubscribe_records_test
<code>
ALTER TABLE unsubscribe_records_test  ADD PARTITION (
	PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB,
	PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB,
	PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB,
	PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB,
	PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB,
	PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB,
	PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB,
	PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB,
	PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB,
	PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB,
	PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB,
	PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB
);
</code>