Page MenuHomePhabricator
Differential D6924 Diff 23875 keyserver/src/database/setup-db.js

Changeset View

Standalone View

View Options

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 bigint(20) NOT NULL, user bigint(20) 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
tomekUnsubmitted
Not Done
Inline Actions

pinned is a little redundant as non-null pin_time means that a message is pinned, but we can keep it.

tomek: `pinned` is a little redundant as non-null `pin_time` means that a message is pinned, but we…
) 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 bigint(20) NOT NULL, user bigint(20) 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 pinned (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 141 Lines • Show Last 20 Lines