Changeset View
Changeset View
Standalone View
Standalone View
keyserver/src/database/setup-db.js
Show First 20 Lines • Show All 83 Lines • ▼ Show 20 Lines | SQL` | ||||
CREATE TABLE messages ( | CREATE TABLE messages ( | ||||
id bigint(20) NOT NULL, | id bigint(20) NOT NULL, | ||||
thread bigint(20) NOT NULL, | thread bigint(20) NOT NULL, | ||||
user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL, | user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL, | ||||
type tinyint(3) UNSIGNED NOT NULL, | type tinyint(3) UNSIGNED NOT NULL, | ||||
content mediumtext COLLATE utf8mb4_bin, | content mediumtext COLLATE utf8mb4_bin, | ||||
time bigint(20) NOT NULL, | time bigint(20) NOT NULL, | ||||
creation varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, | creation varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, | ||||
target_message bigint(20) DEFAULT NULL | target_message bigint(20) DEFAULT NULL, | ||||
pinned tinyint(1) UNSIGNED NOT NULL DEFAULT 0, | |||||
pin_time bigint(20) DEFAULT NULL | |||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; | ||||
CREATE TABLE notifications ( | CREATE TABLE notifications ( | ||||
id bigint(20) NOT NULL, | id bigint(20) NOT NULL, | ||||
user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL, | user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL, | ||||
thread bigint(20) DEFAULT NULL, | thread bigint(20) DEFAULT NULL, | ||||
message bigint(20) DEFAULT NULL, | message bigint(20) DEFAULT NULL, | ||||
collapse_key varchar(255) DEFAULT NULL, | collapse_key varchar(255) DEFAULT NULL, | ||||
▲ Show 20 Lines • Show All 173 Lines • ▼ Show 20 Lines | SQL` | ||||
ADD KEY role (role) USING BTREE; | ADD KEY role (role) USING BTREE; | ||||
ALTER TABLE memberships ADD INDEX user (user); | ALTER TABLE memberships ADD INDEX user (user); | ||||
ALTER TABLE messages | ALTER TABLE messages | ||||
ADD PRIMARY KEY (id), | ADD PRIMARY KEY (id), | ||||
ADD UNIQUE KEY user_creation (user,creation), | ADD UNIQUE KEY user_creation (user,creation), | ||||
ADD KEY thread (thread), | ADD KEY thread (thread), | ||||
ADD INDEX target_message (target_message); | ADD INDEX target_message (target_message), | ||||
ADD INDEX thread_pinned (thread, pinned); | |||||
ALTER TABLE notifications | ALTER TABLE notifications | ||||
ADD PRIMARY KEY (id), | ADD PRIMARY KEY (id), | ||||
ADD KEY rescinded_user_collapse_key (rescinded,user,collapse_key) | ADD KEY rescinded_user_collapse_key (rescinded,user,collapse_key) | ||||
USING BTREE, | USING BTREE, | ||||
ADD KEY thread (thread), | ADD KEY thread (thread), | ||||
ADD KEY rescinded_user_thread_message (rescinded,user,thread,message) | ADD KEY rescinded_user_thread_message (rescinded,user,thread,message) | ||||
USING BTREE; | USING BTREE; | ||||
▲ Show 20 Lines • Show All 143 Lines • Show Last 20 Lines |