openfire_hsqldb.sql

来自「xmpp协议的客户端软件」· SQL 代码 · 共 15 行

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

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

// Make password column accept null, add encrypted password column.
ALTER TABLE jiveUser ALTER COLUMN password VARCHAR(32);
ALTER TABLE jiveUser ADD COLUMN encryptedPassword VARCHAR(255) BEFORE name;