aboutsummaryrefslogtreecommitdiffstats
path: root/install/phpwebgallery_structure.sql
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2004-11-21 11:13:48 +0000
committerplegall <plg@piwigo.org>2004-11-21 11:13:48 +0000
commitec015abc782f6e615ea561e11132aa71076cdd04 (patch)
treebcb6d38ccd043bcec51de1529a9e755b408c83f3 /install/phpwebgallery_structure.sql
parent9f037e7cea37aafd562fa494afd9a289c60a5855 (diff)
optimization : instead of reading each $conf['calendar_datefield'] for
matching YEAR() and MONTH(), use of SQL statement BETWEEN ... AND ... on the date field + new index image_i5 on date_creation (default date field for calendar) git-svn-id: http://piwigo.org/svn/trunk@612 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/phpwebgallery_structure.sql')
-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 d9dbf2161..d24d7d023 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -145,7 +145,8 @@ CREATE TABLE phpwebgallery_images (
KEY images_i2 (date_available),
KEY images_i1 (storage_category_id),
KEY images_i3 (average_rate),
- KEY images_i4 (hit)
+ KEY images_i4 (hit),
+ KEY images_i5 (date_creation)
) TYPE=MyISAM;
--