-- -- 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.625649988651275635,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 --