gateway_hsqldb.sql 969 Bytes
Newer Older
1
CREATE TABLE gatewayRegistration (
2 3
   registrationID    BIGINT         NOT NULL,
   jid               VARCHAR(255)   NOT NULL,
4
   transportType     VARCHAR(15)    NOT NULL,
5 6
   username          VARCHAR(255)   NOT NULL,
   password          VARCHAR(255),
7
   nickname          VARCHAR(255),
8 9
   registrationDate  BIGINT         NOT NULL,
   lastLogin         BIGINT,
Matt Tucker's avatar
Matt Tucker committed
10
   CONSTRAINT gatewayReg_pk PRIMARY KEY (registrationID)
11
);
12
CREATE INDEX gatewayReg_jid_idx ON gatewayRegistration (jid);
13
CREATE INDEX gatewayReg_type_idx ON gatewayRegistration (transportType);
14

15 16 17 18 19 20 21 22 23 24
CREATE TABLE gatewayPseudoRoster (
   registrationID    BIGINT         NOT NULL,
   username          VARCHAR(255)   NOT NULL,
   nickname          VARCHAR(255),
   groups            VARCHAR(255)
);
CREATE INDEX gatewayPsRs_regid_idx ON gatewayPseudoRoster (registrationID);
CREATE INDEX gatewayPsRs_uname_idx ON gatewayPseudoRoster (username);

INSERT INTO jiveVersion (name, version) VALUES ('gateway', 1);