| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172 |
- from datetime import datetime
- from sqlalchemy import Column, Integer, String, Text, SmallInteger, DateTime, UniqueConstraint, Index
- from app.core.database import Base
- class Plugin(Base):
- __tablename__ = "plugins"
- __ddl__ = """
- CREATE TABLE IF NOT EXISTS `plugins` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(64) NOT NULL COMMENT '插件唯一英文标识',
- `display_name` VARCHAR(128) NOT NULL DEFAULT '',
- `filename` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '插件二进制脚本文件',
- `class_name` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '插件入口类名',
- `protocol` VARCHAR(64) NOT NULL DEFAULT 'IPlugin' COMMENT '插件协议标识',
- `latest_version` VARCHAR(32) NOT NULL DEFAULT '1.0.0',
- `description` VARCHAR(512) NOT NULL DEFAULT '',
- `status` SMALLINT NOT NULL DEFAULT 1 COMMENT '1:启用, 0:停用',
- `developer_id` VARCHAR(128) NULL COMMENT '插件开发管理者ID (享有20%技术分成)',
- `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_plugin_name` (`name`),
- INDEX `idx_plugins_developer_id` (`developer_id`),
- INDEX `idx_plugins_status` (`status`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='核心履约插件表';
- """
- id = Column(Integer, primary_key=True, autoincrement=True)
- name = Column(String(64), unique=True, nullable=False, index=True)
- display_name = Column(String(128), nullable=False, default="")
- filename = Column(String(128), nullable=False, default="")
- class_name = Column(String(128), nullable=False, default="")
- protocol = Column(String(64), nullable=False, default="IPlugin")
- latest_version = Column(String(32), nullable=False, default="1.0.0")
- description = Column(String(512), nullable=False, default="")
- status = Column(SmallInteger, nullable=False, default=1, index=True)
- developer_id = Column(String(128), nullable=True, index=True, comment="插件开发管理者ID")
- created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
- updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False)
- class PluginVersion(Base):
- __tablename__ = "plugin_versions"
- __ddl__ = """
- CREATE TABLE IF NOT EXISTS `plugin_versions` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `plugin_id` INT NOT NULL DEFAULT 0,
- `plugin_name` VARCHAR(64) NOT NULL,
- `version` VARCHAR(32) NOT NULL,
- `download_url` VARCHAR(512) NOT NULL,
- `sha256` VARCHAR(64) NOT NULL DEFAULT '',
- `changelog` TEXT NULL,
- `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_plugin_version` (`plugin_id`, `version`),
- INDEX `idx_pv_plugin_name` (`plugin_name`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='插件版本历史表';
- """
- id = Column(Integer, primary_key=True, autoincrement=True)
- plugin_id = Column(Integer, nullable=False, default=0, index=True)
- plugin_name = Column(String(64), nullable=False, index=True)
- version = Column(String(32), nullable=False)
- download_url = Column(String(512), nullable=False)
- sha256 = Column(String(64), nullable=False, default="")
- changelog = Column(Text, nullable=True)
- created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
- __table_args__ = (
- UniqueConstraint("plugin_id", "version", name="uk_plugin_version"),
- )
|