powered by Jive Software

Add a trigger on database

Hello,

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?

Thanks

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.

Thanks