Query

avito.sqlite — proxy_ratings

SQL

CREATE TABLE proxy_ratings  (
  proxy_label TEXT PRIMARY KEY,
  score REAL NOT NULL DEFAULT 0,
  success_count INTEGER NOT NULL DEFAULT 0,
  fail_count INTEGER NOT NULL DEFAULT 0,
  blocked_count INTEGER NOT NULL DEFAULT 0,
  timeout_count INTEGER NOT NULL DEFAULT 0,
  total_count INTEGER NOT NULL DEFAULT 0,
  last_status TEXT NOT NULL DEFAULT 'unknown',
  last_error TEXT,
  last_used_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
proxy_label TEXT ✓ ✓ Rename | Drop
score REAL Rename | Drop
success_count INTEGER Rename | Drop
fail_count INTEGER Rename | Drop
blocked_count INTEGER Rename | Drop
timeout_count INTEGER Rename | Drop
total_count INTEGER Rename | Drop
last_status TEXT Rename | Drop
last_error TEXT ✓ Rename | Drop
last_used_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_proxy_ratings_1 proxy_label ✓ SQL
-- no sql found --
 Drop