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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
|
PRAGMA journal_mode=WAL;
CREATE TABLE IF NOT EXISTS discord_roles (
id TEXT PRIMARY KEY,
guild_id TEXT NOT NULL,
name TEXT NOT NULL,
color TEXT NOT NULL,
hoist BOOLEAN NOT NULL,
position INTEGER NOT NULL
);
CREATE TABLE IF NOT EXISTS discord_users (
id TEXT PRIMARY KEY,
username TEXT NOT NULL,
avatar_url TEXT NOT NULL,
accent_color INTEGER NOT NULL
);
CREATE TABLE IF NOT EXISTS discord_messages (
id TEXT PRIMARY KEY,
guild_id TEXT NOT NULL,
channel_id TEXT NOT NULL,
author_id TEXT NOT NULL,
content TEXT,
created_at TEXT NOT NULL,
edited_at TEXT,
webhook_id TEXT
);
CREATE TABLE IF NOT EXISTS discord_webhook_message_info (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
avatar_url TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS discord_attachments (
id TEXT PRIMARY KEY,
message_id TEXT NOT NULL,
url TEXT NOT NULL,
proxy_url TEXT NOT NULL,
filename TEXT NOT NULL,
content_type TEXT NOT NULL,
width INTEGER NOT NULL,
height INTEGER NOT NULL,
"size" INTEGER NOT NULL
);
CREATE TABLE IF NOT EXISTS discord_channels (
id TEXT PRIMARY KEY,
guild_id TEXT NOT NULL,
name TEXT NOT NULL,
topic TEXT NOT NULL,
nsfw BOOLEAN NOT NULL
);
CREATE TABLE IF NOT EXISTS discord_guilds (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
description TEXT NOT NULL,
icon_url TEXT NOT NULL,
banner_url TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS discord_emoji (
id TEXT PRIMARY KEY,
guild_id TEXT NOT NULL,
name TEXT NOT NULL,
url TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS irc_messages (
id SERIAL PRIMARY KEY,
nick TEXT NOT NULL,
user TEXT NOT NULL,
host TEXT NOT NULL,
channel TEXT NOT NULL,
content TEXT NOT NULL,
tags TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS revolt_channels (
id TEXT PRIMARY KEY,
server_id TEXT NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS revolt_emoji (
id TEXT PRIMARY KEY,
server_id TEXT NOT NULL,
name TEXT NOT NULL,
url TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS revolt_discord_emoji (
revolt_id TEXT NOT NULL,
discord_id TEXT NOT NULL,
name TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS revolt_messages (
id TEXT PRIMARY KEY,
channel_id TEXT NOT NULL,
author_id TEXT NOT NULL,
content TEXT NOT NULL,
created_at TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS revolt_message_masquerade (
id TEXT PRIMARY KEY,
username TEXT NOT NULL,
avatar_url TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS revolt_servers (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
description TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS revolt_users (
id TEXT PRIMARY KEY,
username TEXT NOT NULL,
avatar_url TEXT NOT NULL,
created_at TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS revolt_attachments (
id TEXT PRIMARY KEY,
tag TEXT NOT NULL,
message_id TEXT,
url TEXT NOT NULL,
filename TEXT NOT NULL,
content_type TEXT NOT NULL,
width INTEGER,
height INTEGER,
"size" INTEGER NOT NULL
);
CREATE TABLE IF NOT EXISTS s3_uploads (
id TEXT PRIMARY KEY, -- sha512 of file contents
url TEXT NOT NULL,
kind TEXT NOT NULL,
content_type TEXT NOT NULL,
created_at TEXT NOT NULL,
message_id TEXT
);
|
