powered by Jive Software

Add a trigger on database


my OpenFire server uses MySQL as database engine. I’d like to to execute SQL instructions when a record in the ofusers table is updated, so I’d like to add a trigger on the table. I guess that it is possible but I was just wondering if there were some good reason not to do it, except the “If the next version of OpenFire changes the database, your trigger will be destroyed” reason?


You are exactly right. In general, very little activity is ongoing or planned for the database. (It is currently a mess). So your modification is likely to be fine for a while into the future.