-- STEP=2 On Slave SET FOREIGN_KEY_CHECKS = 0; DROP TABLE IF EXISTS Table_Master_2; CREATE TABLE Table_Master_2 ( Column_4 int(4) unsigned NOT NULL AUTO_INCREMENT, Column_5 varchar(50) NOT NULL, PRIMARY KEY (Column_4) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT; INSERT INTO Table_Master_2 VALUES (1,'ABC'); SET FOREIGN_KEY_CHECKS = 0; DROP TABLE IF EXISTS Table_Master; CREATE TABLE Table_Master ( Column_S1 bigint(8) unsigned NOT NULL AUTO_INCREMENT, Column_S2 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', Column_1 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', Column_2 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', Column_3 varchar(15) NOT NULL, Column_4 int(4) unsigned DEFAULT NULL, Column_5 varchar(64) NOT NULL, Column_6 varchar(25) NOT NULL, Column_7 varchar(25) NOT NULL, Column_8 varchar(25) NOT NULL, Column_9 varchar(15) NOT NULL, Column_10 varchar(128) NOT NULL, Column_11 varchar(25) NOT NULL, Column_12 varchar(25) NOT NULL, Column_13 varchar(128) NOT NULL, Column_14 varchar(25) NOT NULL, Column_15 int(4) unsigned DEFAULT NULL, Column_16 bigint(8) unsigned NOT NULL, Column_17 int(4) unsigned NOT NULL, Column_18 int(4) unsigned NOT NULL, Column_19 int(4) unsigned NOT NULL, Column_20 int(4) unsigned DEFAULT NULL, Column_21 int(4) unsigned DEFAULT NULL, Column_22 bigint(8) unsigned DEFAULT NULL, Column_23 int(4) unsigned DEFAULT NULL, Column_24 bigint(8) unsigned DEFAULT NULL, Column_25 int(4) unsigned NOT NULL DEFAULT '0', Column_26 int(4) unsigned NOT NULL DEFAULT '0', Column_27 int(4) unsigned NOT NULL DEFAULT '0', Column_28 int(4) unsigned NOT NULL DEFAULT '0', Column_29 int(4) unsigned NOT NULL DEFAULT '0', Column_30 int(4) unsigned NOT NULL DEFAULT '0', Column_31 int(4) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (Column_S1), KEY Column_S2 (Column_S2), KEY Column_1 (Column_1), KEY Column_2 (Column_2), FOREIGN KEY (Column_4) REFERENCES Table_Master_2 (Column_4) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;