--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.2
-- Dumped by pg_dump version 9.6.2

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_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: cube; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS cube WITH SCHEMA public;


--
-- Name: EXTENSION cube; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION cube IS 'data type for multidimensional cubes';


--
-- Name: earthdistance; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS earthdistance WITH SCHEMA public;


--
-- Name: EXTENSION earthdistance; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION earthdistance IS 'calculate great-circle distances on the surface of the Earth';


--
-- Name: fuzzystrmatch; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS fuzzystrmatch WITH SCHEMA public;


--
-- Name: EXTENSION fuzzystrmatch; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION fuzzystrmatch IS 'determine similarities and distance between strings';


SET search_path = public, pg_catalog;

--
-- Name: discount_status; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE discount_status AS ENUM (
    'usable',
    'used',
    'canceled'
);


ALTER TYPE discount_status OWNER TO postgres;

--
-- Name: location; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE location AS (
	address text,
	city text,
	postalcode text,
	latitude double precision,
	longitude double precision
);


ALTER TYPE location OWNER TO postgres;

--
-- Name: order_status; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE order_status AS ENUM (
    'canceled',
    'finished',
    'pending',
    'paid',
    'created'
);


ALTER TYPE order_status OWNER TO postgres;

--
-- Name: payment; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE payment AS ENUM (
    'none',
    'CB',
    'paypal'
);


ALTER TYPE payment OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: customer; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE customer (
    id uuid NOT NULL,
    code integer NOT NULL,
    firstname text NOT NULL,
    lastname text NOT NULL,
    birthdate date,
    address location NOT NULL,
    addressfallback timestamp without time zone,
    mainphone text NOT NULL,
    otherphone text,
    validatedemail uuid
);


ALTER TABLE customer OWNER TO postgres;

--
-- Name: customer_code_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE customer_code_seq OWNER TO postgres;

--
-- Name: customer_code_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE customer_code_seq OWNED BY customer.code;


--
-- Name: customer_discount; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE customer_discount (
    id uuid NOT NULL,
    created timestamp without time zone NOT NULL,
    code integer NOT NULL,
    publiccode text NOT NULL,
    status discount_status NOT NULL,
    validity timestamp without time zone NOT NULL,
    amount numeric NOT NULL,
    customer uuid NOT NULL,
    linkorder uuid,
    usedorder uuid
);


ALTER TABLE customer_discount OWNER TO postgres;

--
-- Name: customer_discount_code_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE customer_discount_code_seq OWNER TO postgres;

--
-- Name: customer_discount_code_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE customer_discount_code_seq OWNED BY customer_discount.code;


--
-- Name: customer_order; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE customer_order (
    id uuid NOT NULL,
    code integer NOT NULL,
    date timestamp without time zone NOT NULL,
    status order_status NOT NULL,
    statuspayment payment DEFAULT 'none'::payment,
    customer uuid NOT NULL,
    gardenaddress location NOT NULL,
    comment text,
    admincomment text,
    gardener uuid,
    canceldate date,
    validate boolean,
    validatecomment text,
    bill bytea,
    billnumber integer,
    billaddress location NOT NULL,
    tva numeric NOT NULL,
    marge numeric NOT NULL,
    fee numeric NOT NULL,
    totalamout numeric NOT NULL,
    totaldiscount numeric NOT NULL,
    totaltime numeric NOT NULL
);


ALTER TABLE customer_order OWNER TO postgres;

--
-- Name: customer_order_billnumber_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE customer_order_billnumber_seq OWNER TO postgres;

--
-- Name: customer_order_billnumber_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE customer_order_billnumber_seq OWNED BY customer_order.billnumber;


--
-- Name: customer_order_code_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE customer_order_code_seq OWNER TO postgres;

--
-- Name: customer_order_code_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE customer_order_code_seq OWNED BY customer_order.code;


--
-- Name: customer_order_detail; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE customer_order_detail (
    id uuid NOT NULL,
    customer uuid NOT NULL,
    customerorder uuid NOT NULL,
    service text NOT NULL,
    comment text,
    amount numeric NOT NULL,
    "time" numeric NOT NULL,
    parameters jsonb NOT NULL
);


ALTER TABLE customer_order_detail OWNER TO postgres;

--
-- Name: files; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE files (
    id uuid NOT NULL,
    personid uuid,
    date timestamp without time zone NOT NULL,
    type text NOT NULL,
    content bytea
);


ALTER TABLE files OWNER TO postgres;

--
-- Name: gardener; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE gardener (
    id uuid NOT NULL,
    enabled boolean DEFAULT true NOT NULL,
    firstname text NOT NULL,
    lastname text NOT NULL,
    birthdate date,
    address location NOT NULL,
    addressfallback timestamp without time zone,
    mainphone text NOT NULL,
    otherphone text,
    companyname text NOT NULL,
    companynumber text NOT NULL,
    companystatus text,
    companynumbervat text,
    companyrcs text,
    freelancer boolean DEFAULT false NOT NULL,
    services text[]
);


ALTER TABLE gardener OWNER TO postgres;

--
-- Name: gardener_calendar; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE gardener_calendar (
    id uuid NOT NULL,
    day date,
    gardener uuid NOT NULL,
    team uuid NOT NULL,
    teamnumber integer DEFAULT 1,
    slot integer DEFAULT 1,
    customerorder uuid,
    datereserved timestamp without time zone,
    dateconfirmed timestamp without time zone,
    CONSTRAINT gardener_calendar_slot_check CHECK (((slot >= 1) AND (slot <= 8)))
);


ALTER TABLE gardener_calendar OWNER TO postgres;

--
-- Name: gardener_team; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE gardener_team (
    id uuid NOT NULL,
    name text NOT NULL,
    number integer DEFAULT 1,
    phone text,
    gardener uuid,
    deleted boolean DEFAULT false
);


ALTER TABLE gardener_team OWNER TO postgres;

--
-- Name: pages; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE pages (
    id uuid NOT NULL,
    path text NOT NULL,
    title text NOT NULL,
    content text NOT NULL,
    lastmodification timestamp without time zone NOT NULL,
    lastpublication timestamp without time zone
);


ALTER TABLE pages OWNER TO postgres;

--
-- Name: person; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE person (
    id uuid NOT NULL,
    created timestamp without time zone NOT NULL,
    email text NOT NULL,
    password text NOT NULL
);


ALTER TABLE person OWNER TO postgres;

--
-- Name: zipgeo; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE zipgeo (
    city text,
    zipcode text,
    citycode text,
    latitude double precision,
    longitude double precision
);


ALTER TABLE zipgeo OWNER TO postgres;

--
-- Name: customer code; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer ALTER COLUMN code SET DEFAULT nextval('customer_code_seq'::regclass);


--
-- Name: customer_discount code; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_discount ALTER COLUMN code SET DEFAULT nextval('customer_discount_code_seq'::regclass);


--
-- Name: customer_order code; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_order ALTER COLUMN code SET DEFAULT nextval('customer_order_code_seq'::regclass);


--
-- Data for Name: customer; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY customer (id, code, firstname, lastname, birthdate, address, addressfallback, mainphone, otherphone, validatedemail) FROM stdin;
f3128fc7-51bd-431f-91c4-c7c0768afbdb	100000	Mathieu	Fosse	1985-07-18	("23 rue de caen","Aunay sur odon",14260,-0.[REDACTED],49.0236053466796875)	\N	0674921357	\N	4c9a43a7-a1eb-4ec3-8e8d-cb4a9f73ce70
5673ef57-ca19-4572-8b56-38c1982ebc44	100001	romain	delaitre	1985-09-09	("3 impasse de la meheudiere","st remy",14570,-0.506476998329162598,48.9308013916015625)	\N	0123456789	\N	\N
\.


--
-- Name: customer_code_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('customer_code_seq', 100001, true);


--
-- Data for Name: customer_discount; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY customer_discount (id, created, code, publiccode, status, validity, amount, customer, linkorder, usedorder) FROM stdin;
\.


--
-- Name: customer_discount_code_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('customer_discount_code_seq', 100000, false);


