Query

telegram.db — telegram_approvals

SQL

CREATE TABLE telegram_approvals  (
  request_id TEXT PRIMARY KEY,
  type TEXT NOT NULL,
  code TEXT NOT NULL,
  metadata_json TEXT,
  status TEXT NOT NULL DEFAULT 'pending',
  created_at TEXT DEFAULT CURRENT_TIMESTAMP,
  resolved_at TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
request_id TEXT ✓ ✓ Rename | Drop
type TEXT Rename | Drop
code TEXT Rename | Drop
metadata_json TEXT ✓ Rename | Drop
status TEXT Rename | Drop
created_at TEXT ✓ Rename | Drop
resolved_at TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_telegram_approvals_status status SQL 
CREATE INDEX idx_telegram_approvals_status
ON telegram_approvals (status)
Drop
sqlite_autoindex_telegram_approvals_1 request_id ✓ SQL
-- no sql found --
 Drop