Differential D7560 Diff 26278 keyserver/src/database/setup-db.js

Changeset View

Standalone View

keyserver/src/database/setup-db.js

Show First 20 Lines • Show All 263 Lines • ▼ Show 20 Lines	SQL`
cookie_id bigint(20) NOT NULL,		cookie_id bigint(20) NOT NULL,
is_content tinyint(1) NOT NULL,		is_content tinyint(1) NOT NULL,
version bigint(20) NOT NULL,		version bigint(20) NOT NULL,
pickled_olm_session text		pickled_olm_session text
CHARACTER SET ascii		CHARACTER SET ascii
COLLATE latin1_bin NOT NULL		COLLATE latin1_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;		) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

		CREATE TABLE olm_accounts (
		is_content tinyint(1) NOT NULL,
		version bigint(20) NOT NULL,
		pickling_key text
		CHARACTER SET latin1
		COLLATE latin1_bin NOT NULL,
		pickled_olm_account text
		CHARACTER SET latin1
		COLLATE latin1_bin NOT NULL
		) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_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 111 Lines • ▼ Show 20 Lines	SQL`

ALTER TABLE invite_links		ALTER TABLE invite_links
ADD PRIMARY KEY (id),		ADD PRIMARY KEY (id),
ADD UNIQUE KEY (name),		ADD UNIQUE KEY (name),
ADD INDEX community_primary (community, \`primary\`);		ADD INDEX community_primary (community, \`primary\`);

ALTER TABLE olm_sessions		ALTER TABLE olm_sessions
ADD PRIMARY KEY (cookie_id, is_content);		ADD PRIMARY KEY (cookie_id, is_content);

		ALTER TABLE olm_accounts
		ADD PRIMARY KEY (is_content);
`,		`,
{ 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