[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 18:48:34
[Download RAW message or body]

CVS commit by uga: 

Add missing indexes to the default DB structure too


  M +3 -1      structure.sql   1.12


--- kdenonbeta/krecipes/data/structure.sql  #1.11:1.12
@@ -15,5 +15,7 @@
 CREATE TABLE category_list (
   recipe_id int(11) NOT NULL default '0',
-  category_id int(11) NOT NULL default '0'
+  category_id int(11) NOT NULL default '0',
+  INDEX  rid_index (recipe_id),
+  INDEX cid_index (category_id))
 ) TYPE=MyISAM;
 CREATE TABLE db_info (


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