add default for first_active column

1 files changed, 1 insertions, 1 deletions

diff --git a/synapse/storage/schema/delta/52/free_mau.sql b/synapse/storage/schema/delta/52/free_mau.sql

index c7b1d17fcc..2dae3087cc 100644
--- a/synapse/storage/schema/delta/52/free_mau.sql
+++ b/synapse/storage/schema/delta/52/free_mau.sql
@@ -13,6 +13,6 @@
  * limitations under the License.
  */
 
-ALTER TABLE monthly_active_users ADD COLUMN first_active BIGINT NOT NULL;
+ALTER TABLE monthly_active_users ADD COLUMN first_active BIGINT DEFAULT 0 NOT NULL;
 
 CREATE INDEX monthly_active_users_first_active ON monthly_active_users(first_active);