CREATE USER vtapi with PASSWORD 'visiblethread7';

CREATE DATABASE vtapi
  WITH ENCODING='UTF8'
       CONNECTION LIMIT=-1;

ALTER DATABASE vtapi OWNER TO vtapi;

GRANT ALL PRIVILEGES ON DATABASE vtapi TO vtapi;

ALTER ROLE "vtapi" WITH LOGIN;
\c vtapi
ALTER SCHEMA public OWNER TO vtapi;
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";