status-im/status-go

protocol/migrations/sqlite/1603888149_create_chat_identity_last_published_table.up.sql

Summary

Maintainability

Test Coverage

Issues

CREATE TABLE IF NOT EXISTS chat_identity_last_published (
  chat_id VARCHAR NOT NULL PRIMARY KEY ON CONFLICT REPLACE,
  clock_value INT NOT NULL,
  hash BLOB NOT NULL
);

CREATE TABLE IF NOT EXISTS chat_identity_contacts (
  contact_id VARCHAR NOT NULL,
  image_type VARCHAR NOT NULL,
  clock_value INT NOT NULL,
  payload BLOB NOT NULL,
  UNIQUE(contact_id, image_type) ON CONFLICT REPLACE
);