1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
--
-- This updates jabberd2 sqlite databases created prior to 2.1.19.
--
-- sqlite3 jabberd2.db < db-setup.sqlite
--
ALTER TABLE "authreg" ADD COLUMN "token" TEXT;
ALTER TABLE "authreg" ADD COLUMN "sequence" INTEGER;
ALTER TABLE "authreg" ADD COLUMN "hash" TEXT;
ALTER TABLE "vcard" ADD COLUMN "jabberid" TEXT;
ALTER TABLE "vcard" ADD COLUMN "mailer" TEXT;
ALTER TABLE "vcard" ADD COLUMN "uid" TEXT;
ALTER TABLE "status" ADD COLUMN "xml" TEXT;
--
-- Published roster items
-- Used by: mod_roster_publish
--
CREATE TABLE "published-roster" (
"collection-owner" TEXT NOT NULL,
"object-sequence" INTEGER PRIMARY KEY,
"jid" TEXT NOT NULL,
"group" TEXT,
"name" TEXT,
"to" BOOLEAN NOT NULL,
"from" BOOLEAN NOT NULL,
"ask" INTEGER NOT NULL );
CREATE INDEX i_pubrosteri_owner ON "published-roster"("collection-owner");
--
-- Published roster groups
-- Used by: mod_roster_publish
--
CREATE TABLE "published-roster-groups" (
"collection-owner" TEXT NOT NULL,
"object-sequence" INTEGER PRIMARY KEY,
"groupname" TEXT NOT NULL );
CREATE INDEX i_pubrosterg_owner ON "published-roster-groups"("collection-owner");
|
