ADC Fee Details

INSERT INTO `app_modules` (`mnu_name`, `mnu_desc`, `mnu_icon`, `mnu_parent`, `mnu_ord`, `mnu_link`, `mnu_status`, `mnu_link_info`)
SELECT 'ADC Fee Details', '', '', '96', '56', 'setup.php?statpos=adc_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/adc_fee_details.controller.php\";s:14:\"class_filename\";s:42:\"admin/setup/adc_fee_details.class.php\";s:10:\"class_name\";s:17:\"clsAdcFeeDetails\";s:17:\"template_filename\";s:40:\"admin/setup/adc_fee_details.tpl.php\";s:21:\"templateform_filename\";s:45:\"admin/setup/adc_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` = '210'));



-- 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_adc_fee_details`;
CREATE TABLE `college_adc_fee_details` (
  `adc_id` int(11) NOT NULL AUTO_INCREMENT,
  `adc_name` varchar(255) NOT NULL,
  `adc_status` int(10) NOT NULL,
  `adc_amount` varchar(255) NOT NULL,
  `adc_type` varchar(255) NOT NULL,
  PRIMARY KEY (`adc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

TRUNCATE `college_adc_fee_details`;
INSERT INTO `college_adc_fee_details` (`adc_id`, `adc_name`, `adc_status`, `adc_amount`, `adc_type`) VALUES
(1, 'Payment Per Subject',  1,  '900',  ''),
(2, 'Payment Per Transaction',  0,  '600',  '');

-- 2017-04-10 08:33:38



INSERT INTO `app_modules` (`mnu_name`, `mnu_desc`, `mnu_icon`, `mnu_parent`, `mnu_ord`, `mnu_link`, `mnu_status`, `mnu_link_info`)
SELECT 'ADC Assessment', '', '', '144', '31', 'registration.php?statpos=adc_assessment', '1', 'a:18:{s:8:\"linkpage\";s:16:\"registration.php\";s:7:\"statpos\";s:14:\"adc_assessment\";s:11:\"querystring\";s:0:\"\";s:14:\"maincontroller\";s:22:\"admin/registration.php\";s:18:\"default_controller\";s:15:\"admin/index.php\";s:19:\"controller_filename\";s:48:\"admin/registration/adc_assessment.controller.php\";s:14:\"class_filename\";s:43:\"admin/registration/adc_assessment.class.php\";s:10:\"class_name\";s:16:\"clsAdcAssessment\";s:17:\"template_filename\";s:41:\"admin/registration/adc_assessment.tpl.php\";s:21:\"templateform_filename\";s:46:\"admin/registration/adc_assessment_form.tpl.php\";s:7:\"chkmenu\";s:1:\"1\";s:7:\"chkmain\";N;s:13:\"chkcontroller\";N;s:8:\"chkclass\";N;s:11:\"chktemplate\";N;s:15:\"chktemplateform\";N;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` = '179'));


CREATE TABLE `college_adc_assessment_header` (
  `caah_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `fad_id` int(10) NOT NULL,
  `stud_applicant_id` int(10) NOT NULL,
  `caah_status` int(10) NOT NULL
);

ALTER TABLE `college_adc_assessment_header`
ADD `caah_trans_date` varchar(255) NOT NULL;


CREATE TABLE `college_adc_assessment_payments` (
  `caapd_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `caah_id` int(11) NOT NULL,
  `caapd_amount` varchar(255) NOT NULL,
  `caapd_transaction_date` varchar(255) NOT NULL,
  `sy_id` int(10) NOT NULL,
  `yl_id` int(10) NOT NULL,
  FOREIGN KEY (`caah_id`) REFERENCES `college_adc_assessment_header` (`caah_id`)
);

ALTER TABLE `college_adc_assessment_header`
CHANGE `caah_status` `caah_status` int(10) NOT NULL COMMENT '1 = assess, 0 = not assess' AFTER `stud_applicant_id`;


ALTER TABLE `college_adc_assessment_payments`
DROP FOREIGN KEY `college_adc_assessment_payments_ibfk_1`,
ADD FOREIGN KEY (`caah_id`) REFERENCES `college_adc_assessment_header` (`caah_id`) ON DELETE CASCADE ON UPDATE CASCADE