1983 lines
64 KiB
Text
1983 lines
64 KiB
Text
2025-05-20 13:16:24,653 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-05-20 13:16:24,743 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-05-20 13:16:24,854 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-05-20 13:16:24,955 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-05-20 13:16:25,043 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-05-20 13:16:25,167 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-05-20 13:16:25,253 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-05-20 13:16:25,338 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-05-20 13:16:25,435 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-05-20 13:16:25,530 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-05-20 13:16:25,643 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-05-20 13:16:25,775 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-05-20 13:16:25,869 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-05-20 13:16:25,972 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-05-20 13:16:26,150 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-05-20 13:16:26,244 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-05-20 13:16:26,325 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-05-20 13:16:26,408 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-05-20 13:16:26,508 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-05-20 13:16:26,604 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-05-20 13:16:26,744 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-05-20 13:16:26,960 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-05-20 13:16:27,101 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-05-20 13:16:27,198 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-05-20 13:16:27,293 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-05-20 13:16:27,402 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-05-20 13:16:27,504 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-05-20 13:16:27,619 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-05-20 13:16:27,721 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-05-20 13:16:27,808 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-05-20 13:16:27,887 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-05-20 13:16:27,963 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-05-20 13:16:28,070 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-05-20 13:16:28,184 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-05-20 13:16:28,296 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-05-20 13:16:28,386 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-05-20 13:16:29,369 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-05-20 13:16:29,587 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-05-20 13:16:29,700 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-05-20 13:16:29,760 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-05-20 13:16:29,867 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-05-20 13:16:29,971 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-05-20 13:16:30,072 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-05-20 13:16:30,174 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-05-20 13:16:30,291 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-05-20 13:16:30,417 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-05-20 13:16:30,519 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-05-20 13:16:30,637 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-05-20 13:16:30,738 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-05-20 13:16:30,851 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-05-20 13:16:30,953 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-05-20 13:16:31,063 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-05-20 13:16:31,159 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-05-20 13:16:31,274 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-05-20 13:16:31,376 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-05-20 13:16:31,506 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-05-20 13:16:31,614 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-05-20 13:16:31,785 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-05-20 13:16:31,957 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-05-20 13:16:32,046 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-05-20 13:16:32,141 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-05-20 13:16:32,219 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-05-20 13:16:32,301 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-05-20 13:16:32,403 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-05-20 13:16:32,515 WARNING database DDL Query made to DB:
|
|
create table `tabSalary Component Account` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company` varchar(140),
|
|
`account` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:16:32,597 WARNING database DDL Query made to DB:
|
|
create table `tabGratuity Rule Slab` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`from_year` int(11) not null default 0,
|
|
`to_year` int(11) not null default 0,
|
|
`fraction_of_applicable_earnings` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:16:32,680 WARNING database DDL Query made to DB:
|
|
create table `tabSalary Slip Timesheet` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`time_sheet` varchar(140),
|
|
`working_hours` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:16:32,793 WARNING database DDL Query made to DB:
|
|
create table `tabAdditional Salary` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`naming_series` varchar(140),
|
|
`employee` varchar(140),
|
|
`employee_name` varchar(140),
|
|
`department` varchar(140),
|
|
`company` varchar(140),
|
|
`is_recurring` int(1) not null default 0,
|
|
`disabled` int(1) not null default 0,
|
|
`from_date` date,
|
|
`to_date` date,
|
|
`payroll_date` date,
|
|
`amended_from` varchar(140),
|
|
`salary_component` varchar(140),
|
|
`type` varchar(140),
|
|
`currency` varchar(140),
|
|
`amount` decimal(21,9) not null default 0,
|
|
`deduct_full_tax_on_selected_payroll_date` int(1) not null default 0,
|
|
`overwrite_salary_structure_amount` int(1) not null default 1,
|
|
`ref_doctype` varchar(140),
|
|
`ref_docname` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `employee`(`employee`),
|
|
index `payroll_date`(`payroll_date`),
|
|
index `salary_component`(`salary_component`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:16:32,905 WARNING database DDL Query made to DB:
|
|
create table `tabIncome Tax Slab` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`disabled` int(1) not null default 0,
|
|
`effective_from` date,
|
|
`company` varchar(140),
|
|
`currency` varchar(140),
|
|
`standard_tax_exemption_amount` decimal(21,9) not null default 0,
|
|
`allow_tax_exemption` int(1) not null default 0,
|
|
`amended_from` varchar(140),
|
|
`tax_relief_limit` decimal(21,9) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:16:33,026 WARNING database DDL Query made to DB:
|
|
create table `tabEmployee Tax Exemption Proof Submission` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`employee` varchar(140),
|
|
`employee_name` varchar(140),
|
|
`department` varchar(140),
|
|
`currency` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`submission_date` date,
|
|
`payroll_period` varchar(140),
|
|
`company` varchar(140),
|
|
`total_actual_amount` decimal(21,9) not null default 0,
|
|
`exemption_amount` decimal(21,9) not null default 0,
|
|
`attachments` text,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:16:33,151 WARNING database DDL Query made to DB:
|
|
create table `tabEmployee Other Income` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`employee` varchar(140),
|
|
`employee_name` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`company` varchar(140),
|
|
`payroll_period` varchar(140),
|
|
`source` varchar(140),
|
|
`amount` decimal(21,9) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `employee`(`employee`),
|
|
index `company`(`company`),
|
|
index `payroll_period`(`payroll_period`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:16:33,299 WARNING database DDL Query made to DB:
|
|
create table `tabPayroll Entry` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`posting_date` date,
|
|
`company` varchar(140),
|
|
`currency` varchar(140),
|
|
`exchange_rate` decimal(21,9) not null default 0,
|
|
`payroll_payable_account` varchar(140),
|
|
`status` varchar(140),
|
|
`salary_slip_based_on_timesheet` int(1) not null default 0,
|
|
`payroll_frequency` varchar(140),
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`deduct_tax_for_unclaimed_employee_benefits` int(1) not null default 0,
|
|
`deduct_tax_for_unsubmitted_tax_exemption_proof` int(1) not null default 0,
|
|
`branch` varchar(140),
|
|
`department` varchar(140),
|
|
`designation` varchar(140),
|
|
`grade` varchar(140),
|
|
`number_of_employees` int(11) not null default 0,
|
|
`validate_attendance` int(1) not null default 0,
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`payment_account` varchar(140),
|
|
`bank_account` varchar(140),
|
|
`salary_slips_created` int(1) not null default 0,
|
|
`salary_slips_submitted` int(1) not null default 0,
|
|
`error_message` text,
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:16:33,406 WARNING database DDL Query made to DB:
|
|
create table `tabEmployee Incentive` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`employee` varchar(140),
|
|
`employee_name` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`company` varchar(140),
|
|
`department` varchar(140),
|
|
`salary_component` varchar(140),
|
|
`currency` varchar(140),
|
|
`payroll_date` date,
|
|
`incentive_amount` decimal(21,9) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:16:35,084 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabEmployee` ADD COLUMN `employment_type` varchar(140), ADD COLUMN `grade` varchar(140), ADD COLUMN `job_applicant` varchar(140), ADD COLUMN `default_shift` varchar(140), ADD COLUMN `expense_approver` varchar(140), ADD COLUMN `leave_approver` varchar(140), ADD COLUMN `shift_request_approver` varchar(140), ADD COLUMN `payroll_cost_center` varchar(140), ADD COLUMN `health_insurance_provider` varchar(140), ADD COLUMN `health_insurance_no` varchar(140)
|
|
2025-05-20 13:16:35,099 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0
|
|
2025-05-20 13:16:35,148 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTimesheet` ADD COLUMN `salary_slip` varchar(140)
|
|
2025-05-20 13:16:35,162 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTimesheet` MODIFY `base_total_billed_amount` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0, MODIFY `total_billable_hours` decimal(21,9) not null default 0, MODIFY `base_total_costing_amount` decimal(21,9) not null default 0, MODIFY `base_total_billable_amount` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `per_billed` decimal(21,9) not null default 0, MODIFY `total_billed_hours` decimal(21,9) not null default 0
|
|
2025-05-20 13:16:35,203 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTerms and Conditions` ADD COLUMN `hr` int(1) not null default 1
|
|
2025-05-20 13:16:35,242 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabDesignation` ADD COLUMN `appraisal_template` varchar(140)
|
|
2025-05-20 13:16:35,287 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabDepartment` ADD COLUMN `payroll_cost_center` varchar(140), ADD COLUMN `leave_block_list` varchar(140)
|
|
2025-05-20 13:16:35,337 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTask` ADD COLUMN `total_expense_claim` decimal(21,9) not null default 0
|
|
2025-05-20 13:16:35,352 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTask` MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `progress` decimal(21,9) not null default 0, MODIFY `total_billing_amount` decimal(21,9) not null default 0, MODIFY `task_weight` decimal(21,9) not null default 0
|
|
2025-05-20 13:16:35,403 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabProject` ADD COLUMN `total_expense_claim` decimal(21,9) not null default 0
|
|
2025-05-20 13:16:35,417 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabProject` MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `gross_margin` decimal(21,9) not null default 0, MODIFY `estimated_costing` decimal(21,9) not null default 0, MODIFY `per_gross_margin` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0, MODIFY `total_sales_amount` decimal(21,9) not null default 0, MODIFY `total_billable_amount` decimal(21,9) not null default 0, MODIFY `total_consumed_material_cost` decimal(21,9) not null default 0, MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `percent_complete` decimal(21,9) not null default 0, MODIFY `total_purchase_cost` decimal(21,9) not null default 0
|
|
2025-05-20 13:16:35,480 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabCompany` ADD COLUMN `default_expense_claim_payable_account` varchar(140), ADD COLUMN `default_employee_advance_account` varchar(140), ADD COLUMN `default_payroll_payable_account` varchar(140)
|
|
2025-05-20 13:16:35,494 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabCompany` MODIFY `monthly_sales_target` decimal(21,9) not null default 0, MODIFY `credit_limit` decimal(21,9) not null default 0, MODIFY `total_monthly_sales` decimal(21,9) not null default 0
|
|
2025-05-20 13:23:19,732 WARNING database DDL Query made to DB:
|
|
DROP DATABASE IF EXISTS `_dd79dbfb116c2426`
|
|
2025-05-20 13:23:19,733 WARNING database DDL Query made to DB:
|
|
DROP USER IF EXISTS '_dd79dbfb116c2426'@'%'
|
|
2025-05-20 13:23:19,735 WARNING database DDL Query made to DB:
|
|
DROP USER IF EXISTS '_dd79dbfb116c2426'@'localhost'
|