drop table if exists cities cascade;
drop table if exists airports cascade;
drop table if exists companies cascade;
drop table if exists flight_costs cascade;
drop table if exists passenger_types cascade;
drop table if exists users cascade;
drop table if exists aircraft_types cascade;
drop table if exists searchings cascade;
drop table if exists passengers cascade;
drop table if exists bought_tickets cascade;
drop table if exists classes cascade;
drop table if exists seat_count_in_class cascade;
drop table if exists seats cascade;
drop table if exists flights cascade;
DROP INDEX index_flights_index_departure;
DROP INDEX index_flights_index_arrival;
DROP INDEX index_flights_index_departure_time;
DROP INDEX index_flights_index_arrival_time;
DROP INDEX index_airports_cities_id;
DROP INDEX index_bought_tickets_flight_id;
DROP INDEX index_bought_tickets_seats_id;
DROP INDEX index_seats_aircrafts_id;