DROP DATABASE IF EXISTS part_db;
CREATE DATABASE IF NOT EXISTS part_db;
USE part_db;
CREATE TABLE trigger_result (
entry VARCHAR(30)
);
CREATE TABLE part_range (i int) PARTITION BY RANGE (i) (
PARTITION p0 VALUES LESS THAN (2),
PARTITION p1 VALUES LESS THAN (8),		
PARTITION p2 VALUES LESS THAN (17), 
PARTITION p3 VALUES LESS THAN (64)
);
ALTER TABLE part_range DROP PARTITION p1;