CREATE TABLE `class_group_ministry_equivalence` (
  `serial_clgme` INT(11) NOT NULL AUTO_INCREMENT,
  `name_clgme` VARCHAR(45) NOT NULL,
  `description_clgme` TEXT NULL DEFAULT NULL,
  `status_clgme` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_clgme`));

ALTER TABLE `course` 
ADD COLUMN `serial_clgme` INT(11) NULL DEFAULT NULL AFTER `serial_set`,
ADD INDEX `fk_selected_class_ministry_equivalence_idx` (`serial_clgme` ASC);
ALTER TABLE `course` 
ADD CONSTRAINT `fk_selected_class_ministry_equivalence`
FOREIGN KEY (`serial_clgme`)
REFERENCES `class_group_ministry_equivalence` (`serial_clgme`)
ON DELETE RESTRICT
ON UPDATE RESTRICT;

