mirror of
https://github.com/nullishamy/ferri.git
synced 2025-06-27 16:44:18 +00:00
13 lines
264 B
SQL
13 lines
264 B
SQL
CREATE TABLE IF NOT EXISTS attachment
|
|
(
|
|
-- UUID
|
|
id TEXT PRIMARY KEY NOT NULL,
|
|
post_id TEXT NOT NULL,
|
|
url TEXT NOT NULL,
|
|
media_type TEXT NOT NULL,
|
|
marked_sensitive BOOL NOT NULL,
|
|
alt TEXT,
|
|
|
|
FOREIGN KEY(post_id) REFERENCES post(id)
|
|
);
|
|
|