summary refs log tree commit diff
path: root/synapse/storage/schema (follow)
Commit message (Expand)AuthorAgeFilesLines
* 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-212-3/+31
* Drop unused table `public_room_list_stream`. (#11795)Richard van der Hoff2022-01-212-1/+21
* Stop reading from `event_reference_hashes` (#11794)Richard van der Hoff2022-01-211-1/+4
* Stop populating `state_events.prev_state` (#11558)Richard van der Hoff2021-12-101-1/+4
* Save the OIDC session ID (sid) with the device on login (#11482)Quentin Gliech2021-12-061-0/+27
* Disambiguate queries on `state_key` (#11497)Richard van der Hoff2021-12-021-1/+5
* 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-122-1/+23
* | 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-132-1/+24
* Drop backwards-compatibility support for "outlier" (#10903)Richard van der Hoff2021-09-281-4/+2
* Document changes to schema version 61 - 64 (#10917)Eric Eastwood2021-09-241-0/+11
* 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-213-1/+61
* 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
* Make a note to leave a summary when one is bumping the schema version (#10621)Andrew Morgan2021-08-251-0/+2
* 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
* Remove the unused public_room_list_stream (#10565)Andrew Morgan2021-08-171-1/+6
* update links to schema doc (#10620)Richard van der Hoff2021-08-172-3/+3
* Add support for MSC2716 marker events (#10498)Eric Eastwood2021-08-042-1/+25
* Make historical events discoverable from backfill for servers without any scr...Eric Eastwood2021-07-281-0/+49
* Reduce likelihood of Postgres table scanning `state_groups_state`. (#10359)Erik Johnston2021-07-151-0/+34
* 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
* Remove functionality associated with unused historical stats tables (#9721)Cristina2021-07-081-1/+5
* 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-292-1/+41
* | 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
* Support for database schema version ranges (#9933)Richard van der Hoff2021-06-113-37/+26
* 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-07280-0/+10293
* Only run one background update at a timeRichard van der Hoff2020-03-311-0/+19
* Move schema delta files to the correct data store.Erik Johnston2019-10-242-73/+0
* Merge branch 'develop' of github.com:matrix-org/synapse into erikj/refactor_s...Erik Johnston2019-10-222-0/+73
|\
| * Merge branch 'develop' into uhoreg/e2e_cross-signing_mergedHubert Chathi2019-10-189-0/+221
| |\
| * \ Merge branch 'develop' into cross-signing_keysHubert Chathi2019-09-041-0/+152
| |\ \
| * \ \ Merge branch 'uhoreg/e2e_cross-signing_merged' into cross-signing_keysHubert Chathi2019-08-284-0/+75
| |\ \ \
| | * \ \ Merge branch 'develop' into uhoreg/e2e_cross-signing_mergedHubert Chathi2019-08-284-0/+75
| | |\ \ \
| | * | | | Cross-signing [1/4] -- hidden devices (#5759)Hubert Chathi2019-08-121-0/+18
| * | | | | use stream ID generator instead of timestampHubert Chathi2019-08-281-3/+3
| * | | | | make changes from PR reviewHubert Chathi2019-08-012-41/+55
| * | | | | Merge branch 'cross-signing_hidden' into cross-signing_keysHubert Chathi2019-08-013-3/+42
| |\ \ \ \ \
| | * | | | | Merge branch 'develop' into cross-signing_hiddenHubert Chathi2019-07-303-3/+42
| | |\| | | |
| * | | | | | Merge branch 'cross-signing_hidden' into cross-signing_keysHubert Chathi2019-07-301-1/+1
| |\| | | | |
| | * | | | | apply changes from PR reviewHubert Chathi2019-07-301-1/+1
| * | | | | | allow uploading keys for cross-signingHubert Chathi2019-07-251-0/+41
| |/ / / / /
| * | | | | allow devices to be marked as "hidden"Hubert Chathi2019-07-241-0/+18
* | | | | | Move storage classes into a main "data store".Erik Johnston2019-10-21189-8109/+10
| |_|_|_|/ |/| | | |
* | | | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/disable_sq...Erik Johnston2019-10-103-0/+88
|\ \ \ \ \
| * | | | | Rewrite the user_filter migration again (#6184)Richard van der Hoff2019-10-101-26/+32
| * | | | | Merge pull request #6185 from matrix-org/erikj/fix_censored_evnetsErik Johnston2019-10-091-0/+26
| |\ \ \ \ \
| * | | | | | Fix unique_user_filter_index schema updateBrendan Abolivier2019-10-071-2/+2
| * | | | | | Update `user_filters` table to have a unique index, and non-null columns (#1172)Alexander Maznev2019-10-041-0/+46
| * | | | | | Land improved room list based on room stats (#6019)Erik Johnston2019-10-021-0/+16
| * | | | | | Merge branch 'release-v1.4.0' of github.com:matrix-org/synapse into developErik Johnston2019-10-022-0/+38
| |\ \ \ \ \ \
| * | | | | | | Drop unused tables (#6115)Richard van der Hoff2019-09-301-0/+20
* | | | | | | | Do the update as a background indexErik Johnston2019-10-091-9/+8
| |_|/ / / / / |/| | | | | |
* | | | | | | Fix existing hex encoded json values in DBErik Johnston2019-10-081-0/+26
| |/ / / / / |/| | | | |
* | | | | | Fix errors storing large retry intervals.Erik Johnston2019-10-021-0/+18
* | | | | | Add received_ts column to redactions.Erik Johnston2019-10-011-0/+20
|/ / / / /
* | | | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/cleanup_us...Erik Johnston2019-09-251-0/+24
|\ \ \ \ \
| * \ \ \ \ Merge remote-tracking branch 'origin/develop' into rav/saml_mapping_workRichard van der Hoff2019-09-241-20/+0
| |\ \ \ \ \
| * \ \ \ \ \ Merge branch 'develop' into rav/saml_mapping_workRichard van der Hoff2019-09-197-0/+269
| |\ \ \ \ \ \
| * | | | | | | Record mappings from saml users in an external tableRichard van der Hoff2019-09-131-0/+24
| | |_|_|/ / / | |/| | | | |
* | | | | | | Add BG update to populate devices last seen infoErik Johnston2019-09-231-0/+3
* | | | | | | Add last seen info to devices table.Erik Johnston2019-09-231-0/+21
| |_|/ / / / |/| | | | |
* | | | | | Undo the deletion of some tables (#6047)Richard van der Hoff2019-09-191-20/+0
| |/ / / / |/| | | |
* | | | | Add 'failure_ts' column to 'destinations' table (#6016)Richard van der Hoff2019-09-171-0/+25
* | | | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/censor_red...Erik Johnston2019-09-051-0/+152
|\ \ \ \ \ | | |_|_|/ | |/| | |
| * | | | Fix and refactor room and user stats (#5971)Erik Johnston2019-09-041-0/+152
| | |_|/ | |/| |
* / | | Censor redactions in DB after a monthErik Johnston2019-08-301-0/+17
|/ / /
* | | Propagate opentracing contexts through EDUs (#5852)Jorik Schellekens2019-08-221-0/+20
* | | Add missing index on users_in_public_rooms. (#5894)Richard van der Hoff2019-08-221-0/+17
* | | Drop some unused tables. (#5893)Richard van der Hoff2019-08-211-0/+20
* | | add the version field to the index for e2e_room_keysHubert Chathi2019-08-141-0/+18
|/ /
* | Don't recreate columnErik Johnston2019-07-302-1/+22
* | Fix current_state_events membership background update.Erik Johnston2019-07-301-0/+0
* | Remove lost commentErik Johnston2019-07-291-7/+0
* | Add function to get all forgotten rooms for userErik Johnston2019-07-241-0/+25
|/
* Update comment for new columnErik Johnston2019-07-191-0/+3
* Add background update for current_state_events.membership columnErik Johnston2019-07-181-0/+3
* Add membership column to current_state_events table.Erik Johnston2019-07-181-0/+19
* Implement access token expiry (#5660)Richard van der Hoff2019-07-121-0/+18
* Run Black. (#5482)Amber Brown2019-06-207-38/+58
* Track deactivated accounts in the database (#5378)Brendan Abolivier2019-06-141-0/+19
* Merge pull request #5320 from matrix-org/hawkowl/full-schema-v1Erik Johnston2019-06-064-0/+2338
|\
| * fix maybeAmber H. Brown2019-06-071-20/+2
| * just user dir?Amber H. Brown2019-06-071-1/+19
| * remove background updates that arent neededAmber H. Brown2019-06-071-33/+1
| * add more commentsAmber Brown2019-06-061-0/+5
| * add stuff in bg updatesAmber Brown2019-06-041-10/+62
| * WHY IS THIS CALLED A SLIGHTLY DIFFERENT THINGAmber Brown2019-06-031-0/+1
| * more fixAmber Brown2019-06-031-0/+38
| * fix schemasAmber Brown2019-06-033-59/+18
| * full schemaAmber Brown2019-06-033-0/+2315
* | Add ability to perform password reset via email without trusting the identity...Andrew Morgan2019-06-061-0/+31
|/
* Merge pull request #5294 from matrix-org/erikj/speed_up_room_statsErik Johnston2019-05-311-0/+28
|\
| * Add indices. Remove room_ids accidentally addedErik Johnston2019-05-311-0/+28
* | Add index to temp tableErik Johnston2019-05-301-0/+1
|/
* Fixup comments and loggingErik Johnston2019-05-301-0/+3
* Add DB bg update to cleanup extremities.Erik Johnston2019-05-291-0/+19
* Merge pull request #5268 from matrix-org/babolivier/account_validity_fix_schemaBrendan Abolivier2019-05-281-0/+3
|\
| * Fix schema update for account validityBrendan Abolivier2019-05-281-0/+3
* | Store key validity time in the storage layerRichard van der Hoff2019-05-231-0/+23
* | Room Statistics (#4338)Amber Brown2019-05-211-0/+80
* | Add simple send_relation API and track in DBErik Johnston2019-05-151-0/+27
|/
* Merge pull request #5047 from matrix-org/babolivier/account_expirationBrendan Abolivier2019-04-171-1/+8
|\
| * Send out emails with links to extend an account's validity periodBrendan Abolivier2019-04-171-1/+8
* | Merge pull request #5033 from matrix-org/erikj/fix_schema_deltaErik Johnston2019-04-101-1/+3
|\ \
| * | Fix schema upgrade when dropping tablesErik Johnston2019-04-091-1/+3
* | | Merge pull request #5027 from matrix-org/babolivier/account_expirationBrendan Abolivier2019-04-091-0/+20
|\ \ \ | |/ / |/| / | |/
| * Add account expiration featureBrendan Abolivier2019-04-091-0/+20
* | Remove unused server_tls_certificates functions (#5028)Richard van der Hoff2019-04-082-11/+4
* | drop tables listed in #1830 (#4992)Neil Johnson2019-04-0823-740/+42
* | Remove presence lists (#4989)Neil Johnson2019-04-032-10/+18
* | Fixup docstringsErik Johnston2019-04-021-2/+2
* | Grandfather in existing user threepidsErik Johnston2019-04-011-0/+2
* | Track IS used to bind 3PIDsErik Johnston2019-04-011-0/+27
|/
* Fix user directory background update (#4887)Erik Johnston2019-03-191-1/+1
* Migrate the user directory initial population to a background task (#4864)Amber Brown2019-03-191-0/+30
* fixupAmber Brown2019-03-131-7/+0
* fixupAmber Brown2019-03-121-5/+12
* Merge remote-tracking branch 'origin/develop' into hawkowl/userdir-searchAmber Brown2019-03-111-0/+2
|\
| * Add comment to schemaErik Johnston2019-03-081-0/+2
* | initialAmber Brown2019-03-112-3/+28
|/
* Rewrite userdir to be faster (#4537)Amber Brown2019-03-071-0/+47
* Analyze user_ips before running deduplicationErik Johnston2019-02-121-3/+7
* Add support for persisting event format versionsErik Johnston2019-01-231-0/+16
* Remove duplicates in the user_ips table and add an index (#4370)Amber Brown2019-01-121-0/+26
* create support user (#4141)Neil Johnson2018-12-141-0/+19
* Drop sent_transactionsAaron Raimist2018-12-014-72/+2
* Merge remote-tracking branch 'origin/develop' into dbkr/e2e_backup_versions_a...David Baker2018-11-093-4/+60
|\
| * Add unique indexes to a couple of tablesRichard van der Hoff2018-11-022-4/+41
| * Merge branch 'develop' of github.com:matrix-org/synapse into erikj/purge_stat...Erik Johnston2018-10-191-0/+39
| |\
| * | Add state_group index to event_to_state_groupsErik Johnston2018-10-041-0/+19
* | | Try & make it work on postgresDavid Baker2018-10-301-2/+2
* | | Make e2e backup versions numeric in the DBDavid Baker2018-10-291-0/+53
| |/ |/|
* | Don't reuse backup versionsDavid Baker2018-10-051-1/+2
* | WIP e2e key backupsDavid Baker2018-09-131-0/+0
* | Merge branch 'develop' into e2e_backupsHubert Chathi2018-08-241-0/+27
|\|
| * typosNeil Johnson2018-08-081-1/+1
| * make use of _simple_select_one_onecol, improved commentsNeil Johnson2018-08-061-0/+4
| * Revert "change monthly_active_users table to be a single column"Neil Johnson2018-08-021-1/+3
| * change monthly_active_users table to be a single columnNeil Johnson2018-08-011-3/+1
| * fix commentNeil Johnson2018-08-011-1/+1
| * api into monthly_active_users tableNeil Johnson2018-07-312-1/+24
* | fix idiocies and so make tests passMatthew Hodgson2018-08-121-1/+1
* | blindly incorporate PR review - needs testing & fixingMatthew Hodgson2018-08-121-5/+3
* | make /room_keys/version workMatthew Hodgson2018-08-121-2/+2
* | implement /room_keys/version too (untested)Matthew Hodgson2018-08-121-1/+1
* | make it work and fix pep8Matthew Hodgson2018-08-121-1/+1
* | total WIP skeleton for /room_keys APIMatthew Hodgson2018-08-121-0/+40
* | coding styleNeil Johnson2018-07-311-1/+1
|/
* Create the column nullableRichard van der Hoff2018-07-262-9/+13
* Stop populating events.contentRichard van der Hoff2018-07-261-0/+93
* comment on event_edgesRichard van der Hoff2018-07-261-1/+2
* run isortAmber Brown2018-07-0911-23/+24
* Revert "Revert "Merge pull request #3431 from matrix-org/rav/erasure_visibili...Erik Johnston2018-06-251-0/+21
* Revert "Merge pull request #3431 from matrix-org/rav/erasure_visibility"Richard van der Hoff2018-06-221-21/+0
* UserErasureStoreRichard van der Hoff2018-06-121-0/+21
* remove unnecessary INSERTNeil Johnson2018-06-011-1/+0
* create users index on creation_tsNeil Johnson2018-05-291-0/+20
* Send users a server notice about consentRichard van der Hoff2018-05-221-0/+20
* Merge pull request #3163 from matrix-org/cohort_analyticsNeil Johnson2018-05-162-0/+38
|\
| * Merge branch 'develop' of https://github.com/matrix-org/synapse into cohort_a...Neil Johnson2018-05-142-1/+60
| |\
| * | add inidexes based on usageNeil Johnson2018-05-011-6/+2
| * | Generate user daily statsNeil Johnson2018-04-252-0/+42
* | | Merge pull request #3213 from matrix-org/rav/consent_handlerRichard van der Hoff2018-05-161-0/+18
|\ \ \
| * | | ConsentResource to gather policy consent from usersRichard van der Hoff2018-05-151-0/+18
| | |/ | |/|
* / | Add the schema fileDavid Baker2018-05-091-0/+25
|/ /
* | Merge pull request #3129 from matrix-org/matthew/fix_group_dupsMatthew Hodgson2018-04-301-0/+57
|\ \
| * | fix missing importMatthew Hodgson2018-04-281-0/+1
| * | pep8Matthew Hodgson2018-04-281-3/+5
| * | make it work with sqliteMatthew Hodgson2018-04-282-34/+54
| * | remove duplicates from groups tablesMatthew Hodgson2018-04-251-0/+34
| |/
* / Move more xrange to sixAdrian Tschira2018-04-281-1/+3
|/
* Merge pull request #3045 from matrix-org/dbkr/group_joinableLuke Barnard2018-04-051-0/+22
|\
| * NON NULL -> NOT NULLLuke Barnard2018-04-051-1/+1
| * Use DEFAULT join_policy of "invite" in dbLuke Barnard2018-04-051-1/+1
| * Use join_policy API instead of joinableLuke Barnard2018-04-031-1/+7
| * OK, smallint it is thenDavid Baker2018-03-281-1/+1
| * Grr. Copy the definition from is_adminDavid Baker2018-03-281-1/+1
| * Make column definition that works on both dbsDavid Baker2018-03-281-1/+1
| * Add schema delta fileDavid Baker2018-03-281-0/+16
* | Merge pull request #3041 from matrix-org/r30_statsNeil Johnson2018-04-051-0/+17
|\ \
| * | Add user_ips last seen indexNeil Johnson2018-03-281-0/+17
| |/
* / Use simplejson throughoutRichard van der Hoff2018-03-291-1/+2
|/
* Merge branch 'master' of github.com:matrix-org/synapse into developErik Johnston2018-03-194-8/+8
|\
| * Replace ujson with simplejsonErik Johnston2018-03-154-7/+7
* | CommentsErik Johnston2018-02-161-0/+4
* | Store push actions in staging areaErik Johnston2018-02-151-0/+24
* | Merge branch 'matthew/gin_work_mem' into matthew/hit_the_ginRichard van der Hoff2018-02-132-0/+53
|\ \
| * | Store state groups separately from events (#2784)Erik Johnston2018-02-061-0/+37
| * | Remove lost commentErik Johnston2018-01-171-3/+0
| * | Keep track of last access time for local mediaErik Johnston2018-01-171-0/+19
| |/
* | move search reindex to schema 47Richard van der Hoff2018-02-132-1/+1
* | fix GIST->GIN switchMatthew Hodgson2018-01-092-2/+21
|/
* Merge branch 'develop' into matthew/search-all-local-usersMatthew Hodgson2017-11-302-1/+28
|\
| * Fix error on sqlite 3.7Richard van der Hoff2017-11-212-1/+28
* | remove null constraint on user_dir.room_idMatthew Hodgson2017-11-301-0/+35
|/
* Avoid locking for upsert on pushers tablesRichard van der Hoff2017-11-161-0/+35
* create new indexes before dropping old ones to keep safetynet in placeMatthew Hodgson2017-11-071-2/+4
* s/users_in_pubic_room/users_in_public_rooms/gMatthew Hodgson2017-11-041-2/+2
* s/users_in_pubic_room/users_in_public_rooms/gMatthew Hodgson2017-11-041-0/+22
* fix copyright....Matthew Hodgson2017-11-041-1/+1
* s/popualte/populate/Matthew Hodgson2017-11-041-1/+1
* Remove the last vestiges of refresh_tokensRichard van der Hoff2017-10-313-40/+3
* DB schema interface for password auth providersRichard van der Hoff2017-10-311-0/+7
* Recreate groups table instead of adding columnLuke Barnard2017-10-261-2/+16
* Awful hack to get default trueLuke Barnard2017-10-261-1/+2
* Add is_public to groups table to allow for private groupsLuke Barnard2017-10-261-0/+17
* replace 'except:' with 'except Exception:'Richard van der Hoff2017-10-231-1/+1
* Fix schema delta versionsErik Johnston2017-10-112-0/+0
* Merge branch 'develop' into erikj/groups_mergedDavid Baker2017-10-021-0/+38
|\
| * Add old indicesErik Johnston2017-09-281-0/+2
| * Change expires column to expires_tsErik Johnston2017-09-281-1/+20
| * More bracketsErik Johnston2017-09-281-1/+1
| * Delete expired url cache dataErik Johnston2017-09-281-0/+17
* | Add unique index to group_rooms tableErik Johnston2017-09-261-1/+1
* | Add remote profile cacheErik Johnston2017-08-251-0/+28
* | Use BOOLEAN rather than TEXT typeErik Johnston2017-08-211-1/+1
* | Store whether the user wants to publicise their membership of a groupErik Johnston2017-08-081-0/+1
* | Add groups to sync streamErik Johnston2017-07-201-0/+9