migration script for dpr 2017 31 05

CREATE TABLE `college_subject_grades` (
  `csg_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `stud_applicant_id` int(10) NOT NULL,
  `sy_id` int(10) NOT NULL,
  `yl_id` int(10) NOT NULL,
  `csm_id` int(10) NOT NULL,
  `caq_open` int(10) NOT NULL,
  `dept_id` int(10) NOT NULL,
  `cc_id` int(10) NOT NULL,
  `ccc_id` int(10) NOT NULL,
  `csh_id` int(10) NOT NULL,
  `css_id` int(10) NOT NULL,
  `pi_id` int(10) NOT NULL,
  `cbas_id` int(10) NOT NULL,
  `added_when` timestamp NOT NULL,
  `midterm` float(10) NOT NULL,
  `midterm_dec` float(10) NOT NULL,
  `prelim` float(10) NOT NULL,
  `additional_point` float(10) NOT NULL,
  `prelim_dec` float(10) NOT NULL,
  `final` float(10) NOT NULL,
  `final_dec` float(10) NOT NULL,
  `isprelim_grade_final` int(10) NOT NULL,
  `csg_remarks` varchar(255) NOT NULL,
  `ismidterm_grade_final` int(10) NOT NULL,
  `cs_id` int(10) NOT NULL,
  `additional_point_dec` float(10) NOT NULL,
  `isfinal_grade_final` int(10) NOT NULL,
  `equivalent_grade` float(10) NOT NULL,
  `csg_status` int(10) NOT NULL
) ENGINE='MyISAM' COLLATE 'utf8_general_ci';