summary refs log tree commit diff
path: root/synapse/storage/schema/main (follow)
Commit message (Expand)AuthorAgeFilesLines
* Revert "Add `event_stream_ordering` column to membership state tables (#14979)"David Robertson2023-02-071-21/+0
* Add `event_stream_ordering` column to membership state tables (#14979)Nick Mills-Barrett2023-02-071-0/+21
* Drop unused table `presence` (#14825)Dirk Klimpel2023-01-131-0/+17
* Add index to improve performance of the `/timestamp_to_event` endpoint used f...reivilibre2023-01-111-0/+17
* Faster remote room joins: stream the un-partial-stating of events over replic...reivilibre2022-12-142-0/+54
* Delete event_push_summary_unique_index again. (#14669)Patrick Cloke2022-12-141-0/+33
* Rebuild the user directory and stats tables. (#14643)Patrick Cloke2022-12-081-0/+29
* Faster remote room joins: stream the un-partial-stating of rooms over replica...reivilibre2022-12-052-0/+52
* Add another index to `device_lists_changes_in_room` (#14534)Erik Johnston2022-11-231-0/+20
* Track unconverted device list outbound pokes using a position instead (#14516)Sean Quah2022-11-221-0/+53
* Fix PostgreSQL sometimes using table scans for `event_search` (#14409)Sean Quah2022-11-101-0/+33
* Save login tokens in database (#13844)Quentin Gliech2022-10-261-0/+35
* Unified search query syntax using the full-text search capabilities of the un...James Salter2022-10-251-0/+62
* Update the thread_id right before use (in case the bg update hasn't finished)...Patrick Cloke2022-10-183-134/+8
* When restarting a partial join resync, prioritise the server which actioned a...David Robertson2022-10-181-0/+18
* Add an API for listing threads in a room. (#13394)Patrick Cloke2022-10-131-0/+30
* Mark events as read using threaded read receipts from MSC3771. (#13877)Patrick Cloke2022-10-042-0/+99
* Track notification counts per thread (implement MSC3773). (#13776)Patrick Cloke2022-10-043-0/+149
* Clear out old rows from `event_push_actions_staging` (#14020)Erik Johnston2022-10-032-0/+46
* Allow admins to require a manual approval process before new accounts can be ...Brendan Abolivier2022-09-291-0/+20
* Handle remote device list updates during partial join (#13913)Erik Johnston2022-09-281-0/+28
* Add new columns tracking when we partial-joined (#13892)David Robertson2022-09-271-0/+23
* Snapshot schema 72 (#13873)David Robertson2022-09-262-0/+1990
* Track device IDs for pushers (#13831)Brendan Abolivier2022-09-211-0/+20
* Support enabling/disabling pushers (from MSC3881) (#13799)Brendan Abolivier2022-09-211-0/+16
* Add support to purge rows from MSC2716 and other tables when purging a room (...Eric Eastwood2022-09-161-0/+22
* Keep track when we try and fail to process a pulled event (#13589)Eric Eastwood2022-09-141-0/+29
* Update event push action and receipt tables to support threads. (#13753)Patrick Cloke2022-09-144-0/+150
* Use partial indices on SQLIte. (#13802)Patrick Cloke2022-09-141-0/+56
* Make sequence `cache_invalidation_stream_seq` begin at `2` (#13766)Mathieu Velten2022-09-131-0/+23
* Add receipts event stream ordering (#13703)Nick Mills-Barrett2022-09-131-0/+19
* Remove check current state membership up to date (#13745)Nick Mills-Barrett2022-09-121-0/+52
* Add timestamp to user's consent (#13741)Dirk Klimpel2022-09-081-0/+16
* Add a schema delta to drop unstable private read receipts. (#13692)Patrick Cloke2022-09-011-0/+19
* Drop unused column `application_services_state.last_txn` (#13627)Shay2022-08-302-0/+57
* Bg update to populate new `events` table columns (#13215)Richard van der Hoff2022-07-151-0/+47
* Drop unused tables from groups/communities. (#12967)Patrick Cloke2022-07-131-0/+31
* Drop unused table `event_reference_hashes` (#13218)Richard van der Hoff2022-07-121-0/+17
* Merge remote-tracking branch 'origin/release-v1.62' into developPatrick Cloke2022-06-301-0/+19
|\
| * Add index to help delete old push actions (#13141)Erik Johnston2022-06-301-0/+19
* | Implement MSC3827: Filtering of `/publicRooms` by room type (#13031)Šimon Brandner2022-06-291-0/+19
|/
* Fix serialization errors when rotating notifications (#13118)Erik Johnston2022-06-281-0/+35
* Speed up `get_unread_event_push_actions_by_room` (#13005)Erik Johnston2022-06-152-3/+22
* Clean up schema for `event_edges` (#12893)Richard van der Hoff2022-06-152-0/+90
* Rename delta to apply in the proper schema version. (#13050)Patrick Cloke2022-06-141-0/+0
* Replace noop background updates with DELETE. (#12954)Patrick Cloke2022-06-131-0/+61
* Add a migration step to cleanup potential leftovers of bug 11833 (#12784)Mathieu Velten2022-05-301-0/+19
* Add index to cache invalidations (#12747)Erik Johnston2022-05-171-0/+18
* Track device list updates per room. (#12321)Erik Johnston2022-04-041-0/+38
* Use a sequence to generate AS transaction IDs, drop `last_txn` AS state (#12209)Nick Mills-Barrett2022-04-011-0/+44
* Send device list updates to application services (MSC3202) - part 1 (#11881)Andrew Morgan2022-03-301-0/+23
* Remove unnecessary pass statements. (#12206)Patrick Cloke2022-03-111-1/+0
* Faster joins: persist to database (#12012)Richard van der Hoff2022-03-012-0/+113
* Fix non-strings in the `event_search` table (#12037)Sean Quah2022-02-241-0/+22
* Fix slow performance of `/logout` in some cases where refresh tokens are in u...reivilibre2022-02-221-0/+28
* Add a background database update to purge account data for deactivated users....reivilibre2022-02-021-0/+20
* Send to-device messages to application services (#11215)Andrew Morgan2022-02-011-0/+21
* Add `state_key` and `rejection_reason` to `events` (#11792)Richard van der Hoff2022-01-211-0/+26
* Drop unused table `public_room_list_stream`. (#11795)Richard van der Hoff2022-01-211-0/+18
* Save the OIDC session ID (sid) with the device on login (#11482)Quentin Gliech2021-12-061-0/+27
* Support expiry of refresh tokens and expiry of the overall session when refre...reivilibre2021-11-261-0/+28
* Improve performance of `remove_{hidden,deleted}_devices_from_device_inbox` (#...Brendan Abolivier2021-11-251-0/+18
* Store arbitrary relations from events. (#11391)Patrick Cloke2021-11-221-1/+1
* Merge tag 'v1.47.0rc3' into developDavid Robertson2021-11-161-1/+13
|\
| * Rename `remove_deleted_devices_from_device_inbox` to ensure it is always run ...Andrew Morgan2021-11-161-1/+13
| * Move sql file for `remove_deleted_devices_from_device_inbox` into v65 (#11303)Dirk Klimpel2021-11-151-1/+1
* | Remove unused tables `room_stats_historical` and `user_stats_historical` (#11...Shay2021-11-121-0/+19
* | Move sql file for `remove_deleted_devices_from_device_inbox` into v65 (#11303)Dirk Klimpel2021-11-111-1/+1
|/
* Add index to `local_group_updates.stream_id` (#11231)Erik Johnston2021-11-021-0/+18
* Delete messages for hidden devices from `device_inbox` (#11199)Dirk Klimpel2021-11-021-0/+22
* Fix comments referencing v1.46.0 from PR #10969. (#11212)Dirk Klimpel2021-10-291-1/+1
* Delete messages from `device_inbox` table when deleting device (#10969)Dirk Klimpel2021-10-271-0/+22
* Add a background update for updating MSC3440 relation threads. (#11181)Patrick Cloke2021-10-261-0/+18
* Resolve and share `state_groups` for all historical events in batch (MSC2716)...Eric Eastwood2021-10-131-0/+19
* Use direct references for some configuration variables (part 3) (#10885)Patrick Cloke2021-09-231-1/+1
* Rename MSC2716 things from `chunk` to `batch` to match `/batch_send` endpoint...Eric Eastwood2021-09-212-0/+60
* Use direct references for some configuration variables (#10798)Patrick Cloke2021-09-132-2/+2
* Add a partial index to `presence_stream` to speed up startups (#10748)Sean2021-09-031-0/+18
* Populate `rooms.creator` field for easy lookup (#10697)Eric Eastwood2021-09-011-0/+17
* Move the sessions delta to the latest schema version. (#10725)Patrick Cloke2021-08-311-0/+0
* Remove pushers when deleting 3pid from account (#10581)Azrenbeth2021-08-261-0/+20
* Persist room hierarchy pagination sessions to the database. (#10613)Patrick Cloke2021-08-241-0/+23
* Implement MSC3231: Token authenticated registration (#10142)Callum Brown2021-08-211-0/+23
* Add support for MSC2716 marker events (#10498)Eric Eastwood2021-08-041-0/+24
* Make historical events discoverable from backfill for servers without any scr...Eric Eastwood2021-07-281-0/+49
* Replace `room_depth.min_depth` with a BIGINT (#10289)Richard van der Hoff2021-07-122-0/+88
* Switch `application_services_txns.txn_id` to BIGINT (#10349)Richard van der Hoff2021-07-091-0/+23
* fix ordering of bg update (#10291)Richard van der Hoff2021-07-011-1/+1
* Change more stream_ordering columns to BIGINT (#10286)Richard van der Hoff2021-06-301-0/+30
* Rebuild other indexes using `stream_ordering` (#10282)Richard van der Hoff2021-06-301-3/+8
* Merge branch 'release-v1.37' into developRichard van der Hoff2021-06-292-0/+69
|\
| * Handle inbound events from federation asynchronously (#10272)Erik Johnston2021-06-291-0/+32
| * Add a distributed lock (#10269)Erik Johnston2021-06-291-0/+37
* | Migrate stream_ordering to a bigint (#10264)Richard van der Hoff2021-06-291-0/+40
* | MSC2918 Refresh tokens implementation (#9450)Quentin Gliech2021-06-241-0/+34
|/
* Fix schema delta to not take as long on large servers (#10227)Erik Johnston2021-06-221-2/+5
* Implement knock feature (#6739)Sorunome2021-06-091-0/+17
* Use a database table to hold the users that should have full presence sent to...Andrew Morgan2021-05-181-0/+34
* Reorganise the database schema directories (#9932)Richard van der Hoff2021-05-07263-0/+10006