From aa33a48943862d101fa0b839727975f5317e5d14 Mon Sep 17 00:00:00 2001 From: z0rglub 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(-) 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