2025-05-20 13:10:25,177 WARNING database DDL Query made to DB: create table `tabDelivery Note 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', `barcode` varchar(140), `has_item_scanned` int(1) not null default 0, `item_code` varchar(140), `item_name` varchar(140), `customer_item_code` varchar(140), `description` longtext, `brand` varchar(140), `item_group` varchar(140), `image` text, `qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), `uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `stock_qty` decimal(21,9) not null default 0, `returned_qty` decimal(21,9) not null default 0, `price_list_rate` decimal(21,9) not null default 0, `base_price_list_rate` decimal(21,9) not null default 0, `margin_type` varchar(140), `margin_rate_or_amount` decimal(21,9) not null default 0, `rate_with_margin` decimal(21,9) not null default 0, `discount_percentage` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `distributed_discount_amount` decimal(21,9) not null default 0, `base_rate_with_margin` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `base_rate` decimal(21,9) not null default 0, `base_amount` decimal(21,9) not null default 0, `pricing_rules` text, `stock_uom_rate` decimal(21,9) not null default 0, `is_free_item` int(1) not null default 0, `grant_commission` int(1) not null default 0, `net_rate` decimal(21,9) not null default 0, `net_amount` decimal(21,9) not null default 0, `item_tax_template` varchar(140), `base_net_rate` decimal(21,9) not null default 0, `base_net_amount` decimal(21,9) not null default 0, `billed_amt` decimal(21,9) not null default 0, `incoming_rate` decimal(21,9) not null default 0, `weight_per_unit` decimal(21,9) not null default 0, `total_weight` decimal(21,9) not null default 0, `weight_uom` varchar(140), `warehouse` varchar(140), `target_warehouse` varchar(140), `quality_inspection` varchar(140), `allow_zero_valuation_rate` int(1) not null default 0, `against_sales_order` varchar(140), `so_detail` varchar(140), `against_sales_invoice` varchar(140), `si_detail` varchar(140), `dn_detail` varchar(140), `pick_list_item` varchar(140), `serial_and_batch_bundle` varchar(140), `use_serial_batch_fields` int(1) not null default 0, `serial_no` text, `batch_no` varchar(140), `actual_qty` decimal(21,9) not null default 0, `actual_batch_qty` decimal(21,9) not null default 0, `company_total_stock` decimal(21,9) not null default 0, `installed_qty` decimal(21,9) not null default 0, `packed_qty` decimal(21,9) not null default 0, `received_qty` decimal(21,9) not null default 0, `expense_account` varchar(140), `item_tax_rate` text, `material_request` varchar(140), `purchase_order` varchar(140), `purchase_order_item` varchar(140), `material_request_item` varchar(140), `cost_center` varchar(140), `project` varchar(140), `page_break` int(1) not null default 0, index `item_code`(`item_code`), index `against_sales_order`(`against_sales_order`), index `so_detail`(`so_detail`), index `against_sales_invoice`(`against_sales_invoice`), index `si_detail`(`si_detail`), index `dn_detail`(`dn_detail`), index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `batch_no`(`batch_no`), index `purchase_order`(`purchase_order`), 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:10:25,274 WARNING database DDL Query made to DB: create table `tabBatch` ( name varchar(140) primary key, creation datetime(6), 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, `use_batchwise_valuation` int(1) not null default 0, `batch_id` varchar(140) unique, `item` varchar(140), `item_name` varchar(140), `image` text, `parent_batch` varchar(140), `manufacturing_date` date, `batch_qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), `expiry_date` date, `supplier` varchar(140), `reference_doctype` varchar(140), `reference_name` varchar(140), `description` text, `qty_to_produce` decimal(21,9) not null default 0, `produced_qty` 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:10:25,352 WARNING database DDL Query made to DB: create table `tabQuality Inspection 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', `quality_inspection_template_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:10:25,443 WARNING database DDL Query made to DB: create table `tabStock Entry 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', `purpose` varchar(140) default 'Material Issue', `add_to_transit` int(1) not null default 0, `is_standard` 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:10:25,703 WARNING database DDL Query made to DB: create table `tabDelivery Note` ( name varchar(140) primary key, creation datetime(6), 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) default '{customer_name}', `naming_series` varchar(140), `customer` varchar(140), `tax_id` varchar(140), `customer_name` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `company` varchar(140), `amended_from` varchar(140), `is_return` int(1) not null default 0, `issue_credit_note` int(1) not null default 0, `return_against` varchar(140), `cost_center` varchar(140), `project` varchar(140), `currency` varchar(140), `conversion_rate` decimal(21,9) not null default 0, `selling_price_list` varchar(140), `price_list_currency` varchar(140), `plc_conversion_rate` decimal(21,9) not null default 0, `ignore_pricing_rule` int(1) not null default 0, `scan_barcode` varchar(140), `pick_list` varchar(140), `set_warehouse` varchar(140), `set_target_warehouse` varchar(140), `total_qty` decimal(21,9) not null default 0, `total_net_weight` decimal(21,9) not null default 0, `base_total` decimal(21,9) not null default 0, `base_net_total` decimal(21,9) not null default 0, `total` decimal(21,9) not null default 0, `net_total` decimal(21,9) not null default 0, `tax_category` varchar(140), `taxes_and_charges` varchar(140), `shipping_rule` varchar(140), `incoterm` varchar(140), `named_place` varchar(140), `base_total_taxes_and_charges` decimal(21,9) not null default 0, `total_taxes_and_charges` decimal(21,9) not null default 0, `base_grand_total` decimal(21,9) not null default 0, `base_rounding_adjustment` decimal(21,9) not null default 0, `base_rounded_total` decimal(21,9) not null default 0, `base_in_words` varchar(240), `grand_total` decimal(21,9) not null default 0, `rounding_adjustment` decimal(21,9) not null default 0, `rounded_total` decimal(21,9) not null default 0, `in_words` varchar(240), `disable_rounded_total` int(1) not null default 0, `apply_discount_on` varchar(140) default 'Grand Total', `base_discount_amount` decimal(21,9) not null default 0, `additional_discount_percentage` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `other_charges_calculation` longtext, `customer_address` varchar(140), `address_display` text, `contact_person` varchar(140), `contact_display` text, `contact_mobile` text, `contact_email` varchar(140), `shipping_address_name` varchar(140), `shipping_address` text, `dispatch_address_name` varchar(140), `dispatch_address` text, `company_address` varchar(140), `company_address_display` text, `company_contact_person` varchar(140), `tc_name` varchar(140), `terms` longtext, `per_billed` decimal(21,9) not null default 0, `status` varchar(140) default 'Draft', `per_installed` decimal(21,9) not null default 0, `installation_status` varchar(140), `per_returned` decimal(21,9) not null default 0, `transporter` varchar(140), `driver` varchar(140), `lr_no` varchar(140), `vehicle_no` varchar(140), `transporter_name` varchar(140), `driver_name` varchar(140), `lr_date` date, `po_no` text, `po_date` date, `sales_partner` varchar(140), `amount_eligible_for_commission` decimal(21,9) not null default 0, `commission_rate` decimal(21,9) not null default 0, `total_commission` decimal(21,9) not null default 0, `auto_repeat` varchar(140), `letter_head` varchar(140), `print_without_amount` int(1) not null default 0, `group_same_items` int(1) not null default 0, `select_print_heading` varchar(140), `language` varchar(140), `is_internal_customer` int(1) not null default 0, `represents_company` varchar(140), `inter_company_reference` varchar(140), `customer_group` varchar(140), `territory` varchar(140), `source` varchar(140), `campaign` varchar(140), `excise_page` varchar(140), `instructions` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index `customer`(`customer`), index `posting_date`(`posting_date`), index `return_against`(`return_against`), index `pick_list`(`pick_list`), index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:25,820 WARNING database DDL Query made to DB: create table `tabSerial and Batch 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', `serial_no` varchar(140), `batch_no` varchar(140), `qty` decimal(21,9) not null default 1.0, `warehouse` varchar(140), `delivered_qty` decimal(21,9) not null default 0, `incoming_rate` decimal(21,9) not null default 0, `outgoing_rate` decimal(21,9) not null default 0, `stock_value_difference` decimal(21,9) not null default 0, `is_outward` int(1) not null default 0, `stock_queue` text, index `serial_no`(`serial_no`), index `batch_no`(`batch_no`), index `warehouse`(`warehouse`), 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:10:25,904 WARNING database DDL Query made to DB: create table `tabItem Tax` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_tax_template` varchar(140), `tax_category` varchar(140), `valid_from` date, `minimum_net_rate` decimal(21,9) not null default 0, `maximum_net_rate` 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:10:26,030 WARNING database DDL Query made to DB: create table `tabShipment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `pickup_from_type` varchar(140) default 'Company', `pickup_company` varchar(140), `pickup_customer` varchar(140), `pickup_supplier` varchar(140), `pickup` varchar(140), `pickup_address_name` varchar(140), `pickup_address` text, `pickup_contact_person` varchar(140), `pickup_contact_name` varchar(140), `pickup_contact_email` varchar(140), `pickup_contact` text, `delivery_to_type` varchar(140) default 'Customer', `delivery_company` varchar(140), `delivery_customer` varchar(140), `delivery_supplier` varchar(140), `delivery_to` varchar(140), `delivery_address_name` varchar(140), `delivery_address` text, `delivery_contact_name` varchar(140), `delivery_contact_email` varchar(140), `delivery_contact` text, `parcel_template` varchar(140), `total_weight` decimal(21,9) not null default 0, `pallets` varchar(140) default 'No', `value_of_goods` decimal(21,9) not null default 0, `pickup_date` date, `pickup_from` time(6) default '09:00', `pickup_to` time(6) default '17:00', `shipment_type` varchar(140) default 'Goods', `pickup_type` varchar(140) default 'Pickup', `incoterm` varchar(140), `description_of_content` text, `service_provider` varchar(140), `shipment_id` varchar(140), `shipment_amount` decimal(21,9) not null default 0, `status` varchar(140), `tracking_url` text, `carrier` varchar(140), `carrier_service` varchar(140), `awb_number` varchar(140), `tracking_status` varchar(140), `tracking_status_info` 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:10:26,266 WARNING database DDL Query made to DB: create table `tabPurchase Receipt` ( name varchar(140) primary key, creation datetime(6), 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) default '{supplier_name}', `naming_series` varchar(140), `supplier` varchar(140), `supplier_name` varchar(140), `supplier_delivery_note` varchar(140), `subcontracting_receipt` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `company` varchar(140), `apply_putaway_rule` int(1) not null default 0, `is_return` int(1) not null default 0, `return_against` varchar(140), `cost_center` varchar(140), `project` varchar(140), `currency` varchar(140), `conversion_rate` decimal(21,9) not null default 0, `buying_price_list` varchar(140), `price_list_currency` varchar(140), `plc_conversion_rate` decimal(21,9) not null default 0, `ignore_pricing_rule` int(1) not null default 0, `scan_barcode` varchar(140), `set_warehouse` varchar(140), `set_from_warehouse` varchar(140), `rejected_warehouse` varchar(140), `is_subcontracted` int(1) not null default 0, `supplier_warehouse` varchar(140), `total_qty` decimal(21,9) not null default 0, `total_net_weight` decimal(21,9) not null default 0, `base_total` decimal(21,9) not null default 0, `base_net_total` decimal(21,9) not null default 0, `total` decimal(21,9) not null default 0, `net_total` decimal(21,9) not null default 0, `tax_withholding_net_total` decimal(21,9) not null default 0, `base_tax_withholding_net_total` decimal(21,9) not null default 0, `tax_category` varchar(140), `taxes_and_charges` varchar(140), `shipping_rule` varchar(140), `incoterm` varchar(140), `named_place` varchar(140), `base_taxes_and_charges_added` decimal(21,9) not null default 0, `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, `base_total_taxes_and_charges` decimal(21,9) not null default 0, `taxes_and_charges_added` decimal(21,9) not null default 0, `taxes_and_charges_deducted` decimal(21,9) not null default 0, `total_taxes_and_charges` decimal(21,9) not null default 0, `base_grand_total` decimal(21,9) not null default 0, `base_rounding_adjustment` decimal(21,9) not null default 0, `base_rounded_total` decimal(21,9) not null default 0, `base_in_words` varchar(240), `grand_total` decimal(21,9) not null default 0, `rounding_adjustment` decimal(21,9) not null default 0, `rounded_total` decimal(21,9) not null default 0, `in_words` varchar(240), `disable_rounded_total` int(1) not null default 0, `apply_discount_on` varchar(140) default 'Grand Total', `base_discount_amount` decimal(21,9) not null default 0, `additional_discount_percentage` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `other_charges_calculation` longtext, `supplier_address` varchar(140), `address_display` text, `contact_person` varchar(140), `contact_display` text, `contact_mobile` text, `contact_email` text, `dispatch_address` varchar(140), `dispatch_address_display` longtext, `shipping_address` varchar(140), `shipping_address_display` text, `billing_address` varchar(140), `billing_address_display` text, `tc_name` varchar(140), `terms` longtext, `status` varchar(140) default 'Draft', `per_billed` decimal(21,9) not null default 0, `per_returned` decimal(21,9) not null default 0, `auto_repeat` varchar(140), `letter_head` varchar(140), `group_same_items` int(1) not null default 0, `select_print_heading` varchar(140), `language` varchar(140), `transporter_name` varchar(140), `lr_no` varchar(140), `lr_date` date, `instructions` text, `is_internal_supplier` int(1) not null default 0, `represents_company` varchar(140), `inter_company_reference` varchar(140), `remarks` text, `range` varchar(140), `amended_from` varchar(140), `is_old_subcontracting_flow` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `supplier`(`supplier`), index `subcontracting_receipt`(`subcontracting_receipt`), index `posting_date`(`posting_date`), index `return_against`(`return_against`), index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:26,367 WARNING database DDL Query made to DB: create table `tabItem Website Specification` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `label` varchar(140), `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-05-20 13:10:26,514 WARNING database DDL Query made to DB: create table `tabStock Entry 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', `barcode` varchar(140), `has_item_scanned` int(1) not null default 0, `s_warehouse` varchar(140), `t_warehouse` varchar(140), `item_code` varchar(140), `item_name` varchar(140), `is_finished_item` int(1) not null default 0, `is_scrap_item` int(1) not null default 0, `quality_inspection` varchar(140), `subcontracted_item` varchar(140), `description` longtext, `item_group` varchar(140), `image` text, `qty` decimal(21,9) not null default 0, `transfer_qty` decimal(21,9) not null default 0, `retain_sample` int(1) not null default 0, `uom` varchar(140), `stock_uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `sample_quantity` int(11) not null default 0, `basic_rate` decimal(21,9) not null default 0, `additional_cost` decimal(21,9) not null default 0, `valuation_rate` decimal(21,9) not null default 0, `allow_zero_valuation_rate` int(1) not null default 0, `set_basic_rate_manually` int(1) not null default 0, `basic_amount` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `use_serial_batch_fields` int(1) not null default 0, `serial_and_batch_bundle` varchar(140), `serial_no` text, `batch_no` varchar(140), `expense_account` varchar(140), `cost_center` varchar(140), `project` varchar(140), `actual_qty` decimal(21,9) not null default 0, `transferred_qty` decimal(21,9) not null default 0, `bom_no` varchar(140), `allow_alternative_item` int(1) not null default 0, `material_request` varchar(140), `material_request_item` varchar(140), `original_item` varchar(140), `against_stock_entry` varchar(140), `ste_detail` varchar(140), `po_detail` varchar(140), `sco_rm_detail` varchar(140), `putaway_rule` varchar(140), `reference_purchase_receipt` varchar(140), `job_card_item` varchar(140), index `item_code`(`item_code`), index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `actual_qty`(`actual_qty`), index `material_request`(`material_request`), index `job_card_item`(`job_card_item`), 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:10:26,592 WARNING database DDL Query made to DB: create table `tabShipment Parcel` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `length` int(11) not null default 0, `width` int(11) not null default 0, `height` int(11) not null default 0, `weight` decimal(21,9) not null default 0, `count` int(11) 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-05-20 13:10:26,671 WARNING database DDL Query made to DB: create table `tabItem Quality Inspection Parameter` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `specification` varchar(140), `parameter_group` varchar(140), `value` varchar(140), `numeric` int(1) not null default 1, `min_value` decimal(21,9) not null default 0, `max_value` decimal(21,9) not null default 0, `formula_based_criteria` int(1) not null default 0, `acceptance_formula` 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:10:26,740 WARNING database DDL Query made to DB: create table `tabItem Supplier` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `supplier` varchar(140), `supplier_part_no` 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:10:26,818 WARNING database DDL Query made to DB: create table `tabItem Customer 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', `customer_name` varchar(140), `customer_group` varchar(140), `ref_code` varchar(140), index `customer_name`(`customer_name`), index `ref_code`(`ref_code`), 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:10:26,979 WARNING database DDL Query made to DB: create table `tabStock 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', `naming_series` varchar(140), `stock_entry_type` varchar(140), `outgoing_stock_entry` varchar(140), `purpose` varchar(140), `add_to_transit` int(1) not null default 0, `work_order` varchar(140), `purchase_order` varchar(140), `subcontracting_order` varchar(140), `delivery_note_no` varchar(140), `sales_invoice_no` varchar(140), `pick_list` varchar(140), `purchase_receipt_no` varchar(140), `asset_repair` varchar(140), `company` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `inspection_required` int(1) not null default 0, `apply_putaway_rule` int(1) not null default 0, `from_bom` int(1) not null default 0, `use_multi_level_bom` int(1) not null default 1, `bom_no` varchar(140), `fg_completed_qty` decimal(21,9) not null default 0, `process_loss_percentage` decimal(21,9) not null default 0, `process_loss_qty` decimal(21,9) not null default 0, `from_warehouse` varchar(140), `source_warehouse_address` varchar(140), `source_address_display` text, `to_warehouse` varchar(140), `target_warehouse_address` varchar(140), `target_address_display` text, `scan_barcode` varchar(140), `total_outgoing_value` decimal(21,9) not null default 0, `total_incoming_value` decimal(21,9) not null default 0, `value_difference` decimal(21,9) not null default 0, `total_additional_costs` decimal(21,9) not null default 0, `supplier` varchar(140), `supplier_name` varchar(140), `supplier_address` varchar(140), `address_display` text, `project` varchar(140), `select_print_heading` varchar(140), `letter_head` varchar(140), `is_opening` varchar(140), `remarks` text, `per_transferred` decimal(21,9) not null default 0, `total_amount` decimal(21,9) not null default 0, `job_card` varchar(140), `amended_from` varchar(140), `credit_note` varchar(140), `is_return` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `stock_entry_type`(`stock_entry_type`), index `purpose`(`purpose`), index `work_order`(`work_order`), index `delivery_note_no`(`delivery_note_no`), index `pick_list`(`pick_list`), index `purchase_receipt_no`(`purchase_receipt_no`), index `posting_date`(`posting_date`), index `job_card`(`job_card`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:27,135 WARNING database DDL Query made to DB: create table `tabPrice 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', `enabled` int(1) not null default 1, `price_list_name` varchar(140) unique, `currency` varchar(140), `buying` int(1) not null default 0, `selling` int(1) not null default 0, `price_not_uom_dependent` 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:10:27,238 WARNING database DDL Query made to DB: create table `tabItem Variant Attribute` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `variant_of` varchar(140), `attribute` varchar(140), `attribute_value` varchar(140), `numeric_values` int(1) not null default 0, `disabled` int(1) not null default 0, `from_range` decimal(21,9) not null default 0, `increment` decimal(21,9) not null default 0, `to_range` decimal(21,9) not null default 0, index `variant_of`(`variant_of`), index `attribute`(`attribute`), 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:10:27,318 WARNING database DDL Query made to DB: create table `tabItem Attribute` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `attribute_name` varchar(140) unique, `numeric_values` int(1) not null default 0, `disabled` int(1) not null default 0, `from_range` decimal(21,9) not null default 0, `increment` decimal(21,9) not null default 0, `to_range` 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:10:27,446 WARNING database DDL Query made to DB: create table `tabStock Reservation 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', `item_code` varchar(140), `warehouse` varchar(140), `has_serial_no` int(1) not null default 0, `has_batch_no` int(1) not null default 0, `voucher_type` varchar(140), `voucher_no` varchar(140), `voucher_detail_no` varchar(140), `from_voucher_type` varchar(140), `from_voucher_no` varchar(140), `from_voucher_detail_no` varchar(140), `stock_uom` varchar(140), `available_qty` decimal(21,9) not null default 0, `voucher_qty` decimal(21,9) not null default 0, `reserved_qty` decimal(21,9) not null default 0, `delivered_qty` decimal(21,9) not null default 0, `reservation_based_on` varchar(140) default 'Qty', `company` varchar(140), `project` varchar(140), `status` varchar(140) default 'Draft', `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `item_code`(`item_code`), index `warehouse`(`warehouse`), index `voucher_no`(`voucher_no`), index `voucher_detail_no`(`voucher_detail_no`), index `from_voucher_no`(`from_voucher_no`), index `company`(`company`), index `project`(`project`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:27,566 WARNING database DDL Query made to DB: create table `tabItem Default` ( name varchar(140) primary key, creation datetime(6), 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_warehouse` varchar(140), `default_price_list` varchar(140), `default_discount_account` varchar(140), `buying_cost_center` varchar(140), `default_supplier` varchar(140), `expense_account` varchar(140), `default_provisional_account` varchar(140), `selling_cost_center` varchar(140), `income_account` varchar(140), `deferred_expense_account` varchar(140), `deferred_revenue_account` varchar(140), index `default_warehouse`(`default_warehouse`), 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:10:27,668 WARNING database DDL Query made to DB: create table `tabPick 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', `naming_series` varchar(140), `company` varchar(140), `purpose` varchar(140) default 'Material Transfer for Manufacture', `customer` varchar(140), `customer_name` varchar(140), `work_order` varchar(140), `material_request` varchar(140), `for_qty` decimal(21,9) not null default 0, `parent_warehouse` varchar(140), `consider_rejected_warehouses` int(1) not null default 0, `pick_manually` int(1) not null default 0, `ignore_pricing_rule` int(1) not null default 0, `scan_barcode` varchar(140), `scan_mode` int(1) not null default 0, `prompt_qty` int(1) not null default 0, `amended_from` varchar(140), `group_same_items` int(1) not null default 0, `status` varchar(140) default 'Draft', `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:27,796 WARNING database DDL Query made to DB: create table `tabPacking Slip 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', `item_code` varchar(140), `item_name` varchar(140), `batch_no` varchar(140), `description` longtext, `qty` decimal(21,9) not null default 0, `net_weight` decimal(21,9) not null default 0, `stock_uom` varchar(140), `weight_uom` varchar(140), `page_break` int(1) not null default 0, `dn_detail` varchar(140), `pi_detail` 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:10:27,872 WARNING database DDL Query made to DB: create table `tabWarehouse 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:10:28,030 WARNING database DDL Query made to DB: create table `tabSerial and Batch Bundle` ( name varchar(140) primary key, creation datetime(6), 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) default 'SABB-.########', `company` varchar(140), `item_name` varchar(140), `has_serial_no` int(1) not null default 0, `has_batch_no` int(1) not null default 0, `item_code` varchar(140), `warehouse` varchar(140), `type_of_transaction` varchar(140), `total_qty` decimal(21,9) not null default 0, `item_group` varchar(140), `avg_rate` decimal(21,9) not null default 0, `total_amount` decimal(21,9) not null default 0, `voucher_type` varchar(140), `voucher_no` varchar(140), `voucher_detail_no` varchar(140), `posting_date` date, `posting_time` time(6), `returned_against` varchar(140), `is_cancelled` int(1) not null default 0, `is_rejected` int(1) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `company`(`company`), index `item_code`(`item_code`), index `warehouse`(`warehouse`), index `type_of_transaction`(`type_of_transaction`), index `voucher_no`(`voucher_no`), index `voucher_detail_no`(`voucher_detail_no`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:28,147 WARNING database DDL Query made to DB: create table `tabItem Reorder` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `warehouse_group` varchar(140), `warehouse` varchar(140), `warehouse_reorder_level` decimal(21,9) not null default 0, `warehouse_reorder_qty` decimal(21,9) not null default 0, `material_request_type` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:28,245 WARNING database DDL Query made to DB: create table `tabStock Reconciliation` ( name varchar(140) primary key, creation datetime(6), 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), `company` varchar(140), `purpose` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `set_warehouse` varchar(140), `scan_barcode` varchar(140), `scan_mode` int(1) not null default 0, `expense_account` varchar(140), `difference_amount` decimal(21,9) not null default 0, `amended_from` varchar(140), `cost_center` 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:10:28,355 WARNING database DDL Query made to DB: create table `tabQuality Inspection` ( name varchar(140) primary key, creation datetime(6), 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), `company` varchar(140), `report_date` date, `status` varchar(140) default 'Accepted', `child_row_reference` varchar(140), `inspection_type` varchar(140), `reference_type` varchar(140), `reference_name` varchar(140), `item_code` varchar(140), `item_serial_no` varchar(140), `batch_no` varchar(140), `sample_size` decimal(21,9) not null default 0, `item_name` varchar(140), `description` text, `bom_no` varchar(140), `quality_inspection_template` varchar(140), `manual_inspection` int(1) not null default 0, `inspected_by` varchar(140) default 'user', `verified_by` varchar(140), `remarks` text, `amended_from` varchar(140), `letter_head` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `report_date`(`report_date`), index `item_code`(`item_code`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:28,460 WARNING database DDL Query made to DB: create table `tabBin` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_code` varchar(140), `warehouse` varchar(140), `actual_qty` decimal(21,9) not null default 0, `planned_qty` decimal(21,9) not null default 0, `indented_qty` decimal(21,9) not null default 0, `ordered_qty` decimal(21,9) not null default 0, `projected_qty` decimal(21,9) not null default 0, `reserved_qty` decimal(21,9) not null default 0, `reserved_qty_for_production` decimal(21,9) not null default 0, `reserved_qty_for_sub_contract` decimal(21,9) not null default 0, `reserved_qty_for_production_plan` decimal(21,9) not null default 0, `reserved_stock` decimal(21,9) not null default 0, `stock_uom` varchar(140), `valuation_rate` decimal(21,9) not null default 0, `stock_value` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `warehouse`(`warehouse`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:28,534 WARNING database DDL Query made to DB: alter table `tabBin` add unique `unique_item_warehouse`(item_code, warehouse) 2025-05-20 13:10:28,578 WARNING database DDL Query made to DB: create table `tabUOM Conversion 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', `uom` varchar(140), `conversion_factor` 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:10:28,659 WARNING database DDL Query made to DB: create table `tabCustoms Tariff Number` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `tariff_number` varchar(140) unique, `description` 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:10:28,756 WARNING database DDL Query made to DB: create table `tabLanded Cost 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', `item_code` varchar(140), `description` longtext, `receipt_document_type` varchar(140), `receipt_document` varchar(140), `qty` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `is_fixed_asset` int(1) not null default 0, `applicable_charges` decimal(21,9) not null default 0, `purchase_receipt_item` varchar(140), `cost_center` 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:10:28,829 WARNING database DDL Query made to DB: create table `tabItem Attribute Value` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `attribute_value` varchar(140), `abbr` varchar(140), index `abbr`(`abbr`), 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:10:28,939 WARNING database DDL Query made to DB: create table `tabPacked Item` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `parent_item` varchar(140), `item_code` varchar(140), `item_name` varchar(140), `description` longtext, `warehouse` varchar(140), `target_warehouse` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `qty` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `uom` varchar(140), `use_serial_batch_fields` int(1) not null default 0, `serial_and_batch_bundle` varchar(140), `serial_no` text, `batch_no` varchar(140), `actual_batch_qty` decimal(21,9) not null default 0, `actual_qty` decimal(21,9) not null default 0, `projected_qty` decimal(21,9) not null default 0, `ordered_qty` decimal(21,9) not null default 0, `packed_qty` decimal(21,9) not null default 0, `incoming_rate` decimal(21,9) not null default 0, `picked_qty` decimal(21,9) not null default 0, `page_break` int(1) not null default 0, `prevdoc_doctype` varchar(140), `parent_detail_docname` varchar(140), index `parent_detail_docname`(`parent_detail_docname`), 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:10:28,982 WARNING database DDL Query made to DB: ALTER TABLE `tabPacked Item` ADD INDEX IF NOT EXISTS `item_code_warehouse_index`(item_code, warehouse) 2025-05-20 13:10:29,044 WARNING database DDL Query made to DB: create table `tabPutaway 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, `item_code` varchar(140), `item_name` varchar(140), `warehouse` varchar(140), `priority` int(11) not null default 1, `company` varchar(140), `capacity` decimal(21,9) not null default 0, `uom` varchar(140), `conversion_factor` decimal(21,9) not null default 1.0, `stock_uom` varchar(140), `stock_capacity` 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:10:29,136 WARNING database DDL Query made to DB: create table `tabItem Barcode` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `barcode` varchar(140) unique, `barcode_type` varchar(140), `uom` 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:10:29,217 WARNING database DDL Query made to DB: create table `tabItem Manufacturer` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_code` varchar(140), `manufacturer` varchar(140), `manufacturer_part_no` varchar(140), `item_name` varchar(140), `description` text, `is_default` 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:10:29,336 WARNING database DDL Query made to DB: create table `tabStock Reconciliation 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', `barcode` varchar(140), `has_item_scanned` varchar(140), `item_code` varchar(140), `item_name` varchar(140), `item_group` varchar(140), `warehouse` varchar(140), `qty` decimal(21,9) not null default 0, `valuation_rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `allow_zero_valuation_rate` int(1) not null default 0, `use_serial_batch_fields` int(1) not null default 0, `reconcile_all_serial_batch` int(1) not null default 0, `serial_and_batch_bundle` varchar(140), `current_serial_and_batch_bundle` varchar(140), `serial_no` longtext, `batch_no` varchar(140), `current_qty` decimal(21,9) not null default 0, `current_amount` decimal(21,9) not null default 0, `current_valuation_rate` decimal(21,9) not null default 0, `current_serial_no` longtext, `quantity_difference` varchar(140), `amount_difference` decimal(21,9) not null default 0, index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `batch_no`(`batch_no`), 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:10:29,411 WARNING database DDL Query made to DB: create table `tabUOM 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', `category_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-05-20 13:10:29,490 WARNING database DDL Query made to DB: create table `tabItem Alternative` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_code` varchar(140), `alternative_item_code` varchar(140), `two_way` int(1) not null default 0, `item_name` varchar(140), `alternative_item_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-05-20 13:10:29,698 WARNING database DDL Query made to DB: create table `tabMaterial Request 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', `item_code` varchar(140), `item_name` varchar(140), `schedule_date` date, `description` longtext, `item_group` varchar(140), `brand` varchar(140), `image` text, `qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), `from_warehouse` varchar(140), `warehouse` varchar(140), `uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `stock_qty` decimal(21,9) not null default 0, `min_order_qty` decimal(21,9) not null default 0, `projected_qty` decimal(21,9) not null default 0, `actual_qty` decimal(21,9) not null default 0, `ordered_qty` decimal(21,9) not null default 0, `received_qty` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `price_list_rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `expense_account` varchar(140), `wip_composite_asset` varchar(140), `manufacturer` varchar(140), `manufacturer_part_no` varchar(140), `bom_no` varchar(140), `project` varchar(140), `cost_center` varchar(140), `lead_time_date` date, `sales_order` varchar(140), `sales_order_item` varchar(140), `production_plan` varchar(140), `material_request_plan_item` varchar(140), `job_card_item` varchar(140), `page_break` int(1) not null default 0, index `item_code`(`item_code`), index `item_name`(`item_name`), index `item_group`(`item_group`), index `sales_order_item`(`sales_order_item`), 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:10:29,746 WARNING database DDL Query made to DB: ALTER TABLE `tabMaterial Request Item` ADD INDEX IF NOT EXISTS `item_code_warehouse_index`(item_code, warehouse) 2025-05-20 13:10:29,832 WARNING database DDL Query made to DB: create table `tabSerial No` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `serial_no` varchar(140) unique, `item_code` varchar(140), `batch_no` varchar(140), `warehouse` varchar(140), `purchase_rate` decimal(21,9) not null default 0, `status` varchar(140), `item_name` varchar(140), `description` text, `item_group` varchar(140), `brand` varchar(140), `asset` varchar(140), `asset_status` varchar(140), `location` varchar(140), `employee` varchar(140), `warranty_expiry_date` date, `amc_expiry_date` date, `maintenance_status` varchar(140), `warranty_period` int(11) not null default 0, `company` varchar(140), `work_order` varchar(140), `purchase_document_no` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `maintenance_status`(`maintenance_status`), index `company`(`company`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:29,973 WARNING database DDL Query made to DB: create table `tabVariant Field` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `field_name` 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:10:30,102 WARNING database DDL Query made to DB: create table `tabMaterial 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', `naming_series` varchar(140), `title` varchar(140) default '{material_request_type}', `material_request_type` varchar(140), `customer` varchar(140), `company` varchar(140), `transaction_date` date, `schedule_date` date, `amended_from` varchar(140), `scan_barcode` varchar(140), `set_from_warehouse` varchar(140), `set_warehouse` varchar(140), `tc_name` varchar(140), `terms` longtext, `status` varchar(140), `per_ordered` decimal(21,9) not null default 0, `transfer_status` varchar(140), `per_received` decimal(21,9) not null default 0, `letter_head` varchar(140), `select_print_heading` varchar(140), `job_card` varchar(140), `work_order` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `company`(`company`), index `transaction_date`(`transaction_date`), index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:30,274 WARNING database DDL Query made to DB: create table `tabLanded Cost Voucher` ( name varchar(140) primary key, creation datetime(6), 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), `company` varchar(140), `posting_date` date, `total_taxes_and_charges` decimal(21,9) not null default 0, `distribute_charges_based_on` 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:10:30,396 WARNING database DDL Query made to DB: create table `tabPick List 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', `item_code` varchar(140), `item_name` varchar(140), `description` text, `item_group` varchar(140), `warehouse` varchar(140), `qty` decimal(21,9) not null default 1.0, `stock_qty` decimal(21,9) not null default 0, `picked_qty` decimal(21,9) not null default 0, `stock_reserved_qty` decimal(21,9) not null default 0, `uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `stock_uom` varchar(140), `serial_and_batch_bundle` varchar(140), `use_serial_batch_fields` int(1) not null default 0, `serial_no` text, `batch_no` varchar(140), `sales_order` varchar(140), `sales_order_item` varchar(140), `product_bundle_item` varchar(140), `material_request` varchar(140), `material_request_item` varchar(140), index `item_code`(`item_code`), index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `batch_no`(`batch_no`), 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:10:30,496 WARNING database DDL Query made to DB: create table `tabRepost Item Valuation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `based_on` varchar(140) default 'Transaction', `voucher_type` varchar(140), `voucher_no` varchar(140), `item_code` varchar(140), `warehouse` varchar(140), `posting_date` date, `posting_time` time(6), `status` varchar(140) default 'Queued', `company` varchar(140), `allow_negative_stock` int(1) not null default 1, `via_landed_cost_voucher` int(1) not null default 0, `allow_zero_rate` int(1) not null default 0, `recreate_stock_ledgers` int(1) not null default 0, `amended_from` varchar(140), `error_log` longtext, `reposting_data_file` text, `items_to_be_repost` longtext, `distinct_item_and_warehouse` longtext, `total_reposting_count` int(11) not null default 0, `current_index` int(11) not null default 0, `gl_reposting_index` int(11) not null default 0, `affected_transactions` 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-05-20 13:10:30,560 WARNING database DDL Query made to DB: ALTER TABLE `tabRepost Item Valuation` ADD INDEX IF NOT EXISTS `item_warehouse`(warehouse, item_code) 2025-05-20 13:10:30,619 WARNING database DDL Query made to DB: create table `tabLanded Cost Taxes and 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', `expense_account` varchar(140), `account_currency` varchar(140), `exchange_rate` decimal(21,9) not null default 0, `description` text, `amount` decimal(21,9) not null default 0, `base_amount` decimal(21,9) not null default 0, `has_corrective_cost` 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:10:30,685 WARNING database DDL Query made to DB: create table `tabPrice List Country` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `country` 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:10:30,759 WARNING database DDL Query made to DB: create table `tabQuality Inspection Parameter 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', `group_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:10:30,859 WARNING database DDL Query made to DB: create table `tabQuality Inspection Parameter` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `parameter` varchar(140) unique, `parameter_group` varchar(140), `description` 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-05-20 13:10:30,949 WARNING database DDL Query made to DB: create table `tabItem Variant` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_attribute` varchar(140), `item_attribute_value` 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:10:31,056 WARNING database DDL Query made to DB: create table `tabWarehouse` ( name varchar(140) primary key, creation datetime(6), 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, `warehouse_name` varchar(140), `is_group` int(1) not null default 0, `parent_warehouse` varchar(140), `is_rejected_warehouse` int(1) not null default 0, `account` varchar(140), `company` varchar(140), `email_id` varchar(140), `phone_no` varchar(140), `mobile_no` varchar(140), `address_line_1` varchar(140), `address_line_2` varchar(140), `city` varchar(140), `state` varchar(140), `pin` varchar(140), `warehouse_type` varchar(140), `default_in_transit_warehouse` varchar(140), `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 `parent_warehouse`(`parent_warehouse`), index `company`(`company`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:31,168 WARNING database DDL Query made to DB: create table `tabLanded Cost Purchase Receipt` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `receipt_document_type` varchar(140), `receipt_document` varchar(140), `supplier` varchar(140), `posting_date` date, `grand_total` 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:10:31,261 WARNING database DDL Query made to DB: create table `tabQuality Inspection Reading` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `specification` varchar(140), `parameter_group` varchar(140), `status` varchar(140) default 'Accepted', `value` varchar(140), `numeric` int(1) not null default 1, `manual_inspection` int(1) not null default 0, `min_value` decimal(21,9) not null default 0, `max_value` decimal(21,9) not null default 0, `formula_based_criteria` int(1) not null default 0, `acceptance_formula` longtext, `reading_value` varchar(140), `reading_1` varchar(140), `reading_2` varchar(140), `reading_3` varchar(140), `reading_4` varchar(140), `reading_5` varchar(140), `reading_6` varchar(140), `reading_7` varchar(140), `reading_8` varchar(140), `reading_9` varchar(140), `reading_10` 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:10:31,477 WARNING database DDL Query made to DB: create table `tabShipment Delivery Note` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `delivery_note` varchar(140), `grand_total` 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:10:31,658 WARNING database DDL Query made to DB: create table `tabItem Price` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_code` varchar(140), `uom` varchar(140), `packing_unit` int(11) not null default 0, `item_name` varchar(140), `brand` varchar(140), `item_description` text, `price_list` varchar(140), `customer` varchar(140), `supplier` varchar(140), `batch_no` varchar(140), `buying` int(1) not null default 0, `selling` int(1) not null default 0, `currency` varchar(140), `price_list_rate` decimal(21,9) not null default 0, `valid_from` date, `lead_time_days` int(11) not null default 0, `valid_upto` date, `note` text, `reference` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `item_code`(`item_code`), index `price_list`(`price_list`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:31,775 WARNING database DDL Query made to DB: create table `tabInventory Dimension` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `dimension_name` varchar(140) unique, `reference_document` varchar(140), `disabled` int(1) not null default 0, `source_fieldname` varchar(140), `target_fieldname` varchar(140), `apply_to_all_doctypes` int(1) not null default 1, `validate_negative_stock` int(1) not null default 0, `document_type` varchar(140), `type_of_transaction` varchar(140), `fetch_from_parent` varchar(140), `istable` int(1) not null default 0, `condition` longtext, `reqd` int(1) not null default 0, `mandatory_depends_on` 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:10:31,887 WARNING database DDL Query made to DB: create table `tabPacking 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', `delivery_note` varchar(140), `naming_series` varchar(140), `from_case_no` int(11) not null default 0, `to_case_no` int(11) not null default 0, `net_weight_pkg` decimal(21,9) not null default 0, `net_weight_uom` varchar(140), `gross_weight_pkg` decimal(21,9) not null default 0, `gross_weight_uom` varchar(140), `letter_head` 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:10:32,133 WARNING database DDL Query made to DB: create table `tabPurchase Receipt 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', `barcode` varchar(140), `has_item_scanned` int(1) not null default 0, `item_code` varchar(140), `product_bundle` varchar(140), `supplier_part_no` varchar(140), `item_name` varchar(140), `description` longtext, `brand` varchar(140), `item_group` varchar(140), `image` text, `received_qty` decimal(21,9) not null default 0, `qty` decimal(21,9) not null default 0, `rejected_qty` decimal(21,9) not null default 0, `uom` varchar(140), `stock_uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `retain_sample` int(1) not null default 0, `sample_quantity` int(11) not null default 0, `received_stock_qty` decimal(21,9) not null default 0, `stock_qty` decimal(21,9) not null default 0, `returned_qty` decimal(21,9) not null default 0, `price_list_rate` decimal(21,9) not null default 0, `base_price_list_rate` decimal(21,9) not null default 0, `margin_type` varchar(140), `margin_rate_or_amount` decimal(21,9) not null default 0, `rate_with_margin` decimal(21,9) not null default 0, `discount_percentage` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `distributed_discount_amount` decimal(21,9) not null default 0, `base_rate_with_margin` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `base_rate` decimal(21,9) not null default 0, `base_amount` decimal(21,9) not null default 0, `pricing_rules` text, `stock_uom_rate` decimal(21,9) not null default 0, `is_free_item` int(1) not null default 0, `apply_tds` int(1) not null default 1, `net_rate` decimal(21,9) not null default 0, `net_amount` decimal(21,9) not null default 0, `item_tax_template` varchar(140), `base_net_rate` decimal(21,9) not null default 0, `base_net_amount` decimal(21,9) not null default 0, `valuation_rate` decimal(21,9) not null default 0, `sales_incoming_rate` decimal(21,9) not null default 0, `item_tax_amount` decimal(21,9) not null default 0, `rm_supp_cost` decimal(21,9) not null default 0, `landed_cost_voucher_amount` decimal(21,9) not null default 0, `amount_difference_with_purchase_invoice` decimal(21,9) not null default 0, `billed_amt` decimal(21,9) not null default 0, `warehouse` varchar(140), `rejected_warehouse` varchar(140), `from_warehouse` varchar(140), `material_request` varchar(140), `purchase_order` varchar(140), `purchase_invoice` varchar(140), `allow_zero_valuation_rate` int(1) not null default 0, `return_qty_from_rejected_warehouse` int(1) not null default 0, `is_fixed_asset` int(1) not null default 0, `asset_location` varchar(140), `asset_category` varchar(140), `schedule_date` date, `quality_inspection` varchar(140), `material_request_item` varchar(140), `purchase_order_item` varchar(140), `purchase_invoice_item` varchar(140), `purchase_receipt_item` varchar(140), `delivery_note_item` varchar(140), `putaway_rule` varchar(140), `serial_and_batch_bundle` varchar(140), `use_serial_batch_fields` int(1) not null default 0, `rejected_serial_and_batch_bundle` varchar(140), `serial_no` text, `rejected_serial_no` text, `batch_no` varchar(140), `include_exploded_items` int(1) not null default 0, `bom` varchar(140), `weight_per_unit` decimal(21,9) not null default 0, `total_weight` decimal(21,9) not null default 0, `weight_uom` varchar(140), `manufacturer` varchar(140), `manufacturer_part_no` varchar(140), `expense_account` varchar(140), `item_tax_rate` longtext, `wip_composite_asset` varchar(140), `provisional_expense_account` varchar(140), `project` varchar(140), `cost_center` varchar(140), `page_break` int(1) not null default 0, `sales_order` varchar(140), `sales_order_item` varchar(140), `subcontracting_receipt_item` varchar(140), index `item_code`(`item_code`), index `purchase_order`(`purchase_order`), index `purchase_order_item`(`purchase_order_item`), index `purchase_invoice_item`(`purchase_invoice_item`), index `purchase_receipt_item`(`purchase_receipt_item`), index `delivery_note_item`(`delivery_note_item`), index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `batch_no`(`batch_no`), index `sales_order`(`sales_order`), index `sales_order_item`(`sales_order_item`), index `subcontracting_receipt_item`(`subcontracting_receipt_item`), 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:10:32,885 WARNING database DDL Query made to DB: create table `tabService Day` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `workday` varchar(140), `start_time` time(6), `end_time` time(6), 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:10:32,952 WARNING database DDL Query made to DB: create table `tabPause SLA On Status` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `status` 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:10:33,047 WARNING database DDL Query made to DB: create table `tabService Level Agreement` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `document_type` varchar(140), `default_priority` varchar(140), `service_level` varchar(140), `enabled` int(1) not null default 1, `default_service_level_agreement` int(1) not null default 0, `entity_type` varchar(140), `entity` varchar(140), `condition` longtext, `start_date` date, `end_date` date, `apply_sla_for_resolution` int(1) not null default 1, `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-05-20 13:10:33,152 WARNING database DDL Query made to DB: create table `tabSupport Search 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), `source_type` varchar(140), `base_url` varchar(140), `query_route` varchar(140), `search_term_param_name` varchar(140), `response_result_key_path` varchar(140), `post_route` varchar(140), `post_route_key_list` varchar(140), `post_title_key` varchar(140), `post_description_key` varchar(140), `source_doctype` varchar(140), `result_title_field` varchar(140), `result_preview_field` varchar(140), `result_route_field` 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:10:33,221 WARNING database DDL Query made to DB: create table `tabIssue Priority` ( name varchar(140) primary key, creation datetime(6), 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:10:33,378 WARNING database DDL Query made to DB: create table `tabIssue 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:10:33,468 WARNING database DDL Query made to DB: create table `tabService Level Priority` ( name varchar(140) primary key, creation datetime(6), 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_priority` int(1) not null default 0, `priority` varchar(140), `response_time` decimal(21,9), `resolution_time` decimal(21,9), 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:10:33,542 WARNING database DDL Query made to DB: create table `tabSLA Fulfilled On Status` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `status` 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:10:33,661 WARNING database DDL Query made to DB: create table `tabIssue` ( name varchar(140) primary key, creation datetime(6), 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), `subject` varchar(140), `customer` varchar(140), `raised_by` varchar(140), `status` varchar(140) default 'Open', `priority` varchar(140), `issue_type` varchar(140), `issue_split_from` varchar(140), `description` longtext, `service_level_agreement` varchar(140), `response_by` datetime(6), `agreement_status` varchar(140) default 'First Response Due', `sla_resolution_by` datetime(6), `service_level_agreement_creation` datetime(6), `on_hold_since` datetime(6), `total_hold_time` decimal(21,9), `first_response_time` decimal(21,9), `first_responded_on` datetime(6), `avg_response_time` decimal(21,9), `resolution_details` longtext, `opening_date` date, `opening_time` time(6), `sla_resolution_date` datetime(6), `resolution_time` decimal(21,9), `user_resolution_time` decimal(21,9), `lead` varchar(140), `contact` varchar(140), `email_account` varchar(140), `customer_name` varchar(140), `project` varchar(140), `company` varchar(140), `via_customer_portal` int(1) not null default 0, `attachment` text, `content_type` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index `customer`(`customer`), index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:33,813 WARNING database DDL Query made to DB: create table `tabWarranty 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), `status` varchar(140) default 'Open', `complaint_date` date, `customer` varchar(140), `serial_no` varchar(140), `complaint` longtext, `item_code` varchar(140), `item_name` varchar(140), `description` text, `warranty_amc_status` varchar(140), `warranty_expiry_date` date, `amc_expiry_date` date, `resolution_date` datetime(6), `resolved_by` varchar(140), `resolution_details` text, `customer_name` varchar(140), `contact_person` varchar(140), `contact_display` text, `contact_mobile` varchar(140), `contact_email` varchar(140), `territory` varchar(140), `customer_group` varchar(140), `customer_address` varchar(140), `address_display` text, `service_address` text, `company` varchar(140), `complaint_raised_by` varchar(140), `from_company` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `status`(`status`), index `complaint_date`(`complaint_date`), index `customer`(`customer`), index `serial_no`(`serial_no`), index `item_code`(`item_code`), index `warranty_amc_status`(`warranty_amc_status`), index `resolution_date`(`resolution_date`), index `resolved_by`(`resolved_by`), index `territory`(`territory`), index `company`(`company`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:33,973 WARNING database DDL Query made to DB: create table `tabSMS Log` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `sender_name` varchar(140), `sent_on` date, `message` text, `no_of_requested_sms` int(11) not null default 0, `requested_numbers` longtext, `no_of_sent_sms` int(11) not null default 0, `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-05-20 13:10:34,118 WARNING database DDL Query made to DB: create table `tabPortal 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), index `user`(`user`), 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:10:34,378 WARNING database DDL Query made to DB: create table `tabVideo` ( name varchar(140) primary key, creation datetime(6), 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, `provider` varchar(140), `url` varchar(140), `youtube_video_id` varchar(140), `publish_date` date, `duration` decimal(21,9), `like_count` decimal(21,9) not null default 0, `view_count` decimal(21,9) not null default 0, `dislike_count` decimal(21,9) not null default 0, `comment_count` decimal(21,9) not null default 0, `description` longtext, `image` 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:10:34,587 WARNING database DDL Query made to DB: create table `tabAsset Capitalization Asset 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', `asset` varchar(140), `asset_name` varchar(140), `finance_book` varchar(140), `item_code` varchar(140), `item_name` varchar(140), `current_asset_value` decimal(21,9) not null default 0, `asset_value` decimal(21,9) not null default 0, `cost_center` varchar(140), `fixed_asset_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:10:34,670 WARNING database DDL Query made to DB: create table `tabAsset Movement` ( name varchar(140) primary key, creation datetime(6), 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), `purpose` varchar(140), `transaction_date` datetime(6), `reference_doctype` varchar(140), `reference_name` 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:10:34,771 WARNING database DDL Query made to DB: create table `tabAsset 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', `asset_category_name` varchar(140) unique, `enable_cwip_accounting` int(1) not null default 0, `non_depreciable_category` 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:10:34,882 WARNING database DDL Query made to DB: create table `tabAsset Depreciation Schedule` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `asset` varchar(140), `naming_series` varchar(140), `company` varchar(140), `gross_purchase_amount` decimal(21,9) not null default 0, `opening_accumulated_depreciation` decimal(21,9) not null default 0, `opening_number_of_booked_depreciations` int(11) not null default 0, `finance_book` varchar(140), `finance_book_id` int(11) not null default 0, `depreciation_method` varchar(140), `total_number_of_depreciations` int(11) not null default 0, `rate_of_depreciation` decimal(21,9) not null default 0, `daily_prorata_based` int(1) not null default 0, `shift_based` int(1) not null default 0, `frequency_of_depreciation` int(11) not null default 0, `expected_value_after_useful_life` decimal(21,9) not null default 0, `notes` text, `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-05-20 13:10:34,970 WARNING database DDL Query made to DB: create table `tabAsset 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', `asset` varchar(140), `date` datetime(6), `user` varchar(140), `subject` 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:10:35,059 WARNING database DDL Query made to DB: create table `tabMaintenance Team Member` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `team_member` varchar(140), `full_name` varchar(140), `maintenance_role` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:35,158 WARNING database DDL Query made to DB: create table `tabAsset Value Adjustment` ( name varchar(140) primary key, creation datetime(6), 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), `asset` varchar(140), `asset_category` varchar(140), `date` date, `finance_book` varchar(140), `amended_from` varchar(140), `current_asset_value` decimal(21,9) not null default 0, `new_asset_value` decimal(21,9) not null default 0, `difference_amount` decimal(21,9) not null default 0, `difference_account` varchar(140), `journal_entry` varchar(140), `cost_center` 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:10:35,258 WARNING database DDL Query made to DB: create table `tabAsset Finance Book` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `finance_book` varchar(140), `depreciation_method` varchar(140), `total_number_of_depreciations` int(11) not null default 0, `total_number_of_booked_depreciations` int(11) not null default 0, `daily_prorata_based` int(1) not null default 0, `shift_based` int(1) not null default 0, `frequency_of_depreciation` int(11) not null default 0, `depreciation_start_date` date, `salvage_value_percentage` decimal(21,9) not null default 0, `expected_value_after_useful_life` decimal(21,9) not null default 0, `value_after_depreciation` decimal(21,9) not null default 0, `rate_of_depreciation` 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:10:35,343 WARNING database DDL Query made to DB: create table `tabAsset Capitalization 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', `item_code` varchar(140), `item_name` varchar(140), `expense_account` varchar(140), `qty` decimal(21,9) not null default 1.0, `uom` varchar(140), `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `cost_center` 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:10:35,459 WARNING database DDL Query made to DB: create table `tabAsset Capitalization` ( name varchar(140) primary key, creation datetime(6), 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), `naming_series` varchar(140), `capitalization_method` varchar(140), `target_item_code` varchar(140), `target_item_name` varchar(140), `target_asset` varchar(140), `target_asset_name` varchar(140), `target_qty` decimal(21,9) not null default 1.0, `target_asset_location` varchar(140), `company` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `finance_book` varchar(140), `target_batch_no` varchar(140), `target_serial_no` text, `amended_from` varchar(140), `target_is_fixed_asset` int(1) not null default 0, `target_has_batch_no` int(1) not null default 0, `target_has_serial_no` int(1) not null default 0, `stock_items_total` decimal(21,9) not null default 0, `asset_items_total` decimal(21,9) not null default 0, `service_items_total` decimal(21,9) not null default 0, `total_value` decimal(21,9) not null default 0, `target_incoming_rate` decimal(21,9) not null default 0, `cost_center` varchar(140), `target_fixed_asset_account` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index `posting_date`(`posting_date`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-05-20 13:10:35,616 WARNING database DDL Query made to DB: create table `tabAsset` ( name varchar(140) primary key, creation datetime(6), 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), `item_code` varchar(140), `item_name` varchar(140), `asset_owner` varchar(140), `asset_owner_company` varchar(140), `is_existing_asset` int(1) not null default 0, `is_composite_asset` int(1) not null default 0, `supplier` varchar(140), `customer` varchar(140), `image` text, `journal_entry_for_scrap` varchar(140), `naming_series` varchar(140), `asset_name` varchar(140), `asset_category` varchar(140), `location` varchar(140), `split_from` varchar(140), `custodian` varchar(140), `department` varchar(140), `disposal_date` date, `cost_center` varchar(140), `purchase_receipt` varchar(140), `purchase_receipt_item` varchar(140), `purchase_invoice` varchar(140), `purchase_invoice_item` varchar(140), `purchase_date` date, `available_for_use_date` date, `gross_purchase_amount` decimal(21,9) not null default 0, `asset_quantity` int(11) not null default 1, `additional_asset_cost` decimal(21,9) not null default 0, `total_asset_cost` decimal(21,9) not null default 0, `calculate_depreciation` int(1) not null default 0, `opening_accumulated_depreciation` decimal(21,9) not null default 0, `opening_number_of_booked_depreciations` int(11) not null default 0, `is_fully_depreciated` int(1) not null default 0, `depreciation_method` varchar(140), `value_after_depreciation` decimal(21,9) not null default 0, `total_number_of_depreciations` int(11) not null default 0, `frequency_of_depreciation` int(11) not null default 0, `next_depreciation_date` date, `policy_number` varchar(140), `insurer` varchar(140), `insured_value` varchar(140), `insurance_start_date` date, `insurance_end_date` date, `comprehensive_insurance` varchar(140), `maintenance_required` int(1) not null default 0, `status` varchar(140) default 'Draft', `booked_fixed_asset` int(1) not null default 0, `purchase_amount` decimal(21,9) not null default 0, `default_finance_book` varchar(140), `depr_entry_posting_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-05-20 13:10:35,722 WARNING database DDL Query made to DB: create table `tabAsset Capitalization Stock 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', `item_code` varchar(140), `item_name` varchar(140), `warehouse` varchar(140), `purchase_receipt_item` varchar(140), `stock_qty` decimal(21,9) not null default 0, `actual_qty` decimal(21,9) not null default 0, `valuation_rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `stock_uom` varchar(140), `serial_and_batch_bundle` varchar(140), `use_serial_batch_fields` int(1) not null default 0, `serial_no` text, `batch_no` varchar(140), `cost_center` 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:10:35,798 WARNING database DDL Query made to DB: create table `tabAsset Category 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_name` varchar(140), `fixed_asset_account` varchar(140), `accumulated_depreciation_account` varchar(140), `depreciation_expense_account` varchar(140), `capital_work_in_progress_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:10:35,875 WARNING database DDL Query made to DB: create table `tabAsset Shift Factor` ( name varchar(140) primary key, creation datetime(6), 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_name` varchar(140) unique, `shift_factor` decimal(21,9) not null default 0, `default` 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:10:35,968 WARNING database DDL Query made to DB: create table `tabLinked Location` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `location` 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:10:36,051 WARNING database DDL Query made to DB: create table `tabAsset Maintenance Team` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `maintenance_team_name` varchar(140) unique, `maintenance_manager` varchar(140), `maintenance_manager_name` varchar(140), `company` 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:10:36,130 WARNING database DDL Query made to DB: create table `tabDepreciation Schedule` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `schedule_date` date, `depreciation_amount` decimal(21,9) not null default 0, `accumulated_depreciation_amount` decimal(21,9) not null default 0, `journal_entry` varchar(140), `shift` 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:10:36,214 WARNING database DDL Query made to DB: create table `tabAsset Movement 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', `company` varchar(140), `asset` varchar(140), `source_location` varchar(140), `from_employee` varchar(140), `asset_name` varchar(140), `target_location` varchar(140), `to_employee` 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:10:36,309 WARNING database DDL Query made to DB: create table `tabAsset Maintenance Task` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `maintenance_task` varchar(140), `maintenance_type` varchar(140), `maintenance_status` varchar(140), `start_date` date, `periodicity` varchar(140), `end_date` date, `certificate_required` int(1) not null default 0, `assign_to` varchar(140), `assign_to_name` varchar(140), `next_due_date` date, `last_completion_date` date, `description` longtext, index `certificate_required`(`certificate_required`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci