Advertisement
badlogic

migration script additional point dprpats grading

Jul 4th, 2017
350
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 0.50 KB | None | 0 0
  1. ALTER TABLE `college_subject_grades`
  2. ADD `additional_point_lab` float NOT NULL,
  3. ADD `additional_point_dec_lab` float NOT NULL AFTER `additional_point_lab`;
  4.  
  5. ALTER TABLE `college_subject_grades`
  6. ADD `semestral_lec` float NOT NULL,
  7. ADD `semestral_lab` float NOT NULL AFTER `semestral_lec`;
  8.  
  9. ALTER TABLE `college_subject_grades`
  10. ADD `equivalent_grade_lab` float NOT NULL;
  11.  
  12. ALTER TABLE `college_subject_grades`
  13. CHANGE `equivalent_grade_lab` `equivalent_grade_lab` varchar(255) NOT NULL AFTER `semestral_lab`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement