Page MenuHomePhorge
Files F32212238

D7199.1765140601.diff
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

D7199.1765140601.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
@@ -309,6 +309,15 @@
`);
},
],
+ [
+ 28,
+ 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
Sun, Dec 7, 8:50 PM (20 h, 34 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5845972
Default Alt Text
D7199.1765140601.diff (1 KB)

Event Timeline