SET NAMES utf8mb4;

ALTER TABLE products
    ADD COLUMN shipping_enabled TINYINT NOT NULL DEFAULT 0 AFTER base_spec_json,
    ADD COLUMN unit_weight_grams INT UNSIGNED NULL AFTER shipping_enabled;

ALTER TABLE shipping_methods
    ADD COLUMN margin_percent DECIMAL(8,4) NOT NULL DEFAULT 0.0000 AFTER variable_percent;

ALTER TABLE shipping_method_rates
    ADD COLUMN min_weight_grams INT UNSIGNED NULL AFTER max_order_amount_ht,
    ADD COLUMN max_weight_grams INT UNSIGNED NULL AFTER min_weight_grams;
