+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: db updates (/showthread.php?tid=1174)
db updates - jtullett - 10-13-2018
Hi again
Question: when UserSpice updates, does it leave the database alone apart from adding any new tables/columns? I want to add some triggers to it, and I'd be sad if they were quietly removed without warning. I'll check first, obviously, but in the past would updates have removed them?
-Jon
RE: db updates - Brandin - 10-14-2018
We for the most part never issue DROP or DELETE statements on database updates. There are some rare occasions that we will to correct a beta feature, but that would be the most. We would never drop or modify any stored procedures, triggers, etc.
Brandin.
RE: db updates - jtullett - 10-14-2018
Thanks Brandin, that's perfect. I'm having to implement a workaround for inbound data I can't edit, and that means having to keep track of every email address a user has ever verified. I figured doing that via a trigger would be more durable than modifying the php.