data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/kie-flyway/db/data-audit/h2/V1.0.0__CREATE DATA AUDIT SCHEMA.sql [44:86]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
create table Task_Instance_Deadline_Notification_Log (task_instance_deadline_log_id bigint not null, property_value varchar(255), property_name varchar(255) not null, primary key (task_instance_deadline_log_id, property_name));
create index ix_jel_pid on Job_Execution_Log (process_instance_id);
create index ix_jel_jid on Job_Execution_Log (job_id);
create index ix_jel_status on Job_Execution_Log (status);
create index ix_piel_pid on Process_Instance_Error_Log (process_instance_id);
create index ix_piel_key on Process_Instance_Error_Log (business_key);
create index ix_piel_event_date on Process_Instance_Error_Log (event_date);
create index ix_pinl_pid on Process_Instance_Node_Log (process_instance_id);
create index ix_pinl_key on Process_Instance_Node_Log (business_key);
create index ix_pinl_event_date on Process_Instance_Node_Log (event_date);
create index ix_pisl_pid on Process_Instance_State_Log (process_instance_id);
create index ix_pisl_state on Process_Instance_State_Log (state);
create index ix_pisl_key on Process_Instance_State_Log (business_key);
create index ix_pisl_event_date on Process_Instance_State_Log (event_date);
create index ix_pivl_pid on Process_Instance_Variable_Log (process_instance_id);
create index ix_pivl_key on Process_Instance_Variable_Log (business_key);
create index ix_pivl_event_date on Process_Instance_Variable_Log (event_date);
create index ix_pivl_var_id on Process_Instance_Variable_Log (variable_id);
create index ix_utasl_utid on Task_Instance_Assignment_Log (user_task_instance_id);
create index ix_utasl_pid on Task_Instance_Assignment_Log (process_instance_id);
create index ix_utasl_key on Task_Instance_Assignment_Log (business_key);
create index ix_utasl_event_date on Task_Instance_Assignment_Log (event_date);
create index ix_utatl_utid on Task_Instance_Attachment_Log (user_task_instance_id);
create index ix_utatl_pid on Task_Instance_Attachment_Log (process_instance_id);
create index ix_utatl_key on Task_Instance_Attachment_Log (business_key);
create index ix_utatl_event_date on Task_Instance_Attachment_Log (event_date);
create index ix_utcl_utid on Task_Instance_Comment_Log (user_task_instance_id);
create index ix_utcl_pid on Task_Instance_Comment_Log (process_instance_id);
create index ix_utcl_key on Task_Instance_Comment_Log (business_key);
create index ix_utcl_event_date on Task_Instance_Comment_Log (event_date);
create index ix_utdl_utid on Task_Instance_Deadline_Log (user_task_instance_id);
create index ix_utdl_pid on Task_Instance_Deadline_Log (process_instance_id);
create index ix_utdl_key on Task_Instance_Deadline_Log (business_key);
create index ix_utdl_event_date on Task_Instance_Deadline_Log (event_date);
create index ix_utsl_utid on Task_Instance_State_Log (user_task_instance_id);
create index ix_utsl_state on Task_Instance_State_Log (state);
create index ix_utsl_pid on Task_Instance_State_Log (process_instance_id);
create index ix_utsl_key on Task_Instance_State_Log (business_key);
create index ix_utsl_event_date on Task_Instance_State_Log (event_date);
create index ix_tavl_utid on Task_Instance_Variable_Log (user_task_instance_id);
create index ix_tavl_pid on Task_Instance_Variable_Log (process_instance_id);
create index ix_tavl_key on Task_Instance_Variable_Log (business_key);
create index ix_tavl_event_date on Task_Instance_Variable_Log (event_date);
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/kie-flyway/db/data-audit/postgresql/V1.0.0__CREATE DATA AUDIT SCHEMA.sql [44:86]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
create table Task_Instance_Deadline_Notification_Log (task_instance_deadline_log_id bigint not null, property_value varchar(255), property_name varchar(255) not null, primary key (task_instance_deadline_log_id, property_name));
create index ix_jel_pid on Job_Execution_Log (process_instance_id);
create index ix_jel_jid on Job_Execution_Log (job_id);
create index ix_jel_status on Job_Execution_Log (status);
create index ix_piel_pid on Process_Instance_Error_Log (process_instance_id);
create index ix_piel_key on Process_Instance_Error_Log (business_key);
create index ix_piel_event_date on Process_Instance_Error_Log (event_date);
create index ix_pinl_pid on Process_Instance_Node_Log (process_instance_id);
create index ix_pinl_key on Process_Instance_Node_Log (business_key);
create index ix_pinl_event_date on Process_Instance_Node_Log (event_date);
create index ix_pisl_pid on Process_Instance_State_Log (process_instance_id);
create index ix_pisl_state on Process_Instance_State_Log (state);
create index ix_pisl_key on Process_Instance_State_Log (business_key);
create index ix_pisl_event_date on Process_Instance_State_Log (event_date);
create index ix_pivl_pid on Process_Instance_Variable_Log (process_instance_id);
create index ix_pivl_key on Process_Instance_Variable_Log (business_key);
create index ix_pivl_event_date on Process_Instance_Variable_Log (event_date);
create index ix_pivl_var_id on Process_Instance_Variable_Log (variable_id);
create index ix_utasl_utid on Task_Instance_Assignment_Log (user_task_instance_id);
create index ix_utasl_pid on Task_Instance_Assignment_Log (process_instance_id);
create index ix_utasl_key on Task_Instance_Assignment_Log (business_key);
create index ix_utasl_event_date on Task_Instance_Assignment_Log (event_date);
create index ix_utatl_utid on Task_Instance_Attachment_Log (user_task_instance_id);
create index ix_utatl_pid on Task_Instance_Attachment_Log (process_instance_id);
create index ix_utatl_key on Task_Instance_Attachment_Log (business_key);
create index ix_utatl_event_date on Task_Instance_Attachment_Log (event_date);
create index ix_utcl_utid on Task_Instance_Comment_Log (user_task_instance_id);
create index ix_utcl_pid on Task_Instance_Comment_Log (process_instance_id);
create index ix_utcl_key on Task_Instance_Comment_Log (business_key);
create index ix_utcl_event_date on Task_Instance_Comment_Log (event_date);
create index ix_utdl_utid on Task_Instance_Deadline_Log (user_task_instance_id);
create index ix_utdl_pid on Task_Instance_Deadline_Log (process_instance_id);
create index ix_utdl_key on Task_Instance_Deadline_Log (business_key);
create index ix_utdl_event_date on Task_Instance_Deadline_Log (event_date);
create index ix_utsl_utid on Task_Instance_State_Log (user_task_instance_id);
create index ix_utsl_state on Task_Instance_State_Log (state);
create index ix_utsl_pid on Task_Instance_State_Log (process_instance_id);
create index ix_utsl_key on Task_Instance_State_Log (business_key);
create index ix_utsl_event_date on Task_Instance_State_Log (event_date);
create index ix_tavl_utid on Task_Instance_Variable_Log (user_task_instance_id);
create index ix_tavl_pid on Task_Instance_Variable_Log (process_instance_id);
create index ix_tavl_key on Task_Instance_Variable_Log (business_key);
create index ix_tavl_event_date on Task_Instance_Variable_Log (event_date);
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



