diff options
Diffstat (limited to 'webmentions_ssg/migrations/versions')
| -rw-r--r-- | webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py b/webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py new file mode 100644 index 0000000..cbb40ef --- /dev/null +++ b/webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py @@ -0,0 +1,26 @@ +"""Index received webmentions for expired verification recovery. + +Revision ID: c0272f25ce17 +Revises: 85f2b226ec99 +""" + +from alembic import op + +revision = "c0272f25ce17" +down_revision = "85f2b226ec99" +branch_labels = None +depends_on = None + + +def upgrade(): + op.create_index( + "ix_received_webmentions_status_updated_at", + "received_webmentions", + ["status", "updated_at"], + ) + + +def downgrade(): + op.drop_index( + "ix_received_webmentions_status_updated_at", table_name="received_webmentions" + ) |
