Gitea install failure

**Describe the problem**

Gitea install fails when configuring CockroachDB as PostgreSQL database source

**To Reproduce**

Initiate a Gitea install, providing a CockroachDB as PG db source.

**Expected behavior**
Gitea installs without error.

**Additional data / screenshots**

Install log says:
`The database settings are invalid: migrate: sync: pq: multiple primary keys for table "version" are not allowed`

**Environment:**
Gitea 1.22.2 and Cockroach v24.2.0 (in container)

**Additional context**

I gave it an other try after removing the primary key from the table "version", but the same occured.

Gitea uses ORM on top of the DB, also handling and modifying the schema.

Gitea works well with a traditional PostgreSQL server.

Jira issue: CRDB-42492

Epic CRDB-16356

Start with Jira issue CRDB-42492 and reproduce the Gitea 1.22.2 installation using CockroachDB v24.2.0 as a PostgreSQL source. Investigate the reported duplicate-primary-key migration error around the `version` table; done means Gitea installs successfully without that schema error.

Written by the indexing model from the issue text.