Beep boop, touching database structures is always scary. I think I will have to (in order to make it "the right way") identify old !gnusocial database definition, upgrade it without unique indexing at first and then proceed with the proper ALTER TABLE statement afterwards.

^- note to self regarding File table 'urlhash' implementation, so we can perhaps get some utf8mb4 encoding and thus #emojis !