diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2011-10-14 04:29:53 +0200 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2011-10-14 14:30:51 +0200 |
| commit | d86fccf9c909602c37ec97577a19dc442e22206b (patch) | |
| tree | a5c6725ba6cf6c91bef2b0a77a8129c0912414ae /phpBB/includes/db | |
| parent | 4e69fe68590cca0db66cc90af12e74c58bac10be (diff) | |
| download | forums-d86fccf9c909602c37ec97577a19dc442e22206b.tar forums-d86fccf9c909602c37ec97577a19dc442e22206b.tar.gz forums-d86fccf9c909602c37ec97577a19dc442e22206b.tar.bz2 forums-d86fccf9c909602c37ec97577a19dc442e22206b.tar.xz forums-d86fccf9c909602c37ec97577a19dc442e22206b.zip | |
[ticket/10327] Change CREATE INDEX to ALTER TABLE table ADD INDEX for MySQL.
* CREATE INDEX is internally mapped to an ALTER INDEX statement.
* CREATE INDEX requires the INDEX permission.
* ALTER TABLE requires the (more powerful) ALTER permission.
* We require the ALTER permission anyway for operation.
* Changing CREATE INDEX to ALTER TABLE thus removes dependency on the INDEX
permission which is good because some management software does not give
out the INDEX permission by default.
http://dev.mysql.com/doc/refman/5.0/en/create-index.html
PHPBB3-10327
Diffstat (limited to 'phpBB/includes/db')
| -rw-r--r-- | phpBB/includes/db/db_tools.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/includes/db/db_tools.php b/phpBB/includes/db/db_tools.php index 10ca6c0a1f..0d8cf7fdab 100644 --- a/phpBB/includes/db/db_tools.php +++ b/phpBB/includes/db/db_tools.php @@ -2145,7 +2145,7 @@ class phpbb_db_tools } // no break case 'mysql_41': - $statements[] = 'CREATE INDEX ' . $index_name . ' ON ' . $table_name . '(' . implode(', ', $column) . ')'; + $statements[] = 'ALTER TABLE ' . $table_name . ' ADD INDEX ' . $index_name . '(' . implode(', ', $column) . ')'; break; case 'mssql': |