aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--phpBB/install/schemas/mysql_schema.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index a2a717eafe..d54a77e1a5 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -887,7 +887,8 @@ CREATE TABLE phpbb_users (
user_newpasswd varchar(32) DEFAULT '' NOT NULL,
user_occ varchar(255) DEFAULT '' NOT NULL,
user_interests varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (user_id)
+ PRIMARY KEY (user_id),
+ KEY user_birthday (user_birthday(6))
);