github.com/status-im/status-go@v1.1.0/protocol/pushnotificationserver/migrations/sql/1593601728_initial_schema.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS push_notification_server_registrations (
     2    public_key BLOB NOT NULL,
     3    installation_id VARCHAR NOT NULL,
     4    version INT NOT NULL,
     5    registration BLOB,
     6    UNIQUE(public_key, installation_id) ON CONFLICT REPLACE
     7  );
     8  
     9  CREATE TABLE IF NOT EXISTS push_notification_server_identity (
    10    private_key BLOB NOT NULL,
    11    synthetic_id INT NOT NULL DEFAULT 0,
    12    UNIQUE(synthetic_id)
    13  );
    14  
    15  CREATE INDEX idx_push_notification_server_registrations_public_key ON push_notification_server_registrations(public_key);
    16  CREATE INDEX idx_push_notification_server_registrations_public_key_installation_id ON push_notification_server_registrations(public_key, installation_id);
    17