Page MenuHomePhorge
Files F32257980

D7199.1765243089.diff
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

D7199.1765243089.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
@@ -288,6 +288,15 @@
},
],
[25, updateRolesAndPermissionsForAllThreads],
+ [
+ 26,
+ async () => {
+ await dbQuery(SQL`
+ ALTER TABLE threads
+ ADD COLUMN IF NOT EXISTS pinned_count int UNSIGNED NOT NULL DEFAULT 0;
+ `);
+ },
+ ],
]);
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
@@ -157,7 +157,8 @@
color char(6) COLLATE utf8mb4_bin NOT NULL,
source_message bigint(20) DEFAULT NULL UNIQUE,
replies_count int UNSIGNED NOT NULL DEFAULT 0,
- avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL
+ avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
+ pinned_count int UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE updates (

File Metadata

Mime Type
text/plain
Expires
Tue, Dec 9, 1:18 AM (7 h, 31 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5851889
Default Alt Text
D7199.1765243089.diff (1 KB)

Event Timeline