-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for missing optimization data and updating configuration logic for scalar parameters and formulas.

CREATE TABLE routes (
  route_id INTEGER,
  passenger_capacity INTEGER
);

CREATE TABLE flights (
  route_id INTEGER,
  number_of_flights INTEGER
);

