# MySQL Bugs: #25356
# FOREIGN KEY constraints changed after executing CREATE INDEX
# http://bugs.mysql.com/bug.php?id=25356

DROP TABLE IF EXISTS t3;
DROP TABLE IF EXISTS t2;
DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (
    id INT PRIMARY KEY
)
ENGINE = InnoDB;

CREATE TABLE t2 (
    id INT PRIMARY KEY,
    t1_id INT NOT NULL,
    colA INT NOT NULL,
    CONSTRAINT fk_t2_t1
        FOREIGN KEY (t1_id)
        REFERENCES t1 (id)
        ON UPDATE CASCADE
        ON DELETE CASCADE,
    INDEX ix_t2_colA (colA)
)
ENGINE = InnoDB;

CREATE TABLE t3 (
    id INT PRIMARY KEY,
    t1_id INT NOT NULL,
    colA INT NOT NULL,
    CONSTRAINT fk_t3_t1
        FOREIGN KEY (t1_id)
        REFERENCES t1 (id)
        ON UPDATE CASCADE
        ON DELETE CASCADE
)
ENGINE = InnoDB;

SHOW CREATE TABLE t2;
SHOW CREATE TABLE t3;

CREATE INDEX ix_t3_colA ON t3 (colA);

SHOW CREATE TABLE t2;
SHOW CREATE TABLE t3;