summary refs log tree commit diff
path: root/synapse/storage/schema (follow)
Commit message (Expand)AuthorAgeFilesLines
* Add replication streams for ex outliers and current state resetsMark Haines2016-03-301-0/+38
* 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
| * | | Rename the pusher SQL delta to v9 which the next free oneDavid Baker2014-12-181-0/+0
| * | | after a few rethinks, a working implementation of pushers.David Baker2014-12-182-4/+2
| * | | Update to app_id / app_instance_id (partially) and mangle to be PEP8 compliant.David Baker2014-12-032-4/+6
| * | | Merge branch 'develop' into pushersDavid Baker2014-12-022-1/+35
| |\ \ \
| * | | | More work on pushers. Attempt to do HTTP pokes. Not sure if the actual HTTP p...David Baker2014-11-212-0/+4
| * | | | Start creating a module to do generic notifications (just prints them to stdo...David Baker2014-11-192-0/+56
* | | | | Add support for storing rejected events in EventContext and data storesErik Johnston2015-01-222-0/+28
| |_|_|/ |/| | |
* | | | Add delta and bump DB versionErik Johnston2015-01-061-0/+16
* | | | Add index on transaction_id to sent_transcationsErik Johnston2015-01-061-0/+1
* | | | Update copyright noticesMark Haines2015-01-0619-15/+71
| |_|/ |/| |
* | | Fix upgrade script to run all the missing deltas.Erik Johnston2014-12-161-1/+57
* | | Persist internal_metadataErik Johnston2014-12-161-0/+1
* | | Merge branch 'develop' of github.com:matrix-org/synapse into events_refactorErik Johnston2014-12-111-0/+68
|\ \ \
| * \ \ Merge branch 'develop' into media_repositoryMark Haines2014-12-102-0/+29
| |\ \ \
| * \ \ \ Merge branch 'develop' into media_repositoryMark Haines2014-12-102-1/+35
| |\ \ \ \ | | | |_|/ | | |/| |
| * | | | Add a method field to thumbnail storageMark Haines2014-12-051-1/+3
| * | | | Write the upload portion of version 1 of the media repositoryMark Haines2014-12-021-0/+66
| | |_|/ | |/| |
* | | | Fix bug where we clobbered old state group valuesErik Johnston2014-12-101-1/+2
* | | | Fix bug when uploading state with empty state_keyErik Johnston2014-12-101-0/+2
* | | | Merge branch 'develop' of github.com:matrix-org/synapse into events_refactorErik Johnston2014-12-102-0/+29
|\ \ \ \ | | |_|/ | |/| |
| * | | track replication destination health, and perform exponential back-off when s...Matthew Hodgson2014-12-072-0/+29
| | |/ | |/|
* / | Store full JSON of events in dbErik Johnston2014-12-011-0/+10
|/ /
* | Add update delta for schema changeErik Johnston2014-11-261-0/+34
* | Update schema to support multiple signaturesErik Johnston2014-11-261-1/+1
|/
* Store all signatures on events rather than just dropping themErik Johnston2014-11-121-3/+3
* Add indices to state group tablesErik Johnston2014-11-121-0/+13
* Tidy up some of the unused sql tablesErik Johnston2014-11-101-62/+6
* Start implementing auth chainsErik Johnston2014-11-071-0/+10
* Implement new replace_state and changed prev_stateErik Johnston2014-11-061-12/+28
* Remove unused sql file.Erik Johnston2014-10-311-31/+0
* Remove more references to dead PDU tablesErik Johnston2014-10-311-66/+0
* Remove PDU tables.Erik Johnston2014-10-311-106/+0
* Start filling out and using new events tablesErik Johnston2014-10-291-5/+3
* Begin implementing all the PDU storage stuff in Events landErik Johnston2014-10-283-0/+117
* Merge branch 'event_signing' of github.com:matrix-org/synapse into federation...Erik Johnston2014-10-271-0/+66
|\
| * Merge branch 'develop' into event_signingMark Haines2014-10-271-0/+31
| |\
| * | Hash the same content covered by the signature when referencing previous PDUs...Mark Haines2014-10-171-2/+16
| * | Include hashes of previous pdus when referencing themMark Haines2014-10-161-0/+16
| * | persist hashes and origin signatures for PDUsMark Haines2014-10-151-2/+2
| * | Storage for pdu signaturesMark Haines2014-10-141-0/+36
* | | Merge branch 'develop' of github.com:matrix-org/synapse into federation_autho...Erik Johnston2014-10-271-0/+31
|\ \ \ | | |/ | |/|
| * | Bump database version number.Erik Johnston2014-10-171-0/+31
| * | keep 'origin_server_ts' as 'ts' in the database to avoid needlessly updating ...Mark Haines2014-10-172-3/+3
| * | SPEC-7: Rename 'ts' to 'origin_server_ts'Mark Haines2014-10-172-3/+3
| |/
* | Begin making auth use event.old_state_eventsErik Johnston2014-10-151-1/+1
* | Begin implementing state groups.Erik Johnston2014-10-141-0/+33
|/
* Merge branch 'develop' into server2server_signingMark Haines2014-09-305-1/+52
|\
| * SYN-48: Implement WHOIS rest servletErik Johnston2014-09-292-2/+4
| * SYN-48: Track User-Agents as well as IPs for client devices.Erik Johnston2014-09-292-2/+6
| * Track the IP users connect with. Add an admin column to users table.Erik Johnston2014-09-262-0/+24
| * Rename deletions to redactionsErik Johnston2014-09-244-13/+15
| * Add v4 deltas to current sql.Erik Johnston2014-09-242-1/+9
| * SYN-12: Implement auth for deletion by adding a 'delete_level' on the ops lev...Erik Johnston2014-09-231-0/+4
| * Add m.room.deletion. If an event is deleted it will be returned to clients 'p...Erik Johnston2014-09-231-2/+4
| * Add a deletions tableErik Johnston2014-09-221-0/+5
* | SYN-75 Verify signatures on server to server transactionsMark Haines2014-09-301-6/+7
|/
* Generate m.room.aliases event when the HS creates a room aliasErik Johnston2014-09-051-0/+27
* fix the copyright holder from matrix.org to OpenMarket Ltd, as matrix.org has...Matthew Hodgson2014-09-0310-10/+10
* Store SQL DDL deltas as well; attempt to upgrade the database on startup if i...Paul "LeoNerd" Evans2014-09-031-0/+168
* Add copyright notices and fix pyflakes errorsMark Haines2014-09-031-0/+15
* Merge branch 'develop' of github.com:matrix-org/synapse into room_configErik Johnston2014-09-011-0/+30
|\
| * Add store for server certificates and keysMark Haines2014-08-281-0/+30
* | Add all the necessary checks to make banning work.Erik Johnston2014-09-011-1/+1
* | Add beginnings of ban support.Erik Johnston2014-09-011-0/+11
* | Implement power level lists, default power levels and send_evnet_level/add_st...Erik Johnston2014-09-011-0/+20