-- SQL script to add product_type to products table
ALTER TABLE `products` ADD COLUMN `product_type` ENUM('product', 'service') DEFAULT 'product' AFTER `category_id`;