15 lines
761 B
SQL
15 lines
761 B
SQL
-- Sādhana reminder support.
|
|
--
|
|
-- timezone: the user's IANA zone (e.g. "Asia/Kolkata"), reported by the
|
|
-- browser, so reminders fire at their local clock time. Defaults to UTC
|
|
-- until the client reports a real zone.
|
|
--
|
|
-- sadhna_reminders_enabled: per-user opt-out for the daily reminders.
|
|
--
|
|
-- last_{chant,quote}_reminder_on: the UTC date a reminder of that kind was
|
|
-- last sent, so each kind goes out at most once per (UTC) day.
|
|
ALTER TABLE users ADD COLUMN IF NOT EXISTS timezone TEXT NOT NULL DEFAULT 'UTC';
|
|
ALTER TABLE users ADD COLUMN IF NOT EXISTS sadhna_reminders_enabled BOOLEAN NOT NULL DEFAULT TRUE;
|
|
ALTER TABLE users ADD COLUMN IF NOT EXISTS last_chant_reminder_on DATE;
|
|
ALTER TABLE users ADD COLUMN IF NOT EXISTS last_quote_reminder_on DATE;
|