simplexmq-0.4.1: migrations/20210624_confirmations.sql

CREATE TABLE conn_confirmations (
  confirmation_id BLOB NOT NULL PRIMARY KEY,
  conn_alias BLOB NOT NULL REFERENCES connections ON DELETE CASCADE,
  sender_key BLOB NOT NULL,
  sender_conn_info BLOB NOT NULL,
  accepted INTEGER NOT NULL,
  own_conn_info BLOB,
  created_at TEXT NOT NULL DEFAULT (datetime('now'))
) WITHOUT ROWID;