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