import.sql

-- enable CSV import mode
.mode csv

-- define the CSV separator
.separator ','

-- import & create tables, this will not insert the header line of a CSV file as a row
.import input/shapes.txt shapes
.import input/stops.txt stops
.import input/stop_times.txt stop_times
.import input/trips.txt trips
.import input/routes.txt routes
.import input/calendar.txt calendar

-- create a db file via:
-- $ sqlite3 gtfs.db < import.sql