The Goal:

To implement a global system of content revisioning.

Overview:

By making content tables use 2 primary indexes (id, rev#) we should be able to easily implement a revisioning system.

Steps to Implement:

• Update all table defs to use 2 primary indexes.
• Update SQL queries in expController to honor the revisions properly and just lookup the newest.
• Create action for managing revisions for a module
• Create action for rolling back to specific revision.
• Create action deleting a revision.
• Create action to edit and use an older revision.
• Update addContentToSeach functions to keep old revisions out of search results
• Audit all existing exp2 modules to make sure they are implementing revisioning correctly.

Things to Consider:

• We need to figure out how this will work with multi-lang sites.
• We need to figure out how this will work with workflow.
• We need to assess if there will be any performance issues using multiple indexes.

Areas of Exponent Affected By the Change:

expController and ALL existing modules will need to be touched to implement this feature.