aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--install/dbscheme.txt1
-rw-r--r--install/phpwebgallery_structure.sql3
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;
--