diff options
| -rw-r--r-- | modules/system/system.install | 21 |
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" */ |