diff options
Diffstat (limited to 'scripts/mysql_to_mariadb.sql')
| -rw-r--r-- | scripts/mysql_to_mariadb.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/scripts/mysql_to_mariadb.sql b/scripts/mysql_to_mariadb.sql index 4ee3f3a4214..ac089df9d38 100644 --- a/scripts/mysql_to_mariadb.sql +++ b/scripts/mysql_to_mariadb.sql @@ -15,7 +15,7 @@ alter table mysql.user drop column `password_last_changed`, drop column `passwor alter table mysql.user change column `authentication_string` `auth_string` text COLLATE utf8_bin NOT NULL; -- Add new columns -alter table mysql.user add column `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '' after `user`, add column `is_role` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N' after `auth_string`; +alter table mysql.user add column `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '' after `user`, add column `is_role` enum('N','Y') CHARACTER SET utf8mb3 NOT NULL DEFAULT 'N' after `auth_string`; alter table mysql.user add column `default_role` char(80) COLLATE utf8_bin NOT NULL DEFAULT '', add column `max_statement_time` decimal(12,6) NOT NULL DEFAULT '0.000000'; -- Fix passwords |