--
-- Data for Name: customer_order; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY customer_order (id, code, date, status, statuspayment, customer, gardenaddress, comment, admincomment, gardener, canceldate, validate, validatecomment, bill, billnumber, billaddress, tva, marge, fee, totalamout, totaldiscount, totaltime) FROM stdin;
ac38ebeb-41ad-4e93-8dd4-3e6fdd1656f1	100000	2017-03-06 12:39:05.895	canceled	CB	5673ef57-ca19-4572-8b56-38c1982ebc44	("3 impasse de la meheudiere","st remy",14570,-0.506476998329162598,48.9308013916015625)		\N	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	\N	\N	\N	\N	\N	("3 impasse de la meheudiere","st remy",14570,-0.506476998329162598,48.9308013916015625)	1.2	0.8	36.0	76.50	0.0	1.0
\.


--
-- Name: customer_order_billnumber_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('customer_order_billnumber_seq', 100000, false);


--
-- Name: customer_order_code_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('customer_order_code_seq', 100000, true);


--
-- Data for Name: customer_order_detail; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY customer_order_detail (id, customer, customerorder, service, comment, amount, "time", parameters) FROM stdin;
45c48225-3d33-48f3-9097-598b4b39e3ca	5673ef57-ca19-4572-8b56-38c1982ebc44	ac38ebeb-41ad-4e93-8dd4-3e6fdd1656f1	mow	\N	40.50	1.0	{"surface": "500"}
\.


--
-- Data for Name: files; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY files (id, personid, date, type, content) FROM stdin;
\.


--
-- Data for Name: gardener; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY gardener (id, enabled, firstname, lastname, birthdate, address, addressfallback, mainphone, otherphone, companyname, companynumber, companystatus, companynumbervat, companyrcs, freelancer, services) FROM stdin;
3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	t	Romich	Delaitre	\N	("3 impasse de la meheudiere","st remy",14570,-0.506476998329162598,48.9308013916015625)	\N	0123456789		romich SA	01234567896544	SAS	15121212424242	02154642315454	f	{mow,scarify,cutHedge,reduceHedge}
b396efa0-fa1c-429d-bac2-9bcd26440693	t	Mathieu	Fosse	\N	("102 avenue henry cherron",Caen,14000,-0.396643012762069702,49.1721725463867188)	\N	0674921357	0674921357	Au plaisir du jardin	555444333		FR 99988877755	555444333	t	{mow,scarify,cutHedge,reduceHedge,cutBush,cutBushClassic,cutBushRose,cutBushTopiary,cutBushClimbing,clearing,pipping,removeLeaves,cleaner,request}
\.


