Query

telegram.db — ping_request_messages

SQL

CREATE TABLE ping_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 ping_requests(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 ping_requests.id

+ Add index

Indexes

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