ALTER TABLE school_year MODIFY COLUMN activities_scy
set('NOTAPPLY','INSCRIPTION','EXTRACURRICULAR','CRON','ENABLE_SCALE','QLT_SUBJ_LAST_POS_MIN','NOT_SHOW_TOTAL_AVERAGES','APPLY_DCM_IN_ASIGN_PAYMENT_MODE','HAS_TRAVEL_WIZARD','CHECK_PAYMENTS_IN_TRAVEL','CHECK_PAYMENTS_IN_GENERAL_REPORT','USE_INFORMATIVE_DEBTS','RESET_TRAVEL_FORMAT_UPDATE_ADDRESS','CHECKLIST','HIDE_SCLAE_POINTS','CHECK_PAYMENTS_IN_REGISTER_TO_EXTRACURRICULAR','REGISTER_OBSERVATIONS_BY_SUBJRECT_BY_SUBPERIOD','IN_THIRD_PARCIAL_SET_MAX_GRADE','SHOW_STUDENT_PHOTO_ON_REPORT','CHECK_SUMMATIVE_IN_GRADE','SHOW_AMOUNT_OF_FEES','RUN_ASIGN_MASSIVE_PAYMENTS','APPLICATION_FORM','CHECK_COURSE_IN_UPLOAD_MATRICULE_FILES','ECONOMIC_HELP','MANY_SUBJECT_IN_A_CREDIT','OBSERVATION_GRADE_ACTIVITY') NULL DEFAULT 'NOTAPPLY';

CREATE TABLE IF NOT EXISTS observation_grades (
  serial_obg int NOT NULL AUTO_INCREMENT,
  serial_std int NULL DEFAULT NULL,
  serial_act int NULL DEFAULT NULL,
  serial_opa int NULL DEFAULT NULL,
  observation_obg varchar(400) NULL,
  status_obg enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  PRIMARY KEY (serial_obg)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

