 
 CREATE TABLE gtfs_stops (
   feed_index int NOT NULL,
-  stop_id text,
+  stop_id integer,
   stop_name text NOT NULL,
   stop_desc text,
   stop_lat double precision,

  route_id text,
  direction_id int REFERENCES gtfs_directions(direction_id),
  shape_id text,
  stop_id text,
  stop_sequence int NOT NULL,
  pct_along_shape numeric,
  dist_along_shape numeric

  trip_id text,
  arrival_time text CHECK (arrival_time LIKE '__:__:__'),
  departure_time text CHECK (departure_time LIKE '__:__:__'),
  stop_id integer,
  stop_sequence int NOT NULL,
  stop_headsign text,
  pickup_type int REFERENCES gtfs_pickup_dropoff_types(type_id),