--
-- Data for Name: gardener_calendar; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY gardener_calendar (id, day, gardener, team, teamnumber, slot, customerorder, datereserved, dateconfirmed) FROM stdin;
37318b7e-1e3d-4942-899f-4b1ba1682b58	2017-03-06	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	1	\N	\N	\N
56bcc502-691e-4a5a-b6fc-0f756a1f162e	2017-03-06	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	2	\N	\N	\N
d2f6c3b6-9d6f-424a-bfa8-0d9c8eb753ca	2017-03-06	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	3	\N	\N	\N
17d581e5-7f4b-44f9-9305-66bf2001b5fc	2017-03-06	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	4	\N	\N	\N
bdbdf06e-d291-4bc7-9557-a2ef819047a7	2017-03-06	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	5	\N	\N	\N
e60c253e-0de7-4770-a602-53544e37f81c	2017-03-06	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	6	\N	\N	\N
fe8ef256-496a-491a-803c-72df2263a4dc	2017-03-06	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	7	\N	\N	\N
3b6e9879-163a-4e2d-97ca-4b2aa1fb1e5c	2017-03-06	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	8	\N	\N	\N
5374184f-a455-41d6-b521-e0959f8bd788	2017-03-07	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	1	\N	\N	\N
4eeaf0c0-1e42-4686-ad34-9d9b439b5528	2017-03-07	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	2	\N	\N	\N
d56022ee-466f-4843-ae73-62e2aa9670be	2017-03-07	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	3	\N	\N	\N
91f30c80-94dd-43d0-83d3-1dc0d3487911	2017-03-07	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	4	\N	\N	\N
6dcfb51d-6742-4d4a-b3bb-e0738c7b6024	2017-03-07	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	5	\N	\N	\N
a831f2b3-10f4-44d7-aab4-4e050863cc07	2017-03-07	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	6	\N	\N	\N
d1c38a50-f88d-4e0b-a7ff-07237bb7986c	2017-03-07	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	7	\N	\N	\N
78378614-6b0d-4690-8e1d-6a65d6e05e82	2017-03-07	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	8	\N	\N	\N
54203c76-88d0-40b5-9d2d-df1523139824	2017-03-08	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	2	\N	\N	\N
822cbec9-55c9-4dcb-a851-da75a092fa10	2017-03-08	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	3	\N	\N	\N
ced6a3c7-6c68-482d-bb0a-d4879c206193	2017-03-08	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	4	\N	\N	\N
bef0ceb1-6cc3-41dd-bc4f-e12564f1603d	2017-03-08	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	5	\N	\N	\N
0c496923-2d8e-4d76-9cd1-058e0c1a70cd	2017-03-08	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	6	\N	\N	\N
cac9ff89-9c36-4f1a-bd85-25f989500754	2017-03-08	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	7	\N	\N	\N
7c28b1d2-af89-4686-abf3-4463f9a28e00	2017-03-08	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	8	\N	\N	\N
9fa40f2a-a7ed-4d30-af9e-fc6516fd9139	2017-03-09	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	1	\N	\N	\N
13162aa9-b004-4c90-adae-b1ac88932318	2017-03-09	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	2	\N	\N	\N
80b4c091-c967-4390-b3d0-b57f7287257f	2017-03-09	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	3	\N	\N	\N
84d8ed3a-a03d-4f10-ab2e-fff4c78b6226	2017-03-09	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	4	\N	\N	\N
f602dd2a-7007-4720-8707-39d2a0a64aac	2017-03-09	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	5	\N	\N	\N
bcdd0776-f95a-438e-a869-8089d73a3308	2017-03-09	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	6	\N	\N	\N
c5a8db03-89c5-4f7f-831a-1ed49e07e45f	2017-03-09	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	7	\N	\N	\N
80ba8c13-0bf4-463b-b0f1-f468b58e62ec	2017-03-09	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	8	\N	\N	\N
bcb4f962-16fd-4988-9919-85010b7c6729	2017-03-10	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	1	\N	\N	\N
80c63fa4-866e-40db-b85a-f0d2214bc70f	2017-03-10	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	2	\N	\N	\N
5ff3e094-d983-4652-9d18-d05952cbfc42	2017-03-10	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	3	\N	\N	\N
a0eec2f2-1f58-4c85-8ebc-6d713bda7da3	2017-03-10	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	4	\N	\N	\N
e7d06339-d096-4905-a0c0-9deb6d975033	2017-03-10	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	5	\N	\N	\N
0fc1ee98-4ee3-4011-90dc-e11d19cf0248	2017-03-10	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	6	\N	\N	\N
2f5db7ba-d1d5-47bd-95e8-f96d12a892c9	2017-03-10	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	7	\N	\N	\N
121d594f-1319-4e84-a1f5-c5753ed4880d	2017-03-10	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	8	\N	\N	\N
eaf1fb7b-a273-411f-a230-9a3142b4b2d3	2017-03-11	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	1	\N	\N	\N
ac14cd2c-da7a-49f3-84a9-e954e7021e85	2017-03-11	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	2	\N	\N	\N
1426df9e-aaa4-4ef2-97b9-098e2eaf2d67	2017-03-11	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	3	\N	\N	\N
6654e31a-8b64-472d-a5c6-5d0f3664c6b6	2017-03-11	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	4	\N	\N	\N
badbb8f7-d386-4b2b-a7dc-b1aec998fa78	2017-03-11	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	5	\N	\N	\N
0325842a-d621-4b68-9da1-52b746a586b2	2017-03-11	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	6	\N	\N	\N
5e6b53c8-1e84-497d-a068-ad23223c1c4a	2017-03-11	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	7	\N	\N	\N
74d5f723-3ac1-4513-8c8d-527a1038b0b3	2017-03-11	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	8	\N	\N	\N
e59195a5-469f-4d25-8a16-f044fa201478	2017-03-04	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	1	\N	\N	\N
ce03c727-b03b-455a-bdf6-f28876d58147	2017-03-04	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	2	\N	\N	\N
b9384e20-10b5-4617-89a0-2299fd013750	2017-03-04	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	3	\N	\N	\N
c852c80b-609b-454f-9b13-e2ef33b3849d	2017-03-04	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	4	\N	\N	\N
5b1ccc92-06ae-42d8-8037-393f9f6237e6	2017-03-04	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	5	\N	\N	\N
7b275baf-f619-400b-989c-ec3b7511a24c	2017-03-04	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	6	\N	\N	\N
e5c63184-9896-4e8f-a8b8-815d3372bb87	2017-03-04	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	7	\N	\N	\N
42e47eac-7ca0-4455-8f50-e72877cffa2b	2017-03-04	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	8	\N	\N	\N
cb4be482-09f1-441a-8fef-afad3e3bfeb2	2017-03-03	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	1	\N	\N	\N
b868ad22-7fa7-4c8f-8bd3-6e2d4cbb35cd	2017-03-03	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	2	\N	\N	\N
dd89b8b8-bc20-49c3-83b7-03b0f3262b04	2017-03-03	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	3	\N	\N	\N
815ff719-0774-4b0f-b284-d77a18466fe0	2017-03-03	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	4	\N	\N	\N
c139450a-6604-4cfa-bff3-530a5fc36de4	2017-03-03	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	5	\N	\N	\N
c28bc44e-2ff0-4a6b-b823-682787711677	2017-03-03	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	6	\N	\N	\N
36e4ed13-5d4d-4de4-aa8d-fbcd63ea18cd	2017-03-03	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	7	\N	\N	\N
6d94df9f-695d-4a18-bdd7-2e96ddf5b2ba	2017-03-03	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	8	\N	\N	\N
39f2c510-7986-4642-b532-1870a4c836dc	2017-03-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
e712a54a-c562-45e9-8a81-969ed7263a5e	2017-03-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
1d061c04-b3e0-4a3d-ab44-ed50ab28e19a	2017-03-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
4c3ac452-4a2f-4f34-b141-c603a48517ca	2017-03-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
59f8172e-1d7f-4edc-b9f7-3225269dac9a	2017-03-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
c6812e63-4308-4db6-b776-2f4c5afe95d9	2017-03-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
b3de377d-61c3-42e6-9612-6b4d2ff55ab8	2017-03-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
4363e2da-b5ef-448e-b9b0-94a18a7e21a9	2017-03-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
1131c767-f50e-444b-81da-fc4a7d30856c	2017-03-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
200fa5ca-8bb3-43f8-8fd5-a3a89d84c084	2017-03-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
66f3d041-4d26-4031-9c56-2a3dbe87577b	2017-03-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
7401bfc2-8402-4531-8496-8005c503bba3	2017-03-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
aee9c3de-de10-4a0e-8d83-7dfa7706fe93	2017-03-09	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
cd319d5a-bdbf-4ba2-a918-d59f6ea63fba	2017-03-09	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
f69cf207-1391-4d32-b7fa-fb6415aee181	2017-03-09	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
529439a0-68bc-4edf-9d9c-9fc5e44bafde	2017-03-09	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
4f252088-277a-4e04-ba4f-13bca0ed9b2f	2017-03-10	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
e37ac3c6-d29c-4afd-93d9-7d7fd4395422	2017-03-10	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
20fc7325-0970-4e2c-bb38-f9a790c5dec3	2017-03-10	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
38e2254e-5ecf-46a2-b9c1-3db2e2126b00	2017-03-10	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
ed9c9812-7098-41ed-8260-7c54857f4bf7	2017-03-11	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
106ec5d4-2791-48c0-a2d7-f50aa770d711	2017-03-11	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
494a3cc8-23e5-410d-a114-214176391721	2017-03-11	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
ebe49519-b6ab-4b58-9787-12442c51af0b	2017-03-11	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
41856804-dad2-40d8-8a87-3f73cd00c74a	2017-03-08	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f2182045-37be-4705-9864-f269c420e83d	4	1	\N	\N	\N
78c8d07a-a0a2-44fa-8601-5536190f927a	2017-03-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
624868d7-f71e-4eeb-b342-2da2798361b9	2017-03-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
5b435c2b-406a-472b-9e59-7760585b9bcd	2017-03-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
a3092208-8c95-49e6-b113-3fb0bfc488dd	2017-03-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
5d0d3f87-de57-406e-8127-b4fe6b712608	2017-03-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
42aef764-b24f-4345-938f-b85f1492baef	2017-03-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
400f93ee-1d9c-4346-af4d-3ca19c83b59b	2017-03-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
009978be-8826-47aa-b6d1-b2b968bbc26a	2017-03-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
afc84e03-2cf2-4670-ab62-e9a049d841a7	2017-03-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
b13d39c4-f633-4deb-91e3-73853448956e	2017-03-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
631b0587-1c98-4bc5-9eb7-93b47d7780a6	2017-03-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
26ca7b1f-5855-4a49-97ec-5385573655e8	2017-03-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
5064357f-b8c7-494b-8905-efda6a8ee096	2017-03-09	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
25318ea8-c895-486a-a2b9-ad251d089bc7	2017-03-09	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
38811c72-495c-49a3-a9e1-dfd742b09b2f	2017-03-09	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
051b5b6e-184e-4b39-9d10-7df5f05915c2	2017-03-09	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
d0f16e07-9ad4-41b3-822c-53e09f920ea8	2017-03-10	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
ee2fc04d-b94a-47de-bc47-2b76f0d97b56	2017-03-10	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
9a4fb700-f1a9-4bd6-899c-d80bb2b6bd01	2017-03-10	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
c9ac78c2-e9a4-4801-a125-2d1d1b4c102c	2017-03-10	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
8a878322-ce7c-49d8-859d-3a3022837cf3	2017-03-11	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
b2568368-ba3a-428a-9b5c-2796ae93489a	2017-03-11	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
09c5bc71-b7ba-4c20-a6ab-524a3a7c4645	2017-03-11	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
4117097f-d7a1-4db5-a44e-e61169bac209	2017-03-11	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
ec27ec57-4f15-4910-92a3-6aa886f97e04	2017-03-13	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
29a37242-d942-41e8-8ff2-d6d8b5298ffa	2017-03-13	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
c9368807-6df4-4b59-9550-9f35b7407979	2017-03-13	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
87b2c6ac-3991-41d5-a137-0c3457b369b1	2017-03-13	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
98065dec-0036-4cc1-9467-e406238c2c25	2017-03-13	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
d502bd71-3bf4-43be-a65d-77bcdf1ddda7	2017-03-13	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
9f15b8b9-ad5c-4047-992c-a338db4e43ae	2017-03-13	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
897e3c86-f674-4d01-98f5-6fca4e7a5b80	2017-03-13	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
793bd80b-b772-4f30-8a37-37bb0ba52859	2017-03-14	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
e2fecce4-8cd7-46f1-b32a-d704bea8b876	2017-03-14	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
5f1b7b4f-576a-4e94-998e-b6854383ee45	2017-03-14	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
0f9e8f27-25f3-494b-be80-5762cd17e020	2017-03-14	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
bdf5832f-82be-403b-abb4-8f638c5b1274	2017-03-14	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
ded19c9e-ebda-42ad-8546-ef3674868f5d	2017-03-14	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
a94b19d2-ce18-4c43-967d-83e70f91f3da	2017-03-14	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
668a5b7d-38cb-476b-8555-1d9af485ac06	2017-03-14	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
652c9634-014c-4aa3-b52c-a2b14bd9613a	2017-03-15	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
3f887bf5-f4c5-42f7-ae34-664252d25b99	2017-03-15	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
f118c8c4-4a77-42eb-b360-cd396a2e367e	2017-03-15	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
ae70e4af-5d54-4025-ac0f-4f6382022227	2017-03-15	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
53f20ecc-6a44-405e-ad1a-348b42bba883	2017-03-15	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
7d244d66-6e13-4cfb-b3e4-788477864205	2017-03-15	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
76c37b33-d662-4b85-b0f6-33bc7e4afcad	2017-03-15	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
7d80fb39-03f7-481f-be29-0f8ff3cf46f8	2017-03-15	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
cc27ae81-ae4f-43b6-8996-4df5f10c8d0b	2017-03-16	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
240da15d-fe19-4c6e-948f-20f58393694f	2017-03-16	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
e33bfb87-41da-4a7b-b04d-611ea3634345	2017-03-16	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
2e4737a1-d2a3-42ef-908c-67be81f4a059	2017-03-16	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
70324e27-5f42-4db9-b11f-01a790775080	2017-03-16	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
d7b20cc9-b1e7-403d-8995-e92da2c602c1	2017-03-16	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
9e6c25de-c93b-4188-a86b-fb34e96d834d	2017-03-16	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
1203b5a4-899d-4850-97db-a72f904bf841	2017-03-16	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
a8104e67-f8d0-4d9f-a8cb-48a113c3e6eb	2017-03-17	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
a01f9a77-1025-4fca-9b7c-1e227686c7e0	2017-03-17	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
90d03c50-aea9-4c51-b2c5-5bedde9d5594	2017-03-17	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
734fb439-aeeb-4c15-a288-94e3ce35f5e9	2017-03-17	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
2721043d-70ac-4ede-831a-fe56b0681ba0	2017-03-17	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
4eaa7719-1b3d-421d-ad2b-b03911e9cddd	2017-03-17	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
c8373252-13ce-429a-a090-80ff193615f7	2017-03-17	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
b1e97cf6-af31-431f-9053-447c169f4d9d	2017-03-17	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
f27c3b48-3e0b-47b9-bcfe-4d3aa9c44099	2017-03-18	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
e5e80a99-650d-4e2e-b233-f49f9c33ec38	2017-03-18	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
0d2009a0-9bd2-4753-849d-7d31cd19870a	2017-03-18	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
a734657c-a80a-4b0a-ac55-4076697d7237	2017-03-18	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
2d0c387e-20c3-4cdb-ae97-886870e9782d	2017-03-18	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
3df58dda-5052-44f3-b2fd-be8a6162987b	2017-03-18	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
45ee94e2-fd8e-4ebc-a405-2f2ffe8ad0da	2017-03-18	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
7d9e2611-0a28-4c90-98a0-f9a01e2a00d0	2017-03-18	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
26b267a0-7bad-46e2-a8e6-dc08f1275c5e	2017-03-20	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
378ff618-0f70-42da-808f-96af37eccc5c	2017-03-20	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
f7133f48-6907-4f9a-88bb-2d3645307997	2017-03-20	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
8a64e3aa-1ccc-44cf-b969-6061222574a9	2017-03-20	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
8506d753-0797-4cec-a9cf-03406501e233	2017-03-20	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
13400c9e-90b7-4a63-bfbf-56f92fa94bdd	2017-03-20	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
018c1619-9361-4118-b098-4b6527b410f4	2017-03-20	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
78fcd948-0f19-4164-a291-d30cfe2f9ff3	2017-03-20	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
b9099e64-7fa4-4395-b633-468c0c938a53	2017-03-21	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
6e884ea3-8260-46a4-9bed-ba071fca0fbb	2017-03-21	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
e70917e5-0796-4992-9b7b-399022209b4b	2017-03-21	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
c5409fe6-6f72-48bf-a595-78addecbd4a2	2017-03-21	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
d716608e-c5a5-4efd-b5e3-03fd3392232f	2017-03-21	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
efce3c98-6623-46ff-86eb-18fafb49b4b2	2017-03-21	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
a6840506-53e1-469e-a7b4-184de51afc0d	2017-03-21	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
889d2b52-4b35-4044-bcf8-682430710594	2017-03-21	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
77ea9c64-87ad-4172-9365-3770f3e79037	2017-03-22	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
f11b70f2-c8e2-4484-b640-513be5da792e	2017-03-22	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
d49346e4-51a8-4bc8-8c3f-39a82c949d49	2017-03-22	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
58f631e0-6911-42ee-8672-8e967f096044	2017-03-22	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
d2adf311-f120-4c98-9c08-5a3265836e76	2017-03-22	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
a350c8f3-a88f-4e4d-a0d8-2d6801870ed7	2017-03-22	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
f956e013-fb22-43c7-bdb7-f7f2f32740a1	2017-03-22	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
68a0db66-1d87-4e57-b284-3f42d3f26507	2017-03-22	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
a9433761-2059-4825-b747-7812592018d7	2017-03-23	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
1c776f67-d19c-41f4-be19-467c85bae470	2017-03-23	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
cbeffcc2-0b48-48a9-923b-11070751ec9a	2017-03-23	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
8c9757d5-0339-4e5d-aa2b-4fb53d2b2d2d	2017-03-23	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
474fed52-8339-4b2b-bfa8-01e1c154f9af	2017-03-23	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
17a11d76-c194-4cbf-98b5-e2988d884549	2017-03-23	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
1d07888d-d7be-4855-ab58-9f432ca8771f	2017-03-23	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
b8c895d6-9217-4d54-8f00-c1e91b5159eb	2017-03-23	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
cd06729b-8c78-4ad2-a219-7c7752465bb0	2017-03-24	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
f1182044-eb7b-4002-a36c-7055235262f4	2017-03-24	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
f2a8dbab-59d4-4746-9e00-0e44320d0bb3	2017-03-24	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
70a6da7e-0832-46e6-ba5f-969d374a587a	2017-03-24	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
e1fbb5a7-8514-4d91-b800-f18f3a6df8fe	2017-03-24	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
430229a0-e656-4833-9df8-27f11b08ec51	2017-03-24	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
c684fd4e-93e2-424b-8aaf-44279da2cff1	2017-03-24	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
048ded98-3718-427b-b2b5-efd6fd82e068	2017-03-24	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
208d4833-fbd4-48b0-8af8-1d1531097843	2017-03-25	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
1a83d041-b422-4afb-a218-493d24df825c	2017-03-25	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
52f91d68-756f-4911-97a7-37e05bad8587	2017-03-25	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
57cbc724-0c32-4488-adef-5269645d5815	2017-03-25	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
98350770-0450-464f-adaf-a069a61da3ea	2017-03-25	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
ea4e1fd1-e6ee-4ec2-87cc-6079dafc0e25	2017-03-25	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
462089ca-8298-440c-a647-8a0b47ddce44	2017-03-25	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
c5f439c5-a9ab-45c9-8e60-e6cccc8528ec	2017-03-25	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
3c7b73a4-be13-4d01-b5c9-eeca6072b485	2017-03-27	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
db1bbc39-7af3-45e5-bcb6-ecb7a257b01b	2017-03-27	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
6d2f3e2a-f8a3-4ce1-a4a0-85bf9e665d22	2017-03-27	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
f5ea51e6-cd14-4ca4-8aa2-8155efd777d0	2017-03-27	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
0d474627-509a-4019-b565-133fe152e29b	2017-03-27	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
5acfb1ce-e761-4d70-9759-052bf1564ae6	2017-03-27	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
fdb34e37-669d-493b-86d7-0eef5adc8adb	2017-03-27	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
e17aba7a-a3f7-4e1a-b136-5f9443f90f74	2017-03-27	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
b8f0d9f6-fab1-4258-8837-f91779956e01	2017-03-28	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
2fd51eda-6c6a-4158-8712-dcd3af282e1b	2017-03-28	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
b31e10e8-159f-493c-801f-3e0394a95ed8	2017-03-28	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
2b7af4b0-26eb-43a6-963a-3679d6a63fb4	2017-03-28	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
9a8155f3-0cab-480f-a064-85a91967637f	2017-03-28	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
e6005d7c-262e-4615-a6c0-82a7f345cbbc	2017-03-28	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
aeec6b52-206b-43f3-ac1b-066c5c44c4b2	2017-03-28	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
ee4ba9f1-cb0b-47ee-b882-7032de8f9ac3	2017-03-28	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
0a4a7c9a-82c7-45f7-9ac8-1014fb3254f5	2017-03-29	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
29d7dc91-e3d7-4876-970d-c867f69d0a21	2017-03-29	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
4b33e917-e4e1-4dc2-8ff9-957d29f3d947	2017-03-29	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
6e7ae7dd-d020-4b3e-8bd7-e51c3de1f7df	2017-03-29	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
d7b61823-08c5-4863-8751-c7e37d9e27a4	2017-03-29	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
312fbe51-b92c-4db0-836f-8aba29659961	2017-03-29	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
9b148129-d5b8-46f9-9184-58e09feabd74	2017-03-29	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
d18ca6e7-83c6-4b10-aa23-7c0f2a6df466	2017-03-29	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
7562d9db-3887-4d58-9991-dbe875fbc3e1	2017-03-30	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
ea9abb1d-0ccf-47cb-aa00-36bd297833a1	2017-03-30	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
292f8a08-62d4-401f-9935-8f56ebe29fc5	2017-03-30	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
7307976a-e49c-410b-8176-b228f9f494bd	2017-03-30	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
4022be31-e1c9-4715-a680-1c945442793a	2017-03-30	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
daa57630-311e-4073-bdea-97f2e2bc6f45	2017-03-30	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
cd8760e3-bc82-451c-a3ba-1e0453dfabeb	2017-03-30	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
04aa72b4-2fd5-4e5a-8f10-7039d936529f	2017-03-30	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
4d8ae453-b18b-470b-b449-3c263436e792	2017-03-31	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
fcc4d235-1b44-47ba-ae9e-c322e2880598	2017-03-31	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
a576604b-677b-42d2-96a4-2ec1e0a01b91	2017-03-31	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
12736e17-9307-4fed-9c70-cb794b20dfdd	2017-03-31	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
5410e260-a913-4999-94e1-6b6b11d1bf8c	2017-03-31	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
cd5791a1-a07f-444e-852f-5840a65c4234	2017-03-31	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
d5d6dd30-aa1c-47cc-b556-a9d949582b5a	2017-03-31	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
973a20c1-87fd-480b-abf1-7534138a4cd0	2017-03-31	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
f286a833-e0f1-4b4b-926c-031fbdc68518	2017-04-01	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
1b193b78-5211-435c-b785-c53096e3203c	2017-04-01	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
4c087dfd-fb62-403e-a51b-c3b242d75dce	2017-04-01	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
e0839744-315b-4232-bf3d-da0bc170f1f9	2017-04-01	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
fa1b80b3-ed5b-430f-8f82-c72df633276f	2017-04-01	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
b6d17c96-5f81-497b-8509-eb43b5f88e9e	2017-04-01	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
17525691-0d45-4002-979e-6e207ad191a3	2017-04-01	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
c2939d55-e657-4cd4-a38f-380aed04f73f	2017-04-01	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
fd223547-a50c-4811-b068-459b9635de2b	2017-04-03	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
9c3d7320-2f40-4004-ae1b-410c06c85f49	2017-04-03	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
323fbf7b-35ce-478b-a375-3701baea6a1f	2017-04-03	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
2cddfb83-f281-4e7f-a5f0-f053bec1bb90	2017-04-03	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
e9ef45f6-2338-4171-a1dc-1d6195204374	2017-04-03	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
37e045d8-dcd9-4d13-b9fb-7dc6703b099a	2017-04-03	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
3109e537-e696-42fb-8886-eff0bc9a7409	2017-04-03	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
c277167f-ed38-43ae-8aae-941d41555367	2017-04-03	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
2611ef34-6c80-4b0c-8509-5a9bb7340025	2017-04-04	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
10916400-86db-4cd3-92c6-96f9f5221c66	2017-04-04	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
719a0c0d-00f0-4285-ae63-3a531142a090	2017-04-04	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
9e48bb20-83aa-467e-bc60-937f43f172bf	2017-04-04	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
67a5c637-2fdd-4304-aa07-7cacc63e1692	2017-04-04	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
7b9d62b1-fd9e-49cd-a05b-1abf69af8008	2017-04-04	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
e006f092-4ef2-49d0-a527-d7332ea7c25b	2017-04-04	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
03e8fb3f-fcbd-45a7-b6f3-d5060cbf7672	2017-04-04	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
c83139a8-abb9-4c71-b9cb-72751bdefac3	2017-04-05	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
ae3f58a9-8d45-4c25-9f60-811fc38fd396	2017-04-05	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
96b699c4-c67b-4bda-b60f-0cf5798ee80d	2017-04-05	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
679ceed3-b697-464a-b2b4-db842af4ade6	2017-04-05	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
01e84fdd-1716-4c45-a0a8-120b00af8851	2017-04-05	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
a627e596-b10c-4eaa-b1ae-f8b50a8b543c	2017-04-05	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
f17e9415-3447-480f-98e4-413345ee5b21	2017-04-05	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
f12305e7-db30-42a5-a9b3-da1e8d9d9236	2017-04-05	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
546336b2-3c1d-4d09-a71f-36cd8797c829	2017-04-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
dd3fd3b1-1a0d-4624-9a32-b69a9f50d1a8	2017-04-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
1dd516a3-238d-48fd-8dd6-240ce310b36c	2017-04-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
27f5faa5-74e3-416e-8084-f20edac6f27d	2017-04-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
bf5da69d-cf93-472b-94dc-28a8723f4e87	2017-04-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
ecd832a3-827f-40fa-a6ed-ab7637432c99	2017-04-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
80fbedbd-37fb-443c-9049-758e84a1f580	2017-04-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
7b25391a-dc06-4e93-a82b-c940631afb51	2017-04-06	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
148e8fed-2b61-4894-bf06-ced8dd0f6a65	2017-04-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
3cd766ad-a421-4dee-8f70-b44110090461	2017-04-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
b413f7c7-aa5a-464a-98d1-f421999a5366	2017-04-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
e63b8e38-332d-4096-99da-b0c93471c53c	2017-04-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
70d889f7-933f-4bfc-8eed-276523ace8fd	2017-04-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
b9077639-6eb1-46f7-9c0c-b116b2c7c5fd	2017-04-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
f6f26a8f-655c-4a16-9930-299e10ca4880	2017-04-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
6257dd3c-ea0f-4751-ab96-b36a4b2b0b7c	2017-04-07	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
bb5abbd9-f386-49da-b1fd-73996ef3d719	2017-04-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	1	\N	\N	\N
2a1f90e3-48f9-4336-86d4-465d1eca48e8	2017-04-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	2	\N	\N	\N
cf37959b-1ef6-4d52-b385-f2c78c8f1a87	2017-04-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	3	\N	\N	\N
61504545-c4cf-4c33-b493-a8802b52c3ad	2017-04-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	4	\N	\N	\N
1ac72cec-ab0e-4a2f-bfc2-9cdcd83e8d49	2017-04-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	5	\N	\N	\N
4ae5b69a-dc53-42fa-9a84-7bd273247c70	2017-04-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	6	\N	\N	\N
70e2e6a1-c293-4a2b-b90b-394ad7ea66bd	2017-04-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	7	\N	\N	\N
c184fc4c-2d59-4623-a40a-55784a5fa5d8	2017-04-08	b396efa0-fa1c-429d-bac2-9bcd26440693	fb618d02-75e9-4d27-a1c7-3d67564999e3	1	8	\N	\N	\N
\.


