Page Menu
Home
Phorge
Search
Configure Global Search
Log In
Files
F32210016
D5438.1765129209.diff
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
1 KB
Referenced Files
None
Subscribers
None
D5438.1765129209.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
@@ -36,6 +36,17 @@
await dbQuery(SQL`ALTER TABLE uploads ADD INDEX container (container)`);
},
],
+ [
+ 5,
+ async () => {
+ await dbQuery(SQL`
+ ALTER TABLE cookies
+ ADD device_id varchar(255) DEFAULT NULL,
+ ADD public_key varchar(255) DEFAULT NULL,
+ ADD social_proof varchar(255) DEFAULT NULL;
+ `);
+ },
+ ],
]);
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
@@ -33,6 +33,9 @@
last_used bigint(20) NOT NULL,
device_token varchar(255) DEFAULT NULL,
versions json DEFAULT NULL,
+ device_id varchar(255) DEFAULT NULL,
+ public_key varchar(255) DEFAULT NULL,
+ social_proof varchar(255) DEFAULT NULL,
\`primary\` TINYINT(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Sun, Dec 7, 5:40 PM (14 h, 41 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5842861
Default Alt Text
D5438.1765129209.diff (1 KB)
Attached To
Mode
D5438: [keyserver/sql] add SIWE columns
Attached
Detach File
Event Timeline
Log In to Comment