Shared Hosting - Missing index

Hi there,

i am using Nextcloud on a shared Hosting without SSH access, so i am not able to use occ.

I have to add some new Indexes and so on with phpmyadmin.

Maybe someone can help me with the right commands?

Missing Index:

  • Fehlender Index “fs_size” in der Tabelle “oc_filecache”.
  • Fehlender Index “calendarobject_calid_index” in der Tabelle “oc_calendarobjects_props”.
  • Fehlender Index “schedulobj_principuri_index” in der Tabelle “oc_schedulingobjects”.
  • Fehlender Index “properties_path_index” in der Tabelle “oc_properties”.

Missing column:

  • Fehlende optionale Spalte “reference_id” in der Tabelle “oc_comments”.

Missing convertion to big int:

  • filecache_extended.fileid
  • mounts.storage_id
  • mounts.root_id
  • mounts.mount_id

i have already found/used this:

but those commands are only for some of the missing indixes.