diff options
| author | Erik Johnston <erikj@jki.re> | 2019-04-10 10:22:35 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-04-10 10:22:35 +0100 |
| commit | e446921deffd976bdb123ef80a518019fe2272ad (patch) | |
| tree | 2796a39c131ded7b85e058b29efc558ab14efd27 | |
| parent | Fix disappearing exceptions in manhole. (#5035) (diff) | |
| parent | Newsfile (diff) | |
| download | synapse-e446921deffd976bdb123ef80a518019fe2272ad.tar.xz | |
Merge pull request #5033 from matrix-org/erikj/fix_schema_delta
Fix schema upgrade when dropping tables
| -rw-r--r-- | changelog.d/5033.misc | 1 | ||||
| -rw-r--r-- | synapse/storage/schema/delta/54/drop_legacy_tables.sql | 4 |
2 files changed, 4 insertions, 1 deletions
diff --git a/changelog.d/5033.misc b/changelog.d/5033.misc new file mode 100644 index 0000000000..3ee4228c09 --- /dev/null +++ b/changelog.d/5033.misc @@ -0,0 +1 @@ +Remove a number of unused tables from the database schema. diff --git a/synapse/storage/schema/delta/54/drop_legacy_tables.sql b/synapse/storage/schema/delta/54/drop_legacy_tables.sql index ecca005d9b..dbbe682697 100644 --- a/synapse/storage/schema/delta/54/drop_legacy_tables.sql +++ b/synapse/storage/schema/delta/54/drop_legacy_tables.sql @@ -13,8 +13,10 @@ * limitations under the License. */ -DROP TABLE IF EXISTS application_services; +-- we need to do this first due to foreign constraints DROP TABLE IF EXISTS application_services_regex; + +DROP TABLE IF EXISTS application_services; DROP TABLE IF EXISTS transaction_id_to_pdu; DROP TABLE IF EXISTS stats_reporting; DROP TABLE IF EXISTS current_state_resets; |