chat

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidversionfile
1 73 73/01event_failed_pull_attempts.sql
2 73 73/02add_pusher_enabled.sql
3 73 73/02room_id_indexes_for_purging.sql
4 73 73/03pusher_device_id.sql
5 73 73/03users_approved_column.sql
6 73 73/04partial_join_details.sql
7 73 73/04pending_device_list_updates.sql
8 73 73/05old_push_actions.sql.sqlite
9 73 73/06thread_notifications_thread_id_idx.sql
10 73 73/08thread_receipts_non_null.sql.sqlite
11 73 73/09partial_joined_via_destination.sql
12 73 73/09threads_table.sql
13 73 73/10_update_sqlite_fts4_tokenizer.py
14 73 73/10login_tokens.sql
15 73 73/12refactor_device_list_outbound_pokes.sql
16 73 73/13add_device_lists_index.sql
17 73 73/20_un_partial_stated_room_stream.sql
18 73 73/22_rebuild_user_dir_stats.sql
19 73 73/22_un_partial_stated_event_stream.sql
20 73 73/23_fix_thread_index.sql
21 73 73/24_events_jump_to_date_index.sql
22 73 73/25drop_presence.sql
23 74 74/01_user_directory_stale_remote_users.sql
24 74 74/02_set_device_id_for_pushers_bg_update.sql
25 74 74/03_membership_tables_event_stream_ordering.sql.sqlite
26 74 74/03_room_membership_index.sql
27 74 74/04_delete_e2e_backup_keys_for_deactivated_users.sql
28 74 74/04_membership_tables_event_stream_ordering_triggers.py
29 74 74/05_events_txn_id_device_id.sql
30 76 76/01_add_profiles_full_user_id_column.sql
31 76 76/02_add_user_filters_full_user_id_column.sql
32 76 76/03_per_user_experimental_features.sql
33 76 76/04_add_room_forgetter.sql
34 77 77/03bg_populate_full_user_id_profiles.sql
35 77 77/04bg_populate_full_user_id_user_filters.sql
36 77 77/05thread_notifications_backfill.sql
37 77 77/06thread_notifications_not_null.sql.sqlite
38 77 77/14bg_indices_event_stream_ordering.sql
39 78 78/01_validate_and_update_profiles.py
40 78 78/02_validate_and_update_user_filters.py
41 78 78/03_remove_unused_indexes_user_filters.py
42 78 78/03event_extremities_constraints.py
43 78 78/04_add_full_user_id_index_user_filters.py
44 79 79/03_read_write_locks_triggers.sql.sqlite
45 79 79/04_mitigate_stream_ordering_update_race.py
46 79 79/05_read_write_locks_triggers.sql.sqlite
47 80 80/01_users_alter_locked.sql
48 80 80/02_scheduled_tasks.sql
49 82 82/02_scheduled_tasks_index.sql
50 82 82/04_add_indices_for_purging_rooms.sql
51 82 82/05gaps.sql
52 83 83/01_drop_old_tables.sql
53 83 83/03_instance_name_receipts.sql.sqlite
54 83 83/05_cross_signing_key_update_grant.sql
55 83 83/06_event_push_summary_room.sql
56 84 84/02_auth_links_index.sql
57 84 84/04_access_token_index.sql
58 85 85/01_add_suspended.sql
59 85 85/02_add_instance_names.sql
60 85 85/04_cleanup_device_federation_outbox.sql
61 85 85/05_add_instance_names_converted_pos.sql
62 85 85/06_add_room_reports.sql
63 86 86/01_authenticate_media.sql
64 86 86/02_receipts_event_id_index.sql
65 87 87/01_sliding_sync_memberships.sql
66 87 87/02_per_connection_state.sql
67 87 87/03_current_state_index.sql
68 88 88/01_add_delayed_events.sql
69 88 88/01_custom_profile_fields.sql
70 88 88/02_fix_sliding_sync_membership_snapshots_forgotten_column.sql
71 88 88/03_add_otk_ts_added_index.sql
72 88 88/04_current_state_delta_index.sql
73 88 88/05_drop_old_otks.sql.sqlite
74 88 88/05_sliding_sync_room_config_index.sql
75 88 88/06_events_received_ts_index.sql
76 89 89/01_sliding_sync_membership_snapshot_index.sql
77 89 89/01_state_groups_deletion.sql
78 90 90/01_add_column_participant_room_memberships_table.sql
79 90 90/02_delete_unreferenced_state_groups.sql
80 90 90/03_remove_old_deletion_bg_update.sql
81 91 91/01_media_hash.sql
82 92 92/01_remove_trigger.sql.sqlite
83 92 92/02_remove_populate_participant_bg_update.sql
84 92 92/04_ss_membership_snapshot_idx.sql
85 92 92/04_thread_subscriptions.sql
86 92 92/05_fixup_max_depth_cap.sql
87 92 92/06_device_federation_inbox_index.sql
88 92 92/07_add_user_reports.sql
89 92 92/07_event_txn_id_device_id_txn_id2.sql
90 92 92/08_room_ban_redactions.sql
91 92 92/09_thread_subscriptions_update.sql
92 93 93/01_add_delayed_events.sql
93 93 93/01_sticky_events.sql
94 93 93/02_sliding_sync_members.sql
95 93 93/03_sss_pos_last_used.sql
96 93 93/04_make_delayed_event_content_text.py
97 94 94/01_redactions_recheck.sql
98 94 94/02_redactions_recheck_bg_update.sql
99 94 94/03_device_lists_room_timestamp.sql
100 94 94/03_quarantined_media_tracking.sql
101 94 94/03_state_dag_fwd_extrems.sql