migrations/006_doc_steps.sql at 87b736ef368a36cd6d4ebbcb18d2b4b30dc67f6d

diffdown.com / diffdown-app

fork atom

Diffdown is a real-time collaborative Markdown editor/previewer built on the AT Protocol diffdown.com

fork atom

diffdown-app / migrations / 006_doc_steps.sql

at 87b736ef368a36cd6d4ebbcb18d2b4b30dc67f6d 12 lines 420 B view raw

wrap content

John Luther feat(db): add doc_steps table for prosemirror-collab step log 3w ago

4d579696

 1-- migrations/006_doc_steps.sql
 2CREATE TABLE IF NOT EXISTS doc_steps (
 3    id        INTEGER PRIMARY KEY AUTOINCREMENT,
 4    doc_rkey  TEXT    NOT NULL,
 5    version   INTEGER NOT NULL,
 6    step_json TEXT    NOT NULL,
 7    client_id TEXT    NOT NULL,
 8    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
 9    UNIQUE(doc_rkey, version)
10);
11
12CREATE INDEX IF NOT EXISTS idx_doc_steps_rkey_version ON doc_steps(doc_rkey, version);