| 1234567891011121314151617181920212223242526272829303132333435 |
- 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)
|