db updates

[jtullett]

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

[Brandin]

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.

[jtullett]

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.