from sqlalchemy import Column, String, DateTime, Integer from datetime import datetime from app.core.database import Base class VasVerificationToken(Base): __tablename__ = "vas_verification_token" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_verification_token` ( `id` INT NOT NULL AUTO_INCREMENT, `token` VARCHAR(128) NOT NULL, `used` INT NOT NULL DEFAULT 0, `expire_at` DATETIME NOT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_vas_verif_token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='验证Token表'; """ id = Column(Integer, primary_key=True, autoincrement=True) token = Column(String(128), nullable=False) used = Column(Integer, default=0) expire_at = Column(DateTime, nullable=False) created_at = Column(DateTime, default=datetime.utcnow)