-- 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)
);