summary refs log tree commit diff
path: root/synapse/storage/schema (follow)
Commit message (Expand)AuthorAgeFilesLines
* 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
|\
| * 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
| |\
| * | Move to storing state_groups_state as deltasErik Johnston2016-09-011-0/+21
* | | Send device messages over federationMark Haines2016-09-061-3/+1
* | | Add tables for federated device messagesMark Haines2016-09-061-0/+38
| |/ |/|
* | Clean up old sent transactionsErik Johnston2016-08-311-0/+32
|/
* 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
* | | /tokenrefresh POST endpointDaniel Wagner-Hall2015-08-201-0/+21
|/ /
* / Add index receipts_linearized_room_streamErik Johnston2015-08-171-0/+18
|/
* Merge branch 'develop' of github.com:matrix-org/synapse into erikj/receiptsErik Johnston2015-07-131-0/+34
|\
| * Uniquely name unique constraintErik Johnston2015-07-101-2/+2
| * Don't bother with a timeout for one time keys on the server.Mark Haines2015-07-091-1/+0
| * Add store for client end to end keysMark Haines2015-07-061-0/+35
* | Change format of receipts to allow inclusion of dataErik Johnston2015-07-091-10/+6
* | Add stream_id indexErik Johnston2015-07-021-1/+5
* | Add basic storage functions for handling of receiptsErik Johnston2015-07-011-14/+17
* | Add tables for receiptsErik Johnston2015-06-301-0/+35
|/
* Add a dummy.sql into delta/20 as pip isn't packinging the pushers.pyErik Johnston2015-06-131-0/+1
* pep8David Baker2015-06-041-1/+0
* Add script to (re)convert the pushers table to changing the unique key. Also ...David Baker2015-06-042-1/+78
* Newline, remove debug loggingErik Johnston2015-05-181-1/+1
* Add index on eventsErik Johnston2015-05-131-0/+19
* Drop the old table not the new tableMark Haines2015-05-081-1/+1
* Rename unique constraintMark Haines2015-05-081-1/+1
* Remove unsignedMark Haines2015-05-081-2/+2
* Make the timestamps in server_keys_json bigintsMark Haines2015-05-081-0/+32
* Remove some unused indexesErik Johnston2015-05-011-0/+18
* Oops, update the contraint tooDavid Baker2015-04-291-1/+1
* Be more postgressiveDavid Baker2015-04-291-2/+2
* Be postgressiveDavid Baker2015-04-291-4/+3
* Oops, forgot the schema delta fileDavid Baker2015-04-291-0/+10
* pushers table requires an access_tokenErik Johnston2015-04-291-0/+1
* bump database schema versionMark Haines2015-04-291-0/+0
* Use bytea rather than BLOBMark Haines2015-04-291-1/+1
* Merge branch 'develop' into key_distributionMark Haines2015-04-2938-190/+1074
|\
| * Merge branch 'develop' of github.com:matrix-org/synapse into postgresErik Johnston2015-04-281-0/+25
| |\
| | * Merge pull request #126 from matrix-org/csauthMark Haines2015-04-281-0/+25
| | |\
| | | * Merge branch 'develop' into csauthDavid Baker2015-04-171-0/+30
| | | |\
| | | * | Allow multiple pushers for a single app ID & pushkey, honouring the 'append' ...David Baker2015-03-251-2/+25
| | | * | 1) Pushers are now associated with an access tokenDavid Baker2015-03-241-0/+2
| * | | | Use TEXT instead of VARCHAR(n), since PostgreSQL treats them the same except ...Erik Johnston2015-04-2832-289/+289
| * | | | Merge branch 'develop' of github.com:matrix-org/synapse into postgresErik Johnston2015-04-272-0/+28
| |\| | |
| * | | | Add unique index to room_aliases, remove duplicates on upgrade. Convert some ...Erik Johnston2015-04-177-4/+19
| * | | | Go back to storing JSON in TEXTErik Johnston2015-04-164-10/+10
| * | | | Remove mysql/maria supportErik Johnston2015-04-151-1/+1
| * | | | Change full_schemas/11 to work with postgresErik Johnston2015-04-1513-84/+90
| * | | | Add index on events (topological_ordering, stream_ordering) to help with ORDE...Erik Johnston2015-04-152-0/+2
| * | | | Rename user_ips.user -> user_idErik Johnston2015-04-142-6/+6
| * | | | Add support for postgres instead of mysql. Change sql accourdingly. blob + va...Erik Johnston2015-04-1413-105/+103
| * | | | For backwards compat, make state_groups.id have a type of int, not varcharErik Johnston2015-04-131-1/+1
| * | | | Remove duplicate rowsErik Johnston2015-04-101-0/+9
| * | | | DROP indexes before recreating themErik Johnston2015-04-102-1/+9
| * | | | Use LONGBLOB and TEXT for arbitary length rowsErik Johnston2015-04-1012-34/+34
| * | | | Use unsigned bigintErik Johnston2015-04-1019-50/+50
| * | | | SQLite wants INTEGER and not BIGINT for primary keysErik Johnston2015-04-106-9/+9
| * | | | Update full_schemas/16 to match delta files. Add delta/16 scriptsErik Johnston2015-04-106-0/+245
| * | | | Revert non-trivial changes to upgrade scriptsErik Johnston2015-04-103-5/+5
| * | | | Fix schema againErik Johnston2015-04-102-3/+3
| * | | | Revert non-trivial schema changes and move them to a new schema version.Erik Johnston2015-04-1019-27/+636
| * | | | Remove spurious spacesErik Johnston2015-04-0915-50/+50
| * | | | Merge branch 'develop' of github.com:matrix-org/synapse into mysqlErik Johnston2015-04-071-0/+31
| |\ \ \ \ | | | |_|/ | | |/| |
| * | | | Add index to presence tableErik Johnston2015-04-071-0/+2
| * | | | Don't use multiple UNIQUE constraints; it will cause deadlocksErik Johnston2015-04-072-6/+8
| * | | | Fix unicode supportErik Johnston2015-04-0216-145/+143
| * | | | Make work in both Maria and SQLite. Fix testsErik Johnston2015-04-0115-55/+55
| * | | | Fix unicode database supportErik Johnston2015-03-253-3/+2
| * | | | Fix up schemas some moreErik Johnston2015-03-203-3/+3
| * | | | Remove redundant keyErik Johnston2015-03-191-1/+0
| * | | | Fix up schemas to work with mariadbErik Johnston2015-03-1915-84/+82
| * | | | Update schema to work with mariadbErik Johnston2015-03-1816-256/+224
| | |_|/ | |/| |
* | | | Add server_keys.sql to the current delta rather than creating a new deltaMark Haines2015-04-281-0/+0
* | | | Merge branch 'develop' into key_distributionMark Haines2015-04-242-0/+28
|\ \ \ \ | | |_|/ | |/| |
| * | | Copyright noticesMark Haines2015-04-242-0/+28
| | |/ | |/|
* | | Add methods for storing and retrieving the raw key jsonMark Haines2015-04-151-3/+3
* | | Return a sha256 fingerprint rather than the entire tls certificateMark Haines2015-04-141-0/+24
|/ /
* | Edit SQL schema to use string IDs not ints. Use token as ID. Update tests.Kegan Dougal2015-03-311-4/+3
* | Use event IDs instead of dumping event content in the txns table.Kegan Dougal2015-03-091-1/+1
* | Finish appservice txn storage impl and tests.Kegan Dougal2015-03-091-1/+1
* | Merge branch 'develop' into application-services-txn-reliabilityKegan Dougal2015-03-061-0/+9
|\|
| * Schema change as delta in v14David Baker2015-03-061-0/+0
| * Merge branch 'develop' into pushrules2David Baker2015-03-0428-530/+53
| |\
| * | Add enable/disable overlay for push rules (REST API not yet hooked up)David Baker2015-02-252-0/+19
* | | Add appservice txns sql schemaKegan Dougal2015-03-061-0/+31
| |/ |/|
* | s/schema_deltas/applied_schema_deltas/Erik Johnston2015-03-041-2/+2
* | Add unique constraint on schema_version.lock schema. Use conflict clause in sql.Erik Johnston2015-03-041-1/+2
* | Change to use logger in db upgrade scriptErik Johnston2015-03-041-1/+4
* | Actually add full_schemas dirErik Johnston2015-03-0412-0/+645
* | More docs. Rename 'schema/current' to 'schema/full_schemas'Erik Johnston2015-03-0412-645/+0
* | SYN-67: Finish up implementing new database schema managementErik Johnston2015-03-0427-501/+30
|/
* Bump schema versionErik Johnston2015-02-171-0/+0
* Merge pull request #50 from matrix-org/application-servicesMark Haines2015-02-132-0/+68
|\
| * Merge branch 'develop' into application-servicesKegan Dougal2015-02-092-24/+11
| |\
| * | Register a user account for the AS when the AS registers. Add 'sender' column...Kegan Dougal2015-02-092-0/+2
| * | Add delta sql file.Kegan Dougal2015-02-051-0/+33
| * | Merge branch 'develop' into application-servicesKegan Dougal2015-02-052-2/+2
| |\ \
| * | | Add hs_token column and generate a different token f.e application service.Kegan Dougal2015-02-051-0/+1
| * | | Merge branch 'develop' into application-servicesKegan Dougal2015-02-025-0/+169
| |\ \ \
| * | | | Add basic application_services SQL, and hook up parts of the appservice store...Kegan Dougal2015-01-281-0/+32
* | | | | Set database schema version in deltaErik Johnston2015-02-121-0/+2
| |_|_|/ |/| | |
* | | | Move delta/v13.sql to delta/v12.sqlErik Johnston2015-02-062-24/+11
| |_|/ |/| |
* | | s/instance_handle/profile_tag/David Baker2015-02-032-2/+2
| |/ |/|
* | Merge branch 'develop' of github.com:matrix-org/synapse into rejections_storageErik Johnston2015-01-302-0/+48
|\ \
| * \ Merge changes from developMark Haines2015-01-292-0/+92
| |\ \
| * | | Move bump schema deltaMark Haines2015-01-291-0/+0
| * | | Also edit the filter column on the delta SQLKegan Dougal2015-01-291-1/+1
| * | | s/definition/filter_json/ since definition is now used to mean a component of...Kegan Dougal2015-01-281-1/+1
| * | | Created schema deltaPaul "LeoNerd" Evans2015-01-271-0/+24
| * | | Initial stab at real SQL storage implementation of user filter definitionsPaul "LeoNerd" Evans2015-01-271-0/+24
| | |/ | |/|
* | | Put CREATE rejections into seperate .sqlErik Johnston2015-01-302-7/+21
* | | Merge branch 'develop' of github.com:matrix-org/synapse into rejections_storageErik Johnston2015-01-302-0/+79
|\ \ \ | | |/ | |/|
| * | Move pushers delta to v12 and bump schema versionDavid Baker2015-01-281-0/+0
| * | Oops: second part of commit dc938606David Baker2015-01-222-0/+26
| * | add instance_handles to pushers so we have a way to refer to them even if the...David Baker2015-01-202-0/+2
| * | Require device language when adding a pusher.David Baker2015-01-162-0/+2
| * | Honour the 'rejected' return from push gatewaysDavid Baker2015-01-132-0/+2
| * | Merge branch 'develop' into pushersDavid Baker2015-01-1320-15/+88
| |\|
| * | Merge branch 'develop' into pushersDavid Baker2014-12-185-1/+168
| |\ \
| * | | schema version is now 10David Baker2014-12-181-0/+0