diff options
| author | plegall <plg@piwigo.org> | 2004-11-21 11:13:48 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2004-11-21 11:13:48 +0000 |
| commit | ec015abc782f6e615ea561e11132aa71076cdd04 (patch) | |
| tree | bcb6d38ccd043bcec51de1529a9e755b408c83f3 /install/dbscheme.txt | |
| parent | 9f037e7cea37aafd562fa494afd9a289c60a5855 (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/dbscheme.txt')
| -rw-r--r-- | install/dbscheme.txt | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/install/dbscheme.txt b/install/dbscheme.txt index 070f7f0bc..654ccbc28 100644 --- a/install/dbscheme.txt +++ b/install/dbscheme.txt @@ -140,5 +140,6 @@ index:images_i2 table:images column:date_available index:images_i1 table:images column:storage_category_id index:images_i3 table:images column:average_rate index:images_i4 table:images column:hit +index:images_i5 table:images column:date_creation index:sites_ui1 table:sites column:galleries_url index:users_ui1 table:users column:username |