github.com/status-im/status-go@v1.1.0/protocol/migrations/sqlite/1617694931_add_notification_center.up.sql (about)

     1  ALTER TABLE chats ADD COLUMN accepted BOOLEAN DEFAULT false;
     2  UPDATE chats SET accepted = 1;
     3  
     4  CREATE TABLE activity_center_notifications (
     5    id VARCHAR NOT NULL PRIMARY KEY,
     6    timestamp INT NOT NULL,
     7    notification_type INT NOT NULL,
     8    chat_id VARCHAR,
     9    read BOOLEAN NOT NULL DEFAULT FALSE,
    10    dismissed BOOLEAN NOT NULL DEFAULT FALSE,
    11    accepted BOOLEAN NOT NULL DEFAULT FALSE
    12  ) WITHOUT ROWID;
    13  
    14  CREATE INDEX activity_center_dimissed_accepted ON activity_center_notifications(dismissed, accepted);
    15  
    16  CREATE INDEX activity_center_read ON activity_center_notifications(read);