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"), )