Man, these tables drive me crazy. Is there a good reason I'm missing that we don't it like this?
+------------------+ +---------------+ | page | | page_version | +------------------+ +---------------+ | page_id | ----> | version_id | | current_version | ----/ | page_id | +------------------+ | timestamp | | user | | ... | | data | +---------------+
That way, all your page versions are in one place -- a lot easier to manage than two tables.
Just some woolgathering as I fight my way through some RFEs...
~ESP