mirror of
https://gitlab.com/PronounsPage/PronounsPage.git
synced 2025-09-16 19:16:54 -04:00
13 lines
382 B
SQL
13 lines
382 B
SQL
-- Up
|
|
|
|
CREATE TABLE block_connections (
|
|
id TEXT NOT NULL PRIMARY KEY,
|
|
from_userId TEXT NOT NULL REFERENCES users ON DELETE CASCADE,
|
|
to_userId TEXT NOT NULL REFERENCES users ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE INDEX "block_connections_from_userId" ON "block_connections" ("from_userId");
|
|
CREATE INDEX "block_connections_to_userId" ON "block_connections" ("to_userId");
|
|
|
|
-- Down
|