Andrew Bogott has submitted this change and it was merged.

Change subject: Set CHARSET=utf8mb4 for the labspuppetbackend tables.
......................................................................


Set CHARSET=utf8mb4 for the labspuppetbackend tables.

Previously things were 'binary' which made debugging
unpleasant.

Bug: T133412
Change-Id: Id0e97dd3876d7f4b8bdf0e167717542c3c782654
---
M modules/labspuppetbackend/files/schema.sql
1 file changed, 6 insertions(+), 6 deletions(-)

Approvals:
  BryanDavis: Looks good to me, but someone else must approve
  Andrew Bogott: Looks good to me, approved
  Yuvipanda: Looks good to me, but someone else must approve
  jenkins-bot: Verified



diff --git a/modules/labspuppetbackend/files/schema.sql 
b/modules/labspuppetbackend/files/schema.sql
index 4bd6ba0..9111ee2 100644
--- a/modules/labspuppetbackend/files/schema.sql
+++ b/modules/labspuppetbackend/files/schema.sql
@@ -1,19 +1,19 @@
 CREATE TABLE prefix (
     id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
-    project VARCHAR(64) BINARY NOT NULL, -- 63 dns label length limit
-    prefix VARCHAR(64) BINARY NOT NULL -- 63 dns label length limit + 1 for 
trailing .
-);
+    project VARCHAR(64) NOT NULL, -- 63 dns label length limit
+    prefix VARCHAR(64) NOT NULL -- 63 dns label length limit + 1 for trailing .
+) CHARSET=utf8mb4;
 CREATE UNIQUE INDEX project_prefix ON prefix(project, prefix);
 
 CREATE TABLE roleassignment(
     id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
     prefix_id INT UNSIGNED NOT NULL,
-    role VARCHAR(255) BINARY NOT NULL
-);
+    role VARCHAR(255) NOT NULL
+) CHARSET=utf8mb4;
 
 CREATE TABLE hieraassignment(
     id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
     prefix_id INT UNSIGNED NOT NULL,
     hiera_data TEXT NOT NULL
-);
+) CHARSET=utf8mb4;
 CREATE UNIQUE INDEX hiera_prefix ON hieraassignment(prefix_id);

-- 
To view, visit https://gerrit.wikimedia.org/r/311742
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: Id0e97dd3876d7f4b8bdf0e167717542c3c782654
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Andrew Bogott <abog...@wikimedia.org>
Gerrit-Reviewer: Andrew Bogott <abog...@wikimedia.org>
Gerrit-Reviewer: BryanDavis <bda...@wikimedia.org>
Gerrit-Reviewer: Springle <sprin...@wikimedia.org>
Gerrit-Reviewer: Yuvipanda <yuvipa...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>

_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to