diff options
| author | Nils Adermann <naderman@naderman.de> | 2007-03-13 22:00:55 +0000 |
|---|---|---|
| committer | Nils Adermann <naderman@naderman.de> | 2007-03-13 22:00:55 +0000 |
| commit | ce8b00801edabd8de8b88891d6997309e7ca0459 (patch) | |
| tree | 65788f228055ca6d8b50242ee6f94ff914de70d4 /phpBB/develop | |
| parent | 5e06885ea4acd2dbe0c05fdb3db61577b79669d1 (diff) | |
| download | forums-ce8b00801edabd8de8b88891d6997309e7ca0459.tar forums-ce8b00801edabd8de8b88891d6997309e7ca0459.tar.gz forums-ce8b00801edabd8de8b88891d6997309e7ca0459.tar.bz2 forums-ce8b00801edabd8de8b88891d6997309e7ca0459.tar.xz forums-ce8b00801edabd8de8b88891d6997309e7ca0459.zip | |
- improvements to search indexing performance, espacially tidy() by adding a word_count column, the database update from b5 to next version will take quite a while on bigger databases, I also lowered the default common word threshold from 20 to 5 percent, big boards might want to use 3 or 2 percent, 20 was way too high
- added some keys to ACL tables, great improvement of auth query performance
- we will only add new language strings to install.php language file and won't modify any, if a language file is updated before phpBB is updated, the updater will not overwrite the user's language with english if install.php was modified
git-svn-id: file:///svn/phpbb/trunk@7182 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/develop')
| -rw-r--r-- | phpBB/develop/create_schema_files.php | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index 01044e63eb..52e1af0e3a 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -810,6 +810,7 @@ function get_schema_struct() 'KEYS' => array( 'group_id' => array('INDEX', 'group_id'), 'auth_opt_id' => array('INDEX', 'auth_option_id'), + 'auth_role_id' => array('INDEX', 'auth_role_id'), ), ); @@ -849,6 +850,9 @@ function get_schema_struct() 'auth_setting' => array('TINT:2', 0), ), 'PRIMARY_KEY' => array('role_id', 'auth_option_id'), + 'KEYS' => array( + 'auth_option_id' => array('INDEX', 'auth_option_id'), + ), ); $schema_data['phpbb_acl_users'] = array( @@ -862,6 +866,7 @@ function get_schema_struct() 'KEYS' => array( 'user_id' => array('INDEX', 'user_id'), 'auth_option_id' => array('INDEX', 'auth_option_id'), + 'auth_role_id' => array('INDEX', 'auth_role_id'), ), ); @@ -1461,10 +1466,12 @@ function get_schema_struct() 'word_id' => array('UINT', NULL, 'auto_increment'), 'word_text' => array('VCHAR_UNI', ''), 'word_common' => array('BOOL', 0), + 'word_count' => array('UINT', 0), ), 'PRIMARY_KEY' => 'word_id', 'KEYS' => array( 'wrd_txt' => array('UNIQUE', 'word_text'), + 'wrd_cnt' => array('INDEX', 'word_count'), ), ); |