migration script for unit fee details college

INSERT INTO `app_modules` (`mnu_name`, `mnu_desc`, `mnu_icon`, `mnu_parent`, `mnu_ord`, `mnu_link`, `mnu_status`, `mnu_link_info`)
SELECT 'Unit Fee Details', '', '', '96', '51', 'setup.php?statpos=unit_fee_details', '1', 'a:18:{s:8:\"linkpage\";s:9:\"setup.php\";s:7:\"statpos\";s:20:\"unit_fee_details\";s:11:\"querystring\";s:0:\"\";s:14:\"maincontroller\";s:0:\"\";s:18:\"default_controller\";s:0:\"\";s:19:\"controller_filename\";s:47:\"admin/setup/unit_fee_details.controller.php\";s:14:\"class_filename\";s:42:\"admin/setup/unit_fee_details.class.php\";s:10:\"class_name\";s:17:\"clsUnitFeeDetails\";s:17:\"template_filename\";s:40:\"admin/setup/unit_fee_details.tpl.php\";s:21:\"templateform_filename\";s:45:\"admin/setup/unit_fee_details_form.tpl.php\";s:7:\"chkmenu\";s:1:\"1\";s:7:\"chkmain\";N;s:13:\"chkcontroller\";s:1:\"1\";s:8:\"chkclass\";s:1:\"1\";s:11:\"chktemplate\";s:1:\"1\";s:15:\"chktemplateform\";s:1:\"1\";s:5:\"ud_id\";a:4:{i:0;s:1:\"2\";i:1;s:1:\"4\";i:2;s:1:\"3\";i:3;s:1:\"1\";}s:9:\"user_type\";a:2:{i:0;s:19:\"Super Administrator\";i:1;s:13:\"Administrator\";}}'
FROM `app_modules`
WHERE ((`mnu_id` = '205'));


CREATE TABLE `college_unit_fee_details` (
  `unit_fee_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `name` varchar(255) NOT NULL,
  `year_level` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `amount` float(10) NOT NULL,
  `date` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `sy_id` int(10) NOT NULL
);


INSERT INTO `college_unit_fee_details` (`unit_fee_id`, `name`, `year_level`, `type`, `amount`, `date`, `status`, `sy_id`, `type_unit`) VALUES
(1, 'CCS Non-major',    'First and Second', '1',    1000,   '', '', 0,  'Per Unit'),
(2, 'CCS Major',    'First and Second', '2',    1000,   '', '', 0,  'Per 3 Unit'),
(3, 'CCS Non-major',    'Third and Fourth', '3',    1000,   '', '', 0,  'Per Unit'),
(4, 'CCS Major',    'Third and Fourth', '4',    1000,   '', '', 0,  'Per 3 Unit'),
(5, 'General Collegiate',   'First and Second', '5',    1000,   '', '', 0,  'Per Unit'),
(6, 'General Collegiate',   'Third and Fourth', '6',    1000,   '', '', 0,  'Per Unit'),
(7, 'Computer Subject', 'First and Second', '7',    56, '', '', 0,  'Per 3 Unit'),
(8, 'Computer Subject', 'Third and Fourth', '8',    324,    '', '', 0,  'Per 3 Unit');

ALTER TABLE `college_unit_fee_details`
CHANGE `type` `type` varchar(255) COLLATE 'latin1_swedish_ci' NOT NULL COMMENT '1=non major,2 = major, 3 = per 1 unit, 4 = per 3 unit ' AFTER `year_level`;


ALTER TABLE `college_course_curriculum_2016_2017`
ADD `unit_fee_id` int(10) NOT NULL;