#
# Naming convention for the 05 tests - partitioning
#

--disable_warnings
DROP DATABASE IF EXISTS part_db;
CREATE DATABASE IF NOT EXISTS part_db;
--enable_warnings

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)
);
--enable_query_log

CREATE TRIGGER part_trigger BEFORE INSERT ON part_range
  FOR EACH ROW INSERT INTO trigger_result VALUES ('part2');

ALTER TABLE part_range DROP PARTITION p1;