"""add content features and alerts Revision ID: 0003_content_features Revises: 0002_file_blob_thumb Create Date: 2026-06-03 """ from __future__ import annotations from alembic import op import sqlalchemy as sa revision = "0003_content_features" down_revision = "0002_file_blob_thumb" branch_labels = None depends_on = None def upgrade() -> None: op.add_column("artworks", sa.Column("content_type", sa.String(length=20), nullable=False, server_default="illust")) op.add_column("artworks", sa.Column("last_viewed_at", sa.DateTime(timezone=True), nullable=True)) op.create_index("ix_artworks_content_type", "artworks", ["content_type"]) op.create_index("ix_artworks_last_viewed_at", "artworks", ["last_viewed_at"]) op.add_column("novels", sa.Column("series_id", sa.String(length=50), nullable=True)) op.add_column("novels", sa.Column("series_title", sa.String(length=500), nullable=True)) op.add_column("novels", sa.Column("chapter_title", sa.String(length=500), nullable=True)) op.add_column("novels", sa.Column("chapter_order", sa.Integer(), nullable=False, server_default="0")) op.add_column("novels", sa.Column("last_viewed_at", sa.DateTime(timezone=True), nullable=True)) op.create_index("ix_novels_series_id", "novels", ["series_id"]) op.create_index("ix_novels_last_viewed_at", "novels", ["last_viewed_at"]) op.create_table( "creator_follows", sa.Column("id", sa.String(length=36), nullable=False), sa.Column("created_at", sa.DateTime(timezone=True), nullable=False), sa.Column("updated_at", sa.DateTime(timezone=True), nullable=False), sa.Column("user_id", sa.String(length=36), nullable=False), sa.Column("platform", sa.String(length=20), nullable=False), sa.Column("creator_id", sa.String(length=100), nullable=False), sa.Column("creator_name", sa.String(length=200), nullable=True), sa.Column("creator_handle", sa.String(length=200), nullable=True), sa.Column("profile_url", sa.Text(), nullable=True), sa.Column("avatar_url", sa.Text(), nullable=True), sa.Column("enabled", sa.Boolean(), nullable=False), sa.Column("last_checked_at", sa.DateTime(timezone=True), nullable=True), sa.Column("latest_published_at", sa.DateTime(timezone=True), nullable=True), sa.Column("metadata", sa.JSON(), nullable=False), sa.ForeignKeyConstraint(["user_id"], ["users.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), ) op.create_index("ix_creator_follows_user_id", "creator_follows", ["user_id"]) op.create_index("ix_creator_follows_platform", "creator_follows", ["platform"]) op.create_index("ix_creator_follows_creator_id", "creator_follows", ["creator_id"]) op.create_index("ix_creator_follows_enabled", "creator_follows", ["enabled"]) op.create_table( "update_alerts", sa.Column("id", sa.String(length=36), nullable=False), sa.Column("created_at", sa.DateTime(timezone=True), nullable=False), sa.Column("updated_at", sa.DateTime(timezone=True), nullable=False), sa.Column("user_id", sa.String(length=36), nullable=False), sa.Column("follow_id", sa.String(length=36), nullable=True), sa.Column("platform", sa.String(length=20), nullable=False), sa.Column("creator_id", sa.String(length=100), nullable=False), sa.Column("title", sa.String(length=500), nullable=False), sa.Column("body", sa.Text(), nullable=True), sa.Column("content_type", sa.String(length=20), nullable=True), sa.Column("target_url", sa.Text(), nullable=True), sa.Column("cover_url", sa.Text(), nullable=True), sa.Column("is_read", sa.Boolean(), nullable=False), sa.Column("payload", sa.JSON(), nullable=False), sa.ForeignKeyConstraint(["follow_id"], ["creator_follows.id"], ondelete="SET NULL"), sa.ForeignKeyConstraint(["user_id"], ["users.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), ) op.create_index("ix_update_alerts_user_id", "update_alerts", ["user_id"]) op.create_index("ix_update_alerts_follow_id", "update_alerts", ["follow_id"]) op.create_index("ix_update_alerts_platform", "update_alerts", ["platform"]) op.create_index("ix_update_alerts_creator_id", "update_alerts", ["creator_id"]) op.create_index("ix_update_alerts_is_read", "update_alerts", ["is_read"]) def downgrade() -> None: op.drop_index("ix_update_alerts_is_read", table_name="update_alerts") op.drop_index("ix_update_alerts_creator_id", table_name="update_alerts") op.drop_index("ix_update_alerts_platform", table_name="update_alerts") op.drop_index("ix_update_alerts_follow_id", table_name="update_alerts") op.drop_index("ix_update_alerts_user_id", table_name="update_alerts") op.drop_table("update_alerts") op.drop_index("ix_creator_follows_enabled", table_name="creator_follows") op.drop_index("ix_creator_follows_creator_id", table_name="creator_follows") op.drop_index("ix_creator_follows_platform", table_name="creator_follows") op.drop_index("ix_creator_follows_user_id", table_name="creator_follows") op.drop_table("creator_follows") op.drop_index("ix_novels_last_viewed_at", table_name="novels") op.drop_index("ix_novels_series_id", table_name="novels") op.drop_column("novels", "last_viewed_at") op.drop_column("novels", "chapter_order") op.drop_column("novels", "chapter_title") op.drop_column("novels", "series_title") op.drop_column("novels", "series_id") op.drop_index("ix_artworks_last_viewed_at", table_name="artworks") op.drop_index("ix_artworks_content_type", table_name="artworks") op.drop_column("artworks", "last_viewed_at") op.drop_column("artworks", "content_type")