from sqlalchemy import Column, Integer, String, Text, DateTime, Enum, JSON from datetime import datetime from app.core.database import Base class VasPaymentProvider(Base): __tablename__ = "vas_payment_provider" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_payment_provider` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(64) NOT NULL, `title` VARCHAR(100) NULL, `channel` VARCHAR(64) NOT NULL, `currency` VARCHAR(3) NOT NULL, `icon` TEXT NULL, `enabled` INT NOT NULL DEFAULT 1, `config` JSON NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付服务商配置表'; """ id = Column(Integer, primary_key=True, autoincrement=True) name = Column(String(64), nullable=False) title = Column(String(100)) channel = Column(String(64), nullable=False) currency = Column(String(3), nullable=False) icon = Column(Text) enabled = Column(Integer, default=1) config = Column(JSON) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)