I hope someone can help. We are using a test environment and would like to use the same database for multiple sandbox type installs. For instance we have test.domain.com, test1.domain.com, test2.domain.com, etc. We do not want to duplicate the database accross multiple instances.
I am wondering if this is possible. In the wp_blogs table it lists the siteurls that are allowed, but the blog_id is a primary key and therefore must be unique. Is it possible to remove this constraint safely? Or is there a better way?
I think - and please correct me if I'm going about this the wrong way - I'd essentially like my wp_blogs table to be something like:
blog_id | site_id | domain
1 | 1 | test.domain.com
5 | 1 | test.domain.com
9 | 1 | test.domain.com
1 | 2 | test2.domain.com
5 | 2 | test2.domain.com
9 | 2 | test2.domain.com
1 | 3 | test3.domain.com
5 | 3 | test3.domain.com
9 | 3 | test3.domain.com
Thanks in advance for any help!
~Michelle
WPMU 2.9.2