Page MenuHomePhorge
Files F33021990

D6907.1768388432.diff
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

D6907.1768388432.diff
View Options

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
@@ -166,6 +166,24 @@
);
},
],
+ [
+ 16,
+ async () => {
+ await dbQuery(
+ SQL`
+ ALTER TABLE cookies
+ DROP COLUMN IF EXISTS public_key;
+
+ ALTER TABLE cookies
+ ADD COLUMN IF NOT EXISTS signed_identity_keys mediumtext
+ CHARACTER SET utf8mb4
+ COLLATE utf8mb4_bin
+ DEFAULT NULL;
+ `,
+ { multipleStatements: true },
+ );
+ },
+ ],
]);
const newDatabaseVersion: number = Math.max(...migrations.keys());
diff --git a/keyserver/src/database/setup-db.js b/keyserver/src/database/setup-db.js
--- a/keyserver/src/database/setup-db.js
+++ b/keyserver/src/database/setup-db.js
@@ -34,7 +34,7 @@
device_token varchar(255) DEFAULT NULL,
versions json DEFAULT NULL,
device_id varchar(255) DEFAULT NULL,
- public_key varchar(255) DEFAULT NULL,
+ signed_identity_keys mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
social_proof mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
\`primary\` TINYINT(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

File Metadata

Mime Type
text/plain
Expires
Wed, Jan 14, 11:00 AM (1 h, 26 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5931618
Default Alt Text
D6907.1768388432.diff (1 KB)

Event Timeline