adam/frappe
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
frappe/logs/database.log.10

3239 lines
97 KiB
Text
Raw Permalink Blame History

2025-06-23 23:53:14,055 WARNING database DDL Query made to DB:
create table `tabEmployee Promotion` (
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),
`salary_currency` varchar(140),
`promotion_date` date,
`company` varchar(140),
`current_ctc` decimal(21,9) not null default 0,
`revised_ctc` decimal(21,9) not null default 0,
`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:14,167 WARNING database DDL Query made to DB:
create table `tabEmployee Grievance` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`subject` varchar(140),
`raised_by` varchar(140),
`employee_name` varchar(140),
`designation` varchar(140),
`date` date,
`status` varchar(140) default 'Open',
`reports_to` varchar(140),
`grievance_against_party` varchar(140),
`grievance_against` varchar(140),
`grievance_type` varchar(140),
`associated_document_type` varchar(140),
`associated_document` varchar(140),
`description` text,
`cause_of_grievance` text,
`resolved_by` varchar(140),
`resolution_date` date,
`employee_responsible` varchar(140),
`resolution_detail` 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:14,260 WARNING database DDL Query made to DB:
create table `tabInterest` (
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',
`interest` 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:14,363 WARNING database DDL Query made to DB:
create table `tabInterview Round` (
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',
`round_name` varchar(140) unique,
`interview_type` varchar(140),
`expected_average_rating` decimal(3,2),
`designation` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:14,453 WARNING database DDL Query made to DB:
create table `tabDaily Work Summary Group User` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`user` varchar(140),
`email` 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:14,523 WARNING database DDL Query made to DB:
create table `tabEmployee Health Insurance` (
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',
`health_insurance_name` 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:14,612 WARNING database DDL Query made to DB:
create table `tabShift Request` (
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',
`shift_type` varchar(140),
`employee` varchar(140),
`employee_name` varchar(140),
`department` varchar(140),
`status` varchar(140) default 'Draft',
`company` varchar(140),
`approver` varchar(140),
`from_date` date,
`to_date` date,
`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:14,710 WARNING database DDL Query made to DB:
create table `tabEmployee Transfer` (
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),
`transfer_date` date,
`company` varchar(140),
`new_company` varchar(140),
`department` varchar(140),
`reallocate_leaves` int(1) not null default 0,
`create_new_employee_id` int(1) not null default 0,
`new_employee_id` 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:14,804 WARNING database DDL Query made to DB:
create table `tabEmployee Grade` (
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',
`default_salary_structure` varchar(140),
`currency` varchar(140),
`default_base_pay` 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:14,917 WARNING database DDL Query made to DB:
create table `tabEmployee Checkin` (
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),
`log_type` varchar(140),
`shift` varchar(140),
`time` datetime(6),
`device_id` varchar(140),
`skip_auto_attendance` int(1) not null default 0,
`attendance` varchar(140),
`latitude` decimal(21,9) not null default 0,
`longitude` decimal(21,9) not null default 0,
`geolocation` longtext,
`shift_start` datetime(6),
`shift_end` datetime(6),
`offshift` int(1) not null default 0,
`shift_actual_start` datetime(6),
`shift_actual_end` datetime(6),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index `employee`(`employee`),
index `shift`(`shift`),
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:15,029 WARNING database DDL Query made to DB:
create table `tabCompensatory Leave Request` (
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),
`leave_type` varchar(140),
`leave_allocation` varchar(140),
`work_from_date` date,
`work_end_date` date,
`half_day` int(1) not null default 0,
`half_day_date` date,
`reason` 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:15,126 WARNING database DDL Query made to DB:
create table `tabDaily Work Summary` (
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',
`daily_work_summary_group` varchar(140),
`status` varchar(140) default 'Open',
`email_sent_to` longtext,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:15,303 WARNING database DDL Query made to DB:
create table `tabAttendance` (
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),
`working_hours` decimal(21,9) not null default 0,
`status` varchar(140) default 'Present',
`leave_type` varchar(140),
`leave_application` varchar(140),
`attendance_date` date,
`company` varchar(140),
`department` varchar(140),
`attendance_request` varchar(140),
`half_day_status` varchar(140),
`shift` varchar(140),
`in_time` datetime(6),
`out_time` datetime(6),
`late_entry` int(1) not null default 0,
`early_exit` int(1) not null default 0,
`amended_from` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index `employee`(`employee`),
index `status`(`status`),
index `attendance_date`(`attendance_date`),
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:15,396 WARNING database DDL Query made to DB:
create table `tabIdentification Document Type` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`identification_document_type` 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:15,474 WARNING database DDL Query made to DB:
create table `tabTraining Result` (
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',
`training_event` varchar(140) unique,
`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:15,584 WARNING database DDL Query made to DB:
create table `tabLeave 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',
`naming_series` varchar(140),
`employee` varchar(140),
`employee_name` varchar(140),
`leave_type` varchar(140),
`company` varchar(140),
`department` varchar(140),
`from_date` date,
`to_date` date,
`half_day` int(1) not null default 0,
`half_day_date` date,
`total_leave_days` decimal(21,9) not null default 0,
`description` text,
`leave_balance` decimal(21,9) not null default 0,
`leave_approver` varchar(140),
`leave_approver_name` varchar(140),
`follow_via_email` int(1) not null default 1,
`posting_date` date,
`status` varchar(140) default 'Open',
`salary_slip` varchar(140),
`color` varchar(140),
`letter_head` varchar(140),
`amended_from` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index `employee`(`employee`),
index `leave_type`(`leave_type`),
index `from_date`(`from_date`),
index `to_date`(`to_date`),
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:15,662 WARNING database DDL Query made to DB:
ALTER TABLE `tabLeave Application`
ADD INDEX IF NOT EXISTS `employee_from_date_to_date_index`(employee, from_date, to_date)
2025-06-23 23:53:15,714 WARNING database DDL Query made to DB:
create table `tabEmployee Boarding Activity` (
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',
`activity_name` varchar(140),
`user` varchar(140),
`role` varchar(140),
`begin_on` int(11) not null default 0,
`duration` int(11) not null default 0,
`task` varchar(140),
`task_weight` decimal(21,9) not null default 0,
`required_for_employee_creation` int(1) not null default 0,
`description` 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:15,796 WARNING database DDL Query made to DB:
create table `tabLeave Policy 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),
`company` varchar(140),
`leave_policy` varchar(140),
`carry_forward` int(1) not null default 0,
`assignment_based_on` varchar(140),
`leave_period` varchar(140),
`effective_from` date,
`effective_to` date,
`leaves_allocated` int(1) not null default 0,
`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:15,880 WARNING database DDL Query made to DB:
create table `tabDepartment Approver` (
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',
`approver` 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:15,951 WARNING database DDL Query made to DB:
create table `tabJob Offer Term Template` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`title` varchar(140) unique,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:16,035 WARNING database DDL Query made to DB:
create table `tabSkill` (
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_name` varchar(140) unique,
`description` text,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:16,144 WARNING database DDL Query made to DB:
create table `tabEmployee Performance Feedback` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`employee` varchar(140),
`employee_name` varchar(140),
`department` varchar(140),
`designation` varchar(140),
`company` varchar(140),
`reviewer` varchar(140),
`reviewer_name` varchar(140),
`reviewer_designation` varchar(140),
`user` varchar(140),
`added_on` datetime(6),
`appraisal_cycle` varchar(140),
`appraisal` varchar(140),
`total_score` decimal(21,9) not null default 0,
`feedback` longtext,
`amended_from` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:16,284 WARNING database DDL Query made to DB:
create table `tabAppraisal Cycle` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`cycle_name` varchar(140) unique,
`company` varchar(140),
`status` varchar(140) default 'Not Started',
`start_date` date,
`end_date` date,
`description` longtext,
`kra_evaluation_method` varchar(140) default 'Automated Based on Goal Progress',
`calculate_final_score_based_on_formula` int(1) not null default 0,
`final_score_formula` longtext,
`branch` varchar(140),
`department` varchar(140),
`designation` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:16,389 WARNING database DDL Query made to DB:
create table `tabShift Schedule 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),
`company` varchar(140),
`shift_schedule` varchar(140),
`shift_location` varchar(140),
`shift_status` varchar(140) default 'Active',
`enabled` int(1) not null default 1,
`create_shifts_after` 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:16,479 WARNING database DDL Query made to DB:
create table `tabEmployee Feedback Rating` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`criteria` varchar(140),
`per_weightage` decimal(21,9) not null default 0,
`rating` decimal(3,2),
parent varchar(140),
parentfield varchar(140),
parenttype varchar(140),
index parent(parent))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:16,558 WARNING database DDL Query made to DB:
create table `tabAppraisee` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`employee` varchar(140),
`employee_name` varchar(140),
`appraisal_template` varchar(140),
`department` varchar(140),
`designation` varchar(140),
`branch` varchar(140),
parent varchar(140),
parentfield varchar(140),
parenttype varchar(140),
index parent(parent))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:16,639 WARNING database DDL Query made to DB:
create table `tabTraining Feedback` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`employee` varchar(140),
`employee_name` varchar(140),
`department` varchar(140),
`course` varchar(140),
`training_event` varchar(140),
`event_name` varchar(140),
`trainer_name` varchar(140),
`feedback` 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:16,748 WARNING database DDL Query made to DB:
create table `tabJob Requisition` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`naming_series` varchar(140),
`designation` varchar(140),
`department` varchar(140),
`no_of_positions` int(11) not null default 0,
`expected_compensation` decimal(21,9) not null default 0,
`company` varchar(140),
`status` varchar(140),
`requested_by` varchar(140),
`requested_by_name` varchar(140),
`requested_by_dept` varchar(140),
`requested_by_designation` varchar(140),
`posting_date` date,
`completed_on` date,
`expected_by` date,
`time_to_fill` decimal(21,9),
`description` longtext,
`reason_for_requesting` text,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:16,858 WARNING database DDL Query made to DB:
create table `tabInterview` (
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',
`interview_round` varchar(140),
`job_applicant` varchar(140),
`job_opening` varchar(140),
`designation` varchar(140),
`resume_link` varchar(140),
`status` varchar(140) default 'Pending',
`scheduled_on` date,
`from_time` time(6),
`to_time` time(6),
`expected_average_rating` decimal(3,2),
`average_rating` decimal(3,2),
`interview_summary` text,
`reminded` int(1) not null default 0,
`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:16,958 WARNING database DDL Query made to DB:
create table `tabLeave 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',
`from_date` date,
`to_date` date,
`is_active` int(1) not null default 0,
`company` varchar(140),
`optional_holiday_list` 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:17,051 WARNING database DDL Query made to DB:
create table `tabAppraisal Goal` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`kra` text,
`per_weightage` decimal(21,9) not null default 0,
`score` decimal(21,9) not null default 0,
`score_earned` 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:17,144 WARNING database DDL Query made to DB:
create table `tabShift 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),
`company` varchar(140),
`department` varchar(140),
`shift_type` varchar(140),
`shift_location` varchar(140),
`status` varchar(140) default 'Active',
`start_date` date,
`end_date` date,
`shift_request` varchar(140),
`shift_schedule_assignment` varchar(140),
`amended_from` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index `employee`(`employee`),
index `shift_type`(`shift_type`),
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:17,262 WARNING database DDL Query made to DB:
create table `tabLeave Encashment` (
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),
`leave_period` varchar(140),
`leave_type` varchar(140),
`leave_allocation` varchar(140),
`leave_balance` decimal(21,9) not null default 0,
`actual_encashable_days` decimal(21,9) not null default 0,
`encashment_days` decimal(21,9) not null default 0,
`encashment_amount` decimal(21,9) not null default 0,
`pay_via_payment_entry` int(1) not null default 0,
`expense_account` varchar(140),
`payable_account` varchar(140),
`posting_date` date,
`currency` varchar(140),
`paid_amount` decimal(21,9) not null default 0,
`cost_center` varchar(140),
`encashment_date` date,
`additional_salary` varchar(140),
`amended_from` varchar(140),
`status` 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:17,362 WARNING database DDL Query made to DB:
create table `tabTraining Event Employee` (
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),
`status` varchar(140) default 'Open',
`attendance` varchar(140),
`is_mandatory` int(1) not null default 1,
parent varchar(140),
parentfield varchar(140),
parenttype varchar(140),
index parent(parent))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:17,441 WARNING database DDL Query made to DB:
create table `tabLeave Block 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',
`leave_block_list_name` varchar(140) unique,
`company` varchar(140),
`applies_to_all_departments` int(1) not null default 0,
`leave_type` 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:17,525 WARNING database DDL Query made to DB:
create table `tabEmployee Onboarding 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:17,601 WARNING database DDL Query made to DB:
create table `tabEmployee Property History` (
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',
`property` varchar(140),
`current` varchar(140),
`new` varchar(140),
`fieldname` 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:17,694 WARNING database DDL Query made to DB:
create table `tabShift Type` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`start_time` time(6),
`end_time` time(6),
`holiday_list` varchar(140),
`color` varchar(140) default 'Blue',
`enable_auto_attendance` int(1) not null default 0,
`determine_check_in_and_check_out` varchar(140),
`working_hours_calculation_based_on` varchar(140),
`begin_check_in_before_shift_start_time` int(11) not null default 60,
`allow_check_out_after_shift_end_time` int(11) not null default 60,
`mark_auto_attendance_on_holidays` int(1) not null default 0,
`working_hours_threshold_for_half_day` decimal(21,9) not null default 0,
`working_hours_threshold_for_absent` decimal(21,9) not null default 0,
`process_attendance_after` date,
`last_sync_of_checkin` datetime(6),
`auto_update_last_sync` int(1) not null default 0,
`enable_late_entry_marking` int(1) not null default 0,
`late_entry_grace_period` int(11) not null default 0,
`enable_early_exit_marking` int(1) not null default 0,
`early_exit_grace_period` 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:17,783 WARNING database DDL Query made to DB:
create table `tabVehicle Service` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`service_item` varchar(140),
`type` varchar(140),
`frequency` varchar(140),
`expense_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:17,886 WARNING database DDL Query made to DB:
create table `tabTravel Request` (
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',
`travel_type` varchar(140),
`travel_funding` varchar(140),
`travel_proof` text,
`purpose_of_travel` varchar(140),
`details_of_sponsor` varchar(140),
`employee` varchar(140),
`employee_name` varchar(140),
`cell_number` varchar(140),
`prefered_email` varchar(140),
`company` varchar(140),
`date_of_birth` date,
`personal_id_type` varchar(140),
`personal_id_number` varchar(140),
`passport_number` varchar(140),
`description` text,
`cost_center` varchar(140),
`name_of_organizer` varchar(140),
`address_of_organizer` varchar(140),
`other_details` 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:17,962 WARNING database DDL Query made to DB:
create table `tabJob Applicant 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),
`details` longtext,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:18,044 WARNING database DDL Query made to DB:
create table `tabExpense Claim Type` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`deferred_expense_account` int(1) not null default 0,
`expense_type` varchar(140) unique,
`description` text,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:18,145 WARNING database DDL Query made to DB:
create table `tabEmployee 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',
`job_applicant` varchar(140),
`job_offer` varchar(140),
`employee_onboarding_template` varchar(140),
`company` varchar(140),
`boarding_status` varchar(140) default 'Pending',
`project` varchar(140),
`employee` varchar(140),
`employee_name` varchar(140),
`department` varchar(140),
`designation` varchar(140),
`employee_grade` varchar(140),
`holiday_list` varchar(140),
`date_of_joining` date,
`boarding_begins_on` date,
`notify_users_by_email` int(1) not null default 0,
`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:18,314 WARNING database DDL Query made to DB:
create table `tabExpense Claim 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',
`expense_date` date,
`expense_type` varchar(140),
`default_account` varchar(140),
`description` longtext,
`amount` decimal(21,9) not null default 0,
`sanctioned_amount` decimal(21,9) not null default 0,
`cost_center` varchar(140),
`project` 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:18,397 WARNING database DDL Query made to DB:
create table `tabTravel Itinerary` (
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',
`travel_from` varchar(140),
`travel_to` varchar(140),
`mode_of_travel` varchar(140),
`meal_preference` varchar(140),
`travel_advance_required` int(1) not null default 0,
`advance_amount` varchar(140),
`departure_date` datetime(6),
`arrival_date` datetime(6),
`lodging_required` int(1) not null default 0,
`preferred_area_for_lodging` varchar(140),
`check_in_date` date,
`check_out_date` date,
`other_details` 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:18,474 WARNING database DDL Query made to DB:
create table `tabAppraisal KRA` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`kra` varchar(140),
`per_weightage` decimal(21,9) not null default 0,
`goal_completion` decimal(21,9) not null default 0,
`goal_score` decimal(21,9) not null default 0,
parent varchar(140),
parentfield varchar(140),
parenttype varchar(140),
index parent(parent))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:18,555 WARNING database DDL Query made to DB:
create table `tabStaffing Plan` (
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),
`department` varchar(140),
`from_date` date,
`to_date` date,
`total_estimated_budget` decimal(21,9) not null default 0,
`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:18,638 WARNING database DDL Query made to DB:
create table `tabAppointment Letter content` (
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),
`description` 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:18,725 WARNING database DDL Query made to DB:
create table `tabEmployee Separation` (
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),
`employee_grade` varchar(140),
`company` varchar(140),
`boarding_status` varchar(140) default 'Pending',
`resignation_letter_date` date,
`boarding_begins_on` date,
`project` varchar(140),
`employee_separation_template` varchar(140),
`notify_users_by_email` int(1) not null default 0,
`exit_interview` longtext,
`amended_from` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:18,831 WARNING database DDL Query made to DB:
create table `tabLeave Allocation` (
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),
`leave_type` varchar(140),
`from_date` date,
`to_date` date,
`new_leaves_allocated` decimal(21,9) not null default 0,
`carry_forward` int(1) not null default 0,
`unused_leaves` decimal(21,9) not null default 0,
`total_leaves_allocated` decimal(21,9) not null default 0,
`total_leaves_encashed` decimal(21,9) not null default 0,
`compensatory_request` varchar(140),
`leave_period` varchar(140),
`leave_policy` varchar(140),
`leave_policy_assignment` varchar(140),
`carry_forwarded_leaves_count` decimal(21,9) not null default 0,
`expired` int(1) not null default 0,
`amended_from` varchar(140),
`description` text,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index `employee`(`employee`),
index `employee_name`(`employee_name`),
index `leave_type`(`leave_type`),
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:18,914 WARNING database DDL Query made to DB:
create table `tabLeave Policy 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',
`leave_type` varchar(140),
`annual_allocation` 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:18,984 WARNING database DDL Query made to DB:
create table `tabAppraisal Template Goal` (
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',
`key_result_area` varchar(140),
`per_weightage` 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:19,087 WARNING database DDL Query made to DB:
create table `tabTraining Result Employee` (
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),
`hours` decimal(21,9) not null default 0,
`grade` varchar(140),
`comments` 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:19,308 WARNING database DDL Query made to DB:
create table `tabExit Interview` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`naming_series` varchar(140),
`employee` varchar(140),
`employee_name` varchar(140),
`email` varchar(140),
`company` varchar(140),
`status` varchar(140),
`date` date,
`department` varchar(140),
`designation` varchar(140),
`reports_to` varchar(140),
`date_of_joining` date,
`relieving_date` date,
`ref_doctype` varchar(140),
`questionnaire_email_sent` int(1) not null default 0,
`reference_document_name` varchar(140),
`interview_summary` longtext,
`employee_status` varchar(140),
`amended_from` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:19,393 WARNING database DDL Query made to DB:
create sequence if not exists pwa_notification_id_seq nocache nocycle
2025-06-23 23:53:19,408 WARNING database DDL Query made to DB:
create table `tabPWA Notification` (
name bigint 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',
`to_user` varchar(140),
`from_user` varchar(140),
`message` longtext,
`read` int(1) not null default 0,
`reference_document_type` varchar(140),
`reference_document_name` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index `to_user`(`to_user`),
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:19,494 WARNING database DDL Query made to DB:
create table `tabLeave Policy` (
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),
`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:19,614 WARNING database DDL Query made to DB:
create table `tabLeave Ledger 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',
`employee` varchar(140),
`employee_name` varchar(140),
`leave_type` varchar(140),
`transaction_type` varchar(140),
`transaction_name` varchar(140),
`company` varchar(140),
`leaves` decimal(21,9) not null default 0,
`from_date` date,
`to_date` date,
`holiday_list` varchar(140),
`is_carry_forward` int(1) not null default 0,
`is_expired` int(1) not null default 0,
`is_lwp` int(1) not null default 0,
`amended_from` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index `employee`(`employee`),
index `transaction_type`(`transaction_type`),
index `transaction_name`(`transaction_name`),
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:19,686 WARNING database DDL Query made to DB:
ALTER TABLE `tabLeave Ledger Entry`
ADD INDEX IF NOT EXISTS `transaction_type_transaction_name_index`(transaction_type, transaction_name)
2025-06-23 23:53:19,744 WARNING database DDL Query made to DB:
create table `tabJob Offer` (
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',
`job_applicant` varchar(140),
`applicant_name` varchar(140),
`applicant_email` varchar(140),
`status` varchar(140),
`offer_date` date,
`designation` varchar(140),
`company` varchar(140),
`job_offer_term_template` varchar(140),
`select_terms` varchar(140),
`terms` longtext,
`letter_head` varchar(140),
`select_print_heading` 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:19,822 WARNING database DDL Query made to DB:
create table `tabVehicle Service Item` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`service_item` varchar(140) unique,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:19,924 WARNING database DDL Query made to DB:
create table `tabFull and Final Statement` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`employee` varchar(140),
`employee_name` varchar(140),
`transaction_date` date,
`company` varchar(140),
`status` varchar(140) default 'Unpaid',
`amended_from` varchar(140),
`date_of_joining` date,
`relieving_date` date,
`designation` varchar(140),
`department` varchar(140),
`total_asset_recovery_cost` decimal(21,9) not null default 0,
`total_payable_amount` decimal(21,9) not null default 0,
`total_receivable_amount` decimal(21,9) not null default 0,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:20,016 WARNING database DDL Query made to DB:
create table `tabSkill Assessment` (
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),
`rating` decimal(3,2),
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:20,106 WARNING database DDL Query made to DB:
create table `tabInterview 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',
`interview` varchar(140),
`interview_round` varchar(140),
`job_applicant` varchar(140),
`interviewer` varchar(140),
`result` varchar(140),
`average_rating` decimal(3,2),
`feedback` 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:20,223 WARNING database DDL Query made to DB:
create table `tabJob Applicant` (
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',
`applicant_name` varchar(140),
`email_id` varchar(140),
`phone_number` varchar(140),
`country` varchar(140),
`job_title` varchar(140),
`designation` varchar(140),
`status` varchar(140),
`source` varchar(140),
`source_name` varchar(140),
`employee_referral` varchar(140),
`applicant_rating` decimal(3,2),
`notes` varchar(140),
`cover_letter` text,
`resume_attachment` text,
`resume_link` varchar(140),
`currency` varchar(140),
`lower_range` decimal(21,9) not null default 0,
`upper_range` decimal(21,9) not null default 0,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index `job_title`(`job_title`),
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:20,302 WARNING database DDL Query made to DB:
create table `tabJob Offer Term` (
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',
`offer_term` varchar(140),
`value` 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:20,378 WARNING database DDL Query made to DB:
create table `tabKRA` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`title` varchar(140) unique,
`description` text,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:20,461 WARNING database DDL Query made to DB:
create table `tabStaffing Plan 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',
`designation` varchar(140),
`vacancies` int(11) not null default 0,
`estimated_cost_per_position` decimal(21,9) not null default 0,
`total_estimated_cost` decimal(21,9) not null default 0,
`current_count` int(11) not null default 0,
`current_openings` int(11) not null default 0,
`number_of_positions` 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:20,550 WARNING database DDL Query made to DB:
create table `tabAttendance Request` (
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),
`from_date` date,
`to_date` date,
`half_day` int(1) not null default 0,
`half_day_date` date,
`include_holidays` int(1) not null default 0,
`shift` varchar(140),
`reason` varchar(140),
`explanation` 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:20,650 WARNING database DDL Query made to DB:
create table `tabAppointment Letter Template` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`template_name` varchar(140) unique,
`introduction` longtext,
`closing_notes` 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:20,768 WARNING database DDL Query made to DB:
create table `tabJob Opening` (
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',
`job_title` varchar(140),
`designation` varchar(140),
`status` varchar(140),
`posted_on` datetime(6),
`closes_on` date,
`closed_on` date,
`company` varchar(140),
`department` varchar(140),
`employment_type` varchar(140),
`location` varchar(140),
`staffing_plan` varchar(140),
`planned_vacancies` int(11) not null default 0,
`job_requisition` varchar(140),
`vacancies` int(11) not null default 0,
`publish` int(1) not null default 0,
`route` varchar(140) unique,
`publish_applications_received` int(1) not null default 1,
`job_application_route` varchar(140),
`description` longtext,
`currency` varchar(140),
`lower_range` decimal(21,9) not null default 0,
`upper_range` decimal(21,9) not null default 0,
`salary_per` varchar(140) default 'Month',
`publish_salary_range` int(1) not null default 0,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:20,851 WARNING database DDL Query made to DB:
create table `tabInterview Type` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`description` text,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:20,949 WARNING database DDL Query made to DB:
create table `tabDaily Work Summary Group` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`enabled` int(1) not null default 1,
`send_emails_at` varchar(140),
`holiday_list` varchar(140),
`subject` varchar(140) default 'What did you work on today?',
`message` longtext default '<p>Please share what did you do today. If you reply by midnight, your response will be recorded!</p>',
`_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:21,101 WARNING database DDL Query made to DB:
create table `tabInterviewer` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`user` varchar(140),
parent varchar(140),
parentfield varchar(140),
parenttype varchar(140),
index parent(parent))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:21,186 WARNING database DDL Query made to DB:
create table `tabFull and Final Outstanding Statement` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`component` varchar(140),
`reference_document_type` varchar(140),
`reference_document` varchar(140),
`account` varchar(140),
`paid_via_salary_slip` int(1) not null default 0,
`amount` decimal(21,9) not null default 0,
`status` varchar(140) default 'Unsettled',
`remark` text,
index `reference_document`(`reference_document`),
parent varchar(140),
parentfield varchar(140),
parenttype varchar(140),
index parent(parent))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:21,262 WARNING database DDL Query made to DB:
create table `tabExpected Skill Set` (
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),
`description` 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:21,338 WARNING database DDL Query made to DB:
create table `tabEmployment Type` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`employee_type_name` 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:21,436 WARNING database DDL Query made to DB:
create table `tabAppraisal 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',
`template_title` varchar(140) unique,
`description` text,
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:21,526 WARNING database DDL Query made to DB:
create table `tabEmployee Training` (
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',
`training` varchar(140),
`training_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:21,662 WARNING database DDL Query made to DB:
create table `tabExpense 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',
`naming_series` varchar(140),
`employee` varchar(140),
`employee_name` varchar(140),
`department` varchar(140),
`company` varchar(140),
`expense_approver` varchar(140),
`approval_status` varchar(140) default 'Draft',
`total_sanctioned_amount` decimal(21,9) not null default 0,
`total_taxes_and_charges` decimal(21,9) not null default 0,
`total_advance_amount` decimal(21,9) not null default 0,
`grand_total` decimal(21,9) not null default 0,
`total_claimed_amount` decimal(21,9) not null default 0,
`total_amount_reimbursed` decimal(21,9) not null default 0,
`posting_date` date,
`is_paid` int(1) not null default 0,
`mode_of_payment` varchar(140),
`payable_account` varchar(140),
`clearance_date` date,
`remark` text,
`project` varchar(140),
`cost_center` varchar(140),
`status` varchar(140) default 'Draft',
`task` varchar(140),
`amended_from` varchar(140),
`delivery_trip` varchar(140),
`vehicle_log` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index `employee`(`employee`),
index `approval_status`(`approval_status`),
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:21,794 WARNING database DDL Query made to DB:
create table `tabAppraisal` (
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),
`designation` varchar(140),
`employee_image` text,
`company` varchar(140),
`appraisal_cycle` varchar(140),
`start_date` date,
`end_date` date,
`final_score` decimal(21,9) not null default 0,
`appraisal_template` varchar(140),
`rate_goals_manually` int(1) not null default 0,
`goal_score_percentage` decimal(21,9) not null default 0,
`remarks` text,
`total_score` decimal(21,9) not null default 0,
`avg_feedback_score` decimal(21,9) not null default 0,
`self_score` decimal(21,9) not null default 0,
`reflections` longtext,
`amended_from` 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:21,921 WARNING database DDL Query made to DB:
create table `tabLeave Type` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`leave_type_name` varchar(140) unique,
`max_leaves_allowed` decimal(21,9) not null default 0,
`applicable_after` int(11) not null default 0,
`max_continuous_days_allowed` int(11) not null default 0,
`is_carry_forward` int(1) not null default 0,
`is_lwp` int(1) not null default 0,
`is_ppl` int(1) not null default 0,
`fraction_of_daily_salary_per_leave` decimal(21,9) not null default 0,
`is_optional_leave` int(1) not null default 0,
`allow_negative` int(1) not null default 0,
`allow_over_allocation` int(1) not null default 0,
`include_holiday` int(1) not null default 0,
`is_compensatory` int(1) not null default 0,
`maximum_carry_forwarded_leaves` decimal(21,9) not null default 0,
`expire_carry_forwarded_leaves_after_days` int(11) not null default 0,
`allow_encashment` int(1) not null default 0,
`max_encashable_leaves` int(11) not null default 0,
`non_encashable_leaves` int(11) not null default 0,
`earning_component` varchar(140),
`is_earned_leave` int(1) not null default 0,
`earned_leave_frequency` varchar(140),
`allocate_on_day` varchar(140) default 'Last Day',
`rounding` 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,009 WARNING database DDL Query made to DB:
create table `tabInterview 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',
`interviewer` 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,093 WARNING database DDL Query made to DB:
create table `tabEmployee Skill 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',
`employee` varchar(140) unique,
`employee_name` varchar(140),
`designation` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:22,179 WARNING database DDL Query made to DB:
create table `tabAppointment Letter` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`job_applicant` varchar(140),
`applicant_name` varchar(140),
`company` varchar(140),
`appointment_date` date,
`appointment_letter_template` varchar(140),
`introduction` longtext,
`closing_notes` 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:22,277 WARNING database DDL Query made to DB:
create table `tabFull and Final Asset` (
name varchar(140) primary key,
creation datetime(6),
modified datetime(6),
modified_by varchar(140),
owner varchar(140),
docstatus int(1) not null default '0',
idx int(8) not null default '0',
`reference` varchar(140),
`asset_name` varchar(140),
`date` datetime(6),
`actual_cost` decimal(21,9) not null default 0,
`cost` decimal(21,9) not null default 0,
`account` varchar(140),
`action` varchar(140) default 'Return',
`status` varchar(140),
`description` 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:22,382 WARNING database DDL Query made to DB:
create table `tabEmployee Referral` (
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',
`first_name` varchar(140),
`last_name` varchar(140),
`full_name` varchar(140),
`date` date,
`status` varchar(140),
`for_designation` varchar(140),
`email` varchar(140) unique,
`contact_no` varchar(140),
`resume_link` varchar(140),
`current_employer` varchar(140),
`current_job_title` varchar(140),
`resume` text,
`referrer` varchar(140),
`referrer_name` varchar(140),
`is_applicable_for_referral_bonus` int(1) not null default 1,
`referral_payment_status` varchar(140),
`department` varchar(140),
`qualification_reason` longtext,
`work_references` longtext,
`amended_from` varchar(140),
`_user_tags` text,
`_comments` text,
`_assign` text,
`_liked_by` text,
index modified(modified))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:22,480 WARNING database DDL Query made to DB:
create table `tabPurpose of Travel` (
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',
`purpose_of_travel` 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,558 WARNING database DDL Query made to DB:
create table `tabLeave Block List Allow` (
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',
`allow_user` varchar(140),
parent varchar(140),
parentfield varchar(140),
parenttype varchar(140),
index parent(parent))
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHARACTER SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
2025-06-23 23:53:22,635 WARNING database DDL Query made to DB:
create table `tabExpense Claim 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),
`default_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: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
Reference in a new issue View git blame Copy permalink