-- Iteration 1 Database Schema
-- Objective: Schema changes include adding a new table for max_stock_per_shop and updating existing tables to align with OR expert's requirements. Configuration logic updated for scalar parameters.

CREATE TABLE phone_market (
  Market_ID INTEGER,
  Phone_ID INTEGER,
  Num_of_stock INTEGER,
  available_stock INTEGER
);

CREATE TABLE market_stock_constraints (
  Market_ID INTEGER,
  max_stock_per_shop INTEGER
);

