aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mysql_40_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/mysql_40_schema.sql')
-rw-r--r--phpBB/install/schemas/mysql_40_schema.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql
index fef5357d2a..19df59f6f2 100644
--- a/phpBB/install/schemas/mysql_40_schema.sql
+++ b/phpBB/install/schemas/mysql_40_schema.sql
@@ -884,8 +884,7 @@ CREATE TABLE phpbb_user_notifications (
item_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
method varbinary(255) DEFAULT '' NOT NULL,
- notify tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- PRIMARY KEY (item_type, item_id, user_id, method)
+ notify tinyint(1) UNSIGNED DEFAULT '1' NOT NULL
);