from sqlalchemy import Column, Integer, String, Text, Float, JSON, TIMESTAMP, Enum, DateTime from sqlalchemy.sql import func from datetime import datetime from app.core.database import Base class Account(Base): __tablename__ = "account" __ddl__ = """ CREATE TABLE IF NOT EXISTS `account` ( `id` INT NOT NULL AUTO_INCREMENT, `pool_name` VARCHAR(50) NOT NULL, `username` VARCHAR(100) NOT NULL, `password` VARCHAR(255) NULL, `extra_data` JSON NULL, `next_use_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '下次允许使用的时间', `status` ENUM('active','disable') NOT NULL DEFAULT 'active', `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_account_pool_name` (`pool_name`), KEY `idx_account_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='账号池表'; """ id = Column(Integer, primary_key=True, index=True) pool_name = Column(String(50), nullable=False, index=True) username = Column(String(100), nullable=False) password = Column(String(255), nullable=True) extra_data = Column(JSON, nullable=True) next_use_time = Column(DateTime, nullable=False, default=func.now(), comment="下次允许使用的时间") status = Column(Enum('active','disable'), default="active", index=True) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)