 
 drop table if exists commodity;
 
-drop table if exists pathfinder_application;
-
-drop table if exists pathfinder_user;
-
 drop table if exists vehicle;
 
+drop table if exists application cascade;
+
+drop table if exists capacity_parameter cascade;
+
+drop table if exists customer cascade;
+
+drop table if exists objective_function cascade;
+
+drop table if exists objective_parameter cascade;

ALTER TABLE ONLY commodity ALTER COLUMN id SET DEFAULT nextval('commodity_id_seq'::regclass);


ALTER TABLE ONLY pathfinder_user ALTER COLUMN id set DEFAULT nextval('pathfinder_user_id_seq'::regclass);


ALTER TABLE ONLY vehicle ALTER COLUMN id SET DEFAULT nextval('vehicle_id_seq'::regclass);


SELECT pg_catalog.setval('cluster_id_seq', 1, false);

SELECT pg_catalog.setval('commodity_id_seq', 1, false);

SELECT pg_catalog.setval('pathfinder_user_id_seq', 1, false);

SELECT pg_catalog.setval('vehicle_id_seq', 1, false);



# --- !Ups


