sqlite> .schema
CREATE TABLE drafts ( key TEXT UNIQUE PRIMARY KEY NOT NULL, text TEXT NOT NULL);
CREATE TABLE messages ( id TEXT UNIQUE PRIMARY KEY NOT NULL, local_id TEXT, thread TEXT NOT NULL, user TEXT NOT NULL, type INTEGER NOT NULL, future_type INTEGER, content TEXT, time INTEGER NOT NULL);
CREATE TABLE olm_persist_account ( id INTEGER UNIQUE PRIMARY KEY NOT NULL, account_data TEXT NOT NULL);
CREATE TABLE olm_persist_sessions ( target_user_id TEXT UNIQUE PRIMARY KEY NOT NULL, session_data TEXT NOT NULL);
CREATE TABLE media ( id TEXT UNIQUE PRIMARY KEY NOT NULL, container TEXT NOT NULL, thread TEXT NOT NULL, uri TEXT NOT NULL, type TEXT NOT NULL, extras TEXT NOT NULL);
CREATE TABLE threads ( id TEXT UNIQUE PRIMARY KEY NOT NULL, type INTEGER NOT NULL, name TEXT, description TEXT, color TEXT NOT NULL, creation_time BIGINT NOT NULL, parent_thread_id TEXT, containing_thread_id TEXT, community TEXT, members TEXT NOT NULL, roles TEXT NOT NULL, current_user TEXT NOT NULL, source_message_id TEXT, replies_count INTEGER NOT NULL);
CREATE TABLE metadata ( name TEXT UNIQUE PRIMARY KEY NOT NULL, data TEXT NOT NULL);
CREATE INDEX media_idx_container ON media (container);
CREATE INDEX messages_idx_thread_time ON messages (thread, time);
sqlite> .indexes
media_idx_container
messages_idx_thread_time
sqlite_autoindex_drafts_1
sqlite_autoindex_media_1
sqlite_autoindex_messages_1
sqlite_autoindex_metadata_1
sqlite_autoindex_olm_persist_account_1
sqlite_autoindex_olm_persist_sessions_1
sqlite_autoindex_threads_1

sqlite> .databases
main: /Users/kamil/comm/comm/test-for-atul-2.db r/w