summary refs log tree commit diff
path: root/synapse/storage/schema (follow)
Commit message (Expand)AuthorAgeFilesLines
* 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
* | 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
* Make the device id on e2e key upload optionalRichard van der Hoff2016-07-261-0/+19
* Implement deleting devicesRichard van der Hoff2016-07-262-0/+34
* Create index on user_ips in the backgroundRichard van der Hoff2016-07-221-1/+2
* GET /devices endpointRichard van der Hoff2016-07-201-0/+16
* Merge pull request #922 from matrix-org/erikj/file_api2Erik Johnston2016-07-201-0/+60
|\
| * Add sender and contains_url field to events tableErik Johnston2016-07-141-0/+60
* | schema fixRichard van der Hoff2016-07-191-1/+1
* | Add device_id support to /loginRichard van der Hoff2016-07-182-0/+37
|/
* Track approximate last access time for remote mediaErik Johnston2016-06-291-0/+31
* Fix synapse/storage/schema/delta/30/as_users.pyMark Haines2016-05-311-2/+2
* Remove topics tableErik Johnston2016-05-131-1/+0
* Annotate the removed indicies with why they were removed.Mark Haines2016-05-131-18/+15
* Remove unused indicesErik Johnston2016-05-131-0/+42
* unbreak schemaMatrix2016-05-102-0/+0
* Merge remote-tracking branch 'origin/develop' into dbkr/email_notifsDavid Baker2016-05-102-0/+34
|\
| * Add an openidish mechanism for proving to third parties that you own a given ...Mark Haines2016-05-051-0/+9
| * Add primary keyErik Johnston2016-05-041-1/+1
| * Add timestamp and auto incrementing IDErik Johnston2016-05-041-0/+2
| * Add /report endpointErik Johnston2016-05-041-0/+23
* | Merge remote-tracking branch 'origin/develop' into dbkr/email_notifsDavid Baker2016-04-291-0/+65
|\|
| * Order NULLs firstErik Johnston2016-04-211-2/+2
| * Use special UPDATE syntaxErik Johnston2016-04-211-2/+2
| * Create index concurrentlyErik Johnston2016-04-211-5/+1
| * Add missing run_upgradeErik Johnston2016-04-211-0/+4
| * Optimise event_search in postgresErik Johnston2016-04-211-0/+65
* | First bits of emailpusherDavid Baker2016-04-192-0/+39
|/
* Add indexErik Johnston2016-04-141-0/+18
* Merge pull request #705 from matrix-org/dbkr/pushers_use_event_actionsDavid Baker2016-04-111-0/+79
|\
| * pep8David Baker2016-04-071-0/+1
| * Fix port script for changes merged from developDavid Baker2016-04-071-1/+4
| * Merge remote-tracking branch 'origin/develop' into dbkr/pushers_use_event_act...David Baker2016-04-075-5/+23
| |\
| * | Make pushers use the event_push_actions table instead of listening on an even...David Baker2016-04-061-0/+75
* | | move local_media_repository_url_cache.sql to schema v31Matthew Hodgson2016-04-081-0/+0
* | | Merge branch 'develop' into matthew/preview_urlsMatthew Hodgson2016-04-076-5/+65
|\ \ \ | | |/ | |/|
| * | Don't require config to create databaseErik Johnston2016-04-065-5/+23
| |/
| * Docs and indentsErik Johnston2016-04-041-11/+11
| * Add upgrade path, rename tableErik Johnston2016-04-041-3/+17
| * Store invites in a separate table.Erik Johnston2016-04-041-0/+28
* | Merge branch 'develop' into matthew/preview_urlsMatthew Hodgson2016-04-041-0/+38
|\|
| * Add replication streams for ex outliers and current state resetsMark Haines2016-03-301-0/+38
* | add a persistent cache of URL lookups, and fix up the in-memory one to workMatthew Hodgson2016-04-031-0/+27
|/
* Comment about weird SQLErik Johnston2016-03-231-1/+3
* SQLite and postgres doesn't share a true literalErik Johnston2016-03-231-1/+1
* Ensure all old public rooms have aliasesErik Johnston2016-03-231-0/+21
* Add a comment to offer a hint to an explanation for why we have a unique cons...Mark Haines2016-03-161-0/+1
* Add replication stream for pushersMark Haines2016-03-151-0/+24
* Update users table in a batched mannerErik Johnston2016-03-101-9/+14
* Merge branch 'develop' into daniel/ickDaniel Wagner-Hall2016-03-082-0/+54
|\
| * s/stream_ordering/event_stream_ordering/ in pushMark Haines2016-03-041-1/+1
| * Merge branch 'develop' into markjh/pushrule_streamMark Haines2016-03-042-0/+75
| |\
| | * Merge pull request #614 from matrix-org/erikj/alias_deleteErik Johnston2016-03-041-0/+16
| | |\
| | | * Allow alias creators to delete aliasesErik Johnston2016-03-011-0/+16
| * | | Add a stream for push rule updatesMark Haines2016-03-011-0/+38
| | |/ | |/|
* | | Idempotent-ise schema update scriptDaniel Wagner-Hall2016-03-081-1/+5
| |/ |/|
* | Merge pull request #571 from matrix-org/daniel/asidsDaniel Wagner-Hall2016-03-031-0/+59
|\ \ | |/ |/|
| * Mark AS users with their AS's IDDaniel Wagner-Hall2016-02-111-0/+59
* | Generate guest access token on 3pid invitesDaniel Wagner-Hall2016-02-241-0/+24
* | Prefix TS fields with _tsErik Johnston2016-02-181-3/+3
* | Initial cutErik Johnston2016-02-171-0/+30
|/
* Merge pull request #554 from matrix-org/erikj/event_pushErik Johnston2016-02-031-0/+31
|\
| * Change event_push_actions_rm_tokens schemaErik Johnston2016-02-031-0/+31
* | Change the way we do public room list fetchingErik Johnston2016-02-021-0/+16
|/
* Add events indexErik Johnston2016-01-281-0/+16
* Add index to event_push_actionsErik Johnston2016-01-251-0/+1
* Add index by user id on receipts_linearizedDavid Baker2016-01-201-0/+18
* Remove rogue 'admin'David Baker2016-01-111-1/+1
* Merge pull request #456 from matrix-org/store_event_actionsDavid Baker2016-01-082-0/+48
|\
| * Add schema change file for is_guest flagDavid Baker2016-01-061-0/+22
| * Add is_guest flag to users db to track whether a user is a guest user or not....David Baker2016-01-061-0/+0
| * Merge remote-tracking branch 'origin/develop' into store_event_actionsDavid Baker2016-01-051-0/+21
| |\
| * | Rename event-actions to event_push_actions as per PR requestDavid Baker2016-01-041-2/+2
| * | still very WIP, but now sends unread_notifications_count in the room object o...David Baker2015-12-161-2/+3
| * | Save event actions to the dbDavid Baker2015-12-101-0/+25
* | | copyrightsMatthew Hodgson2016-01-0753-53/+53
| |/ |/|
* | Allow guests to upgrade their accountsDaniel Wagner-Hall2016-01-051-0/+21
|/
* Bump schema version.Mark Haines2015-12-044-23/+36
* Merge pull request #414 from matrix-org/erikj/if_not_existsErik Johnston2015-12-031-1/+1
|\
| * Older versions of SQLite don't like IF NOT EXISTS in virtual tablesErik Johnston2015-12-021-1/+1
* | Just replace the table definition with the one from full_schema 16David Baker2015-12-021-11/+10
* | Fix schema delta 15 on postgres in the very unlikley event that anyone upgrad...David Baker2015-12-021-1/+1
|/
* Add API for setting account_data globaly or on a per room basisMark Haines2015-12-011-0/+23
* Allow paginating search ordered by recentsErik Johnston2015-11-301-0/+57
* Remove size specifier for database columnDaniel Wagner-Hall2015-11-231-1/+3
* Merge branch 'develop' into daniel/forgetroomsPaul "LeoNerd" Evans2015-11-191-0/+17
|\
| * Rename the database tableMark Haines2015-11-181-0/+17
* | Allow users to forget roomsDaniel Wagner-Hall2015-11-171-0/+24
|/
* Merge pull request #359 from matrix-org/markjh/incremental_indexingErik Johnston2015-11-112-75/+47
|\
| * Fix param style to work on both sqlite and postgresMark Haines2015-11-111-2/+6
| * Fix the background updateMark Haines2015-11-111-4/+3
| * Use a background task to update databases to use the full text searchMark Haines2015-11-101-76/+24
| * Add storage module for tracking background updates.Mark Haines2015-11-091-0/+21
* | Return world_readable and guest_can_join in /publicRoomsDaniel Wagner-Hall2015-11-101-0/+25
|/
* Remove accidentally added ID columnDaniel Wagner-Hall2015-11-061-1/+0
* Open up /events to anonymous users for room events onlyDaniel Wagner-Hall2015-11-051-0/+26
* Merge pull request #335 from matrix-org/markjh/room_tagsMark Haines2015-11-031-0/+38
|\
| * Store room tag content and return the content in the m.tag eventMark Haines2015-11-021-0/+1
| * Add APIs for adding and removing tags from roomsMark Haines2015-10-281-0/+37
* | Add missing columnDaniel Wagner-Hall2015-10-301-1/+1
|/
* Pull out sender when computing search resultsErik Johnston2015-10-231-14/+17
* Implement rank function for SQLite FTSErik Johnston2015-10-231-1/+1
* PEP8Erik Johnston2015-10-221-1/+2
* Move FTS to delta 25Erik Johnston2015-10-221-2/+2
* Split up run_upgradeErik Johnston2015-10-161-5/+11
* Merge branch 'erikj/store_engine' into erikj/searchErik Johnston2015-10-131-1/+1
|\
* | Merge branch 'erikj/store_engine' into erikj/searchErik Johnston2015-10-131-1/+1
|\|
* | Add sqlite schemaErik Johnston2015-10-131-5/+64
* | Keep FTS indexes up to date. Only search through rooms currently joinedErik Johnston2015-10-121-1/+2
* | Add basic full text search impl.Erik Johnston2015-10-091-0/+57
|/
* Implement configurable stats reportingDaniel Wagner-Hall2015-09-221-0/+22
* Drop unused indexErik Johnston2015-09-141-0/+16
* Remove autoincrement since we incrementing the ID in the storage layerMark Haines2015-08-241-1/+1
* Merge branch 'develop' into refreshDaniel Wagner-Hall2015-08-201-0/+19
|\
| * Merge pull request #211 from matrix-org/email_in_useMark Haines2015-08-201-0/+19
| |\
| | * Add endpoint that proxies ID server request token and errors if the given ema...David Baker2015-08-041-0/+19