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 179 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 147 Lines • Show Last 20 Lines | |||||