_memory
| type | name | tbl_name | rootpage | sql |
|---|---|---|---|---|
| table | archive_messages | archive_messages | 2 | CREATE TABLE archive_messages( event_id TEXT, room_id TEXT, ts INT, sent_at, sender TEXT, sender_name TEXT, network, msgtype TEXT, body TEXT, url, filename TEXT, size INT, mimetype TEXT, reply_to TEXT ) |
| table | archive_rooms | archive_rooms | 54216 | CREATE TABLE archive_rooms( room_id TEXT, name, alias, topic TEXT ) |
| table | archive_fts | archive_fts | 0 | CREATE VIRTUAL TABLE archive_fts USING fts5(event_id UNINDEXED, body, tokenize='trigram') |
| table | archive_fts_data | archive_fts_data | 54249 | CREATE TABLE 'archive_fts_data'(id INTEGER PRIMARY KEY, block BLOB) |
| table | archive_fts_idx | archive_fts_idx | 54250 | CREATE TABLE 'archive_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID |
| table | archive_fts_content | archive_fts_content | 54251 | CREATE TABLE 'archive_fts_content'(id INTEGER PRIMARY KEY, c0, c1) |
| table | archive_fts_docsize | archive_fts_docsize | 54252 | CREATE TABLE 'archive_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB) |
| table | archive_fts_config | archive_fts_config | 54253 | CREATE TABLE 'archive_fts_config'(k PRIMARY KEY, v) WITHOUT ROWID |