applied_schema_deltas

106 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: version

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE applied_schema_deltas(
    version INTEGER NOT NULL,
    file TEXT NOT NULL,
    UNIQUE(version, file)
);