Query

avito.sqlite — blacklist_entries

SQL

CREATE TABLE blacklist_entries  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  seller_name TEXT,
  seller_url TEXT,
  reason TEXT NOT NULL,
  source TEXT NOT NULL DEFAULT 'manual',
  status TEXT NOT NULL DEFAULT 'active',
  trigger_count INTEGER NOT NULL DEFAULT 1,
  window_seconds INTEGER NOT NULL DEFAULT 180,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
seller_name TEXT ✓ Rename | Drop
seller_url TEXT ✓ Rename | Drop
reason TEXT Rename | Drop
source TEXT Rename | Drop
status TEXT Rename | Drop
trigger_count INTEGER Rename | Drop
window_seconds INTEGER Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_blacklist_seller_name seller_name ✓ SQL 
CREATE UNIQUE INDEX idx_blacklist_seller_name
ON blacklist_entries (seller_name)
      WHERE seller_name IS NOT NULL
Drop
idx_blacklist_seller_url seller_url ✓ SQL 
CREATE UNIQUE INDEX idx_blacklist_seller_url
ON blacklist_entries (seller_url)
      WHERE seller_url IS NOT NULL
Drop