diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2013-07-30 02:01:24 +0200 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2013-07-30 02:01:24 +0200 |
| commit | 404f2881135373060086116003122a9f6d851adf (patch) | |
| tree | 90d348fc536dc0dbe51dd7545b6a6f87693caab6 | |
| parent | 469d9ee1719c02c097291a1bf61c1f77c1e452a4 (diff) | |
| download | forums-404f2881135373060086116003122a9f6d851adf.tar forums-404f2881135373060086116003122a9f6d851adf.tar.gz forums-404f2881135373060086116003122a9f6d851adf.tar.bz2 forums-404f2881135373060086116003122a9f6d851adf.tar.xz forums-404f2881135373060086116003122a9f6d851adf.zip | |
[ticket/11753] Update MySQL upgrader schema data.
PHPBB3-11753
| -rw-r--r-- | phpBB/develop/mysql_upgrader.php | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/phpBB/develop/mysql_upgrader.php b/phpBB/develop/mysql_upgrader.php index 05d279a099..b3f40b2ca4 100644 --- a/phpBB/develop/mysql_upgrader.php +++ b/phpBB/develop/mysql_upgrader.php @@ -694,6 +694,24 @@ function get_schema_struct() ), ); + $schema_data['phpbb_login_attempts'] = array( + 'COLUMNS' => array( + 'attempt_ip' => array('VCHAR:40', ''), + 'attempt_browser' => array('VCHAR:150', ''), + 'attempt_forwarded_for' => array('VCHAR:255', ''), + 'attempt_time' => array('TIMESTAMP', 0), + 'user_id' => array('UINT', 0), + 'username' => array('VCHAR_UNI:255', 0), + 'username_clean' => array('VCHAR_CI', 0), + ), + 'KEYS' => array( + 'att_ip' => array('INDEX', array('attempt_ip', 'attempt_time')), + 'att_for' => array('INDEX', array('attempt_forwarded_for', 'attempt_time')), + 'att_time' => array('INDEX', array('attempt_time')), + 'user_id' => array('INDEX', 'user_id'), + ), + ); + $schema_data['phpbb_moderator_cache'] = array( 'COLUMNS' => array( 'forum_id' => array('UINT', 0), @@ -897,6 +915,7 @@ function get_schema_struct() 'field_default_value' => array('VCHAR_UNI', ''), 'field_validation' => array('VCHAR_UNI:20', ''), 'field_required' => array('BOOL', 0), + 'field_show_novalue' => array('BOOL', 0), 'field_show_on_reg' => array('BOOL', 0), 'field_show_on_vt' => array('BOOL', 0), 'field_show_profile' => array('BOOL', 0), |