3276 lines
97 KiB
Groff
3276 lines
97 KiB
Groff
2025-05-20 13:08:50,385 WARNING database DDL Query made to DB:
|
|
create table `tabTop Bar 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',
|
|
`label` varchar(140),
|
|
`url` varchar(140),
|
|
`open_in_new_tab` int(1) not null default 0,
|
|
`right` int(1) not null default 1,
|
|
`parent_label` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:50,442 WARNING database DDL Query made to DB:
|
|
create table `tabWebsite Route Meta` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:51,054 WARNING database DDL Query made to DB:
|
|
create table `tabWorkflow Action` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`reference_name` varchar(140),
|
|
`reference_doctype` varchar(140),
|
|
`workflow_state` varchar(140),
|
|
`completed_by_role` varchar(140),
|
|
`completed_by` varchar(140),
|
|
`user` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `user`(`user`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:51,113 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabWorkflow Action`
|
|
ADD INDEX IF NOT EXISTS `reference_name_reference_doctype_status_index`(reference_name, reference_doctype, status)
|
|
2025-05-20 13:08:51,267 WARNING database DDL Query made to DB:
|
|
create table `tabWorkflow` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`workflow_name` varchar(140) unique,
|
|
`document_type` varchar(140),
|
|
`is_active` int(1) not null default 0,
|
|
`override_status` int(1) not null default 0,
|
|
`send_email_alert` int(1) not null default 0,
|
|
`workflow_state_field` varchar(140) default 'workflow_state',
|
|
`workflow_data` json,
|
|
`_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:08:51,328 WARNING database DDL Query made to DB:
|
|
create table `tabWorkflow Action Permitted Role` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`role` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:51,390 WARNING database DDL Query made to DB:
|
|
create table `tabWorkflow State` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`workflow_state_name` varchar(140) unique,
|
|
`icon` varchar(140),
|
|
`style` 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:08:51,456 WARNING database DDL Query made to DB:
|
|
create table `tabWorkflow Action Master` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`workflow_action_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:08:51,524 WARNING database DDL Query made to DB:
|
|
create table `tabWorkflow Document State` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`state` varchar(140),
|
|
`doc_status` varchar(140) default '0',
|
|
`update_field` varchar(140),
|
|
`update_value` varchar(140),
|
|
`is_optional_state` int(1) not null default 0,
|
|
`avoid_status_override` int(1) not null default 0,
|
|
`next_action_email_template` varchar(140),
|
|
`allow_edit` varchar(140),
|
|
`send_email` int(1) not null default 1,
|
|
`message` text,
|
|
`workflow_builder_id` 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:08:51,592 WARNING database DDL Query made to DB:
|
|
create table `tabWorkflow Transition` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`state` varchar(140),
|
|
`action` varchar(140),
|
|
`next_state` varchar(140),
|
|
`allowed` varchar(140),
|
|
`allow_self_approval` int(1) not null default 1,
|
|
`send_email_to_creator` int(1) not null default 0,
|
|
`condition` longtext,
|
|
`workflow_builder_id` 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:08:51,713 WARNING database DDL Query made to DB:
|
|
create table `tabEmail Group Member` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`email_group` varchar(140),
|
|
`email` varchar(140),
|
|
`unsubscribed` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `email_group`(`email_group`),
|
|
index `unsubscribed`(`unsubscribed`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:51,763 WARNING database DDL Query made to DB:
|
|
alter table `tabEmail Group Member`
|
|
add unique `unique_email_group_email`(email_group, email)
|
|
2025-05-20 13:08:51,901 WARNING database DDL Query made to DB:
|
|
create table `tabEmail Unsubscribe` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`email` varchar(140),
|
|
`reference_doctype` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`global_unsubscribe` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `email`(`email`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:51,970 WARNING database DDL Query made to DB:
|
|
create table `tabEmail 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',
|
|
`subject` varchar(140),
|
|
`use_html` int(1) not null default 0,
|
|
`response_html` longtext,
|
|
`response` 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:08:52,053 WARNING database DDL Query made to DB:
|
|
create table `tabEmail Flag Queue` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`is_completed` int(1) not null default 0,
|
|
`communication` varchar(140),
|
|
`action` varchar(140),
|
|
`email_account` varchar(140),
|
|
`uid` 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:08:52,108 WARNING database DDL Query made to DB:
|
|
create table `tabNewsletter Attachment` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`attachment` text,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:52,197 WARNING database DDL Query made to DB:
|
|
create table `tabAuto Email Report` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`report` varchar(140),
|
|
`user` varchar(140) default 'User',
|
|
`enabled` int(1) not null default 1,
|
|
`report_type` varchar(140),
|
|
`reference_report` varchar(140),
|
|
`send_if_data` int(1) not null default 1,
|
|
`data_modified_till` int(11) not null default 0,
|
|
`no_of_rows` int(11) not null default 100,
|
|
`filters` text,
|
|
`filter_meta` text,
|
|
`from_date_field` varchar(140),
|
|
`to_date_field` varchar(140),
|
|
`dynamic_date_period` varchar(140),
|
|
`use_first_day_of_period` int(1) not null default 0,
|
|
`email_to` text,
|
|
`day_of_week` varchar(140) default 'Monday',
|
|
`sender` varchar(140),
|
|
`frequency` varchar(140),
|
|
`format` 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:08:52,260 WARNING database DDL Query made to DB:
|
|
create table `tabEmail 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',
|
|
`email_id` varchar(140) unique,
|
|
`is_spam` 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:08:52,317 WARNING database DDL Query made to DB:
|
|
create table `tabNotification Recipient` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`receiver_by_document_field` varchar(140),
|
|
`receiver_by_role` varchar(140),
|
|
`cc` longtext,
|
|
`bcc` longtext,
|
|
`condition` 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:08:52,388 WARNING database DDL Query made to DB:
|
|
create table `tabEmail 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',
|
|
`title` varchar(140) unique,
|
|
`total_subscribers` int(11) not null default 0,
|
|
`confirmation_email_template` varchar(140),
|
|
`welcome_email_template` varchar(140),
|
|
`welcome_url` varchar(140),
|
|
`add_query_parameters` 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:08:52,467 WARNING database DDL Query made to DB:
|
|
create table `tabEmail Queue` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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` varchar(140),
|
|
`show_as_cc` text,
|
|
`message` longtext,
|
|
`status` varchar(140) default 'Not Sent',
|
|
`error` longtext,
|
|
`message_id` text,
|
|
`reference_doctype` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`communication` varchar(140),
|
|
`send_after` datetime(6),
|
|
`priority` int(11) not null default 1,
|
|
`add_unsubscribe_link` int(1) not null default 1,
|
|
`unsubscribe_param` varchar(140),
|
|
`unsubscribe_method` varchar(140),
|
|
`expose_recipients` varchar(140),
|
|
`attachments` longtext,
|
|
`retry` int(11) not null default 0,
|
|
`email_account` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `reference_name`(`reference_name`),
|
|
index `communication`(`communication`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=COMPRESSED
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:52,512 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabEmail Queue`
|
|
ADD INDEX IF NOT EXISTS `index_bulk_flush`(status, send_after, priority, creation)
|
|
2025-05-20 13:08:52,533 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabEmail Queue`
|
|
ADD INDEX IF NOT EXISTS `message_id_index`(message_id(140))
|
|
2025-05-20 13:08:52,585 WARNING database DDL Query made to DB:
|
|
create table `tabDocument Follow` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`ref_doctype` varchar(140),
|
|
`ref_docname` varchar(140),
|
|
`user` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `ref_doctype`(`ref_doctype`),
|
|
index `ref_docname`(`ref_docname`),
|
|
index `user`(`user`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:52,675 WARNING database DDL Query made to DB:
|
|
create table `tabNewsletter` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`email_sent_at` datetime(6),
|
|
`total_recipients` int(11) not null default 0,
|
|
`total_views` int(11) not null default 0,
|
|
`email_sent` int(1) not null default 0,
|
|
`sender_name` varchar(140),
|
|
`sender_email` varchar(140),
|
|
`send_from` varchar(140),
|
|
`subject` text,
|
|
`content_type` varchar(140),
|
|
`message` longtext,
|
|
`message_md` longtext,
|
|
`message_html` longtext,
|
|
`campaign` varchar(140),
|
|
`send_unsubscribe_link` int(1) not null default 1,
|
|
`send_webview_link` int(1) not null default 0,
|
|
`scheduled_to_send` int(11) not null default 0,
|
|
`schedule_sending` int(1) not null default 0,
|
|
`schedule_send` datetime(6),
|
|
`published` int(1) not null default 0,
|
|
`route` 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:08:52,761 WARNING database DDL Query made to DB:
|
|
create table `tabEmail Domain` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`domain_name` varchar(140) unique,
|
|
`email_server` varchar(140),
|
|
`use_imap` int(1) not null default 0,
|
|
`use_ssl` int(1) not null default 0,
|
|
`use_starttls` int(1) not null default 0,
|
|
`incoming_port` varchar(140),
|
|
`attachment_limit` int(11) not null default 0,
|
|
`smtp_server` varchar(140),
|
|
`use_tls` int(1) not null default 0,
|
|
`use_ssl_for_outgoing` int(1) not null default 0,
|
|
`smtp_port` varchar(140),
|
|
`append_emails_to_sent_folder` int(1) not null default 0,
|
|
`sent_folder_name` varchar(140) default 'Sent',
|
|
`_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:08:52,827 WARNING database DDL Query made to DB:
|
|
create table `tabUnhandled Email` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`email_account` varchar(140),
|
|
`uid` varchar(140),
|
|
`reason` longtext,
|
|
`message_id` longtext,
|
|
`raw` 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:08:52,966 WARNING database DDL Query made to DB:
|
|
create table `tabEmail 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',
|
|
`email_id` varchar(140) unique,
|
|
`email_account_name` varchar(140) unique,
|
|
`domain` varchar(140),
|
|
`service` varchar(140),
|
|
`auth_method` varchar(140) default 'Basic',
|
|
`backend_app_flow` int(1) not null default 0,
|
|
`password` text,
|
|
`awaiting_password` int(1) not null default 0,
|
|
`ascii_encode_password` int(1) not null default 0,
|
|
`connected_app` varchar(140),
|
|
`connected_user` varchar(140),
|
|
`login_id_is_different` int(1) not null default 0,
|
|
`login_id` varchar(140),
|
|
`enable_incoming` int(1) not null default 0,
|
|
`default_incoming` int(1) not null default 0,
|
|
`use_imap` int(1) not null default 0,
|
|
`use_ssl` int(1) not null default 0,
|
|
`use_starttls` int(1) not null default 0,
|
|
`email_server` varchar(140),
|
|
`incoming_port` varchar(140),
|
|
`attachment_limit` int(11) not null default 0,
|
|
`email_sync_option` varchar(140) default 'UNSEEN',
|
|
`initial_sync_count` varchar(140) default '250',
|
|
`append_emails_to_sent_folder` int(1) not null default 0,
|
|
`sent_folder_name` varchar(140),
|
|
`append_to` varchar(140),
|
|
`create_contact` int(1) not null default 1,
|
|
`enable_automatic_linking` int(1) not null default 0,
|
|
`notify_if_unreplied` int(1) not null default 0,
|
|
`unreplied_for_mins` int(11) not null default 30,
|
|
`send_notification_to` text,
|
|
`enable_outgoing` int(1) not null default 0,
|
|
`use_tls` int(1) not null default 0,
|
|
`use_ssl_for_outgoing` int(1) not null default 0,
|
|
`smtp_server` varchar(140),
|
|
`smtp_port` varchar(140),
|
|
`default_outgoing` int(1) not null default 0,
|
|
`always_use_account_email_id_as_sender` int(1) not null default 0,
|
|
`always_use_account_name_as_sender_name` int(1) not null default 0,
|
|
`send_unsubscribe_message` int(1) not null default 1,
|
|
`track_email_status` int(1) not null default 1,
|
|
`no_smtp_authentication` int(1) not null default 0,
|
|
`always_bcc` varchar(140),
|
|
`add_signature` int(1) not null default 0,
|
|
`signature` longtext,
|
|
`enable_auto_reply` int(1) not null default 0,
|
|
`auto_reply_message` longtext,
|
|
`footer` longtext,
|
|
`brand_logo` text,
|
|
`uidvalidity` varchar(140),
|
|
`uidnext` int(11) not null default 0,
|
|
`no_failed` int(11) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:53,032 WARNING database DDL Query made to DB:
|
|
create table `tabIMAP Folder` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`folder_name` varchar(140),
|
|
`append_to` varchar(140),
|
|
`uidvalidity` varchar(140),
|
|
`uidnext` 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:08:53,090 WARNING database DDL Query made to DB:
|
|
create table `tabEmail Queue Recipient` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`recipient` varchar(140),
|
|
`status` varchar(140) default 'Not Sent',
|
|
`error` longtext,
|
|
index `status`(`status`),
|
|
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:08:53,125 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabEmail Queue Recipient`
|
|
ADD INDEX IF NOT EXISTS `modified_index`(modified)
|
|
2025-05-20 13:08:53,176 WARNING database DDL Query made to DB:
|
|
create table `tabNewsletter Email 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',
|
|
`email_group` varchar(140),
|
|
`total_subscribers` 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:08:53,301 WARNING database DDL Query made to DB:
|
|
create table `tabCustomize Form Field` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`is_system_generated` int(1) not null default 0,
|
|
`label` varchar(140),
|
|
`fieldtype` varchar(140) default 'Data',
|
|
`fieldname` varchar(140),
|
|
`non_negative` int(1) not null default 0,
|
|
`reqd` int(1) not null default 0,
|
|
`unique` int(1) not null default 0,
|
|
`is_virtual` int(1) not null default 0,
|
|
`in_list_view` int(1) not null default 0,
|
|
`in_standard_filter` int(1) not null default 0,
|
|
`in_global_search` int(1) not null default 0,
|
|
`in_preview` int(1) not null default 0,
|
|
`bold` int(1) not null default 0,
|
|
`no_copy` int(1) not null default 0,
|
|
`allow_in_quick_entry` int(1) not null default 0,
|
|
`translatable` int(1) not null default 1,
|
|
`link_filters` json,
|
|
`default` text,
|
|
`precision` varchar(140),
|
|
`length` int(11) not null default 0,
|
|
`options` text,
|
|
`sort_options` int(1) not null default 0,
|
|
`fetch_from` text,
|
|
`fetch_if_empty` int(1) not null default 0,
|
|
`show_dashboard` int(1) not null default 0,
|
|
`depends_on` longtext,
|
|
`permlevel` int(11) not null default 0,
|
|
`hidden` int(1) not null default 0,
|
|
`read_only` int(1) not null default 0,
|
|
`collapsible` int(1) not null default 0,
|
|
`allow_bulk_edit` int(1) not null default 0,
|
|
`collapsible_depends_on` longtext,
|
|
`ignore_user_permissions` int(1) not null default 0,
|
|
`allow_on_submit` int(1) not null default 0,
|
|
`report_hide` int(1) not null default 0,
|
|
`remember_last_selected_value` int(1) not null default 0,
|
|
`hide_border` int(1) not null default 0,
|
|
`ignore_xss_filter` int(1) not null default 0,
|
|
`mandatory_depends_on` longtext,
|
|
`read_only_depends_on` longtext,
|
|
`in_filter` int(1) not null default 0,
|
|
`hide_seconds` int(1) not null default 0,
|
|
`hide_days` int(1) not null default 0,
|
|
`description` text,
|
|
`placeholder` varchar(140),
|
|
`print_hide` int(1) not null default 0,
|
|
`print_hide_if_no_value` int(1) not null default 0,
|
|
`print_width` varchar(140),
|
|
`columns` int(11) not null default 0,
|
|
`width` varchar(140),
|
|
`is_custom_field` int(1) not null default 0,
|
|
index `label`(`label`),
|
|
index `fieldtype`(`fieldtype`),
|
|
index `fieldname`(`fieldname`),
|
|
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:08:53,493 WARNING database DDL Query made to DB:
|
|
create table `tabDocType Layout` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`route` varchar(140),
|
|
`client_script` longtext,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:53,569 WARNING database DDL Query made to DB:
|
|
create table `tabDocType Layout 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',
|
|
`label` varchar(140),
|
|
`fieldname` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:53,954 WARNING database DDL Query made to DB:
|
|
create table `tabCountry` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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_name` varchar(140) unique,
|
|
`date_format` varchar(140),
|
|
`time_format` varchar(140) default 'HH:mm:ss',
|
|
`time_zones` text,
|
|
`code` 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:08:54,153 WARNING database DDL Query made to DB:
|
|
create table `tabCurrency` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`currency_name` varchar(140) unique,
|
|
`enabled` int(1) not null default 0,
|
|
`fraction` varchar(140),
|
|
`fraction_units` int(11) not null default 0,
|
|
`smallest_currency_fraction_value` decimal(21,9) not null default 0,
|
|
`symbol` varchar(140),
|
|
`symbol_on_right` int(1) not null default 0,
|
|
`number_format` 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:08:54,283 WARNING database DDL Query made to DB:
|
|
create table `tabDesktop Icon` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`module_name` varchar(140),
|
|
`label` varchar(140),
|
|
`standard` int(1) not null default 0,
|
|
`custom` int(1) not null default 0,
|
|
`app` varchar(140),
|
|
`description` text,
|
|
`category` varchar(140),
|
|
`hidden` int(1) not null default 0,
|
|
`blocked` int(1) not null default 0,
|
|
`force_show` int(1) not null default 0,
|
|
`type` varchar(140),
|
|
`_doctype` varchar(140),
|
|
`_report` varchar(140),
|
|
`link` text,
|
|
`color` varchar(140),
|
|
`icon` varchar(140),
|
|
`reverse` 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:08:54,340 WARNING database DDL Query made to DB:
|
|
alter table `tabDesktop Icon`
|
|
add unique `unique_module_name_owner_standard`(module_name, owner, standard)
|
|
2025-05-20 13:08:54,494 WARNING database DDL Query made to DB:
|
|
create table `tabList Filter` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`filter_name` varchar(140),
|
|
`reference_doctype` varchar(140),
|
|
`for_user` varchar(140),
|
|
`filters` 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:08:54,590 WARNING database DDL Query made to DB:
|
|
create table `tabNotification Subscribed Document` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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` 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:08:54,643 WARNING database DDL Query made to DB:
|
|
create table `tabDashboard Settings` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`user` varchar(140),
|
|
`chart_config` 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:08:54,701 WARNING database DDL Query made to DB:
|
|
create table `tabConsole 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',
|
|
`script` longtext,
|
|
`type` varchar(140),
|
|
`committed` 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:08:54,766 WARNING database DDL Query made to DB:
|
|
create table `tabTag Link` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`document_type` varchar(140),
|
|
`document_name` varchar(140),
|
|
`tag` varchar(140),
|
|
`title` 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:08:54,803 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTag Link`
|
|
ADD INDEX IF NOT EXISTS `document_type_document_name_index`(document_type, document_name)
|
|
2025-05-20 13:08:54,861 WARNING database DDL Query made to DB:
|
|
create table `tabList View Settings` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`disable_count` int(1) not null default 0,
|
|
`disable_comment_count` int(1) not null default 0,
|
|
`disable_sidebar_stats` int(1) not null default 0,
|
|
`disable_auto_refresh` int(1) not null default 0,
|
|
`allow_edit` int(1) not null default 0,
|
|
`disable_automatic_recency_filters` int(1) not null default 0,
|
|
`total_fields` varchar(140),
|
|
`fields` 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:08:54,965 WARNING database DDL Query made to DB:
|
|
create table `tabChangelog Feed` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`app_name` varchar(140),
|
|
`link` longtext,
|
|
`posting_timestamp` datetime(6),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `posting_timestamp`(`posting_timestamp`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:55,041 WARNING database DDL Query made to DB:
|
|
create table `tabToDo` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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) default 'Open',
|
|
`priority` varchar(140) default 'Medium',
|
|
`color` varchar(140),
|
|
`date` date,
|
|
`allocated_to` varchar(140),
|
|
`description` longtext,
|
|
`reference_type` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`role` varchar(140),
|
|
`assigned_by` varchar(140),
|
|
`assigned_by_full_name` varchar(140),
|
|
`sender` varchar(140),
|
|
`assignment_rule` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:55,074 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabToDo`
|
|
ADD INDEX IF NOT EXISTS `reference_type_reference_name_index`(reference_type, reference_name)
|
|
2025-05-20 13:08:55,115 WARNING database DDL Query made to DB:
|
|
create table `tabRoute History` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`route` varchar(140),
|
|
`user` 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:08:55,171 WARNING database DDL Query made to DB:
|
|
create table `tabDashboard Chart 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',
|
|
`y_field` varchar(140),
|
|
`color` 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:08:55,247 WARNING database DDL Query made to DB:
|
|
create table `tabKanban Board` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`kanban_board_name` varchar(140) unique,
|
|
`reference_doctype` varchar(140),
|
|
`field_name` varchar(140),
|
|
`private` int(1) not null default 0,
|
|
`show_labels` int(1) not null default 0,
|
|
`filters` longtext,
|
|
`fields` 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:08:55,321 WARNING database DDL Query made to DB:
|
|
create table `tabCustom HTML Block` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`private` int(1) not null default 0,
|
|
`html` longtext,
|
|
`script` longtext,
|
|
`style` 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:08:55,424 WARNING database DDL Query made to DB:
|
|
create table `tabDashboard Chart Link` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`chart` varchar(140),
|
|
`width` varchar(140) default 'Half',
|
|
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:08:55,564 WARNING database DDL Query made to DB:
|
|
create table `tabKanban Board Column` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`column_name` varchar(140),
|
|
`status` varchar(140) default 'Active',
|
|
`indicator` varchar(140) default 'Gray',
|
|
`order` 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:08:55,697 WARNING database DDL Query made to DB:
|
|
create table `tabNote Seen By` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`user` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:55,874 WARNING database DDL Query made to DB:
|
|
create table `tabNotification 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',
|
|
`subject` text,
|
|
`for_user` varchar(140),
|
|
`type` varchar(140),
|
|
`email_content` longtext,
|
|
`document_type` varchar(140),
|
|
`read` int(1) not null default 0,
|
|
`document_name` varchar(140),
|
|
`attached_file` longtext,
|
|
`from_user` varchar(140),
|
|
`link` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index `for_user`(`for_user`),
|
|
index `document_name`(`document_name`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:55,924 WARNING database DDL Query made to DB:
|
|
create table `tabGlobal Search DocType` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`document_type` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:55,981 WARNING database DDL Query made to DB:
|
|
create table `tabNumber Card Link` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`card` 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:08:56,079 WARNING database DDL Query made to DB:
|
|
create table `tabEvent` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`subject` text,
|
|
`event_category` varchar(140),
|
|
`event_type` varchar(140),
|
|
`color` varchar(140),
|
|
`send_reminder` int(1) not null default 1,
|
|
`repeat_this_event` int(1) not null default 0,
|
|
`starts_on` datetime(6),
|
|
`ends_on` datetime(6),
|
|
`status` varchar(140) default 'Open',
|
|
`sender` varchar(140),
|
|
`all_day` int(1) not null default 0,
|
|
`sync_with_google_calendar` int(1) not null default 0,
|
|
`add_video_conferencing` int(1) not null default 0,
|
|
`google_calendar` varchar(140),
|
|
`google_calendar_id` varchar(140),
|
|
`google_calendar_event_id` varchar(320),
|
|
`google_meet_link` text,
|
|
`pulled_from_google_calendar` int(1) not null default 0,
|
|
`repeat_on` varchar(140),
|
|
`repeat_till` date,
|
|
`monday` int(1) not null default 0,
|
|
`tuesday` int(1) not null default 0,
|
|
`wednesday` int(1) not null default 0,
|
|
`thursday` int(1) not null default 0,
|
|
`friday` int(1) not null default 0,
|
|
`saturday` int(1) not null default 0,
|
|
`sunday` int(1) not null default 0,
|
|
`description` longtext,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index `event_type`(`event_type`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:56,154 WARNING database DDL Query made to DB:
|
|
create table `tabNotification Settings` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`enabled` int(1) not null default 1,
|
|
`enable_email_notifications` int(1) not null default 1,
|
|
`enable_email_mention` int(1) not null default 1,
|
|
`enable_email_assignment` int(1) not null default 1,
|
|
`enable_email_threads_on_assigned_document` int(1) not null default 1,
|
|
`enable_email_energy_point` int(1) not null default 1,
|
|
`enable_email_share` int(1) not null default 1,
|
|
`enable_email_event_reminders` int(1) not null default 1,
|
|
`user` varchar(140),
|
|
`seen` int(1) not null default 0,
|
|
`energy_points_system_notifications` int(1) not null default 1,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:56,211 WARNING database DDL Query made to DB:
|
|
create table `tabTag` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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:08:56,270 WARNING database DDL Query made to DB:
|
|
create table `tabCalendar View` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`reference_doctype` varchar(140),
|
|
`subject_field` varchar(140),
|
|
`start_date_field` varchar(140),
|
|
`end_date_field` varchar(140),
|
|
`all_day` 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:08:56,341 WARNING database DDL Query made to DB:
|
|
create table `tabNote` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`public` int(1) not null default 0,
|
|
`notify_on_login` int(1) not null default 0,
|
|
`notify_on_every_login` int(1) not null default 0,
|
|
`expire_notification_on` date,
|
|
`content` longtext,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `expire_notification_on`(`expire_notification_on`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:56,443 WARNING database DDL Query made to DB:
|
|
create table `tabEvent Participants` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`reference_doctype` varchar(140),
|
|
`reference_docname` varchar(140),
|
|
`email` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:56,626 WARNING database DDL Query made to DB:
|
|
create table `tabSlack Webhook URL` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`webhook_name` varchar(140) unique,
|
|
`webhook_url` varchar(140),
|
|
`show_document_link` int(1) not null default 1,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:57,394 WARNING database DDL Query made to DB:
|
|
create table `tabGoogle Contacts` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`enable` int(1) not null default 0,
|
|
`email_id` varchar(140),
|
|
`last_sync_on` datetime(6),
|
|
`authorization_code` text,
|
|
`refresh_token` text,
|
|
`next_sync_token` text,
|
|
`pull_from_google_contacts` int(1) not null default 0,
|
|
`push_to_google_contacts` 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:08:57,846 WARNING database DDL Query made to DB:
|
|
create table `tabOAuth Client` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`client_id` varchar(140),
|
|
`app_name` varchar(140),
|
|
`user` varchar(140),
|
|
`client_secret` varchar(140),
|
|
`skip_authorization` int(1) not null default 0,
|
|
`scopes` text default 'all openid',
|
|
`redirect_uris` text,
|
|
`default_redirect_uri` varchar(140),
|
|
`grant_type` varchar(140),
|
|
`response_type` varchar(140) default 'Code',
|
|
`_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:08:57,916 WARNING database DDL Query made to DB:
|
|
create table `tabWebhook Request 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',
|
|
`webhook` varchar(140),
|
|
`reference_document` varchar(140),
|
|
`headers` longtext,
|
|
`data` longtext,
|
|
`user` varchar(140),
|
|
`url` text,
|
|
`response` longtext,
|
|
`error` 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:08:57,983 WARNING database DDL Query made to DB:
|
|
create table `tabWebhook Header` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`key` text,
|
|
`value` text,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:58,057 WARNING database DDL Query made to DB:
|
|
create table `tabOAuth Authorization Code` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`client` varchar(140),
|
|
`user` varchar(140),
|
|
`scopes` text,
|
|
`authorization_code` varchar(140) unique,
|
|
`expiration_time` datetime(6),
|
|
`redirect_uri_bound_to_authorization_code` varchar(140),
|
|
`validity` varchar(140),
|
|
`nonce` varchar(140),
|
|
`code_challenge` varchar(140),
|
|
`code_challenge_method` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:58,139 WARNING database DDL Query made to DB:
|
|
create table `tabConnected App` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`provider_name` varchar(140),
|
|
`openid_configuration` varchar(140),
|
|
`client_id` varchar(140),
|
|
`redirect_uri` varchar(140),
|
|
`client_secret` text,
|
|
`authorization_uri` text,
|
|
`token_uri` varchar(140),
|
|
`revocation_uri` varchar(140),
|
|
`userinfo_uri` varchar(140),
|
|
`introspection_uri` 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:08:58,296 WARNING database DDL Query made to DB:
|
|
create table `tabQuery Parameters` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`key` varchar(140),
|
|
`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:08:58,351 WARNING database DDL Query made to DB:
|
|
create table `tabOAuth Client Role` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`role` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:58,417 WARNING database DDL Query made to DB:
|
|
create table `tabToken Cache` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`connected_app` varchar(140),
|
|
`provider_name` varchar(140),
|
|
`access_token` text,
|
|
`refresh_token` text,
|
|
`expires_in` int(11) not null default 0,
|
|
`state` varchar(140),
|
|
`success_uri` varchar(140),
|
|
`token_type` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:58,475 WARNING database DDL Query made to DB:
|
|
create table `tabOAuth Scope` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`scope` 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:08:58,546 WARNING database DDL Query made to DB:
|
|
create table `tabOAuth Bearer Token` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`client` varchar(140),
|
|
`user` varchar(140),
|
|
`scopes` text,
|
|
`access_token` varchar(140) unique,
|
|
`refresh_token` varchar(140),
|
|
`expiration_time` datetime(6),
|
|
`expires_in` int(11) not null default 0,
|
|
`status` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:58,638 WARNING database DDL Query made to DB:
|
|
create table `tabWebhook` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`webhook_doctype` varchar(140),
|
|
`webhook_docevent` varchar(140),
|
|
`enabled` int(1) not null default 1,
|
|
`condition` text,
|
|
`request_url` text,
|
|
`is_dynamic_url` int(1) not null default 0,
|
|
`timeout` int(11) not null default 5,
|
|
`background_jobs_queue` varchar(140),
|
|
`request_method` varchar(140) default 'POST',
|
|
`request_structure` varchar(140),
|
|
`enable_security` int(1) not null default 0,
|
|
`webhook_secret` text,
|
|
`webhook_json` longtext,
|
|
`preview_document` 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:08:58,703 WARNING database DDL Query made to DB:
|
|
create table `tabWebhook Data` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`fieldname` varchar(140),
|
|
`key` 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:08:58,840 WARNING database DDL Query made to DB:
|
|
create table `tabLDAP Group Mapping` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`ldap_group` varchar(140),
|
|
`erpnext_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:08:58,920 WARNING database DDL Query made to DB:
|
|
create table `tabSocial Login Key` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`enable_social_login` int(1) not null default 0,
|
|
`social_login_provider` varchar(140) default 'Custom',
|
|
`client_id` varchar(140),
|
|
`provider_name` varchar(140),
|
|
`client_secret` text,
|
|
`icon` varchar(140),
|
|
`base_url` varchar(140),
|
|
`sign_ups` varchar(140),
|
|
`authorize_url` varchar(140),
|
|
`access_token_url` varchar(140),
|
|
`redirect_url` varchar(140),
|
|
`api_endpoint` varchar(140),
|
|
`custom_base_url` int(1) not null default 0,
|
|
`api_endpoint_args` longtext,
|
|
`auth_url_data` longtext,
|
|
`user_id_property` 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:08:59,007 WARNING database DDL Query made to DB:
|
|
create table `tabIntegration 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',
|
|
`request_id` varchar(140),
|
|
`integration_request_service` varchar(140),
|
|
`is_remote_request` int(1) not null default 0,
|
|
`request_description` varchar(140),
|
|
`status` varchar(140) default 'Queued',
|
|
`url` text,
|
|
`request_headers` longtext,
|
|
`data` longtext,
|
|
`output` longtext,
|
|
`error` longtext,
|
|
`reference_doctype` varchar(140),
|
|
`reference_docname` 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:08:59,084 WARNING database DDL Query made to DB:
|
|
create table `tabGoogle Calendar` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`enable` int(1) not null default 1,
|
|
`calendar_name` varchar(140) unique,
|
|
`user` varchar(140),
|
|
`pull_from_google_calendar` int(1) not null default 1,
|
|
`sync_as_public` int(1) not null default 0,
|
|
`push_to_google_calendar` int(1) not null default 1,
|
|
`google_calendar_id` varchar(140),
|
|
`refresh_token` text,
|
|
`authorization_code` text,
|
|
`next_sync_token` 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:08:59,217 WARNING database DDL Query made to DB:
|
|
create table `tabNetwork Printer Settings` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`server_ip` varchar(140) default 'localhost',
|
|
`port` int(11) not null default 631,
|
|
`printer_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:08:59,462 WARNING database DDL Query made to DB:
|
|
create table `tabPrint Heading` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`print_heading` varchar(140),
|
|
`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:08:59,532 WARNING database DDL Query made to DB:
|
|
create table `tabPrint Format Field 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',
|
|
`document_type` varchar(140),
|
|
`field` varchar(140),
|
|
`template_file` varchar(140),
|
|
`module` varchar(140),
|
|
`standard` int(1) not null default 0,
|
|
`template` longtext,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:59,619 WARNING database DDL Query made to DB:
|
|
create table `tabLetter Head` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`letter_head_name` varchar(140) unique,
|
|
`source` varchar(140),
|
|
`footer_source` varchar(140) default 'HTML',
|
|
`disabled` int(1) not null default 0,
|
|
`is_default` int(1) not null default 0,
|
|
`image` text,
|
|
`image_height` decimal(21,9) not null default 0,
|
|
`image_width` decimal(21,9) not null default 0,
|
|
`align` varchar(140) default 'Left',
|
|
`content` longtext,
|
|
`footer` longtext,
|
|
`footer_image` text,
|
|
`footer_image_height` decimal(21,9) not null default 0,
|
|
`footer_image_width` decimal(21,9) not null default 0,
|
|
`footer_align` varchar(140),
|
|
`header_script` longtext,
|
|
`footer_script` longtext,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `is_default`(`is_default`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:08:59,879 WARNING database DDL Query made to DB:
|
|
create table `tabAddress` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`address_title` varchar(140),
|
|
`address_type` varchar(140),
|
|
`address_line1` varchar(240),
|
|
`address_line2` varchar(240),
|
|
`city` varchar(140),
|
|
`county` varchar(140),
|
|
`state` varchar(140),
|
|
`country` varchar(140),
|
|
`pincode` varchar(140),
|
|
`email_id` varchar(140),
|
|
`phone` varchar(140),
|
|
`fax` varchar(140),
|
|
`is_primary_address` int(1) not null default 0,
|
|
`is_shipping_address` int(1) not null default 0,
|
|
`disabled` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `city`(`city`),
|
|
index `country`(`country`),
|
|
index `pincode`(`pincode`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:00,170 WARNING database DDL Query made to DB:
|
|
create table `tabAddress 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',
|
|
`country` varchar(140) unique,
|
|
`is_default` int(1) not null default 0,
|
|
`template` longtext,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:00,230 WARNING database DDL Query made to DB:
|
|
create table `tabSalutation` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`salutation` 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:09:00,293 WARNING database DDL Query made to DB:
|
|
create table `tabGender` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`gender` 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:09:00,353 WARNING database DDL Query made to DB:
|
|
create table `tabContact Email` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`email_id` varchar(140),
|
|
`is_primary` 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:09:00,453 WARNING database DDL Query made to DB:
|
|
create table `tabContact` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`first_name` varchar(140),
|
|
`middle_name` varchar(140),
|
|
`last_name` varchar(140),
|
|
`full_name` varchar(140),
|
|
`email_id` varchar(140),
|
|
`user` varchar(140),
|
|
`address` varchar(140),
|
|
`sync_with_google_contacts` int(1) not null default 0,
|
|
`status` varchar(140) default 'Passive',
|
|
`salutation` varchar(140),
|
|
`designation` varchar(140),
|
|
`gender` varchar(140),
|
|
`phone` varchar(140),
|
|
`mobile_no` varchar(140),
|
|
`company_name` varchar(140),
|
|
`image` text,
|
|
`google_contacts` varchar(140),
|
|
`google_contacts_id` varchar(140),
|
|
`pulled_from_google_contacts` int(1) not null default 0,
|
|
`is_primary_contact` int(1) not null default 0,
|
|
`department` varchar(140),
|
|
`unsubscribed` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `email_id`(`email_id`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:00,546 WARNING database DDL Query made to DB:
|
|
create table `tabContact Phone` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`phone` varchar(140),
|
|
`is_primary_phone` int(1) not null default 0,
|
|
`is_primary_mobile_no` 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:09:00,645 WARNING database DDL Query made to DB:
|
|
create table `tabReview Level` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`level_name` varchar(140) unique,
|
|
`role` varchar(140) unique,
|
|
`review_points` int(11) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:00,840 WARNING database DDL Query made to DB:
|
|
create table `tabEnergy Point 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',
|
|
`enabled` int(1) not null default 1,
|
|
`rule_name` varchar(140) unique,
|
|
`reference_doctype` varchar(140),
|
|
`for_doc_event` varchar(140) default 'Custom',
|
|
`field_to_check` varchar(140),
|
|
`points` int(11) not null default 0,
|
|
`for_assigned_users` int(1) not null default 0,
|
|
`user_field` varchar(140),
|
|
`multiplier_field` varchar(140),
|
|
`max_points` int(11) not null default 0,
|
|
`apply_only_once` int(1) not null default 0,
|
|
`condition` 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:09:00,964 WARNING database DDL Query made to DB:
|
|
create table `tabEnergy Point 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',
|
|
`user` varchar(140),
|
|
`type` varchar(140),
|
|
`points` int(11) not null default 0,
|
|
`rule` varchar(140),
|
|
`reference_doctype` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`reverted` int(1) not null default 0,
|
|
`revert_of` varchar(140),
|
|
`reason` text,
|
|
`seen` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `user`(`user`),
|
|
index `reference_name`(`reference_name`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:01,019 WARNING database DDL Query made to DB:
|
|
create table `tabAssignment Rule 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),
|
|
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:09:01,230 WARNING database DDL Query made to DB:
|
|
create table `tabReminder` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`remind_at` datetime(6),
|
|
`description` text,
|
|
`reminder_doctype` varchar(140),
|
|
`reminder_docname` varchar(140),
|
|
`notified` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `user`(`user`),
|
|
index `remind_at`(`remind_at`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:01,320 WARNING database DDL Query made to DB:
|
|
create table `tabMilestone Tracker` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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) unique,
|
|
`track_field` varchar(140),
|
|
`disabled` 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:09:01,396 WARNING database DDL Query made to DB:
|
|
create table `tabMilestone` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`reference_type` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`track_field` varchar(140),
|
|
`value` varchar(140),
|
|
`milestone_tracker` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `reference_type`(`reference_type`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:01,436 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabMilestone`
|
|
ADD INDEX IF NOT EXISTS `reference_type_reference_name_index`(reference_type, reference_name)
|
|
2025-05-20 13:09:01,480 WARNING database DDL Query made to DB:
|
|
create table `tabAssignment Rule 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',
|
|
`day` 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:09:01,566 WARNING database DDL Query made to DB:
|
|
create table `tabAuto Repeat` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`reference_doctype` varchar(140),
|
|
`reference_document` varchar(140),
|
|
`submit_on_creation` int(1) not null default 0,
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`disabled` int(1) not null default 0,
|
|
`frequency` varchar(140),
|
|
`repeat_on_day` int(11) not null default 0,
|
|
`repeat_on_last_day` int(1) not null default 0,
|
|
`next_schedule_date` date,
|
|
`notify_by_email` int(1) not null default 0,
|
|
`recipients` text,
|
|
`template` varchar(140),
|
|
`subject` varchar(140),
|
|
`message` text default 'Please find attached {{ doc.doctype }} #{{ doc.name }}',
|
|
`print_format` varchar(140),
|
|
`status` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `next_schedule_date`(`next_schedule_date`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:01,659 WARNING database DDL Query made to DB:
|
|
create table `tabAssignment Rule` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`document_type` varchar(140),
|
|
`due_date_based_on` varchar(140),
|
|
`priority` int(11) not null default 0,
|
|
`disabled` int(1) not null default 0,
|
|
`description` text default 'Automatic Assignment',
|
|
`assign_condition` longtext,
|
|
`unassign_condition` longtext,
|
|
`close_condition` longtext,
|
|
`rule` varchar(140),
|
|
`field` varchar(140),
|
|
`last_user` 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:09:01,721 WARNING database DDL Query made to DB:
|
|
create table `tabAuto Repeat 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',
|
|
`day` 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:09:50,653 WARNING database DDL Query made to DB:
|
|
create table `tabCampaign 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',
|
|
`campaign` 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:09:50,716 WARNING database DDL Query made to DB:
|
|
create table `tabPayment Entry Deduction` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`account` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`amount` decimal(21,9) not null default 0,
|
|
`is_exchange_gain_loss` int(1) not null default 0,
|
|
`description` text,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:50,786 WARNING database DDL Query made to DB:
|
|
create table `tabBank` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`bank_name` varchar(140) unique,
|
|
`swift_number` varchar(140) unique,
|
|
`website` varchar(140),
|
|
`plaid_access_token` 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:09:50,843 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Invoice Reference` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`pos_invoice` varchar(140),
|
|
`posting_date` date,
|
|
`customer` varchar(140),
|
|
`grand_total` decimal(21,9) not null default 0,
|
|
`is_return` int(1) not null default 0,
|
|
`return_against` 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:09:50,913 WARNING database DDL Query made to DB:
|
|
create table `tabSubscription Plan` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`plan_name` varchar(140) unique,
|
|
`currency` varchar(140),
|
|
`item` varchar(140),
|
|
`price_determination` varchar(140),
|
|
`cost` decimal(21,9) not null default 0,
|
|
`price_list` varchar(140),
|
|
`billing_interval` varchar(140) default 'Day',
|
|
`billing_interval_count` int(11) not null default 1,
|
|
`product_price_id` varchar(140),
|
|
`payment_gateway` 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:09:51,046 WARNING database DDL Query made to DB:
|
|
create table `tabAccounting Dimension 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',
|
|
`company` varchar(140),
|
|
`reference_document` varchar(140),
|
|
`default_dimension` varchar(140),
|
|
`mandatory_for_bs` int(1) not null default 0,
|
|
`mandatory_for_pl` int(1) not null default 0,
|
|
`automatically_post_balancing_accounting_entry` int(1) not null default 0,
|
|
`offsetting_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:09:51,104 WARNING database DDL Query made to DB:
|
|
create table `tabMonthly Distribution Percentage` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`month` varchar(140),
|
|
`percentage_allocation` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:51,157 WARNING database DDL Query made to DB:
|
|
create table `tabShipping Rule 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:09:51,241 WARNING database DDL Query made to DB:
|
|
create table `tabProcess Payment Reconciliation Log Allocations` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`reference_type` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`reference_row` varchar(140),
|
|
`invoice_type` varchar(140),
|
|
`invoice_number` varchar(140),
|
|
`allocated_amount` decimal(21,9) not null default 0,
|
|
`unreconciled_amount` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`is_advance` varchar(140),
|
|
`difference_amount` decimal(21,9) not null default 0,
|
|
`gain_loss_posting_date` date,
|
|
`difference_account` varchar(140),
|
|
`exchange_rate` decimal(21,9) not null default 0,
|
|
`currency` varchar(140),
|
|
`reconciled` 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:09:51,304 WARNING database DDL Query made to DB:
|
|
create table `tabAdvance 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',
|
|
`reference_type` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`reference_detail` varchar(140),
|
|
`account_head` varchar(140),
|
|
`allocated_amount` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:51,359 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Opening 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',
|
|
`mode_of_payment` varchar(140),
|
|
`opening_amount` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:51,438 WARNING database DDL Query made to DB:
|
|
create table `tabAdvance 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',
|
|
`add_deduct_tax` varchar(140),
|
|
`charge_type` varchar(140),
|
|
`row_id` varchar(140),
|
|
`account_head` varchar(140),
|
|
`description` text,
|
|
`included_in_paid_amount` int(1) not null default 0,
|
|
`cost_center` varchar(140),
|
|
`rate` decimal(21,9) not null default 0,
|
|
`currency` varchar(140),
|
|
`tax_amount` decimal(21,9) not null default 0,
|
|
`total` decimal(21,9) not null default 0,
|
|
`allocated_amount` decimal(21,9) not null default 0,
|
|
`base_tax_amount` decimal(21,9) not null default 0,
|
|
`base_total` decimal(21,9) not null default 0,
|
|
index `account_head`(`account_head`),
|
|
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:09:51,525 WARNING database DDL Query made to DB:
|
|
create table `tabLoyalty Program` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`loyalty_program_name` varchar(140) unique,
|
|
`loyalty_program_type` varchar(140),
|
|
`from_date` date,
|
|
`to_date` date,
|
|
`customer_group` varchar(140),
|
|
`customer_territory` varchar(140),
|
|
`auto_opt_in` int(1) not null default 0,
|
|
`conversion_factor` decimal(21,9) not null default 0,
|
|
`expiry_duration` int(11) not null default 0,
|
|
`expense_account` varchar(140),
|
|
`company` 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:09:51,619 WARNING database DDL Query made to DB:
|
|
create table `tabPayment Terms Template 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',
|
|
`payment_term` varchar(140),
|
|
`description` text,
|
|
`invoice_portion` decimal(21,9) not null default 0,
|
|
`mode_of_payment` varchar(140),
|
|
`due_date_based_on` varchar(140),
|
|
`credit_days` int(11) not null default 0,
|
|
`credit_months` int(11) not null default 0,
|
|
`discount_type` varchar(140) default 'Percentage',
|
|
`discount` decimal(21,9) not null default 0,
|
|
`discount_validity_based_on` varchar(140) default 'Day(s) after invoice date',
|
|
`discount_validity` int(11) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:51,680 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Search Fields` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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` varchar(140),
|
|
`fieldname` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:51,801 WARNING database DDL Query made to DB:
|
|
create table `tabOpening Invoice Creation Tool 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',
|
|
`invoice_number` varchar(140),
|
|
`party_type` varchar(140),
|
|
`party` varchar(140),
|
|
`temporary_opening_account` varchar(140),
|
|
`posting_date` date,
|
|
`due_date` date,
|
|
`item_name` varchar(140) default 'Opening Invoice Item',
|
|
`outstanding_amount` decimal(21,9) not null default 0,
|
|
`qty` varchar(140) default '1',
|
|
`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:09:51,868 WARNING database DDL Query made to DB:
|
|
create table `tabAccounting 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',
|
|
`document_type` varchar(140),
|
|
`label` varchar(140) unique,
|
|
`fieldname` varchar(140),
|
|
`disabled` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `document_type`(`document_type`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:52,020 WARNING database DDL Query made to DB:
|
|
create table `tabCoupon Code` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`coupon_name` varchar(140) unique,
|
|
`coupon_type` varchar(140),
|
|
`customer` varchar(140),
|
|
`coupon_code` varchar(140) unique,
|
|
`pricing_rule` varchar(140),
|
|
`valid_from` date,
|
|
`valid_upto` date,
|
|
`maximum_use` int(11) not null default 0,
|
|
`used` int(11) not null default 0,
|
|
`description` longtext,
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:52,106 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Invoice Merge 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',
|
|
`posting_date` date,
|
|
`posting_time` time(6),
|
|
`merge_invoices_based_on` varchar(140),
|
|
`pos_closing_entry` varchar(140),
|
|
`customer` varchar(140),
|
|
`customer_group` varchar(140),
|
|
`consolidated_invoice` varchar(140),
|
|
`consolidated_credit_note` 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:09:52,201 WARNING database DDL Query made to DB:
|
|
create table `tabShipping 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',
|
|
`label` varchar(140) unique,
|
|
`disabled` int(1) not null default 0,
|
|
`shipping_rule_type` varchar(140),
|
|
`company` varchar(140),
|
|
`account` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`calculate_based_on` varchar(140) default 'Fixed',
|
|
`shipping_amount` decimal(21,9) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:52,273 WARNING database DDL Query made to DB:
|
|
create table `tabPSOA Cost Center` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`cost_center_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:09:52,333 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Closing Entry Taxes` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`account_head` varchar(140),
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:52,395 WARNING database DDL Query made to DB:
|
|
create table `tabBank Account 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',
|
|
`account_type` 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:09:52,462 WARNING database DDL Query made to DB:
|
|
create table `tabParty Account` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company` varchar(140),
|
|
`account` varchar(140),
|
|
`advance_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:09:52,651 WARNING database DDL Query made to DB:
|
|
create table `tabGL Entry` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`posting_date` date,
|
|
`transaction_date` date,
|
|
`fiscal_year` varchar(140),
|
|
`due_date` date,
|
|
`account` varchar(140),
|
|
`account_currency` varchar(140),
|
|
`against` text,
|
|
`party_type` varchar(140),
|
|
`party` varchar(140),
|
|
`voucher_type` varchar(140),
|
|
`voucher_no` varchar(140),
|
|
`voucher_subtype` text,
|
|
`transaction_currency` varchar(140),
|
|
`against_voucher_type` varchar(140),
|
|
`against_voucher` varchar(140),
|
|
`voucher_detail_no` varchar(140),
|
|
`transaction_exchange_rate` decimal(21,9) not null default 0,
|
|
`debit_in_account_currency` decimal(21,9) not null default 0,
|
|
`debit` decimal(21,9) not null default 0,
|
|
`debit_in_transaction_currency` decimal(21,9) not null default 0,
|
|
`credit_in_account_currency` decimal(21,9) not null default 0,
|
|
`credit` decimal(21,9) not null default 0,
|
|
`credit_in_transaction_currency` decimal(21,9) not null default 0,
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`finance_book` varchar(140),
|
|
`company` varchar(140),
|
|
`is_opening` varchar(140),
|
|
`is_advance` varchar(140),
|
|
`to_rename` int(1) not null default 1,
|
|
`is_cancelled` int(1) not null default 0,
|
|
`remarks` text,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `posting_date`(`posting_date`),
|
|
index `account`(`account`),
|
|
index `party_type`(`party_type`),
|
|
index `party`(`party`),
|
|
index `voucher_no`(`voucher_no`),
|
|
index `against_voucher`(`against_voucher`),
|
|
index `voucher_detail_no`(`voucher_detail_no`),
|
|
index `company`(`company`),
|
|
index `to_rename`(`to_rename`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:52,820 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabGL Entry`
|
|
ADD INDEX IF NOT EXISTS `voucher_type_voucher_no_index`(voucher_type, voucher_no)
|
|
2025-05-20 13:09:52,842 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabGL Entry`
|
|
ADD INDEX IF NOT EXISTS `posting_date_company_index`(posting_date, company)
|
|
2025-05-20 13:09:52,863 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabGL Entry`
|
|
ADD INDEX IF NOT EXISTS `party_type_party_index`(party_type, party)
|
|
2025-05-20 13:09:52,906 WARNING database DDL Query made to DB:
|
|
create table `tabItem Tax Template 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',
|
|
`tax_type` varchar(140),
|
|
`tax_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:09:52,961 WARNING database DDL Query made to DB:
|
|
create table `tabCurrency Exchange Settings Details` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`key` varchar(140),
|
|
`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:09:53,226 WARNING database DDL Query made to DB:
|
|
create table `tabRepost Payment Ledger Items` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`voucher_type` varchar(140),
|
|
`voucher_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:09:53,287 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Closing 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',
|
|
`mode_of_payment` varchar(140),
|
|
`opening_amount` decimal(21,9) not null default 0,
|
|
`expected_amount` decimal(21,9) not null default 0,
|
|
`closing_amount` decimal(21,9) not null default 0,
|
|
`difference` 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:09:53,370 WARNING database DDL Query made to DB:
|
|
create table `tabExchange Rate Revaluation 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',
|
|
`account` varchar(140),
|
|
`party_type` varchar(140),
|
|
`party` varchar(140),
|
|
`account_currency` varchar(140),
|
|
`balance_in_account_currency` decimal(21,9) not null default 0,
|
|
`new_balance_in_account_currency` decimal(21,9) not null default 0,
|
|
`current_exchange_rate` decimal(21,9) not null default 0,
|
|
`new_exchange_rate` decimal(21,9) not null default 0,
|
|
`balance_in_base_currency` decimal(21,9) not null default 0,
|
|
`new_balance_in_base_currency` decimal(21,9) not null default 0,
|
|
`gain_loss` decimal(21,9) not null default 0,
|
|
`zero_balance` 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:09:53,431 WARNING database DDL Query made to DB:
|
|
create table `tabTransaction Deletion Record Details` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`doctype_name` varchar(140),
|
|
`docfield_name` varchar(140),
|
|
`no_of_docs` int(11) not null default 0,
|
|
`done` 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:09:53,488 WARNING database DDL Query made to DB:
|
|
create table `tabFinance 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_name` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:09:53,560 WARNING database DDL Query made to DB:
|
|
create table `tabShare 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',
|
|
`title` varchar(140) unique,
|
|
`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
|