aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-06-25 20:38:06 +0000
committerz0rglub <z0rglub@piwigo.org>2004-06-25 20:38:06 +0000
commitaa33a48943862d101fa0b839727975f5317e5d14 (patch)
treebfcfedb29b4e780c1fc6183d2ae16a2855f76f83
parent537af4c95944dc5205a8c1ac70a813c933fd2f4e (diff)
- 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
-rw-r--r--install/phpwebgallery_structure.sql3
1 files changed, 2 insertions, 1 deletions
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;
--