Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- alter table Question drop foreign key FK_Option_Table;
- CREATE TABLE `Question` (
- `SessionId` varchar(10) NOT NULL DEFAULT '',
- `QuestionId` int(5) NOT NULL,
- `QuestionContent` varchar(5000) NOT NULL,
- `NoofAnswers` int(2) NOT NULL,
- `AnswerId` int(10) NOT NULL AUTO_INCREMENT,
- `ReplyId` varchar(2) NOT NULL,
- `QuestionMarks` int(4) NOT NULL,
- `OptionId` varchar(3) NOT NULL,
- PRIMARY KEY (`SessionId`,`QuestionId`),
- KEY `FK_Option_Table` (`OptionId`),
- KEY `FK_IndividualQuestion` (`QuestionId`),
- KEY `FK_Reply` (`ReplyId`),
- KEY `FK_AnswerId` (`AnswerId`)
- ) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8
- CREATE TABLE `Option_Table` (
- `OptionId` varchar(3) NOT NULL,
- `OptionType` varchar(20) NOT NULL,
- PRIMARY KEY (`OptionId`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- OptionId OptionType
- O1 A-C
- O2 A-D
- O3 A-E
- O4 A-F
- ...
- ALTER TABLE `Question`
- ADD CONSTRAINT `SessionId`
- FOREIGN KEY (`SessionId` )
- REFERENCES `Option_Table` (`OptionId` )
- ON DELETE NO ACTION
- ON UPDATE CASCADE
- , ADD INDEX `test_idx` (`SessionId` ASC) ;
- ALTER TABLE `Question` DROP FOREIGN KEY `SessionId` ;
Add Comment
Please, Sign In to add comment