aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/postgres_schema.sql
diff options
context:
space:
mode:
authorAndreas Fischer <bantu@phpbb.com>2011-07-05 00:27:04 +0200
committerAndreas Fischer <bantu@phpbb.com>2011-07-05 00:27:04 +0200
commitf5d86d06040de198d15fe9596c63186da02347d8 (patch)
tree23616fb831fef47ea8665aef55cf2594eb59b3fd /phpBB/install/schemas/postgres_schema.sql
parentffa6f3448fdfe6d076c894231ebbd59e3b51e2ba (diff)
parentcb7604dcd83bf3a4ddf6ace1282974eaf475c8d8 (diff)
downloadforums-f5d86d06040de198d15fe9596c63186da02347d8.tar
forums-f5d86d06040de198d15fe9596c63186da02347d8.tar.gz
forums-f5d86d06040de198d15fe9596c63186da02347d8.tar.bz2
forums-f5d86d06040de198d15fe9596c63186da02347d8.tar.xz
forums-f5d86d06040de198d15fe9596c63186da02347d8.zip
Merge remote-tracking branch 'naderman/ticket/10247' into prep-release-3.0.9
* naderman/ticket/10247: [ticket/10247] Removing attempt_id column from the 3.0.8 to 3.0.9-RC1 updater. [ticket/10247] Add a db_tools test for the removal of a primary key column. [ticket/10247] Add empty data section to database update for RC4 [ticket/10247] Remove unecessary attempt_id primary key column
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
-rw-r--r--phpBB/install/schemas/postgres_schema.sql6
1 files changed, 1 insertions, 5 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index 359ec325d7..cf655cb1c7 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -527,18 +527,14 @@ CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id);
/*
Table: 'phpbb_login_attempts'
*/
-CREATE SEQUENCE phpbb_login_attempts_seq;
-
CREATE TABLE phpbb_login_attempts (
- attempt_id INT4 DEFAULT nextval('phpbb_login_attempts_seq'),
attempt_ip varchar(40) DEFAULT '' NOT NULL,
attempt_browser varchar(150) DEFAULT '' NOT NULL,
attempt_forwarded_for varchar(255) DEFAULT '' NOT NULL,
attempt_time INT4 DEFAULT '0' NOT NULL CHECK (attempt_time >= 0),
user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
username varchar(255) DEFAULT '0' NOT NULL,
- username_clean varchar_ci DEFAULT '0' NOT NULL,
- PRIMARY KEY (attempt_id)
+ username_clean varchar_ci DEFAULT '0' NOT NULL
);
CREATE INDEX phpbb_login_attempts_att_ip ON phpbb_login_attempts (attempt_ip, attempt_time);