From 3a46874407521c79c8355e0465cf9d6ca520feeb Mon Sep 17 00:00:00 2001 From: Matthew Hodgson 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(-) 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.4.1