From 3a46874407521c79c8355e0465cf9d6ca520feeb Mon Sep 17 00:00:00 2001
From: Matthew Hodgson <matthew@matrix.org>
Date: Wed, 22 Aug 2018 18:44:05 +0200
Subject: add default for first_active column

---
 synapse/storage/schema/delta/52/free_mau.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'synapse/storage/schema/delta/52/free_mau.sql')

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);
-- 
cgit 1.5.1

