temp

-- Adminer 4.2.5 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

USE `dps_registrar_db`;

DROP TABLE IF EXISTS `college_unit_fee_details_percourse`;
CREATE TABLE `college_unit_fee_details_percourse` (
  `unitfee_id` int(11) NOT NULL AUTO_INCREMENT,
  `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` varchar(255) NOT NULL,
  `cc_id` int(10) NOT NULL,
  `yl_name` varchar(255) NOT NULL,
  `course_name` varchar(255) NOT NULL,
  PRIMARY KEY (`unitfee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

TRUNCATE `college_unit_fee_details_percourse`;
INSERT INTO `college_unit_fee_details_percourse` (`unitfee_id`, `unit_name`, `yl_id`, `unit_type`, `unit_amount`, `unit_date`, `unit_status`, `sy_id`, `type_unit`, `cc_id`, `yl_name`, `course_name`) VALUES
(1, 'General Collegiate',   19, 0,  0,  '', '', 0,  'Per 1 unit',   1,  'First Year',   'AMT'),
(2, 'Computer Subject', 19, 0,  0,  '', '', 0,  'Per 3 unit',   1,  'First Year',   'AMT'),
(3, 'General Collegiate',   20, 1,  0,  '', '', 0,  'Per 1 unit',   1,  'Second Year',  'AMT'),
(4, 'Computer Subject', 20, 1,  0,  '', '', 0,  'Per 3 unit',   1,  'Second Year',  'AMT'),
(5, 'General Collegiate',   21, 2,  0,  '', '', 0,  'Per 1 unit',   1,  'Third Year',   'AMT'),
(6, 'Computer Subject', 21, 2,  0,  '', '', 0,  'Per 3 unit',   1,  'Third Year',   'AMT'),
(7, 'General Collegiate',   22, 3,  0,  '', '', 0,  'Per 1 unit',   1,  'Fourt Year',   'AMT'),
(8, 'Computer Subject', 22, 3,  0,  '', '', 0,  'Per 3 unit',   1,  'Fourt Year',   'AMT'),
(9, 'General Collegiate',   23, 4,  0,  '', '', 0,  'Per 1 unit',   1,  'Fifth Year',   'AMT'),
(10,    'Computer Subject', 23, 4,  0,  '', '', 0,  'Per 3 unit',   1,  'Fifth Year',   'AMT');

-- 2017-08-02 06:38:04