diff options
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 4d1c836d9a..c7a254e2e1 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -497,7 +497,7 @@ CREATE TABLE phpbb_ratings ( post_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', user_id tinyint(4) UNSIGNED UNSIGNED NOT NULL DEFAULT '0', rating tinyint(4) NOT NULL, - PRIMARY KEY (post_id, user_id), + KEY post_id (post_id), KEY user_id (user_id) ); @@ -881,7 +881,7 @@ CREATE TABLE phpbb_users ( user_aim varchar(255) DEFAULT '' NOT NULL, user_yim varchar(255) DEFAULT '' NOT NULL, user_msnm varchar(255) DEFAULT '' NOT NULL, - user_jabber varhcar(255) DEFAULT '' NOT NULL, + user_jabber varchar(255) DEFAULT '' NOT NULL, user_website varchar(100) DEFAULT '' NOT NULL, user_actkey varchar(32) DEFAULT '' NOT NULL, user_newpasswd varchar(32) DEFAULT '' NOT NULL, |