-- 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 BudgetAllocation (
  branch_id INTEGER,
  amount FLOAT
);

CREATE TABLE Purchase (
  branch_id INTEGER,
  Total_pounds FLOAT
);

