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)