mirror of
https://gitlab.com/PronounsPage/PronounsPage.git
synced 2025-09-22 12:03:25 -04:00
15 lines
422 B
SQL
15 lines
422 B
SQL
-- Up
|
|
|
|
CREATE TABLE user_connections (
|
|
id TEXT NOT NULL PRIMARY KEY,
|
|
from_profileId TEXT NOT NULL REFERENCES profiles ON DELETE CASCADE,
|
|
to_userId TEXT NOT NULL REFERENCES users ON DELETE CASCADE,
|
|
relationship TEXT NOT NULL
|
|
);
|
|
|
|
CREATE INDEX "user_connections_from_profileId" ON "user_connections" ("from_profileId");
|
|
CREATE INDEX "user_connections_to_userId" ON "user_connections" ("to_userId");
|
|
|
|
-- Down
|
|
|