/usr/share/doc/jabberd2/db-update.sqlite is in jabberd2 2.6.1-3build1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 | --
-- 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");
|