Hi Rudolf and other developers, just a warning from my experience.
So I was modifying my version, making a few improvements and updates. Added a new column to the table and updated the picture table with correct data in the column I just added.
Went to the page to view the changes. And everything was gone.
on update CURRENT_TIMESTAMP
had changed the date of the column for all respective pictures resulting in that all pictures was gone.
Luckily I was able to write a script that just simply located the files and updated the database with the correct date again (recursive search the dir for the file and then explode the dirs to get the date).
Now Im concidering to create a sepperate table for my column, making it a real plugin. But I think that was a scary thing. Its not wrong to do as you did, It might even be the correct way to ensure that it always updates. But I just had a horrible experience with it.
So I was modifying my version, making a few improvements and updates. Added a new column to the table and updated the picture table with correct data in the column I just added.
Went to the page to view the changes. And everything was gone.
on update CURRENT_TIMESTAMP
had changed the date of the column for all respective pictures resulting in that all pictures was gone.
Luckily I was able to write a script that just simply located the files and updated the database with the correct date again (recursive search the dir for the file and then explode the dirs to get the date).
Now Im concidering to create a sepperate table for my column, making it a real plugin. But I think that was a scary thing. Its not wrong to do as you did, It might even be the correct way to ensure that it always updates. But I just had a horrible experience with it.