Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `college_unit_fee_details_percourse` (
- `unitfee_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
- `unit_name` varchar(255) NOT NULL,
- `yl_id` int(10) NOT NULL,
- `unit_type` int(10) NOT NULL,
- `unit_amount` float NOT NULL,
- `unit_date` varchar(255) NOT NULL,
- `unit_status` varchar(255) NOT NULL,
- `sy_id` int(10) NOT NULL,
- `type_unit` int(10) NOT NULL,
- `cc_id` int(10) NOT NULL,
- `yl_name` varchar(255) NOT NULL
- );
- ALTER TABLE `college_unit_fee_details_percourse`
- ADD `course_name` varchar(255) COLLATE 'latin1_swedish_ci' NOT NULL;
- ALTER TABLE `college_unit_fee_details_percourse`
- CHANGE `type_unit` `type_unit` varchar(255) NOT NULL AFTER `sy_id`;
Add Comment
Please, Sign In to add comment