migrations/006_doc_steps.sql at 2879567a37b77ab5bedaac110f2201493b973eff

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 2879567a37b77ab5bedaac110f2201493b973eff 12 lines 420 B view raw

wrap content

John Luther feat(db): add doc_steps table for prosemirror-collab step log 4w 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);