To easily import GTFS files into a compatible database:

* Set up a MySQL database called "mbta_gtfs".
* Set up a MySQL username and password to access this database with.
* Run the SQL in create-tables.sql.
* Convert the raw files' newlines with dos2unix if necessary.
* Go to the directory that has (only) MBTA GTFS files and load the
  data with the following command:
  mysqlimport --delete --ignore-lines=1 --fields-optionally-enclosed-by=\" --fie
lds-terminated-by=, --local -u YOUR_MYSQL_USERNAME -p mbta_gtfs *

Optimize the database with (takes about 5 minutes each):
* ALTER TABLE stop_times ADD INDEX (stop_id(20));
* ALTER TABLE stop_times ADD INDEX (departure_time);
* ALTER TABLE stop_times ADD INDEX (arrival_time);
* ALTER TABLE stop_times ADD INDEX (trip_id(20));
* ALTER TABLE results ADD INDEX (stop_id(20));
* ALTER TABLE stops ADD INDEX (stop_lat);
* ALTER TABLE stops ADD INDEX (stop_lon);

To run reports after you have the database loaded:
* You may need to install additional Perl modules from CPAN, including
  DBIx::Class, DBIx::Class::Schema::Loader, SVG, and Geo::Distance.
* Put the MySQL username and password, plus path info into beland_passwords.pm.
