CREATE TABLE template (id INT AUTO_INCREMENT NOT NULL, uri VARCHAR(50) NOT NULL, UNIQUE INDEX template_idx (uri), PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE web_page_content (id INT AUTO_INCREMENT NOT NULL, template_id INT NOT NULL, content VARCHAR(50) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE header (id INT AUTO_INCREMENT NOT NULL, template_id INT NOT NULL, content VARCHAR(50) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB;
ALTER TABLE web_page_content ADD CONSTRAINT FK_95E4B6E5627579FF FOREIGN KEY (id) REFERENCES template(id) ON DELETE CASCADE;
ALTER TABLE header ADD CONSTRAINT FK_95E3B5E5627579FF FOREIGN KEY (id) REFERENCES template(id) ON DELETE CASCADE;