No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

View Options

	diff --git a/src/database/migrations/2021_08_27_105020_drop_greylist_connect_index.php b/src/database/migrations/2021_08_27_105020_drop_greylist_connect_index.php
	new file mode 100644
	index 00000000..85c8a199
	--- /dev/null
	+++ b/src/database/migrations/2021_08_27_105020_drop_greylist_connect_index.php
	@@ -0,0 +1,51 @@
	+<?php
	+
	+use Illuminate\Database\Migrations\Migration;
	+use Illuminate\Database\Schema\Blueprint;
	+use Illuminate\Support\Facades\Schema;
	+
	+// phpcs:ignore
	+class DropGreylistConnectIndex extends Migration
	+{
	+ /**
	+ * Run the migrations.
	+ *
	+ * @return void
	+ */
	+ public function up()
	+ {
	+ Schema::table(
	+ 'greylist_connect',
	+ function (Blueprint $table) {
	+ $table->dropIndex('ssrnn_idx');
	+ }
	+ );
	+ }
	+
	+ /**
	+ * Reverse the migrations.
	+ *
	+ * @return void
	+ */
	+ public function down()
	+ {
	+ Schema::table(
	+ 'greylist_connect',
	+ function (Blueprint $table) {
	+ /**
	+ * Index for recipient request.
	+ */
	+ $table->index(
	+ [
	+ 'sender_local',
	+ 'sender_domain',
	+ 'recipient_hash',
	+ 'net_id',
	+ 'net_type'
	+ ],
	+ 'ssrnn_idx'
	+ );
	+ }
	+ );
	+ }
	+}