diff options
author | Andreas Fischer <bantu@phpbb.com> | 2011-07-05 00:27:04 +0200 |
---|---|---|
committer | Andreas Fischer <bantu@phpbb.com> | 2011-07-05 00:27:04 +0200 |
commit | f5d86d06040de198d15fe9596c63186da02347d8 (patch) | |
tree | 23616fb831fef47ea8665aef55cf2594eb59b3fd /phpBB/install/schemas/postgres_schema.sql | |
parent | ffa6f3448fdfe6d076c894231ebbd59e3b51e2ba (diff) | |
parent | cb7604dcd83bf3a4ddf6ace1282974eaf475c8d8 (diff) | |
download | forums-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.sql | 6 |
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); |