sql: set survive zone on regional by row system tables

[fqazi]

Now that the region liveness work has been work we can finally enable it on multi-region clusters. To help aid in this this patch will do the following:

1. All system tables will now be assigned a locality out of the gate, previously we were missing logic to set these settings on newly added system tables.
2. Adding a region on the system database will configure the system database as SURVIVE REGION. Also the table: system.lease, system.sqlliveness, system.sqlinstances will be configured as survive zone.
3. An upgrade will be added to migrate existing system database to SURVIVE REGION and the same version gate will be used to block setting SURVIVE REGION incorrectly. The tables will setup as system.lease, system.sqlliveness, system.sqlinstances will be migrated to SURVIVE ZONE.
4. Previously, some system tables incorrectly did not have the inherit flags set on their zone configurations, these will be fixed during migration and during bootstrap.g
5. The system.lease session based upgrade had a bug which caused it incorrectly be setup on multi-region configurations by not propagating partition information on the primary index.

Fixes: #119090 Epic: CC-24173

[cockroach-teamcity]

This change is 

[rafiss]

this is totally unrelated to your PR, but while we are adding one system database upgrade migration, do you think we could fix https://github.com/cockroachdb/cockroach/issues/113296 as well?

[fqazi]

this is totally unrelated to your PR, but while we are adding one system database upgrade migration, do you think we could fix #113296 as well?

Yeah I'll sort that out here as well

[fqazi]

@rafiss Reworked things a bit, since after chatting with Jeff we need to leave the system database as SURVIVE REGION, but only configure SURVIVE ZONE on the regional by row tables.

@JeffSwenson RFAL

[fqazi]

bors r+

[fqazi]

@rafiss @JeffSwenson TFTR!

[craig[bot]]

Build failed:

• Bazel Essential CI (Cockroach)

[fqazi]

bors r-

[fqazi]

bors r+

[craig[bot]]

Build succeeded:

• Bazel Essential CI (Cockroach)

[RaduBerinde]

We forgot to bump SystemDatabaseSchemaBootstrapVersion here.. Note that this was mentioned in TestSystemDatabaseSchemaBootstrapVersionBumped which was modified.