-- Enable `pgcrypto` extension to have safe storage for passwords: CREATE EXTENSION IF NOT EXISTS pgcrypto; -- Enable `citext` extension to have case-insensitive column for logins and addresses; CREATE EXTENSION IF NOT EXISTS citext;