migrations/001_initdb.sql at a32d63d2aef8979ae35ca5ecdd5a43f591125df3 · zenfyr.dev/xpost

zenfyr.dev / xpost

social media crossposting tool. 3rd time's the charm

mastodon misskey crossposting bluesky

xpost / migrations / 001_initdb.sql

at a32d63d2aef8979ae35ca5ecdd5a43f591125df3 474 B view raw

 1CREATE TABLE IF NOT EXISTS posts (
 2    id         INTEGER PRIMARY KEY AUTOINCREMENT,
 3    user_id    TEXT NOT NULL,
 4    service    TEXT NOT NULL,
 5    identifier TEXT NOT NULL,
 6    parent_id  INTEGER NULL REFERENCES posts(id),
 7    root_id    INTEGER NULL REFERENCES posts(id)
 8);
 9
10CREATE TABLE IF NOT EXISTS mappings (
11    original_post_id INTEGER NOT NULL REFERENCES posts(id) ON DELETE CASCADE,
12    mapped_post_id   INTEGER NOT NULL REFERENCES posts(id) ON DELETE CASCADE
13);