-- ============================================================
-- SQL Manual untuk Migration Adjustments
-- Jalankan query ini langsung di MySQL jika tidak mau
-- pakai `php artisan migrate`
--
-- Semua query sudah safe (cek kolom dulu sebelum ALTER),
-- jadi aman dijalankan berkali-kali.
-- ============================================================


-- ─────────────────────────────────────────────────────────────
-- 1. products: hapus progress_status, tambah id_status
--    File: 2025_04_09_054625_change_progress_status_to_id_status
-- ─────────────────────────────────────────────────────────────
ALTER TABLE products
    DROP COLUMN IF EXISTS progress_status;

ALTER TABLE products
    ADD COLUMN IF NOT EXISTS id_status BIGINT UNSIGNED NULL AFTER repair_info;


-- ─────────────────────────────────────────────────────────────
-- 2. products: tambah order_id
--    File: 2025_04_23_042450_add_order_id_to_products_table
-- ─────────────────────────────────────────────────────────────
ALTER TABLE products
    ADD COLUMN IF NOT EXISTS order_id VARCHAR(255) NULL AFTER id;


-- ─────────────────────────────────────────────────────────────
-- 3. transactions: tambah image
--    File: 2025_04_30_135228_add_image_to_transactions_table
-- ─────────────────────────────────────────────────────────────
ALTER TABLE transactions
    ADD COLUMN IF NOT EXISTS image VARCHAR(255) NULL AFTER id_product;


-- ─────────────────────────────────────────────────────────────
-- 4. products: tambah issue
--    File: 2025_05_05_033345_add_issue_to_products_table
-- ─────────────────────────────────────────────────────────────
ALTER TABLE products
    ADD COLUMN IF NOT EXISTS issue TINYINT(1) NOT NULL DEFAULT 0 AFTER pickup_date;


-- ─────────────────────────────────────────────────────────────
-- 5. roles: tambah status
--    File: 2025_05_15_053953_add_status_to_roles_table
-- ─────────────────────────────────────────────────────────────
ALTER TABLE roles
    ADD COLUMN IF NOT EXISTS status TINYINT(1) NOT NULL DEFAULT 1 AFTER guard_name;


-- ─────────────────────────────────────────────────────────────
-- 6. detail_order_parts: hapus name_part, tambah id_category_part
--    File: 2025_10_06_081621_update_detail_order_parts_replace_name_with_id_category_part
-- ─────────────────────────────────────────────────────────────
ALTER TABLE detail_order_parts
    DROP COLUMN IF EXISTS name_part;

ALTER TABLE detail_order_parts
    ADD COLUMN IF NOT EXISTS id_category_part BIGINT UNSIGNED NOT NULL AFTER id_order_part;

-- Foreign key (skip jika sudah ada)
ALTER TABLE detail_order_parts
    ADD CONSTRAINT fk_detail_order_parts_category_part
    FOREIGN KEY (id_category_part) REFERENCES category_parts(id)
    ON DELETE CASCADE;