summary refs log tree commit diff
path: root/synapse/storage/schema (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Implement configurable stats reportingDaniel Wagner-Hall2015-09-221-0/+22
| | | | | | | | | | SYN-287 This requires that HS owners either opt in or out of stats reporting. When --generate-config is passed, --report-stats must be specified If an already-generated config is used, and doesn't have the report_stats key, it is requested to be set.
* 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
|\ | | | | | | | | Conflicts: synapse/rest/client/v1/login.py
| * Merge pull request #211 from matrix-org/email_in_useMark Haines2015-08-201-0/+19
| |\ | | | | | | Changes for unique emails
| | * Add endpoint that proxies ID server request token and errors if the given ↵David Baker2015-08-041-0/+19
| | | | | | | | | | | | email is in use on this Home Server.
* | | /tokenrefresh POST endpointDaniel Wagner-Hall2015-08-201-0/+21
|/ / | | | | | | | | | | | | | | This allows refresh tokens to be exchanged for (access_token, refresh_token). It also starts issuing them on login, though no clients currently interpret them.
* / 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
| | | | give the python db upgrade scripts the database engine so they can convert parameter strings, and add *args **kwargs to the upgrade function so we can add more args in future and previous scripts will ignore them.
* 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
|\ | | | | | | | | Conflicts: synapse/config/homeserver.py
| * 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
| | |\ | | | | | | | | Client / Server Auth Refactor
| | | * 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
| | | | | | | | | | | | | | | | | | | | flag in the API.
| | | * | 1) Pushers are now associated with an access tokenDavid Baker2015-03-241-0/+2
| | | | | | | | | | | | | | | | | | | | 2) Change places where we mean unauthenticated to 401, not 403, in C/S v2: hack so it stays as 403 in v1 because web client relies on it.
| * | | | Use TEXT instead of VARCHAR(n), since PostgreSQL treats them the same except ↵Erik Johnston2015-04-2832-289/+289
| | | | | | | | | | | | | | | | | | | | for a limit
| * | | | 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
| | | | | | | | | | | | | | | | | | | | columns back to TEXT from bytea
| * | | | 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 ↵Erik Johnston2015-04-152-0/+2
| | | | | | | | | | | | | | | | | | | | ORDER BY clauses
| * | | | Rename user_ips.user -> user_idErik Johnston2015-04-142-6/+6
| | | | |
| * | | | Add support for postgres instead of mysql. Change sql accourdingly. blob + ↵Erik Johnston2015-04-1413-105/+103
| | | | | | | | | | | | | | | | | | | | varbinary -> bytea. No support for UNSIGNED or CREATE INDEX IF NOT EXISTS.
| * | | | 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
| |\ | | | | | | | | | | | | Conflicts: synapse/storage/schema/pusher.sql
| * | 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
|\ | | | | Application Services
| * Merge branch 'develop' into application-servicesKegan Dougal2015-02-092-24/+11
| |\
| * | Register a user account for the AS when the AS registers. Add 'sender' ↵Kegan Dougal2015-02-092-0/+2
| | | | | | | | | | | | column to AS table.
| * | 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
| |\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: synapse/handlers/__init__.py synapse/storage/__init__.py
| * | | | Add basic application_services SQL, and hook up parts of the appservice ↵Kegan Dougal2015-01-281-0/+32
| | | | | | | | | | | | | | | | | | | | store to read from it.
* | | | | 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
|\ \ | | | | | | | | | | | | Conflicts: synapse/storage/__init__.py
| * \ 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 ↵Kegan Dougal2015-01-281-1/+1
| | | | | | | | | | | | | | | | of the filter, rather than the complete json
| * | | 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
|\ \ \ | | |/ | |/| | | | | | | | | | Conflicts: synapse/storage/__init__.py synapse/storage/schema/delta/v12.sql
| * | 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 ↵David Baker2015-01-202-0/+2
| | | | | | | | | | | | the push token changes.
| * | Require device language when adding a pusher.David Baker2015-01-162-0/+2
| | | | | | | | | | | | | | | Because this seems like it might be useful to do sooner rather than later.
| * | Honour the 'rejected' return from push gatewaysDavid Baker2015-01-132-0/+2
| | | | | | | | | | | | | | | | | | | | | Add a timestamp to push tokens so we know the last time they we got them from the device. Send it to the push gateways so it can determine whether its failure is more recent than the token. Stop and remove pushers that have been rejected.
| * | Merge branch 'develop' into pushersDavid Baker2015-01-1320-15/+88
| |\|
| * | Merge branch 'develop' into pushersDavid Baker2014-12-185-1/+168
| |\ \ | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: synapse/api/errors.py synapse/server.py synapse/storage/__init__.py
| * | | 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 ↵David Baker2014-11-212-0/+4
| | | | | | | | | | | | | | | | | | | | pokes work or not yet but the retry semantics are pretty good.
| * | | | Start creating a module to do generic notifications (just prints them to ↵David Baker2014-11-192-0/+56
| | | | | | | | | | | | | | | | | | | | stdout currently!)
* | | | | 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
|\ \ \ | | | | | | | | | | | | | | | | Conflicts: setup.py
| * \ \ 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 ↵Matthew Hodgson2014-12-072-0/+29
| | |/ | |/| | | | | | | sending transactions. does *not* yet retry transactions, but drops them on the floor if waiting for a server to recover.
* / | 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
| | | | | `prev_state` is now a list of previous state ids, similiar to prev_events. `replace_state` now points to what we think was replaced.
* 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 ↵Erik Johnston2014-10-271-0/+66
|\ | | | | | | | | | | | | federation_authorization Conflicts: synapse/storage/__init__.py
| * Merge branch 'develop' into event_signingMark Haines2014-10-271-0/+31
| |\
| * | Hash the same content covered by the signature when referencing previous ↵Mark Haines2014-10-171-2/+16
| | | | | | | | | | | | PDUs rather than reusing the PDU content hashes
| * | 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 ↵Erik Johnston2014-10-271-0/+31
|\ \ \ | | |/ | |/| | | | | | | | | | | | | | | | federation_authorization Conflicts: synapse/federation/transport.py synapse/handlers/message.py
| * | 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
| | | | | | | | | | | | schema
| * | 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
|\ | | | | | | | | | | Conflicts: synapse/storage/__init__.py tests/rest/test_presence.py
| * 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 ↵Erik Johnston2014-09-231-0/+4
| | | | | | | | | | | | levels event SYN-12 # comment Auth has been added.
| * Add m.room.deletion. If an event is deleted it will be returned to clients ↵Erik Johnston2014-09-231-2/+4
| | | | | | | | 'pruned', i.e. all client specified keys will be removed.
| * 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 ↵Matthew Hodgson2014-09-0310-10/+10
| | | | hasn't been incorporated in time for launch.
* Store SQL DDL deltas as well; attempt to upgrade the database on startup if ↵Paul "LeoNerd" Evans2014-09-031-0/+168
| | | | it's too old
* 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 ↵Erik Johnston2014-09-011-0/+20
| | | | | | | | send_evnet_level/add_state_level events.
* | Start adding storage for new events.Erik Johnston2014-08-291-0/+32
|/
* Add a unique constraint on the room hosts tableErik Johnston2014-08-241-1/+2
|
* Add indices to schemaErik Johnston2014-08-221-0/+20
|
* Don't return state event outlier's when paginating.Erik Johnston2014-08-221-0/+1
|
* Change the way pagination works to support out of order events.Erik Johnston2014-08-191-1/+1
|
* SQL doesn't allow AUTOINCREMENT on non PRIMARY KEY columns.Erik Johnston2014-08-181-1/+1
|
* Add two different columns for ordering the events table, one which can be ↵Erik Johnston2014-08-181-5/+8
| | | | used for pagination and one which can be as tokens for notifying clients. Also add a 'processed' field which is currently always set to True
* Start chagning the events stream to work with the new DB schemaErik Johnston2014-08-151-1/+4
|
* Reimplement the get public rooms api to work with new DB schemaErik Johnston2014-08-151-0/+12
|
* Fix up typos and correct sql queriesErik Johnston2014-08-141-2/+2
|
* Fix up RoomMemberStore to work with the new schema.Erik Johnston2014-08-141-1/+5
|
* Merge branch 'master' of github.com:matrix-org/synapse into sql_refactorErik Johnston2014-08-141-0/+1
|\ | | | | | | | | Conflicts: synapse/storage/_base.py
| * An initial hack at storing presence state-change mtimes in database and ↵Paul "LeoNerd" Evans2014-08-131-0/+1
| | | | | | | | presenting age durations to clients/federation events
* | Make feedback table also store sender.Erik Johnston2014-08-131-1/+2
| |
* | Initial stab at refactoring the SQL tables, including rejigging some of the ↵Erik Johnston2014-08-131-6/+5
| | | | | | | | storage layer.
* | Convert im schema to a 'one' table structureErik Johnston2014-08-131-26/+31
|/
* Reference Matrix Home Servermatrix.org2014-08-128-0/+352
generated by cgit-pink 1.4.1 (git 2.36.1) at 2024-11-28 11:40:38 +0000