SET ROLE social;

CREATE SCHEMA api;

SET ROLE postgres;
CREATE EXTENSION hstore SCHEMA api;
SET ROLE social;

GRANT usage ON SCHEMA api to socialapplication;

ALTER DATABASE social set search_path="$user", public, api;

SET ROLE social;

CREATE SCHEMA api;

SET ROLE postgres;
CREATE EXTENSION IF NOT EXISTS hstore;
SET ROLE social;

GRANT usage ON SCHEMA api to socialapplication;

ALTER DATABASE social set search_path="$user", public, api;

Remove schema dependency for hstore extension
Social: Remove schema dependency for hstore extension
