From c3ec68312a5ca4a3b41aabdf5c2e8809dc4c6b79 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Fri, 8 Dec 2006 16:13:42 +0000
Subject: - Patch #18616: allow longer role names.

---
 modules/system/system.install | 21 +++++++++++++++++++--
 1 file changed, 19 insertions(+), 2 deletions(-)

(limited to 'modules/system/system.install')

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)
       )");
@@ -3403,6 +3403,23 @@ function system_update_1016() {
   return $ret;
 }
 
+/**
+ * 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"
  */
-- 
cgit v1.2.3