from sqlalchemy import Column, String, DateTime, Integer from datetime import datetime from app.core.database import Base class VasUser(Base): __tablename__ = "vas_user" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_user` ( `id` VARCHAR(128) NOT NULL, `role` VARCHAR(32) NULL, `email` VARCHAR(128) NULL, `phone` VARCHAR(32) NULL, `nickname` VARCHAR(64) NULL, `avatar_url` VARCHAR(255) NULL, `preferred_language` VARCHAR(8) NULL, `timezone` VARCHAR(32) NULL, `register_ip` VARCHAR(64) NULL, `last_login_ip` VARCHAR(64) NULL, `password_hash` VARCHAR(255) NULL, `email_verified` INT NOT NULL DEFAULT 0, `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_user_email` (`email`), KEY `idx_vas_user_role` (`role`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户基础表'; """ id = Column(String(128), primary_key=True) role = Column(String(32)) email = Column(String(128)) phone = Column(String(32)) nickname = Column(String(64)) avatar_url = Column(String(255)) preferred_language = Column(String(8)) timezone = Column(String(32)) register_ip = Column(String(64)) last_login_ip = Column(String(64)) password_hash = Column(String(255)) email_verified = Column(Integer, default=0) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)