SQL patterns for database changes and rollbacks.
Recent revisions are kept. Restoring one creates a new revision.