Query

avito.sqlite — search_url_history

SQL

CREATE TABLE search_url_history  (
  search_url TEXT PRIMARY KEY,
  first_seen_at TEXT NOT NULL,
  last_seen_at TEXT NOT NULL,
  seen_count INTEGER NOT NULL DEFAULT 1
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
search_url TEXT ✓ ✓ Rename | Drop
first_seen_at TEXT Rename | Drop
last_seen_at TEXT Rename | Drop
seen_count INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_search_url_history_1 search_url ✓ SQL
-- no sql found --
 Drop