From aa33a48943862d101fa0b839727975f5317e5d14 Mon Sep 17 00:00:00 2001
From: z0rglub <z0rglub@piwigo.org>
Date: Fri, 25 Jun 2004 20:38:06 +0000
Subject: - moved index images.storage_category_id to images_i1

- new index images_i2 on images.date_available


git-svn-id: http://piwigo.org/svn/trunk@444 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 install/phpwebgallery_structure.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'install/phpwebgallery_structure.sql')

diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index 603949488..ab0edfa66 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -136,7 +136,8 @@ CREATE TABLE phpwebgallery_images (
   keywords varchar(255) default NULL,
   storage_category_id smallint(5) unsigned default NULL,
   PRIMARY KEY  (id),
-  KEY storage_category_id (storage_category_id)
+  KEY images_i2 (date_available),
+  KEY images_i1 (storage_category_id)
 ) TYPE=MyISAM;
 
 --
-- 
cgit v1.2.3

