verification_token.py 926 B

12345678910111213141516171819202122232425
  1. from sqlalchemy import Column, String, DateTime, Integer
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasVerificationToken(Base):
  5. __tablename__ = "vas_verification_token"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_verification_token` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `token` VARCHAR(128) NOT NULL,
  10. `used` INT NOT NULL DEFAULT 0,
  11. `expire_at` DATETIME NOT NULL,
  12. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  13. PRIMARY KEY (`id`),
  14. KEY `idx_vas_verif_token` (`token`)
  15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='验证Token表';
  16. """
  17. id = Column(Integer, primary_key=True, autoincrement=True)
  18. token = Column(String(128), nullable=False)
  19. used = Column(Integer, default=0)
  20. expire_at = Column(DateTime, nullable=False)
  21. created_at = Column(DateTime, default=datetime.utcnow)