Can i ask you a small question about the database logical structure of a WordPress enabled with Multisite?
According to the official documentation (Multisite_Table_Details) for each blog registered in a WordPress Multisite Network, in the database are generated only:
...OK but, where are the users?
Obviously in the main
wp_users! You will say.
But if all multisite's users are registered in wp_users, there must be a reference table that link users to their own blog, so to their blog_id, and I supposed that the only place where there could be something like this, could be...
I sincerely wish it were not so.
Especially considering that in the official documentation there's nothing written about a logical foreign key in the field of 'wp_registration_log' table that links to the
I remind you the structure of this table:
ID bigint(20) unsigned PRI NULL auto_increment email varchar(255) NO IP varchar(30) NO blog_id bigint(20) unsigned PRI 0 FK->wp_blogs.blog_id date_registered
(Note email, and blog_id).
I'm right? The
wp_registration_log is the logical foreign key that (linking to the field
user_email in the table
wp_users) links the user to his blog?
If so, it would not seem to be a very smart solution.
Am I wrong?