diff options
Diffstat (limited to 'install')
| -rw-r--r-- | install/dbscheme.txt | 1 | ||||
| -rw-r--r-- | install/phpwebgallery_structure.sql | 3 |
2 files changed, 3 insertions, 1 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 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; -- |