mirror of
https://gitlab.com/PronounsPage/PronounsPage.git
synced 2025-09-24 05:05:20 -04:00
15 lines
348 B
SQL
15 lines
348 B
SQL
-- Up
|
|
|
|
CREATE TABLE ban_proposals (
|
|
id TEXT NOT NULL PRIMARY KEY,
|
|
userId TEXT NULL NOT NULL REFERENCES users ON DELETE CASCADE,
|
|
bannedBy TEXT NOT NULL REFERENCES users ON DELETE SET NULL,
|
|
bannedTerms TEXT NULL NOT NULL,
|
|
bannedReason TEXT NOT NULL
|
|
);
|
|
|
|
CREATE INDEX "ban_proposals_userId" ON "ban_proposals" ("userId");
|
|
|
|
-- Down
|
|
|