| 123456789101112131415161718192021222324252627282930313233343536373839 |
- 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="更新时间")
|