--
-- Data for Name: gardener_team; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY gardener_team (id, name, number, phone, gardener, deleted) FROM stdin;
f2182045-37be-4705-9864-f269c420e83d	Équipe par défaut	1	\N	3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	f
fb618d02-75e9-4d27-a1c7-3d67564999e3	Équipe par défaut	1	\N	b396efa0-fa1c-429d-bac2-9bcd26440693	f
\.


--
-- Data for Name: pages; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY pages (id, path, title, content, lastmodification, lastpublication) FROM stdin;
a0973ad6-8637-4dbf-9d89-cabaaee76608	help	Besoin d'aide		2017-03-05 14:59:23.818723	\N
9edc2789-ae36-4a73-b709-bc41c06f2ba2	cgu	CGU		2017-03-05 14:59:23.843803	\N
0aad2baa-5082-4eca-8bb6-a4721c46a95b	cgv	CGV		2017-03-05 14:59:23.852141	\N
dd3483f5-ea21-44b8-badd-34bab8c95c3c	comments	Avis		2017-03-05 14:59:23.860467	\N
82550ad4-e48e-411b-bbc6-0c5d720fc222	who	Qui nous sommes	test	2017-03-05 15:43:32.614924	\N
2bd95127-2807-42b4-af9a-54bcfe59642d	mentions	Mentions légales	test	2017-03-05 15:44:51.680281	\N
\.


