2025-06-23 23:36:53,109 WARNING database DDL Query made to DB: create table `tabSalary Component` ( 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', `salary_component` varchar(140) unique, `salary_component_abbr` varchar(140), `type` varchar(140), `description` text, `depends_on_payment_days` int(1) not null default 1, `is_tax_applicable` int(1) not null default 1, `deduct_full_tax_on_selected_payroll_date` int(1) not null default 0, `variable_based_on_taxable_salary` int(1) not null default 0, `is_income_tax_component` int(1) not null default 0, `exempted_from_income_tax` int(1) not null default 0, `round_to_the_nearest_integer` int(1) not null default 0, `statistical_component` int(1) not null default 0, `do_not_include_in_total` int(1) not null default 0, `remove_if_zero_valued` int(1) not null default 1, `disabled` int(1) not null default 0, `condition` longtext, `amount` decimal(21,9) not null default 0, `amount_based_on_formula` int(1) not null default 0, `formula` longtext, `is_flexible_benefit` int(1) not null default 0, `max_benefit_amount` decimal(21,9) not null default 0, `pay_against_benefit_claim` int(1) not null default 0, `only_tax_impact` int(1) not null default 0, `create_separate_payment_entry_against_benefit_claim` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `variable_based_on_taxable_salary`(`variable_based_on_taxable_salary`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:53,205 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Proof Submission Detail` ( 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', `exemption_sub_category` varchar(140), `exemption_category` varchar(140), `max_amount` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `type_of_proof` varchar(140), `attach_proof` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:53,311 WARNING database DDL Query made to DB: create table `tabSalary Structure Assignment` ( 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), `grade` varchar(140), `salary_structure` varchar(140), `from_date` date, `income_tax_slab` varchar(140), `company` varchar(140), `payroll_payable_account` varchar(140), `currency` varchar(140), `base` decimal(21,9) not null default 0, `variable` decimal(21,9) not null default 0, `amended_from` varchar(140), `taxable_earnings_till_date` decimal(21,9) not null default 0, `tax_deducted_till_date` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `salary_structure`(`salary_structure`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:53,412 WARNING database DDL Query made to DB: create table `tabPayroll Period` ( 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', `company` varchar(140), `start_date` date, `end_date` date, `_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 2025-06-23 23:36:53,515 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Sub Category` ( 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', `exemption_category` varchar(140), `max_amount` decimal(21,9) not null default 0, `is_active` int(1) not null default 1, `_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 2025-06-23 23:36:53,613 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)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:53,728 WARNING database DDL Query made to DB: create table `tabSalary Withholding` ( 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), `company` varchar(140), `posting_date` date, `payroll_frequency` varchar(140), `number_of_withholding_cycles` int(11) not null default 0, `status` varchar(140) default 'Draft', `from_date` date, `to_date` date, `date_of_joining` date, `relieving_date` date, `reason_for_withholding_salary` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `amended_from`(`amended_from`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:53,823 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Category` ( 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', `max_amount` decimal(21,9) not null default 0, `is_active` int(1) not null default 1, `_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 2025-06-23 23:36:53,941 WARNING database DDL Query made to DB: create table `tabGratuity` ( 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), `current_work_experience` decimal(21,9) not null default 0, `posting_date` date, `gratuity_rule` varchar(140), `status` varchar(140) default 'Draft', `company` varchar(140), `amended_from` varchar(140), `pay_via_salary_slip` int(1) not null default 1, `amount` decimal(21,9) not null default 0, `paid_amount` decimal(21,9) not null default 0, `payroll_date` date, `salary_component` varchar(140), `cost_center` varchar(140), `mode_of_payment` varchar(140), `expense_account` varchar(140), `payable_account` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:54,040 WARNING database DDL Query made to DB: create table `tabSalary Slip Loan` ( 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', `loan` varchar(140), `loan_product` varchar(140), `loan_account` varchar(140), `interest_income_account` varchar(140), `principal_amount` decimal(21,9) not null default 0, `interest_amount` decimal(21,9) not null default 0, `total_payment` decimal(21,9) not null default 0, `loan_repayment_entry` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:54,204 WARNING database DDL Query made to DB: create table `tabEmployee Benefit Application Detail` ( 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', `earning_component` varchar(140), `pay_against_benefit_claim` int(1) not null default 0, `max_benefit_amount` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:54,368 WARNING database DDL Query made to DB: create table `tabSalary Withholding 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', `from_date` date, `to_date` date, `is_salary_released` int(1) not null default 0, `journal_entry` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:54,446 WARNING database DDL Query made to DB: create table `tabSalary Slip Leave` ( 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', `leave_type` varchar(140), `total_allocated_leaves` decimal(21,9) not null default 0, `expired_leaves` decimal(21,9) not null default 0, `used_leaves` decimal(21,9) not null default 0, `pending_leaves` decimal(21,9) not null default 0, `available_leaves` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:54,526 WARNING database DDL Query made to DB: create table `tabTaxable Salary Slab` ( 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', `from_amount` decimal(21,9) not null default 0, `to_amount` decimal(21,9) not null default 0, `percent_deduction` decimal(21,9) not null default 0, `condition` longtext, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:54,603 WARNING database DDL Query made to DB: create table `tabPayroll Period Date` ( 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', `start_date` date, `end_date` date, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:54,683 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Declaration Category` ( 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', `exemption_sub_category` varchar(140), `exemption_category` varchar(140), `max_amount` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:54,775 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Declaration` ( 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), `company` varchar(140), `payroll_period` varchar(140), `currency` varchar(140), `amended_from` varchar(140), `total_declared_amount` decimal(21,9) not null default 0, `total_exemption_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 2025-06-23 23:36:54,881 WARNING database DDL Query made to DB: create table `tabSalary Component Account` ( 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', `company` varchar(140), `account` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:54,959 WARNING database DDL Query made to DB: create table `tabGratuity Rule Slab` ( 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', `from_year` int(11) not null default 0, `to_year` int(11) not null default 0, `fraction_of_applicable_earnings` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:55,042 WARNING database DDL Query made to DB: create table `tabSalary Slip Timesheet` ( 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', `time_sheet` varchar(140), `working_hours` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:55,149 WARNING database DDL Query made to DB: create table `tabAdditional Salary` ( 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), `department` varchar(140), `company` varchar(140), `is_recurring` int(1) not null default 0, `disabled` int(1) not null default 0, `from_date` date, `to_date` date, `payroll_date` date, `amended_from` varchar(140), `salary_component` varchar(140), `type` varchar(140), `currency` varchar(140), `amount` decimal(21,9) not null default 0, `deduct_full_tax_on_selected_payroll_date` int(1) not null default 0, `overwrite_salary_structure_amount` int(1) not null default 1, `ref_doctype` varchar(140), `ref_docname` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `payroll_date`(`payroll_date`), index `salary_component`(`salary_component`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:55,251 WARNING database DDL Query made to DB: create table `tabIncome Tax Slab` ( 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', `disabled` int(1) not null default 0, `effective_from` date, `company` varchar(140), `currency` varchar(140), `standard_tax_exemption_amount` decimal(21,9) not null default 0, `allow_tax_exemption` int(1) not null default 0, `amended_from` varchar(140), `tax_relief_limit` 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 2025-06-23 23:36:55,367 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Proof Submission` ( 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), `currency` varchar(140), `amended_from` varchar(140), `submission_date` date, `payroll_period` varchar(140), `company` varchar(140), `total_actual_amount` decimal(21,9) not null default 0, `exemption_amount` decimal(21,9) not null default 0, `attachments` 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 2025-06-23 23:36:55,487 WARNING database DDL Query made to DB: create table `tabEmployee Other Income` ( 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), `amended_from` varchar(140), `company` varchar(140), `payroll_period` varchar(140), `source` varchar(140), `amount` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `company`(`company`), index `payroll_period`(`payroll_period`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:55,623 WARNING database DDL Query made to DB: create table `tabPayroll Entry` ( 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', `posting_date` date, `company` varchar(140), `currency` varchar(140), `exchange_rate` decimal(21,9) not null default 0, `payroll_payable_account` varchar(140), `status` varchar(140), `salary_slip_based_on_timesheet` int(1) not null default 0, `payroll_frequency` varchar(140), `start_date` date, `end_date` date, `deduct_tax_for_unclaimed_employee_benefits` int(1) not null default 0, `deduct_tax_for_unsubmitted_tax_exemption_proof` int(1) not null default 0, `branch` varchar(140), `department` varchar(140), `designation` varchar(140), `grade` varchar(140), `number_of_employees` int(11) not null default 0, `validate_attendance` int(1) not null default 0, `cost_center` varchar(140), `project` varchar(140), `payment_account` varchar(140), `bank_account` varchar(140), `salary_slips_created` int(1) not null default 0, `salary_slips_submitted` int(1) not null default 0, `error_message` text, `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 2025-06-23 23:36:55,716 WARNING database DDL Query made to DB: create table `tabEmployee Incentive` ( 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), `amended_from` varchar(140), `company` varchar(140), `department` varchar(140), `salary_component` varchar(140), `currency` varchar(140), `payroll_date` date, `incentive_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 2025-06-23 23:36:56,926 WARNING database DDL Query made to DB: ALTER TABLE `tabDepartment` ADD COLUMN `payroll_cost_center` varchar(140), ADD COLUMN `leave_block_list` varchar(140) 2025-06-23 23:36:56,966 WARNING database DDL Query made to DB: ALTER TABLE `tabDesignation` ADD COLUMN `appraisal_template` varchar(140) 2025-06-23 23:36:57,008 WARNING database DDL Query made to DB: ALTER TABLE `tabTerms and Conditions` ADD COLUMN `hr` int(1) not null default 1 2025-06-23 23:36:57,073 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` ADD COLUMN `employment_type` varchar(140), ADD COLUMN `grade` varchar(140), ADD COLUMN `job_applicant` varchar(140), ADD COLUMN `default_shift` varchar(140), ADD COLUMN `expense_approver` varchar(140), ADD COLUMN `leave_approver` varchar(140), ADD COLUMN `shift_request_approver` varchar(140), ADD COLUMN `payroll_cost_center` varchar(140), ADD COLUMN `health_insurance_provider` varchar(140), ADD COLUMN `health_insurance_no` varchar(140) 2025-06-23 23:36:57,089 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-23 23:36:57,140 WARNING database DDL Query made to DB: ALTER TABLE `tabTask` ADD COLUMN `total_expense_claim` decimal(21,9) not null default 0 2025-06-23 23:36:57,156 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 `progress` 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 2025-06-23 23:36:57,202 WARNING database DDL Query made to DB: ALTER TABLE `tabTimesheet` ADD COLUMN `salary_slip` varchar(140) 2025-06-23 23:36:57,218 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_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, MODIFY `base_total_costing_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 2025-06-23 23:36:57,268 WARNING database DDL Query made to DB: ALTER TABLE `tabProject` ADD COLUMN `total_expense_claim` decimal(21,9) not null default 0 2025-06-23 23:36:57,284 WARNING database DDL Query made to DB: ALTER TABLE `tabProject` MODIFY `total_consumed_material_cost` decimal(21,9) not null default 0, MODIFY `total_costing_amount` 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 `total_sales_amount` decimal(21,9) not null default 0, MODIFY `total_billable_amount` decimal(21,9) not null default 0, MODIFY `total_purchase_cost` decimal(21,9) not null default 0, MODIFY `gross_margin` decimal(21,9) not null default 0, MODIFY `per_gross_margin` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0, MODIFY `actual_time` decimal(21,9) not null default 0 2025-06-23 23:36:57,345 WARNING database DDL Query made to DB: ALTER TABLE `tabCompany` ADD COLUMN `default_expense_claim_payable_account` varchar(140), ADD COLUMN `default_employee_advance_account` varchar(140), ADD COLUMN `default_payroll_payable_account` varchar(140) 2025-06-23 23:36:57,361 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 2025-06-23 23:37:16,595 WARNING database DDL Query made to DB: create table `tabCheck Run` ( 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', `end_date` date, `posting_date` date, `beg_balance` decimal(21,9) not null default 0, `company_discretionary_data` varchar(20), `initial_check_number` int(11) not null default 0, `final_check_number` int(11) not null default 0, `amount_check_run` decimal(21,9) not null default 0, `company` varchar(140), `bank_account` varchar(140), `pay_to_account` varchar(140) default 'company.default_payable_account', `amended_from` varchar(140), `transactions` longtext, `print_count` int(11) not null default 0, `status` varchar(140) default 'Draft', `ach_file_generated` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:37:16,836 WARNING database DDL Query made to DB: create table `tabCheck Run Settings` ( 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', `company` varchar(140), `bank_account` varchar(140), `approver_role` varchar(140), `pay_to_account` varchar(140), `print_format` varchar(140), `include_purchase_invoices` int(1) not null default 1, `include_journal_entries` int(1) not null default 1, `include_expense_claims` int(1) not null default 1, `pre_check_overdue_items` int(1) not null default 0, `allow_cancellation` int(1) not null default 0, `cascade_cancellation` int(1) not null default 0, `validate_unique_check_number` int(1) not null default 0, `set_payment_entry_posting_date` varchar(140) default 'Use Today\'s Date', `number_of_invoices_per_voucher` int(11) not null default 0, `split_by_address` int(1) not null default 0, `automatically_release_on_hold_invoices` int(1) not null default 0, `file_preview_threshold` int(11) not null default 1000, `allow_stand_alone_debit_notes` varchar(140) default 'No', `purchase_invoice` varchar(140), `journal_entry` varchar(140), `expense_claim` varchar(140), `allow_only_verified_accounts_in_nacha_generation` int(1) not null default 0, `ach_file_extension` varchar(140) default 'ach', `ach_service_class_code` varchar(140), `ach_standard_class_code` varchar(140), `ach_description` varchar(10), `immediate_origin` varchar(140), `company_discretionary_data` varchar(20), `custom_post_processing_hook` varchar(140), `role_allowed_to_download_ach_file_multiple_times` varchar(140), `attach_positive_pay` int(1) not null default 0, `positive_pay_file_format` varchar(140) default 'CSV', `csv_delimiter` varchar(1) default ',', `csv_quoting` varchar(140) default 'Non-numeric', `_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 2025-06-23 23:37:17,969 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` ADD COLUMN `check_run` varchar(140) 2025-06-23 23:37:17,985 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` MODIFY `target_exchange_rate` decimal(21,9) not null default 0, MODIFY `party_balance` decimal(21,9) not null default 0, MODIFY `paid_to_account_balance` decimal(21,9) not null default 0, MODIFY `unallocated_amount` decimal(21,9) not null default 0, MODIFY `paid_from_account_balance` decimal(21,9) not null default 0, MODIFY `difference_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `total_allocated_amount` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_received_amount` decimal(21,9) not null default 0, MODIFY `source_exchange_rate` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `base_received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `base_total_allocated_amount` decimal(21,9) not null default 0, MODIFY `received_amount` decimal(21,9) not null default 0 2025-06-23 23:37:18,073 WARNING database DDL Query made to DB: ALTER TABLE `tabBank` ADD COLUMN `aba_number` varchar(140) 2025-06-23 23:37:18,312 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` ADD COLUMN `supplier_default_mode_of_payment` varchar(140) 2025-06-23 23:37:18,328 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `base_rounded_total` 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 `grand_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `per_received` 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 `discount_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0 2025-06-23 23:37:18,525 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` ADD COLUMN `mode_of_payment` varchar(140), ADD COLUMN `bank` varchar(140), ADD COLUMN `bank_account` text 2025-06-23 23:37:18,541 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-23 23:37:18,668 WARNING database DDL Query made to DB: ALTER TABLE `tabSupplier` ADD COLUMN `supplier_default_mode_of_payment` varchar(140), ADD COLUMN `number_of_invoices_per_check_voucher` int(11) not null default 0, ADD COLUMN `bank_account` text, ADD COLUMN `bank` varchar(140) 2025-06-23 23:37:18,893 WARNING database DDL Query made to DB: ALTER TABLE `tabBank Account` ADD COLUMN `allow_quick_check` int(1) not null default 1, ADD COLUMN `check_number` varchar(140), ADD COLUMN `company_ach_id` varchar(140) 2025-06-23 23:37:19,131 WARNING database DDL Query made to DB: create table `tabSite Code` ( 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', `site_code` 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 2025-06-23 23:37:19,978 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` ADD COLUMN `site_code` varchar(140), ADD COLUMN `service_date` date 2025-06-23 23:37:19,994 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total_qty` 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 `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` 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 `net_total` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0 2025-06-23 23:37:20,223 WARNING database DDL Query made to DB: create table `tabWiki Page Revision 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', `wiki_page` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:37:20,340 WARNING database DDL Query made to DB: create table `tabWiki Space` ( 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', `space_name` varchar(140), `route` varchar(140) unique, `app_switcher_logo` text, `light_mode_logo` text, `dark_mode_logo` 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 2025-06-23 23:37:20,471 WARNING database DDL Query made to DB: create table `tabWiki 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', `wiki_page` varchar(140), `status` varchar(140) default 'Open', `rating` decimal(3,2), `feedback` text, `email_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 2025-06-23 23:37:20,576 WARNING database DDL Query made to DB: create table `tabWiki Page` ( 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), `route` varchar(140) unique, `published` int(1) not null default 0, `allow_guest` int(1) not null default 1, `content` longtext default 'No Content', `meta_description` text, `meta_image` text, `meta_keywords` 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 2025-06-23 23:37:20,663 WARNING database DDL Query made to DB: create table `tabWiki App Switcher List Table` ( 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', `app_title` varchar(140), `wiki_space` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:37:20,759 WARNING database DDL Query made to DB: create table `tabWiki Page Patch` ( 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', `wiki_page` varchar(140), `new_title` varchar(140), `new_sidebar_group` varchar(140), `message` text, `raised_by` varchar(140), `status` varchar(140) default 'Under Review', `approved_by` varchar(140), `new` int(1) not null default 0, `orignal_code` longtext, `new_code` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:37:20,851 WARNING database DDL Query made to DB: create table `tabWiki Sidebar` ( 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', `wiki_page` varchar(140) unique, `parent_label` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:37:21,001 WARNING database DDL Query made to DB: create table `tabWiki Group 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', `parent_label` varchar(140), `wiki_page` varchar(140), `hide_on_sidebar` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:37:21,178 WARNING database DDL Query made to DB: create table `tabWiki Page Revision` ( 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', `content` longtext, `raised_by` varchar(140), `raised_by_username` varchar(140), `message` 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 2025-06-23 23:37:56,253 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Invoice` ADD COLUMN `exempt_from_sales_tax` int(1) not null default 0 2025-06-23 23:37:56,275 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Invoice` MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `total_commission` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `base_change_amount` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `change_amount` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `total_billing_hours` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `amount_eligible_for_commission` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `commission_rate` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `loyalty_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0 2025-06-23 23:37:56,360 WARNING database DDL Query made to DB: ALTER TABLE `tabCustomer` ADD COLUMN `exempt_from_sales_tax` int(1) not null default 0 2025-06-23 23:37:56,379 WARNING database DDL Query made to DB: ALTER TABLE `tabCustomer` MODIFY `default_commission_rate` decimal(21,9) not null default 0 2025-06-23 23:37:56,464 WARNING database DDL Query made to DB: ALTER TABLE `tabQuotation` ADD COLUMN `exempt_from_sales_tax` int(1) not null default 0 2025-06-23 23:37:56,480 WARNING database DDL Query made to DB: ALTER TABLE `tabQuotation` MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `total` 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 2025-06-23 23:37:56,575 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Order` ADD COLUMN `exempt_from_sales_tax` int(1) not null default 0 2025-06-23 23:37:56,592 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Order` MODIFY `conversion_rate` decimal(21,9) not null default 0, 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 `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `per_picked` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `advance_paid` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` 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 `base_rounded_total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `amount_eligible_for_commission` decimal(21,9) not null default 0, MODIFY `commission_rate` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `total_commission` decimal(21,9) not null default 0, MODIFY `per_delivered` decimal(21,9) not null default 0, MODIFY `loyalty_amount` decimal(21,9) not null default 0, MODIFY `discount_amount` 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 `per_billed` decimal(21,9) not null default 0 2025-06-23 23:37:56,665 WARNING database DDL Query made to DB: ALTER TABLE `tabSupplier` ADD COLUMN `irs_1099` int(1) not null default 0 2025-06-23 23:51:40,810 WARNING database DDL Query made to DB: DROP USER IF EXISTS '_06925c1bee92171f'@'localhost' 2025-06-23 23:51:44,426 WARNING database DDL Query made to DB: DROP DATABASE IF EXISTS `_06925c1bee92171f` 2025-06-23 23:51:44,428 WARNING database DDL Query made to DB: CREATE USER '_06925c1bee92171f'@'localhost' IDENTIFIED BY 'zZxPjpFL3O8X4Crv' 2025-06-23 23:51:44,430 WARNING database DDL Query made to DB: CREATE DATABASE `_06925c1bee92171f` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 2025-06-23 23:51:44,676 WARNING database DDL Query made to DB: create table if not exists `__Auth` ( `doctype` VARCHAR(140) NOT NULL, `name` VARCHAR(255) NOT NULL, `fieldname` VARCHAR(140) NOT NULL, `password` TEXT NOT NULL, `encrypted` INT(1) NOT NULL DEFAULT 0, PRIMARY KEY (`doctype`, `name`, `fieldname`) ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:44,685 WARNING database DDL Query made to DB: create table __global_search( doctype varchar(100), name varchar(140), title varchar(140), content text, fulltext(content), route varchar(140), published int(1) not null default 0, unique `doctype_name` (doctype, name)) COLLATE=utf8mb4_unicode_ci ENGINE=MyISAM CHARACTER SET=utf8mb4 2025-06-23 23:51:44,695 WARNING database DDL Query made to DB: create table if not exists __UserSettings ( `user` VARCHAR(180) NOT NULL, `doctype` VARCHAR(180) NOT NULL, `data` TEXT, UNIQUE(user, doctype) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:44,850 WARNING database DDL Query made to DB: create table `tabDocType State` ( 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), `color` varchar(140) default 'Blue', `custom` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:44,966 WARNING database DDL Query made to DB: ALTER TABLE `tabDocField` ADD COLUMN `non_negative` int(1) not null default 0, ADD COLUMN `is_virtual` int(1) not null default 0, ADD COLUMN `sort_options` int(1) not null default 0, ADD COLUMN `link_filters` json, ADD COLUMN `fetch_from` text, ADD COLUMN `show_on_timeline` int(1) not null default 0, ADD COLUMN `make_attachment_public` int(1) not null default 0, ADD COLUMN `documentation_url` varchar(140), ADD COLUMN `placeholder` varchar(140) 2025-06-23 23:51:45,009 WARNING database DDL Query made to DB: ALTER TABLE `tabDocField` MODIFY `collapsible_depends_on` longtext, MODIFY `mandatory_depends_on` longtext, MODIFY `fieldtype` varchar(140) default 'Data', MODIFY `print_width` varchar(10), MODIFY `oldfieldname` varchar(140), MODIFY `fieldname` varchar(140), MODIFY `label` varchar(140), MODIFY `width` varchar(10), MODIFY `read_only_depends_on` longtext, MODIFY `depends_on` longtext, MODIFY `precision` varchar(140), MODIFY `oldfieldtype` varchar(140) 2025-06-23 23:51:45,144 WARNING database DDL Query made to DB: ALTER TABLE `tabDocPerm` ADD COLUMN `if_owner` int(1) not null default 0, ADD COLUMN `select` int(1) not null default 0 2025-06-23 23:51:45,172 WARNING database DDL Query made to DB: ALTER TABLE `tabDocPerm` MODIFY `role` varchar(140) 2025-06-23 23:51:45,238 WARNING database DDL Query made to DB: ALTER TABLE `tabDocType Action` ADD COLUMN `hidden` int(1) not null default 0, ADD COLUMN `custom` int(1) not null default 0 2025-06-23 23:51:45,286 WARNING database DDL Query made to DB: ALTER TABLE `tabDocType Link` ADD COLUMN `parent_doctype` varchar(140), ADD COLUMN `table_fieldname` varchar(140), ADD COLUMN `hidden` int(1) not null default 0, ADD COLUMN `is_child_table` int(1) not null default 0, ADD COLUMN `custom` int(1) not null default 0 2025-06-23 23:51:45,370 WARNING database DDL Query made to DB: create table `tabForm Tour Step` ( 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', `ui_tour` int(1) not null default 0, `is_table_field` int(1) not null default 0, `title` varchar(140), `parent_fieldname` varchar(140), `fieldname` varchar(140), `element_selector` varchar(140), `parent_element_selector` varchar(140), `description` longtext, `ondemand_description` longtext, `position` varchar(140) default 'Bottom', `hide_buttons` int(1) not null default 0, `popover_element` int(1) not null default 0, `modal_trigger` int(1) not null default 0, `offset_x` int(11) not null default 0, `offset_y` int(11) not null default 0, `next_on_click` int(1) not null default 0, `label` varchar(140), `fieldtype` varchar(140) default '0', `has_next_condition` int(1) not null default 0, `next_step_condition` longtext, `next_form_tour` varchar(140), `child_doctype` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:45,449 WARNING database DDL Query made to DB: create table `tabForm Tour` ( 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, `view_name` varchar(140), `workspace_name` varchar(140), `list_name` varchar(140) default 'List', `report_name` varchar(140), `dashboard_name` varchar(140), `new_document_form` int(1) not null default 0, `page_name` varchar(140), `reference_doctype` varchar(140), `module` varchar(140), `ui_tour` int(1) not null default 0, `track_steps` int(1) not null default 0, `is_standard` int(1) not null default 0, `save_on_complete` int(1) not null default 0, `first_document` int(1) not null default 0, `include_name_field` int(1) not null default 0, `page_route` 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 2025-06-23 23:51:45,594 WARNING database DDL Query made to DB: ALTER TABLE `tabDocType` ADD COLUMN `is_calendar_and_gantt` int(1) not null default 0, ADD COLUMN `quick_entry` int(1) not null default 0, ADD COLUMN `grid_page_length` int(11) not null default 50, ADD COLUMN `track_views` int(1) not null default 0, ADD COLUMN `queue_in_background` int(1) not null default 0, ADD COLUMN `documentation` varchar(140), ADD COLUMN `nsm_parent_field` varchar(140), ADD COLUMN `allow_events_in_timeline` int(1) not null default 0, ADD COLUMN `allow_auto_repeat` int(1) not null default 0, ADD COLUMN `make_attachments_public` int(1) not null default 0, ADD COLUMN `default_view` varchar(140), ADD COLUMN `force_re_route_to_default_view` int(1) not null default 0, ADD COLUMN `show_preview_popup` int(1) not null default 0, ADD COLUMN `default_email_template` varchar(140), ADD COLUMN `sender_name_field` varchar(140), ADD COLUMN `protect_attached_files` int(1) not null default 0, ADD COLUMN `index_web_pages_for_search` int(1) not null default 1, ADD COLUMN `row_format` varchar(140) default 'Dynamic', ADD COLUMN `_comments` text, ADD COLUMN `_assign` text, ADD COLUMN `_liked_by` text 2025-06-23 23:51:45,620 WARNING database DDL Query made to DB: ALTER TABLE `tabDocType` MODIFY `title_field` varchar(140), MODIFY `search_fields` varchar(140), MODIFY `default_print_format` varchar(140), MODIFY `sort_field` varchar(140) default 'modified', MODIFY `sort_order` varchar(140) default 'DESC', MODIFY `document_type` varchar(140), MODIFY `icon` varchar(140), MODIFY `color` varchar(140), MODIFY `module` varchar(140), MODIFY `sender_field` varchar(140), MODIFY `subject_field` varchar(140), MODIFY `restrict_to_domain` varchar(140), MODIFY `route` varchar(140), MODIFY `is_published_field` varchar(140), MODIFY `website_search_field` varchar(140), MODIFY `autoname` varchar(140), MODIFY `engine` varchar(140) default 'InnoDB', MODIFY `allow_rename` int(1) not null default 1, MODIFY `migration_hash` varchar(140), MODIFY `_user_tags` text, MODIFY `image_field` varchar(140), MODIFY `timeline_field` varchar(140) 2025-06-23 23:51:45,641 WARNING database DDL Query made to DB: ALTER TABLE `tabDocType` ADD INDEX `module_index`(`module`) 2025-06-23 23:51:45,782 WARNING database DDL Query made to DB: create table `tabRole` ( 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', `role_name` varchar(140) unique, `home_page` varchar(140), `restrict_to_domain` varchar(140), `disabled` int(1) not null default 0, `is_custom` int(1) not null default 0, `desk_access` int(1) not null default 1, `two_factor_auth` int(1) 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 2025-06-23 23:51:45,873 WARNING database DDL Query made to DB: create table `tabHas Role` ( 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', `role` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:45,978 WARNING database DDL Query made to DB: create table `tabCustom Field` ( 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', `is_system_generated` int(1) not null default 0, `dt` varchar(140), `module` varchar(140), `label` varchar(140), `placeholder` varchar(140), `fieldname` varchar(140), `insert_after` varchar(140), `length` int(11) not null default 0, `link_filters` json, `fieldtype` varchar(140) default 'Data', `precision` varchar(140), `hide_seconds` int(1) not null default 0, `hide_days` int(1) not null default 0, `options` text, `sort_options` int(1) not null default 0, `fetch_from` text, `fetch_if_empty` int(1) not null default 0, `collapsible` int(1) not null default 0, `collapsible_depends_on` longtext, `default` text, `depends_on` longtext, `mandatory_depends_on` longtext, `read_only_depends_on` longtext, `non_negative` int(1) not null default 0, `reqd` int(1) not null default 0, `unique` int(1) not null default 0, `is_virtual` int(1) not null default 0, `read_only` int(1) not null default 0, `ignore_user_permissions` int(1) not null default 0, `hidden` int(1) not null default 0, `print_hide` int(1) not null default 0, `print_hide_if_no_value` int(1) not null default 0, `print_width` varchar(140), `no_copy` int(1) not null default 0, `allow_on_submit` int(1) not null default 0, `in_list_view` int(1) not null default 0, `in_standard_filter` int(1) not null default 0, `in_global_search` int(1) not null default 0, `in_preview` int(1) not null default 0, `bold` int(1) not null default 0, `report_hide` int(1) not null default 0, `search_index` int(1) not null default 0, `allow_in_quick_entry` int(1) not null default 0, `ignore_xss_filter` int(1) not null default 0, `translatable` int(1) not null default 0, `hide_border` int(1) not null default 0, `show_dashboard` int(1) not null default 0, `description` text, `permlevel` int(11) not null default 0, `width` varchar(140), `columns` int(11) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `dt`(`dt`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:46,049 WARNING database DDL Query made to DB: create table `tabProperty Setter` ( 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', `is_system_generated` int(1) not null default 0, `doctype_or_field` varchar(140), `doc_type` varchar(140), `field_name` varchar(140), `row_name` varchar(140), `module` varchar(140), `property` varchar(140), `property_type` varchar(140), `value` text, `default_value` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `doc_type`(`doc_type`), index `field_name`(`field_name`), index `property`(`property`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:46,153 WARNING database DDL Query made to DB: create table `tabWeb Form` ( 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), `route` varchar(140) unique, `published` int(1) not null default 0, `doc_type` varchar(140), `module` varchar(140), `is_standard` int(1) not null default 0, `introduction_text` longtext, `anonymous` int(1) not null default 0, `login_required` int(1) not null default 0, `apply_document_permissions` int(1) not null default 0, `allow_edit` int(1) not null default 0, `allow_multiple` int(1) not null default 0, `allow_delete` int(1) not null default 0, `allow_incomplete` int(1) not null default 0, `allow_comments` int(1) not null default 0, `allow_print` int(1) not null default 0, `print_format` varchar(140), `max_attachment_size` int(11) not null default 0, `show_attachments` int(1) not null default 0, `allowed_embedding_domains` text, `condition_json` json, `show_list` int(1) not null default 0, `list_title` varchar(140), `show_sidebar` int(1) not null default 0, `website_sidebar` varchar(140), `button_label` varchar(140) default 'Save', `banner_image` text, `breadcrumbs` longtext, `success_title` varchar(140), `success_url` varchar(140), `success_message` text, `meta_title` varchar(140), `meta_description` text, `meta_image` text, `client_script` longtext, `custom_css` 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 2025-06-23 23:51:46,222 WARNING database DDL Query made to DB: create table `tabWeb 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', `type` varchar(140) default 'Section', `standard` int(1) not null default 0, `module` varchar(140), `template` 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 2025-06-23 23:51:46,293 WARNING database DDL Query made to DB: create table `tabWeb Form Field` ( 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', `fieldname` varchar(140), `fieldtype` varchar(140), `label` varchar(140), `allow_read_on_all_link_options` int(1) not null default 0, `reqd` int(1) not null default 0, `read_only` int(1) not null default 0, `show_in_filter` int(1) not null default 0, `hidden` int(1) not null default 0, `options` text, `max_length` int(11) not null default 0, `max_value` int(11) not null default 0, `precision` varchar(140), `depends_on` longtext, `mandatory_depends_on` longtext, `read_only_depends_on` longtext, `description` text, `default` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:46,345 WARNING database DDL Query made to DB: create table `tabPortal Menu 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', `title` varchar(140), `enabled` int(1) not null default 0, `route` varchar(140), `reference_doctype` varchar(140), `role` varchar(140), `target` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:46,417 WARNING database DDL Query made to DB: create table `tabNumber Card` ( 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', `is_standard` int(1) not null default 0, `module` varchar(140), `label` varchar(140), `type` varchar(140), `report_name` varchar(140), `method` varchar(140), `function` varchar(140), `aggregate_function_based_on` varchar(140), `document_type` varchar(140), `parent_document_type` varchar(140), `report_field` varchar(140), `report_function` varchar(140), `is_public` int(1) not null default 0, `currency` varchar(140), `filters_config` longtext, `show_percentage_stats` int(1) not null default 1, `stats_time_interval` varchar(140) default 'Daily', `filters_json` longtext, `dynamic_filters_json` longtext, `color` 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 2025-06-23 23:51:46,524 WARNING database DDL Query made to DB: create table `tabDashboard Chart` ( 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', `is_standard` int(1) not null default 0, `module` varchar(140), `chart_name` varchar(140) unique, `chart_type` varchar(140), `report_name` varchar(140), `use_report_chart` int(1) not null default 0, `x_field` varchar(140), `source` varchar(140), `document_type` varchar(140), `parent_document_type` varchar(140), `based_on` varchar(140), `value_based_on` varchar(140), `group_by_type` varchar(140) default 'Count', `group_by_based_on` varchar(140), `aggregate_function_based_on` varchar(140), `number_of_groups` int(11) not null default 0, `is_public` int(1) not null default 0, `heatmap_year` varchar(140), `timespan` varchar(140), `from_date` date, `to_date` date, `time_interval` varchar(140), `timeseries` int(1) not null default 0, `type` varchar(140) default 'Line', `currency` varchar(140), `filters_json` longtext, `dynamic_filters_json` longtext, `custom_options` longtext, `color` varchar(140), `last_synced_on` datetime(6), `_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 2025-06-23 23:51:46,585 WARNING database DDL Query made to DB: create table `tabDashboard` ( 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', `dashboard_name` varchar(140) unique, `is_default` int(1) not null default 0, `is_standard` int(1) not null default 0, `module` varchar(140), `chart_options` 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 2025-06-23 23:51:46,636 WARNING database DDL Query made to DB: create table `tabOnboarding Permission` ( 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', `role` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:46,713 WARNING database DDL Query made to DB: create table `tabOnboarding Step` ( 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), `is_complete` int(1) not null default 0, `is_skipped` int(1) not null default 0, `description` longtext, `intro_video_url` varchar(140), `action` varchar(140), `action_label` varchar(140), `reference_document` varchar(140), `show_full_form` int(1) not null default 0, `show_form_tour` int(1) not null default 0, `form_tour` varchar(140), `is_single` int(1) not null default 0, `reference_report` varchar(140), `report_reference_doctype` varchar(140), `report_type` varchar(140), `report_description` varchar(140), `path` varchar(140), `callback_title` varchar(140), `callback_message` text, `validate_action` int(1) not null default 1, `field` varchar(140), `value_to_validate` varchar(140), `video_url` 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 2025-06-23 23:51:46,763 WARNING database DDL Query made to DB: create table `tabOnboarding Step Map` ( 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', `step` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:46,818 WARNING database DDL Query made to DB: create table `tabModule Onboarding` ( 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), `subtitle` varchar(140), `module` varchar(140), `success_message` varchar(140), `documentation_url` varchar(140), `is_complete` int(1) 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 2025-06-23 23:51:46,884 WARNING database DDL Query made to DB: create table `tabWorkspace Link` ( 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', `type` varchar(140) default 'Link', `label` varchar(140), `icon` varchar(140), `description` longtext, `hidden` int(1) not null default 0, `link_type` varchar(140), `link_to` varchar(140), `report_ref_doctype` varchar(140), `dependencies` varchar(140), `only_for` varchar(140), `onboard` int(1) not null default 0, `is_query_report` int(1) not null default 0, `link_count` int(11) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:46,931 WARNING database DDL Query made to DB: create table `tabWorkspace Chart` ( 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', `chart_name` varchar(140), `label` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:46,997 WARNING database DDL Query made to DB: create table `tabWorkspace Shortcut` ( 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', `type` varchar(140), `link_to` varchar(140), `url` varchar(140), `doc_view` varchar(140), `kanban_board` varchar(140), `label` varchar(140), `icon` varchar(140), `restrict_to_domain` varchar(140), `report_ref_doctype` varchar(140), `stats_filter` longtext, `color` varchar(140), `format` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:47,052 WARNING database DDL Query made to DB: create table `tabWorkspace Quick List` ( 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', `document_type` varchar(140), `label` varchar(140), `quick_list_filter` longtext, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:47,097 WARNING database DDL Query made to DB: create table `tabWorkspace Number Card` ( 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', `number_card_name` varchar(140), `label` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:47,144 WARNING database DDL Query made to DB: create table `tabWorkspace Custom Block` ( 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', `custom_block_name` varchar(140), `label` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:47,227 WARNING database DDL Query made to DB: create table `tabWorkspace` ( 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', `label` varchar(140) unique, `title` varchar(140), `sequence_id` decimal(21,9) not null default 0, `for_user` varchar(140), `parent_page` varchar(140), `module` varchar(140), `icon` varchar(140), `indicator_color` varchar(140), `restrict_to_domain` varchar(140), `hide_custom` int(1) not null default 0, `public` int(1) not null default 0, `is_hidden` int(1) not null default 0, `content` longtext default '[]', `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `restrict_to_domain`(`restrict_to_domain`), index `public`(`public`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:47,294 WARNING database DDL Query made to DB: create table `tabPage` ( 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', `system_page` int(1) not null default 0, `page_name` varchar(140) unique, `title` varchar(140), `icon` varchar(140), `module` varchar(140), `restrict_to_domain` varchar(140), `standard` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `standard`(`standard`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:47,372 WARNING database DDL Query made to DB: create table `tabReport` ( 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', `report_name` varchar(140) unique, `ref_doctype` varchar(140), `reference_report` varchar(140), `is_standard` varchar(140), `module` varchar(140), `report_type` varchar(140), `letter_head` varchar(140), `add_total_row` int(1) not null default 0, `disabled` int(1) not null default 0, `prepared_report` int(1) not null default 0, `add_translate_data` int(1) not null default 0, `timeout` int(11) not null default 0, `query` longtext, `report_script` longtext, `javascript` longtext, `json` 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 2025-06-23 23:51:47,434 WARNING database DDL Query made to DB: create table `tabDashboard Chart Source` ( 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', `source_name` varchar(140) unique, `module` varchar(140), `timeseries` int(1) 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 2025-06-23 23:51:47,519 WARNING database DDL Query made to DB: create table `tabPrint Format` ( 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', `doc_type` varchar(140), `module` varchar(140), `default_print_language` varchar(140), `standard` varchar(140) default 'No', `custom_format` int(1) not null default 0, `disabled` int(1) not null default 0, `pdf_generator` varchar(140) default 'wkhtmltopdf', `print_format_type` varchar(140) default 'Jinja', `raw_printing` int(1) not null default 0, `html` longtext, `raw_commands` longtext, `margin_top` decimal(21,9) not null default 15.0, `margin_bottom` decimal(21,9) not null default 15.0, `margin_left` decimal(21,9) not null default 15.0, `margin_right` decimal(21,9) not null default 15.0, `align_labels_right` int(1) not null default 0, `show_section_headings` int(1) not null default 0, `line_breaks` int(1) not null default 0, `absolute_value` int(1) not null default 0, `font_size` int(11) not null default 14, `font` varchar(140), `page_number` varchar(140) default 'Hide', `css` longtext, `format_data` longtext, `print_format_builder` int(1) not null default 0, `print_format_builder_beta` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `standard`(`standard`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:47,613 WARNING database DDL Query made to DB: create table `tabWeb Page` ( 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), `route` varchar(140) unique, `dynamic_route` int(1) not null default 0, `published` int(1) not null default 1, `module` varchar(140), `content_type` varchar(140) default 'Page Builder', `slideshow` varchar(140), `dynamic_template` int(1) not null default 0, `main_section` longtext, `main_section_md` longtext, `main_section_html` longtext, `context_script` longtext, `javascript` longtext, `insert_style` int(1) not null default 0, `text_align` varchar(140), `css` longtext, `full_width` int(1) not null default 1, `show_title` int(1) not null default 0, `start_date` datetime(6), `end_date` datetime(6), `meta_title` varchar(140), `meta_description` text, `meta_image` text, `show_sidebar` int(1) not null default 0, `website_sidebar` varchar(140), `enable_comments` int(1) not null default 0, `header` longtext, `breadcrumbs` 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 2025-06-23 23:51:47,689 WARNING database DDL Query made to DB: create table `tabWebsite Theme` ( 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', `theme` varchar(140) unique, `module` varchar(140) default 'Website', `custom` int(1) not null default 1, `google_font` varchar(140), `font_size` varchar(140), `font_properties` varchar(140) default 'wght@300;400;500;600;700;800', `button_rounded_corners` int(1) not null default 1, `button_shadows` int(1) not null default 0, `button_gradients` int(1) not null default 0, `primary_color` varchar(140), `text_color` varchar(140), `light_color` varchar(140), `dark_color` varchar(140), `background_color` varchar(140), `custom_overrides` longtext, `custom_scss` longtext, `theme_scss` longtext, `theme_url` varchar(140), `js` 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 2025-06-23 23:51:47,782 WARNING database DDL Query made to DB: create table `tabNotification` ( 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', `enabled` int(1) not null default 1, `is_standard` int(1) not null default 0, `module` varchar(140), `channel` varchar(140) default 'Email', `slack_webhook_url` varchar(140), `subject` varchar(140), `event` varchar(140), `document_type` varchar(140), `method` varchar(140), `date_changed` varchar(140), `days_in_advance` int(11) not null default 0, `value_changed` varchar(140), `sender` varchar(140), `send_system_notification` int(1) not null default 0, `sender_email` varchar(140), `condition` longtext, `set_property_after_alert` varchar(140), `property_value` varchar(140), `send_to_all_assignees` int(1) not null default 0, `message_type` varchar(140) default 'Markdown', `message` longtext default 'Add your message here', `attach_print` int(1) not null default 0, `print_format` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `event`(`event`), index `document_type`(`document_type`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:47,837 WARNING database DDL Query made to DB: create table `tabPrint Style` ( 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', `print_style_name` varchar(140) unique, `disabled` int(1) not null default 0, `standard` int(1) not null default 0, `css` longtext, `preview` 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 2025-06-23 23:51:47,896 WARNING database DDL Query made to DB: create table `tabClient Script` ( 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', `dt` varchar(140), `view` varchar(140) default 'Form', `module` varchar(140), `enabled` int(1) not null default 0, `script` 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 2025-06-23 23:51:47,964 WARNING database DDL Query made to DB: create table `tabServer Script` ( 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', `script_type` varchar(140), `reference_doctype` varchar(140), `event_frequency` varchar(140), `cron_format` varchar(140), `doctype_event` varchar(140), `api_method` varchar(140), `allow_guest` int(1) not null default 0, `module` varchar(140), `disabled` int(1) not null default 0, `script` longtext, `enable_rate_limit` int(1) not null default 0, `rate_limit_count` int(11) not null default 5, `rate_limit_seconds` int(11) not null default 86400, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `reference_doctype`(`reference_doctype`), index `module`(`module`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:48,032 WARNING database DDL Query made to DB: create table `tabTranslation` ( 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', `contributed` int(1) not null default 0, `language` varchar(140), `source_text` longtext, `context` varchar(140), `translated_text` longtext, `contribution_status` varchar(140), `contribution_docname` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `language`(`language`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:48,195 WARNING database DDL Query made to DB: create table `tabUser` ( 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', `enabled` int(1) not null default 1, `email` varchar(140), `first_name` varchar(140), `middle_name` varchar(140), `last_name` varchar(140), `full_name` varchar(140), `username` varchar(140) unique, `language` varchar(140), `time_zone` varchar(140), `send_welcome_email` int(1) not null default 1, `unsubscribed` int(1) not null default 0, `user_image` text, `role_profile_name` varchar(140), `module_profile` varchar(140), `home_settings` longtext, `gender` varchar(140), `birth_date` date, `interest` text, `phone` varchar(140), `location` varchar(140), `bio` text, `mobile_no` varchar(140) unique, `mute_sounds` int(1) not null default 0, `desk_theme` varchar(140), `banner_image` text, `search_bar` int(1) not null default 1, `notifications` int(1) not null default 1, `list_sidebar` int(1) not null default 1, `bulk_actions` int(1) not null default 1, `view_switcher` int(1) not null default 1, `form_sidebar` int(1) not null default 1, `timeline` int(1) not null default 1, `dashboard` int(1) not null default 1, `new_password` text, `logout_all_sessions` int(1) not null default 1, `reset_password_key` varchar(140), `last_reset_password_key_generated_on` datetime(6), `last_password_reset_date` date, `redirect_url` text, `document_follow_notify` int(1) not null default 0, `document_follow_frequency` varchar(140) default 'Daily', `follow_created_documents` int(1) not null default 0, `follow_commented_documents` int(1) not null default 0, `follow_liked_documents` int(1) not null default 0, `follow_assigned_documents` int(1) not null default 0, `follow_shared_documents` int(1) not null default 0, `email_signature` text, `thread_notify` int(1) not null default 1, `send_me_a_copy` int(1) not null default 0, `allowed_in_mentions` int(1) not null default 1, `default_workspace` varchar(140), `default_app` varchar(140), `simultaneous_sessions` int(11) not null default 2, `restrict_ip` text, `last_ip` varchar(140), `login_after` int(11) not null default 0, `user_type` varchar(140) default 'System User', `last_active` datetime(6), `login_before` int(11) not null default 0, `bypass_restrict_ip_check_if_2fa_enabled` int(1) not null default 0, `last_login` varchar(140), `last_known_versions` text, `api_key` varchar(140) unique, `api_secret` text, `onboarding_status` text default '{}', `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `last_active`(`last_active`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:48,260 WARNING database DDL Query made to DB: create table `tabDocument Naming Rule` ( 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', `document_type` varchar(140), `disabled` int(1) not null default 0, `priority` int(11) not null default 0, `prefix` varchar(140), `counter` int(11) not null default 0, `prefix_digits` int(11) not null default 5, `_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 2025-06-23 23:51:48,375 WARNING database DDL Query made to DB: ALTER TABLE `tabDefaultValue` MODIFY `defkey` varchar(140) 2025-06-23 23:51:48,403 WARNING database DDL Query made to DB: ALTER TABLE `tabDefaultValue` ADD INDEX IF NOT EXISTS `defaultvalue_parent_parenttype_index`(parent, parenttype) 2025-06-23 23:51:48,591 WARNING database DDL Query made to DB: create table `tabScheduler Event` ( 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', `scheduled_against` varchar(140), `method` 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 2025-06-23 23:51:48,641 WARNING database DDL Query made to DB: create table `tabUser Select Document Type` ( 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', `document_type` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:48,695 WARNING database DDL Query made to DB: create table `tabView Log` ( 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', `viewed_by` varchar(140), `reference_doctype` varchar(140), `reference_name` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `reference_name`(`reference_name`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:48,744 WARNING database DDL Query made to DB: create table `tabUser Group Member` ( 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', `user` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:48,796 WARNING database DDL Query made to DB: create table `tabDomain` ( 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', `domain` 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 2025-06-23 23:51:48,877 WARNING database DDL Query made to DB: ALTER TABLE `tabFile` ADD COLUMN `is_private` int(1) not null default 0, ADD COLUMN `file_type` varchar(140), ADD COLUMN `is_home_folder` int(1) not null default 0, ADD COLUMN `is_attachments_folder` int(1) not null default 0, ADD COLUMN `thumbnail_url` text, ADD COLUMN `folder` varchar(255), ADD COLUMN `is_folder` int(1) not null default 0, ADD COLUMN `attached_to_field` varchar(140), ADD COLUMN `old_parent` varchar(140), ADD COLUMN `content_hash` varchar(140), ADD COLUMN `uploaded_to_dropbox` int(1) not null default 0, ADD COLUMN `uploaded_to_google_drive` int(1) not null default 0, ADD COLUMN `_user_tags` text, ADD COLUMN `_comments` text, ADD COLUMN `_assign` text, ADD COLUMN `_liked_by` text 2025-06-23 23:51:48,906 WARNING database DDL Query made to DB: ALTER TABLE `tabFile` MODIFY `attached_to_name` varchar(140), MODIFY `file_size` bigint(20) not null default 0, MODIFY `file_url` longtext, MODIFY `file_name` varchar(140), MODIFY `attached_to_doctype` varchar(140) 2025-06-23 23:51:48,922 WARNING database DDL Query made to DB: ALTER TABLE `tabFile` DROP INDEX `attached_to_name`, DROP INDEX `attached_to_doctype` 2025-06-23 23:51:48,951 WARNING database DDL Query made to DB: ALTER TABLE `tabFile` ADD INDEX IF NOT EXISTS `attached_to_doctype_attached_to_name_index`(attached_to_doctype, attached_to_name) 2025-06-23 23:51:48,972 WARNING database DDL Query made to DB: ALTER TABLE `tabFile` ADD INDEX IF NOT EXISTS `file_url_index`(file_url(100)) 2025-06-23 23:51:49,012 WARNING database DDL Query made to DB: create table `tabUser Group` ( 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', `_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 2025-06-23 23:51:49,115 WARNING database DDL Query made to DB: create table `tabPackage Release` ( 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', `package` varchar(140), `publish` int(1) not null default 0, `path` text, `major` int(11) not null default 0, `minor` int(11) not null default 0, `patch` int(11) not null default 0, `release_notes` 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 2025-06-23 23:51:49,166 WARNING database DDL Query made to DB: create table `tabSMS Parameter` ( 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', `parameter` varchar(140), `value` varchar(255), `header` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:49,230 WARNING database DDL Query made to DB: create table `tabUser Document Type` ( 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', `document_type` varchar(140), `is_custom` int(1) not null default 0, `read` int(1) not null default 1, `write` int(1) not null default 0, `create` int(1) not null default 0, `submit` int(1) not null default 0, `cancel` int(1) not null default 0, `amend` int(1) not null default 0, `delete` int(1) not null default 0, `email` int(1) not null default 1, `share` int(1) not null default 1, `print` int(1) not null default 1, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:49,298 WARNING database DDL Query made to DB: create table `tabDocShare` ( 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', `user` varchar(140), `share_doctype` varchar(140), `share_name` varchar(140), `read` int(1) not null default 0, `write` int(1) not null default 0, `share` int(1) not null default 0, `submit` int(1) not null default 0, `everyone` int(1) not null default 0, `notify_by_email` int(1) not null default 1, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `user`(`user`), index `share_doctype`(`share_doctype`), index `share_name`(`share_name`), index `everyone`(`everyone`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:51:49,331 WARNING database DDL Query made to DB: ALTER TABLE `tabDocShare` ADD INDEX IF NOT EXISTS `user_share_doctype_index`(user, share_doctype) 2025-06-23 23:51:49,353 WARNING database DDL Query made to DB: ALTER TABLE `tabDocShare` ADD INDEX IF NOT EXISTS `share_doctype_share_name_index`(share_doctype, share_name) 2025-06-23 23:51:49,458 WARNING database DDL Query made to DB: create table `tabScheduled Job Type` ( 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', `stopped` int(1) not null default 0, `method` varchar(140), `server_script` varchar(140), `scheduler_event` varchar(140), `frequency` varchar(140), `cron_format` varchar(140), `create_log` int(1) not null default 0, `last_execution` datetime(6), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `server_script`(`server_script`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci