[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    kdenonbeta/krecipes/data
From:       Unai Garro <Unai.Garro () ee ! ed ! ac ! uk>
Date:       2003-09-18 22:33:14
[Download RAW message or body]

CVS commit by uga: 

use indexes by default too for the ingredient_list. 


  M +3 -1      structure.sql   1.13


--- kdenonbeta/krecipes/data/structure.sql  #1.12:1.13
@@ -33,5 +33,7 @@
   ingredient_id int(11) default NULL,
   amount float default NULL,
-  unit_id int(11) default NULL
+  unit_id int(11) default NULL,
+  INDEX  ridil_index (recipe_id),
+  INDEX iidil_index (ingredient_id))
 ) TYPE=MyISAM;
 CREATE TABLE ingredient_properties (


[prev in list] [next in list] [prev in thread] [next in thread]