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

     1  CREATE TABLE IF NOT EXISTS community_storenodes (
     2      community_id BLOB NOT NULL,
     3      storenode_id VARCHAR NOT NULL,
     4      name VARCHAR NOT NULL,
     5      address VARCHAR NOT NULL,
     6      fleet VARCHAR NOT NULL,
     7      version INT NOT NULL,
     8      clock INT NOT NULL DEFAULT 0,
     9      removed BOOLEAN NOT NULL DEFAULT FALSE,
    10      deleted_at INT NOT NULL DEFAULT 0,
    11      PRIMARY KEY (community_id, storenode_id) -- One to many relationship between communities and storenodes: one community might have multiple storenodes
    12  ) WITHOUT ROWID;