6a2632da70
将 Clover 从上层产品包旧仓库中独立出来,建立专属版本控制。 当前状态=纵切片端到端已打通(登录→选品→出文出图→审核→下载包), M1文案质量去套路化已验收。此提交作为后续按核销清单逐条修复的基线。 Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
65 lines
2.5 KiB
Python
65 lines
2.5 KiB
Python
"""001_banana_users_tables
|
||
|
||
Revision ID: 001
|
||
Revises:
|
||
Create Date: 2026-06-09
|
||
Alembic 001: 从 banana 搬 3 张表（users/login_records/user_preferences）
|
||
删除 credits 字段，其余无改。
|
||
"""
|
||
|
||
from typing import Sequence, Union
|
||
|
||
import sqlalchemy as sa
|
||
from alembic import op
|
||
|
||
revision: str = "001"
|
||
down_revision: Union[str, None] = None
|
||
branch_labels: Union[str, Sequence[str], None] = None
|
||
depends_on: Union[str, Sequence[str], None] = None
|
||
|
||
|
||
def upgrade() -> None:
|
||
op.create_table(
|
||
"users",
|
||
sa.Column("id", sa.BigInteger(), autoincrement=True, nullable=False),
|
||
sa.Column("username", sa.String(64), nullable=False),
|
||
sa.Column("email", sa.String(255), nullable=False),
|
||
sa.Column("hashed_password", sa.String(255), nullable=False),
|
||
sa.Column("is_active", sa.Boolean(), nullable=False, server_default="1"),
|
||
sa.Column("created_at", sa.DateTime(), server_default=sa.text("now()"), nullable=False),
|
||
sa.Column("updated_at", sa.DateTime(), server_default=sa.text("now()"), nullable=False),
|
||
sa.PrimaryKeyConstraint("id"),
|
||
sa.UniqueConstraint("username"),
|
||
sa.UniqueConstraint("email"),
|
||
)
|
||
|
||
op.create_table(
|
||
"login_records",
|
||
sa.Column("id", sa.BigInteger(), autoincrement=True, nullable=False),
|
||
sa.Column("user_id", sa.BigInteger(), nullable=False),
|
||
sa.Column("ip_address", sa.String(64), nullable=True),
|
||
sa.Column("user_agent", sa.String(512), nullable=True),
|
||
sa.Column("created_at", sa.DateTime(), server_default=sa.text("now()"), nullable=False),
|
||
sa.ForeignKeyConstraint(["user_id"], ["users.id"], ondelete="CASCADE"),
|
||
sa.PrimaryKeyConstraint("id"),
|
||
)
|
||
op.create_index("idx_login_records_user_id", "login_records", ["user_id"])
|
||
|
||
op.create_table(
|
||
"user_preferences",
|
||
sa.Column("id", sa.BigInteger(), autoincrement=True, nullable=False),
|
||
sa.Column("user_id", sa.BigInteger(), nullable=False),
|
||
sa.Column("preferences_json", sa.Text(), nullable=True),
|
||
sa.Column("updated_at", sa.DateTime(), server_default=sa.text("now()"), nullable=False),
|
||
sa.ForeignKeyConstraint(["user_id"], ["users.id"], ondelete="CASCADE"),
|
||
sa.PrimaryKeyConstraint("id"),
|
||
sa.UniqueConstraint("user_id"),
|
||
)
|
||
|
||
|
||
def downgrade() -> None:
|
||
op.drop_table("user_preferences")
|
||
op.drop_index("idx_login_records_user_id", "login_records")
|
||
op.drop_table("login_records")
|
||
op.drop_table("users")
|