| @@ -30,9 +30,8 @@ | ||
| 30 | 30 | `status` VARCHAR(100) NULL DEFAULT 'active', |
| 31 | 31 | `file_size` VARCHAR(100) NULL, |
| 32 | 32 | `created_at` TIMESTAMP NULL, |
| 33 | 33 | `updated_at` TIMESTAMP NULL, |
| 34 | - INDEX `idx_file_hash` (`file_hash`), | |
| 35 | 34 | INDEX `idx_ticket_id` (`ticket_id`), |
| 36 | 35 | INDEX `idx_person_id` (`person_id`), |
| 37 | 36 | INDEX `idx_conversation_id` (`conversation_id`), |
| 38 | 37 | INDEX `idx_status` (`status`), |
| @@ -89,9 +88,8 @@ | ||
| 89 | 88 | 'idx_person_id' => 'person_id', |
| 90 | 89 | 'idx_conversation_id' => 'conversation_id', |
| 91 | 90 | 'idx_status' => 'status', |
| 92 | 91 | 'idx_created_at' => 'created_at', |
| 93 | - 'idx_file_hash' => 'file_hash', | |
| 94 | 92 | ]; |
| 95 | 93 | |
| 96 | 94 | // Add missing indexes. $table is esc_sql()'d above; $index_name and |
| 97 | 95 | // $column_name are hardcoded array literals — no user input reaches this query. |