CREATE TABLE `qbank` (
  `UtyId` smallint(6) DEFAULT NULL,
  `QuestionID` int(11) NOT NULL AUTO_INCREMENT,
  `SubjectId` smallint(6) DEFAULT NULL,
  `SyllabusID` int(11) NOT NULL,
  `TopicID` int(11) NOT NULL,
  `QTypeID` int(11) NOT NULL,
  `QText` mediumtext NOT NULL,
  `QText_Enc` mediumblob,
  `LangID` tinyint(4) DEFAULT NULL,
  `QMarks` float DEFAULT NULL,
  `TimeToAnswer` smallint(6) DEFAULT NULL,
  `AnsLengthWords` smallint(6) DEFAULT NULL,
  `DifficultyID` tinyint(4) NOT NULL,
  `PGroupId` int(11) NOT NULL DEFAULT '0',
  `IsActive` tinyint(1) NOT NULL DEFAULT '1',
  `Tag1` varchar(100) DEFAULT NULL,
  `Ans_And_Or` tinyint(4) DEFAULT NULL COMMENT 'To provide additional conf. for MCQ',
  `DistributionId` tinyint(4) DEFAULT NULL,
  `Descriptivetype` char(4) DEFAULT NULL,
  `CoLevel` smallint(2) DEFAULT NULL,
  `BloomsLevel` smallint(2) DEFAULT NULL,
  `CreatedBy` varchar(100) DEFAULT NULL,
  `CreatedOn` datetime DEFAULT NULL,
  `ModifiedBy` varchar(100) DEFAULT NULL,
  `ModifiedOn` datetime DEFAULT NULL,
  PRIMARY KEY (`QuestionID`),
  KEY `qbank_utysylbtopc_idx` (`UtyId`,`SyllabusID`,`TopicID`)
) ENGINE=InnoDB AUTO_INCREMENT=77281 DEFAULT CHARSET=utf8

CREATE TABLE `qbank_ans_keys` (
  `UtyId` smallint(6) DEFAULT NULL,
  `QuestionID` int(11) NOT NULL,
  `AnsKeyID` tinyint(4) NOT NULL,
  `AnsKeyNo` varchar(100) DEFAULT NULL,
  `AnsKeyText` mediumtext NOT NULL,
  `AnsKeyMarks` float DEFAULT NULL,
  `IsActive` tinyint(1) NOT NULL DEFAULT '1',
  `CreatedBy` varchar(100) NOT NULL,
  `CreatedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8