ALTER TABLE `assignment_tb`
  DROP INDEX `idx_assignment_class_status`,
  DROP COLUMN `class_id`,
  ADD COLUMN `description` TEXT NULL AFTER `title`,
  ADD COLUMN `resource_url` VARCHAR(500) NULL AFTER `description`,
  ADD KEY `idx_assignment_status` (`status`);