42 lines
749 B
SQL
42 lines
749 B
SQL
-- Cheogram
|
|
create table cheogram.messages (
|
|
uuid text,
|
|
subject text,
|
|
oobUri text,
|
|
fileParams text,
|
|
payloads text,
|
|
timeReceived NUMBER,
|
|
occupant_id text
|
|
);
|
|
|
|
create table cheogram.blocked_media (
|
|
cid text not null primary key
|
|
);
|
|
|
|
create table cheogram.cids (
|
|
cid text not null primary key,
|
|
path text not null,
|
|
url text
|
|
);
|
|
CREATE TABLE cheogram.webxdc_updates (
|
|
serial INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
conversationUuid text not null,
|
|
sender TEXT NOT NULL,
|
|
thread TEXT NOT NULL,
|
|
threadParent TEXT,
|
|
info TEXT,
|
|
document TEXT,
|
|
summary TEXT,
|
|
payload text,
|
|
message_id text
|
|
);
|
|
|
|
CREATE TABLE cheogram.muted_participants (
|
|
muc_jid TEXT NOT NULL,
|
|
occupant_id TEXT NOT NULL,
|
|
nick TEXT NOT NULL,
|
|
PRIMARY KEY (muc_jid, occupant_id)
|
|
);
|
|
|
|
|