Query

avito.sqlite — notification_queue

SQL

CREATE TABLE notification_queue  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  topic_name TEXT NOT NULL,
  title TEXT,
  body_text TEXT NOT NULL,
  click_url TEXT,
  deduplication_key TEXT,
  status TEXT NOT NULL DEFAULT 'pending',
  attempts INTEGER NOT NULL DEFAULT 0,
  last_error TEXT,
  last_response_code INTEGER,
  last_response_text TEXT,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL,
  last_attempt_at TEXT,
  sent_at TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
topic_name TEXT Rename | Drop
title TEXT ✓ Rename | Drop
body_text TEXT Rename | Drop
click_url TEXT ✓ Rename | Drop
deduplication_key TEXT ✓ Rename | Drop
status TEXT Rename | Drop
attempts INTEGER Rename | Drop
last_error TEXT ✓ Rename | Drop
last_response_code INTEGER ✓ Rename | Drop
last_response_text TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
last_attempt_at TEXT ✓ Rename | Drop
sent_at TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?