diff options
| author | David Colón <david@davidiq.com> | 2017-05-24 17:34:17 -0400 |
|---|---|---|
| committer | David Colón <david@davidiq.com> | 2017-05-25 09:40:58 -0400 |
| commit | a6317dc52dded6eeb3adb174b5d843673b7dbc15 (patch) | |
| tree | cebae4f9f4c5053adc17d08f1a9f80747fd5851e /phpBB | |
| parent | 4c67f65d5db539ffc94259549d1cbf270703d7be (diff) | |
| download | forums-a6317dc52dded6eeb3adb174b5d843673b7dbc15.tar forums-a6317dc52dded6eeb3adb174b5d843673b7dbc15.tar.gz forums-a6317dc52dded6eeb3adb174b5d843673b7dbc15.tar.bz2 forums-a6317dc52dded6eeb3adb174b5d843673b7dbc15.tar.xz forums-a6317dc52dded6eeb3adb174b5d843673b7dbc15.zip | |
[ticket/14992] Reduce notification table col sizes
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/phpbb/db/migration/data/v32x/user_notifications_table_reduce_column_sizes.php | 48 | ||||
| -rw-r--r-- | phpBB/phpbb/db/migration/data/v32x/user_notifications_table_unique_index.php | 2 |
2 files changed, 49 insertions, 1 deletions
diff --git a/phpBB/phpbb/db/migration/data/v32x/user_notifications_table_reduce_column_sizes.php b/phpBB/phpbb/db/migration/data/v32x/user_notifications_table_reduce_column_sizes.php new file mode 100644 index 0000000000..c2efb8fd4f --- /dev/null +++ b/phpBB/phpbb/db/migration/data/v32x/user_notifications_table_reduce_column_sizes.php @@ -0,0 +1,48 @@ +<?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\v32x; + +class user_notifications_table_reduce_column_sizes extends \phpbb\db\migration\migration +{ + static public function depends_on() + { + return array( + '\phpbb\db\migration\data\v32x\user_notifications_table_remove_duplicates', + ); + } + + public function update_schema() + { + return array( + 'change_columns' => array( + $this->table_prefix . 'user_notifications' => array( + 'item_type' => array('VCHAR:165', ''), + 'method' => array('VCHAR:165', ''), + ), + ), + ); + } + + public function revert_schema() + { + return array( + 'change_columns' => array( + $this->table_prefix . 'user_notifications' => array( + 'item_type' => array('VCHAR:255', ''), + 'method' => array('VCHAR:255', ''), + ), + ), + ); + } +} diff --git a/phpBB/phpbb/db/migration/data/v32x/user_notifications_table_unique_index.php b/phpBB/phpbb/db/migration/data/v32x/user_notifications_table_unique_index.php index 157a12472b..e46c231b7b 100644 --- a/phpBB/phpbb/db/migration/data/v32x/user_notifications_table_unique_index.php +++ b/phpBB/phpbb/db/migration/data/v32x/user_notifications_table_unique_index.php @@ -18,7 +18,7 @@ class user_notifications_table_unique_index extends \phpbb\db\migration\migratio static public function depends_on() { return array( - '\phpbb\db\migration\data\v32x\user_notifications_table_remove_duplicates', + '\phpbb\db\migration\data\v32x\user_notifications_table_reduce_column_sizes', ); } |