Differential D7076 Diff 23919 keyserver/src/database/setup-db.js

Changeset View

Standalone View

keyserver/src/database/setup-db.js

Show First 20 Lines • Show All 242 Lines • ▼ Show 20 Lines	SQL`
confirmed tinyint(1) UNSIGNED NOT NULL DEFAULT 0		confirmed tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;		) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE siwe_nonces (		CREATE TABLE siwe_nonces (
nonce char(17) NOT NULL,		nonce char(17) NOT NULL,
creation_time bigint(20) NOT NULL		creation_time bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;		) ENGINE=InnoDB DEFAULT CHARSET=utf8;

		CREATE TABLE search (
		original_message_id bigint(20) NOT NULL,
		message_id bigint(20) NOT NULL,
		processed_content mediumtext COLLATE utf8mb4_bin,
		FULLTEXT(processed_content)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

ALTER TABLE cookies		ALTER TABLE cookies
ADD PRIMARY KEY (id),		ADD PRIMARY KEY (id),
ADD UNIQUE KEY device_token (device_token(512)),		ADD UNIQUE KEY device_token (device_token(512)),
ADD KEY user_device_token (user,device_token(512));		ADD KEY user_device_token (user,device_token(512));

ALTER TABLE days		ALTER TABLE days
ADD PRIMARY KEY (id),		ADD PRIMARY KEY (id),
ADD UNIQUE KEY date_thread (date,thread) USING BTREE;		ADD UNIQUE KEY date_thread (date,thread) USING BTREE;
▲ Show 20 Lines • Show All 100 Lines • ▼ Show 20 Lines	SQL`
ALTER TABLE metadata		ALTER TABLE metadata
ADD PRIMARY KEY (name);		ADD PRIMARY KEY (name);

ALTER TABLE policy_acknowledgments		ALTER TABLE policy_acknowledgments
ADD PRIMARY KEY (user, policy);		ADD PRIMARY KEY (user, policy);

ALTER TABLE siwe_nonces		ALTER TABLE siwe_nonces
ADD PRIMARY KEY (nonce);		ADD PRIMARY KEY (nonce);

		ALTER TABLE search
		ADD PRIMARY KEY (original_message_id);
`,		`,
{ multipleStatements: true },		{ multipleStatements: true },
);		);
}		}

async function createUsers() {		async function createUsers() {
const [user1, user2] = sortIDs(bots.commbot.userID, ashoat.id);		const [user1, user2] = sortIDs(bots.commbot.userID, ashoat.id);
await dbQuery(		await dbQuery(
▲ Show 20 Lines • Show All 57 Lines • Show Last 20 Lines