[TYPO3-dev] Moving pages in workspaces - brainstorm

[Daniel Pötzinger]

Hello

At first again thanks for the great work and the effort!

While trying to understand the implementation of versioning I thought of 
a Data-Model of the core- database-tables in TYPO3. Is there something 
like a ERD or UML Model for that? If not: Could it be useful? (Just for 
visual feeling (and overview) of the different relations beetween the 
tables.)

I am sorry if my following idea misses the point, I just had a short 
look on the versioning and a spontaneous idea:

What about a field like t3ver_newpid for versions? Maybe with default 
"-1" and the id of the new parent page after moving.
For preview it could be possible to use a join like:

... from tt_content as online, tt_content as version
where online.pid="9"
AND version.t3ver_oid=live.uid
AND (version.t3ver_newpid ="-1" OR version.t3ver_newpid ="9")