search-course/database/update.sql

 TRUNCATE TABLE `campuses`;
 TRUNCATE TABLE `course_campuses`;
 TRUNCATE TABLE `course_intakes`;
 TRUNCATE TABLE `course_tags`;
 TRUNCATE TABLE `courses`;
 TRUNCATE TABLE `destinations`;
 TRUNCATE TABLE `institutes`;
 TRUNCATE TABLE `levels`;


ALTER TABLE `courses`
CHANGE `ielts` `ielts` tinytext NULL DEFAULT NULL,
CHANGE `toefl` `toefl` tinytext NULL DEFAULT NULL,
CHANGE `pte` `pte` tinytext NULL DEFAULT NULL,
CHANGE `duolingo` `duolingo` tinytext NULL DEFAULT NULL,
ADD COLUMN `entry_requirement` longtext NULL DEFAULT NULL AFTER `reference`;

ALTER TABLE `destinations`
ADD COLUMN `short_code` varchar(255) NULL DEFAULT NULL AFTER `name`,
ADD COLUMN `currency` varchar(255) NULL DEFAULT NULL AFTER `short_code`;


ALTER TABLE `courses`
CHANGE `deposit_required` `deposit_required` tinytext NULL DEFAULT NULL;

ALTER TABLE `courses`
CHANGE `scholarship` `scholarship` tinytext NULL DEFAULT NULL;