Page MenuHomePhorge
Files F33312221

D7179.1768814068.diff
No OneTemporary
Actions

Size
8 KB
Referenced Files
None
Subscribers
None

D7179.1768814068.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
@@ -227,6 +227,54 @@
`);
},
],
+ [
+ 22,
+ async () => {
+ await dbQuery(
+ SQL`
+ ALTER TABLE cookies
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE entries
+ MODIFY creator varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE focused
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE memberships
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE messages
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE notifications
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE reports
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE revisions
+ MODIFY author varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE sessions
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE threads
+ MODIFY creator varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE updates
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE uploads
+ MODIFY uploader varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE users
+ MODIFY id varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE relationships_undirected
+ MODIFY user1 varchar(255) CHARSET latin1 COLLATE latin1_bin,
+ MODIFY user2 varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE relationships_directed
+ MODIFY user1 varchar(255) CHARSET latin1 COLLATE latin1_bin,
+ MODIFY user2 varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE user_messages
+ MODIFY recipient varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE settings
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ ALTER TABLE policy_acknowledgments
+ MODIFY user varchar(255) CHARSET latin1 COLLATE latin1_bin;
+ `,
+ { 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
@@ -27,7 +27,7 @@
CREATE TABLE cookies (
id bigint(20) NOT NULL,
hash char(60) NOT NULL,
- user bigint(20) DEFAULT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin DEFAULT NULL,
platform varchar(255) DEFAULT NULL,
creation_time bigint(20) NOT NULL,
last_used bigint(20) NOT NULL,
@@ -49,7 +49,7 @@
id bigint(20) NOT NULL,
day bigint(20) NOT NULL,
text mediumtext COLLATE utf8mb4_bin NOT NULL,
- creator bigint(20) NOT NULL,
+ creator varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
creation_time bigint(20) NOT NULL,
last_update bigint(20) NOT NULL,
deleted tinyint(1) UNSIGNED NOT NULL,
@@ -57,7 +57,7 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE focused (
- user bigint(20) NOT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
session bigint(20) NOT NULL,
thread bigint(20) NOT NULL,
time bigint(20) NOT NULL
@@ -70,7 +70,7 @@
CREATE TABLE memberships (
thread bigint(20) NOT NULL,
- user bigint(20) NOT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
role bigint(20) NOT NULL,
permissions json DEFAULT NULL,
permissions_for_children json DEFAULT NULL,
@@ -84,7 +84,7 @@
CREATE TABLE messages (
id bigint(20) NOT NULL,
thread bigint(20) NOT NULL,
- user bigint(20) NOT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
type tinyint(3) UNSIGNED NOT NULL,
content mediumtext COLLATE utf8mb4_bin,
time bigint(20) NOT NULL,
@@ -94,7 +94,7 @@
CREATE TABLE notifications (
id bigint(20) NOT NULL,
- user bigint(20) NOT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
thread bigint(20) DEFAULT NULL,
message bigint(20) DEFAULT NULL,
collapse_key varchar(255) DEFAULT NULL,
@@ -104,7 +104,7 @@
CREATE TABLE reports (
id bigint(20) NOT NULL,
- user bigint(20) NOT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
type tinyint(3) UNSIGNED NOT NULL,
platform varchar(255) NOT NULL,
report json NOT NULL,
@@ -114,7 +114,7 @@
CREATE TABLE revisions (
id bigint(20) NOT NULL,
entry bigint(20) NOT NULL,
- author bigint(20) NOT NULL,
+ author varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
text mediumtext COLLATE utf8mb4_bin NOT NULL,
creation_time bigint(20) NOT NULL,
session bigint(20) NOT NULL,
@@ -132,7 +132,7 @@
CREATE TABLE sessions (
id bigint(20) NOT NULL,
- user bigint(20) NOT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
cookie bigint(20) NOT NULL,
query json NOT NULL,
creation_time bigint(20) NOT NULL,
@@ -150,7 +150,7 @@
community bigint(20) DEFAULT NULL,
depth int UNSIGNED NOT NULL DEFAULT 0,
default_role bigint(20) NOT NULL,
- creator bigint(20) NOT NULL,
+ creator varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
creation_time bigint(20) NOT NULL,
color char(6) COLLATE utf8mb4_bin NOT NULL,
source_message bigint(20) DEFAULT NULL UNIQUE,
@@ -160,7 +160,7 @@
CREATE TABLE updates (
id bigint(20) NOT NULL,
- user bigint(20) NOT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
type tinyint(3) UNSIGNED NOT NULL,
\`key\` bigint(20) DEFAULT NULL,
updater bigint(20) DEFAULT NULL,
@@ -172,7 +172,7 @@
CREATE TABLE uploads (
id bigint(20) NOT NULL,
thread bigint(20) DEFAULT NULL,
- uploader bigint(20) NOT NULL,
+ uploader varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
container bigint(20) DEFAULT NULL,
type varchar(255) NOT NULL,
filename varchar(255) NOT NULL,
@@ -184,7 +184,7 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE users (
- id bigint(20) NOT NULL,
+ id varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL,
hash char(60) COLLATE utf8mb4_bin DEFAULT NULL,
avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
@@ -193,14 +193,14 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE relationships_undirected (
- user1 bigint(20) NOT NULL,
- user2 bigint(20) NOT NULL,
+ user1 varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
+ user2 varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
status tinyint(1) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE relationships_directed (
- user1 bigint(20) NOT NULL,
- user2 bigint(20) NOT NULL,
+ user1 varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
+ user2 varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
status tinyint(1) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@@ -218,7 +218,7 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE user_messages (
- recipient bigint(20) NOT NULL,
+ recipient varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
thread bigint(20) NOT NULL,
message bigint(20) NOT NULL,
time bigint(20) NOT NULL,
@@ -226,7 +226,7 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE settings (
- user bigint(20) NOT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
name varchar(255) NOT NULL,
data mediumtext COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
@@ -237,7 +237,7 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE policy_acknowledgments (
- user bigint(20) NOT NULL,
+ user varchar(255) CHARSET latin1 COLLATE latin1_bin NOT NULL,
policy varchar(255) NOT NULL,
date bigint(20) NOT NULL,
confirmed tinyint(1) UNSIGNED NOT NULL DEFAULT 0

File Metadata

Mime Type
text/plain
Expires
Mon, Jan 19, 9:14 AM (11 h, 38 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5955583
Default Alt Text
D7179.1768814068.diff (8 KB)

Event Timeline