SET NAMES utf8mb4;

ALTER TABLE md_suppliers
    ADD COLUMN IF NOT EXISTS account_code VARCHAR(50) NULL AFTER tax_id,
    ADD COLUMN IF NOT EXISTS supplier_group VARCHAR(100) NULL AFTER trade_registry,
    ADD COLUMN IF NOT EXISTS branch_code VARCHAR(100) NULL AFTER supplier_group,
    ADD COLUMN IF NOT EXISTS third_party_type VARCHAR(100) NULL AFTER branch_code,
    ADD COLUMN IF NOT EXISTS postal_code VARCHAR(20) NULL AFTER country,
    ADD COLUMN IF NOT EXISTS saft_code VARCHAR(50) NULL AFTER postal_code,
    ADD COLUMN IF NOT EXISTS is_vat_payer TINYINT(1) NOT NULL DEFAULT 1 AFTER saft_code,
    ADD COLUMN IF NOT EXISTS is_blocked TINYINT(1) NOT NULL DEFAULT 0 AFTER is_vat_payer,
    ADD COLUMN IF NOT EXISTS import_type VARCHAR(100) NULL AFTER is_blocked,
    ADD COLUMN IF NOT EXISTS vat_registration_date DATE NULL AFTER import_type,
    ADD COLUMN IF NOT EXISTS vat_end_date DATE NULL AFTER vat_registration_date,
    ADD COLUMN IF NOT EXISTS vat_validation_date DATE NULL AFTER vat_end_date,
    ADD COLUMN IF NOT EXISTS vat_suspension_date DATE NULL AFTER vat_validation_date,
    ADD COLUMN IF NOT EXISTS additional_info TEXT NULL AFTER vat_suspension_date;

CREATE INDEX IF NOT EXISTS idx_md_suppliers_account_code
    ON md_suppliers(account_code);

CREATE INDEX IF NOT EXISTS idx_md_suppliers_saft_code
    ON md_suppliers(saft_code);