#date : 22-08-2025
#Bank Account Details 


INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'user', 'import', 'Import');
INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'basic_salary', 'bank_details', 'Bank Account Details');
INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'bank', 'bank_name', 'Name Of The Bank');
INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'bank', 'account_number', 'Bank Account Number');
INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'bank', 'branch_name', 'Branch Name');
INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'bank', 'city', 'City');
INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'bank', 'ifsc_code', 'IFSC Code');
INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'bank', 'account_holder_name', 'Account Holder Name');
INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'bank', 'pan_number', 'PAN Number');
INSERT INTO `translations` (`lang_id`, `group`, `key`, `value`) VALUES ( 1, 'user', 'adhar_card_number', 'Adhar Card Number');

ALTER TABLE `users` ADD `account_holder_name` VARCHAR(250) NULL DEFAULT NULL AFTER `salary_group_id`, ADD `bank_name` VARCHAR(250) NULL DEFAULT NULL AFTER `account_holder_name`, ADD `account_number` VARCHAR(250) NULL DEFAULT NULL AFTER `bank_name`, ADD `branch_name` VARCHAR(250) NULL DEFAULT NULL AFTER `account_number`, ADD `city` VARCHAR(250) NULL DEFAULT NULL AFTER `branch_name`, ADD `ifsc_code` VARCHAR(250) NULL DEFAULT NULL AFTER `city`;
ALTER TABLE `users` ADD `pan_number` VARCHAR(250) NULL DEFAULT NULL AFTER `ifsc_code`;
ALTER TABLE `users` ADD `adhar_card_number` VARCHAR(255) NULL DEFAULT NULL AFTER `pan_number`;

#end