NotAShelf
56d44e120a
Signed-off-by: NotAShelf <raf@notashelf.dev> Change-Id: I8567eec6980b2b5453687bcbd07a61206a6a6964
15 lines
487 B
SQL
15 lines
487 B
SQL
-- Plugin registry table
|
|
CREATE TABLE plugin_registry (
|
|
id TEXT PRIMARY KEY,
|
|
name TEXT NOT NULL,
|
|
version TEXT NOT NULL,
|
|
enabled BOOLEAN NOT NULL DEFAULT TRUE,
|
|
config_json TEXT,
|
|
manifest_json TEXT,
|
|
installed_at TIMESTAMP WITH TIME ZONE NOT NULL,
|
|
updated_at TIMESTAMP WITH TIME ZONE NOT NULL
|
|
);
|
|
|
|
-- Index for quick lookups
|
|
CREATE INDEX idx_plugin_registry_enabled ON plugin_registry(enabled);
|
|
CREATE INDEX idx_plugin_registry_name ON plugin_registry(name);
|