代码搜索：PostgreSQL
找到约 4,136 项符合「PostgreSQL」的源代码
代码结果 4,136
www.eeworm.com/read/412766/2165496
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
-- Create PubSub Tables
CREATE TABLE pubsubNode (
serviceID VARCHAR(100) NOT NULL,
nodeID VARCHAR(100) NOT NULL,
leaf
www.eeworm.com/read/412766/2165503
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
-- Update jiveVersion to Openfire 2.5
UPDATE jiveVersion SET majorVersion=2, minorVersion=5;
-- jivePrivacyList: Create new table
CREATE TABLE jivePrivacyList (
www.eeworm.com/read/412766/2165510
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
ALTER TABLE jiveRemoteServerConf RENAME COLUMN domain TO xmppDomain;
ALTER TABLE jiveOffline RENAME COLUMN message TO stanza;
ALTER TABLE jiveVCard RENAME COLUMN value
www.eeworm.com/read/412766/2165517
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
-- Drop old columns of pubSubNode
ALTER TABLE pubsubNode DROP COLUMN contacts;
ALTER TABLE pubsubNode DROP COLUMN rosterGroups;
ALTER TABLE pubsubNode DROP COLUMN replyR
www.eeworm.com/read/412766/2165524
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
ALTER TABLE mucConversationLog RENAME COLUMN time TO logTime;
UPDATE jiveVersion set version=12 where name = 'openfire';
www.eeworm.com/read/412766/2165531
sql openfire_postgresql.sql
-- add wildcard column to ofExtComponentConf
ALTER TABLE ofExtComponentConf ADD COLUMN wildcard INTEGER;
UPDATE ofExtComponentConf SET wildcard = 0;
-- Update version
UPDATE ofVersion SET version = 2
www.eeworm.com/read/412766/2165538
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
-- Update the jiveVersion table to new definition.
DROP TABLE jiveVersion;
CREATE TABLE jiveVersion (
name VARCHAR(50) NOT NULL,
version INTEGER NOT NU
www.eeworm.com/read/412766/2165545
sql openfire_postgresql.sql
-- create table jiveSecurityAuditLog
CREATE TABLE jiveSecurityAuditLog (
msgID INTEGER NOT NULL,
username VARCHAR(64) NOT NULL,
entryStamp BIG
www.eeworm.com/read/412766/2165552
sql openfire_postgresql.sql
-- add isHidden column to mucService, with isHidden set to false by default
ALTER TABLE mucService ADD COLUMN isHidden INTEGER;
UPDATE mucService SET isHidden = 0;
UPDATE jiveVersion set version=18
www.eeworm.com/read/412766/2165559
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
CREATE TABLE jiveSASLAuthorized (
username VARCHAR(64) NOT NULL,
principal VARCHAR(4000) NOT NULL,
CONSTRAINT jiveSASLAuthoirzed_pk PRIMARY KEY