summary refs log tree commit diff
path: root/synapse/storage/databases/main/schema/delta/58
diff options
context:
space:
mode:
authorRichard van der Hoff <richard@matrix.org>2020-09-06 23:32:28 +0100
committerRichard van der Hoff <richard@matrix.org>2020-09-06 23:32:28 +0100
commit77b4711bc28c6e1c2c56ae564f93985d21419251 (patch)
tree7308cff3630d81cd97cf9eadb88aeafa6d997b5c /synapse/storage/databases/main/schema/delta/58
parentIn light of #8255, use BIGINTs for destination_rooms (#8256) (diff)
parentAdd cross-signing sigs to the `keys` object (#8234) (diff)
downloadsynapse-77b4711bc28c6e1c2c56ae564f93985d21419251.tar.xz
Merge branch 'release-v1.20.0' into develop
Diffstat (limited to 'synapse/storage/databases/main/schema/delta/58')
-rw-r--r--synapse/storage/databases/main/schema/delta/58/15unread_count.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/synapse/storage/databases/main/schema/delta/58/15unread_count.sql b/synapse/storage/databases/main/schema/delta/58/15unread_count.sql
index b451e8663a..317fba8a5d 100644
--- a/synapse/storage/databases/main/schema/delta/58/15unread_count.sql
+++ b/synapse/storage/databases/main/schema/delta/58/15unread_count.sql
@@ -19,8 +19,8 @@
 
 -- Add columns to event_push_actions and event_push_actions_staging to track unread
 -- messages and calculate unread counts.
-ALTER TABLE event_push_actions_staging ADD COLUMN unread SMALLINT NOT NULL DEFAULT 0;
-ALTER TABLE event_push_actions ADD COLUMN unread SMALLINT NOT NULL DEFAULT 0;
+ALTER TABLE event_push_actions_staging ADD COLUMN unread SMALLINT;
+ALTER TABLE event_push_actions ADD COLUMN unread SMALLINT;
 
 -- Add column to event_push_summary
-ALTER TABLE event_push_summary ADD COLUMN unread_count BIGINT NOT NULL DEFAULT 0;
\ No newline at end of file
+ALTER TABLE event_push_summary ADD COLUMN unread_count BIGINT;
\ No newline at end of file