aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/postgres_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
-rw-r--r--phpBB/install/schemas/postgres_schema.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index 426f2decbf..8892357805 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -1136,8 +1136,7 @@ CREATE TABLE phpbb_user_notifications (
item_id INT4 DEFAULT '0' NOT NULL CHECK (item_id >= 0),
user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
method varchar(255) DEFAULT '' NOT NULL,
- notify INT2 DEFAULT '1' NOT NULL CHECK (notify >= 0),
- PRIMARY KEY (item_type, item_id, user_id, method)
+ notify INT2 DEFAULT '1' NOT NULL CHECK (notify >= 0)
);