github.com/status-im/status-go@v1.1.0/appdatabase/migrations/sql/1653037334_add_notifications_settings_table.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS notifications_settings (
     2    id TEXT PRIMARY KEY ON CONFLICT REPLACE,
     3    exemption BOOLEAN,
     4    text_value TEXT,
     5    int_value INT,
     6    bool_value BOOLEAN,
     7    ex_mute_all_messages BOOLEAN,
     8    ex_personal_mentions TEXT,
     9    ex_global_mentions TEXT,
    10    ex_other_messages TEXT
    11  );
    12  
    13  INSERT INTO notifications_settings (
    14    id, 
    15    exemption, 
    16    text_value, 
    17    int_value, 
    18    bool_value, 
    19    ex_mute_all_messages, 
    20    ex_personal_mentions,
    21    ex_global_mentions,
    22    ex_other_messages
    23  ) 
    24  VALUES 
    25    ("AllowNotifications", 0, NULL, NULL, 1, NULL, NULL, NULL, NULL),
    26    ("OneToOneChats", 0, "SendAlerts", NULL, NULL, NULL, NULL, NULL, NULL),
    27    ("GroupChats", 0, "SendAlerts", NULL, NULL, NULL, NULL, NULL, NULL),
    28    ("PersonalMentions", 0, "SendAlerts", NULL, NULL, NULL, NULL, NULL, NULL),
    29    ("GlobalMentions", 0, "SendAlerts", NULL, NULL, NULL, NULL, NULL, NULL),
    30    ("AllMessages", 0, "TurnOff", NULL, NULL, NULL, NULL, NULL, NULL),
    31    ("ContactRequests", 0, "SendAlerts", NULL, NULL, NULL, NULL, NULL, NULL),
    32    ("IdentityVerificationRequests", 0, "SendAlerts", NULL, NULL, NULL, NULL, NULL, NULL),
    33    ("SoundEnabled", 0, NULL, NULL, 1, NULL, NULL, NULL, NULL),
    34    ("Volume", 0, NULL, 50, NULL, NULL, NULL, NULL, NULL),
    35    ("MessagePreview", 0, NULL, 2, NULL, NULL, NULL, NULL, NULL);