Bug / Bugfix: SQL Script for MS SQL Server


Openfire 3.5 latest (downloaded yesterday), used the plugins section to download the Asterisk-IM plugin and the install failed.

SQL Server 2005, code from resources/asterisk-im_sqlserver.sql …

phoneUser.userID is defined as an integer, phoneDevice.userID is a bigint, and the constraint linking the two fails because of this.

Redefining the phoneDevice.userID to be an integer allows the script to run.

I’ve created PHONE-75 for this issue and fixed it for the next release.

Thanks for reporting.