ALTER TABLE `nt_institute_cash_balance` ADD `balance_is_credit_debit` ENUM('credit','debit') NOT NULL AFTER `balance_status`;
ALTER TABLE `nt_institute_banks_balance` ADD `balance_is_credit_debit` ENUM('credit','debit') NOT NULL AFTER `balance_adjusted_amount`;


ALTER TABLE `nt_institute_hrm_roles` ADD `is_editable_deletable` ENUM('no','yes') NOT NULL AFTER `role_permissions`;

ALTER TABLE `nt_institute_sessions_courses` ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`;
ALTER TABLE `nt_institute_sessions_courses` ADD `updated_at` DATETIME NULL DEFAULT NULL AFTER `updated_by`;


ALTER TABLE `nt_system_excel_data` ADD `admission_fee` TEXT NULL DEFAULT NULL AFTER `fee`, ADD `discount` TEXT NULL DEFAULT NULL AFTER `admission_fee`;

ALTER TABLE `nt_system_excel_data` ADD `caste` VARCHAR(255) NULL DEFAULT NULL AFTER `dob`;

ALTER TABLE `nt_system_excel_data` ADD `tenth_total_marks` VARCHAR(255) NULL DEFAULT NULL AFTER `tenth_passing_marks`;

ALTER TABLE `nt_institute_students_academics` CHANGE `acad_12th_board` `acad_12th_board` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `nt_institute_students_academics` CHANGE `acad_12th_yop` `acad_12th_yop` VARCHAR(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `nt_institute_students_academics` CHANGE `acad_stu_inst_parent_id` `acad_stu_inst_parent_id` BIGINT(20) NULL DEFAULT NULL;


ALTER TABLE `nt_institute_payments_details` CHANGE `details_payment_type` `details_payment_type` ENUM('admission_fees','installment_fees','installment_split_fees','installment_balance_fees','installment_split_balance_fees','hostel_fees','seatbooking_fees','seatbooking_balance_fees','hostel_admission_fees_payment','seatbooking_agent_fees','admission_agent_fees','canteen_vendor_fees','employee_salary','other') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

ALTER TABLE `nt_institute_payments_admission_fees_details` CHANGE `pay_mode` `pay_mode` ENUM('cash','cheque','online','phonepeutr','cash_split','online_before_software_split','old_payment_before_software') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;



23/12/2024
----------
ALTER TABLE `nt_institute` ADD `user_has_online_pay_mode` ENUM('no','yes') NOT NULL AFTER `user_has_ams_access`, ADD `user_has_split_pay_mode` ENUM('no','yes') NOT NULL AFTER `user_has_online_pay_mode`;
ALTER TABLE `nt_institute_payments_details` ADD `details_accounting_account` VARCHAR(255) NULL DEFAULT NULL AFTER `details_accounting_type_id`, ADD `details_accounting_account_id` INT NULL DEFAULT NULL AFTER `details_accounting_account`;
ALTER TABLE `nt_institute_cash_balance` ADD `balance_ref_code` VARCHAR(255) NULL DEFAULT NULL AFTER `balance_inst_type`;

26/12/2024
----------
ALTER TABLE `nt_institute_ctm_accounts_category` ADD `category_type` INT NOT NULL AFTER `is_editable`;
ALTER TABLE `nt_institute_payments_details` ADD `details_vendor_id` BIGINT NULL DEFAULT NULL AFTER `details_parent_inst_id`;

CREATE TABLE `nt_institute_amount_transfers` (
  `id` int(10) UNSIGNED NOT NULL,
  `intitute_id` int(10) UNSIGNED NOT NULL,
  `intitute_parent_id` int(10) UNSIGNED NOT NULL,
  `amount` int(11) DEFAULT NULL,
  `purpose` varchar(191) DEFAULT NULL,
  `from_payment_method` int(11) DEFAULT NULL,
  `from_bank_name` int(11) DEFAULT NULL,
  `to_payment_method` int(11) DEFAULT NULL,
  `to_bank_name` int(11) DEFAULT NULL,
  `transfer_date` date DEFAULT NULL,
  `active_status` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `nt_institute_amount_transfers` ADD PRIMARY KEY(`transfer_id`);
ALTER TABLE `nt_institute_amount_transfers` CHANGE `transfer_id` `transfer_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `nt_institute_amount_transfers` CHANGE `from_payment_method` `from_payment_method` VARCHAR(11) NULL DEFAULT NULL;
ALTER TABLE `nt_institute_amount_transfers` CHANGE `to_payment_method` `to_payment_method` VARCHAR(11) NULL DEFAULT NULL;
ALTER TABLE `nt_institute_amount_transfers` CHANGE `id` `transfer_id` INT(10) UNSIGNED NOT NULL;
ALTER TABLE `nt_institute_amount_transfers` CHANGE `active_status` `status` ENUM('active','inactive') NULL;
ALTER TABLE `nt_institute_amount_transfers` ADD `created_by` BIGINT UNSIGNED NOT NULL AFTER `status`, ADD `created_by_type` VARCHAR(255) NULL DEFAULT NULL AFTER `created_by`;
ALTER TABLE `nt_institute_amount_transfers` ADD `updated_by` BIGINT UNSIGNED NOT NULL AFTER `created_by_type`, ADD `updated_by_type` VARCHAR(255) NULL DEFAULT NULL AFTER `updated_by`;


