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

     1  CREATE TABLE IF NOT EXISTS profile_showcase_preferences (
     2      id TEXT PRIMARY KEY ON CONFLICT REPLACE,
     3      entry_type INT NOT NULL DEFAULT 0,
     4      visibility INT NOT NULL DEFAULT 0,
     5      sort_order INT NOT NULL DEFAULT 0
     6  );
     7  
     8  CREATE TABLE IF NOT EXISTS profile_showcase_contacts (
     9      contact_id TEXT PRIMARY KEY ON CONFLICT REPLACE,
    10      entry_id TEXT NOT NULL,
    11      entry_type INT NOT NULL DEFAULT 0,
    12      entry_order INT NOT NULL DEFAULT 0
    13  );