88 lines
2.5 KiB
SQL
88 lines
2.5 KiB
SQL
-- Corresponds to Conversations versions 2.11.0-beta to 2.???
|
|
-- (internal database format versions 51 to ???).
|
|
-- Reference: https://github.com/iNPUTmice/ceb2txt/blob/8b43f40fbce16a0276c9f82a28ab419aa872156d/src/main/java/im/conversations/ceb2txt/Main.java
|
|
-- See also https://codeberg.org/iNPUTmice/Conversations/src/commit/d51682a9bc63048db4536a788ac51cc6ad75b23b/src/main/java/eu/siacs/conversations/persistance/DatabaseBackend.java
|
|
CREATE TABLE accounts (
|
|
uuid text primary key,
|
|
username text,
|
|
server text,
|
|
password text,
|
|
display_name text,
|
|
status number,
|
|
status_message text,
|
|
rosterversion text,
|
|
options number,
|
|
avatar text,
|
|
keys text,
|
|
hostname text,
|
|
port number,
|
|
resource text,
|
|
pinned_mechanism text,
|
|
pinned_channel_binding text,
|
|
fast_mechanism text,
|
|
fast_token text
|
|
);
|
|
CREATE TABLE conversations (
|
|
uuid text,
|
|
accountUuid text,
|
|
name text,
|
|
contactUuid text,
|
|
contactJid text,
|
|
created number,
|
|
status number,
|
|
mode number,
|
|
attributes text
|
|
);
|
|
CREATE TABLE messages (
|
|
uuid text,
|
|
conversationUuid text,
|
|
timeSent number,
|
|
counterpart text,
|
|
trueCounterpart text,
|
|
body text,
|
|
encryption number,
|
|
status number,
|
|
type number,
|
|
relativeFilePath text,
|
|
serverMsgId text,
|
|
axolotl_fingerprint text,
|
|
carbon number,
|
|
edited number,
|
|
read number,
|
|
oob number,
|
|
errorMsg text,
|
|
readByMarkers text,
|
|
markable number,
|
|
remoteMsgId text,
|
|
deleted number,
|
|
bodyLanguage text
|
|
);
|
|
CREATE TABLE prekeys (
|
|
account text,
|
|
id text,
|
|
key text
|
|
);
|
|
CREATE TABLE signed_prekeys (
|
|
account text,
|
|
id text,
|
|
key text
|
|
);
|
|
CREATE TABLE sessions (
|
|
account text,
|
|
name text,
|
|
device_id text,
|
|
key text
|
|
);
|
|
CREATE TABLE identities (
|
|
account text,
|
|
name text,
|
|
ownkey text,
|
|
fingerprint text,
|
|
certificate text,
|
|
trust number,
|
|
active number,
|
|
last_activation number,
|
|
key text
|
|
);
|
|
|