/* $Revision: $ */
/* $Date: $ */
/* Update jiveVersion to Wildfire 2.5 */
UPDATE jiveVersion SET majorVersion=2, minorVersion=5;
/* jivePrivacyList: Create new table */
CREATE TABLE jivePrivacyList (
username NVARCHAR(32) NOT NULL,
name NVARCHAR(100) NOT NULL,
isDefault INT NOT NULL,
list NTEXT NOT NULL,
CONSTRAINT jivePrivacyList_pk PRIMARY KEY (username, name)
);
CREATE INDEX jivePList_default_idx ON jivePrivacyList (username, isDefault);
-
Gaston Dombiak authored
git-svn-id: http://svn.igniterealtime.org/svn/repos/wildfire/branches@3791 b35dd754-fafc-0310-a699-88a17e54d16e
7354facf