badlogic

new migration script for updated unit fee details

May 4th, 2017
309
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.68 KB | None | 0 0
  1. CREATE TABLE `college_unit_fee_details_percourse` (
  2.   `unitfee_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  3.   `unit_name` varchar(255) NOT NULL,
  4.   `yl_id` int(10) NOT NULL,
  5.   `unit_type` int(10) NOT NULL,
  6.   `unit_amount` float NOT NULL,
  7.   `unit_date` varchar(255) NOT NULL,
  8.   `unit_status` varchar(255) NOT NULL,
  9.   `sy_id` int(10) NOT NULL,
  10.   `type_unit` int(10) NOT NULL,
  11.   `cc_id` int(10) NOT NULL,
  12.   `yl_name` varchar(255) NOT NULL
  13. );
  14.  
  15. ALTER TABLE `college_unit_fee_details_percourse`
  16. ADD `course_name` varchar(255) COLLATE 'latin1_swedish_ci' NOT NULL;
  17.  
  18. ALTER TABLE `college_unit_fee_details_percourse`
  19. CHANGE `type_unit` `type_unit` varchar(255) NOT NULL AFTER `sy_id`;
Add Comment
Please, Sign In to add comment