Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE INDEX par_ind on Image_Question (SessionId,QuestionId);
- ALTER TABLE Image_Question ADD CONSTRAINT FK_CONSTRAINT_NAME
- FOREIGN KEY (SessionId,QuestionId)
- REFERENCES Question(SessionId,QuestionId)
- ON DELETE CASCADE;
- #1452 - Cannot add or update a child row: a foreign key constraint fails (`mobile_app`.<result 2 when explaining filename '#sql-4517_14f1a'>, CONSTRAINT `FK_CONSTRAINT_NAME` FOREIGN KEY (`SessionId`, `QuestionId`) REFERENCES `Question` (`SessionId`, `QuestionId`) ON)
- CREATE TABLE Image_Question (ImageQuestionId INT NOT NULL,
- ImageId INT NOT NULL,
- SessionId CHAR(3) NOT NULL,
- QuestionId INT NOT NULL,
- PRIMARY KEY (ImageQuestionId)
- ) ENGINE=INNODB;
- CREATE TABLE Question (QuestionId INT NOT NULL,
- SessionId CHAR(3) NOT NULL,
- Question CHAR(10) NOT NULL ) ENGINE=INNODB;
- ALTER TABLE `question` CHANGE `QuestionId` `QuestionId` INT(11) NOT NULL, ADD PRIMARY KEY(`QuestionId`);
- ALTER TABLE `image_question` ADD INDEX `questionId` (`QuestionId`);
- ALTER TABLE `question` ADD CONSTRAINT `FK_question` FOREIGN KEY (`QuestionId`)
- REFERENCES `image_question` (`QuestionId`) ON DELETE NO ACTION ;
- ALTER TABLE `question` CHANGE `SessionId` `SessionId` INT(11) NOT NULL;
- ALTER TABLE `image_question` CHANGE `SessionId` `SessionId` INT(11) NOT NULL;
- ALTER TABLE `image_question` ADD INDEX `NewIndex1` (`SessionId`);
- ALTER TABLE `image_question` ADD CONSTRAINT `FK_image_question` FOREIGN KEY (`SessionId`) REFERENCES `question` (`SessionId`) ON DELETE NO ACTION ;
Add Comment
Please, Sign In to add comment