代码搜索：Postgresql
找到约 4,136 项符合「Postgresql」的源代码
代码结果 4,136
www.eeworm.com/read/311746/3677809
sql openfire_postgresql.sql
-- jiveRoster: Add new index
CREATE INDEX jiveRoster_jid_idx ON jiveRoster (jid);
UPDATE jiveVersion set version=14 where name = 'openfire';
www.eeworm.com/read/311746/3677816
sql openfire_postgresql.sql
-- $Revision: $
-- $Date: $
-- Increase size of username field
ALTER TABLE jiveUser ADD COLUMN temp varchar(64);
UPDATE jiveUser SET temp = username;
ALTER TABLE jiveUser DROP CONSTRAINT jiveUser_
www.eeworm.com/read/311746/3677822
sql openfire_postgresql.sql
-- $Revision: 1650 $
-- $Date: 2005-07-20 00:18:17 -0300 (Wed, 20 Jul 2005) $
-- Update jiveVersion to JM 2.2
UPDATE jiveVersion SET majorVersion=2, minorVersion=2;
-- jiveExtComponentConf: Cr
www.eeworm.com/read/311746/3677828
sql openfire_postgresql.sql
-- $Revision: 795 $
-- $Date: 2005-01-06 07:44:42 -0300 (Thu, 06 Jan 2005) $
-- jiveGroup: Recreate table from scratch
DROP TABLE jiveGroup;
CREATE TABLE jiveGroup (
groupName VAR
www.eeworm.com/read/311746/3677835
sql openfire_postgresql.sql
-- $Revision: 795 $
-- $Date: 2005-01-06 07:44:42 -0300 (Thu, 06 Jan 2005) $
-- Update jiveVersion to JM 2.4
UPDATE jiveVersion SET majorVersion=2, minorVersion=4;
-- jiveGroupUser: Alter leng
www.eeworm.com/read/311746/3677842
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/311746/3677849
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/311746/3677856
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/311746/3677863
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/311746/3677870
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