Multi-Tenant Federation Mimarisi

-- tenants tablosuna yeni alanlar
ALTER TABLE tenants ADD COLUMN deployment_type ENUM(
    'shared',           -- Tip 1: Mevcut sistem
    'origin_edge',      -- Tip 2: Muzibu modeli
    'self_hosted',      -- Tip 3: Gazete modeli
    'compliance'        -- Tip 4: Hastane modeli
) DEFAULT 'shared';

ALTER TABLE tenants ADD COLUMN license_key VARCHAR(64) NULL;
ALTER TABLE tenants ADD COLUMN edge_config JSON NULL;
ALTER TABLE tenants ADD COLUMN last_heartbeat TIMESTAMP NULL;
ALTER TABLE tenants ADD COLUMN installed_version VARCHAR(20) NULL;

-- Yeni tablo: Satellite sunucu kayitlari
CREATE TABLE tenant_satellites (
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
    tenant_id BIGINT NOT NULL,
    server_type ENUM('origin', 'edge', 'standalone'),
    hostname VARCHAR(255),
    ip_address VARCHAR(45),
    region VARCHAR(50),
    is_active BOOLEAN DEFAULT TRUE,
    last_seen TIMESTAMP,
    metrics JSON,
    FOREIGN KEY (tenant_id) REFERENCES tenants(id)
);