Changeset View
Changeset View
Standalone View
Standalone View
keyserver/src/database/migration-config.js
Show First 20 Lines • Show All 198 Lines • ▼ Show 20 Lines | async () => { | ||||
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)); | ||||
`, | `, | ||||
{ multipleStatements: true }, | { multipleStatements: true }, | ||||
); | ); | ||||
}, | }, | ||||
], | ], | ||||
[18, updateRolesAndPermissionsForAllThreads], | [18, updateRolesAndPermissionsForAllThreads], | ||||
[ | |||||
19, | |||||
async () => { | |||||
await dbQuery( | |||||
SQL` | |||||
CREATE TABLE IF NOT EXISTS search ( | |||||
original_message_id bigint(20) NOT NULL, | |||||
message_id bigint(20) NOT NULL, | |||||
processed_content mediumtext COLLATE utf8mb4_bin, | |||||
FULLTEXT(processed_content), | |||||
PRIMARY KEY (original_message_id) | |||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |||||
`, | |||||
); | |||||
}, | |||||
], | |||||
]); | ]); | ||||
const newDatabaseVersion: number = Math.max(...migrations.keys()); | const newDatabaseVersion: number = Math.max(...migrations.keys()); | ||||
async function writeJSONToFile(data: any, filePath: string): Promise<void> { | async function writeJSONToFile(data: any, filePath: string): Promise<void> { | ||||
console.warn(`updating ${filePath} to ${JSON.stringify(data)}`); | console.warn(`updating ${filePath} to ${JSON.stringify(data)}`); | ||||
const fileHandle = await fs.promises.open(filePath, 'w'); | const fileHandle = await fs.promises.open(filePath, 'w'); | ||||
await fileHandle.writeFile(JSON.stringify(data, null, ' '), 'utf8'); | await fileHandle.writeFile(JSON.stringify(data, null, ' '), 'utf8'); | ||||
await fileHandle.close(); | await fileHandle.close(); | ||||
▲ Show 20 Lines • Show All 89 Lines • Show Last 20 Lines |