[xoops-svn] SF.net SVN: xoops:[9875] XoopsModules/newbb/branches/alfred/newbb

[<dh...@us...>]

Revision: 9875
          http://xoops.svn.sourceforge.net/xoops/?rev=9875&view=rev
Author:   dhcst
Date:     2012-07-14 14:14:48 +0000 (Sat, 14 Jul 2012)
Log Message:
-----------
add index for table bb_posts

Modified Paths:
--------------
    XoopsModules/newbb/branches/alfred/newbb/include/module.php

Added Paths:
-----------
    XoopsModules/newbb/branches/alfred/newbb/sql/mysql.430.sql

Modified: XoopsModules/newbb/branches/alfred/newbb/include/module.php
===================================================================
--- XoopsModules/newbb/branches/alfred/newbb/include/module.php	2012-07-14 11:52:44 UTC (rev 9874)
+++ XoopsModules/newbb/branches/alfred/newbb/include/module.php	2012-07-14 14:14:48 UTC (rev 9875)
@@ -83,6 +83,10 @@
                 " CHANGE `poster_ip` `poster_ip` varchar(15) NOT NULL default '0.0.0.0'";
         $GLOBALS['xoopsDB']->queryF( $sql );      
     }
+
+	if ($oldversion < 431) {
+        $GLOBALS['xoopsDB']->queryFromFile(XOOPS_ROOT_PATH."/modules/".$module->getVar("dirname", "n")."/sql/mysql.430.sql");
+    }
     
 	if (!empty($newbbConfig["syncOnUpdate"])) {
 		mod_loadFunctions("recon", "newbb");

Added: XoopsModules/newbb/branches/alfred/newbb/sql/mysql.430.sql
===================================================================
--- XoopsModules/newbb/branches/alfred/newbb/sql/mysql.430.sql	                        (rev 0)
+++ XoopsModules/newbb/branches/alfred/newbb/sql/mysql.430.sql	2012-07-14 14:14:48 UTC (rev 9875)
@@ -0,0 +1,5 @@
+DROP INDEX `approved` ON `bb_posts`;
+	
+ALTER TABLE `bb_posts` ADD INDEX `forumid_uid` ( `forum_id` , `uid` );
+ALTER TABLE `bb_posts` ADD INDEX `topicid_uid` ( `topic_id` , `uid` );
+ALTER TABLE `bb_posts` ADD INDEX `forumid_approved_postid` ( `forum_id` , `approved` , `post_id` );
\ No newline at end of file

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.