30 lines
822 B
Plaintext
30 lines
822 B
Plaintext
CREATE TABLE t1 (
|
|
id INT NOT NULL,
|
|
title TEXT,
|
|
PRIMARY KEY (id),
|
|
FULLTEXT KEY (title),
|
|
FOREIGN KEY (id) REFERENCES t2 (id)
|
|
) ENGINE=InnoDB;
|
|
ERROR HY000: Failed to open the referenced table 't2'
|
|
CREATE TABLE t1 (
|
|
id INT NOT NULL,
|
|
title TEXT,
|
|
PRIMARY KEY (id)
|
|
) ENGINE=InnoDB;
|
|
ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
|
|
ERROR HY000: Failed to open the referenced table 't2'
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
|
|
Warnings:
|
|
Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (
|
|
id INT NOT NULL,
|
|
title TEXT,
|
|
PRIMARY KEY (id),
|
|
FULLTEXT KEY (title),
|
|
FOREIGN KEY (id) REFERENCES t2 (id)
|
|
) ENGINE=InnoDB;
|
|
DROP TABLE t1;
|
|
SET FOREIGN_KEY_CHECKS = 1;
|