<commit_before>BEGIN;

ALTER TABLE gtfs_agency
  DROP CONSTRAINT gtfs_agency_pkey CASCADE;

ALTER TABLE gtfs_calendar
  DROP CONSTRAINT gtfs_calendar_pkey CASCADE;
DROP INDEX gtfs_calendar_service_id;

ALTER TABLE gtfs_stops
  DROP CONSTRAINT gtfs_stops_pkey CASCADE;

ALTER TABLE gtfs_routes
  DROP CONSTRAINT gtfs_routes_pkey CASCADE;

DROP INDEX gtfs_calendar_dates_dateidx;

ALTER TABLE gtfs_fare_attributes
  DROP CONSTRAINT gtfs_fare_attributes_pkey;

DROP INDEX gtfs_shapes_shape_key;

ALTER TABLE gtfs_trips
  DROP CONSTRAINT gtfs_trips_pkey;
DROP INDEX gtfs_trips_service_id;

ALTER TABLE gtfs_stop_times
  DROP CONSTRAINT gtfs_stop_times_pkey;
DROP INDEX gtfs_stop_times_key;

DROP INDEX arr_time_index;
DROP INDEX dep_time_index;

ALTER TABLE gtfs_shape_geoms
  DROP CONSTRAINT gtfs_shape_geom_pkey;

ALTER TABLE gtfs_frequencies
  DROP CONSTRAINT gtfs_frequencies_pkey;

COMMIT;<commit_msg>add cascades to drop indices<commit_after>BEGIN;

ALTER TABLE gtfs_agency
  DROP CONSTRAINT gtfs_agency_pkey CASCADE;

ALTER TABLE gtfs_calendar
  DROP CONSTRAINT gtfs_calendar_pkey CASCADE;
DROP INDEX gtfs_calendar_service_id;

ALTER TABLE gtfs_stops
  DROP CONSTRAINT gtfs_stops_pkey CASCADE;

ALTER TABLE gtfs_routes
  DROP CONSTRAINT gtfs_routes_pkey CASCADE;

DROP INDEX gtfs_calendar_dates_dateidx;

ALTER TABLE gtfs_fare_attributes
  DROP CONSTRAINT gtfs_fare_attributes_pkey CASCADE;

DROP INDEX gtfs_shapes_shape_key;

ALTER TABLE gtfs_trips
  DROP CONSTRAINT gtfs_trips_pkey CASCADE;
DROP INDEX gtfs_trips_service_id;

ALTER TABLE gtfs_stop_times
  DROP CONSTRAINT gtfs_stop_times_pkey CASCADE;
DROP INDEX gtfs_stop_times_key;

DROP INDEX arr_time_index;
DROP INDEX dep_time_index;

ALTER TABLE gtfs_shape_geoms
  DROP CONSTRAINT gtfs_shape_geom_pkey CASCADE;

ALTER TABLE gtfs_frequencies
  DROP CONSTRAINT gtfs_frequencies_pkey CASCADE;

COMMIT;
{'fraction_non_alphanumeric': 0.022592791823561054, 'fraction_numerical': 0.0, 'mean_word_length': 7.017241379310345, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3265916', 'n_tokens_mistral': 831, 'n_tokens_neox': 795, 'n_words': 170}