text: --
  -- PostgreSQL database dump
  --
  
  -- Dumped from database version 9.5.4
  -- Dumped by pg_dump version 9.5.4
  
  SET statement_timeout = 0;
  SET lock_timeout = 0;
  SET client_encoding = 'UTF8';
  SET standard_conforming_strings = on;
  SET check_function_bodies = false;
  SET client_min_messages = warning;
  SET row_security = off;
  
  --
  -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
  --
  
  CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
  
  
  --
  -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
  --
  
  COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
  
  
  --
  -- Name: uuid-ossp; Type: EXTENSION; Schema: -; Owner: 
  --
  
  CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;
  
  
  --
  -- Name: EXTENSION "uuid-ossp"; Type: COMMENT; Schema: -; Owner: 
  --
  
  COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally unique identifiers (UUIDs)';
  
  
  SET search_path = public, pg_catalog;
  
  SET default_tablespace = '';
  
  SET default_with_oids = false;
  
  --
  -- Name: knex_migrations; Type: TABLE; Schema: public; Owner: postgres
  --
  
  CREATE TABLE knex_migrations (
      id integer NOT NULL,
      name character varying(255),
      batch integer,
      migration_time timestamp with time zone
  );
  
  
  ALTER TABLE knex_migrations OWNER TO postgres;
  
  --
  -- Name: knex_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
  --
  
  CREATE SEQUENCE knex_migrations_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  ALTER TABLE knex_migrations_id_seq OWNER TO postgres;
  
  --
  -- Name: knex_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
  --
  
  ALTER SEQUENCE knex_migrations_id_seq OWNED BY knex_migrations.id;
  
  
  --
  -- Name: knex_migrations_lock; Type: TABLE; Schema: public; Owner: postgres
  --
  
  CREATE TABLE knex_migrations_lock (
      is_locked integer
  );
  
  
  ALTER TABLE knex_migrations_lock OWNER TO postgres;
  
  --
  -- Name: notes; Type: TABLE; Schema: public; Owner: postgres
  --
  
  CREATE TABLE notes (
      id uuid DEFAULT uuid_generate_v4() NOT NULL,
      title character varying(255),
      body character varying(255)
  );
  
  
  ALTER TABLE notes OWNER TO postgres;
  
  --
  -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY knex_migrations ALTER COLUMN id SET DEFAULT nextval('knex_migrations_id_seq'::regclass);
  
  
  --
  -- Name: knex_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY knex_migrations
      ADD CONSTRAINT knex_migrations_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: notes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY notes
      ADD CONSTRAINT notes_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: public; Type: ACL; Schema: -; Owner: sasa
  --
  
  REVOKE ALL ON SCHEMA public FROM PUBLIC;
  REVOKE ALL ON SCHEMA public FROM sasa;
  GRANT ALL ON SCHEMA public TO sasa;
  GRANT ALL ON SCHEMA public TO PUBLIC;
  
  
  --
  -- PostgreSQL database dump complete
  --
  
  