Fixed the upgrade from 1.6.x. The role->shortname field was not being created.
[moodle.git] / lib / db / mysql.php
index 9a168cf..6c5e793 100644 (file)
@@ -2005,6 +2005,7 @@ function main_upgrade($oldversion=0) {
         execute_sql("CREATE TABLE {$CFG->prefix}role (
                               `id` int(10) unsigned NOT NULL auto_increment,
                               `name` varchar(255) NOT NULL default '',
+                              `shortname` varchar(100) NOT NULL default '',
                               `description` text NOT NULL default '',
                               `sortorder` int(10) unsigned NOT NULL default '0',
                               PRIMARY KEY  (`id`)