php-blog-cvs

[<ste...@us...>]

Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1:/tmp/cvs-serv12415

Modified Files:
	db.sql serendipity_admin_installer.inc.php 
Log Message:
properly create the indexes


Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/db.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- db.sql	3 Apr 2003 19:47:03 -0000	1.10
+++ db.sql	3 Apr 2003 19:52:25 -0000	1.11
@@ -47,7 +47,7 @@
   categoryid int(11) default null
 );
 
-CREATE FULLTEXT INDEX entry on {PREFIX}entries (title,body,extended);
+CREATE {FULLTEXT} INDEX entry on {PREFIX}entries (title,body,extended);
 
 #
 # table structure for table '{PREFIX}references'

Index: serendipity_admin_installer.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/serendipity_admin_installer.inc.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- serendipity_admin_installer.inc.php	3 Apr 2003 16:32:28 -0000	1.7
+++ serendipity_admin_installer.inc.php	3 Apr 2003 19:52:25 -0000	1.8
@@ -131,6 +131,10 @@
                 $in_table = 1;
                 $def = $line;
             }
+	
+			if (preg_match('#^create\s*(\{fulltext\}|unique)\s*index#i', $line)) {
+				array_push($queries, $line);
+			}
         }
     }
     fclose($fp);