aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2003-05-21 00:13:59 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2003-05-21 00:13:59 +0000
commitf3c308f67cb3730e93ce1455aaac931c85065d6b (patch)
treec7de59462b4f311729d91c6e2504167ff8cfb580
parent659554b0962c165dab4d5794995bcdd9d8238cf0 (diff)
downloadforums-f3c308f67cb3730e93ce1455aaac931c85065d6b.tar
forums-f3c308f67cb3730e93ce1455aaac931c85065d6b.tar.gz
forums-f3c308f67cb3730e93ce1455aaac931c85065d6b.tar.bz2
forums-f3c308f67cb3730e93ce1455aaac931c85065d6b.tar.xz
forums-f3c308f67cb3730e93ce1455aaac931c85065d6b.zip
Add a 6 char key to user_birthday
git-svn-id: file:///svn/phpbb/trunk@4036 89ea8834-ac86-4346-8a33-228a782c2dd0
-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))
);