 --
 
 COPY commodity (id, startlatitude, startlongitude, endlatitude, endlongitude, status, metadata, cluster_id) FROM stdin;
-1	39.4815139999999971	-87.3141770000000008	39.4754629999999977	-87.3487089999999995	2	{}	1
-2	39.4423790000000025	-87.3390610000000009	39.4816379999999967	-87.3211009999999987	3	{}	1
-3	39.4993100000000013	-87.3791140000000013	39.5159969999999987	-87.3586860000000058	3	{}	1
-6	39.404952999999999	-87.3176050000000004	39.4704460000000026	-87.4144220000000018	3	{}	1
-7	39.4587840000000014	-87.4068690000000004	39.4484449999999995	-87.3344280000000026	3	{}	1
-9	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	3	{}	1
-10	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	3	{}	1
-11	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	3	{}	1
-12	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	3	{}	1
-13	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	3	{}	1
-14	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	3	{}	1
-15	39.4835410779709832	-87.3245842662521881	39.4399999999999977	-87.3400000000000034	3	{}	1
-16	39.4399999999999977	-87.3400000000000034	39.4835410779709832	-87.3245842662521881	3	{}	1
-17	39.4432649000000026	-87.3386129999999952	39.4399999999999977	-87.3400000000000034	2	{}	1
-18	39.4399999999999977	-87.3400000000000034	39.4432649000000026	-87.3386129999999952	2	{}	1
-19	39.4432649000000026	-87.3386129999999952	39.4399999999999977	-87.3400000000000034	2	{}	1
-20	39.4399999999999977	-87.3400000000000034	39.4432649000000026	-87.3386129999999952	2	{}	1
-21	39.4432649000000026	-87.3386129999999952	39.4399999999999977	-87.3400000000000034	2	{}	1
-22	39.4399999999999977	-87.3400000000000034	39.4432649000000026	-87.3386129999999952	2	{}	1
-23	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
-24	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
-25	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
-26	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
-27	39.4432649000000026	-87.3386129999999952	39.4399999999999977	-87.3400000000000034	2	{}	1
-28	39.4399999999999977	-87.3400000000000034	39.4432649000000026	-87.3386129999999952	2	{}	1
-29	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
-30	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
-31	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
-32	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
-33	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
-34	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
-35	42.1864145016690628	-88.1087807101086753	39.4399999999999977	-87.3400000000000034	2	{}	1
-36	39.4399999999999977	-87.3400000000000034	42.1864145016690628	-88.1087807101086753	2	{}	1
-4	39.4920240000000007	-87.4484649999999988	39.4334460000000036	-87.4134459999999933	4	{}	1
-5	39.4914970000000025	-87.3145319999999998	39.4919610000000034	-87.3631129999999985	4	{}	1
+1	39.4819999999999993	-87.3282999999999987	39.4420000000000002	-87.3399000000000001	0	{}	1
+2	39.4617000000000004	-87.3033999999999963	39.4836000000000027	-87.3262	0	{}	1
 \.
 
 

--

COPY pathfinder_application (id, name, token, cluster_id) FROM stdin;
9c4166bb-9535-49e1-8844-1904a0b1f45b	Chimney Swap	\\xefbfbdefbfbdefbfbdefbfbd0a2aefbfbdefbfbd55efbfbd6750efbfbd45efbfbd5befbfbd7333efbfbd27efbfbd34efbfbd14efbfbd51efbfbd524eefbfbd70efbfbd7defbfbd317a173334341912efbfbdefbfbd6defbfbd073befbfbd00efbfbdefbfbdefbfbdefbfbd6c5e6c1defbfbd30efbfbdefbfbd2fefbfbdefbfbd3defbfbd77efbfbd271909efbfbdefbfbd5aefbfbd3307efbfbd3befbfbdefbfbdefbfbd7f527512efbfbd1843efbfbd7fefbfbdefbfbdefbfbdefbfbdefbfbdefbfbd4fefbfbdefbfbdefbfbd7365efbfbdefbfbd49efbfbd7f1c171eefbfbd3e4fefbfbdefbfbdefbfbdefbfbd724e526232422defbfbdefbfbd3257efbfbdefbfbdefbfbd5b59efbfbd643b6befbfbd1eefbfbdefbfbd21efbfbdefbfbdefbfbd237cefbfbdefbfbdefbfbdefbfbdefbfbdefbfbd5befbfbd5d6eefbfbd08efbfbdefbfbdefbfbd3c72efbfbdefbfbdefbfbdefbfbd77efbfbdefbfbd76efbfbd73efbfbd2cefbfbdefbfbdefbfbdefbfbdefbfbdefbfbd7465efbfbd70efbfbdefbfbdefbfbd23efbfbd4a7aefbfbdefbfbdefbfbd26efbfbd752f2aefbfbdefbfbdefbfbd15efbfbd7defbfbd35efbfbdefbfbd0aefbfbdefbfbdefbfbd7506efbfbd5aefbfbd1eefbfbdefbfbd5f187515efbfbd2849efbfbd5800efbfbdefbfbdefbfbd7c102966efbfbd5befbfbdefbfbdefbfbd4cefbfbdefbfbdefbfbdefbfbd134e	1
\.



