migrations/001_initdb.sql at 88ae2e66a2614323786c8a42775e4b1e0a769145 · 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 88ae2e66a2614323786c8a42775e4b1e0a769145 501 B view raw

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