-- Each choice (Small, Red...) can add to the price and carry its own stock and SKU. A product counts stock per choice ("choice", the default for new
-- options) or per combination ("combo", the way earlier products already work). A product can also take its material off a filament spool when it sells.
ALTER TABLE product_option_values
  ADD COLUMN price_add DECIMAL(10,2) NOT NULL DEFAULT 0 AFTER sort_order,
  ADD COLUMN stock INT NOT NULL DEFAULT 0 AFTER price_add,
  ADD COLUMN sku VARCHAR(100) NULL AFTER stock;

ALTER TABLE products
  ADD COLUMN stock_mode ENUM('choice','combo') NOT NULL DEFAULT 'combo' AFTER track_inventory,
  ADD COLUMN spool_id INT UNSIGNED NULL AFTER material_type_id,
  ADD CONSTRAINT fk_products_spool FOREIGN KEY (spool_id) REFERENCES spools(id) ON DELETE SET NULL;
