PronounsPage/migrations/071-social-lookup.sql
2023-05-06 17:32:07 +02:00

12 lines
263 B
SQL

-- Up
CREATE TABLE social_lookup (
userId TEXT NOT NULL REFERENCES users ON DELETE CASCADE,
provider TEXT NOT NULL,
identifier TEXT NOT NULL
);
CREATE INDEX "social_lookup_provider_identifier" ON "social_lookup" ("provider", "identifier");
-- Down