DO $$
BEGIN
  IF NOT EXISTS (SELECT 1 FROM pg_roles WHERE rolname='clickdelivery_app') THEN
    CREATE ROLE clickdelivery_app LOGIN PASSWORD 'clickdelivery_app_dev';
  END IF;
END $$;