CREATE UNIQUE INDEX MyIndexName on MyTableName (

UserId ASC,

RepId ASC,

Field03,

Field04

);

"ERROR 1286 (42000): Unknown storage engine 'partition'"

ALTER TABLE MyTableName ADD UNIQUE MyIndexName (UserId ASC,

RepId ASC,

Field03,

Field04

);

 CREATE TABLE `MyTableName` (

  `Field01` bigint(20) NOT NULL,

  `UserId` bigint(20) NOT NULL,

  `RepId` bigint(20) NOT NULL,

  `Field03` varchar(32) NOT NULL,

  `Field04` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  PRIMARY KEY (`UserId`,`RepId`,`Field01`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED

 PARTITION BY HASH (`UserId`)

PARTITIONS 10