CREATE TABLE Item ( itemId INT NOT NULL AUTO_INCREMENT , pageId INT NOT NULL , containerId INT NOT NULL , contentTypeId INT NOT NULL , createdDate DATETIME NOT NULL , modifiedDate TIMESTAMP , UNIQUE UQ_Item_1 (pageId, containerId) , PRIMARY KEY (itemId) , INDEX (pageId) , CONSTRAINT FK_Item_1 FOREIGN KEY (pageId) REFERENCES Page (pageId) )TYPE=InnoDB;