mirror of
https://tangled.org/evan.jarrett.net/at-container-registry
synced 2026-09-24 19:24:16 +00:00
17 lines
610 B
YAML
17 lines
610 B
YAML
description: Create labels table for ATProto content moderation (takedowns)
|
|
query: |
|
|
CREATE TABLE IF NOT EXISTS labels (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
src TEXT NOT NULL,
|
|
uri TEXT NOT NULL,
|
|
val TEXT NOT NULL,
|
|
neg BOOLEAN NOT NULL DEFAULT 0,
|
|
cts TIMESTAMP NOT NULL,
|
|
subject_did TEXT NOT NULL,
|
|
subject_repo TEXT NOT NULL DEFAULT '',
|
|
seq INTEGER NOT NULL DEFAULT 0,
|
|
UNIQUE(src, uri, val, neg)
|
|
);
|
|
CREATE INDEX IF NOT EXISTS idx_labels_subject ON labels(subject_did, subject_repo);
|
|
CREATE INDEX IF NOT EXISTS idx_labels_val ON labels(val);
|