Files
streamline/drizzle/0031_eddy_knowledge_catalog.sql
2026-11-16 17:26:44 -08:00

21 lines
1.1 KiB
SQL

CREATE TABLE IF NOT EXISTS eddy_knowledge (
id text PRIMARY KEY, latest_revision bigint NOT NULL, enabled bigint NOT NULL DEFAULT 1,
author text NOT NULL, updated bigint NOT NULL
);
CREATE TABLE IF NOT EXISTS eddy_knowledge_revisions (
knowledge_id text NOT NULL, revision bigint NOT NULL, digest text NOT NULL,
document text NOT NULL, author text NOT NULL, created bigint NOT NULL,
PRIMARY KEY (knowledge_id, revision)
);
CREATE TABLE IF NOT EXISTS eddy_knowledge_assets (sha256 text PRIMARY KEY, data text NOT NULL, bytes bigint NOT NULL);
CREATE TABLE IF NOT EXISTS eddy_knowledge_refs (
knowledge_id text NOT NULL, revision bigint NOT NULL, sha256 text NOT NULL,
PRIMARY KEY (knowledge_id, revision, sha256)
);
CREATE TABLE IF NOT EXISTS eddy_knowledge_changes (
seq bigint PRIMARY KEY, knowledge_id text NOT NULL, revision bigint NOT NULL,
enabled bigint NOT NULL, actor text NOT NULL, action text NOT NULL, at bigint NOT NULL
);
CREATE INDEX IF NOT EXISTS eddy_knowledge_changes_latest ON eddy_knowledge_changes(knowledge_id, seq DESC);
CREATE INDEX IF NOT EXISTS eddy_knowledge_refs_hash ON eddy_knowledge_refs(sha256);