diff options
| author | z0rglub <z0rglub@piwigo.org> | 2004-06-25 20:38:06 +0000 |
|---|---|---|
| committer | z0rglub <z0rglub@piwigo.org> | 2004-06-25 20:38:06 +0000 |
| commit | aa33a48943862d101fa0b839727975f5317e5d14 (patch) | |
| tree | bfcfedb29b4e780c1fc6183d2ae16a2855f76f83 /install/phpwebgallery_structure.sql | |
| parent | 537af4c95944dc5205a8c1ac70a813c933fd2f4e (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
Diffstat (limited to 'install/phpwebgallery_structure.sql')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 3 |
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; -- |