I'm creating a directory with multiple languages, so I started with changing the categories table. I added ex. Name_en and Full_Name_en etc.

As far as I understand the original Full_Name is generated by the Category Name so that it will look like Category/Sub Category/Sub Sub Category

This is fine with the original fields, but how can I make that is also automatically generated in the new Full_Name_en field from the Name_en fields of the table?

Thanks