Question

This question addressed how to get access to the latest FogBugz database schema as well as the schema for a given installation of FogBugz via a URL.

However for the purposes of versioning a feature of my plug-in, I need to know when a specific table was introduced. Short of installing every old version of FogBugz and hitting that URL, is there a source of historical DB schema versions available somewhere including information about what version of FB each schema was introduced?

Also, is there a way to detect the DB schema version through the API?

I know, I know. I hate coding these plug-ins directly against the FB data structure directly, but there doesn't seem to be an API yet to access the permissions groups.

Answer 1

The only thing I can tell you to do is to query the Version table. The ixVersion column is the version of the database schema. I don't think we keep documentation for old versions around.

Internally, our strategy is mostly to have the plugin only work on the current version of FogBugz. We don't test new plugins against old releases.

If there's a particular API you need added, we'd like to hear about and what you need it for. For permissions, we've tried to do that transparently with various objects like CBug doing the work for you. Can you make a new post describing the interface you need?