# SPDX-FileCopyrightText: 2026 Dennis Fink # # SPDX-License-Identifier: BSD-3-Clause """Add persistent source-domain block and allow lists. Revision ID: 3e8c87a96b2d Revises: e62b1a7c4d90 """ import sqlalchemy as sa from alembic import op revision = "3e8c87a96b2d" down_revision = "e62b1a7c4d90" branch_labels = None depends_on = None def upgrade(): op.create_table( "blocked_sources", sa.Column("id", sa.Integer(), nullable=False), sa.Column("domain", sa.Text(), nullable=False), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint("domain"), ) op.create_table( "allowed_sources", sa.Column("id", sa.Integer(), nullable=False), sa.Column("domain", sa.Text(), nullable=False), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint("domain"), ) def downgrade(): op.drop_table("allowed_sources") op.drop_table("blocked_sources")