-- 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