代码搜索：PostgreSQL
找到约 4,136 项符合「PostgreSQL」的源代码
代码结果 4,136
www.eeworm.com/read/317330/3582031
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
CREATE TABLE jivePresence (
username VARCHAR(64) NOT NULL,
offlinePresence TEXT,
offlineDate VARCHAR(15) NOT NULL,
CONSTRAIN
www.eeworm.com/read/317330/3582038
sql openfire_postgresql.sql
-- create table jiveUserFlag
CREATE TABLE jiveUserFlag (
username VARCHAR(64) NOT NULL,
name VARCHAR(100) NOT NULL,
startTime CHAR(15),
endTime
www.eeworm.com/read/317330/3582045
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/317330/3582052
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/317330/3582059
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/317330/3582066
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/317330/3582073
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/317330/3582080
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/317330/3582087
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/317330/3582094
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
CREATE TABLE jiveSASLAuthorized (
username VARCHAR(64) NOT NULL,
principal VARCHAR(4000) NOT NULL,
CONSTRAINT jiveSASLAuthoirzed_pk PRIMARY KEY