CREATE TABLE testtbl (
  id INTEGER PRIMARY KEY,
  val1 VARCHAR(40) NOT NULL,
  INDEX `idx_val1` (`val1`)
);