| 12345678910111213141516171819202122232425 |
- 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)
|