from sqlalchemy import Column, Integer, String, TIMESTAMP, func from app.core.database import Base class EmailAuthorization(Base): __tablename__ = "email_authorizations" __ddl__ = """ CREATE TABLE IF NOT EXISTS `email_authorizations` ( `id` INT NOT NULL AUTO_INCREMENT, `email` VARCHAR(255) NOT NULL COMMENT '邮箱地址', `authorization_code` VARCHAR(255) NOT NULL COMMENT '授权码', `imap_server` VARCHAR(255) NULL COMMENT 'IMAP服务器地址', `imap_port` INT NOT NULL DEFAULT 993 COMMENT 'IMAP端口', `smtp_server` VARCHAR(255) NULL COMMENT 'SMTP服务器地址', `smtp_port` INT NOT NULL DEFAULT 465 COMMENT 'SMTP端口', `proxy_host` VARCHAR(255) NULL COMMENT '代理主机', `proxy_port` INT NOT NULL DEFAULT 0 COMMENT '代理端口', `proxy_username` VARCHAR(255) NULL COMMENT '代理用户名', `proxy_password` VARCHAR(255) NULL COMMENT '代理密码', `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uq_email_auth_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邮箱IMAP/SMTP授权管理表'; """ id = Column(Integer, primary_key=True, autoincrement=True) email = Column(String(255), unique=True, nullable=False, comment="邮箱地址") authorization_code = Column(String(255), nullable=False, comment="授权码") imap_server = Column(String(255), nullable=True, comment="IMAP服务器地址") imap_port = Column(Integer, default=993, comment="IMAP端口") smtp_server = Column(String(255), nullable=True, comment="SMTP服务器地址") smtp_port = Column(Integer, default=465, comment="SMTP端口") proxy_host = Column(String(255), nullable=True, comment="代理主机") proxy_port = Column(Integer, default=0, comment="代理端口") proxy_username = Column(String(255), nullable=True, comment="代理用户名") proxy_password = Column(String(255), nullable=True, comment="代理密码") created_at = Column(TIMESTAMP, server_default=func.now(), comment="创建时间") updated_at = Column(TIMESTAMP, server_default=func.now(), onupdate=func.now(), comment="更新时间")