aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--admin/phpwebgallery_structure.sql5
1 files changed, 3 insertions, 2 deletions
diff --git a/admin/phpwebgallery_structure.sql b/admin/phpwebgallery_structure.sql
index cdd6f22b3..d6797c162 100644
--- a/admin/phpwebgallery_structure.sql
+++ b/admin/phpwebgallery_structure.sql
@@ -148,7 +148,8 @@ CREATE TABLE phpwebgallery_images (
height smallint(9) unsigned default NULL,
keywords varchar(255) default NULL,
storage_category_id smallint(5) unsigned default NULL,
- PRIMARY KEY (id)
+ PRIMARY KEY (id),
+ KEY storage_category_id (storage_category_id)
) TYPE=MyISAM;
--
@@ -220,7 +221,7 @@ CREATE TABLE phpwebgallery_users (
long_period tinyint(3) unsigned NOT NULL default '14',
template varchar(255) NOT NULL default 'default',
PRIMARY KEY (id),
- UNIQUE KEY pseudo (username)
+ UNIQUE KEY username (username)
) TYPE=MyISAM;
--