Query

telegram.db — telegram_subscribers

SQL

CREATE TABLE telegram_subscribers  (
  chat_id INTEGER PRIMARY KEY,
  username TEXT,
  first_name TEXT,
  last_name TEXT,
  language_code TEXT,
  joined_at TEXT DEFAULT CURRENT_TIMESTAMP
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
chat_id INTEGER ✓ ✓ Rename | Drop
username TEXT ✓ Rename | Drop
first_name TEXT ✓ Rename | Drop
last_name TEXT ✓ Rename | Drop
language_code TEXT ✓ Rename | Drop
joined_at TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?