lib/gtfs/realtime/database.rb in gtfs-realtime-0.2.1 vs lib/gtfs/realtime/database.rb in gtfs-realtime-0.2.2
- old
+ new
@@ -11,10 +11,20 @@
# It also extends Sequel::Model so that Sequel may be used independently by
# the parent project if desired.
db = Sequel.connect(new_path || "sqlite://")
# Set up all database tables
+ db.create_table? :gtfs_realtime_calendar_dates do
+ Integer :id, primary_key: true
+ String :service_id
+ Date :date
+ Integer :exception_type
+
+ index :id
+ index :service_id
+ end
+
db.create_table? :gtfs_realtime_routes do
String :id, primary_key: true
String :short_name
String :long_name
String :url
@@ -55,9 +65,10 @@
String :id, primary_key: true
String :headsign
String :route_id
String :service_id
String :shape_id
+ Integer :direction_id
index :id
index :route_id
end
\ No newline at end of file