1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/data_stores/main/schema/delta/59/00push_summary_unread_count.sql b/synapse/storage/data_stores/main/schema/delta/59/00push_summary_unread_count.sql
index 2985160201..560858d88b 100644
--- a/synapse/storage/data_stores/main/schema/delta/59/00push_summary_unread_count.sql
+++ b/synapse/storage/data_stores/main/schema/delta/59/00push_summary_unread_count.sql
@@ -15,4 +15,4 @@
 
 -- Store the number of unread messages, i.e. messages that triggered either a notify
 -- action or a mark_unread one.
-ALTER TABLE event_push_summary ADD COLUMN unread_count BIGINT NOT NULL;
+ALTER TABLE event_push_summary ADD COLUMN unread_count BIGINT NOT NULL DEFAULT 0;