代码搜索:Sybase
找到约 10,000 项符合「Sybase」的源代码
代码结果 10,000
www.eeworm.com/read/412766/2165464
sql openfire_sybase.sql
/* $Revision: 840 $ */
/* $Date: 2005-01-10 01:30:06 -0300 (Mon, 10 Jan 2005) $ */
/* Update jiveVersion to JM 2.4 */
UPDATE jiveVersion SET majorVersion=2
www.eeworm.com/read/412766/2165471
sql openfire_sybase.sql
/* Rename jiveUser to ofUser */
DROP INDEX jiveUser.jiveUser_cDate_idx;
ALTER TABLE jiveUser DROP CONSTRAINT jiveUser_pk;
sp_rename 'jiveUser', 'ofUser';
ALTER TABLE ofUser ADD CONSTRAINT ofUser_pk PR
www.eeworm.com/read/412766/2165478
sql openfire_sybase.sql
/* $Revision: $ */
/* $Date: $ */
CREATE TABLE jivePresence (
username NVARCHAR(64) NOT NULL,
offlinePresence TEXT,
offlineDate CHAR(15) NOT NULL,
CON
www.eeworm.com/read/412766/2165485
sql openfire_sybase.sql
/* create jiveUserFlag table */
CREATE TABLE jiveUserFlag (
username NVARCHAR(64) NOT NULL,
name NVARCHAR(100) NOT NULL,
startTime CHAR(15),
endT
www.eeworm.com/read/412766/2165492
sql openfire_sybase.sql
/* $Revision: $ */
/* $Date: $ */
/* Create PubSub Tables */
CREATE TABLE pubsubNode (
serviceID NVARCHAR(100) NOT NULL,
nodeID NVARCHAR(100) NOT NULL,
leaf
www.eeworm.com/read/412766/2165499
sql openfire_sybase.sql
/* $Revision: $ */
/* $Date: $ */
/* Update jiveVersion to Openfire 2.5 */
UPDATE jiveVersion SET majorVersion=2, minorVersion=5;
/* jivePrivacyList: Create new table */
CREATE TABLE jive
www.eeworm.com/read/412766/2165506
sql openfire_sybase.sql
/* $Revision: $ */
/* $Date: $ */
sp_rename 'jiveRemoteServerConf.domain', 'xmppDomain';
sp_rename 'jiveOffline.message', 'stanza';
sp_rename 'jiveVCard.value', 'vcard';
sp_rename 'jivePrivate.v
www.eeworm.com/read/412766/2165513
sql openfire_sybase.sql
/* $Revision: $ */
/* $Date: $ */
/* Drop old columns of pubSubNode */
ALTER TABLE pubsubNode DROP COLUMN contacts;
ALTER TABLE pubsubNode DROP COLUMN rosterGroups;
ALTER TABLE pubsubNode DROP COLU
www.eeworm.com/read/412766/2165520
sql openfire_sybase.sql
/* $Revision: $ */
/* $Date: $ */
sp_rename 'mucConversationLog.time', 'logTime';
UPDATE jiveVersion set version=12 where name = 'openfire';
www.eeworm.com/read/412766/2165527
sql openfire_sybase.sql
/* add wildcard column to ofExtComponentConf */
ALTER TABLE ofExtComponentConf ADD COLUMN wildcard INT DEFAULT 0 NOT NULL;
/* Update version */
UPDATE ofVersion SET version = 20 WHERE name = 'openfir