summary refs log tree commit diff
path: root/synapse/storage/schema (follow)
Commit message (Collapse)AuthorAgeFilesLines
* 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
| | | | | 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 Johnston2016-10-271-19/+11
|
* Fix user_threepids schema deltaErik Johnston2016-10-271-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 37David Baker2016-10-191-0/+0
|
* Merge remote-tracking branch 'origin/develop' into ↵David Baker2016-10-191-0/+81
|\ | | | | | | dbkr/password_reset_case_insensitive
| * 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
| | | | | | | | | | | | And db migration sql to convert existing addresses.
* | | 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 ↵Erik Johnston2016-09-126-0/+24
|\ | | | | | | erikj/make_notif_highlight_query_fast
| * 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 ↵David Baker2016-09-093-0/+80
|\ | | | | | | dbkr/make_notif_highlight_query_fast
| * 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
| | | | | | | | inbox table
| * Merge pull request #1087 from matrix-org/markjh/reapply_deltaMark Haines2016-09-091-1/+4
| |\ | | | | | | Reapply 34/device_outbox in 35/device_outbox_again.py since the schem…
| | * 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 ↵Mark Haines2016-09-081-0/+30
| | | | | | | | | | | | bumped before it landed on develop
| * | 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
| | | | | | | | | | | | | | | 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_actionsDavid Baker2016-09-091-0/+18
| |/ |/| | | | | | | | | and remove room_id caluse so it uses it Mostly from @negativemjark
* | 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
| | | | | | | | | 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 updateErik Johnston2016-08-171-0/+3
|
* Add migration scriptDavid Baker2016-08-161-0/+17
| | | | To port existing rule actions & enable entries to the new name
* 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
| | | | | | 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 fixRichard van der Hoff2016-07-271-1/+1
|
* Make the device id on e2e key upload optionalRichard van der Hoff2016-07-261-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 devicesRichard van der Hoff2016-07-262-0/+34
|
* Create index on user_ips in the backgroundRichard van der Hoff2016-07-221-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 endpointRichard van der Hoff2016-07-201-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_api2Erik Johnston2016-07-201-0/+60
|\ | | | | Feature: Add filter to /messages. Add 'contains_url' to filter.
| * Add sender and contains_url field to events tableErik Johnston2016-07-141-0/+60
| |
* | schema fixRichard van der Hoff2016-07-191-1/+1
| | | | | | | | device_id should be text, not bigint.
* | Add device_id support to /loginRichard van der Hoff2016-07-182-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 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
| | | | | This includes removing both unused indices and indices that are subsets of other indices.
* 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
| | | | | | | | user_id
| * 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
|/ | | | Mostly logic of when to send an email
* Add indexErik Johnston2016-04-141-0/+18
|
* Merge pull request #705 from matrix-org/dbkr/pushers_use_event_actionsDavid Baker2016-04-111-0/+79
|\ | | | | Change pushers to use the event_actions table
| * 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 ↵David Baker2016-04-075-5/+23
| |\ | | | | | | | | | dbkr/pushers_use_event_actions
| * | Make pushers use the event_push_actions table instead of listening on an ↵David Baker2016-04-061-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 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 ↵Mark Haines2016-03-161-0/+1
| | | | constraint on (app_id, pushkey, user_id)
* 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 aliases
| | | * 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
| |/ |/| | | | | | | 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/asidsDaniel Wagner-Hall2016-03-031-0/+59
|\ \ | |/ |/| Mark AS users with their AS's ID
| * 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
| | | | | | | | | | | | | | | | | | 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.
* | 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 schema
| * 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
|\ | | | | Send unread notification counts
| * 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 ↵David Baker2016-01-061-0/+0
| | | | | | | | not. Use this so we can run _filter_events_for_client when calculating event_push_actions.
| * 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 ↵David Baker2015-12-161-2/+3
| | | | | | | | | | | | on sync (only actually corrrect in a full sync: hardcoded to 0 in incremental syncs).
| * | 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
| | | | As we released version 26 in v0.11.1
* 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 tables
| * 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 ↵David Baker2015-12-021-1/+1
|/ | | | upgrades to 15...
* 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
| | | | | | Postgres doesn't support them like this. We don't have a bool type in common between postgres and sqlite.
* 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
|\ | | | | Incremental background updates for db indexes
| * 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
| | | | | | | | | | | | | | The progress for each background update is stored as a JSON blob in the database. Each background update is broken up into separate batches. The batch size is automatically tuned to try avoid blocking single threaded databases for too long.
* | 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
| | | | Squash-merge of PR #345 from daniel/anonymousevents
* Merge pull request #335 from matrix-org/markjh/room_tagsMark Haines2015-11-031-0/+38
|\ | | | | Add APIs for adding and removing tags from rooms
| * 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
| | | | | | | | | | 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
|/
generated by cgit-pink 1.4.1 (git 2.36.1) at 2024-11-20 05:27:42 +0000