AI-News/backend/app/db/migrations/versions/20251121_add_article_views.py
2025-12-04 10:04:21 +08:00

27 lines
525 B
Python

"""add article views column
Revision ID: add_article_views
Revises: fdf8821871d7
Create Date: 2025-11-21
"""
import sqlalchemy as sa
from alembic import op
revision = "add_article_views"
down_revision = "fdf8821871d7"
branch_labels = None
depends_on = None
def upgrade() -> None:
op.add_column(
"articles",
sa.Column("views", sa.Integer(), nullable=False, server_default="0"),
)
op.alter_column("articles", "views", server_default=None)
def downgrade() -> None:
op.drop_column("articles", "views")