diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2004-08-02 18:54:35 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2004-08-02 18:54:35 +0000 |
| commit | 3fabbb14e7b49dd660c14da4aaf2d2d26bbba1ac (patch) | |
| tree | d5e1d7d2bbbb4405d61ab9ab07646871556c9224 | |
| parent | bd4e95f7ab828064ad476d7f72f5c300887fe63e (diff) | |
| download | forums-3fabbb14e7b49dd660c14da4aaf2d2d26bbba1ac.tar forums-3fabbb14e7b49dd660c14da4aaf2d2d26bbba1ac.tar.gz forums-3fabbb14e7b49dd660c14da4aaf2d2d26bbba1ac.tar.bz2 forums-3fabbb14e7b49dd660c14da4aaf2d2d26bbba1ac.tar.xz forums-3fabbb14e7b49dd660c14da4aaf2d2d26bbba1ac.zip | |
- small schema fix
git-svn-id: file:///svn/phpbb/trunk@4953 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index bf83fab1d9..e86edf8b6b 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -41,7 +41,7 @@ CREATE TABLE phpbb_auth_groups ( # Table: phpbb_auth_options CREATE TABLE phpbb_auth_options ( - auth_option_id tinyint(4) NOT NULL auto_increment, + auth_option_id smallint(5) UNSIGNED NOT NULL auto_increment, auth_option char(20) NOT NULL, is_global tinyint(1) DEFAULT '0' NOT NULL, is_local tinyint(1) DEFAULT '0' NOT NULL, @@ -103,9 +103,8 @@ CREATE TABLE phpbb_bookmarks ( topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, order_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - KEY topic_id (topic_id), - KEY user_id (user_id), - KEY notify_status (order_id) + KEY order_id (order_id), + KEY topic_user_id (topic_id, user_id) ); # Table: 'phpbb_bots' |