path: root/filamento/filamento.db

SQLite format 3

@  
.zp
�
~��
�`�
R�Q
��
>
��
��y��9�
~�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_rosterCREATE 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)
)9M'
indexsqlite_autoindex_groups_roster_1groups_rosterX
�tablegroupsgroupsCREATE 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_1rostere%%
�
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�)
--
�table_sqlx_migrations_sqlx_migrationsCREATE TABLE _sqlx_migrations (
    version BIGINT PRIMARY KEY,
    description TEXT NOT NULL,
    installed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    success BOOLEAN NOT NULL,
    checksum BLOB NOT NULL,
    execution_time BIGINT NOT NULL
)?S-
indexsqlite_autoindex__sqlx_migrations_1_sqlx_migrations

��V
3	lh���luz2025-03-26 15:54:30K��@�3l#j�n�\�}��k��F�����Yl��G�(����.�A}�
vP,
@

��		h���
���%test@blos.sm
#cel@blos.sm
���%
test@blos.sm#	cel@blos.sm


	}��������}	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
���%test@blos.smnone
#cel@blos.smcelbuddy
���%
test@blos.sm#	cel@blos.sm
���
Contacts	
Buddies
���
Contacts
	Buddies
���#Contactscel@blos.sm
#Buddiescel@blos.sm
���#
Contactscel@blos.sm#	Buddiescel@blos.sm





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

��