| 123456789101112131415161718192021222324252627282930 |
- from sqlalchemy import Column, String, DateTime
- from datetime import datetime
- from app.core.database import Base
- class VasSession(Base):
- __tablename__ = "vas_session"
- __ddl__ = """
- CREATE TABLE IF NOT EXISTS `vas_session` (
- `id` VARCHAR(128) NOT NULL,
- `user_id` VARCHAR(128) NOT NULL,
- `user_agent` VARCHAR(255) NOT NULL,
- `ip` VARCHAR(128) NOT NULL,
- `expire_at` DATETIME NOT NULL,
- `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- KEY `idx_vas_session_user_id` (`user_id`),
- KEY `idx_vas_session_expire_at` (`expire_at`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户会话Token表';
- """
- id = Column(String(128), primary_key=True) # token
- user_id = Column(String(128), nullable=False)
- user_agent = Column(String(255), nullable=False)
- ip = Column(String(128), nullable=False)
- expire_at = Column(DateTime, nullable=False)
- created_at = Column(DateTime, default=datetime.utcnow)
- updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|