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;

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