Page MenuHomePhorge
Files F32181814

D5566.1765077955.diff
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

D5566.1765077955.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
@@ -63,6 +63,17 @@
);
},
],
+ [
+ 8,
+ async () => {
+ await dbQuery(
+ SQL`
+ ALTER TABLE users
+ ADD COLUMN IF NOT EXISTS ethereum_address char(42) 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
@@ -185,6 +185,7 @@
username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL,
hash char(60) COLLATE utf8mb4_bin DEFAULT NULL,
avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
+ ethereum_address char(42) DEFAULT NULL,
creation_time bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

File Metadata

Mime Type
text/plain
Expires
Sun, Dec 7, 3:25 AM (30 m, 43 s)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5841820
Default Alt Text
D5566.1765077955.diff (1 KB)

Event Timeline