-
Notifications
You must be signed in to change notification settings - Fork 4
/
schema.sql
32 lines (32 loc) · 838 Bytes
/
schema.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
CREATE TABLE telegram_messages (
update_id INTEGER PRIMARY KEY,
message_id INTEGER,
user_id INTEGER,
first_name TEXT,
username TEXT,
sender_chat_id TEXT,
sender_chat_title TEXT,
sender_chat_username TEXT,
sender_chat_type TEXT,
chat_id TEXT,
chat_title TEXT,
chat_username TEXT,
chat_type TEXT,
date INTEGER,
message_thread_id INTEGER,
reply_to_message_id INTEGER,
reply_from_id INTEGER,
reply_from_first_name TEXT,
reply_sender_chat_id INTEGER,
reply_sender_chat_title TEXT,
reply_sender_chat_type TEXT,
reply_date INTEGER,
forward_from_chat_id INTEGER,
forward_from_chat_title TEXT,
forward_from_chat_type TEXT,
forward_from_message_id INTEGER,
media_group_id INTEGER,
photo_file_id TEXT,
caption TEXT,
text TEXT
);