Changeset 534 for trunk/xpressme_integration_kit/include/onupdate.php

Timestamp:

Mar 10, 2010, 4:47:23 PM (15 years ago)

Author:

toemon

Message:

グループ権限のMultiBlog対応 Fixes #298

File:

• trunk/xpressme_integration_kit/include/onupdate.php (modified) (2 diffs)

trunk/xpressme_integration_kit/include/onupdate.php

@@ -254 +254 @@
         }
 
+        $group_role = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_group_role' ;
         if (! enhanced_table_check($mydirname,'group_role')){
-                $group_role = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_group_role' ;
                 $queries ="CREATE TABLE $group_role (
                         groupid smallint(5) unsigned NOT NULL default '0',
+                        blog_id bigint(20) unsigned NOT NULL default '0',
                         name varchar(50)  NOT NULL default '' ,
                         description text  NOT NULL default '',
@@ -269 +270 @@
                 $db->queryF( $sql ) ;
                 $msgs[] = "$group_role table of XPressME was made.";
+        } else {
+                if (!is_found_table_column($group_role,'blog_id')){
+                        $queries ="ALTER TABLE $group_role ADD blog_id bigint(20)  AFTER groupid";
+                        $db->queryF( $queries ) ;
+                        $msgs[] = "$group_role  ADD blog_id .";
+                }
+                // The table is repaired.
+                $update_sql = "UPDATE $group_role SET blog_id = 1 WHERE(blog_id IS NULL OR blog_id < 1)";
+                $db->queryF( $update_sql ) ;
         }