Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | create support user (#4141) | Neil Johnson | 2018-12-14 | 1 | -0/+19 |
| | | | | | | Allow for the creation of a support user. A support user can access the server, join rooms, interact with other users, but does not appear in the user directory nor does it contribute to monthly active user limits. | ||||
* | Drop sent_transactions | Aaron Raimist | 2018-12-01 | 4 | -72/+2 |
| | | | | Signed-off-by: Aaron Raimist <aaron@raim.ist> | ||||
* | Merge remote-tracking branch 'origin/develop' into ↵ | David Baker | 2018-11-09 | 3 | -4/+60 |
|\ | | | | | | | dbkr/e2e_backup_versions_are_numbers | ||||
| * | Add unique indexes to a couple of tables | Richard van der Hoff | 2018-11-02 | 2 | -4/+41 |
| | | | | | | | | | | The indexes on device_lists_remote_extremeties can be unique, and they therefore should, to ensure that the db remains consistent. | ||||
| * | Merge branch 'develop' of github.com:matrix-org/synapse into ↵ | Erik Johnston | 2018-10-19 | 1 | -0/+39 |
| |\ | | | | | | | | | | erikj/purge_state_groups | ||||
| * | | Add state_group index to event_to_state_groups | Erik Johnston | 2018-10-04 | 1 | -0/+19 |
| | | | | | | | | | | | | | | | This is needed to efficiently check for unreferenced state groups during purge. | ||||
* | | | Try & make it work on postgres | David Baker | 2018-10-30 | 1 | -2/+2 |
| | | | |||||
* | | | Make e2e backup versions numeric in the DB | David Baker | 2018-10-29 | 1 | -0/+53 |
| |/ |/| | | | | | | | We were doing max(version) which does not do what we wanted on a column of type TEXT. | ||||
* | | Don't reuse backup versions | David Baker | 2018-10-05 | 1 | -1/+2 |
| | | | | | | | | | | | | | | | | Since we don't actually delete the keys, just mark the versions as deleted in the db rather than actually deleting them, then we won't reuse versions. Fixes https://github.com/vector-im/riot-web/issues/7448 | ||||
* | | WIP e2e key backups | David Baker | 2018-09-13 | 1 | -0/+0 |
| | | | | | | | | | | | | | | Continues from uhoreg's branch This just fixed the errcode on /room_keys/version if no backup and updates the schema delta to be on the latest so it gets run | ||||
* | | Merge branch 'develop' into e2e_backups | Hubert Chathi | 2018-08-24 | 1 | -0/+27 |
|\| | |||||
| * | typos | Neil Johnson | 2018-08-08 | 1 | -1/+1 |
| | | |||||
| * | make use of _simple_select_one_onecol, improved comments | Neil Johnson | 2018-08-06 | 1 | -0/+4 |
| | | |||||
| * | Revert "change monthly_active_users table to be a single column" | Neil Johnson | 2018-08-02 | 1 | -1/+3 |
| | | | | | | | | This reverts commit ec716a35b219d147dee51733b55573952799a549. | ||||
| * | change monthly_active_users table to be a single column | Neil Johnson | 2018-08-01 | 1 | -3/+1 |
| | | |||||
| * | fix comment | Neil Johnson | 2018-08-01 | 1 | -1/+1 |
| | | |||||
| * | api into monthly_active_users table | Neil Johnson | 2018-07-31 | 2 | -1/+24 |
| | | |||||
* | | fix idiocies and so make tests pass | Matthew Hodgson | 2018-08-12 | 1 | -1/+1 |
| | | |||||
* | | blindly incorporate PR review - needs testing & fixing | Matthew Hodgson | 2018-08-12 | 1 | -5/+3 |
| | | |||||
* | | make /room_keys/version work | Matthew Hodgson | 2018-08-12 | 1 | -2/+2 |
| | | |||||
* | | implement /room_keys/version too (untested) | Matthew Hodgson | 2018-08-12 | 1 | -1/+1 |
| | | |||||
* | | make it work and fix pep8 | Matthew Hodgson | 2018-08-12 | 1 | -1/+1 |
| | | |||||
* | | total WIP skeleton for /room_keys API | Matthew Hodgson | 2018-08-12 | 1 | -0/+40 |
| | | |||||
* | | coding style | Neil Johnson | 2018-07-31 | 1 | -1/+1 |
|/ | |||||
* | Create the column nullable | Richard van der Hoff | 2018-07-26 | 2 | -9/+13 |
| | | | | | There's no real point in ever making the column non-nullable, and doing so breaks the sytests. | ||||
* | Stop populating events.content | Richard van der Hoff | 2018-07-26 | 1 | -0/+93 |
| | | | | | | This field is no longer read from, so we should stop populating it. Once we're happy that this doesn't break everything, and a rollback is unlikely, we can think about dropping the column. | ||||
* | comment on event_edges | Richard van der Hoff | 2018-07-26 | 1 | -1/+2 |
| | |||||
* | run isort | Amber Brown | 2018-07-09 | 11 | -23/+24 |
| | |||||
* | Revert "Revert "Merge pull request #3431 from ↵ | Erik Johnston | 2018-06-25 | 1 | -0/+21 |
| | | | | | | matrix-org/rav/erasure_visibility"" This reverts commit 1d009013b3c3e814177afc59f066e02a202b21cd. | ||||
* | Revert "Merge pull request #3431 from matrix-org/rav/erasure_visibility" | Richard van der Hoff | 2018-06-22 | 1 | -21/+0 |
| | | | | | This reverts commit ce0d911156b355c5bf452120bfb08653dad96497, reversing changes made to b4a5d767a94f1680d07edfd583aae54ce422573e. | ||||
* | UserErasureStore | Richard van der Hoff | 2018-06-12 | 1 | -0/+21 |
| | | | | to store which users have been erased | ||||
* | remove unnecessary INSERT | Neil Johnson | 2018-06-01 | 1 | -1/+0 |
| | |||||
* | create users index on creation_ts | Neil Johnson | 2018-05-29 | 1 | -0/+20 |
| | |||||
* | Send users a server notice about consent | Richard van der Hoff | 2018-05-22 | 1 | -0/+20 |
| | | | | | When a user first syncs, we will send them a server notice asking them to consent to the privacy policy if they have not already done so. | ||||
* | Merge pull request #3163 from matrix-org/cohort_analytics | Neil Johnson | 2018-05-16 | 2 | -0/+38 |
|\ | | | | | user visit data | ||||
| * | Merge branch 'develop' of https://github.com/matrix-org/synapse into ↵ | Neil Johnson | 2018-05-14 | 2 | -1/+60 |
| |\ | | | | | | | | | | cohort_analytics | ||||
| * | | add inidexes based on usage | Neil Johnson | 2018-05-01 | 1 | -6/+2 |
| | | | |||||
| * | | Generate user daily stats | Neil Johnson | 2018-04-25 | 2 | -0/+42 |
| | | | |||||
* | | | Merge pull request #3213 from matrix-org/rav/consent_handler | Richard van der Hoff | 2018-05-16 | 1 | -0/+18 |
|\ \ \ | | | | | | | | | ConsentResource to gather policy consent from users | ||||
| * | | | ConsentResource to gather policy consent from users | Richard van der Hoff | 2018-05-15 | 1 | -0/+18 |
| | |/ | |/| | | | | | | | | | | Hopefully there are enough comments and docs in this that it makes sense on its own. | ||||
* / | | Add the schema file | David Baker | 2018-05-09 | 1 | -0/+25 |
|/ / | |||||
* | | Merge pull request #3129 from matrix-org/matthew/fix_group_dups | Matthew Hodgson | 2018-04-30 | 1 | -0/+57 |
|\ \ | | | | | | | remove duplicates from groups tables | ||||
| * | | fix missing import | Matthew Hodgson | 2018-04-28 | 1 | -0/+1 |
| | | | |||||
| * | | pep8 | Matthew Hodgson | 2018-04-28 | 1 | -3/+5 |
| | | | |||||
| * | | make it work with sqlite | Matthew Hodgson | 2018-04-28 | 2 | -34/+54 |
| | | | |||||
| * | | remove duplicates from groups tables | Matthew Hodgson | 2018-04-25 | 1 | -0/+34 |
| |/ | | | | | | | | | and rename inconsistently named indexes. Based on https://github.com/matrix-org/synapse/pull/3128 - thanks @vurpo\! | ||||
* / | Move more xrange to six | Adrian Tschira | 2018-04-28 | 1 | -1/+3 |
|/ | | | | | | plus a bonus next() Signed-off-by: Adrian Tschira <nota@notafile.com> | ||||
* | Merge pull request #3045 from matrix-org/dbkr/group_joinable | Luke Barnard | 2018-04-05 | 1 | -0/+22 |
|\ | | | | | Add joinability for groups | ||||
| * | NON NULL -> NOT NULL | Luke Barnard | 2018-04-05 | 1 | -1/+1 |
| | | |||||
| * | Use DEFAULT join_policy of "invite" in db | Luke Barnard | 2018-04-05 | 1 | -1/+1 |
| | | |||||
| * | Use join_policy API instead of joinable | Luke Barnard | 2018-04-03 | 1 | -1/+7 |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The API is now under /groups/$group_id/setting/m.join_policy and expects a JSON blob of the shape ```json { "m.join_policy": { "type": "invite" } } ``` where "invite" could alternatively be "open". | ||||
| * | OK, smallint it is then | David Baker | 2018-03-28 | 1 | -1/+1 |
| | | |||||
| * | Grr. Copy the definition from is_admin | David Baker | 2018-03-28 | 1 | -1/+1 |
| | | |||||
| * | Make column definition that works on both dbs | David Baker | 2018-03-28 | 1 | -1/+1 |
| | | |||||
| * | Add schema delta file | David Baker | 2018-03-28 | 1 | -0/+16 |
| | | |||||
* | | Merge pull request #3041 from matrix-org/r30_stats | Neil Johnson | 2018-04-05 | 1 | -0/+17 |
|\ \ | | | | | | | R30 stats | ||||
| * | | Add user_ips last seen index | Neil Johnson | 2018-03-28 | 1 | -0/+17 |
| |/ | |||||
* / | Use simplejson throughout | Richard van der Hoff | 2018-03-29 | 1 | -1/+2 |
|/ | | | | Let's use simplejson rather than json, for consistency. | ||||
* | Merge branch 'master' of github.com:matrix-org/synapse into develop | Erik Johnston | 2018-03-19 | 4 | -8/+8 |
|\ | |||||
| * | Replace ujson with simplejson | Erik Johnston | 2018-03-15 | 4 | -7/+7 |
| | | |||||
* | | Comments | Erik Johnston | 2018-02-16 | 1 | -0/+4 |
| | | |||||
* | | Store push actions in staging area | Erik Johnston | 2018-02-15 | 1 | -0/+24 |
| | | |||||
* | | Merge branch 'matthew/gin_work_mem' into matthew/hit_the_gin | Richard van der Hoff | 2018-02-13 | 2 | -0/+53 |
|\ \ | |||||
| * | | Store state groups separately from events (#2784) | Erik Johnston | 2018-02-06 | 1 | -0/+37 |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Split state group persist into seperate storage func * Add per database engine code for state group id gen * Move store_state_group to StateReadStore This allows other workers to use it, and so resolve state. * Hook up store_state_group * Fix tests * Rename _store_mult_state_groups_txn * Rename StateGroupReadStore * Remove redundant _have_persisted_state_group_txn * Update comments * Comment compute_event_context * Set start val for state_group_id_seq ... otherwise we try to recreate old state groups * Update comments * Don't store state for outliers * Update comment * Update docstring as state groups are ints | ||||
| * | | Remove lost comment | Erik Johnston | 2018-01-17 | 1 | -3/+0 |
| | | | |||||
| * | | Keep track of last access time for local media | Erik Johnston | 2018-01-17 | 1 | -0/+19 |
| |/ | |||||
* | | move search reindex to schema 47 | Richard van der Hoff | 2018-02-13 | 2 | -1/+1 |
| | | | | | | | | | | | | | | | | | | | | | | | | We're up to schema v47 on develop now, so this will have to go in there to have an effect. This might cause an error if somebody has already run it in the v46 guise, and runs it again in the v47 guise, because it will cause a duplicate entry in the bbackground_updates table. On the other hand, the entry is removed once it is complete, and it is unlikely that anyone other than matrix.org has run it on v46. The update itself is harmless to re-run because it deliberately copes with the index already existing. | ||||
* | | fix GIST->GIN switch | Matthew Hodgson | 2018-01-09 | 2 | -2/+21 |
|/ | |||||
* | Merge branch 'develop' into matthew/search-all-local-users | Matthew Hodgson | 2017-11-30 | 2 | -1/+28 |
|\ | |||||
| * | Fix error on sqlite 3.7 | Richard van der Hoff | 2017-11-21 | 2 | -1/+28 |
| | | | | | | | | | | | | | | | | | | | | | | Create the url_cache index on local_media_repository as a background update, so that we can detect whether we are on sqlite or not and create a partial or complete index accordingly. To avoid running the cleanup job before we have built the index, add a bailout which will defer the cleanup if the bg updates are still running. Fixes https://github.com/matrix-org/synapse/issues/2572. | ||||
* | | remove null constraint on user_dir.room_id | Matthew Hodgson | 2017-11-30 | 1 | -0/+35 |
|/ | |||||
* | Avoid locking for upsert on pushers tables | Richard van der Hoff | 2017-11-16 | 1 | -0/+35 |
| | | | | | * replace the upsert into deleted_pushers with an insert * no need to lock for upsert on pusher_throttle | ||||
* | create new indexes before dropping old ones to keep safetynet in place | Matthew Hodgson | 2017-11-07 | 1 | -2/+4 |
| | |||||
* | s/users_in_pubic_room/users_in_public_rooms/g | Matthew Hodgson | 2017-11-04 | 1 | -2/+2 |
| | |||||
* | s/users_in_pubic_room/users_in_public_rooms/g | Matthew Hodgson | 2017-11-04 | 1 | -0/+22 |
| | |||||
* | fix copyright.... | Matthew Hodgson | 2017-11-04 | 1 | -1/+1 |
| | |||||
* | s/popualte/populate/ | Matthew Hodgson | 2017-11-04 | 1 | -1/+1 |
| | |||||
* | Remove the last vestiges of refresh_tokens | Richard van der Hoff | 2017-10-31 | 3 | -40/+3 |
| | |||||
* | DB schema interface for password auth providers | Richard van der Hoff | 2017-10-31 | 1 | -0/+7 |
| | | | | | Provide an interface by which password auth providers can register db schema files to be run at startup | ||||
* | Recreate groups table instead of adding column | Luke Barnard | 2017-10-26 | 1 | -2/+16 |
| | | | | Adding a column with non-constant default not possible in sqlite3 | ||||
* | Awful hack to get default true | Luke Barnard | 2017-10-26 | 1 | -1/+2 |
| | |||||
* | Add is_public to groups table to allow for private groups | Luke Barnard | 2017-10-26 | 1 | -0/+17 |
| | | | | | | Prevent group API access to non-members for private groups Also make all the group code paths consistent with `requester_user_id` always being the User ID of the requesting user. | ||||
* | replace 'except:' with 'except Exception:' | Richard van der Hoff | 2017-10-23 | 1 | -1/+1 |
| | | | | what could possibly go wrong | ||||
* | Fix schema delta versions | Erik Johnston | 2017-10-11 | 2 | -0/+0 |
| | |||||
* | Merge branch 'develop' into erikj/groups_merged | David Baker | 2017-10-02 | 1 | -0/+38 |
|\ | |||||
| * | Add old indices | Erik Johnston | 2017-09-28 | 1 | -0/+2 |
| | | |||||
| * | Change expires column to expires_ts | Erik Johnston | 2017-09-28 | 1 | -1/+20 |
| | | |||||
| * | More brackets | Erik Johnston | 2017-09-28 | 1 | -1/+1 |
| | | |||||
| * | Delete expired url cache data | Erik Johnston | 2017-09-28 | 1 | -0/+17 |
| | | |||||
* | | Add unique index to group_rooms table | Erik Johnston | 2017-09-26 | 1 | -1/+1 |
| | | |||||
* | | Add remote profile cache | Erik Johnston | 2017-08-25 | 1 | -0/+28 |
| | | |||||
* | | Use BOOLEAN rather than TEXT type | Erik Johnston | 2017-08-21 | 1 | -1/+1 |
| | | |||||
* | | Store whether the user wants to publicise their membership of a group | Erik Johnston | 2017-08-08 | 1 | -0/+1 |
| | | |||||
* | | Add groups to sync stream | Erik Johnston | 2017-07-20 | 1 | -0/+9 |
| | | |||||
* | | Remove sync stuff | Erik Johnston | 2017-07-18 | 1 | -9/+1 |
| | | |||||
* | | Remove unused tables | Erik Johnston | 2017-07-18 | 1 | -7/+0 |
| | | |||||
* | | Add local group server support | Erik Johnston | 2017-07-17 | 1 | -0/+28 |
| | | |||||
* | | Comments | Erik Johnston | 2017-07-12 | 1 | -5/+12 |
| | | |||||
* | | Add group summary APIs | Erik Johnston | 2017-07-12 | 1 | -0/+56 |
| | | |||||
* | | Comment | Erik Johnston | 2017-07-12 | 1 | -1/+1 |
| | | |||||
* | | Move comment | Erik Johnston | 2017-07-11 | 1 | -2/+2 |
| | | |||||
* | | Rename column to attestation_json | Erik Johnston | 2017-07-11 | 1 | -1/+1 |
| | | |||||
* | | Comments | Erik Johnston | 2017-07-11 | 1 | -2/+2 |
| | | |||||
* | | Comments | Erik Johnston | 2017-07-11 | 1 | -1/+5 |
| | | |||||
* | | Initial group server implementation | Erik Johnston | 2017-07-10 | 1 | -0/+77 |
|/ | |||||
* | Fix up indices for users_who_share_rooms | Erik Johnston | 2017-06-26 | 1 | -1/+2 |
| | |||||
* | Store URL cache preview downloads seperately | Erik Johnston | 2017-06-23 | 1 | -0/+16 |
| | | | | This makes it easier to clear old media out at a later date | ||||
* | Add API to quarantine media | Erik Johnston | 2017-06-19 | 1 | -0/+17 |
| | |||||
* | Add shutdown room API | Erik Johnston | 2017-06-19 | 1 | -0/+21 |
| | |||||
* | Add DB schema for tracking users who share rooms | Erik Johnston | 2017-06-15 | 1 | -0/+32 |
| | |||||
* | Split up device_lists_outbound_pokes table for faster updates. | Erik Johnston | 2017-06-07 | 1 | -0/+33 |
| | |||||
* | Split the table in two | Erik Johnston | 2017-06-01 | 1 | -1/+9 |
| | |||||
* | Use unique indices | Erik Johnston | 2017-05-31 | 1 | -2/+2 |
| | |||||
* | Split out directory and search tables | Erik Johnston | 2017-05-31 | 1 | -11/+14 |
| | |||||
* | Handle the server leaving a public room | Erik Johnston | 2017-05-31 | 1 | -0/+4 |
| | |||||
* | Add comments | Erik Johnston | 2017-05-31 | 1 | -1/+1 |
| | |||||
* | Add user_directory to database | Erik Johnston | 2017-05-31 | 1 | -0/+69 |
| | |||||
* | Add comment | Erik Johnston | 2017-05-30 | 1 | -1/+1 |
| | |||||
* | Add clobbered event_id | Erik Johnston | 2017-05-30 | 1 | -1/+2 |
| | |||||
* | Add current_state_delta_stream table | Erik Johnston | 2017-05-30 | 1 | -0/+25 |
| | |||||
* | Add background task to clear out old event_auth | Erik Johnston | 2017-05-24 | 1 | -0/+17 |
| | |||||
* | Add a comment to old delta | Richard van der Hoff | 2017-05-11 | 1 | -0/+4 |
| | |||||
* | Add an index to event_search | Richard van der Hoff | 2017-05-11 | 1 | -0/+17 |
| | | | | - to make the purge API quicker | ||||
* | Add per user ratelimiting overrides | Erik Johnston | 2017-05-10 | 1 | -0/+22 |
| | |||||
* | Add index to device_lists_stream | Erik Johnston | 2017-03-01 | 1 | -0/+17 |
| | |||||
* | Add stream_id index to device_lists_outbound_pokes | Erik Johnston | 2017-02-28 | 1 | -0/+16 |
| | | | | As this is used for replication streaming | ||||
* | Use TEXT rather than VARCHAR | David Baker | 2017-02-17 | 1 | -6/+6 |
| | | | | While we're changing anyway | ||||
* | Make the pushers lang field column longer | David Baker | 2017-02-17 | 1 | -0/+39 |
| | | | | | | To accommodate things like zh-Hans-CN Fixes https://github.com/vector-im/riot-ios/issues/1031 | ||||
* | Aggregate event push actions | Erik Johnston | 2017-02-14 | 1 | -0/+37 |
| | |||||
* | Add an index to make membership queries faster | Erik Johnston | 2017-01-31 | 1 | -0/+17 |
| | |||||
* | Add ts column to device_lists_outbound_pokes | Erik Johnston | 2017-01-27 | 1 | -1/+2 |
| | |||||
* | Add comments | Erik Johnston | 2017-01-26 | 1 | -1/+7 |
| | |||||
* | Implement device key caching over federation | Erik Johnston | 2017-01-26 | 1 | -12/+8 |
| | |||||
* | Add basic implementation of local device list changes | Erik Johnston | 2017-01-25 | 1 | -0/+56 |
| | |||||
* | Add comment | Erik Johnston | 2017-01-13 | 1 | -0/+1 |
| | |||||
* | Change device_inbox stream index to include user | Erik Johnston | 2017-01-10 | 1 | -0/+20 |
| | | | | | This makes fetching the nost recently changed users much tricker, and brings it in line with e.g. presence_stream indices. | ||||
* | Merge pull request #1676 from matrix-org/erikj/room_list | Erik Johnston | 2016-12-12 | 1 | -0/+29 |
|\ | | | | | Add new API appservice specific public room list | ||||
| * | Comments | Erik Johnston | 2016-12-07 | 1 | -0/+2 |
| | | |||||
| * | Add new API appservice specific public room list | Erik Johnston | 2016-12-06 | 1 | -0/+27 |
| | | |||||
* | | Add profile data to the room_membership table for joins | Erik Johnston | 2016-12-08 | 1 | -0/+20 |
|/ | |||||
* | Don't send old events as federation | Erik Johnston | 2016-11-24 | 1 | -1/+1 |
| | |||||
* | More efficient notif count queries | Erik Johnston | 2016-11-23 | 1 | -0/+17 |
| | |||||
* | Store federation stream positions in the database | Erik Johnston | 2016-11-21 | 1 | -0/+22 |
| | |||||
* | Handle sending events and device messages over federation | Erik Johnston | 2016-11-17 | 1 | -0/+16 |
| | |||||
* | Replace postgres GIN with GIST | Erik Johnston | 2016-11-03 | 1 | -0/+17 |
| | | | | | This is because GIN can be slow to write too, especially when the table gets large. | ||||
* | Use most recently added binding, not most recently seen user. | Erik Johnston | 2016-10-27 | 1 | -19/+11 |
| | |||||
* | Fix user_threepids schema delta | Erik Johnston | 2016-10-27 | 1 | -1/+38 |
| | | | | | | | | | | | The delta `37/user_threepids.sql` aimed to update all the email addresses to be lower case, however duplicate emails may exist in the table already. This commit adds a step where the delta moves the duplicate emails to a new `medium` `email_old`. Only the most recently used account keeps the binding intact. We move rather than delete so that we retain some record of which emails were associated with which account. | ||||
* | Latest delta is now 37 | David Baker | 2016-10-19 | 1 | -0/+0 |
| | |||||
* | Merge remote-tracking branch 'origin/develop' into ↵ | David Baker | 2016-10-19 | 1 | -0/+81 |
|\ | | | | | | | dbkr/password_reset_case_insensitive | ||||
| * | Bump schema version | Erik Johnston | 2016-10-17 | 1 | -0/+0 |
| | | |||||
| * | Remove TODO | Erik Johnston | 2016-10-17 | 1 | -2/+0 |
| | | |||||
| * | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/remove_auth | Erik Johnston | 2016-10-17 | 4 | -1/+97 |
| |\ | |||||
| * | | Drop some unused indices | Erik Johnston | 2016-10-17 | 2 | -16/+83 |
| | | | |||||
| * | | Remove redundant event_auth index | Erik Johnston | 2016-09-13 | 1 | -0/+16 |
| | | | |||||
* | | | Convert emails to lowercase when storing | David Baker | 2016-10-19 | 1 | -1/+8 |
| | | | | | | | | | | | | And db migration sql to convert existing addresses. | ||||
* | | | Make password reset email field case insensitive | David Baker | 2016-10-14 | 1 | -0/+16 |
| |/ |/| | |||||
* | | Match against event_id, rather than room_id | Erik Johnston | 2016-09-21 | 1 | -1/+1 |
| | | |||||
* | | Update correct table | Erik Johnston | 2016-09-21 | 1 | -6/+10 |
| | | |||||
* | | Readd entries to public_room_list_stream that were deleted | Erik Johnston | 2016-09-21 | 1 | -0/+22 |
| | | |||||
* | | Add a room visibility stream | Erik Johnston | 2016-09-14 | 1 | -0/+33 |
| | | |||||
* | | Add a DB index to figure out past state at a stream ordering in a room | Erik Johnston | 2016-09-14 | 1 | -0/+37 |
|/ | |||||
* | Index contains_url for file search queries | Erik Johnston | 2016-09-12 | 1 | -0/+17 |
| | |||||
* | Merge branch 'develop' of github.com:matrix-org/synapse into ↵ | Erik Johnston | 2016-09-12 | 6 | -0/+24 |
|\ | | | | | | | erikj/make_notif_highlight_query_fast | ||||
| * | Add comments to existing schema deltas that used "CREATE INDEX" directly | Mark Haines | 2016-09-12 | 6 | -0/+24 |
| | | |||||
| * | Revert "Add index to event_push_actions" | Erik Johnston | 2016-09-12 | 1 | -18/+0 |
| | | |||||
* | | Make reindex happen in bg | Erik Johnston | 2016-09-12 | 1 | -3/+2 |
|/ | |||||
* | Merge remote-tracking branch 'origin/develop' into ↵ | David Baker | 2016-09-09 | 3 | -0/+80 |
|\ | | | | | | | dbkr/make_notif_highlight_query_fast | ||||
| * | Use the previous MAX value if any to set the stream_id | Mark Haines | 2016-09-09 | 1 | -1/+2 |
| | | |||||
| * | Track the max_stream_device_id in a separate table, since we delete from the ↵ | Mark Haines | 2016-09-09 | 1 | -0/+20 |
| | | | | | | | | inbox table | ||||
| * | Merge pull request #1087 from matrix-org/markjh/reapply_delta | Mark Haines | 2016-09-09 | 1 | -1/+4 |
| |\ | | | | | | | Reapply 34/device_outbox in 35/device_outbox_again.py since the schem… | ||||
| | * | Just move the schema and add some DROPs | Mark Haines | 2016-09-09 | 2 | -35/+4 |
| | | | |||||
| | * | Only catch databas errors | Mark Haines | 2016-09-08 | 1 | -1/+1 |
| | | | |||||
| | * | Add a stub run_upgrade | Mark Haines | 2016-09-08 | 1 | -0/+4 |
| | | | |||||
| | * | Reapply 34/device_outbox in 35/device_outbox_again.py since the schema was ↵ | Mark Haines | 2016-09-08 | 1 | -0/+30 |
| | | | | | | | | | | | | bumped before it landed on develop | ||||
| * | | Add delta file | Erik Johnston | 2016-09-08 | 1 | -0/+20 |
| |/ | |||||
| * | Merge branch 'develop' into markjh/direct_to_device_federation | Mark Haines | 2016-09-08 | 2 | -0/+39 |
| |\ | |||||
| * | | Send device messages over federation | Mark Haines | 2016-09-06 | 1 | -3/+1 |
| | | | |||||
| * | | Add tables for federated device messages | Mark Haines | 2016-09-06 | 1 | -0/+38 |
| | | | | | | | | | | | | | | | Adds tables for storing the messages that need to be sent to a remote device and for deduplicating messages received. | ||||
* | | | Add index to event_push_actions | David Baker | 2016-09-09 | 1 | -0/+18 |
| |/ |/| | | | | | | | | | and remove room_id caluse so it uses it Mostly from @negativemjark | ||||
* | | Correctly delete old state groups in purge history API | Erik Johnston | 2016-09-05 | 1 | -0/+1 |
| | | |||||
* | | Add upgrade script that will slowly prune state_groups_state entries | Erik Johnston | 2016-09-05 | 1 | -0/+17 |
| | | |||||
* | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/state_storage | Erik Johnston | 2016-09-02 | 1 | -0/+32 |
|\| | |||||
| * | Clean up old sent transactions | Erik Johnston | 2016-08-31 | 1 | -0/+32 |
| | | |||||
* | | Move to storing state_groups_state as deltas | Erik Johnston | 2016-09-01 | 1 | -0/+21 |
|/ | |||||
* | Add store-and-forward direct-to-device messaging | Mark Haines | 2016-08-25 | 1 | -0/+24 |
| | |||||
* | Delete old received_transactions | Erik Johnston | 2016-08-22 | 1 | -0/+32 |
| | |||||
* | Make AppserviceHandler stream events from database | Erik Johnston | 2016-08-18 | 1 | -0/+23 |
| | | | | | | | | | This is for two reasons: 1. Suppresses duplicates correctly, as the notifier doesn't do any duplicate suppression. 2. Makes it easier to connect the AppserviceHandler to the replication stream. | ||||
* | Fix push_display_name_rename schema update | Erik Johnston | 2016-08-17 | 1 | -0/+3 |
| | |||||
* | Add migration script | David Baker | 2016-08-16 | 1 | -0/+17 |
| | | | | To port existing rule actions & enable entries to the new name | ||||
* | Rename table. Add docs. | Erik Johnston | 2016-08-15 | 1 | -2/+4 |
| | |||||
* | Add some invalidations to a cache_stream | Erik Johnston | 2016-08-15 | 1 | -0/+44 |
| | |||||
* | Default device_display_name to null | Richard van der Hoff | 2016-08-03 | 2 | -1/+21 |
| | | | | | | It turns out that it's more useful to return a null device display name (and let clients decide how to handle it: eg, falling back to device_id) than using a constant string like "unknown device". | ||||
* | SQL syntax fix | Richard van der Hoff | 2016-07-27 | 1 | -1/+1 |
| | |||||
* | Make the device id on e2e key upload optional | Richard van der Hoff | 2016-07-26 | 1 | -0/+19 |
| | | | | | | | | | | | | We should now be able to get our device_id from the access_token, so the device_id on the upload request is optional. Where it is supplied, we should check that it matches. For active access_tokens without an associated device_id, we ought to register the device in the devices table. Also update the table on upgrade so that all of the existing e2e keys are associated with real devices. | ||||
* | Implement deleting devices | Richard van der Hoff | 2016-07-26 | 2 | -0/+34 |
| | |||||
* | Create index on user_ips in the background | Richard van der Hoff | 2016-07-22 | 1 | -1/+2 |
| | | | | | | | | user_ips is kinda big, so really we want to add the index in the background once we're running. Replace the schema delta with one which will do that. I've done this in a way that's reasonably easy to reuse as there a few other indexes I need, and I don't suppose they will be the last. | ||||
* | GET /devices endpoint | Richard van der Hoff | 2016-07-20 | 1 | -0/+16 |
| | | | | | | | implement a GET /devices endpoint which lists all of the user's devices. It also returns the last IP where we saw that device, so there is some dancing to fish that out of the user_ips table. | ||||
* | Merge pull request #922 from matrix-org/erikj/file_api2 | Erik Johnston | 2016-07-20 | 1 | -0/+60 |
|\ | | | | | Feature: Add filter to /messages. Add 'contains_url' to filter. | ||||
| * | Add sender and contains_url field to events table | Erik Johnston | 2016-07-14 | 1 | -0/+60 |
| | | |||||
* | | schema fix | Richard van der Hoff | 2016-07-19 | 1 | -1/+1 |
| | | | | | | | | device_id should be text, not bigint. | ||||
* | | Add device_id support to /login | Richard van der Hoff | 2016-07-18 | 2 | -0/+37 |
|/ | | | | | | | | | | | | | Add a 'devices' table to the storage, as well as a 'device_id' column to refresh_tokens. Allow the client to pass a device_id, and initial_device_display_name, to /login. If login is successful, then register the device in the devices table if it wasn't known already. If no device_id was supplied, make one up. Associate the device_id with the access token and refresh token, so that we can get at it again later. Ensure that the device_id is copied from the refresh token to the access_token when the token is refreshed. | ||||
* | Track approximate last access time for remote media | Erik Johnston | 2016-06-29 | 1 | -0/+31 |
| | |||||
* | Fix synapse/storage/schema/delta/30/as_users.py | Mark Haines | 2016-05-31 | 1 | -2/+2 |
| | |||||
* | Remove topics table | Erik Johnston | 2016-05-13 | 1 | -1/+0 |
| | |||||
* | Annotate the removed indicies with why they were removed. | Mark Haines | 2016-05-13 | 1 | -18/+15 |
| | |||||
* | Remove unused indices | Erik Johnston | 2016-05-13 | 1 | -0/+42 |
| | | | | | This includes removing both unused indices and indices that are subsets of other indices. | ||||
* | unbreak schema | Matrix | 2016-05-10 | 2 | -0/+0 |
| | |||||
* | Merge remote-tracking branch 'origin/develop' into dbkr/email_notifs | David Baker | 2016-05-10 | 2 | -0/+34 |
|\ | |||||
| * | Add an openidish mechanism for proving to third parties that you own a given ↵ | Mark Haines | 2016-05-05 | 1 | -0/+9 |
| | | | | | | | | user_id | ||||
| * | Add primary key | Erik Johnston | 2016-05-04 | 1 | -1/+1 |
| | | |||||
| * | Add timestamp and auto incrementing ID | Erik Johnston | 2016-05-04 | 1 | -0/+2 |
| | | |||||
| * | Add /report endpoint | Erik Johnston | 2016-05-04 | 1 | -0/+23 |
| | | |||||
* | | Merge remote-tracking branch 'origin/develop' into dbkr/email_notifs | David Baker | 2016-04-29 | 1 | -0/+65 |
|\| | |||||
| * | Order NULLs first | Erik Johnston | 2016-04-21 | 1 | -2/+2 |
| | | |||||
| * | Use special UPDATE syntax | Erik Johnston | 2016-04-21 | 1 | -2/+2 |
| | | |||||
| * | Create index concurrently | Erik Johnston | 2016-04-21 | 1 | -5/+1 |
| | | |||||
| * | Add missing run_upgrade | Erik Johnston | 2016-04-21 | 1 | -0/+4 |
| | | |||||
| * | Optimise event_search in postgres | Erik Johnston | 2016-04-21 | 1 | -0/+65 |
| | | |||||
* | | First bits of emailpusher | David Baker | 2016-04-19 | 2 | -0/+39 |
|/ | | | | Mostly logic of when to send an email | ||||
* | Add index | Erik Johnston | 2016-04-14 | 1 | -0/+18 |
| | |||||
* | Merge pull request #705 from matrix-org/dbkr/pushers_use_event_actions | David Baker | 2016-04-11 | 1 | -0/+79 |
|\ | | | | | Change pushers to use the event_actions table | ||||
| * | pep8 | David Baker | 2016-04-07 | 1 | -0/+1 |
| | | |||||
| * | Fix port script for changes merged from develop | David Baker | 2016-04-07 | 1 | -1/+4 |
| | | |||||
| * | Merge remote-tracking branch 'origin/develop' into ↵ | David Baker | 2016-04-07 | 5 | -5/+23 |
| |\ | | | | | | | | | | dbkr/pushers_use_event_actions | ||||
| * | | Make pushers use the event_push_actions table instead of listening on an ↵ | David Baker | 2016-04-06 | 1 | -0/+75 |
| | | | | | | | | | | | | | | | | | | | | | event stream & running the rules again. Sytest passes, but remaining to do: * Make badges work again * Remove old, unused code | ||||
* | | | move local_media_repository_url_cache.sql to schema v31 | Matthew Hodgson | 2016-04-08 | 1 | -0/+0 |
| | | | |||||
* | | | Merge branch 'develop' into matthew/preview_urls | Matthew Hodgson | 2016-04-07 | 6 | -5/+65 |
|\ \ \ | | |/ | |/| | |||||
| * | | Don't require config to create database | Erik Johnston | 2016-04-06 | 5 | -5/+23 |
| |/ | |||||
| * | Docs and indents | Erik Johnston | 2016-04-04 | 1 | -11/+11 |
| | | |||||
| * | Add upgrade path, rename table | Erik Johnston | 2016-04-04 | 1 | -3/+17 |
| | | |||||
| * | Store invites in a separate table. | Erik Johnston | 2016-04-04 | 1 | -0/+28 |
| | | |||||
* | | Merge branch 'develop' into matthew/preview_urls | Matthew Hodgson | 2016-04-04 | 1 | -0/+38 |
|\| | |||||
| * | Add replication streams for ex outliers and current state resets | Mark Haines | 2016-03-30 | 1 | -0/+38 |
| | | |||||
* | | add a persistent cache of URL lookups, and fix up the in-memory one to work | Matthew Hodgson | 2016-04-03 | 1 | -0/+27 |
|/ | |||||
* | Comment about weird SQL | Erik Johnston | 2016-03-23 | 1 | -1/+3 |
| | |||||
* | SQLite and postgres doesn't share a true literal | Erik Johnston | 2016-03-23 | 1 | -1/+1 |
| | |||||
* | Ensure all old public rooms have aliases | Erik Johnston | 2016-03-23 | 1 | -0/+21 |
| | |||||
* | Add a comment to offer a hint to an explanation for why we have a unique ↵ | Mark Haines | 2016-03-16 | 1 | -0/+1 |
| | | | | constraint on (app_id, pushkey, user_id) | ||||
* | Add replication stream for pushers | Mark Haines | 2016-03-15 | 1 | -0/+24 |
| | |||||
* | Update users table in a batched manner | Erik Johnston | 2016-03-10 | 1 | -9/+14 |
| | |||||
* | Merge branch 'develop' into daniel/ick | Daniel Wagner-Hall | 2016-03-08 | 2 | -0/+54 |
|\ | |||||
| * | s/stream_ordering/event_stream_ordering/ in push | Mark Haines | 2016-03-04 | 1 | -1/+1 |
| | | |||||
| * | Merge branch 'develop' into markjh/pushrule_stream | Mark Haines | 2016-03-04 | 2 | -0/+75 |
| |\ | |||||
| | * | Merge pull request #614 from matrix-org/erikj/alias_delete | Erik Johnston | 2016-03-04 | 1 | -0/+16 |
| | |\ | | | | | | | | | Allow alias creators to delete aliases | ||||
| | | * | Allow alias creators to delete aliases | Erik Johnston | 2016-03-01 | 1 | -0/+16 |
| | | | | |||||
| * | | | Add a stream for push rule updates | Mark Haines | 2016-03-01 | 1 | -0/+38 |
| | |/ | |/| | |||||
* | | | Idempotent-ise schema update script | Daniel Wagner-Hall | 2016-03-08 | 1 | -1/+5 |
| |/ |/| | | | | | | | If any ASes don't have an ID, the schema will fail, and then it will error when trying to add the column again. | ||||
* | | Merge pull request #571 from matrix-org/daniel/asids | Daniel Wagner-Hall | 2016-03-03 | 1 | -0/+59 |
|\ \ | |/ |/| | Mark AS users with their AS's ID | ||||
| * | Mark AS users with their AS's ID | Daniel Wagner-Hall | 2016-02-11 | 1 | -0/+59 |
| | | |||||
* | | Generate guest access token on 3pid invites | Daniel Wagner-Hall | 2016-02-24 | 1 | -0/+24 |
| | | | | | | | | | | | | | | | | | | This means that following the same link across multiple sessions or devices can re-use the same guest account. Note that this is somewhat of an abuse vector; we can't throw up captchas on this flow, so this is a way of registering ephemeral accounts for spam, whose sign-up we don't rate limit. |