backup_tar

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.1
-- Dumped by pg_dump version 9.5.1

-- Started on 2016-05-25 15:08:57 BST

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;

--
-- TOC entry 1 (class 3079 OID 12623)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 2406 (class 0 OID 0)
-- Dependencies: 1
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 183 (class 1259 OID 17315)
-- Name: clinicians; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE clinicians (
    clinician_id text NOT NULL,
    password_hash text,
    id integer NOT NULL
);


ALTER TABLE clinicians OWNER TO postgres;

--
-- TOC entry 186 (class 1259 OID 17351)
-- Name: clinicians_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE clinicians_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE clinicians_id_seq OWNER TO postgres;

--
-- TOC entry 2407 (class 0 OID 0)
-- Dependencies: 186
-- Name: clinicians_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE clinicians_id_seq OWNED BY clinicians.id;


--
-- TOC entry 185 (class 1259 OID 17342)
-- Name: clinicians_patients; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE clinicians_patients (
    clinician_id text,
    patient_id text,
    id integer NOT NULL
);


ALTER TABLE clinicians_patients OWNER TO postgres;

--
-- TOC entry 188 (class 1259 OID 17371)
-- Name: clinicians_patients_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE clinicians_patients_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE clinicians_patients_id_seq OWNER TO postgres;

--
-- TOC entry 2408 (class 0 OID 0)
-- Dependencies: 188
-- Name: clinicians_patients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE clinicians_patients_id_seq OWNED BY clinicians_patients.id;


--
-- TOC entry 184 (class 1259 OID 17331)
-- Name: letters; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE letters (
    topic text,
    recipient text,
    patient_id text,
    status text,
    date_created date,
    id integer NOT NULL
);


ALTER TABLE letters OWNER TO postgres;

--
-- TOC entry 187 (class 1259 OID 17361)
-- Name: letters_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE letters_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE letters_id_seq OWNER TO postgres;

--
-- TOC entry 2409 (class 0 OID 0)
-- Dependencies: 187
-- Name: letters_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE letters_id_seq OWNED BY letters.id;


--
-- TOC entry 181 (class 1259 OID 17295)
-- Name: patients; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE patients (
    patient_id text NOT NULL,
    first_name text,
    last_name text,
    email text,
    mobile_number text,
    password_hash text,
    id integer NOT NULL
);


ALTER TABLE patients OWNER TO postgres;

--
-- TOC entry 182 (class 1259 OID 17303)
-- Name: patients_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE patients_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE patients_id_seq OWNER TO postgres;

--
-- TOC entry 2410 (class 0 OID 0)
-- Dependencies: 182
-- Name: patients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE patients_id_seq OWNED BY patients.id;


--
-- TOC entry 2270 (class 2604 OID 17353)
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY clinicians ALTER COLUMN id SET DEFAULT nextval('clinicians_id_seq'::regclass);


--
-- TOC entry 2272 (class 2604 OID 17373)
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY clinicians_patients ALTER COLUMN id SET DEFAULT nextval('clinicians_patients_id_seq'::regclass);


--
-- TOC entry 2271 (class 2604 OID 17363)
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY letters ALTER COLUMN id SET DEFAULT nextval('letters_id_seq'::regclass);


--
-- TOC entry 2269 (class 2604 OID 17305)
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY patients ALTER COLUMN id SET DEFAULT nextval('patients_id_seq'::regclass);


--
-- TOC entry 2393 (class 0 OID 17315)
-- Dependencies: 183
-- Data for Name: clinicians; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO clinicians VALUES ('myuniqueid', '$2a$10$ARGOjAZWs6cLYWarXR0ANuXljuanhwei/ids9EzEiKi6MaCkBO.cy', 1);
INSERT INTO clinicians VALUES ('myuniqueid2', '$2a$10$XKwvUFEqH53Od/bJ6v9V5OxTnPIABRj2D7Dgwm0JqtP5eOwhvcuBC', 2);


--
-- TOC entry 2411 (class 0 OID 0)
-- Dependencies: 186
-- Name: clinicians_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('clinicians_id_seq', 2, true);


--
-- TOC entry 2395 (class 0 OID 17342)
-- Dependencies: 185
-- Data for Name: clinicians_patients; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO clinicians_patients VALUES ('myuniqueid', '0434hg048', 1);


--
-- TOC entry 2412 (class 0 OID 0)
-- Dependencies: 188
-- Name: clinicians_patients_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('clinicians_patients_id_seq', 1, true);


--
-- TOC entry 2394 (class 0 OID 17331)
-- Dependencies: 184
-- Data for Name: letters; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO letters VALUES ('Katherines Health', 'Mum', '0434hg048', 'Sent', '2016-01-08', 1);
INSERT INTO letters VALUES ('', 'Mum', 'fhew9aph983', 'Sent', '2015-06-03', 4);


--
-- TOC entry 2413 (class 0 OID 0)
-- Dependencies: 187
-- Name: letters_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('letters_id_seq', 1, true);


--
-- TOC entry 2391 (class 0 OID 17295)
-- Dependencies: 181
-- Data for Name: patients; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO patients VALUES ('09876543', 'Rob', 'Stallion', 'biggansta@founder.com', '084385934', '$2a$10$O3RSih9BCi5Tm7wAHG2hTOE8n/aSNEdQx051eOeZkuuc5N.AJzLKu', 1);
INSERT INTO patients VALUES ('098765432', 'Virginie', 'Trubiano', 'vt@founer.com', '0434873582', '$2a$10$MN2HMzdZlaLnneTymhAa.Or/xVTutmAaDKePySfYSa5UFodK24mvu', 2);
INSERT INTO patients VALUES ('0434hg048', 'Katherine', 'Bow', 'stuff@stuff.com', '077738947305', 'soem_hash', 3);


--
-- TOC entry 2414 (class 0 OID 0)
-- Dependencies: 182
-- Name: patients_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('patients_id_seq', 2, true);


--
-- TOC entry 2274 (class 2606 OID 17302)
-- Name: Patients_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY patients
    ADD CONSTRAINT "Patients_pkey" PRIMARY KEY (patient_id);


--
-- TOC entry 2276 (class 2606 OID 17323)
-- Name: clinicians_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY clinicians
    ADD CONSTRAINT clinicians_pkey PRIMARY KEY (clinician_id);


--
-- TOC entry 2405 (class 0 OID 0)
-- Dependencies: 6
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2016-05-25 15:08:57 BST

--
-- PostgreSQL database dump complete
--