代码搜索:Postgresql
找到约 4,136 项符合「Postgresql」的源代码
代码结果 4,136
www.eeworm.com/read/413153/2164137
sql upload_postgresql.sql
CREATE TABLE "public"."uploads" (
"filename" VARCHAR(255),
uploadid SERIAL,
"binaryfile" BYTEA,
UNIQUE("uploadid")
) WITH OIDS;
www.eeworm.com/read/412766/2165435
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/412766/2165442
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/412766/2165448
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/412766/2165454
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/412766/2165461
sql openfire_postgresql.sql
-- create table mucService
CREATE TABLE mucService (
serviceID INTEGER NOT NULL,
subdomain VARCHAR(255) NOT NULL,
description VARCHAR(255),
CONSTRAINT mucSer
www.eeworm.com/read/412766/2165468
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/412766/2165475
sql openfire_postgresql.sql
-- Rename jiveUser to ofUser
DROP INDEX jiveUser_cDate_idx;
ALTER TABLE jiveUser DROP CONSTRAINT jiveUser_pk;
ALTER TABLE jiveUser RENAME TO ofUser;
ALTER TABLE ofUser ADD CONSTRAINT ofUser_pk PRIMARY
www.eeworm.com/read/412766/2165482
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/412766/2165489
sql openfire_postgresql.sql
-- create table jiveUserFlag
CREATE TABLE jiveUserFlag (
username VARCHAR(64) NOT NULL,
name VARCHAR(100) NOT NULL,
startTime CHAR(15),
endTime