# HG changeset patch
# User jbe
# Date 1460907401 -7200
# Node ID ab05fb3bf974a8c206124c196fb7db4c1a3cc6a7
# Parent  705097d1b1f3ee07623fa638b1043c5cd94a0485
Set column "notification_hour" of "member" table by default to random number

diff -r 705097d1b1f3 -r ab05fb3bf974 core.sql
--- a/core.sql	Sun Apr 17 15:14:14 2016 +0200
+++ b/core.sql	Sun Apr 17 17:36:41 2016 +0200
@@ -117,7 +117,7 @@
         "notification_counter"     INT4         NOT NULL DEFAULT 1,
         "notification_sample_size" INT4         NOT NULL DEFAULT 3,
         "notification_dow"         INT4         CHECK ("notification_dow" BETWEEN 0 AND 6),
-        "notification_hour"        INT4         CHECK ("notification_hour" BETWEEN 0 AND 23),
+        "notification_hour"        INT4         DEFAULT floor(random() * 24) CHECK ("notification_hour" BETWEEN 0 AND 23),
         "notification_sent"        TIMESTAMP,
         "login_recovery_expiry"        TIMESTAMPTZ,
         "password_reset_secret"        TEXT     UNIQUE,
diff -r 705097d1b1f3 -r ab05fb3bf974 update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 17 15:14:14 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 17 17:36:41 2016 +0200
@@ -8,7 +8,7 @@
 ALTER TABLE "member" ADD COLUMN "notification_counter"     INT4    NOT NULL DEFAULT 1;
 ALTER TABLE "member" ADD COLUMN "notification_sample_size" INT4    NOT NULL DEFAULT 3;
 ALTER TABLE "member" ADD COLUMN "notification_dow"         INT4    CHECK ("notification_dow" BETWEEN 0 AND 6);
-ALTER TABLE "member" ADD COLUMN "notification_hour"        INT4    CHECK ("notification_hour" BETWEEN 0 AND 23);
+ALTER TABLE "member" ADD COLUMN "notification_hour"        INT4    DEFAULT floor(random() * 24) CHECK ("notification_hour" BETWEEN 0 AND 23);
 ALTER TABLE "member" ADD COLUMN "notification_sent"        TIMESTAMP;
 ALTER TABLE "member" ADD
   CONSTRAINT "notification_dow_requires_notification_hour"