path: root/filamento/filamento.db

SQLite format 3

@  



.j�
����
��
W
�2
*�
<p	7
	�	����8''
�/tablecached_statuscached_statusCREATE TABLE cached_status (
    id integer primary key not null,
    show text,
    message text,
    foreign key(show) references show(state)
)M
tableshowshowCREATE TABLE show (
    state text primary key not null
)';
indexsqlite_autoindex_show_1show�e
�tablemessagesmessagesCREATE TABLE messages (
    id text primary key not null,
    body text,
    chat_id text not null,
    -- TODO: channel stuff 
    -- channel_id uuid,
    -- check ((chat_id == null) <> (channel_id == null)),
    -- check ((chat_id == null) or (channel_id == null)),
    -- user is the current "owner" of the message
    -- TODO: queued messages offline
    -- TODO: timestamp
    timestamp text not null,

    -- TODO: icky
    -- the user to show it coming from (not necessarily the original sender)
    -- from_identity text not null,
    -- original sender details (only from jabber supported for now)
    from_jid text not null,
    -- resource can be null
    from_resource text,
    -- check (from_jid != original_sender),

    -- TODO: from can be either a jid, a moved jid (for when a contact moves, save original sender jid/user but link to new user), or imported (from another service (save details), linked to new user)
    -- TODO: read bool not null,
    foreign key(chat_id) references chats(id) on delete cascade,
    -- foreign key(from_identity) references identities(id),
    foreign key(from_jid) references users(jid),
    foreign key(from_jid, from_resource) references resources(bare_jid, resource)
)/C
indexsqlite_autoindex_messages_1messages�,

�7tablechatschatsCREATE TABLE chats (
    id text primary key not null,
    correspondent text not null unique,
    foreign key(correspondent) references users(jid)
))=
indexsqlite_autoindex_chats_2chats)=
indexsqlite_autoindex_chats_1chats�1''
�!tablegroups_rostergroups_roster
CREATE TABLE groups_roster(
    group_name text not null,
    contact_jid text not null,
    foreign key(group_name) references groups(group_name),
    foreign key(contact_jid) references roster(user_jid) on delete cascade,
    primary key(group_name, contact_jid)
)9M'
indexsqlite_autoindex_groups_roster_1groups_rosterX	
�tablegroupsgroupsCREATE TABLE groups(
    group_name text primary key not null
)+
?
indexsqlite_autoindex_groups_1groups�u
�Etablerosterroster	CREATE TABLE roster( 
    user_jid text primary key not null,
    name TEXT,
    subscription text not null,
    foreign key(subscription) references subscription(state),
    foreign key(user_jid) references users(jid)
)+?
indexsqlite_autoindex_roster_1roster
e%%
�
tablesubscriptionsubscriptionCREATE TABLE subscription(
    state text primary key not null
)7K%
indexsqlite_autoindex_subscription_1subscription�E
�YtableresourcesresourcesCREATE TABLE resources(
    bare_jid text not null,
    resource text not null,
    foreign key(bare_jid) references users(jid),
    primary key(bare_jid, resource)
)1E
indexsqlite_autoindex_resources_1resources�X

�tableusersusersCREATE TABLE users(
    -- TODO: enforce bare jid
    jid text primary key not null,
    -- can receive presence status from non-contacts
    cached_status_message text
    -- TODO: last_seen
))=
indexsqlite_autoindex_users_1users
























	}��������}	buddy)in-pending-out)out-pending-in	only-in
only-out9pending-in-pending-out!pending-in
#pending-out
none
	uu�������	
buddy	)
in-pending-out)
out-pending-in
only-in
only-out9
pending-in-pending-out!
pending-in#
pending-out	none











�����'extended-away)do-not-disturbchat
away
�����'
extended-away)
do-not-disturb
chat	away

��