-- 
-- 

ALTER TABLE yachts 
ADD COLUMN company_id VARCHAR(50) DEFAULT NULL AFTER booking_manager_id;

CREATE INDEX idx_yachts_company_id ON yachts(company_id);


UPDATE yachts 
SET company_id = '7850' 
WHERE booking_manager_id LIKE '%7850%' AND company_id IS NULL;

UPDATE yachts 
SET company_id = '4366' 
WHERE booking_manager_id LIKE '%4366%' AND company_id IS NULL;

UPDATE yachts 
SET company_id = '3604' 
WHERE booking_manager_id LIKE '%3604%' AND company_id IS NULL;

UPDATE schema_version 
SET version = 6, updated_at = NOW() 
WHERE id = 1;


SHOW COLUMNS FROM yachts LIKE 'company_id';

SELECT 
    company_id, 
    COUNT(*) as yacht_count 
FROM yachts 
GROUP BY company_id;

SELECT id, name, booking_manager_id, company_id 
FROM yachts 
WHERE company_id IS NULL;