--

COPY play_evolutions (id, hash, applied_at, apply_script, revert_script, state, last_problem) FROM stdin;
1	f332ff093c2b2b9a09d3b618c76764badc063d17	2015-12-12 00:00:00	SET search_path = public, pg_catalog;\n\nSET default_tablespace = '';\n\nSET default_with_oids = false;\n\nCREATE TABLE cluster (\nid bigint NOT NULL,\nparent_id bigint,\nauthentication_token bytea\n);\n\n\nALTER TABLE cluster OWNER TO pathfinderwebserver;\n\n\nCREATE SEQUENCE cluster_id_seq\nSTART WITH 1\nINCREMENT BY 1\nNO MINVALUE\nNO MAXVALUE\nCACHE 1;\n\n\nALTER TABLE cluster_id_seq OWNER TO pathfinderwebserver;\n\n\nALTER SEQUENCE cluster_id_seq OWNED BY cluster.id;\n\n\nCREATE TABLE commodity (\nid bigint NOT NULL,\nstartlatitude double precision NOT NULL,\nstartlongitude double precision NOT NULL,\nendlatitude double precision NOT NULL,\nendlongitude double precision NOT NULL,\nstatus integer NOT NULL,\nmetadata json,\ncluster_id bigint,\nCONSTRAINT ck_commodity_status CHECK ((status = ANY (ARRAY[3, 0, 1, 4, 2])))\n);\n\n\nALTER TABLE commodity OWNER TO pathfinderwebserver;\n\nCREATE SEQUENCE commodity_id_seq\nSTART WITH 1\nINCREMENT BY 1\nNO MINVALUE\nNO MAXVALUE\nCACHE 1;\n\n\nALTER TABLE commodity_id_seq OWNER TO pathfinderwebserver;\n\nALTER SEQUENCE commodity_id_seq OWNED BY commodity.id;\n\n\nCREATE TABLE pathfinder_application (\nid uuid NOT NULL,\nname character varying(255),\ntoken bytea,\ncluster_id bigint\n);\n\n\nALTER TABLE pathfinder_application OWNER TO pathfinderwebserver;\n\nCREATE TABLE pathfinder_user (\nusername character varying(255) NOT NULL,\npassword character varrying(255) NOT NULL,\nuser_token bytea NOT NULL\n);\n\n\nALTER TABLE pathfinder_user OWNER TO pathfinderwebserver;\n\nCREATE SEQUENCE pathfinder_user_id_seq\nSTART WITH 1\nINCREMENT BY 1\nNO MINVALUE\nNO MAXVALUE\nCACHE 1;\n\nALTER TABLE commodity_id_seq OWNER TO pathfinderwebserver;\n\nALTER SEQUENCE commodity_id_seq OWNED BY pathfinder_user.id;\n\n\nCREATE TABLE vehicle (\nid bigint NOT NULL,\nlatitude double precision NOT NULL,\nlongitude double precision NOT NULL,\ncluster_id bigint,\nstatus integer NOT NULL,\nmetadata json,\nCONSTRAINT ck_vehicle_status CHECK ((status = ANY (ARRAY[0, 1])))\n);\n\n\nALTER TABLE vehicle OWNER TO pathfinderwebserver;\n\nCREATE SEQUENCE vehicle_id_seq\nSTART WITH 1\nINCREMENT BY 1\nNO MINVALUE\nNO MAXVALUE\nCACHE 1;\n\n\nALTER TABLE vehicle_id_seq OWNER TO pathfinderwebserver;\n\nALTER SEQUENCE vehicle_id_seq OWNED BY vehicle.id;\n\n\nALTER TABLE ONLY cluster ALTER COLUMN id SET DEFAULT nextval('cluster_id_seq'::regclass);\n\n\nALTER TABLE ONLY commodity ALTER COLUMN id SET DEFAULT nextval('commodity_id_seq'::regclass);\n\n\nALTER TABLE ONLY pathfinder_user ALTER COLUMN id set DEFAULT nextval('pathfinder_user_id_seq'::regclass);\n\n\nALTER TABLE ONLY vehicle ALTER COLUMN id SET DEFAULT nextval('vehicle_id_seq'::regclass);\n\n\nSELECT pg_catalog.setval('cluster_id_seq', 1, false);\n\nSELECT pg_catalog.setval('commodity_id_seq', 1, false);\n\nSELECT pg_catalog.setval('pathfinder_user_id_seq', 1, false);\n\nSELECT pg_catalog.setval('vehicle_id_seq', 1, false);\n\n\nALTER TABLE ONLY cluster\nADD CONSTRAINT pk_cluster PRIMARY KEY (id);\n\n\nALTER TABLE ONLY commodity\nADD CONSTRAINT pk_commodity PRIMARY KEY (id);\n\n\nALTER TABLE ONLY pathfinder_application\nADD CONSTRAINT pk_pathfinder_application PRIMARY KEY (id);\n\nALTER TABLE ONLY pathfinder_user\nADD CONSTRAINT pk_pathfinder_user PRIMARY KEY (id);\n\nALTER TABLE ONLY vehicle\nADD CONSTRAINT pk_vehicle PRIMARY KEY (id);\n\n\nCREATE INDEX ix_cluster_parent_id ON cluster USING btree (parent_id);\n\n\nCREATE INDEX ix_commodity_cluster_id ON commodity USING btree (cluster_id);\n\n\nCREATE INDEX ix_pathfinder_application_cluster_id ON pathfinder_application USING btree (cluster_id);\n\n\nCREATE INDEX ix_vehicle_cluster_id ON vehicle USING btree (cluster_id);\n\n\n\nALTER TABLE ONLY cluster\nADD CONSTRAINT fk_cluster_parent_id FOREIGN KEY (parent_id) REFERENCES cluster(id) ON UPDATE RESTRICT ON DELETE RESTRICT;\n\n\nALTER TABLE ONLY commodity\nADD CONSTRAINT fk_commodity_cluster_id FOREIGN KEY (cluster_id) REFERENCES cluster(id) ON UPDATE RESTRICT ON DELETE RESTRICT;\n\n\nALTER TABLE ONLY pathfinder_application\nADD CONSTRAINT fk_pathfinder_application_cluster_id FOREIGN KEY (cluster_id) REFERENCES cluster(id) ON UPDATE RESTRICT ON DELETE RESTRICT;\n\n\nALTER TABLE ONLY vehicle\nADD CONSTRAINT fk_vehicle_cluster_id FOREIGN KEY (cluster_id) REFERENCES cluster(id) ON UPDATE RESTRICT ON DELETE RESTRICT;	alter table cluster drop constraint if exists fk_cluster_parent_id;\ndrop index if exists ix_cluster_parent_id;\n\nalter table commodity drop constraint if exists fk_commodity_cluster_id;\ndrop index if exists ix_commodity_cluster_id;\n\nalter table pathfinder_application drop constraint if exists fk_pathfinder_application_cluster_id;\ndrop index if exists ix_pathfinder_application_cluster_id;\n\nalter table vehicle drop constraint if exists fk_vehicle_cluster_id;\ndrop index if exists ix_vehicle_cluster_id;\n\ndrop table if exists cluster;\n\ndrop table if exists commodity;\n\ndrop table if exists pathfinder_application;\n\ndrop table if exists pathfinder_user;\n\ndrop table if exists vehicle;	applied	ERROR: relation "cluster" already exists [ERROR:0, SQLSTATE:42P07]
\.


