-- A note for products whose stock is not counted (In stock, Made to order, Out of stock), a per-product shipping note,
-- and the products to suggest under a product ("Goes well with").
ALTER TABLE products
  ADD COLUMN availability VARCHAR(20) NULL AFTER low_stock_threshold,
  ADD COLUMN ship_note VARCHAR(120) NULL AFTER availability;
CREATE TABLE product_related (
  product_id  INT UNSIGNED NOT NULL,
  related_id  INT UNSIGNED NOT NULL,
  sort_order  INT NOT NULL DEFAULT 0,
  PRIMARY KEY (product_id, related_id),
  FOREIGN KEY (product_id) REFERENCES products(id) ON DELETE CASCADE,
  FOREIGN KEY (related_id) REFERENCES products(id) ON DELETE CASCADE
) ENGINE=InnoDB;
