Here's the SQL to do the build:
Array
(
    [0] => CREATE TABLE mytable (
row1             INTEGER NOT NULL AUTO_INCREMENT,
row2             VARCHAR(16) NOT NULL,
                 PRIMARY KEY (row1)
)
    [1] => ALTER TABLE mytable ADD  INDEX myindex  (row1, row2)
    [2] => insert into mytable ( row1, row2 ) values ( 12, 'mysql stuff' )
    [3] => DROP TABLE IF EXISTS obsoletetable
)