I'm having a issue with the migration from Jdownloads 1.9.x to 2.5.x, indeed, after the migration I've noticed that the column file_id from the table xxx_jdownloads_files has been automatically re-ordered, if for example the values of file_id was like 2, 4, 5, 8, 10, 14 now its like 1, 2, 3, 4, 5, 6, and so on.
My problem is that I use the file_id to link a download to an URL, like for example : http://www.exemple.com/fr/downloads/download/674http://www.exemple.com/fr/downloads/download/475http://www.exemple.com/fr/downloads/download/686http://www.exemple.com/fr/downloads/download/607
Since I did the migration, every link is pointing to the wrong download !
I need to get back to the exact order that I had in Jdownloads 1.9 because those links are hard coded into my softwares, I can't update them
. Fortunately, I have a backup of the column file_id from the jdownloads 1.9.
What I want is to make the Jdownloads 2.5 column file_id equal to the Jdownloads 1.9 column file_id. I think there is a way to do that in SQL (make a column equal to another one from another table), I have been searching for hours and nothing works out. Please I need some help here.