PHP vB_Database_Alter_MySQL::add_index示例

示例#1

文件： options.php 项目： benyamin20/vbregistration

     if ($vbulletin->GPC['deleteindex']) {
         if ($db_alter->fetch_table_info('post')) {
             $db_alter->drop_index('title');
         } else {
             print_stop_message('dbalter_' . $db_alter->fetch_error(), $db_alter->fetch_error_message());
         }
         if ($db_alter->fetch_table_info('thread')) {
             $db_alter->drop_index('title');
         } else {
             print_stop_message('dbalter_' . $db_alter->fetch_error(), $db_alter->fetch_error_message());
         }
     }
 } else {
     // add indices
     if ($db_alter->fetch_table_info('post')) {
         if (!$db_alter->add_index('title', array('title', 'pagetext'), 'fulltext', true)) {
             print_stop_message('dbalter_' . $db_alter->fetch_error(), $db_alter->fetch_error_message());
         }
     } else {
         print_stop_message('dbalter_' . $db_alter->fetch_error(), $db_alter->fetch_error_message());
     }
     if ($db_alter->fetch_table_info('thread')) {
         if (!$db_alter->add_index('title', array('title'), 'fulltext', true)) {
             $error = $db_alter->fetch_error();
             $errormsg = $db_alter->fetch_error_message();
             // Remove index that was added to post above.
             if ($db_alter->fetch_table_info('post')) {
                 $db_alter->drop_index('title');
             }
             print_stop_message('dbalter_' . $error, $errormsg);
         }