summary refs log tree commit diff
path: root/synapse/storage/schema/common (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Merge remote-tracking branch 'gitlab/clokep/license-license' into new_developErik Johnston2023-12-134-0/+76
|\
| * Update license headersPatrick Cloke2023-11-214-0/+76
| |
* | Revert postgres logical replication deltaas v1.98.0rc1David Robertson2023-12-055-5/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | This reverts two commits: 0bb8e418a41c6f583ca9d705b400e37e2308a534 "Fix postgres schema after dropping old tables (#16730)" and 51e4e35653f98c3f61222fbdbdb1dcb8864f7fca "Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one. This should allow use of Postgres logical replication. (take 2, now with no added deadlocks!) (#16658)" and also amends the changelog.
* | Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit ↵reivilibre2023-12-045-0/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | one. This should allow use of Postgres logical replication. (take 2, now with no added deadlocks!) (#16658) * Add `ALTER TABLE ... REPLICA IDENTITY ...` for individual tables We can't combine them into one file as it makes it likely to hit a deadlock if Synapse is running, as it only takes one other transaction to access two tables in a different order to the schema delta. * Add notes * Newsfile Signed-off-by: Olivier Wilkinson (reivilibre) <oliverw@matrix.org> * Re-introduce REPLICA IDENTITY test --------- Signed-off-by: Olivier Wilkinson (reivilibre) <oliverw@matrix.org>
* | Remove old full schema dumps. (#16697)Patrick Cloke2023-11-281-8/+0
|/ | | | These are not useful and make it difficult to search for table definitions, etc.
* Revert "Fix test not detecting tables with missing primary keys and missing ↵Erik Johnston2023-11-161-30/+0
| | | | | replica identities, then add more replica identities. (#16647)" (#16652) This reverts commit 830988ae72d63bbb67d2020a3f221664f3f456ee.
* Fix test not detecting tables with missing primary keys and missing replica ↵reivilibre2023-11-161-0/+30
| | | | | | | | | | | | | | | identities, then add more replica identities. (#16647) * Fix the CI query that did not detect all cases of missing primary keys * Add more missing REPLICA IDENTITY entries * Newsfile Signed-off-by: Olivier Wilkinson (reivilibre) <oliverw@matrix.org> --------- Signed-off-by: Olivier Wilkinson (reivilibre) <oliverw@matrix.org>
* Snapshot schema 72 (#13873)David Robertson2022-09-262-0/+14
| | | Including another batch of fixes to the schema dump script
* Support for database schema version ranges (#9933)Richard van der Hoff2021-06-111-0/+7
| | | This is essentially an implementation of the proposal made at https://hackmd.io/@richvdh/BJYXQMQHO, though the details have ended up looking slightly different.
* Reorganise the database schema directories (#9932)Richard van der Hoff2021-05-075-0/+99
The hope here is that by moving all the schema files into synapse/storage/schema, it gets a bit easier for newcomers to navigate. It certainly got easier for me to write a helpful README. There's more to do on that front, but I'll follow up with other PRs for that.
generated by cgit-magenta 1.5.1 (git 2.48.1) at 2025-08-09 12:30:05 +0000