summary refs log tree commit diff
path: root/synapse/storage/schema/delta (follow)
Commit message (Expand)AuthorAgeFilesLines
* Implement per-room message retention policiesBrendan Abolivier2019-08-281-0/+33
* Track deactivated accounts in the database (#5378)Brendan Abolivier2019-06-141-0/+19
* Create the index in a background updateBrendan Abolivier2019-06-131-1/+2
* Merge branch 'dinsic' into babolivier/fix_profile_replicationBrendan Abolivier2019-06-126-0/+212
|\
| * Merge branch 'master' into dinsicBrendan Abolivier2019-06-124-0/+162
| |\
| | * 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
| | |\
| | * | Store key validity time in the storage layerRichard van der Hoff2019-05-231-0/+23
| | * | Room Statistics (#4338)Amber Brown2019-05-211-0/+80
| * | | Merge branch 'master' into dinsicBrendan Abolivier2019-06-112-0/+50
| |\ \ \
| | * | | 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-301-0/+19
| | |/ /
| | * | Add simple send_relation API and track in DBErik Johnston2019-05-151-0/+27
* | | | Move schema update to 54 and add a warning commentBrendan Abolivier2019-06-101-0/+0
* | | | New lineBrendan Abolivier2019-06-101-1/+1
* | | | Add unique index to the profile_replication_status table.Brendan Abolivier2019-06-101-0/+16
|/ / /
* | | Merge branch 'babolivier/account_validity_fix_schema' into dinsicBrendan Abolivier2019-05-281-0/+3
|\ \ \ | | |/ | |/|
| * | Fix schema update for account validityBrendan Abolivier2019-05-281-0/+3
| |/
* | Merge branch 'release-v0.99.4' into dinsic dinsic_2019-05-14Brendan Abolivier2019-05-141-1/+8
|\|
| * 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 branch 'develop' into dinsicAndrew Morgan2019-04-1510-85/+105
|\| |
| * | 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-081-3/+1
| * | drop tables listed in #1830 (#4992)Neil Johnson2019-04-087-85/+40
| * | Remove presence lists (#4989)Neil Johnson2019-04-031-0/+16
| * | 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
| |/
* | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/dinsic-mergedErik Johnston2019-03-213-0/+102
|\|
| * 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
| * initialAmber Brown2019-03-112-3/+28
| * Rewrite userdir to be faster (#4537)Amber Brown2019-03-071-0/+47
* | Merge branch 'master' of github.com:matrix-org/synapse into erikj/dinsic-merg...Erik Johnston2019-03-159-38/+180
|\|
| * 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-012-34/+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
| | |/ | |/|
* | | merge master into dinsic, again...Matthew Hodgson2018-11-031-0/+39
|\| |
| * | 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
| |\|
| * | 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
* | | merge in masterMatthew Hodgson2018-10-222-0/+119
|\ \ \ | | |/ | |/|
| * | 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
| |/
| * Create the column nullableRichard van der Hoff2018-07-261-8/+7
| * Stop populating events.contentRichard van der Hoff2018-07-261-0/+93
* | Merge remote-tracking branch 'origin/master' into dinsicDavid Baker2018-07-1911-23/+24
|\|
| * run isortAmber Brown2018-07-0911-23/+24
* | Change column def so it works on pgsql & sqliteDavid Baker2018-07-191-1/+1
* | Remove deactivated users from profile searchDavid Baker2018-07-181-0/+23
* | Merge remote-tracking branch 'origin/master' into dinsicDavid Baker2018-07-171-0/+21
|\|
| * 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
* | Merge tag 'v0.31.2' into dinsicMichael Kaye2018-06-228-1/+180
|\|
| * 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
| |/
* | PR feedbackDavid Baker2018-04-251-0/+13
* | Merge remote-tracking branch 'origin/dinsic' into dbkr/profile_replicationDavid Baker2018-04-167-9/+49
|\|
| * 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
* | | Written but untested profile replicationDavid Baker2018-04-101-0/+23
|/ /
* | 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
* 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
* | Remove sync stuffErik Johnston2017-07-181-9/+1
* | Remove unused tablesErik Johnston2017-07-181-7/+0
* | Add local group server supportErik Johnston2017-07-171-0/+28
* | CommentsErik Johnston2017-07-121-5/+12
* | Add group summary APIsErik Johnston2017-07-121-0/+56
* | CommentErik Johnston2017-07-121-1/+1
* | Move commentErik Johnston2017-07-111-2/+2
* | Rename column to attestation_jsonErik Johnston2017-07-111-1/+1
* | CommentsErik Johnston2017-07-111-2/+2
* | CommentsErik Johnston2017-07-111-1/+5
* | Initial group server implementationErik Johnston2017-07-101-0/+77
|/
* Fix up indices for users_who_share_roomsErik Johnston2017-06-261-1/+2
* Store URL cache preview downloads seperatelyErik Johnston2017-06-231-0/+16
* Add API to quarantine mediaErik Johnston2017-06-191-0/+17
* Add shutdown room APIErik Johnston2017-06-191-0/+21
* Add DB schema for tracking users who share roomsErik Johnston2017-06-151-0/+32
* Split up device_lists_outbound_pokes table for faster updates.Erik Johnston2017-06-071-0/+33
* Split the table in twoErik Johnston2017-06-011-1/+9
* Use unique indicesErik Johnston2017-05-311-2/+2
* Split out directory and search tablesErik Johnston2017-05-311-11/+14
* Handle the server leaving a public roomErik Johnston2017-05-311-0/+4
* Add commentsErik Johnston2017-05-311-1/+1
* Add user_directory to databaseErik Johnston2017-05-311-0/+69
* Add commentErik Johnston2017-05-301-1/+1
* Add clobbered event_idErik Johnston2017-05-301-1/+2
* Add current_state_delta_stream tableErik Johnston2017-05-301-0/+25
* Add background task to clear out old event_authErik Johnston2017-05-241-0/+17
* Add a comment to old deltaRichard van der Hoff2017-05-111-0/+4
* Add an index to event_searchRichard van der Hoff2017-05-111-0/+17
* Add per user ratelimiting overridesErik Johnston2017-05-101-0/+22
* Add index to device_lists_streamErik Johnston2017-03-011-0/+17
* Add stream_id index to device_lists_outbound_pokesErik Johnston2017-02-281-0/+16
* Use TEXT rather than VARCHARDavid Baker2017-02-171-6/+6
* Make the pushers lang field column longerDavid Baker2017-02-171-0/+39
* Aggregate event push actionsErik Johnston2017-02-141-0/+37
* Add an index to make membership queries fasterErik Johnston2017-01-311-0/+17
* Add ts column to device_lists_outbound_pokesErik Johnston2017-01-271-1/+2
* Add commentsErik Johnston2017-01-261-1/+7
* Implement device key caching over federationErik Johnston2017-01-261-12/+8
* Add basic implementation of local device list changesErik Johnston2017-01-251-0/+56
* Add commentErik Johnston2017-01-131-0/+1
* Change device_inbox stream index to include userErik Johnston2017-01-101-0/+20
* Merge pull request #1676 from matrix-org/erikj/room_listErik Johnston2016-12-121-0/+29
|\
| * CommentsErik Johnston2016-12-071-0/+2
| * Add new API appservice specific public room listErik Johnston2016-12-061-0/+27
* | Add profile data to the room_membership table for joinsErik Johnston2016-12-081-0/+20
|/
* Don't send old events as federationErik Johnston2016-11-241-1/+1
* More efficient notif count queriesErik Johnston2016-11-231-0/+17
* Store federation stream positions in the databaseErik Johnston2016-11-211-0/+22
* Handle sending events and device messages over federationErik Johnston2016-11-171-0/+16
* Replace postgres GIN with GISTErik Johnston2016-11-031-0/+17
* Use most recently added binding, not most recently seen user.Erik Johnston2016-10-271-19/+11
* Fix user_threepids schema deltaErik Johnston2016-10-271-1/+38
* Latest delta is now 37David Baker2016-10-191-0/+0
* Merge remote-tracking branch 'origin/develop' into dbkr/password_reset_case_i...David Baker2016-10-191-0/+81
|\
| * Bump schema versionErik Johnston2016-10-171-0/+0
| * Remove TODOErik Johnston2016-10-171-2/+0
| * Merge branch 'develop' of github.com:matrix-org/synapse into erikj/remove_authErik Johnston2016-10-174-1/+97
| |\
| * | Drop some unused indicesErik Johnston2016-10-172-16/+83
| * | Remove redundant event_auth indexErik Johnston2016-09-131-0/+16
* | | Convert emails to lowercase when storingDavid Baker2016-10-191-1/+8
* | | Make password reset email field case insensitiveDavid Baker2016-10-141-0/+16
| |/ |/|
* | Match against event_id, rather than room_idErik Johnston2016-09-211-1/+1
* | Update correct tableErik Johnston2016-09-211-6/+10
* | Readd entries to public_room_list_stream that were deletedErik Johnston2016-09-211-0/+22
* | Add a room visibility streamErik Johnston2016-09-141-0/+33
* | Add a DB index to figure out past state at a stream ordering in a roomErik Johnston2016-09-141-0/+37
|/
* Index contains_url for file search queriesErik Johnston2016-09-121-0/+17
* Merge branch 'develop' of github.com:matrix-org/synapse into erikj/make_notif...Erik Johnston2016-09-126-0/+24
|\
| * Add comments to existing schema deltas that used "CREATE INDEX" directlyMark Haines2016-09-126-0/+24
| * Revert "Add index to event_push_actions"Erik Johnston2016-09-121-18/+0
* | Make reindex happen in bgErik Johnston2016-09-121-3/+2
|/
* Merge remote-tracking branch 'origin/develop' into dbkr/make_notif_highlight_...David Baker2016-09-093-0/+80
|\
| * Use the previous MAX value if any to set the stream_idMark Haines2016-09-091-1/+2
| * Track the max_stream_device_id in a separate table, since we delete from the ...Mark Haines2016-09-091-0/+20
| * Merge pull request #1087 from matrix-org/markjh/reapply_deltaMark Haines2016-09-091-1/+4
| |\
| | * Just move the schema and add some DROPsMark Haines2016-09-092-35/+4
| | * Only catch databas errorsMark Haines2016-09-081-1/+1
| | * Add a stub run_upgradeMark Haines2016-09-081-0/+4
| | * Reapply 34/device_outbox in 35/device_outbox_again.py since the schema was bu...Mark Haines2016-09-081-0/+30
| * | Add delta fileErik Johnston2016-09-081-0/+20
| |/
| * Merge branch 'develop' into markjh/direct_to_device_federationMark Haines2016-09-082-0/+39
| |\
| * | Send device messages over federationMark Haines2016-09-061-3/+1
| * | Add tables for federated device messagesMark Haines2016-09-061-0/+38
* | | Add index to event_push_actionsDavid Baker2016-09-091-0/+18
| |/ |/|
* | Correctly delete old state groups in purge history APIErik Johnston2016-09-051-0/+1
* | Add upgrade script that will slowly prune state_groups_state entriesErik Johnston2016-09-051-0/+17
* | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/state_storageErik Johnston2016-09-021-0/+32
|\|
| * Clean up old sent transactionsErik Johnston2016-08-311-0/+32
* | Move to storing state_groups_state as deltasErik Johnston2016-09-011-0/+21
|/
* Add store-and-forward direct-to-device messagingMark Haines2016-08-251-0/+24
* Delete old received_transactionsErik Johnston2016-08-221-0/+32
* Make AppserviceHandler stream events from databaseErik Johnston2016-08-181-0/+23
* Fix push_display_name_rename schema updateErik Johnston2016-08-171-0/+3
* Add migration scriptDavid Baker2016-08-161-0/+17
* Rename table. Add docs.Erik Johnston2016-08-151-2/+4
* Add some invalidations to a cache_streamErik Johnston2016-08-151-0/+44
* Default device_display_name to nullRichard van der Hoff2016-08-032-1/+21
* SQL syntax fixRichard van der Hoff2016-07-271-1/+1