status-im/status-go

protocol/migrations/sqlite/1706520870_add_bridge_messages_table.up.sql

Summary

Maintainability

Test Coverage

Issues

CREATE TABLE IF NOT EXISTS bridge_messages (
  user_messages_id TEXT PRIMARY KEY NOT NULL,
  bridge_name TEXT NOT NULL,
  user_name TEXT NOT NULL,
  user_avatar TEXT DEFAULT "",
  user_id TEXT DEFAULT "",
  content TEXT NOT NULL,
  message_id TEXT DEFAULT "",
  parent_message_id TEXT DEFAULT ""
);

CREATE INDEX idx_bridge_messages_user_messages_id
ON bridge_messages (user_messages_id);