Index: trunk/include/onupdate.php
===================================================================
--- trunk/include/onupdate.php	(revision 34)
+++ trunk/include/onupdate.php	(revision 76)
@@ -100,4 +100,30 @@
 			)$charset_collate;";
 		dbDelta($queries);
+	}
+
+	if (! enhanced_table_check($mydirname,'group_role')){
+		$xp_prefix = $mydirname;
+		if ($xp_prefix == 'wordpress'){
+	 		$xp_prefix = 'wp';
+		}
+		
+		$charset_collate = '';
+		if ( version_compare(mysql_get_server_info(), '4.1.0', '>=') ) {
+			if ( ! empty($wpdb->charset) )
+			$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
+			if ( ! empty($wpdb->collate) )
+			$charset_collate .= " COLLATE $wpdb->collate";
+		}
+	
+		$group_role = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_group_role' ;
+		$views_queries ="CREATE TABLE $group_role (
+	  		groupid smallint(5) unsigned NOT NULL default '0',
+	  		name varchar(50)  NOT NULL default '' ,
+	  		description text  NOT NULL default '',
+	  		group_type varchar(10)  NOT NULL default '' ,
+			role varchar(20)  NOT NULL default '' ,
+	  		KEY groupid (groupid)
+			)$charset_collate;";
+		dbDelta($views_queries);
 	}