-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for decision variables, modifying existing tables to ensure all necessary data for constraints are available, and updating configuration logic for scalar parameters and formulas.

CREATE TABLE broadcast_share (
  channel_id INTEGER,
  program_id INTEGER,
  Share_in_percent FLOAT
);

CREATE TABLE decision_variables (
  channel_id INTEGER,
  program_id INTEGER,
  x BOOLEAN
);

