代码搜索:SQLserver
找到约 3,940 项符合「SQLserver」的源代码
代码结果 3,940
www.eeworm.com/read/412766/2165480
sql openfire_sqlserver.sql
/* $Revision: $ */
/* $Date: $ */
CREATE TABLE jivePresence (
username NVARCHAR(64) NOT NULL,
offlinePresence NTEXT,
offlineDate CHAR(15) NOT NULL,
www.eeworm.com/read/412766/2165487
sql openfire_sqlserver.sql
/* create table jiveUserFlag */
CREATE TABLE jiveUserFlag (
username NVARCHAR(64) NOT NULL,
name NVARCHAR(100) NOT NULL,
startTime CHAR(15),
endT
www.eeworm.com/read/412766/2165494
sql openfire_sqlserver.sql
/* $Revision: $ */
/* $Date: $ */
/* Create PubSub Tables */
CREATE TABLE pubsubNode (
serviceID NVARCHAR(100) NOT NULL,
nodeID NVARCHAR(
www.eeworm.com/read/412766/2165501
sql openfire_sqlserver.sql
/* $Revision: $ */
/* $Date: $ */
/* Update jiveVersion to Openfire 2.5 */
UPDATE jiveVersion SET majorVersion=2, minorVersion=5;
/* jivePrivacyList
www.eeworm.com/read/412766/2165508
sql openfire_sqlserver.sql
/* $Revision: $ */
/* $Date: $ */
sp_rename 'jiveRemoteServerConf.domain', 'xmppDomain';
sp_rename 'jiveOffline.message', 'stanza';
sp_rename 'jiveVCard.value', 'vcard';
sp_rename 'jivePri
www.eeworm.com/read/412766/2165515
sql openfire_sqlserver.sql
/* $Revision: $ */
/* $Date: $ */
/* Drop old columns of pubSubNode */
ALTER TABLE pubsubNode DROP COLUMN contacts;
ALTER TABLE pubsubNode DROP COLUMN rosterGroups;
ALTER TA
www.eeworm.com/read/412766/2165522
sql openfire_sqlserver.sql
/* $Revision: $ */
/* $Date: $ */
sp_rename 'mucConversationLog.time', 'logTime';
UPDATE jiveVersion set version=12 where name = 'openfire';
www.eeworm.com/read/412766/2165529
sql openfire_sqlserver.sql
/* add wildcard column to ofExtComponentConf */
ALTER TABLE ofExtComponentConf ADD wildcard INT DEFAULT 0 NOT NULL;
/* Update version */
UPDATE ofVersion SET version = 20 WHERE name = 'openfire';
www.eeworm.com/read/412766/2165536
sql openfire_sqlserver.sql
/* $Revision: $ */
/* $Date: $ */
/* Update the jiveVersion table to new definition. */
DROP TABLE jiveVersion;
CREATE TABLE jiveVersion (
name NVARCHAR(50) NOT
www.eeworm.com/read/412766/2165543
sql openfire_sqlserver.sql
/* create table jiveSecurityAuditLog */
CREATE TABLE jiveSecurityAuditLog (
msgID INTEGER NOT NULL,
username NVARCHAR(64) NOT NULL,
entryStamp