Actually remove Optimistic locking monkeypatch
After #28560 (closed) and #207306 (closed) are done, we can finally remove our monkeypatching for optimistic locking.
We need to:
- Set a NOT NULL constraint on the
lock_version
columns - Remove the partial indexes we're adding in the other two issues
- Actually removesthe monkeypatch for LOCK_VERSION