USE ecto_test;

CREATE TABLE t1(fld1 INT PRIMARY KEY, fld2 INT) ENGINE=INNODB;
CREATE TABLE t2(fld1 INT PRIMARY KEY, fld2 INT, CONSTRAINT fk2
    FOREIGN KEY (fld1) REFERENCES t1 (fld1)) ENGINE=InnoDB;