index|idx_documents_root_kind_slug|documents|CREATE UNIQUE INDEX idx_documents_root_kind_slug ON documents(root_item_id, kind, slug)
index|idx_documents_root|documents|CREATE INDEX idx_documents_root ON documents(root_item_id)
table|documents|documents|CREATE TABLE documents ( doc_rowid INTEGER PRIMARY KEY, id BLOB NOT NULL UNIQUE DEFAULT (randomblob(16)), root_item_id BLOB NOT NULL REFERENCES work_items(id) ON DELETE CASCADE, kind TEXT NOT NULL, slug TEXT NOT NULL, title TEXT, body TEXT NOT NULL, content_hash TEXT NOT NULL, version INTEGER NOT NULL DEFAULT 1, archived_at TIMESTAMP, created_at TIMESTAMP NOT NULL, modified_at TIMESTAMP NOT NULL )
trigger|documents_fts_text_ad|documents|CREATE TRIGGER documents_fts_text_ad AFTER DELETE ON documents BEGIN INSERT INTO documents_fts_text(documents_fts_text, rowid, title, body) VALUES ('delete', old.doc_rowid, old.title, old.body); END
trigger|documents_fts_text_ai|documents|CREATE TRIGGER documents_fts_text_ai AFTER INSERT ON documents BEGIN INSERT INTO documents_fts_text(rowid, title, body) VALUES (new.doc_rowid, new.title, new.body); END
trigger|documents_fts_text_au|documents|CREATE TRIGGER documents_fts_text_au AFTER UPDATE OF title, body ON documents BEGIN INSERT INTO documents_fts_text(documents_fts_text, rowid, title, body) VALUES ('delete', old.doc_rowid, old.title, old.body); INSERT INTO documents_fts_text(rowid, title, body) VALUES (new.doc_rowid, new.title, new.body); END
trigger|documents_fts_trigram_ad|documents|CREATE TRIGGER documents_fts_trigram_ad AFTER DELETE ON documents BEGIN INSERT INTO documents_fts_trigram(documents_fts_trigram, rowid, title, body) VALUES ('delete', old.doc_rowid, old.title, old.body); END
trigger|documents_fts_trigram_ai|documents|CREATE TRIGGER documents_fts_trigram_ai AFTER INSERT ON documents BEGIN INSERT INTO documents_fts_trigram(rowid, title, body) VALUES (new.doc_rowid, new.title, new.body); END
trigger|documents_fts_trigram_au|documents|CREATE TRIGGER documents_fts_trigram_au AFTER UPDATE OF title, body ON documents BEGIN INSERT INTO documents_fts_trigram(documents_fts_trigram, rowid, title, body) VALUES ('delete', old.doc_rowid, old.title, old.body); INSERT INTO documents_fts_trigram(rowid, title, body) VALUES (new.doc_rowid, new.title, new.body); END