--
-- Data for Name: person; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY person (id, created, email, password) FROM stdin;
8a873d22-e784-40ae-9fd2-24408c7acf39	2017-03-05 14:59:24.035533	admin	K6Fbnprrt9hjJxEhuYImw3kMdQK0PMW/9GKArSIyQsyOzcKsHalGSiW+1qM9Q6xsFSe+/bAyrPm3j5zpCg3bdF+UE4Z5XIABq+tnzSRqHLTwiGwDx4dJpTntP9JDZ2yHDsgTAcWefWxlSQsPeMIto+YK+dKA+NcchMb97XkMf+E=:mUISmVOPLvphNDCSWBpXyUdgUh9hcwQv4MzO3pQxfSE=
3a2f7f91-75e9-4eeb-8f9f-49a8b327bf7b	2017-03-05 15:01:10.712624	romich@test.com	/CDi3HatBVPpm6JTqgFP+2pCwn+VbSTzWfdU6QCxtscIIwrd9ftxgzC+61Av+v4/V09ssGoMHL1oPwaxyvus4uZSB6Hf2kk+MiP9gqaj0AjSLqDo77aCfYE7DBD6TB7Gzv+25zLO029L4VvJLQ5wYUdgimMe9YMBlDzMteXAyoM=:seRKxu75vUw7fES+rao+Ah/V3rPfGoaU8RWsJgOeAOQ=
f3128fc7-51bd-431f-91c4-c7c0768afbdb	2017-03-06 08:56:08.823025	fossemathieu@gmail.com	V/93Wzn6b1NBbHu6qKDGNESXhsG2828DfHf6HnZ4pyoNiEPCGToq0I0Au5ZpJIMIXtQIxL8Mhs4ct/E5XPRh8316d/0VRECEzv0OpUf0wiMHE2JYzlqcj8+Bm5VyNdNX6upFgBzo23jHhNFpo713suOMggq7ybS64sA/2F9IIPM=:yiKirnvXF1lmZ7esa3cr3IBYxXzR17vV+3TVe/npiss=
b396efa0-fa1c-429d-bac2-9bcd26440693	2017-03-06 09:43:29.976229	monjardinieronline+presta1@gmail.com	BldRH8qxrdSVis7PZoGHooTiQdya6WcQGwpEWgtgVaT4FqpeLOaTt6VYPKd4AXm9biCtVy2nK8Lht3hi3wnnI5e2LpYVKjKBTAfv9NVURuQgLBbr8jkmvs8D6IivCJv7Z9vK7LjEscUIE0gdvSHSFcWTyJC24SDiuU7uvaUTQow=:MOKqcLTMjmHNu+7Rx3bn0XgxhqGAqWp8JMoJp1GDap8=
5673ef57-ca19-4572-8b56-38c1982ebc44	2017-03-06 12:36:18.096935	romain.delaitre@hotmail.fr	8Qd4hR7D/cBI8lpDo+mDDZgAvnN/GpKA21Q831nTWCM88qKRKNgmhHr7BrAj+HHM3I2qAJA50S348+YvfXZ98uDxDnPzpBQQxbB9Ef9WTV2UNfb/5q9nSqCWwnQ7ft1OUP58MTOUKOqVpSthswpo9abGsy7+fokIpufb/uUsaYk=:QR60oHoToDeDBYkJC9Y0AKjmzoC1ncwyf4+DeVdzp9s=
\.


