


--
-- Table structure for table `rq_subscriber`
--

CREATE TABLE `rq_subscriber` (
  `subscriber_id` int(11) NOT NULL,
  `admin_user_id` int(11) DEFAULT NULL,
  `centre_name` varchar(200) DEFAULT NULL,
  `avatar` varchar(100) DEFAULT NULL,
  `location` varchar(200) DEFAULT NULL,
  `centre_number` varchar(20) DEFAULT NULL,
  `subscription_expiry_date` datetime DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `last_updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `rq_subscriber` ADD UNIQUE( `subscriber_id`);
ALTER TABLE `rq_subscriber` ADD INDEX( `subscriber_id`);
ALTER TABLE `rq_subscriber` CHANGE `subscriber_id` `subscriber_id` INT(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `rq_subscriber` ADD `duplicate_system` TINYINT(1) NULL DEFAULT NULL AFTER `status`;

CREATE TABLE `rq_subscription` (
  `subscription_id` int(11) DEFAULT NULL  AUTO_INCREMENT,
  `subscriber_id` int(11) DEFAULT NULL,
  `payment_id` varchar(20) DEFAULT NULL,
  `package_id` INT(11) DEFAULT NULL,
  `amount_paid` varchar(20) DEFAULT NULL,
  `subscription_expiry_date` datetime DEFAULT NULL,
  `payment_date` datetime DEFAULT NULL,
  `remark` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `last_updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
   PRIMARY KEY (`subscription_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `rq_subscription` ADD `subscription_meta_data` TEXT NOT NULL AFTER `remark`;
-- Check complete table before going to server
-- check complete table of subscriber
-- check subscription table as well as removed paymetId expir date field and added a new column for currency 
CREATE TABLE `rq_subscription_packages` (
  `package_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `access_level` varchar(200) DEFAULT NULL,
  `price` INT(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `last_updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
   PRIMARY KEY ( package_id )
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `rq_subscription_packages` ADD `package_stripe_id` VARCHAR(50) NOT NULL AFTER `description`;
alter table notes add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_adminapprove add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_attendance add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_attendance_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_attendance_makeupclass add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_attendance_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_attendance_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_folders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_audios_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_categories add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_categories_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_categories_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_categories_promotions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_categories_tags add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_codearena add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_folders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_projects add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_projects_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_projects_likes add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_code_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_course_meta add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_courses add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_courses_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_folders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictations_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_dictionary add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_folders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_drama_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_folders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_foundations_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammar_folders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_rocket_state add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_grammars_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_folders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_homeworks_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_inbox_msg add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_jslogs add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_levels add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_levels_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_levels_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_makeupclass add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_makeupclass_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_folders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_rocket_state add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_math_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_maths_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_options_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_options_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_orders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_orders_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_orders_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_orders_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_orders_items add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_orders_items_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_orders_transitions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_pages add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_pages_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_pages_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_pages_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_pages_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_pages_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_payment add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_payment_comment add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_payments add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_payments_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_payments_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_rocket_state add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_score_card add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_assessment_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_folders add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_gameqz_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_gameqz_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_gameqz_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_rocket_state add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_worksheet_result add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_phonics_worksheet_result_status add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_products add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_products_categories add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_products_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_products_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_products_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_products_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_products_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_products_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_puzzle add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_puzzle_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_puzzle_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_puzzle_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_puzzle_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_difficulty_level add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_hint add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_parent_category add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_question_bank add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_question_type add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_question_vocabulary add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_question_word_mapping add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_questionbank_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_questionbank_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_questionbank_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_quiz add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_quiz_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_quiz_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_quiz_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_quiz_question_mapping add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_quiz_section add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_quiz_section_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_quiz_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_result_card add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_result_card_details add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_section_detail add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_student_answer add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_subject_type add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_tags add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_qbank_vocabulary add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reports add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reports_bak20161218 add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reports_wrong add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_resource_permissions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_crons add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_generate add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_questions add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_questions_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_questions_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_questions_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_questions_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_questions_options_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_questions_options_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_questions_options_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_questions_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_reviews_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_settings add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_settings_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_settings_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_settings_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_settings_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_tags add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_tags_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_user_meta add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_users_cart add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_users_deliveries add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_users_details add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_users_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_users_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_users_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_users_save add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_variants add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_variants_inventories add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_variants_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_variants_logs add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_variants_options add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_variants_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_vips add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_vips_designers add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_vips_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_vips_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_webhooks_events add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_wordsgame add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_wordsgame_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_wordsgame_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_answers add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_files add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_files_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_files_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_priority add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_users add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_videos add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_videos_lang add column subscriber_id INT(11) NULL DEFAULT "1";
alter table rq_writings_videos_priority add column subscriber_id INT(11) NULL DEFAULT "1";