DROP TABLE IF EXISTS `tb9_eng1`;
CREATE TABLE `tb9_eng1` (
  `f1` int(11) DEFAULT NULL,
  `f2` char(15) DEFAULT NULL,
  `f3` decimal(5,3) DEFAULT NULL,
  `f4` datetime DEFAULT NULL
) ENGINE=Myisam DEFAULT CHARSET=latin1
PARTITION BY LIST (f1)
SUBPARTITION BY HASH (f1)
(PARTITION part1 VALUES IN (1,2,3,4) ( SUBPARTITION subpart11, SUBPARTITION subpart12));

DELIMITER |;

CREATE trigger tb9_eng1_ins after insert on tb9_eng1 for each row
BEGIN
insert into tb1_logs (dt1, entry_dsc, f4)
values (now(), concat('Insert row ', new.f1,' ',
new.f2, ' ', new.f3, ' (tb9_eng1)'), new.f1);
END |

DELIMITER ;|

CREATE TABLE `tb1_logs` (
  `i1` int(11) NOT NULL AUTO_INCREMENT,
  `dt1` datetime NOT NULL,
  `entry_dsc` char(100) DEFAULT NULL,
  `f4` int(11) DEFAULT NULL,
  PRIMARY KEY (`i1`)
) ENGINE=Falcon PARTITION BY HASH (i1) PARTITIONS 8;

ALTER TABLE tb9_eng1 PARTITION BY KEY (f1) PARTITIONS 4;
insert into tb9_eng1 values (3,'init_val',12.345,'2005-01-01 00:00:00');