email_authorizations.py 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. from sqlalchemy import Column, Integer, String, TIMESTAMP, func
  2. from app.core.database import Base
  3. class EmailAuthorization(Base):
  4. __tablename__ = "email_authorizations"
  5. __ddl__ = """
  6. CREATE TABLE IF NOT EXISTS `email_authorizations` (
  7. `id` INT NOT NULL AUTO_INCREMENT,
  8. `email` VARCHAR(255) NOT NULL COMMENT '邮箱地址',
  9. `authorization_code` VARCHAR(255) NOT NULL COMMENT '授权码',
  10. `imap_server` VARCHAR(255) NULL COMMENT 'IMAP服务器地址',
  11. `imap_port` INT NOT NULL DEFAULT 993 COMMENT 'IMAP端口',
  12. `smtp_server` VARCHAR(255) NULL COMMENT 'SMTP服务器地址',
  13. `smtp_port` INT NOT NULL DEFAULT 465 COMMENT 'SMTP端口',
  14. `proxy_host` VARCHAR(255) NULL COMMENT '代理主机',
  15. `proxy_port` INT NOT NULL DEFAULT 0 COMMENT '代理端口',
  16. `proxy_username` VARCHAR(255) NULL COMMENT '代理用户名',
  17. `proxy_password` VARCHAR(255) NULL COMMENT '代理密码',
  18. `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  19. `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  20. PRIMARY KEY (`id`),
  21. UNIQUE KEY `uq_email_auth_email` (`email`)
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邮箱IMAP/SMTP授权管理表';
  23. """
  24. id = Column(Integer, primary_key=True, autoincrement=True)
  25. email = Column(String(255), unique=True, nullable=False, comment="邮箱地址")
  26. authorization_code = Column(String(255), nullable=False, comment="授权码")
  27. imap_server = Column(String(255), nullable=True, comment="IMAP服务器地址")
  28. imap_port = Column(Integer, default=993, comment="IMAP端口")
  29. smtp_server = Column(String(255), nullable=True, comment="SMTP服务器地址")
  30. smtp_port = Column(Integer, default=465, comment="SMTP端口")
  31. proxy_host = Column(String(255), nullable=True, comment="代理主机")
  32. proxy_port = Column(Integer, default=0, comment="代理端口")
  33. proxy_username = Column(String(255), nullable=True, comment="代理用户名")
  34. proxy_password = Column(String(255), nullable=True, comment="代理密码")
  35. created_at = Column(TIMESTAMP, server_default=func.now(), comment="创建时间")
  36. updated_at = Column(TIMESTAMP, server_default=func.now(), onupdate=func.now(), comment="更新时间")