← All changes | database/Migrations/OrderDownloadPermissionsMigrator.php +18 -1 1.3.23 → 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	}