--
-- Data for Name: zipgeo; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY zipgeo (city, zipcode, citycode, latitude, longitude) FROM stdin;
\.


--
-- Name: customer customer_code_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer
    ADD CONSTRAINT customer_code_key UNIQUE (code);


--
-- Name: customer_discount customer_discount_code_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_discount
    ADD CONSTRAINT customer_discount_code_key UNIQUE (code);


--
-- Name: customer_discount customer_discount_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_discount
    ADD CONSTRAINT customer_discount_pkey PRIMARY KEY (id);


--
-- Name: customer_discount customer_discount_publiccode_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_discount
    ADD CONSTRAINT customer_discount_publiccode_key UNIQUE (publiccode);


--
-- Name: customer_order customer_order_code_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_order
    ADD CONSTRAINT customer_order_code_key UNIQUE (code);


--
-- Name: customer_order_detail customer_order_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_order_detail
    ADD CONSTRAINT customer_order_detail_pkey PRIMARY KEY (id);


--
-- Name: customer_order customer_order_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_order
    ADD CONSTRAINT customer_order_pkey PRIMARY KEY (id);


--
-- Name: customer customer_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer
    ADD CONSTRAINT customer_pkey PRIMARY KEY (id);


--
-- Name: files files_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY files
    ADD CONSTRAINT files_pkey PRIMARY KEY (id);


--
-- Name: gardener_calendar gardener_calendar_day_team_slot_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gardener_calendar
    ADD CONSTRAINT gardener_calendar_day_team_slot_key UNIQUE (day, team, slot);


--
-- Name: gardener_calendar gardener_calendar_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gardener_calendar
    ADD CONSTRAINT gardener_calendar_pkey PRIMARY KEY (id);


--
-- Name: gardener gardener_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gardener
    ADD CONSTRAINT gardener_pkey PRIMARY KEY (id);


--
-- Name: gardener_team gardener_team_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gardener_team
    ADD CONSTRAINT gardener_team_pkey PRIMARY KEY (id);


--
-- Name: pages pages_path_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY pages
    ADD CONSTRAINT pages_path_key UNIQUE (path);


--
-- Name: pages pages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY pages
    ADD CONSTRAINT pages_pkey PRIMARY KEY (id);


--
-- Name: person person_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY person
    ADD CONSTRAINT person_email_key UNIQUE (email);


--
-- Name: person person_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY person
    ADD CONSTRAINT person_pkey PRIMARY KEY (id);


--
-- Name: gardener_calendar_customerorder_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gardener_calendar_customerorder_idx ON gardener_calendar USING btree (customerorder);


--
-- Name: gardener_calendar_dateconfirmed_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gardener_calendar_dateconfirmed_idx ON gardener_calendar USING btree (dateconfirmed);


--
-- Name: gardener_calendar_datereserved_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gardener_calendar_datereserved_idx ON gardener_calendar USING btree (datereserved);


--
-- Name: gardener_calendar_day_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gardener_calendar_day_idx ON gardener_calendar USING btree (day);


--
-- Name: gardener_calendar_gardener_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gardener_calendar_gardener_idx ON gardener_calendar USING btree (gardener);


--
-- Name: gardener_calendar_slot_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gardener_calendar_slot_idx ON gardener_calendar USING btree (slot);


--
-- Name: gardener_calendar_team_day_slot_datereserved_dateconfirmed_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gardener_calendar_team_day_slot_datereserved_dateconfirmed_idx ON gardener_calendar USING btree (team, day, slot, datereserved, dateconfirmed);


--
-- Name: gardener_calendar_team_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gardener_calendar_team_idx ON gardener_calendar USING btree (team);


--
-- Name: gardener_calendar_teamnumber_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gardener_calendar_teamnumber_idx ON gardener_calendar USING btree (teamnumber);


--
-- Name: zipgeo_zipcode_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX zipgeo_zipcode_idx ON zipgeo USING btree (zipcode);


--
-- Name: customer_discount customer_discount_customer_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_discount
    ADD CONSTRAINT customer_discount_customer_fkey FOREIGN KEY (customer) REFERENCES customer(id);


--
-- Name: customer_discount customer_discount_linkorder_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_discount
    ADD CONSTRAINT customer_discount_linkorder_fkey FOREIGN KEY (linkorder) REFERENCES customer_order(id);


--
-- Name: customer_discount customer_discount_usedorder_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_discount
    ADD CONSTRAINT customer_discount_usedorder_fkey FOREIGN KEY (usedorder) REFERENCES customer_order(id);


--
-- Name: customer customer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer
    ADD CONSTRAINT customer_id_fkey FOREIGN KEY (id) REFERENCES person(id);


--
-- Name: customer_order customer_order_customer_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_order
    ADD CONSTRAINT customer_order_customer_fkey FOREIGN KEY (customer) REFERENCES customer(id);


