CREATE TABLE `rq_qbank_quiz_users` (
                       `quiz_id` int(11) NOT NULL,                              
                       `user_id` int(11) DEFAULT NULL,                          
                       `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP  
                     );

alter table `rq_qbank_quiz` add column `quiz_taqs` varchar(255) NULL after `difficulty_level_id`, add column `review_quiz_opt` int(2) DEFAULT '1' NOT NULL COMMENT '1=>New Quiz, 2=>Review Quiz' after `quiz_taqs`;

alter table `rq_qbank_quiz_section` change `title` `title` varchar(255) character set latin1 collate latin1_swedish_ci NULL , change `no_of_questions` `no_of_questions` int(11) NULL , change `multiple` `multiple` int(11) NULL , change `alternative` `alternative` int(11) NULL , change `direction` `direction` int(11) NULL , change `hints` `hints` int(11) NULL , change `pictures` `pictures` int(11) NULL , change `speech` `speech` int(11) NULL , change `pos` `pos` int(11) NULL , change `grammer` `grammer` int(11) NULL , change `attempts` `attempts` int(11) NULL , change `next_level` `next_level` int(11) NULL , change `review` `review` int(11) NULL , change `question_attempts` `question_attempts` int(11) NULL , change `save_quiz` `save_quiz` int(11) NULL , change `review_quiz` `review_quiz` int(11) NULL , change `timer` `timer` int(11) NULL , change `random` `random` int(11) NULL , change `generate_quiz` `generate_quiz` int(11) NULL , change `hide_questions` `hide_questions` int(11) NULL , change `created_at` `created_at` datetime DEFAULT NULL , change `updated_at` `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP;

alter table `rq_qbank_section_detail` change `section_id` `section_id` int(11) NULL , change `all_question` `all_question` varchar(100) character set latin1 collate latin1_swedish_ci NULL , change `from_question` `from_question` int(11) NULL , change `to_question` `to_question` int(11) NULL , change `options` `options` varchar(150) character set latin1 collate latin1_swedish_ci NULL , change `customized_direction` `customized_direction` varchar(255) character set latin1 collate latin1_swedish_ci NULL , change `hints` `hints` int(11) NULL  comment '1 for picture, 2 for text, 3 for picture and text ', change `height` `height` int(11) NULL  comment 'if option type is pictures', change `width` `width` int(11) NULL  comment 'if option type is width', change `speech` `speech` int(11) NULL  comment '1 for speech, 2 for audio', change `option_type` `option_type` varchar(150) character set latin1 collate latin1_swedish_ci NULL , change `created_at` `created_at` datetime DEFAULT NULL , change `updated_at` `updated_at` timestamp default CURRENT_TIMESTAMP NULL;
