Bnei-Baruch/mdb

View on GitHub
migrations/2022-02-26_226:46:47_users_accountid_not_null._sql

Summary

Maintainability
Test Coverage
-- MDB generated migration file
-- rambler up
ALTER TABLE users
    ALTER COLUMN account_id SET NOT NULL;

CREATE UNIQUE INDEX users_accaunt_id_idx ON users (account_id)
    WHERE account_id IS NOT NULL;


-- rambler down

ALTER TABLE users
    ALTER COLUMN accounts_id DROP NOT NULL;

DROP INDEX IF EXISTS users_accaunt_id_idx;