[SAC] [OSGeo] #2976: Fix up Gitea database

[OSGeo]

#2976: Fix up Gitea database
--------------------+------------------------
 Reporter:  strk    |       Owner:  strk
     Type:  task    |      Status:  new
 Priority:  normal  |   Milestone:  Unplanned
Component:  Gitea   |  Resolution:
 Keywords:          |
--------------------+------------------------
Description changed by strk:

Old description:

> Looking at /var/log/gitea/gitea.log we seem to have some out-of-date
> database structure.
>
> Examples:
> ```
> 2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table webhook
> Column is_system_webhook db nullable is false, struct nullable is true
> 2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table hook_task
> column id db type is SERIAL, struct type is BIGSERIAL
> 2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table hook_task
> has column repo_id but struct has not related field
> 2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table review
> column type db type is VARCHAR(255), struct type is INTEGER
> ```
>
> There might be a missing upgrade procedure step to be performed (maybe on
> staging first)

New description:

 Looking at /var/log/gitea/gitea.log we seem to have some out-of-date
 database structure.

 Examples:
 {{{
 2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table webhook
 Column is_system_webhook db nullable is false, struct nullable is true
 2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table hook_task
 column id db type is SERIAL, struct type is BIGSERIAL
 2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table hook_task
 has column repo_id but struct has not related field
 2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table review
 column type db type is VARCHAR(255), struct type is INTEGER
 }}}

 There might be a missing upgrade procedure step to be performed (maybe on
 staging first)

--
-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2976#comment:3>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.