1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| ALTER TABLE appointment_order
| ADD KEY idx_ao_del_create_id (del_flag, create_time, id),
| ADD KEY idx_ao_del_visited_status (del_flag, visited_user_id, status),
| ADD KEY idx_ao_del_submitter_create_id (del_flag, submitter_id, create_time, id),
| ADD KEY idx_ao_del_visited_visit_range (del_flag, visited_user_id, visit_start_date, visit_end_date);
|
| ALTER TABLE approval_instance
| ADD KEY idx_ai_del_order_id (del_flag, order_id, id);
|
| ALTER TABLE approval_task
| ADD KEY idx_at_del_assignee_status_create (del_flag, assignee_user_id, task_status, create_time),
| ADD KEY idx_at_del_assignee_status_update_id (del_flag, assignee_user_id, task_status, update_time, id),
| ADD KEY idx_at_instance_node_group_status (instance_id, node_code, group_key, task_status);
|
| ALTER TABLE appointment_visitor
| ADD KEY idx_av_del_order_id (del_flag, order_id, id),
| ADD KEY idx_av_del_name (del_flag, name);
|
| ALTER TABLE qrcode_ticket
| ADD KEY idx_qt_del_order_visitor_status_id (del_flag, order_id, mp_visitor_id, ticket_status, id);
|
|
