SQL

CREATE TABLE _installs  (
  install_id   TEXT PRIMARY KEY,
  install_seq  INTEGER NOT NULL UNIQUE,
  first_seen   TEXT NOT NULL DEFAULT (datetime('now')),
  last_seen    TEXT NOT NULL DEFAULT (datetime('now'))
)

Columns

Column Data type Allow null Primary key Actions
install_id TEXT ✓ ✓ read-only
install_seq INTEGER read-only
first_seen TEXT read-only
last_seen TEXT read-only

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex__installs_1 install_id ✓ SQL
-- no sql found --
 read-only
sqlite_autoindex__installs_2 install_seq ✓ SQL
-- no sql found --
 read-only