Changeset 62

Timestamp:

12/22/05 09:03:17 (7 years ago)

Author:

fabien

Message:

fixed 2 bugs in search engine

Files:

• trunk/config/schema.xml (modified) (1 diff)
• trunk/data/sql/schema.sql (modified) (1 diff)
• trunk/lib/model/QuestionPeer.php (modified) (1 diff)

trunk/config/schema.xml

@@ -99 +99 @@
-     </foreign-key>
-     <column name="word" type="varchar" size="255" />
+     <index name="word_index">
+       <index-column name="word" />
+     </index>
-     <column name="weight" type="integer" />
-   </table>

trunk/data/sql/schema.sql

@@ -147 +147 @@
-    `word` VARCHAR(255) , 
-    `weight` INTEGER ,  
+    KEY `word_index` (`word`),  
-    INDEX `ask_search_index_FI_1` (`question_id`), 
-    CONSTRAINT `ask_search_index_FK_1` 

trunk/lib/model/QuestionPeer.php

@@ -108 +108 @@
-    $nb_words = count($words);
-
+    if (!$words)
+    {
+      return array();
+    }
+
-    $con = Propel::getConnection();
-    $query = '