-- این فایل رو هم از phpMyAdmin > Import اجرا کن (کنار migration_001 و migration_002)

ALTER TABLE gift_codes
    ADD COLUMN IF NOT EXISTS target_user_id INT NULL AFTER used_count,
    ADD CONSTRAINT fk_giftcode_target_user FOREIGN KEY (target_user_id) REFERENCES users(id) ON DELETE CASCADE;

ALTER TABLE tenant_bots
    MODIFY COLUMN status ENUM('pending_claim','active','disabled','expired') NOT NULL DEFAULT 'pending_claim',
    ADD COLUMN IF NOT EXISTS expires_at DATETIME NULL AFTER telegram_owner_id;

INSERT INTO settings (setting_key, setting_value) VALUES ('license_duration_days', '30')
ON DUPLICATE KEY UPDATE setting_key = setting_key;