2024-08-22 15:38:41,550 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal Template Goal` MODIFY `per_weightage` decimal(21,9) not null default 0 2024-08-22 15:38:41,848 WARNING database DDL Query made to DB: ALTER TABLE `tabTravel Request Costing` MODIFY `sponsored_amount` decimal(21,9) not null default 0, MODIFY `funded_amount` decimal(21,9) not null default 0, MODIFY `total_amount` decimal(21,9) not null default 0 2024-08-22 15:38:41,972 WARNING database DDL Query made to DB: ALTER TABLE `tabTravel Request Costing` ADD INDEX `creation`(`creation`) 2024-08-22 15:38:42,586 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Policy` ADD COLUMN `title` varchar(140) 2024-08-22 15:38:43,069 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Separation Template` ADD COLUMN `title` varchar(140) 2024-08-22 15:38:43,493 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Application` MODIFY `leave_balance` decimal(21,9) not null default 0, MODIFY `total_leave_days` decimal(21,9) not null default 0 2024-08-22 15:38:44,023 WARNING database DDL Query made to DB: create table `tabKRA` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140) unique, `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:38:44,611 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Block List` ADD COLUMN `leave_type` varchar(140) 2024-08-22 15:38:44,704 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Block List` ADD UNIQUE INDEX IF NOT EXISTS leave_block_list_name (`leave_block_list_name`) 2024-08-22 15:38:45,150 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Claim` MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `total_amount_reimbursed` decimal(21,9) not null default 0, MODIFY `total_claimed_amount` decimal(21,9) not null default 0, MODIFY `total_sanctioned_amount` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_advance_amount` decimal(21,9) not null default 0 2024-08-22 15:38:45,950 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal` ADD COLUMN `designation` varchar(140), ADD COLUMN `employee_image` text, ADD COLUMN `appraisal_cycle` varchar(140), ADD COLUMN `final_score` decimal(21,9) not null default 0, ADD COLUMN `appraisal_template` varchar(140), ADD COLUMN `rate_goals_manually` int(1) not null default 0, ADD COLUMN `goal_score_percentage` decimal(21,9) not null default 0, ADD COLUMN `avg_feedback_score` decimal(21,9) not null default 0, ADD COLUMN `self_score` decimal(21,9) not null default 0, ADD COLUMN `reflections` longtext 2024-08-22 15:38:46,013 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal` MODIFY `total_score` decimal(21,9) not null default 0 2024-08-22 15:38:46,665 WARNING database DDL Query made to DB: create table `tabJob Offer Term Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:38:47,498 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Promotion` ADD COLUMN `salary_currency` varchar(140), ADD COLUMN `current_ctc` decimal(21,9) not null default 0, ADD COLUMN `revised_ctc` decimal(21,9) not null default 0 2024-08-22 15:38:47,897 WARNING database DDL Query made to DB: create table `tabFull and Final Outstanding Statement` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `component` varchar(140), `reference_document_type` varchar(140), `reference_document` varchar(140), `account` varchar(140), `paid_via_salary_slip` int(1) not null default 0, `amount` decimal(21,9) not null default 0, `status` varchar(140) default 'Unsettled', `remark` text, index `reference_document`(`reference_document`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:38:48,585 WARNING database DDL Query made to DB: ALTER TABLE `tabTraining Event` ADD UNIQUE INDEX IF NOT EXISTS event_name (`event_name`) 2024-08-22 15:38:48,983 WARNING database DDL Query made to DB: ALTER TABLE `tabAttendance` MODIFY `working_hours` decimal(21,9) not null default 0 2024-08-22 15:38:49,508 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Onboarding` ADD COLUMN `holiday_list` varchar(140), ADD COLUMN `boarding_begins_on` date 2024-08-22 15:38:49,572 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Onboarding` MODIFY `boarding_status` varchar(140) default 'Pending' 2024-08-22 15:38:49,976 WARNING database DDL Query made to DB: create table `tabAppraisal KRA` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `kra` varchar(140), `per_weightage` decimal(21,9) not null default 0, `goal_completion` decimal(21,9) not null default 0, `goal_score` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:38:50,483 WARNING database DDL Query made to DB: create table `tabEmployee Feedback Rating` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `criteria` varchar(140), `per_weightage` decimal(21,9) not null default 0, `rating` decimal(3,2), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:38:50,861 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Taxes and Charges` ADD COLUMN `project` varchar(140) 2024-08-22 15:38:50,925 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Taxes and Charges` MODIFY `tax_amount` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `rate` decimal(21,9) not null default 0 2024-08-22 15:38:51,548 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Policy Detail` MODIFY `annual_allocation` decimal(21,9) not null default 0 2024-08-22 15:38:51,894 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Transfer` MODIFY `department` varchar(140) 2024-08-22 15:38:53,748 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal Template` ADD COLUMN `template_title` varchar(140) unique 2024-08-22 15:38:53,749 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal Template` ADD UNIQUE INDEX IF NOT EXISTS template_title (`template_title`) 2024-08-22 15:38:54,293 WARNING database DDL Query made to DB: ALTER TABLE `tabStaffing Plan Detail` MODIFY `estimated_cost_per_position` decimal(21,9) not null default 0, MODIFY `total_estimated_cost` decimal(21,9) not null default 0 2024-08-22 15:38:54,927 WARNING database DDL Query made to DB: ALTER TABLE `tabInterview Round` MODIFY `expected_average_rating` decimal(3,2) 2024-08-22 15:38:55,352 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Grade` ADD COLUMN `currency` varchar(140), ADD COLUMN `default_base_pay` decimal(21,9) not null default 0 2024-08-22 15:38:55,822 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Separation` ADD COLUMN `boarding_begins_on` date 2024-08-22 15:38:55,887 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Separation` MODIFY `boarding_status` varchar(140) default 'Pending' 2024-08-22 15:38:56,526 WARNING database DDL Query made to DB: ALTER TABLE `tabInterview Detail` MODIFY `average_rating` decimal(3,2) 2024-08-22 15:38:57,209 WARNING database DDL Query made to DB: create table `tabExit Interview` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `email` varchar(140), `company` varchar(140), `status` varchar(140), `date` date, `department` varchar(140), `designation` varchar(140), `reports_to` varchar(140), `date_of_joining` date, `relieving_date` date, `ref_doctype` varchar(140), `questionnaire_email_sent` int(1) not null default 0, `reference_document_name` varchar(140), `interview_summary` longtext, `employee_status` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:38:58,043 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Boarding Activity` ADD COLUMN `begin_on` int(11) not null default 0, ADD COLUMN `duration` int(11) not null default 0 2024-08-22 15:38:58,108 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Boarding Activity` MODIFY `task_weight` decimal(21,9) not null default 0 2024-08-22 15:38:58,660 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Claim Advance` MODIFY `advance_paid` decimal(21,9) not null default 0, MODIFY `unclaimed_amount` decimal(21,9) not null default 0, MODIFY `allocated_amount` decimal(21,9) not null default 0 2024-08-22 15:38:59,126 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Advance` MODIFY `exchange_rate` decimal(21,9) not null default 0, MODIFY `advance_amount` decimal(21,9) not null default 0, MODIFY `return_amount` decimal(21,9) not null default 0, MODIFY `pending_amount` decimal(21,9) not null default 0, MODIFY `claimed_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0 2024-08-22 15:39:00,049 WARNING database DDL Query made to DB: ALTER TABLE `tabVehicle Log` MODIFY `price` decimal(21,9) not null default 0, MODIFY `fuel_qty` decimal(21,9) not null default 0 2024-08-22 15:39:00,455 WARNING database DDL Query made to DB: ALTER TABLE `tabShift Type` ADD COLUMN `mark_auto_attendance_on_holidays` int(1) not null default 0 2024-08-22 15:39:00,531 WARNING database DDL Query made to DB: ALTER TABLE `tabShift Type` MODIFY `working_hours_threshold_for_absent` decimal(21,9) not null default 0, MODIFY `working_hours_threshold_for_half_day` decimal(21,9) not null default 0 2024-08-22 15:39:01,226 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Encashment` MODIFY `encashable_days` decimal(21,9) not null default 0, MODIFY `encashment_amount` decimal(21,9) not null default 0, MODIFY `leave_balance` decimal(21,9) not null default 0 2024-08-22 15:39:02,204 WARNING database DDL Query made to DB: ALTER TABLE `tabAttendance Request` ADD COLUMN `include_holidays` int(1) not null default 0 2024-08-22 15:39:02,687 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Claim Detail` ADD COLUMN `project` varchar(140) 2024-08-22 15:39:02,752 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Claim Detail` MODIFY `sanctioned_amount` decimal(21,9) not null default 0, MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:39:03,471 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Skill` MODIFY `proficiency` decimal(3,2) 2024-08-22 15:39:03,748 WARNING database DDL Query made to DB: ALTER TABLE `tabSkill Assessment` MODIFY `rating` decimal(3,2) 2024-08-22 15:39:04,098 WARNING database DDL Query made to DB: create table `tabGoal` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `goal_name` varchar(140), `is_group` int(1) not null default 0, `parent_goal` varchar(140), `progress` decimal(21,9) not null default 0, `status` varchar(140) default 'Pending', `employee` varchar(140), `employee_name` varchar(140), `company` varchar(140), `user` varchar(140), `start_date` date, `end_date` date, `appraisal_cycle` varchar(140), `kra` varchar(140), `description` longtext, `lft` int(11) not null default 0, `rgt` int(11) not null default 0, `old_parent` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:39:04,978 WARNING database DDL Query made to DB: create table `tabAppraisal Cycle` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `cycle_name` varchar(140) unique, `company` varchar(140), `status` varchar(140) default 'Not Started', `start_date` date, `end_date` date, `description` longtext, `kra_evaluation_method` varchar(140) default 'Automated Based on Goal Progress', `branch` varchar(140), `department` varchar(140), `designation` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:39:05,508 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Type` ADD COLUMN `allocate_on_day` varchar(140) default 'Last Day' 2024-08-22 15:39:05,691 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Type` MODIFY `max_leaves_allowed` decimal(21,9) not null default 0, MODIFY `maximum_carry_forwarded_leaves` decimal(21,9) not null default 0, MODIFY `fraction_of_daily_salary_per_leave` decimal(21,9) not null default 0, MODIFY `rounding` varchar(140) 2024-08-22 15:39:06,373 WARNING database DDL Query made to DB: ALTER TABLE `tabTraining Result Employee` MODIFY `hours` decimal(21,9) not null default 0 2024-08-22 15:39:06,727 WARNING database DDL Query made to DB: ALTER TABLE `tabDaily Work Summary Group` MODIFY `message` longtext default '

Please share what did you do today. If you reply by midnight, your response will be recorded!

' 2024-08-22 15:39:06,996 WARNING database DDL Query made to DB: create table `tabFull and Final Statement` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `transaction_date` date, `company` varchar(140), `status` varchar(140) default 'Unpaid', `amended_from` varchar(140), `date_of_joining` date, `relieving_date` date, `designation` varchar(140), `department` varchar(140), `total_payable_amount` decimal(21,9) not null default 0, `total_receivable_amount` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:39:09,714 WARNING database DDL Query made to DB: ALTER TABLE `tabIncome Tax Slab` MODIFY `standard_tax_exemption_amount` decimal(21,9) not null default 0 2024-08-22 15:39:10,093 WARNING database DDL Query made to DB: ALTER TABLE `tabRetention Bonus` MODIFY `bonus_amount` decimal(21,9) not null default 0 2024-08-22 15:39:10,685 WARNING database DDL Query made to DB: ALTER TABLE `tabPayroll Entry` ADD COLUMN `status` varchar(140), ADD COLUMN `error_message` text 2024-08-22 15:39:10,749 WARNING database DDL Query made to DB: ALTER TABLE `tabPayroll Entry` MODIFY `exchange_rate` decimal(21,9) not null default 0 2024-08-22 15:39:11,198 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Structure` MODIFY `net_pay` decimal(21,9) not null default 0, MODIFY `total_deduction` decimal(21,9) not null default 0, MODIFY `leave_encashment_amount_per_day` decimal(21,9) not null default 0, MODIFY `hour_rate` decimal(21,9) not null default 0, MODIFY `max_benefits` decimal(21,9) not null default 0, MODIFY `total_earning` decimal(21,9) not null default 0 2024-08-22 15:39:11,287 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Structure` ADD INDEX `salary_slip_based_on_timesheet_index`(`salary_slip_based_on_timesheet`) 2024-08-22 15:39:11,938 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Proof Submission` MODIFY `total_actual_amount` decimal(21,9) not null default 0, MODIFY `exemption_amount` decimal(21,9) not null default 0 2024-08-22 15:39:12,688 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip` ADD COLUMN `ctc` decimal(21,9) not null default 0, ADD COLUMN `income_from_other_sources` decimal(21,9) not null default 0, ADD COLUMN `total_earnings` decimal(21,9) not null default 0, ADD COLUMN `non_taxable_earnings` decimal(21,9) not null default 0, ADD COLUMN `standard_tax_exemption_amount` decimal(21,9) not null default 0, ADD COLUMN `tax_exemption_declaration` decimal(21,9) not null default 0, ADD COLUMN `deductions_before_tax_calculation` decimal(21,9) not null default 0, ADD COLUMN `annual_taxable_amount` decimal(21,9) not null default 0, ADD COLUMN `income_tax_deducted_till_date` decimal(21,9) not null default 0, ADD COLUMN `current_month_income_tax` decimal(21,9) not null default 0, ADD COLUMN `future_income_tax_deductions` decimal(21,9) not null default 0, ADD COLUMN `total_income_tax` decimal(21,9) not null default 0 2024-08-22 15:39:12,753 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip` MODIFY `base_net_pay` decimal(21,9) not null default 0, MODIFY `base_total_deduction` decimal(21,9) not null default 0, MODIFY `gross_pay` decimal(21,9) not null default 0, MODIFY `base_month_to_date` decimal(21,9) not null default 0, MODIFY `base_gross_pay` decimal(21,9) not null default 0, MODIFY `hour_rate` decimal(21,9) not null default 0, MODIFY `base_gross_year_to_date` decimal(21,9) not null default 0, MODIFY `year_to_date` decimal(21,9) not null default 0, MODIFY `base_year_to_date` decimal(21,9) not null default 0, MODIFY `total_working_days` decimal(21,9) not null default 0, MODIFY `payment_days` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `leave_without_pay` decimal(21,9) not null default 0, MODIFY `total_deduction` decimal(21,9) not null default 0, MODIFY `absent_days` decimal(21,9) not null default 0, MODIFY `gross_year_to_date` decimal(21,9) not null default 0, MODIFY `month_to_date` decimal(21,9) not null default 0, MODIFY `base_hour_rate` decimal(21,9) not null default 0, MODIFY `net_pay` decimal(21,9) not null default 0, MODIFY `total_working_hours` decimal(21,9) not null default 0, MODIFY `unmarked_days` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0 2024-08-22 15:39:13,225 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Benefit Claim` MODIFY `claimed_amount` decimal(21,9) not null default 0, MODIFY `max_amount_eligible` decimal(21,9) not null default 0 2024-08-22 15:39:13,593 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Benefit Application Detail` MODIFY `amount` decimal(21,9) not null default 0, MODIFY `max_benefit_amount` decimal(21,9) not null default 0 2024-08-22 15:39:13,853 WARNING database DDL Query made to DB: create table `tabEmployee Cost Center` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `cost_center` varchar(140), `percentage` int(11) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:39:14,615 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Detail` MODIFY `default_amount` decimal(21,9) not null default 0, MODIFY `tax_on_additional_salary` decimal(21,9) not null default 0, MODIFY `year_to_date` decimal(21,9) not null default 0, MODIFY `amount` decimal(21,9) not null default 0, MODIFY `tax_on_flexible_benefit` decimal(21,9) not null default 0, MODIFY `additional_amount` decimal(21,9) not null default 0 2024-08-22 15:39:14,925 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip Timesheet` MODIFY `working_hours` decimal(21,9) not null default 0 2024-08-22 15:39:15,249 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip Loan` MODIFY `interest_amount` decimal(21,9) not null default 0, MODIFY `total_payment` decimal(21,9) not null default 0, MODIFY `principal_amount` decimal(21,9) not null default 0 2024-08-22 15:39:15,770 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Declaration Category` MODIFY `max_amount` decimal(21,9) not null default 0, MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:39:16,106 WARNING database DDL Query made to DB: ALTER TABLE `tabPayroll Period` ADD INDEX `creation`(`creation`) 2024-08-22 15:39:16,471 WARNING database DDL Query made to DB: ALTER TABLE `tabGratuity Rule Slab` MODIFY `fraction_of_applicable_earnings` decimal(21,9) not null default 0 2024-08-22 15:39:16,970 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Category` MODIFY `max_amount` decimal(21,9) not null default 0 2024-08-22 15:39:17,417 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Structure Assignment` ADD COLUMN `grade` varchar(140) 2024-08-22 15:39:17,485 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Structure Assignment` MODIFY `tax_deducted_till_date` decimal(21,9) not null default 0, MODIFY `variable` decimal(21,9) not null default 0, MODIFY `base` decimal(21,9) not null default 0, MODIFY `taxable_earnings_till_date` decimal(21,9) not null default 0 2024-08-22 15:39:17,860 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Proof Submission Detail` MODIFY `max_amount` decimal(21,9) not null default 0, MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:39:18,225 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Benefit Application` MODIFY `total_amount` decimal(21,9) not null default 0, MODIFY `pro_rata_dispensed_amount` decimal(21,9) not null default 0, MODIFY `max_benefits` decimal(21,9) not null default 0, MODIFY `remaining_benefit` decimal(21,9) not null default 0 2024-08-22 15:39:18,649 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Other Income` MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:39:19,142 WARNING database DDL Query made to DB: ALTER TABLE `tabAdditional Salary` ADD COLUMN `disabled` int(1) not null default 0 2024-08-22 15:39:19,207 WARNING database DDL Query made to DB: ALTER TABLE `tabAdditional Salary` MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:39:19,538 WARNING database DDL Query made to DB: ALTER TABLE `tabTaxable Salary Slab` MODIFY `to_amount` decimal(21,9) not null default 0 2024-08-22 15:39:19,825 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Sub Category` MODIFY `max_amount` decimal(21,9) not null default 0 2024-08-22 15:39:20,393 WARNING database DDL Query made to DB: ALTER TABLE `tabIncome Tax Slab Other Charges` MODIFY `max_taxable_income` decimal(21,9) not null default 0, MODIFY `percent` decimal(21,9) not null default 0, MODIFY `min_taxable_income` decimal(21,9) not null default 0 2024-08-22 15:39:20,647 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip Leave` MODIFY `available_leaves` decimal(21,9) not null default 0, MODIFY `used_leaves` decimal(21,9) not null default 0, MODIFY `expired_leaves` decimal(21,9) not null default 0, MODIFY `pending_leaves` decimal(21,9) not null default 0, MODIFY `total_allocated_leaves` decimal(21,9) not null default 0 2024-08-22 15:39:21,558 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Component` ADD COLUMN `remove_if_zero_valued` int(1) not null default 1 2024-08-22 15:39:21,642 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Component` MODIFY `max_benefit_amount` decimal(21,9) not null default 0, MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:39:21,742 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Component` ADD INDEX `variable_based_on_taxable_salary_index`(`variable_based_on_taxable_salary`) 2024-08-22 15:39:22,036 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Incentive` MODIFY `incentive_amount` decimal(21,9) not null default 0 2024-08-22 15:39:22,351 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Declaration` MODIFY `total_declared_amount` decimal(21,9) not null default 0, MODIFY `total_exemption_amount` decimal(21,9) not null default 0 2024-08-22 15:39:26,999 WARNING database DDL Query made to DB: ALTER TABLE `tabLoan Repayment` ADD COLUMN `process_payroll_accounting_entry_based_on_employee` int(1) not null default 0 2024-08-22 15:39:27,063 WARNING database DDL Query made to DB: ALTER TABLE `tabLoan Repayment` MODIFY `pending_principal_amount` decimal(21,9) not null default 0, MODIFY `amount_paid` decimal(21,9) not null default 0, MODIFY `penalty_amount` decimal(21,9) not null default 0, MODIFY `interest_payable` decimal(21,9) not null default 0, MODIFY `payable_principal_amount` decimal(21,9) not null default 0, MODIFY `payable_amount` decimal(21,9) not null default 0, MODIFY `total_interest_paid` decimal(21,9) not null default 0, MODIFY `shortfall_amount` decimal(21,9) not null default 0, MODIFY `total_penalty_paid` decimal(21,9) not null default 0, MODIFY `rate_of_interest` decimal(21,9) not null default 0 2024-08-22 15:39:27,292 WARNING database DDL Query made to DB: ALTER TABLE `tabTimesheet` MODIFY `base_total_billed_amount` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `per_billed` decimal(21,9) not null default 0, MODIFY `total_billable_hours` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0, MODIFY `base_total_billable_amount` decimal(21,9) not null default 0, MODIFY `base_total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_billed_hours` decimal(21,9) not null default 0 2024-08-22 15:39:27,515 WARNING database DDL Query made to DB: ALTER TABLE `tabCompany` MODIFY `total_monthly_sales` decimal(21,9) not null default 0, MODIFY `credit_limit` decimal(21,9) not null default 0, MODIFY `monthly_sales_target` decimal(21,9) not null default 0 2024-08-22 15:39:27,781 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2024-08-22 15:39:28,104 WARNING database DDL Query made to DB: ALTER TABLE `tabProject` MODIFY `gross_margin` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0, MODIFY `per_gross_margin` decimal(21,9) not null default 0, MODIFY `total_billable_amount` decimal(21,9) not null default 0, MODIFY `percent_complete` decimal(21,9) not null default 0, MODIFY `total_expense_claim` decimal(21,9) not null default 0, MODIFY `total_consumed_material_cost` decimal(21,9) not null default 0, MODIFY `total_purchase_cost` decimal(21,9) not null default 0, MODIFY `estimated_costing` decimal(21,9) not null default 0, MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_sales_amount` decimal(21,9) not null default 0 2024-08-22 15:39:28,314 WARNING database DDL Query made to DB: ALTER TABLE `tabTask` MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `task_weight` decimal(21,9) not null default 0, MODIFY `progress` decimal(21,9) not null default 0, MODIFY `total_billing_amount` decimal(21,9) not null default 0, MODIFY `total_expense_claim` decimal(21,9) not null default 0 2024-08-22 15:39:28,586 WARNING database DDL Query made to DB: ALTER TABLE `tabDesignation` ADD COLUMN `appraisal_template` varchar(140) 2024-08-22 15:39:28,815 WARNING database DDL Query made to DB: ALTER TABLE `tabLoan` MODIFY `maximum_loan_amount` decimal(21,9) not null default 0, MODIFY `monthly_repayment_amount` decimal(21,9) not null default 0, MODIFY `debit_adjustment_amount` decimal(21,9) not null default 0, MODIFY `disbursed_amount` decimal(21,9) not null default 0, MODIFY `loan_amount` decimal(21,9) not null default 0, MODIFY `rate_of_interest` decimal(21,9) not null default 0, MODIFY `refund_amount` decimal(21,9) not null default 0, MODIFY `total_amount_paid` decimal(21,9) not null default 0, MODIFY `written_off_amount` decimal(21,9) not null default 0, MODIFY `credit_adjustment_amount` decimal(21,9) not null default 0, MODIFY `total_principal_paid` decimal(21,9) not null default 0 2024-08-22 15:39:47,987 WARNING database DDL Query made to DB: alter table `tabLeave Type` drop column `based_on_date_of_joining` 2024-08-22 15:40:21,465 WARNING database DDL Query made to DB: create table `tabAppraisee` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `appraisal_template` varchar(140), `department` varchar(140), `designation` varchar(140), `branch` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:22,241 WARNING database DDL Query made to DB: ALTER TABLE `tabInterview` MODIFY `expected_average_rating` decimal(3,2), MODIFY `average_rating` decimal(3,2) 2024-08-22 15:40:22,568 WARNING database DDL Query made to DB: ALTER TABLE `tabVehicle Service` MODIFY `expense_amount` decimal(21,9) not null default 0 2024-08-22 15:40:23,230 WARNING database DDL Query made to DB: create table `tabVehicle Service Item` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `service_item` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:23,707 WARNING database DDL Query made to DB: create table `tabEmployee Feedback Criteria` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `criteria` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:24,363 WARNING database DDL Query made to DB: create table `tabJob Requisition` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `designation` varchar(140), `department` varchar(140), `no_of_positions` int(11) not null default 0, `expected_compensation` decimal(21,9) not null default 0, `company` varchar(140), `status` varchar(140), `requested_by` varchar(140), `requested_by_name` varchar(140), `requested_by_dept` varchar(140), `requested_by_designation` varchar(140), `posting_date` date, `completed_on` date, `expected_by` date, `time_to_fill` decimal(21,9), `description` longtext, `reason_for_requesting` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:24,714 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal Goal` MODIFY `score` decimal(21,9) not null default 0, MODIFY `score_earned` decimal(21,9) not null default 0, MODIFY `per_weightage` decimal(21,9) not null default 0 2024-08-22 15:40:25,212 WARNING database DDL Query made to DB: ALTER TABLE `tabInterview Feedback` MODIFY `average_rating` decimal(3,2) 2024-08-22 15:40:25,663 WARNING database DDL Query made to DB: ALTER TABLE `tabAppointment Letter Template` ADD COLUMN `template_name` varchar(140) unique 2024-08-22 15:40:25,664 WARNING database DDL Query made to DB: ALTER TABLE `tabAppointment Letter Template` ADD UNIQUE INDEX IF NOT EXISTS template_name (`template_name`) 2024-08-22 15:40:26,149 WARNING database DDL Query made to DB: ALTER TABLE `tabTravel Request` ADD COLUMN `company` varchar(140) 2024-08-22 15:40:26,514 WARNING database DDL Query made to DB: ALTER TABLE `tabJob Applicant` MODIFY `applicant_rating` decimal(3,2), MODIFY `lower_range` decimal(21,9) not null default 0, MODIFY `upper_range` decimal(21,9) not null default 0 2024-08-22 15:40:27,316 WARNING database DDL Query made to DB: create table `tabEmployee Performance Feedback` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `designation` varchar(140), `company` varchar(140), `reviewer` varchar(140), `reviewer_name` varchar(140), `reviewer_designation` varchar(140), `user` varchar(140), `added_on` datetime(6), `appraisal_cycle` varchar(140), `appraisal` varchar(140), `total_score` decimal(21,9) not null default 0, `feedback` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:28,017 WARNING database DDL Query made to DB: ALTER TABLE `tabJob Opening` ADD COLUMN `job_requisition` varchar(140), ADD COLUMN `vacancies` int(11) not null default 0 2024-08-22 15:40:28,091 WARNING database DDL Query made to DB: ALTER TABLE `tabJob Opening` MODIFY `lower_range` decimal(21,9) not null default 0, MODIFY `upper_range` decimal(21,9) not null default 0 2024-08-22 15:40:28,561 WARNING database DDL Query made to DB: ALTER TABLE `tabJob Offer` ADD COLUMN `job_offer_term_template` varchar(140) 2024-08-22 15:40:28,862 WARNING database DDL Query made to DB: create table `tabFull and Final Asset` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `reference` varchar(140), `asset_name` varchar(140), `date` datetime(6), `status` varchar(140), `description` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:29,380 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Ledger Entry` MODIFY `leaves` decimal(21,9) not null default 0 2024-08-22 15:40:29,986 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Onboarding Template` ADD COLUMN `title` varchar(140) 2024-08-22 15:40:30,357 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Allocation` MODIFY `total_leaves_encashed` decimal(21,9) not null default 0, MODIFY `new_leaves_allocated` decimal(21,9) not null default 0, MODIFY `unused_leaves` decimal(21,9) not null default 0, MODIFY `carry_forwarded_leaves_count` decimal(21,9) not null default 0, MODIFY `total_leaves_allocated` decimal(21,9) not null default 0 2024-08-22 15:40:30,740 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal Template Goal` ADD COLUMN `key_result_area` varchar(140) 2024-08-22 15:40:30,805 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal Template Goal` MODIFY `per_weightage` decimal(21,9) not null default 0 2024-08-22 15:40:31,091 WARNING database DDL Query made to DB: ALTER TABLE `tabTravel Request Costing` MODIFY `funded_amount` decimal(21,9) not null default 0, MODIFY `sponsored_amount` decimal(21,9) not null default 0, MODIFY `total_amount` decimal(21,9) not null default 0 2024-08-22 15:40:31,198 WARNING database DDL Query made to DB: ALTER TABLE `tabTravel Request Costing` ADD INDEX `creation`(`creation`) 2024-08-22 15:40:31,818 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Policy` ADD COLUMN `title` varchar(140) 2024-08-22 15:40:32,207 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Separation Template` ADD COLUMN `title` varchar(140) 2024-08-22 15:40:32,580 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Application` MODIFY `total_leave_days` decimal(21,9) not null default 0, MODIFY `leave_balance` decimal(21,9) not null default 0 2024-08-22 15:40:33,107 WARNING database DDL Query made to DB: create table `tabKRA` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140) unique, `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:33,920 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Block List` ADD COLUMN `leave_type` varchar(140) 2024-08-22 15:40:34,229 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Block List` ADD UNIQUE INDEX IF NOT EXISTS leave_block_list_name (`leave_block_list_name`) 2024-08-22 15:40:34,696 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Claim` MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_sanctioned_amount` decimal(21,9) not null default 0, MODIFY `total_amount_reimbursed` decimal(21,9) not null default 0, MODIFY `total_advance_amount` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `total_claimed_amount` decimal(21,9) not null default 0 2024-08-22 15:40:35,393 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal` ADD COLUMN `designation` varchar(140), ADD COLUMN `employee_image` text, ADD COLUMN `appraisal_cycle` varchar(140), ADD COLUMN `final_score` decimal(21,9) not null default 0, ADD COLUMN `appraisal_template` varchar(140), ADD COLUMN `rate_goals_manually` int(1) not null default 0, ADD COLUMN `goal_score_percentage` decimal(21,9) not null default 0, ADD COLUMN `avg_feedback_score` decimal(21,9) not null default 0, ADD COLUMN `self_score` decimal(21,9) not null default 0, ADD COLUMN `reflections` longtext 2024-08-22 15:40:35,461 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal` MODIFY `total_score` decimal(21,9) not null default 0 2024-08-22 15:40:35,998 WARNING database DDL Query made to DB: create table `tabJob Offer Term Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:36,694 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Promotion` ADD COLUMN `salary_currency` varchar(140), ADD COLUMN `current_ctc` decimal(21,9) not null default 0, ADD COLUMN `revised_ctc` decimal(21,9) not null default 0 2024-08-22 15:40:37,019 WARNING database DDL Query made to DB: create table `tabFull and Final Outstanding Statement` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `component` varchar(140), `reference_document_type` varchar(140), `reference_document` varchar(140), `account` varchar(140), `paid_via_salary_slip` int(1) not null default 0, `amount` decimal(21,9) not null default 0, `status` varchar(140) default 'Unsettled', `remark` text, index `reference_document`(`reference_document`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:37,710 WARNING database DDL Query made to DB: ALTER TABLE `tabTraining Event` ADD UNIQUE INDEX IF NOT EXISTS event_name (`event_name`) 2024-08-22 15:40:38,001 WARNING database DDL Query made to DB: ALTER TABLE `tabAttendance` MODIFY `working_hours` decimal(21,9) not null default 0 2024-08-22 15:40:38,384 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Onboarding` ADD COLUMN `holiday_list` varchar(140), ADD COLUMN `boarding_begins_on` date 2024-08-22 15:40:38,450 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Onboarding` MODIFY `boarding_status` varchar(140) default 'Pending' 2024-08-22 15:40:38,719 WARNING database DDL Query made to DB: create table `tabAppraisal KRA` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `kra` varchar(140), `per_weightage` decimal(21,9) not null default 0, `goal_completion` decimal(21,9) not null default 0, `goal_score` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:39,162 WARNING database DDL Query made to DB: create table `tabEmployee Feedback Rating` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `criteria` varchar(140), `per_weightage` decimal(21,9) not null default 0, `rating` decimal(3,2), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:39,537 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Taxes and Charges` ADD COLUMN `project` varchar(140) 2024-08-22 15:40:39,593 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Taxes and Charges` MODIFY `rate` decimal(21,9) not null default 0, MODIFY `tax_amount` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0 2024-08-22 15:40:40,224 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Policy Detail` MODIFY `annual_allocation` decimal(21,9) not null default 0 2024-08-22 15:40:40,523 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Transfer` MODIFY `department` varchar(140) 2024-08-22 15:40:42,251 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal Template` ADD COLUMN `template_title` varchar(140) unique 2024-08-22 15:40:42,252 WARNING database DDL Query made to DB: ALTER TABLE `tabAppraisal Template` ADD UNIQUE INDEX IF NOT EXISTS template_title (`template_title`) 2024-08-22 15:40:42,691 WARNING database DDL Query made to DB: ALTER TABLE `tabStaffing Plan Detail` MODIFY `total_estimated_cost` decimal(21,9) not null default 0, MODIFY `estimated_cost_per_position` decimal(21,9) not null default 0 2024-08-22 15:40:43,156 WARNING database DDL Query made to DB: ALTER TABLE `tabInterview Round` MODIFY `expected_average_rating` decimal(3,2) 2024-08-22 15:40:43,562 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Grade` ADD COLUMN `currency` varchar(140), ADD COLUMN `default_base_pay` decimal(21,9) not null default 0 2024-08-22 15:40:43,959 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Separation` ADD COLUMN `boarding_begins_on` date 2024-08-22 15:40:44,027 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Separation` MODIFY `boarding_status` varchar(140) default 'Pending' 2024-08-22 15:40:44,944 WARNING database DDL Query made to DB: ALTER TABLE `tabInterview Detail` MODIFY `average_rating` decimal(3,2) 2024-08-22 15:40:45,949 WARNING database DDL Query made to DB: create table `tabExit Interview` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `email` varchar(140), `company` varchar(140), `status` varchar(140), `date` date, `department` varchar(140), `designation` varchar(140), `reports_to` varchar(140), `date_of_joining` date, `relieving_date` date, `ref_doctype` varchar(140), `questionnaire_email_sent` int(1) not null default 0, `reference_document_name` varchar(140), `interview_summary` longtext, `employee_status` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:47,030 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Boarding Activity` ADD COLUMN `begin_on` int(11) not null default 0, ADD COLUMN `duration` int(11) not null default 0 2024-08-22 15:40:47,085 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Boarding Activity` MODIFY `task_weight` decimal(21,9) not null default 0 2024-08-22 15:40:47,826 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Claim Advance` MODIFY `allocated_amount` decimal(21,9) not null default 0, MODIFY `advance_paid` decimal(21,9) not null default 0, MODIFY `unclaimed_amount` decimal(21,9) not null default 0 2024-08-22 15:40:48,413 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Advance` MODIFY `claimed_amount` decimal(21,9) not null default 0, MODIFY `pending_amount` decimal(21,9) not null default 0, MODIFY `return_amount` decimal(21,9) not null default 0, MODIFY `exchange_rate` decimal(21,9) not null default 0, MODIFY `advance_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0 2024-08-22 15:40:49,656 WARNING database DDL Query made to DB: ALTER TABLE `tabVehicle Log` MODIFY `fuel_qty` decimal(21,9) not null default 0, MODIFY `price` decimal(21,9) not null default 0 2024-08-22 15:40:50,156 WARNING database DDL Query made to DB: ALTER TABLE `tabShift Type` ADD COLUMN `mark_auto_attendance_on_holidays` int(1) not null default 0 2024-08-22 15:40:50,223 WARNING database DDL Query made to DB: ALTER TABLE `tabShift Type` MODIFY `working_hours_threshold_for_half_day` decimal(21,9) not null default 0, MODIFY `working_hours_threshold_for_absent` decimal(21,9) not null default 0 2024-08-22 15:40:50,691 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Encashment` MODIFY `encashment_amount` decimal(21,9) not null default 0, MODIFY `leave_balance` decimal(21,9) not null default 0, MODIFY `encashable_days` decimal(21,9) not null default 0 2024-08-22 15:40:51,449 WARNING database DDL Query made to DB: ALTER TABLE `tabAttendance Request` ADD COLUMN `include_holidays` int(1) not null default 0 2024-08-22 15:40:51,878 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Claim Detail` ADD COLUMN `project` varchar(140) 2024-08-22 15:40:51,945 WARNING database DDL Query made to DB: ALTER TABLE `tabExpense Claim Detail` MODIFY `amount` decimal(21,9) not null default 0, MODIFY `sanctioned_amount` decimal(21,9) not null default 0 2024-08-22 15:40:52,513 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Skill` MODIFY `proficiency` decimal(3,2) 2024-08-22 15:40:52,756 WARNING database DDL Query made to DB: ALTER TABLE `tabSkill Assessment` MODIFY `rating` decimal(3,2) 2024-08-22 15:40:53,020 WARNING database DDL Query made to DB: create table `tabGoal` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `goal_name` varchar(140), `is_group` int(1) not null default 0, `parent_goal` varchar(140), `progress` decimal(21,9) not null default 0, `status` varchar(140) default 'Pending', `employee` varchar(140), `employee_name` varchar(140), `company` varchar(140), `user` varchar(140), `start_date` date, `end_date` date, `appraisal_cycle` varchar(140), `kra` varchar(140), `description` longtext, `lft` int(11) not null default 0, `rgt` int(11) not null default 0, `old_parent` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:53,674 WARNING database DDL Query made to DB: create table `tabAppraisal Cycle` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `cycle_name` varchar(140) unique, `company` varchar(140), `status` varchar(140) default 'Not Started', `start_date` date, `end_date` date, `description` longtext, `kra_evaluation_method` varchar(140) default 'Automated Based on Goal Progress', `branch` varchar(140), `department` varchar(140), `designation` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:54,138 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Type` ADD COLUMN `allocate_on_day` varchar(140) default 'Last Day' 2024-08-22 15:40:54,284 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Type` MODIFY `max_leaves_allowed` decimal(21,9) not null default 0, MODIFY `fraction_of_daily_salary_per_leave` decimal(21,9) not null default 0, MODIFY `maximum_carry_forwarded_leaves` decimal(21,9) not null default 0, MODIFY `rounding` varchar(140) 2024-08-22 15:40:54,889 WARNING database DDL Query made to DB: ALTER TABLE `tabTraining Result Employee` MODIFY `hours` decimal(21,9) not null default 0 2024-08-22 15:40:55,180 WARNING database DDL Query made to DB: ALTER TABLE `tabDaily Work Summary Group` MODIFY `message` longtext default '

Please share what did you do today. If you reply by midnight, your response will be recorded!

' 2024-08-22 15:40:55,527 WARNING database DDL Query made to DB: create table `tabFull and Final Statement` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `transaction_date` date, `company` varchar(140), `status` varchar(140) default 'Unpaid', `amended_from` varchar(140), `date_of_joining` date, `relieving_date` date, `designation` varchar(140), `department` varchar(140), `total_payable_amount` decimal(21,9) not null default 0, `total_receivable_amount` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:40:58,056 WARNING database DDL Query made to DB: ALTER TABLE `tabIncome Tax Slab` MODIFY `standard_tax_exemption_amount` decimal(21,9) not null default 0 2024-08-22 15:40:58,435 WARNING database DDL Query made to DB: ALTER TABLE `tabRetention Bonus` MODIFY `bonus_amount` decimal(21,9) not null default 0 2024-08-22 15:40:58,963 WARNING database DDL Query made to DB: ALTER TABLE `tabPayroll Entry` ADD COLUMN `status` varchar(140), ADD COLUMN `error_message` text 2024-08-22 15:40:59,028 WARNING database DDL Query made to DB: ALTER TABLE `tabPayroll Entry` MODIFY `exchange_rate` decimal(21,9) not null default 0 2024-08-22 15:40:59,412 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Structure` MODIFY `leave_encashment_amount_per_day` decimal(21,9) not null default 0, MODIFY `total_deduction` decimal(21,9) not null default 0, MODIFY `hour_rate` decimal(21,9) not null default 0, MODIFY `total_earning` decimal(21,9) not null default 0, MODIFY `max_benefits` decimal(21,9) not null default 0, MODIFY `net_pay` decimal(21,9) not null default 0 2024-08-22 15:40:59,524 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Structure` ADD INDEX `salary_slip_based_on_timesheet_index`(`salary_slip_based_on_timesheet`) 2024-08-22 15:41:00,145 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Proof Submission` MODIFY `total_actual_amount` decimal(21,9) not null default 0, MODIFY `exemption_amount` decimal(21,9) not null default 0 2024-08-22 15:41:00,817 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip` ADD COLUMN `ctc` decimal(21,9) not null default 0, ADD COLUMN `income_from_other_sources` decimal(21,9) not null default 0, ADD COLUMN `total_earnings` decimal(21,9) not null default 0, ADD COLUMN `non_taxable_earnings` decimal(21,9) not null default 0, ADD COLUMN `standard_tax_exemption_amount` decimal(21,9) not null default 0, ADD COLUMN `tax_exemption_declaration` decimal(21,9) not null default 0, ADD COLUMN `deductions_before_tax_calculation` decimal(21,9) not null default 0, ADD COLUMN `annual_taxable_amount` decimal(21,9) not null default 0, ADD COLUMN `income_tax_deducted_till_date` decimal(21,9) not null default 0, ADD COLUMN `current_month_income_tax` decimal(21,9) not null default 0, ADD COLUMN `future_income_tax_deductions` decimal(21,9) not null default 0, ADD COLUMN `total_income_tax` decimal(21,9) not null default 0 2024-08-22 15:41:00,882 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip` MODIFY `total_working_days` decimal(21,9) not null default 0, MODIFY `month_to_date` decimal(21,9) not null default 0, MODIFY `net_pay` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `gross_pay` decimal(21,9) not null default 0, MODIFY `base_month_to_date` decimal(21,9) not null default 0, MODIFY `base_year_to_date` decimal(21,9) not null default 0, MODIFY `payment_days` decimal(21,9) not null default 0, MODIFY `total_working_hours` decimal(21,9) not null default 0, MODIFY `leave_without_pay` decimal(21,9) not null default 0, MODIFY `base_hour_rate` decimal(21,9) not null default 0, MODIFY `base_total_deduction` decimal(21,9) not null default 0, MODIFY `base_gross_year_to_date` decimal(21,9) not null default 0, MODIFY `base_gross_pay` decimal(21,9) not null default 0, MODIFY `absent_days` decimal(21,9) not null default 0, MODIFY `year_to_date` decimal(21,9) not null default 0, MODIFY `gross_year_to_date` decimal(21,9) not null default 0, MODIFY `hour_rate` decimal(21,9) not null default 0, MODIFY `unmarked_days` decimal(21,9) not null default 0, MODIFY `base_net_pay` decimal(21,9) not null default 0, MODIFY `total_deduction` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0 2024-08-22 15:41:01,290 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Benefit Claim` MODIFY `claimed_amount` decimal(21,9) not null default 0, MODIFY `max_amount_eligible` decimal(21,9) not null default 0 2024-08-22 15:41:01,668 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Benefit Application Detail` MODIFY `max_benefit_amount` decimal(21,9) not null default 0, MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:41:01,939 WARNING database DDL Query made to DB: create table `tabEmployee Cost Center` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `cost_center` varchar(140), `percentage` int(11) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:41:02,657 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Detail` MODIFY `tax_on_additional_salary` decimal(21,9) not null default 0, MODIFY `default_amount` decimal(21,9) not null default 0, MODIFY `additional_amount` decimal(21,9) not null default 0, MODIFY `amount` decimal(21,9) not null default 0, MODIFY `tax_on_flexible_benefit` decimal(21,9) not null default 0, MODIFY `year_to_date` decimal(21,9) not null default 0 2024-08-22 15:41:02,945 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip Timesheet` MODIFY `working_hours` decimal(21,9) not null default 0 2024-08-22 15:41:03,246 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip Loan` MODIFY `principal_amount` decimal(21,9) not null default 0, MODIFY `total_payment` decimal(21,9) not null default 0, MODIFY `interest_amount` decimal(21,9) not null default 0 2024-08-22 15:41:03,756 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Declaration Category` MODIFY `max_amount` decimal(21,9) not null default 0, MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:41:04,114 WARNING database DDL Query made to DB: ALTER TABLE `tabPayroll Period` ADD INDEX `creation`(`creation`) 2024-08-22 15:41:04,479 WARNING database DDL Query made to DB: ALTER TABLE `tabGratuity Rule Slab` MODIFY `fraction_of_applicable_earnings` decimal(21,9) not null default 0 2024-08-22 15:41:04,923 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Category` MODIFY `max_amount` decimal(21,9) not null default 0 2024-08-22 15:41:05,403 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Structure Assignment` ADD COLUMN `grade` varchar(140) 2024-08-22 15:41:05,471 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Structure Assignment` MODIFY `variable` decimal(21,9) not null default 0, MODIFY `tax_deducted_till_date` decimal(21,9) not null default 0, MODIFY `taxable_earnings_till_date` decimal(21,9) not null default 0, MODIFY `base` decimal(21,9) not null default 0 2024-08-22 15:41:05,813 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Proof Submission Detail` MODIFY `amount` decimal(21,9) not null default 0, MODIFY `max_amount` decimal(21,9) not null default 0 2024-08-22 15:41:06,145 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Benefit Application` MODIFY `remaining_benefit` decimal(21,9) not null default 0, MODIFY `pro_rata_dispensed_amount` decimal(21,9) not null default 0, MODIFY `max_benefits` decimal(21,9) not null default 0, MODIFY `total_amount` decimal(21,9) not null default 0 2024-08-22 15:41:06,571 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Other Income` MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:41:07,101 WARNING database DDL Query made to DB: ALTER TABLE `tabAdditional Salary` ADD COLUMN `disabled` int(1) not null default 0 2024-08-22 15:41:07,165 WARNING database DDL Query made to DB: ALTER TABLE `tabAdditional Salary` MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:41:07,456 WARNING database DDL Query made to DB: ALTER TABLE `tabTaxable Salary Slab` MODIFY `to_amount` decimal(21,9) not null default 0 2024-08-22 15:41:07,701 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Sub Category` MODIFY `max_amount` decimal(21,9) not null default 0 2024-08-22 15:41:08,270 WARNING database DDL Query made to DB: ALTER TABLE `tabIncome Tax Slab Other Charges` MODIFY `max_taxable_income` decimal(21,9) not null default 0, MODIFY `percent` decimal(21,9) not null default 0, MODIFY `min_taxable_income` decimal(21,9) not null default 0 2024-08-22 15:41:08,501 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip Leave` MODIFY `expired_leaves` decimal(21,9) not null default 0, MODIFY `pending_leaves` decimal(21,9) not null default 0, MODIFY `used_leaves` decimal(21,9) not null default 0, MODIFY `total_allocated_leaves` decimal(21,9) not null default 0, MODIFY `available_leaves` decimal(21,9) not null default 0 2024-08-22 15:41:09,193 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Component` ADD COLUMN `remove_if_zero_valued` int(1) not null default 1 2024-08-22 15:41:09,268 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Component` MODIFY `max_benefit_amount` decimal(21,9) not null default 0, MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:41:09,371 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Component` ADD INDEX `variable_based_on_taxable_salary_index`(`variable_based_on_taxable_salary`) 2024-08-22 15:41:09,668 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Incentive` MODIFY `incentive_amount` decimal(21,9) not null default 0 2024-08-22 15:41:10,067 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee Tax Exemption Declaration` MODIFY `total_declared_amount` decimal(21,9) not null default 0, MODIFY `total_exemption_amount` decimal(21,9) not null default 0 2024-08-22 15:41:13,846 WARNING database DDL Query made to DB: ALTER TABLE `tabLoan` MODIFY `loan_amount` decimal(21,9) not null default 0, MODIFY `credit_adjustment_amount` decimal(21,9) not null default 0, MODIFY `written_off_amount` decimal(21,9) not null default 0, MODIFY `refund_amount` decimal(21,9) not null default 0, MODIFY `total_principal_paid` decimal(21,9) not null default 0, MODIFY `maximum_loan_amount` decimal(21,9) not null default 0, MODIFY `monthly_repayment_amount` decimal(21,9) not null default 0, MODIFY `debit_adjustment_amount` decimal(21,9) not null default 0, MODIFY `disbursed_amount` decimal(21,9) not null default 0, MODIFY `total_amount_paid` decimal(21,9) not null default 0, MODIFY `rate_of_interest` decimal(21,9) not null default 0 2024-08-22 15:41:14,033 WARNING database DDL Query made to DB: ALTER TABLE `tabProject` MODIFY `per_gross_margin` decimal(21,9) not null default 0, MODIFY `total_expense_claim` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_purchase_cost` decimal(21,9) not null default 0, MODIFY `total_sales_amount` decimal(21,9) not null default 0, MODIFY `total_consumed_material_cost` decimal(21,9) not null default 0, MODIFY `percent_complete` decimal(21,9) not null default 0, MODIFY `estimated_costing` decimal(21,9) not null default 0, MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0, MODIFY `gross_margin` decimal(21,9) not null default 0, MODIFY `total_billable_amount` decimal(21,9) not null default 0 2024-08-22 15:41:14,257 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2024-08-22 15:41:14,537 WARNING database DDL Query made to DB: ALTER TABLE `tabDesignation` ADD COLUMN `appraisal_template` varchar(140) 2024-08-22 15:41:14,762 WARNING database DDL Query made to DB: ALTER TABLE `tabLoan Repayment` ADD COLUMN `process_payroll_accounting_entry_based_on_employee` int(1) not null default 0 2024-08-22 15:41:14,828 WARNING database DDL Query made to DB: ALTER TABLE `tabLoan Repayment` MODIFY `pending_principal_amount` decimal(21,9) not null default 0, MODIFY `total_penalty_paid` decimal(21,9) not null default 0, MODIFY `payable_amount` decimal(21,9) not null default 0, MODIFY `rate_of_interest` decimal(21,9) not null default 0, MODIFY `amount_paid` decimal(21,9) not null default 0, MODIFY `payable_principal_amount` decimal(21,9) not null default 0, MODIFY `total_interest_paid` decimal(21,9) not null default 0, MODIFY `interest_payable` decimal(21,9) not null default 0, MODIFY `shortfall_amount` decimal(21,9) not null default 0, MODIFY `penalty_amount` decimal(21,9) not null default 0 2024-08-22 15:41:15,044 WARNING database DDL Query made to DB: ALTER TABLE `tabCompany` MODIFY `credit_limit` decimal(21,9) not null default 0, MODIFY `monthly_sales_target` decimal(21,9) not null default 0, MODIFY `total_monthly_sales` decimal(21,9) not null default 0 2024-08-22 15:41:15,223 WARNING database DDL Query made to DB: ALTER TABLE `tabTimesheet` MODIFY `base_total_billable_amount` decimal(21,9) not null default 0, MODIFY `total_billed_hours` decimal(21,9) not null default 0, MODIFY `per_billed` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `base_total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0, MODIFY `base_total_billed_amount` decimal(21,9) not null default 0, MODIFY `total_billable_hours` decimal(21,9) not null default 0 2024-08-22 15:41:15,411 WARNING database DDL Query made to DB: ALTER TABLE `tabTask` MODIFY `progress` decimal(21,9) not null default 0, MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_expense_claim` decimal(21,9) not null default 0, MODIFY `total_billing_amount` decimal(21,9) not null default 0, MODIFY `task_weight` decimal(21,9) not null default 0 2024-08-22 15:41:35,373 WARNING database DDL Query made to DB: alter table `tabLeave Type` drop column `based_on_date_of_joining` 2024-08-22 15:42:37,266 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Gateway` ADD UNIQUE INDEX IF NOT EXISTS gateway (`gateway`) 2024-08-22 15:42:41,158 WARNING database DDL Query made to DB: ALTER TABLE `tabWeb Form` MODIFY `condition_json` json, MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 15:43:04,645 WARNING database DDL Query made to DB: create table `tabDATEV Voucher Config` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `voucher_type` varchar(140), `recipient` varchar(140), `attach_print` int(1) not null default 0, `print_format` varchar(140), `attach_files` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:43:27,113 WARNING database DDL Query made to DB: create table `tabDATEV Voucher Config` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `voucher_type` varchar(140), `recipient` varchar(140), `attach_print` int(1) not null default 0, `print_format` varchar(140), `attach_files` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 15:43:46,921 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Gateway` ADD UNIQUE INDEX IF NOT EXISTS gateway (`gateway`) 2024-08-22 15:43:50,619 WARNING database DDL Query made to DB: ALTER TABLE `tabWeb Form` MODIFY `condition_json` json, MODIFY `amount` decimal(21,9) not null default 0 2024-08-22 16:03:20,774 WARNING database DDL Query made to DB: create table `tabReligious Denomination` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 16:03:21,185 WARNING database DDL Query made to DB: create table `tabVAT ID Check` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `party_type` varchar(140), `party` varchar(140), `party_vat_id` varchar(140), `party_address` varchar(140), `status` varchar(140) default 'Planned', `trader_name` varchar(140), `trader_street` varchar(140), `trader_postcode` varchar(140), `trader_city` varchar(140), `trader_name_match` int(1) not null default 0, `trader_street_match` int(1) not null default 0, `trader_postcode_match` int(1) not null default 0, `trader_city_match` int(1) not null default 0, `actual_trader_name` varchar(140), `actual_trader_address` text, `company` varchar(140), `requester_vat_id` varchar(140), `is_valid` int(1) not null default 0, `request_id` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 16:03:21,953 WARNING database DDL Query made to DB: create table `tabBusiness Letter` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `amended_from` varchar(140), `address` varchar(140), `address_display` text, `contact` varchar(140), `email_id` varchar(140), `date` date, `company` varchar(140), `template` varchar(140), `subject` varchar(140), `content` longtext, `link_document_type` varchar(140), `link_name` varchar(140), `link_title` varchar(140), `subject_preview` varchar(140), `content_preview` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `amended_from`(`amended_from`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 16:03:22,234 WARNING database DDL Query made to DB: create table `tabBusiness Letter Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `subject` varchar(140), `content` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2024-08-22 16:03:30,773 WARNING database DDL Query made to DB: ALTER TABLE `tabQuotation` ADD COLUMN `tax_exemption_reason` text 2024-08-22 16:03:30,841 WARNING database DDL Query made to DB: ALTER TABLE `tabQuotation` MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0 2024-08-22 16:03:31,141 WARNING database DDL Query made to DB: ALTER TABLE `tabCompany` ADD COLUMN `register_type` varchar(140), ADD COLUMN `register_number` varchar(140), ADD COLUMN `register_court` varchar(140) 2024-08-22 16:03:31,209 WARNING database DDL Query made to DB: ALTER TABLE `tabCompany` MODIFY `total_monthly_sales` decimal(21,9) not null default 0, MODIFY `monthly_sales_target` decimal(21,9) not null default 0, MODIFY `credit_limit` decimal(21,9) not null default 0 2024-08-22 16:03:33,178 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Invoice` ADD COLUMN `tax_exemption_reason` text 2024-08-22 16:03:33,262 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Invoice` MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `commission_rate` decimal(21,9) not null default 0, MODIFY `amount_eligible_for_commission` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `total_commission` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `change_amount` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_change_amount` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `total_billing_hours` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `loyalty_amount` decimal(21,9) not null default 0 2024-08-22 16:03:33,476 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Taxes and Charges Template` ADD COLUMN `tax_exemption_reason` text 2024-08-22 16:03:33,752 WARNING database DDL Query made to DB: ALTER TABLE `tabCustomer` ADD COLUMN `register_type` varchar(140), ADD COLUMN `register_number` varchar(140), ADD COLUMN `register_court` varchar(140) 2024-08-22 16:03:33,816 WARNING database DDL Query made to DB: ALTER TABLE `tabCustomer` MODIFY `default_commission_rate` decimal(21,9) not null default 0 2024-08-22 16:03:34,055 WARNING database DDL Query made to DB: ALTER TABLE `tabSupplier` ADD COLUMN `register_type` varchar(140), ADD COLUMN `register_number` varchar(140), ADD COLUMN `register_court` varchar(140) 2024-08-22 16:03:34,392 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Order` ADD COLUMN `tax_exemption_reason` text 2024-08-22 16:03:34,464 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Order` MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `commission_rate` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `per_billed` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `per_picked` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `loyalty_amount` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `per_delivered` decimal(21,9) not null default 0, MODIFY `amount_eligible_for_commission` decimal(21,9) not null default 0, MODIFY `total_commission` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `advance_paid` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0 2024-08-22 16:03:34,796 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` ADD COLUMN `nationality` varchar(140), ADD COLUMN `is_severely_disabled` int(1) not null default 0, ADD COLUMN `working_hours_per_week` decimal(21,9) not null default 0, ADD COLUMN `tax_id` varchar(140), ADD COLUMN `tax_office` varchar(140), ADD COLUMN `tax_office_number` varchar(140), ADD COLUMN `tax_bracket` varchar(140), ADD COLUMN `children_eligible_for_tax_credits` int(11) not null default 0, ADD COLUMN `religious_denomination` varchar(140), ADD COLUMN `has_children` int(1) not null default 0, ADD COLUMN `highest_school_qualification` varchar(140), ADD COLUMN `has_other_employments` int(1) not null default 0 2024-08-22 16:03:34,864 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0