| @@ -1,12 +1,8 @@ | ||
| 1 | 1 | <?php |
| 2 | + | |
| 2 | 3 | namespace WPDeveloper\BetterDocs\Core; |
| 3 | 4 | |
| 4 | -if ( ! defined( 'ABSPATH' ) ) { | |
| 5 | - exit; | |
| 6 | -} | |
| 7 | - | |
| 8 | - | |
| 9 | 5 | use WPDeveloper\BetterDocs\Utils\Base; |
| 10 | 6 | use WPDeveloper\BetterDocs\Utils\Database; |
| 11 | 7 | use WPDeveloper\BetterDocs\Dependencies\DI\Container; |
| 12 | 8 | |
| @@ -168,10 +164,9 @@ | ||
| 168 | 164 | not_found_count mediumint(9) NULL, |
| 169 | 165 | created_at date DEFAULT '0000-00-00' NOT NULL, |
| 170 | 166 | PRIMARY KEY (id), |
| 171 | 167 | KEY keyword_id (keyword_id), |
| 172 | - KEY created_at (created_at), | |
| 173 | - KEY keyword_created (keyword_id, created_at) | |
| 168 | + KEY created_at (created_at) | |
| 174 | 169 | ) {$charset_collate};"; |
| 175 | 170 | |
| 176 | 171 | $_analytics_table = $wpdb->prefix . 'betterdocs_analytics'; |
| 177 | 172 | $analytics_table = "CREATE TABLE $_analytics_table ( |
| @@ -189,10 +184,9 @@ | ||
| 189 | 184 | KEY unique_visit (unique_visit), |
| 190 | 185 | KEY happy (happy), |
| 191 | 186 | KEY sad (sad), |
| 192 | 187 | KEY normal (normal), |
| 193 | - KEY created_at (created_at), | |
| 194 | - UNIQUE KEY post_created (post_id, created_at) | |
| 188 | + KEY created_at (created_at) | |
| 195 | 189 | ) {$charset_collate};"; |
| 196 | 190 | |
| 197 | 191 | require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
| 198 | 192 | dbDelta( $search_keyword . $search_log . $analytics_table ); |
