drop table if exists t1;

create table t1 (
row_id varchar(33),
columnA varchar(33),
columnB varchar(33),
columnC varchar(33),
PRIMARY KEY USING BTREE  (`row_id`),
UNIQUE KEY `columnAindex` (`columnA`),
KEY `columnBindex` USING HASH (`columnB`),
KEY `columnCindex` USING BTREE (`columnC`)
);

--exec $MYSQL_DUMP test t1