migrations/001_initdb.sql at dba88a76f846b697682321e05ae9998dfafef410 · 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 dba88a76f846b697682321e05ae9998dfafef410 542 B view raw

 1CREATE TABLE IF NOT EXISTS posts (
 2    id          INTEGER PRIMARY KEY AUTOINCREMENT,
 3    user        TEXT NOT NULL,
 4    service     TEXT NOT NULL,
 5    identifier  TEXT NOT NULL,
 6    parent      INTEGER NULL REFERENCES posts(id),
 7    root        INTEGER NULL REFERENCES posts(id),
 8    reposted    INTEGER NULL REFERENCES posts(id),
 9    extra_data  TEXT NULL
10);
11
12CREATE TABLE IF NOT EXISTS mappings (
13    original INTEGER NOT NULL REFERENCES posts(id) ON DELETE CASCADE,
14    mapped   INTEGER NOT NULL REFERENCES posts(id) ON DELETE CASCADE
15);