Query

telegram.db — branch_request_messages

SQL

CREATE TABLE branch_request_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 branch_requests(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 branch_requests.request_id

+ Add index

Indexes

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