CREATE TABLE parent (
	id INT NOT NULL,
	PRIMARY KEY (id)
);

CREATE TABLE child (
	id INT NOT NULL, 
	parent_id INT NOT NULL,
	PRIMARY KEY(id),
	INDEX parent_id_index (parent_id),
	FOREIGN KEY (parent_id) REFERENCES parent(id)
);