wildfire_sybase.sql

来自「基于Jabber协议的即时消息服务器」· SQL 代码 · 共 15 行

/* $Revision:  $ */
/* $Date:  $ */

/* Update the jiveVersion table to new definition. */
DROP TABLE jiveVersion;
CREATE TABLE jiveVersion (
  name     NVARCHAR(50) NOT NULL,
  version  INTEGER  NOT NULL,
  CONSTRAINT jiveVersion_pk PRIMARY KEY (name)
);
INSERT INTO jiveVersion (name, version) VALUES ('wildfire', 6);

/* Make password column accept null, add encrypted password column. */
ALTER TABLE jiveUser MODIFY password NVARCHAR(32);
ALTER TABLE jiveUser ADD encryptedPassword NVARCHAR(255);