[development] multisite shared table upgrade enhancements (was what would be more useful)

[Daniel Convissor]

On Fri, Feb 24, 2006 at 02:18:46PM -0500, Moshe Weitzman wrote:
> 
> the only solution that is even somewhat workable in my small brain is to 
> warn the user and then upgrade all the sites at once

Here are my thoughts at this moment:

* Gather the $db_prefix settings from sites/*/settings.php (as previously 
mentioned).

* Add a function to update.php called something like update_db_query() 
that replaces db_query() for the update process.  This function does the 
table name prefixing then stores an MD5 hash of the prefixed SQL.  Save 
that hash in an array via variable_set().  Before executing a query, check 
if the hash exists yet or not.  If it exists, move on, otherwise, run the 
query.

Sound reasonable?  Other ideas?

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409