Query

telegram.db — telegram_approval_messages

SQL

CREATE TABLE telegram_approval_messages  (
  request_id TEXT NOT NULL,
  chat_id INTEGER NOT NULL,
  message_id INTEGER NOT NULL,
  PRIMARY KEY (request_id, chat_id),
  FOREIGN KEY (request_id) REFERENCES telegram_approvals(request_id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
request_id TEXT ✓ Rename | Drop
chat_id INTEGER ✓ Rename | Drop
message_id INTEGER Rename | Drop

Foreign Keys

Column Destination
request_id telegram_approvals.request_id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_telegram_approval_messages_1
  • request_id
  • chat_id
 ✓ SQL
-- no sql found --
 Drop