-- Müşteri vs cari ayrımı (mevcut mobilyaci DB)
SET NAMES utf8mb4;

ALTER TABLE customers
    ADD COLUMN party_kind ENUM('musteri', 'cari') NOT NULL DEFAULT 'musteri'
        COMMENT 'musteri=tek seferlik; cari=tedarikçi/bayi'
        AFTER type,
    ADD KEY idx_customers_party_branch (party_kind, branch_id);