--
-- Name: customer_order_detail customer_order_detail_customer_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_order_detail
    ADD CONSTRAINT customer_order_detail_customer_fkey FOREIGN KEY (customer) REFERENCES customer(id);


--
-- Name: customer_order_detail customer_order_detail_customerorder_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_order_detail
    ADD CONSTRAINT customer_order_detail_customerorder_fkey FOREIGN KEY (customerorder) REFERENCES customer_order(id);


--
-- Name: customer_order customer_order_gardener_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY customer_order
    ADD CONSTRAINT customer_order_gardener_fkey FOREIGN KEY (gardener) REFERENCES gardener(id);


--
-- Name: files files_personid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY files
    ADD CONSTRAINT files_personid_fkey FOREIGN KEY (personid) REFERENCES person(id);


--
-- Name: gardener_calendar gardener_calendar_customerorder_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gardener_calendar
    ADD CONSTRAINT gardener_calendar_customerorder_fkey FOREIGN KEY (customerorder) REFERENCES customer_order(id);


--
-- Name: gardener_calendar gardener_calendar_gardener_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gardener_calendar
    ADD CONSTRAINT gardener_calendar_gardener_fkey FOREIGN KEY (gardener) REFERENCES gardener(id);


--
-- Name: gardener_calendar gardener_calendar_team_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gardener_calendar
    ADD CONSTRAINT gardener_calendar_team_fkey FOREIGN KEY (team) REFERENCES gardener_team(id);


--
-- Name: gardener gardener_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gardener
    ADD CONSTRAINT gardener_id_fkey FOREIGN KEY (id) REFERENCES person(id);


--
-- Name: gardener_team gardener_team_gardener_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gardener_team
    ADD CONSTRAINT gardener_team_gardener_fkey FOREIGN KEY (gardener) REFERENCES gardener(id);


--
-- Name: customer; Type: ROW SECURITY; Schema: public; Owner: postgres
--

ALTER TABLE customer ENABLE ROW LEVEL SECURITY;

--
-- Name: customer customer_admin_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_admin_policy ON customer FOR ALL TO role_admin USING (true) WITH CHECK (true);


--
-- Name: customer customer_anonymous_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_anonymous_policy ON customer FOR ALL TO anonymous USING (true) WITH CHECK (true);


--
-- Name: customer_discount; Type: ROW SECURITY; Schema: public; Owner: postgres
--

ALTER TABLE customer_discount ENABLE ROW LEVEL SECURITY;

--
-- Name: customer_discount customer_discount_admin_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_discount_admin_policy ON customer_discount FOR ALL TO role_admin USING (true) WITH CHECK (true);


--
-- Name: customer_discount customer_discount_anonymous_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_discount_anonymous_policy ON customer_discount FOR ALL TO anonymous USING (true) WITH CHECK (true);


--
-- Name: customer_discount customer_discount_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_discount_policy ON customer_discount FOR ALL TO role_customer USING (((customer)::text = ("current_user"())::text));


--
-- Name: customer customer_gardener_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_gardener_policy ON customer FOR ALL TO role_gardener USING (true) WITH CHECK (true);


--
-- Name: customer_order; Type: ROW SECURITY; Schema: public; Owner: postgres
--

ALTER TABLE customer_order ENABLE ROW LEVEL SECURITY;

--
-- Name: customer_order customer_order_admin_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_order_admin_policy ON customer_order FOR ALL TO role_admin USING (true) WITH CHECK (true);


--
-- Name: customer_order_detail customer_order_detail_admin_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_order_detail_admin_policy ON customer_order_detail FOR ALL TO role_admin USING (true) WITH CHECK (true);


--
-- Name: customer_order_detail customer_order_detail_gardener_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_order_detail_gardener_policy ON customer_order_detail FOR ALL TO role_gardener USING ((customerorder IN ( SELECT o.id
   FROM customer_order o
  WHERE ((o.gardener)::text = ("current_user"())::text))));


--
-- Name: customer_order_detail customer_order_detail_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_order_detail_policy ON customer_order_detail FOR ALL TO role_customer USING (((customer)::text = ("current_user"())::text));


--
-- Name: customer_order customer_order_gardener_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_order_gardener_policy ON customer_order FOR ALL TO role_gardener USING (((gardener)::text = ("current_user"())::text));


--
-- Name: customer_order customer_order_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_order_policy ON customer_order FOR ALL TO role_customer USING (((customer)::text = ("current_user"())::text));


--
-- Name: customer customer_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY customer_policy ON customer FOR ALL TO role_customer USING (((id)::text = ("current_user"())::text));


--
-- Name: files; Type: ROW SECURITY; Schema: public; Owner: postgres
--

ALTER TABLE files ENABLE ROW LEVEL SECURITY;

--
-- Name: files files_admin_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY files_admin_policy ON files FOR ALL TO role_admin USING (true) WITH CHECK (true);


--
-- Name: files files_gardener_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY files_gardener_policy ON files FOR ALL TO role_gardener USING (((personid)::text = ("current_user"())::text));


--
-- Name: gardener; Type: ROW SECURITY; Schema: public; Owner: postgres
--

ALTER TABLE gardener ENABLE ROW LEVEL SECURITY;

--
-- Name: gardener gardener_admin_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_admin_policy ON gardener FOR ALL TO role_admin USING (true) WITH CHECK (true);


--
-- Name: gardener gardener_anonymous_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_anonymous_policy ON gardener FOR ALL TO anonymous USING (true) WITH CHECK (true);


--
-- Name: gardener_calendar; Type: ROW SECURITY; Schema: public; Owner: postgres
--

ALTER TABLE gardener_calendar ENABLE ROW LEVEL SECURITY;

--
-- Name: gardener_calendar gardener_calendar_admin_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_calendar_admin_policy ON gardener_calendar FOR ALL TO role_admin USING (true) WITH CHECK (true);


--
-- Name: gardener_calendar gardener_calendar_customer_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_calendar_customer_policy ON gardener_calendar FOR ALL TO role_customer USING (true) WITH CHECK (true);


--
-- Name: gardener_calendar gardener_calendar_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_calendar_policy ON gardener_calendar FOR ALL TO role_gardener USING (((gardener)::text = ("current_user"())::text));


--
-- Name: gardener gardener_customer_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_customer_policy ON gardener FOR ALL TO role_customer USING (true) WITH CHECK (true);


--
-- Name: gardener gardener_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_policy ON gardener FOR ALL TO role_gardener USING (((id)::text = ("current_user"())::text));


--
-- Name: gardener_team; Type: ROW SECURITY; Schema: public; Owner: postgres
--

ALTER TABLE gardener_team ENABLE ROW LEVEL SECURITY;

--
-- Name: gardener_team gardener_team_admin_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_team_admin_policy ON gardener_team FOR ALL TO role_admin USING (true) WITH CHECK (true);


--
-- Name: gardener_team gardener_team_customer_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_team_customer_policy ON gardener_team FOR ALL TO role_customer USING (true) WITH CHECK (true);


--
-- Name: gardener_team gardener_team_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY gardener_team_policy ON gardener_team FOR ALL TO role_gardener USING (((gardener)::text = ("current_user"())::text));


--
-- Name: person; Type: ROW SECURITY; Schema: public; Owner: postgres
--

ALTER TABLE person ENABLE ROW LEVEL SECURITY;

--
-- Name: person person_admin_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY person_admin_policy ON person FOR ALL TO role_admin USING (true) WITH CHECK (true);


--
-- Name: person person_anonymous_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY person_anonymous_policy ON person FOR ALL TO anonymous USING (true) WITH CHECK (true);


--
-- Name: person person_customer_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY person_customer_policy ON person FOR ALL TO role_customer USING (true) WITH CHECK (true);


--
-- Name: person person_gardener_policy; Type: POLICY; Schema: public; Owner: postgres
--

CREATE POLICY person_gardener_policy ON person FOR ALL TO role_gardener USING (((id)::text = ("current_user"())::text));


--
-- Name: customer; Type: ACL; Schema: public; Owner: postgres
--

GRANT INSERT ON TABLE customer TO anonymous;
GRANT SELECT,INSERT,UPDATE ON TABLE customer TO role_admin;
GRANT SELECT,UPDATE ON TABLE customer TO role_customer;
GRANT SELECT ON TABLE customer TO role_gardener;


