← All changes
|
database/Migrations/OrderDownloadPermissionsMigrator.php
+18
-1
1.4.1
→
1.6.5
View file →
| @@ -8,8 +8,10 @@ | ||
| 8 | 8 | { |
| 9 | 9 | |
| 10 | 10 | public static string $tableName = 'fct_order_download_permissions'; |
| 11 | 11 | |
| 12 | + const CUSTOMER_RECOVERY_INDEX = 'idx_download_permissions_customer_recovery'; | |
| 13 | + | |
| 12 | 14 | public static function getSqlSchema(): string |
| 13 | 15 | { |
| 14 | 16 | $indexPrefix = static::getDbPrefix() . 'fct_odp_'; |
| 15 | 17 | return "`id` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, |
| @@ -24,7 +26,22 @@ | ||
| 24 | 26 | `updated_at` DATETIME NULL, |
| 25 | 27 | |
| 26 | 28 | INDEX `{$indexPrefix}_order_id_idx` (`order_id` ASC), |
| 27 | 29 | INDEX `{$indexPrefix}_download_id_idx` (`download_id` ASC), |
| 28 | - INDEX `{$indexPrefix}_variation_id_idx` (`variation_id` ASC)"; | |
| 30 | + INDEX `{$indexPrefix}_variation_id_idx` (`variation_id` ASC), | |
| 31 | + INDEX `" . self::CUSTOMER_RECOVERY_INDEX . "` (`customer_id` ASC, `id` ASC)"; | |
| 32 | + } | |
| 33 | + public static function migrated() | |
| 34 | + { | |
| 35 | + static::addCustomerRecoveryIndex(); | |
| 36 | + } | |
| 37 | + | |
| 38 | + public static function addCustomerRecoveryIndex(): void | |
| 39 | + { | |
| 40 | + static::addIndexIfNotExists(self::CUSTOMER_RECOVERY_INDEX, ['customer_id', 'id']); | |
| 41 | + } | |
| 42 | + | |
| 43 | + public static function hasCustomerRecoveryIndex(): bool | |
| 44 | + { | |
| 45 | + return static::hasIndex(self::CUSTOMER_RECOVERY_INDEX); | |
| 29 | 46 | } |
| 30 | 47 | } |