- Patch #18616: allow longer role names.

1 files changed, 19 insertions, 2 deletions

diff --git a/modules/system/system.install b/modules/system/system.install
index a8f7f0aaf..9b0c77da1 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -402,7 +402,7 @@ function system_install() {
 
       db_query("CREATE TABLE {role} (
         rid int unsigned NOT NULL auto_increment,
-        name varchar(32) NOT NULL default '',
+        name varchar(64) NOT NULL default '',
         PRIMARY KEY (rid),
         UNIQUE KEY name (name)
       ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
@@ -867,7 +867,7 @@ function system_install() {
 
       db_query("CREATE TABLE {role} (
         rid serial CHECK (rid >= 0),
-        name varchar(32) NOT NULL default '',
+        name varchar(64) NOT NULL default '',
         PRIMARY KEY (rid),
         UNIQUE (name)
       )");
@@ -3404,6 +3404,23 @@ function system_update_1016() {
 }
 
 /**
+ * Allow role names to be up to 64 characters.
+ */
+function system_update_1017() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'pgsql':
+      db_change_column($ret, 'role', 'name', 'name', 'varchar(64)', array('not null' => TRUE, 'default' => "''"));
+      break;
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {role} CHANGE name name varchar(64) NOT NULL default ''");
+      break;
+  }
+  return $ret;
+}
+
+/**
  * @} End of "defgroup updates-4.7-to-5.0"
  */