Differential D7174 Diff 24197 keyserver/src/database/setup-db.js

Changeset View

Standalone View

Show First 20 Lines • Show All 286 Lines • ▼ Show 20 Lines	SQL`
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;

ALTER TABLE notifications ADD INDEX user (user);		ALTER TABLE notifications ADD INDEX user (user);

ALTER TABLE reports		ALTER TABLE reports
ADD PRIMARY KEY (id);		ADD PRIMARY KEY (id),
		ADD INDEX user_type_platform_creation_time
		(user, type, platform, creation_time);

ALTER TABLE revisions		ALTER TABLE revisions
ADD PRIMARY KEY (id),		ADD PRIMARY KEY (id),
ADD KEY entry (entry);		ADD KEY entry (entry);

ALTER TABLE roles		ALTER TABLE roles
ADD PRIMARY KEY (id),		ADD PRIMARY KEY (id),
ADD KEY thread (thread);		ADD KEY thread (thread);
▲ Show 20 Lines • Show All 128 Lines • Show Last 20 Lines