blog_id is set to 0 in wp_x_options?

[wpmuguru]

MU Trac Ticket: ​http://trac.mu.wordpress.org/ticket/1182

Hello there,

I'm trying to extract the blogname and blog URL from the database for several blogs at the same time, but I'm having a problem setting up the join, because the blog_id field in the options tables for each individual blog is set to 0.

For example:

mysql> select * from wp_2_options where option_name="blogname";

+-----------+---------+-------------+-----------------+----------+

| option_id | blog_id | option_name | option_value | autoload |

+-----------+---------+-------------+-----------------+----------+

| 3 | 0 | blogname | Human Resources | yes |

+-----------+---------+-------------+-----------------+----------+

Shouldn't the blog_id be "2"?

As mentioned in the other ticket, the blog_id field in wpdb->options isn't used and has nothing to do with MU/MS.