diff options
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index d289578f71..f3a12e5d3f 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -112,7 +112,7 @@ CREATE TABLE phpbb_bots ( # Table: 'phpbb_cache' CREATE TABLE phpbb_cache ( var_name varchar(255) DEFAULT '' NOT NULL, - var_ts int(10) UNSIGNED DEFAULT '0' NOT NULL, + var_expires int(10) UNSIGNED DEFAULT '0' NOT NULL, var_data text NOT NULL, PRIMARY KEY (var_name) ); @@ -763,7 +763,8 @@ CREATE TABLE phpbb_users ( user_actkey varchar(32) DEFAULT '' NOT NULL, user_newpasswd varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (user_id), - KEY user_birthday (user_birthday(6)) + KEY user_birthday (user_birthday(6)), + KEY username (username) ); # Table: 'phpbb_users_notes' |