room_aliases
5 rows
This data as json, CSV (advanced)
| Link | rowid ▼ | room_alias | room_id | creator |
|---|---|---|---|---|
| 1 | 1 | #telegram_TelegramTips:matrix.jamesst.one | !TuuVfHAWQDmtlxZyTc:matrix.jamesst.one | @telegrambot:matrix.jamesst.one |
| 2 | 2 | #telegram_contest:matrix.jamesst.one | !HenNzFPhosZJtuised:matrix.jamesst.one | @telegrambot:matrix.jamesst.one |
| 3 | 3 | #telegram_BotNews:matrix.jamesst.one | !UJqzdqWCbSZOHNGKko:matrix.jamesst.one | @telegrambot:matrix.jamesst.one |
| 4 | 4 | #telegram_PINE64_News:matrix.jamesst.one | !YxUaZYbdgvuEmWItoI:matrix.jamesst.one | @telegrambot:matrix.jamesst.one |
| 5 | 5 | #telegram_dust_announce:matrix.jamesst.one | !cguwnZmgchwVGBBQsA:matrix.jamesst.one | @telegrambot:matrix.jamesst.one |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE room_aliases( room_alias TEXT NOT NULL, room_id TEXT NOT NULL, creator TEXT, UNIQUE (room_alias) ); CREATE INDEX room_aliases_id ON room_aliases(room_id);