SQL

CREATE TABLE secrets  (
  key TEXT PRIMARY KEY,
  value BLOB NOT NULL,
  nonce BLOB NOT NULL,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
  expires_at TEXT
)

Columns

Column Data type Allow null Primary key Actions
key TEXT ✓ ✓ read-only
value BLOB read-only
nonce BLOB read-only
created_at TEXT read-only
updated_at TEXT read-only
expires_at TEXT ✓ read-only

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_secrets_1 key ✓ SQL
-- no sql found --
 read-only