--
-- Name: customer.validatedemail; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(validatedemail),UPDATE(validatedemail) ON TABLE customer TO anonymous;


--
-- Name: customer_code_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE customer_code_seq TO role_admin;
GRANT ALL ON SEQUENCE customer_code_seq TO anonymous;


--
-- Name: customer_discount; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT ON TABLE customer_discount TO role_customer;
GRANT SELECT ON TABLE customer_discount TO anonymous;
GRANT SELECT,INSERT,UPDATE ON TABLE customer_discount TO role_admin;


--
-- Name: customer_discount.status; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(status) ON TABLE customer_discount TO role_customer;


--
-- Name: customer_discount.usedorder; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(usedorder) ON TABLE customer_discount TO role_customer;


--
-- Name: customer_discount_code_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE customer_discount_code_seq TO role_customer;
GRANT ALL ON SEQUENCE customer_discount_code_seq TO role_admin;


--
-- Name: customer_order; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE customer_order TO role_admin;
GRANT INSERT,UPDATE ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.id; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(id) ON TABLE customer_order TO role_gardener;
GRANT SELECT(id) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.code; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(code) ON TABLE customer_order TO role_gardener;
GRANT SELECT(code) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.date; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(date) ON TABLE customer_order TO role_gardener;
GRANT SELECT(date) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.status; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(status),UPDATE(status) ON TABLE customer_order TO role_gardener;
GRANT SELECT(status) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.statuspayment; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(statuspayment) ON TABLE customer_order TO role_gardener;
GRANT SELECT(statuspayment) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.customer; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(customer) ON TABLE customer_order TO role_gardener;
GRANT SELECT(customer) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.gardenaddress; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(gardenaddress) ON TABLE customer_order TO role_gardener;
GRANT SELECT(gardenaddress) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.comment; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(comment) ON TABLE customer_order TO role_gardener;
GRANT SELECT(comment) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.gardener; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(gardener) ON TABLE customer_order TO role_gardener;
GRANT SELECT(gardener) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.canceldate; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(canceldate) ON TABLE customer_order TO role_gardener;
GRANT SELECT(canceldate) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.validate; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(validate),UPDATE(validate) ON TABLE customer_order TO role_gardener;
GRANT SELECT(validate) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.validatecomment; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(validatecomment),UPDATE(validatecomment) ON TABLE customer_order TO role_gardener;


--
-- Name: customer_order.bill; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(bill) ON TABLE customer_order TO role_gardener;
GRANT SELECT(bill) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.billnumber; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(billnumber) ON TABLE customer_order TO role_gardener;
GRANT SELECT(billnumber) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.billaddress; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(billaddress) ON TABLE customer_order TO role_gardener;
GRANT SELECT(billaddress) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.tva; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(tva) ON TABLE customer_order TO role_gardener;
GRANT SELECT(tva) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.marge; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(marge) ON TABLE customer_order TO role_gardener;
GRANT SELECT(marge) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.fee; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(fee) ON TABLE customer_order TO role_gardener;
GRANT SELECT(fee) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.totalamout; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(totalamout) ON TABLE customer_order TO role_gardener;
GRANT SELECT(totalamout) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.totaldiscount; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(totaldiscount) ON TABLE customer_order TO role_gardener;
GRANT SELECT(totaldiscount) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order.totaltime; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(totaltime) ON TABLE customer_order TO role_gardener;
GRANT SELECT(totaltime) ON TABLE customer_order TO role_customer;


--
-- Name: customer_order_billnumber_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE customer_order_billnumber_seq TO role_customer;
GRANT ALL ON SEQUENCE customer_order_billnumber_seq TO role_admin;


--
-- Name: customer_order_code_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE customer_order_code_seq TO role_customer;
GRANT ALL ON SEQUENCE customer_order_code_seq TO role_admin;


--
-- Name: customer_order_detail; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE customer_order_detail TO role_customer;
GRANT SELECT ON TABLE customer_order_detail TO role_gardener;
GRANT SELECT,INSERT,UPDATE ON TABLE customer_order_detail TO role_admin;


--
-- Name: files; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE files TO role_admin;
GRANT SELECT,INSERT ON TABLE files TO role_gardener;


--
-- Name: gardener; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE gardener TO role_gardener;
GRANT SELECT,INSERT,UPDATE ON TABLE gardener TO role_admin;
GRANT SELECT ON TABLE gardener TO role_customer;


--
-- Name: gardener.enabled; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(enabled) ON TABLE gardener TO anonymous;


--
-- Name: gardener.firstname; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(firstname) ON TABLE gardener TO role_gardener;


--
-- Name: gardener.lastname; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(lastname) ON TABLE gardener TO role_gardener;


--
-- Name: gardener.birthdate; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(birthdate) ON TABLE gardener TO role_gardener;


--
-- Name: gardener.address; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT(address) ON TABLE gardener TO anonymous;
GRANT UPDATE(address) ON TABLE gardener TO role_gardener;


--
-- Name: gardener.addressfallback; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(addressfallback) ON TABLE gardener TO role_gardener;


--
-- Name: gardener.mainphone; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(mainphone) ON TABLE gardener TO role_gardener;


--
-- Name: gardener.otherphone; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(otherphone) ON TABLE gardener TO role_gardener;


--
-- Name: gardener_calendar; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE gardener_calendar TO role_gardener;
GRANT SELECT,INSERT,UPDATE ON TABLE gardener_calendar TO role_admin;
GRANT SELECT ON TABLE gardener_calendar TO role_customer;


--
-- Name: gardener_calendar.id; Type: ACL; Schema: public; Owner: postgres
--

GRANT INSERT(id) ON TABLE gardener_calendar TO role_gardener;


--
-- Name: gardener_calendar.day; Type: ACL; Schema: public; Owner: postgres
--

GRANT INSERT(day) ON TABLE gardener_calendar TO role_gardener;


--
-- Name: gardener_calendar.gardener; Type: ACL; Schema: public; Owner: postgres
--

GRANT INSERT(gardener) ON TABLE gardener_calendar TO role_gardener;


--
-- Name: gardener_calendar.team; Type: ACL; Schema: public; Owner: postgres
--

GRANT INSERT(team) ON TABLE gardener_calendar TO role_gardener;


--
-- Name: gardener_calendar.teamnumber; Type: ACL; Schema: public; Owner: postgres
--

GRANT INSERT(teamnumber),UPDATE(teamnumber) ON TABLE gardener_calendar TO role_gardener;


--
-- Name: gardener_calendar.slot; Type: ACL; Schema: public; Owner: postgres
--

GRANT INSERT(slot) ON TABLE gardener_calendar TO role_gardener;


--
-- Name: gardener_calendar.customerorder; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(customerorder) ON TABLE gardener_calendar TO role_customer;


--
-- Name: gardener_calendar.datereserved; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(datereserved) ON TABLE gardener_calendar TO role_customer;


--
-- Name: gardener_calendar.dateconfirmed; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(dateconfirmed) ON TABLE gardener_calendar TO role_customer;


--
-- Name: gardener_team; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE gardener_team TO role_gardener;
GRANT SELECT,INSERT,UPDATE ON TABLE gardener_team TO role_admin;
GRANT SELECT ON TABLE gardener_team TO role_customer;


--
-- Name: pages; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE pages TO role_admin;


--
-- Name: person; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,UPDATE ON TABLE person TO role_gardener;
GRANT ALL ON TABLE person TO mjol;
GRANT SELECT,INSERT,UPDATE ON TABLE person TO role_admin;
GRANT SELECT,INSERT ON TABLE person TO anonymous;
GRANT SELECT,UPDATE ON TABLE person TO role_customer;


--
-- Name: person.password; Type: ACL; Schema: public; Owner: postgres
--

GRANT UPDATE(password) ON TABLE person TO anonymous;
GRANT UPDATE(password) ON TABLE person TO postgres;
GRANT UPDATE(password) ON TABLE person TO mjol;


--
-- Name: zipgeo; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE zipgeo TO anonymous;
GRANT SELECT,INSERT,UPDATE ON TABLE zipgeo TO role_admin;
GRANT SELECT ON TABLE zipgeo TO role_customer;
GRANT SELECT ON TABLE zipgeo TO role_gardener;


--
-- PostgreSQL database dump complete
--

