diff options
| author | Tristan Darricau <github@nicofuma.fr> | 2014-08-07 14:25:37 +0200 |
|---|---|---|
| committer | Tristan Darricau <github@nicofuma.fr> | 2014-08-07 14:27:12 +0200 |
| commit | 2b3e15cf64fdc3f3f1fd4067321c92d4a20c1dd9 (patch) | |
| tree | 601cdd308fc69e72fe6bbd6217bcb96a8675b935 /phpBB | |
| parent | 27b4ab92414c42345f6737890051268f082ffc81 (diff) | |
| download | forums-2b3e15cf64fdc3f3f1fd4067321c92d4a20c1dd9.tar forums-2b3e15cf64fdc3f3f1fd4067321c92d4a20c1dd9.tar.gz forums-2b3e15cf64fdc3f3f1fd4067321c92d4a20c1dd9.tar.bz2 forums-2b3e15cf64fdc3f3f1fd4067321c92d4a20c1dd9.tar.xz forums-2b3e15cf64fdc3f3f1fd4067321c92d4a20c1dd9.zip | |
[ticket/12873] Add migration to rename the index
PHPBB3-12873
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/install/schemas/schema.json | 16 | ||||
| -rw-r--r-- | phpBB/phpbb/db/migration/data/v310/rename_too_long_indexes.php | 38 |
2 files changed, 46 insertions, 8 deletions
diff --git a/phpBB/install/schemas/schema.json b/phpBB/install/schemas/schema.json index 81e658c153..1a9b9b62b7 100644 --- a/phpBB/install/schemas/schema.json +++ b/phpBB/install/schemas/schema.json @@ -2397,14 +2397,6 @@ ] }, "KEYS": { - "un_mtch": [ - "UNIQUE", - [ - "word_id", - "post_id", - "title_match" - ] - ], "word_id": [ "INDEX", "word_id" @@ -2412,6 +2404,14 @@ "post_id": [ "INDEX", "post_id" + ], + "un_mtch": [ + "UNIQUE", + [ + "word_id", + "post_id", + "title_match" + ] ] } }, diff --git a/phpBB/phpbb/db/migration/data/v310/rename_too_long_indexes.php b/phpBB/phpbb/db/migration/data/v310/rename_too_long_indexes.php new file mode 100644 index 0000000000..8d2a15d8ea --- /dev/null +++ b/phpBB/phpbb/db/migration/data/v310/rename_too_long_indexes.php @@ -0,0 +1,38 @@ +<?php +/** +* +* This file is part of the phpBB Forum Software package. +* +* @copyright (c) phpBB Limited <https://www.phpbb.com> +* @license GNU General Public License, version 2 (GPL-2.0) +* +* For full copyright and license information, please see +* the docs/CREDITS.txt file. +* +*/ + +namespace phpbb\db\migration\data\v310; + +class rename_too_long_indexes extends \phpbb\db\migration\migration +{ + static public function depends_on() + { + return array('\phpbb\db\migration\data\v30x\release_3_0_0'); + } + + public function update_schema() + { + return array( + 'drop_keys' => array( + $this->table_prefix . 'search_wordmatch' => array( + 'unq_mtch', + ), + ), + 'add_unique_index' => array( + $this->table_prefix . 'search_wordmatch' => array( + 'un_mtch' => array('word_id', 'post_id', 'title_match'), + ), + ), + ); + } +} |