1 files changed, 13 insertions, 26 deletions
diff --git a/pydis_site/apps/api/migrations/0087_unique_constraint_filters.py b/pydis_site/apps/api/migrations/0087_unique_constraint_filters.py
index b2ff91f1..910e7b1b 100644
--- a/pydis_site/apps/api/migrations/0087_unique_constraint_filters.py
+++ b/pydis_site/apps/api/migrations/0087_unique_constraint_filters.py
@@ -1,5 +1,3 @@
-# Generated by Django 3.1.14 on 2022-03-22 16:31
-
 from django.db import migrations, models
 
 
@@ -10,29 +8,18 @@ class Migration(migrations.Migration):
     ]
 
     operations = [
-        migrations.AddConstraint(
-            model_name='filter',
-            constraint=models.UniqueConstraint(fields=(
-                'content',
-                'additional_field',
-                'filter_list',
-                'dm_content',
-                'dm_embed',
-                'infraction_type',
-                'infraction_reason',
-                'infraction_duration',
-                'infraction_channel',
-                'guild_pings',
-                'filter_dm',
-                'dm_pings',
-                'remove_context',
-                'bypass_roles',
-                'enabled',
-                'send_alert',
-                'enabled_channels',
-                'disabled_channels',
-                'enabled_categories',
-                'disabled_categories'
-            ), name='unique_filters'),
+        migrations.RunSQL(
+            "ALTER TABLE api_filter "
+            "ADD CONSTRAINT unique_filters UNIQUE NULLS NOT DISTINCT "
+            "(content, additional_field, filter_list_id, dm_content, dm_embed, infraction_type, infraction_reason, infraction_duration, infraction_channel, guild_pings, filter_dm, dm_pings, remove_context, bypass_roles, enabled, send_alert, enabled_channels, disabled_channels, enabled_categories, disabled_categories)",
+            state_operations=[
+                migrations.AddConstraint(
+                    model_name='filter',
+                    constraint=models.UniqueConstraint(
+                        fields=('content', 'additional_field', 'filter_list', 'dm_content', 'dm_embed', 'infraction_type', 'infraction_reason', 'infraction_duration', 'infraction_channel', 'guild_pings', 'filter_dm', 'dm_pings', 'remove_context', 'bypass_roles', 'enabled', 'send_alert', 'enabled_channels', 'disabled_channels', 'enabled_categories', 'disabled_categories'),
+                        name='unique_filters'
+                    ),
+                ),
+            ],
         ),
     ]