2 -- This is the required schema for sqlite.
4 -- sqlite3 jabberd2.db < db-setup.sqlite
6 -- Please create database at /var/lib/jabberd/
10 -- c2s authentication/registration table
12 CREATE TABLE 'authreg' (
21 -- Session manager tables
25 -- Active (seen) users
28 CREATE TABLE 'active' (
29 'collection-owner' TEXT NOT NULL,
30 'object-sequence' INTEGER PRIMARY KEY,
35 -- Used by: mod_iq_last
37 CREATE TABLE 'logout' (
38 'collection-owner' TEXT NOT NULL,
39 'object-sequence' INTEGER PRIMARY KEY,
44 -- Used by: mod_roster
46 CREATE TABLE 'roster-items' (
47 'collection-owner' TEXT NOT NULL,
48 'object-sequence' INTEGER PRIMARY KEY,
57 -- Used by: mod_roster
59 CREATE TABLE 'roster-groups' (
60 'collection-owner' TEXT NOT NULL,
61 'object-sequence' INTEGER PRIMARY KEY,
66 -- vCard (user profile information)
67 -- Used by: mod_iq_vcard
69 CREATE TABLE 'vcard' (
70 'collection-owner' TEXT NOT NULL,
71 'object-sequence' INTEGER PRIMARY KEY,
93 -- Offline message queue
94 -- Used by: mod_offline
96 CREATE TABLE 'queue' (
97 'collection-owner' TEXT NOT NULL,
98 'object-sequence' INTEGER PRIMARY KEY,
102 -- Private XML storage
103 -- Used by: mod_iq_private
105 CREATE TABLE 'private' (
106 'collection-owner' TEXT NOT NULL,
107 'object-sequence' INTEGER PRIMARY KEY,
112 -- Message Of The Day (MOTD) messages (announcements)
113 -- Used by: mod_announce
115 CREATE TABLE 'motd-message' (
116 'collection-owner' TEXT NOT NULL,
117 'object-sequence' INTEGER PRIMARY KEY,
121 -- Times of last MOTD message for each user
122 -- Used by: mod_announce
124 CREATE TABLE 'motd-times' (
125 'collection-owner' TEXT NOT NULL,
126 'object-sequence' INTEGER PRIMARY KEY,
130 -- User-published discovery items
131 -- Used by: mod_disco_publish
133 CREATE TABLE 'disco-items' (
134 'collection-owner' TEXT NOT NULL,
135 'object-sequence' INTEGER PRIMARY KEY,
141 -- Default privacy list
142 -- Used by: mod_privacy
144 CREATE TABLE 'privacy-default' (
145 'collection-owner' TEXT NOT NULL,
146 'object-sequence' INTEGER PRIMARY KEY,
151 -- Used by: mod_privacy
153 CREATE TABLE 'privacy-items' (
154 'collection-owner' TEXT NOT NULL,
155 'object-sequence' INTEGER PRIMARY KEY,
165 -- Used by: mod_vacation
167 CREATE TABLE 'vacation-settings' (
168 'collection-owner' TEXT NOT NULL,
169 'object-sequence' INTEGER PRIMARY KEY,