27-12-24
--------
ALTER TABLE `nt_institute_banks_balance` CHANGE `balance_is_credit_debit` `balance_is_credit_debit` ENUM('credit','debit','transfer_credit','transfer_debit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `nt_institute_banks_balance` ADD `balance_transfer_id` INT NULL DEFAULT '0' AFTER `balance_inst_id`;
ALTER TABLE `nt_institute_cash_balance` CHANGE `balance_is_credit_debit` `balance_is_credit_debit` ENUM('credit','debit','transfer_credit','transfer_debit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `nt_institute_cash_balance` ADD `balance_transfer_id` INT NULL DEFAULT '0' AFTER `balance_inst_id`;


ALTER TABLE `nt_institute_amount_transfers` CHANGE `status` `status` ENUM('approved','not_approved') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `nt_institute_amount_transfers` CHANGE `status` `status` ENUM('approved','not_approved','pending') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `nt_institute_admissions` ADD `is_old_data` ENUM('no','yes') NOT NULL AFTER `admission_payment_can_be_scheduled`;
ALTER TABLE `nt_institute` ADD `in_bill_print` ENUM('installment','semester') NULL DEFAULT 'installment' AFTER `user_expire_at`;


30-12-24
--------
ALTER TABLE `nt_institute_ctm_accounts_category` CHANGE `category_type` `category_type` ENUM('income','expense','assets','liabilities','equity','cost_of_goods_sold') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `nt_institute_ctm_accounts_category` ADD `category_type_id` INT NOT NULL AFTER `category_type`;

31-12-24
--------
ALTER TABLE `nt_institute_ctm_accounts_category` ADD `category_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL DEFAULT NULL AFTER `category_inst_type`;

01-01-2025
----------
ALTER TABLE `nt_institute_payments_details` CHANGE `details_accounting_type` `details_accounting_type` ENUM('not_settled','income','expenditure','assets','liabilities','equity') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
ALTER TABLE `nt_institute_payments_details` ADD `details_accounting_dr_cr` ENUM('credit','debit','transfer_credit','transfer_debit') NOT NULL AFTER `details_accounting_type`;
ALTER TABLE `nt_institute_payments_details` ADD `details_accounting_type_p_id` BIGINT NULL DEFAULT NULL AFTER `details_accounting_type_id`;


INSERT INTO `nt_institute_ctm_accounts_type` (`type_id`, `type_name`, `type_group`) VALUES (NULL, 'Revenue', 'income');

02-01-2025
----------
ALTER TABLE `nt_institute_lms_books` ADD `book_acce_no` VARCHAR(255) NULL DEFAULT NULL AFTER `book_isbn`;

04-01-2025
----------
ALTER TABLE `nt_institute_lms_books` CHANGE `book_category_id` `book_category_id` TEXT UNSIGNED NULL DEFAULT NULL;


06-01-2025
----------
ALTER TABLE `nt_institute_lms_books` ADD `book_copy` INT NOT NULL DEFAULT '1' AFTER `book_price`;
ALTER TABLE `nt_institute_lms_books` CHANGE `book_category_id` `book_category_id` VARCHAR(255) NULL DEFAULT NULL;

07-01-2025
----------
ALTER TABLE `nt_institute` ADD `sem_payment_restriction` ENUM('no','yes') NOT NULL AFTER `in_bill_print`;

ALTER TABLE `nt_institute_sessions_courses_students` ADD `is_lateral` ENUM('no','yes') NOT NULL AFTER `session_course_id`;



ALTER TABLE `nt_system_excel_data` ADD `first_installment_paid` VARCHAR(255) NULL DEFAULT NULL AFTER `eighth_installment_payment_date`, ADD `second_installment_paid` VARCHAR(255) NULL DEFAULT NULL AFTER `first_installment_paid`, ADD `third_installment_paid` VARCHAR(255) NULL DEFAULT NULL AFTER `second_installment_paid`, ADD `fourth_installment_paid` VARCHAR(255) NULL DEFAULT NULL AFTER `third_installment_paid`, ADD `fifth_installment_paid` VARCHAR(255) NULL DEFAULT NULL AFTER `fourth_installment_paid`, ADD `sixth_installment_paid` VARCHAR(255) NULL DEFAULT NULL AFTER `fifth_installment_paid`, ADD `seventh_installment_paid` VARCHAR(255) NULL DEFAULT NULL AFTER `sixth_installment_paid`, ADD `eighth_installment_paid` VARCHAR(255) NULL DEFAULT NULL AFTER `seventh_installment_paid`;


08-01-2025
----------
ALTER TABLE `nt_system_excel_data` ADD `course_is_lateral` ENUM('no','yes') NOT NULL AFTER `course`;
ALTER TABLE `nt_institute_payments_admission_fees_installments` ADD `installment_value_penalty_applicable` VARCHAR(255) NULL DEFAULT NULL AFTER `installment_value_penalty`;
ALTER TABLE `nt_institute_payments_admission_fees_installments` CHANGE `installment_value_penalty` `installment_value_penalty` DECIMAL(15,2) NOT NULL DEFAULT '0.0000';
ALTER TABLE `nt_institute_payments_admission_fees` CHANGE `payment_fees_value` `payment_fees_value` DECIMAL(15,2) NOT NULL;


15-01-2025
----------
ALTER TABLE `nt_institute` ADD `phonepay_txn_required` ENUM('no','yes') NOT NULL DEFAULT 'no' AFTER `in_bill_print`;

17-01-2025
----------
ALTER TABLE `nt_institute_lms_books_issues` CHANGE `issue_user_type` `issue_user_type` ENUM('student','employee') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `nt_institute_lms_books_issues` CHANGE `issue_user_session_id` `issue_user_session_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL;
ALTER TABLE `nt_institute_lms_books_issues` ADD `issue_user_department_id` BIGINT(20) NULL DEFAULT NULL AFTER `issue_user_session_id`;

ALTER TABLE `nt_institute_lms_books_issues` ADD `issue_penalty_type` VARCHAR(255) NULL DEFAULT NULL AFTER `issue_penalty`;
ALTER TABLE `nt_institute_lms_books` ADD `book_available_copy` INT NOT NULL AFTER `book_copy`;


18-01-2025
----------
ALTER TABLE `nt_institute_lms_late_fees` ADD `book_issue_id` BIGINT NOT NULL AFTER `late_fee_id`;
ALTER TABLE `nt_institute_lms_books_issues` CHANGE `issue_status` `issue_status` ENUM('issued','renewed','returened','not_returned','lost') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;


22-01-2025
----------
ALTER TABLE `nt_institute_settings` CHANGE `settings_type` `settings_type` ENUM('payment_gateway','student_code','system_mail','email_settings','booking_fee_mandatory','money_reciept_note') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;



21-02-2025
----------
ALTER TABLE `nt_institute` ADD `user_can_edit_admission_date` ENUM('no','yes') NOT NULL AFTER `user_has_ams_access`;


06-03-2025
----------
ALTER TABLE `nt_institute_payments_admission_fees` ADD `payment_admission_fees_value` DOUBLE NULL DEFAULT '0' AFTER `payment_fees_value`;
ALTER TABLE `nt_institute` ADD `lateral_course_applicable` ENUM('no','yes') NOT NULL AFTER `in_bill_print`;
ALTER TABLE `nt_institute` ADD `lateral_sem_start` INT(3) NOT NULL AFTER `lateral_course_applicable`;

08-03-2025
----------
ALTER TABLE `nt_institute_payment_cheques_details` ADD `cheque_bounce_penalty` DOUBLE NOT NULL DEFAULT '0' AFTER `cheque_is_bounced`;
ALTER TABLE `nt_institute_payments_balance_details` CHANGE `inst_installment_id` `inst_installment_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL COMMENT 'for seatbooking it is seat booking id,for admission fees it is admission_id';
ALTER TABLE `nt_institute_payments_balance_details` CHANGE `inst_balance_type` `inst_balance_type` ENUM('admission_balance','admission_split_balance','admission_fees_split_balance','seat_booking_split_balance','canteen_vendor_balance','agent_balance') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;


19-03-2025
----------
ALTER TABLE `nt_institute_admission_late_fees` ADD `late_fee_paid` ENUM('no','yes','exampted') NOT NULL AFTER `late_fee`;
ALTER TABLE `nt_institute_payments_admission_fees` ADD `payment_through` ENUM('admission','seatbooking') NOT NULL DEFAULT 'admission' AFTER `payment_fees_id`;
ALTER TABLE `nt_institute_payments_admission_fees` ADD `payment_through_id` BIGINT NULL DEFAULT '0' COMMENT 'Default value will be 0 and if payment_through is seatbooking then the booking_id will be the value' AFTER `payment_through`;
ALTER TABLE `nt_institute_students` ADD `stu_record_old` ENUM('yes','no') NOT NULL AFTER `stu_removed`;
ALTER TABLE `nt_institute_seat_bookings` ADD `is_lateral` ENUM('no','yes') NOT NULL AFTER `booking_is_new`;



21-03-2025
----------
ALTER TABLE `nt_institute` ADD `user_has_student_reg_by_agent_access` ENUM('no','yes') NOT NULL DEFAULT 'no' AFTER `user_has_split_pay_mode`;

26-03-2025
----------
ALTER TABLE `nt_institute_lms_books_issues` CHANGE `issue_status` `issue_status` ENUM('issued','renewed','returned','not_returned','lost') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;


07-04-2025
----------
ALTER TABLE `nt_storage` CHANGE `storage_type` `storage_type` ENUM('aadhar_card','madhyamik_admit_card','madhyamik_result_card','12th_result_card','grad_result_card','post_grad_result_card','other_certificate_card','pan_card','profile_photo','college_logo','college_letter_head_image','college_seal_logo','college_branch_logo','college_printing_logo','college_report_card_logo','college_report_card_logo','college_authorize_signature_logo','college_seal_logo','student_profile_photo','student_signature_photo','madhyamik_registration_card','madhyamik_rank_card','cheque_scan_backcopy_file','cheque_scan_frontcopy_file','asset_image','employee_docs','employee_profile_image','vendor_bill','expense_account_vendor_bill') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;


09-04-2025
----------
ALTER TABLE `nt_institute_payments_balance_details` CHANGE `inst_balance_type` `inst_balance_type` ENUM('_admission_fees_balance','admission_balance','admission_split_balance','admission_fees_split_balance','seat_booking_split_balance','canteen_vendor_balance','agent_balance') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;



11-04-2025
----------
ALTER TABLE `nt_institute_hrm_employees` ADD `emp_doe` DATE NULL DEFAULT NULL AFTER `emp_doj`;
ALTER TABLE `nt_institute_hrm_employees` CHANGE `emp_aadhar_no` `emp_national_id` VARCHAR(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `nt_institute_hrm_employees` ADD `emp_national_id_type` INT NULL DEFAULT NULL AFTER `emp_national_id`;
ALTER TABLE `nt_institute_hrm_employees` ADD `emp_contract_type` INT NULL DEFAULT NULL AFTER `emp_type`;




18-04-2025
----------
ALTER TABLE `nt_institute` ADD `student_excel_format` VARCHAR(255) NULL DEFAULT NULL AFTER `sem_payment_restriction`;

ALTER TABLE `nt_system_excel_data` ADD `nineth_installment` TEXT NULL DEFAULT NULL AFTER `eighth_installment`, ADD `tenth_installment` TEXT NULL DEFAULT NULL AFTER `nineth_installment`, ADD `eleventh_installment` TEXT NULL DEFAULT NULL AFTER `tenth_installment`, ADD `twelfth_installment` TEXT NULL DEFAULT NULL AFTER `eleventh_installment`;

ALTER TABLE `nt_system_excel_data` ADD `nineth_installment_paid` TEXT NULL DEFAULT NULL AFTER `eighth_installment_paid`, ADD `tenth_installment_paid` TEXT NULL DEFAULT NULL AFTER `nineth_installment_paid`, ADD `eleventh_installment_paid` TEXT NULL DEFAULT NULL AFTER `tenth_installment_paid`, ADD `twelfth_installment_paid` TEXT NULL DEFAULT NULL AFTER `eleventh_installment_paid`;

ALTER TABLE `nt_system_excel_data` ADD `nineth_installment_payment_date` TEXT NULL DEFAULT NULL AFTER `eighth_installment_payment_date`, ADD `tenth_installment_payment_date` TEXT NULL DEFAULT NULL AFTER `nineth_installment_payment_date`, ADD `eleventh_installment_payment_date` TEXT NULL DEFAULT NULL AFTER `tenth_installment_payment_date`, ADD `twelfth_installment_payment_date` TEXT NULL DEFAULT NULL AFTER `eleventh_installment_payment_date`;

ALTER TABLE `nt_system_excel_data` ADD `seat_booking_date` TEXT NULL DEFAULT NULL AFTER `seat_booking_fee`;

ALTER TABLE `nt_system_excel_data` ADD `course_fees` TEXT NULL DEFAULT NULL AFTER `course`;

ALTER TABLE `nt_system_excel_data` ADD `college_roll_no` TEXT NULL DEFAULT NULL AFTER `blood_group`, ADD `enrollment_no` TEXT NULL DEFAULT NULL AFTER `college_roll_no`, ADD `reg_no` TEXT NULL DEFAULT NULL AFTER `enrollment_no`;

ALTER TABLE `nt_system_excel_data` ADD `pan_no` TEXT NULL DEFAULT NULL AFTER `aadhar`;

ALTER TABLE `nt_system_excel_data` ADD `method` TEXT NULL DEFAULT NULL AFTER `last_qualification`, ADD `second_method` TEXT NULL DEFAULT NULL AFTER `method`, ADD `batch` TEXT NULL DEFAULT NULL AFTER `second_method`;

ALTER TABLE `nt_system_excel_data` ADD `subject` TEXT NULL DEFAULT NULL AFTER `batch`, ADD `hons_pass` TEXT NULL DEFAULT NULL AFTER `subject`;
ALTER TABLE `nt_institute_students` ADD `stu_method_subject` TEXT NULL DEFAULT NULL AFTER `stu_passing_percentage`, ADD `stu_2nd_method_subject` TEXT NULL DEFAULT NULL AFTER `stu_method_subject`;

ALTER TABLE `nt_institute_students` ADD `stu_roll_no` TEXT NULL DEFAULT NULL AFTER `stu_user_code`, ADD `stu_enrollment_no` TEXT NULL DEFAULT NULL AFTER `stu_roll_no`, ADD `stu_reg_no` TEXT NULL DEFAULT NULL AFTER `stu_enrollment_no`;

ALTER TABLE `nt_institute_students` ADD `stu_pan` VARCHAR(255) NULL DEFAULT NULL AFTER `stu_aadhar`;

ALTER TABLE `nt_system_excel_data` ADD `total_marks` VARCHAR(255) NULL DEFAULT NULL AFTER `year_of_passing`;

ALTER TABLE `nt_system_excel_data` ADD `cgpa` VARCHAR(255) NULL DEFAULT NULL AFTER `subject`;

ALTER TABLE `nt_system_excel_data` ADD `school_name` TEXT NULL DEFAULT NULL AFTER `hons_pass`, ADD `school_yop` VARCHAR(255) NULL DEFAULT NULL AFTER `school_name`;

ALTER TABLE `nt_institute_students` ADD `stu_school_name` VARCHAR(255) NULL DEFAULT NULL AFTER `stu_guardian_occupation`, ADD `stu_school_yop` VARCHAR(255) NULL DEFAULT NULL AFTER `stu_school_name`;


Old Merges
-----------

23-04-2025
----------
ALTER TABLE `nt_system_excel_data_status` ADD `excel_file_type` TINYINT NULL DEFAULT NULL AFTER `excel_status_id`;
ALTER TABLE `nt_system_excel_data_status` CHANGE `excel_upload_status` `excel_upload_status` ENUM('uploaded_not_checked','uploaded_not_imported','uploaded_and_imported') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;


25-04-2025
------------
ALTER TABLE `nt_system_excel_data` ADD `nineth_installment_date` TEXT NULL DEFAULT NULL AFTER `eighth_installment_date`, ADD `tenth_installment_date` TEXT NULL DEFAULT NULL AFTER `nineth_installment_date`, ADD `eleventh_installment_date` TEXT NULL DEFAULT NULL AFTER `tenth_installment_date`, ADD `twelfth_installment_date` TEXT NULL DEFAULT NULL AFTER `eleventh_installment_date`;
ALTER TABLE `nt_system_excel_data` ADD `caste_id` INT NULL DEFAULT NULL AFTER `caste`;
ALTER TABLE `nt_system_excel_data` ADD `state_id` INT NULL DEFAULT NULL AFTER `state`;
ALTER TABLE `nt_system_excel_data` ADD `data_is_importable` ENUM('no','yes') NOT NULL AFTER `data_imported`;

ALTER TABLE `nt_system_excel_data` ADD `agent_id` INT NOT NULL DEFAULT '0' AFTER `agent_code`;

13-05-2025
----------
ALTER TABLE `nt_system_salary_component_types` ADD `sal_comp_calculation_types_variable` VARCHAR(255) NULL DEFAULT NULL AFTER `sal_comp_calculation_types`;


14-05-2025
----------
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: May 14, 2025 at 06:07 AM
-- Server version: 10.11.10-MariaDB-log
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u986533929_cms_devamscp`
--

-- --------------------------------------------------------

--
-- Table structure for table `nt_institute_hrm_employee_salary_template_data`
--

CREATE TABLE `nt_institute_hrm_employee_salary_template_data` (
  `template_data_id` bigint(20) UNSIGNED NOT NULL,
  `template_data_inst_id` bigint(20) UNSIGNED NOT NULL,
  `template_data_inst_type` enum('institute','institute_branch') NOT NULL,
  `template_data_template_id` bigint(20) UNSIGNED NOT NULL,
  `template_cal_type_id` bigint(20) UNSIGNED NOT NULL,
  `template_cal_type_value` double(15,2) UNSIGNED NOT NULL,
  `template_monthly_value` double(15,2) NOT NULL,
  `template_annual_value` double(15,2) NOT NULL,
  `template_data_applicable` enum('no','yes') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `nt_institute_hrm_employee_salary_template_data`
--
ALTER TABLE `nt_institute_hrm_employee_salary_template_data`
  ADD PRIMARY KEY (`template_data_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `nt_institute_hrm_employee_salary_template_data`
--
ALTER TABLE `nt_institute_hrm_employee_salary_template_data`
  MODIFY `template_data_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


ALTER TABLE `nt_institute_hrm_employee_salary_template_data` ADD `template_data_employee_id` BIGINT NULL DEFAULT NULL AFTER `template_data_inst_type`;
ALTER TABLE `nt_institute_hrm_employees` ADD `emp_ctc` DOUBLE NOT NULL DEFAULT '0' AFTER `emp_expense_limit_point`, ADD `emp_ctc_revised` ENUM('na','no','yes') NOT NULL AFTER `emp_ctc`;
ALTER TABLE `nt_institute_hrm_employee_salary_template_data` ADD `template_data_date` DATETIME NULL DEFAULT NULL AFTER `template_data_applicable`;


19-05-2025
----------

ALTER TABLE `nt_institute` ADD `is_enrollment_number_required` ENUM('no','yes') NOT NULL AFTER `lateral_sem_start`, ADD `is_roll_number_required` ENUM('no','yes') NOT NULL AFTER `is_enrollment_number_required`;
ALTER TABLE `nt_institute_students` ADD `stu_enrollment_no` TEXT NULL DEFAULT NULL AFTER `stu_user_code`, ADD `stu_roll_no` TEXT NULL DEFAULT NULL AFTER `stu_enrollment_no`;


19-05-2025
----------
ALTER TABLE `nt_institute` ADD `in_bill_student_image_required` ENUM('no','yes') NOT NULL AFTER `in_bill_print`;

20-05-2025
----------
ALTER TABLE `nt_institute` ADD `is_second_method_subject_required` ENUM('no','yes') NOT NULL AFTER `is_roll_number_required`, ADD `is_pan_no_required` ENUM('no','yes') NOT NULL AFTER `is_second_method_subject_required`;
ALTER TABLE `nt_institute_students_academics` ADD `acad_grad_hons_pass` VARCHAR(255) NULL DEFAULT NULL AFTER `acad_grad_division`;

New Merge
---------

27-05-25
--------
ALTER TABLE `nt_institute` ADD `is_board_application_date_required` ENUM('no','yes') NOT NULL DEFAULT 'no' AFTER `is_pan_no_required`, ADD `is_board_application_id_required` ENUM('no','yes') NOT NULL DEFAULT 'no' AFTER `is_board_application_date_required`;

ALTER TABLE `nt_institute_students_academics` ADD `acad_others_board_application_id` TEXT NULL DEFAULT NULL AFTER `acad_others_subjects`, ADD `acad_others_board_admission_date` DATE NULL DEFAULT NULL AFTER `acad_others_board_application_id`;


04-06-25
--------
ALTER TABLE `nt_institute_payments_details` ADD INDEX(`details_sess_id`);
ALTER TABLE `nt_institute_payments_details` ADD INDEX(`details_course_id`);
ALTER TABLE `nt_institute_payments_details` ADD INDEX(`details_created_at`);
ALTER TABLE `nt_institute_payments_details` ADD INDEX(`details_id`);


19-06-25
--------

ALTER TABLE `nt_institute` ADD `is_agent_agreement_required` ENUM('no','yes') NOT NULL AFTER `is_board_application_id_required`;

ALTER TABLE `nt_institute_students_academics` ADD `acad_others_board_application_id` BIGINT NULL DEFAULT NULL AFTER `acad_others_board`;

ALTER TABLE `nt_institute_students_academics` ADD `acad_others_board_admission_date` DATE NULL DEFAULT NULL AFTER `acad_others_board_application_id`;

20-06-25
--------
ALTER TABLE `nt_institute_settings` CHANGE `settings_type` `settings_type` ENUM('agent_agreement','payment_gateway','student_code','system_mail','email_settings','booking_fee_mandatory','money_reciept_note') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

ALTER TABLE `nt_storage` CHANGE `storage_type` `storage_type` ENUM('aadhar_card','madhyamik_admit_card','madhyamik_result_card','12th_result_card','grad_result_card','post_grad_result_card','other_certificate_card','pan_card','profile_photo','college_logo','college_letter_head_image','college_seal_logo','college_branch_logo','college_printing_logo','college_report_card_logo','college_report_card_logo','college_authorize_signature_logo','college_seal_logo','student_profile_photo','student_signature_photo','madhyamik_registration_card','madhyamik_rank_card','cheque_scan_backcopy_file','cheque_scan_frontcopy_file','asset_image','employee_docs','employee_profile_image','vendor_bill','expense_account_vendor_bill','agent_agreement_letterhead','agent_agreement_auth_signature') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

ALTER TABLE `nt_institute_agents` ADD `agent_agreed_to_agreement` ENUM('no','yes') NOT NULL AFTER `agent_approval_status`;

ALTER TABLE `nt_institute_agents` ADD `agent_agreement_file` LONGTEXT NULL DEFAULT NULL AFTER `agent_agreed_to_agreement`;


25-06-25
--------
ALTER TABLE `nt_institute` ADD `is_admission_fee_required_in_seatbooking` ENUM('no','yes') NOT NULL AFTER `is_agent_agreement_required`;


function
---------
https://amscp.firstkliq.com/admission_payment_fees_installment_form
https://amscp.firstkliq.com/admission_payment_installment_form
https://amscp.firstkliq.com/admission_payment_installment_add
https://amscp.firstkliq.com/admission_payment_installments
https://amscp.firstkliq.com/lms_books_issue_search

https://amscp.firstkliq.com/upload_students_excel_data

https://amscp.firstkliq.com/lms_books_issue_load