We're updating the issue view to help you get more done. 

Incorrect db script for MS SQL

Description

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.

See http://www.igniterealtime.org/community/message/169164

Environment

None

Acceptance Test - Entry

None

Assignee

Stefan Reuter

Reporter

Stefan Reuter

Labels

None

Expected Effort

None

Ignite Forum URL

None

Components

Fix versions

Affects versions

Priority

Major
Configure