Page MenuHomePhabricator

D5521.diff
No OneTemporary

D5521.diff

diff --git a/keyserver/src/database/migration-config.js b/keyserver/src/database/migration-config.js
--- a/keyserver/src/database/migration-config.js
+++ b/keyserver/src/database/migration-config.js
@@ -48,16 +48,19 @@
},
],
[
- 6,
+ 7,
async () => {
- await dbQuery(SQL`
- ALTER TABLE users
- DROP COLUMN public_key,
- MODIFY hash char(60) COLLATE utf8mb4_bin DEFAULT NULL;
-
- ALTER TABLE sessions
- DROP COLUMN public_key;
- `);
+ await dbQuery(
+ SQL`
+ ALTER TABLE users
+ DROP COLUMN IF EXISTS public_key,
+ MODIFY hash char(60) COLLATE utf8mb4_bin DEFAULT NULL;
+
+ ALTER TABLE sessions
+ DROP COLUMN IF EXISTS public_key;
+ `,
+ { multipleStatements: true },
+ );
},
],
]);

File Metadata

Mime Type
text/plain
Expires
Mon, Dec 23, 7:07 PM (15 h, 43 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2695958
Default Alt Text
D5521.diff (855 B)

Event Timeline