2586 lines
97 KiB
Groff
2586 lines
97 KiB
Groff
2025-06-23 23:53:22,709 WARNING database DDL Query made to DB:
|
|
create table `tabDesignation Skill` (
|
|
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',
|
|
`skill` 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:53:22,805 WARNING database DDL Query made to DB:
|
|
create table `tabGoal` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`goal_name` varchar(140),
|
|
`is_group` int(1) not null default 0,
|
|
`parent_goal` varchar(140),
|
|
`progress` decimal(21,9) not null default 0,
|
|
`status` varchar(140) default 'Pending',
|
|
`employee` varchar(140),
|
|
`employee_name` varchar(140),
|
|
`company` varchar(140),
|
|
`user` varchar(140),
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`appraisal_cycle` varchar(140),
|
|
`kra` varchar(140),
|
|
`description` longtext,
|
|
`lft` int(11) not null default 0,
|
|
`rgt` int(11) not null default 0,
|
|
`old_parent` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:53:22,908 WARNING database DDL Query made to DB:
|
|
create table `tabEmployee Separation Template` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`title` varchar(140),
|
|
`company` varchar(140),
|
|
`department` varchar(140),
|
|
`designation` varchar(140),
|
|
`employee_grade` 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:53:23,012 WARNING database DDL Query made to DB:
|
|
create table `tabTraining 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',
|
|
`event_name` varchar(140) unique,
|
|
`training_program` varchar(140),
|
|
`event_status` varchar(140),
|
|
`has_certificate` int(1) not null default 0,
|
|
`type` varchar(140),
|
|
`level` varchar(140),
|
|
`company` varchar(140),
|
|
`trainer_name` varchar(140),
|
|
`trainer_email` varchar(140),
|
|
`supplier` varchar(140),
|
|
`contact_number` varchar(140),
|
|
`course` varchar(140),
|
|
`location` varchar(140),
|
|
`start_time` datetime(6),
|
|
`end_time` datetime(6),
|
|
`introduction` longtext,
|
|
`amended_from` varchar(140),
|
|
`employee_emails` 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:53:23,092 WARNING database DDL Query made to DB:
|
|
create table `tabEmployee Skill` (
|
|
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',
|
|
`skill` varchar(140),
|
|
`proficiency` decimal(3,2),
|
|
`evaluation_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:53:23,872 WARNING database DDL Query made to DB:
|
|
create table `tabEmployee Benefit Claim` (
|
|
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),
|
|
`claim_date` date,
|
|
`currency` varchar(140),
|
|
`company` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`earning_component` varchar(140),
|
|
`max_amount_eligible` decimal(21,9) not null default 0,
|
|
`pay_against_benefit_claim` int(1) not null default 0,
|
|
`claimed_amount` decimal(21,9) not null default 0,
|
|
`salary_slip` varchar(140),
|
|
`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:53:24,073 WARNING database DDL Query made to DB:
|
|
create table `tabSalary Slip` (
|
|
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),
|
|
`department` varchar(140),
|
|
`designation` varchar(140),
|
|
`branch` varchar(140),
|
|
`posting_date` date,
|
|
`letter_head` varchar(140),
|
|
`status` varchar(140),
|
|
`salary_withholding` varchar(140),
|
|
`salary_withholding_cycle` varchar(140),
|
|
`currency` varchar(140),
|
|
`exchange_rate` decimal(21,9) not null default 1.0,
|
|
`payroll_frequency` varchar(140),
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`salary_structure` varchar(140),
|
|
`payroll_entry` varchar(140),
|
|
`mode_of_payment` varchar(140),
|
|
`salary_slip_based_on_timesheet` int(1) not null default 0,
|
|
`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,
|
|
`total_working_days` decimal(21,9) not null default 0,
|
|
`unmarked_days` decimal(21,9) not null default 0,
|
|
`leave_without_pay` decimal(21,9) not null default 0,
|
|
`absent_days` decimal(21,9) not null default 0,
|
|
`payment_days` decimal(21,9) not null default 0,
|
|
`total_working_hours` decimal(21,9) not null default 0,
|
|
`hour_rate` decimal(21,9) not null default 0,
|
|
`base_hour_rate` decimal(21,9) not null default 0,
|
|
`gross_pay` decimal(21,9) not null default 0,
|
|
`base_gross_pay` decimal(21,9) not null default 0,
|
|
`gross_year_to_date` decimal(21,9) not null default 0,
|
|
`base_gross_year_to_date` decimal(21,9) not null default 0,
|
|
`total_deduction` decimal(21,9) not null default 0,
|
|
`base_total_deduction` decimal(21,9) not null default 0,
|
|
`net_pay` decimal(21,9) not null default 0,
|
|
`base_net_pay` decimal(21,9) not null default 0,
|
|
`rounded_total` decimal(21,9) not null default 0,
|
|
`base_rounded_total` decimal(21,9) not null default 0,
|
|
`year_to_date` decimal(21,9) not null default 0,
|
|
`base_year_to_date` decimal(21,9) not null default 0,
|
|
`month_to_date` decimal(21,9) not null default 0,
|
|
`base_month_to_date` decimal(21,9) not null default 0,
|
|
`total_in_words` varchar(240),
|
|
`base_total_in_words` varchar(240),
|
|
`ctc` decimal(21,9) not null default 0,
|
|
`income_from_other_sources` decimal(21,9) not null default 0,
|
|
`total_earnings` decimal(21,9) not null default 0,
|
|
`non_taxable_earnings` decimal(21,9) not null default 0,
|
|
`standard_tax_exemption_amount` decimal(21,9) not null default 0,
|
|
`tax_exemption_declaration` decimal(21,9) not null default 0,
|
|
`deductions_before_tax_calculation` decimal(21,9) not null default 0,
|
|
`annual_taxable_amount` decimal(21,9) not null default 0,
|
|
`income_tax_deducted_till_date` decimal(21,9) not null default 0,
|
|
`current_month_income_tax` decimal(21,9) not null default 0,
|
|
`future_income_tax_deductions` decimal(21,9) not null default 0,
|
|
`total_income_tax` decimal(21,9) not null default 0,
|
|
`journal_entry` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`bank_name` varchar(140),
|
|
`bank_account_no` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `employee`(`employee`),
|
|
index `start_date`(`start_date`),
|
|
index `end_date`(`end_date`),
|
|
index `salary_structure`(`salary_structure`),
|
|
index `payroll_entry`(`payroll_entry`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:53:24,147 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabSalary Slip`
|
|
ADD INDEX IF NOT EXISTS `employee_start_date_end_date_index`(employee, start_date, end_date)
|
|
2025-06-23 23:53:24,200 WARNING database DDL Query made to DB:
|
|
create table `tabGratuity 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',
|
|
`disable` int(1) not null default 0,
|
|
`calculate_gratuity_amount_based_on` varchar(140),
|
|
`total_working_days_per_year` int(11) not null default 365,
|
|
`work_experience_calculation_function` varchar(140) default 'Round off Work Experience',
|
|
`minimum_year_for_gratuity` int(11) 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:53:24,299 WARNING database DDL Query made to DB:
|
|
create table `tabRetention Bonus` (
|
|
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),
|
|
`date_of_joining` varchar(140),
|
|
`salary_component` varchar(140),
|
|
`bonus_amount` decimal(21,9) not null default 0,
|
|
`bonus_payment_date` date,
|
|
`currency` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:53:24,408 WARNING database DDL Query made to DB:
|
|
create table `tabPayroll Employee 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',
|
|
`employee` varchar(140),
|
|
`employee_name` varchar(140),
|
|
`department` varchar(140),
|
|
`designation` varchar(140),
|
|
`is_salary_withheld` 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:53:24,500 WARNING database DDL Query made to DB:
|
|
create table `tabEmployee Benefit Application` (
|
|
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),
|
|
`date` date,
|
|
`payroll_period` varchar(140),
|
|
`company` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`currency` varchar(140),
|
|
`max_benefits` decimal(21,9) not null default 0,
|
|
`remaining_benefit` decimal(21,9) not null default 0,
|
|
`total_amount` decimal(21,9) not null default 0,
|
|
`pro_rata_dispensed_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:53:24,598 WARNING database DDL Query made to DB:
|
|
create table `tabGratuity Applicable 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),
|
|
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:53:24,706 WARNING database DDL Query made to DB:
|
|
create table `tabSalary 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',
|
|
`salary_component` varchar(140),
|
|
`abbr` varchar(140),
|
|
`amount` decimal(21,9) not null default 0,
|
|
`year_to_date` decimal(21,9) not null default 0,
|
|
`additional_salary` varchar(140),
|
|
`is_recurring_additional_salary` int(1) not null default 0,
|
|
`statistical_component` int(1) not null default 0,
|
|
`depends_on_payment_days` int(1) not null default 0,
|
|
`exempted_from_income_tax` int(1) not null default 0,
|
|
`is_tax_applicable` int(1) not null default 0,
|
|
`is_flexible_benefit` int(1) not null default 0,
|
|
`variable_based_on_taxable_salary` int(1) not null default 0,
|
|
`do_not_include_in_total` int(1) not null default 0,
|
|
`deduct_full_tax_on_selected_payroll_date` int(1) not null default 0,
|
|
`condition` longtext,
|
|
`amount_based_on_formula` int(1) not null default 0,
|
|
`formula` longtext,
|
|
`default_amount` decimal(21,9) not null default 0,
|
|
`additional_amount` decimal(21,9) not null default 0,
|
|
`tax_on_flexible_benefit` decimal(21,9) not null default 0,
|
|
`tax_on_additional_salary` decimal(21,9) not null default 0,
|
|
index `salary_component`(`salary_component`),
|
|
index `exempted_from_income_tax`(`exempted_from_income_tax`),
|
|
index `is_tax_applicable`(`is_tax_applicable`),
|
|
index `variable_based_on_taxable_salary`(`variable_based_on_taxable_salary`),
|
|
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:53:24,816 WARNING database DDL Query made to DB:
|
|
create table `tabSalary Structure` (
|
|
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),
|
|
`letter_head` varchar(140),
|
|
`is_active` varchar(140) default 'Yes',
|
|
`is_default` varchar(140) default 'No',
|
|
`currency` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`leave_encashment_amount_per_day` decimal(21,9) not null default 0,
|
|
`max_benefits` decimal(21,9) not null default 0,
|
|
`salary_slip_based_on_timesheet` int(1) not null default 0,
|
|
`payroll_frequency` varchar(140) default 'Monthly',
|
|
`salary_component` varchar(140),
|
|
`hour_rate` decimal(21,9) not null default 0,
|
|
`total_earning` decimal(21,9) not null default 0,
|
|
`total_deduction` decimal(21,9) not null default 0,
|
|
`net_pay` decimal(21,9) not null default 0,
|
|
`mode_of_payment` varchar(140),
|
|
`payment_account` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `company`(`company`),
|
|
index `currency`(`currency`),
|
|
index `salary_slip_based_on_timesheet`(`salary_slip_based_on_timesheet`),
|
|
index `payroll_frequency`(`payroll_frequency`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:53:24,912 WARNING database DDL Query made to DB:
|
|
create table `tabIncome Tax Slab Other Charges` (
|
|
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',
|
|
`description` varchar(140),
|
|
`percent` decimal(21,9) not null default 0,
|
|
`min_taxable_income` decimal(21,9) not null default 0,
|
|
`max_taxable_income` 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:53:25,023 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:53:25,114 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:53:25,212 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:53:25,309 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:53:25,406 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:53:25,496 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:53:25,593 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:53:25,684 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:53:25,799 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:53:25,895 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:53:26,048 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:53:26,204 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:53:26,283 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:53:26,361 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:53:26,435 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:53:26,511 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:53:26,600 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:53:26,699 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:53:26,775 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:53:26,847 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:53:26,950 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:53:27,052 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:53:27,166 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:53:27,282 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:53:27,416 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:53:27,508 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:53:28,673 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:53:28,716 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:53:28,768 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTimesheet` ADD COLUMN `salary_slip` varchar(140)
|
|
2025-06-23 23:53:28,783 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTimesheet` MODIFY `base_total_billed_amount` decimal(21,9) not null default 0, MODIFY `per_billed` decimal(21,9) not null default 0, MODIFY `total_billable_hours` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_billed_hours` decimal(21,9) not null default 0, MODIFY `base_total_billable_amount` decimal(21,9) not null default 0, MODIFY `base_total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0
|
|
2025-06-23 23:53:28,823 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabDesignation` ADD COLUMN `appraisal_template` varchar(140)
|
|
2025-06-23 23:53:28,873 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:53:28,889 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTask` MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `task_weight` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_billing_amount` decimal(21,9) not null default 0, MODIFY `progress` decimal(21,9) not null default 0
|
|
2025-06-23 23:53:28,939 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:53:28,955 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabProject` MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_billable_amount` decimal(21,9) not null default 0, MODIFY `total_consumed_material_cost` decimal(21,9) not null default 0, MODIFY `total_purchase_cost` decimal(21,9) not null default 0, MODIFY `total_sales_amount` 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 `gross_margin` decimal(21,9) not null default 0, MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `estimated_costing` decimal(21,9) not null default 0, MODIFY `percent_complete` decimal(21,9) not null default 0
|
|
2025-06-23 23:53:29,016 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:53:29,032 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0
|
|
2025-06-23 23:53:29,092 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:53:29,108 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:53:47,445 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:53:47,666 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:53:48,780 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabPayment Entry` ADD COLUMN `check_run` varchar(140)
|
|
2025-06-23 23:53:48,796 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabPayment Entry` MODIFY `received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `target_exchange_rate` decimal(21,9) not null default 0, MODIFY `paid_from_account_balance` decimal(21,9) not null default 0, MODIFY `paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `source_exchange_rate` decimal(21,9) not null default 0, MODIFY `base_received_amount` decimal(21,9) not null default 0, MODIFY `unallocated_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `received_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `total_allocated_amount` decimal(21,9) not null default 0, MODIFY `base_total_allocated_amount` decimal(21,9) not null default 0, MODIFY `paid_to_account_balance` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `party_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
|
|
2025-06-23 23:53:48,858 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabBank` ADD COLUMN `aba_number` varchar(140)
|
|
2025-06-23 23:53:49,106 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabPurchase Invoice` ADD COLUMN `supplier_default_mode_of_payment` varchar(140)
|
|
2025-06-23 23:53:49,123 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabPurchase Invoice` MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` 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 `write_off_amount` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` 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 `base_rounded_total` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0
|
|
2025-06-23 23:53:49,325 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:53:49,342 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0
|
|
2025-06-23 23:53:49,472 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:53:49,697 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:53:49,934 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:53:50,808 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:53:50,824 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabPurchase Invoice` MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` 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 `base_paid_amount` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `outstanding_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, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0
|
|
2025-06-23 23:53:51,045 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:53:51,159 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:53:51,288 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:53:51,391 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:53:51,477 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:53:51,566 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:53:51,657 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:53:51,803 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:53:51,975 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:55:21,548 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:55:21,565 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabSales Order` MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `loyalty_amount` decimal(21,9) not null default 0, MODIFY `advance_paid` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total_commission` 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_grand_total` decimal(21,9) not null default 0, MODIFY `commission_rate` decimal(21,9) not null default 0, MODIFY `per_billed` decimal(21,9) not null default 0, MODIFY `per_picked` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `amount_eligible_for_commission` decimal(21,9) not null default 0, MODIFY `per_delivered` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0
|
|
2025-06-23 23:55:21,653 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:55:21,669 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabQuotation` MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_grand_total` 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_discount_amount` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `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
|
|
2025-06-23 23:55:21,745 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabSupplier` ADD COLUMN `irs_1099` int(1) not null default 0
|
|
2025-06-23 23:55:21,821 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:55:21,837 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:55:21,953 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:55:21,970 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabSales Invoice` MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `change_amount` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `amount_eligible_for_commission` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `loyalty_amount` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_change_amount` 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 `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `total_commission` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `commission_rate` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0
|
|
2025-06-24 00:37:04,711 WARNING database DDL Query made to DB:
|
|
DROP USER IF EXISTS '_06925c1bee92171f'@'localhost'
|
|
2025-06-24 00:37:08,285 WARNING database DDL Query made to DB:
|
|
DROP DATABASE IF EXISTS `_06925c1bee92171f`
|
|
2025-06-24 00:37:08,288 WARNING database DDL Query made to DB:
|
|
CREATE USER '_06925c1bee92171f'@'localhost' IDENTIFIED BY 'zZxPjpFL3O8X4Crv'
|
|
2025-06-24 00:37:08,289 WARNING database DDL Query made to DB:
|
|
CREATE DATABASE `_06925c1bee92171f` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
|
|
2025-06-24 00:37:08,542 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-24 00:37:08,550 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-24 00:37:08,560 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-24 00:37:08,715 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-24 00:37:08,835 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-24 00:37:08,873 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabDocField` MODIFY `label` varchar(140), MODIFY `precision` varchar(140), MODIFY `fieldname` varchar(140), MODIFY `fieldtype` varchar(140) default 'Data', MODIFY `read_only_depends_on` longtext, MODIFY `depends_on` longtext, MODIFY `oldfieldname` varchar(140), MODIFY `width` varchar(10), MODIFY `oldfieldtype` varchar(140), MODIFY `collapsible_depends_on` longtext, MODIFY `mandatory_depends_on` longtext, MODIFY `print_width` varchar(10)
|
|
2025-06-24 00:37:08,966 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-24 00:37:08,989 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabDocPerm` MODIFY `role` varchar(140)
|
|
2025-06-24 00:37:09,038 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-24 00:37:09,083 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-24 00:37:09,169 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-24 00:37:09,248 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-24 00:37:09,396 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-24 00:37:09,426 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabDocType` 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), 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)
|
|
2025-06-24 00:37:09,445 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabDocType` ADD INDEX `module_index`(`module`)
|
|
2025-06-24 00:37:09,584 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-24 00:37:09,672 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-24 00:37:09,779 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-24 00:37:09,852 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-24 00:37:09,961 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-24 00:37:10,031 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-24 00:37:10,097 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-24 00:37:10,152 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-24 00:37:10,221 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-24 00:37:10,319 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-24 00:37:10,378 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-24 00:37:10,429 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-24 00:37:10,501 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-24 00:37:10,548 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-24 00:37:10,602 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-24 00:37:10,666 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-24 00:37:10,715 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-24 00:37:10,787 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-24 00:37:10,834 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-24 00:37:10,877 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-24 00:37:10,923 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-24 00:37:11,000 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-24 00:37:11,070 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-24 00:37:11,147 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-24 00:37:11,210 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-24 00:37:11,297 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-24 00:37:11,396 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-24 00:37:11,470 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-24 00:37:11,561 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
|