-- Brands / attributes / attribute values added by sellers from the product form wait for approval.
-- Same as migration 2026_10_11_000001_add_approval_to_brands_and_attributes (run one or the other).
-- Every existing row stays approved (column default). Afterwards: php artisan cache:clear

ALTER TABLE `brands`
  ADD COLUMN `approved` TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN `requested_by` INT UNSIGNED NULL,
  ADD INDEX `brands_approved_index` (`approved`);

ALTER TABLE `attributes`
  ADD COLUMN `approved` TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN `requested_by` INT UNSIGNED NULL,
  ADD INDEX `attributes_approved_index` (`approved`);

ALTER TABLE `attribute_values`
  ADD COLUMN `approved` TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN `requested_by` INT UNSIGNED NULL,
  ADD INDEX `attribute_values_approved_index` (`approved`);