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