ALTER TABLE `period`
ADD COLUMN `min_grade_dsc_prd` DECIMAL(8,5) NOT NULL DEFAULT 0 AFTER `warning_grade_prd`,
ADD COLUMN `max_grade_dsc_prd` DECIMAL(8,5) NOT NULL DEFAULT 10 AFTER `min_grade_dsc_prd`,
ADD COLUMN `min_grade_dsc_min_prd` DECIMAL(8,5) NOT NULL DEFAULT 0 AFTER `max_grade_dsc_prd`,
ADD COLUMN `max_grade_dsc_min_prd` DECIMAL(8,5) NOT NULL DEFAULT 10 AFTER `min_grade_dsc_min_prd`,
ADD COLUMN `min_grade_disc_equivalence_prd` DECIMAL(8,5) NOT NULL DEFAULT 0 AFTER `max_grade_dsc_min_prd`,
ADD COLUMN `max_grade_disc_equivalence_prd` DECIMAL(8,5) NOT NULL DEFAULT 10 AFTER `min_grade_disc_equivalence_prd`;


CREATE TABLE `notification_recurring_incidences` (
  `serial_nri` int(11) NOT NULL AUTO_INCREMENT,
  `serial_ica` int(11) NOT NULL,
  `number_incidences` int(11) NOT NULL,
  `status_nri` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_nri`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;



CREATE TABLE `discipline_ministry_equivalence` (
  `serial_dme` int(11) NOT NULL AUTO_INCREMENT,
  `serial_scy` int(11) DEFAULT NULL,
  `lower_percentage_dme` decimal(5,2) NOT NULL,
  `higher_percentage_dme` decimal(5,2) NOT NULL,
  `name_dme` varchar(50) NOT NULL,
  `description_dme` varchar(200) DEFAULT NULL,
  `code_dme` varchar(15) NOT NULL,
  `status_dme` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_dme`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;