create table Transaction
(
	id int unsigned auto_increment,
	time datetime not null,
	first_name varchar(40),
	last_name varchar(50),
	primary key (id, time),
	index first_index (first_name),
	index last_index (last_name)	
) engine=Innodb
	partition by range (to_days(time)) (partition p1 values less than (to_days('2007-02-07')),
				      	    partition p2 values less than (to_days('2007-02-08')),
				      	    partition p3 values less than MAXVALUE);
 



insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Q', 'Robert');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Mark', 'Nate');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Nate', 'Oscar');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Zack', 'Alice');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Jack', 'Kathy');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Alice', 'Alice');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Brian', 'Charles');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Charles', 'David');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'David', 'Eric');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Hector', 'Isaac');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Oscar', 'Patricia');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Patricia', 'Q');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'X', 'Yuri');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Robert', 'Shawn');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Kathy', 'Lois');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Eric', 'Francis');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Shawn', 'Theron');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'U', 'Vincent');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Francis', 'George');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'George', 'Hector');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Vincent', 'Walter');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Walter', 'X');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Lois', 'Mark');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Yuri', 'Zack');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Isaac', 'Jack');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Sharon', 'Mark');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Michael', 'Michelle');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Derick', 'Nathan');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Peter', 'Xavier');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Fred', 'Harold');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Katherine', 'Lisa');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Tom', 'Rina');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Jerry', 'Victor');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Alexander', 'Terry');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Justin', 'John');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Greg', 'Ernest');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Robert', 'Q');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Nate', 'Mark');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Oscar', 'Nate');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Alice', 'Zack');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Kathy', 'Jack');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Alice', 'Alice');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Charles', 'Brian');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'David', 'Charles');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Eric', 'David');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Isaac', 'Hector');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Patricia', 'Oscar');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Q', 'Patricia');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Yuri', 'X');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Shawn', 'Robert');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Lois', 'Kathy');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Francis', 'Eric');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Theron', 'Shawn');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Vincent', 'U');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'George', 'Francis');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Hector', 'George');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'Walter', 'Vincent');
insert into transaction (time, first_name, last_name) values ('2007-02-06', 'X', 'Walter');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Mark', 'Lois');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Zack', 'Yuri');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Jack', 'Isaac');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Mark', 'Sharon');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Michelle', 'Michael');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Nathan', 'Derick');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Xavier', 'Peter');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Harold', 'Fred');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Lisa', 'Katherine');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Rina', 'Tom');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Victor', 'Jerry');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Terry', 'Alexander');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'John', 'Justin');
insert into transaction (time, first_name, last_name) values ('2007-02-07', 'Ernest', 'Greg');