CREATE TABLE IF NOT EXISTS fleet_node_meta (
    id INT AUTO_INCREMENT PRIMARY KEY,
    node_id VARCHAR(64) NOT NULL,
    provider_enc TEXT,
    account_email_enc TEXT,
    account_username_enc TEXT,
    account_password_enc TEXT,
    payment_method_enc TEXT,
    card_last4_enc TEXT,
    card_exp_enc TEXT,
    monthly_cost_enc TEXT,
    renewal_date_enc TEXT,
    panel_url_enc TEXT,
    panel_login_enc TEXT,
    ssh_password_enc TEXT,
    root_password_enc TEXT,
    notes_enc TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    UNIQUE KEY idx_node (node_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
