Query

billing.db — telegram_sessions

SQL

CREATE TABLE telegram_sessions  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  telegram_user_id INTEGER UNIQUE NOT NULL,
  username TEXT NOT NULL,
  role TEXT NOT NULL,
  login_time DATETIME DEFAULT CURRENT_TIMESTAMP,
  last_activity DATETIME DEFAULT CURRENT_TIMESTAMP,
  expires_at DATETIME NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
telegram_user_id INTEGER Rename | Drop
username TEXT Rename | Drop
role TEXT Rename | Drop
login_time DATETIME ✓ Rename | Drop
last_activity DATETIME ✓ Rename | Drop
expires_at DATETIME Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_telegram_sessions_expires_at expires_at SQL 
CREATE INDEX idx_telegram_sessions_expires_at
ON telegram_sessions(expires_at)
Drop
idx_telegram_sessions_user_id telegram_user_id SQL 
CREATE INDEX idx_telegram_sessions_user_id
ON telegram_sessions(telegram_user_id)
Drop
sqlite_autoindex_telegram_sessions_1 telegram_user_id ✓ SQL
-- no sql found --
 Drop