START TRANSACTION;

-- Short table names: installer adds PJ_SCRIPT_PREFIX automatically.

ALTER TABLE `products`
ADD COLUMN `model_image_id` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `is_digital`,
ADD COLUMN `material` TEXT NULL DEFAULT NULL AFTER `model_image_id`,
ADD COLUMN `safety_standard` TEXT NULL DEFAULT NULL AFTER `material`;

ALTER TABLE `stocks`
ADD COLUMN `buying_price` DECIMAL(10,2) NULL DEFAULT NULL AFTER `price`;

COMMIT;
