Files

36 lines
1.2 KiB
Python
Raw Permalink Normal View History

2026-11-16 20:45:22 +08:00
"""add daily reminder preferences
Revision ID: 0004_daily_reminder_preferences
Revises: 0003_content_features
Create Date: 2026-06-03
"""
from __future__ import annotations
from alembic import op
import sqlalchemy as sa
revision = "0004_daily_reminder_preferences"
down_revision = "0003_content_features"
branch_labels = None
depends_on = None
def upgrade() -> None:
op.add_column("users", sa.Column("reminder_enabled", sa.Boolean(), nullable=False, server_default=sa.true()))
op.add_column("users", sa.Column("reminder_hour", sa.Integer(), nullable=False, server_default="9"))
op.add_column("users", sa.Column("reminder_minute", sa.Integer(), nullable=False, server_default="0"))
op.add_column(
"users",
sa.Column("reminder_timezone", sa.String(length=64), nullable=False, server_default="Asia/Shanghai"),
)
op.add_column("users", sa.Column("last_reminder_sent_at", sa.DateTime(timezone=True), nullable=True))
def downgrade() -> None:
op.drop_column("users", "last_reminder_sent_at")
op.drop_column("users", "reminder_timezone")
op.drop_column("users", "reminder_minute")
op.drop_column("users", "reminder_hour")
op.drop_column("users", "reminder_enabled")