Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 3 |
CRAP | |
0.00% |
0 / 327 |
| default_data_type_ids | |
0.00% |
0 / 1 |
|
0.00% |
0 / 3 |
12 | |
0.00% |
0 / 327 |
| depends_on | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 3 |
|||
| update_schema | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 162 |
|||
| revert_schema | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 162 |
|||
| <?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\v320; | |
| class default_data_type_ids extends \phpbb\db\migration\migration | |
| { | |
| static public function depends_on() | |
| { | |
| return array( | |
| '\phpbb\db\migration\data\v320\v320a2', | |
| '\phpbb\db\migration\data\v320\oauth_states', | |
| ); | |
| } | |
| public function update_schema() | |
| { | |
| return array( | |
| 'change_columns' => array( | |
| $this->table_prefix . 'acl_users' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'attachments' => array( | |
| 'attach_id' => array('ULINT', null, 'auto_increment'), | |
| 'post_msg_id' => array('ULINT', 0), | |
| 'poster_id' => array('ULINT', 0), | |
| 'topic_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'banlist' => array( | |
| 'ban_id' => array('ULINT', null, 'auto_increment'), | |
| 'ban_userid' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'bookmarks' => array( | |
| 'topic_id' => array('ULINT', 0), | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'bots' => array( | |
| 'bot_id' => array('ULINT', null, 'auto_increment'), | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'drafts' => array( | |
| 'draft_id' => array('ULINT', null, 'auto_increment'), | |
| 'user_id' => array('ULINT', 0), | |
| 'topic_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'forums' => array( | |
| 'forum_last_post_id' => array('ULINT', 0), | |
| 'forum_last_poster_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'forums_access' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'forums_track' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'forums_watch' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'log' => array( | |
| 'log_id' => array('ULINT', null, 'auto_increment'), | |
| 'post_id' => array('ULINT', 0), | |
| 'reportee_id' => array('ULINT', 0), | |
| 'user_id' => array('ULINT', 0), | |
| 'topic_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'login_attempts' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'moderator_cache' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'notifications' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'oauth_accounts' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'oauth_states' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'oauth_tokens' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'poll_options' => array( | |
| 'topic_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'poll_votes' => array( | |
| 'topic_id' => array('ULINT', 0), | |
| 'vote_user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'posts' => array( | |
| 'post_id' => array('ULINT', null, 'auto_increment'), | |
| 'poster_id' => array('ULINT', 0), | |
| 'post_delete_user' => array('ULINT', 0), | |
| 'post_edit_user' => array('ULINT', 0), | |
| 'topic_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'privmsgs' => array( | |
| 'author_id' => array('ULINT', 0), | |
| 'message_edit_user' => array('ULINT', 0), | |
| 'msg_id' => array('ULINT', null, 'auto_increment'), | |
| ), | |
| $this->table_prefix . 'privmsgs_folder' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'privmsgs_rules' => array( | |
| 'rule_user_id' => array('ULINT', 0), | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'privmsgs_to' => array( | |
| 'author_id' => array('ULINT', 0), | |
| 'msg_id' => array('ULINT', 0), | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'profile_fields_data' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'reports' => array( | |
| 'report_id' => array('ULINT', 0), | |
| 'pm_id' => array('ULINT', 0), | |
| 'post_id' => array('ULINT', 0), | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'search_wordlist' => array( | |
| 'word_id' => array('ULINT', null, 'auto_increment'), | |
| ), | |
| $this->table_prefix . 'search_wordmatch' => array( | |
| 'post_id' => array('ULINT', 0), | |
| 'word_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'sessions' => array( | |
| 'session_user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'sessions_keys' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'topics' => array( | |
| 'topic_id' => array('ULINT', null, 'auto_increment'), | |
| 'topic_poster' => array('ULINT', 0), | |
| 'topic_first_post_id' => array('ULINT', 0), | |
| 'topic_last_post_id' => array('ULINT', 0), | |
| 'topic_last_poster_id' => array('ULINT', 0), | |
| 'topic_moved_id' => array('ULINT', 0), | |
| 'topic_delete_user' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'topics_track' => array( | |
| 'user_id' => array('ULINT', 0), | |
| 'topic_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'topics_posted' => array( | |
| 'user_id' => array('ULINT', 0), | |
| 'topic_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'topics_watch' => array( | |
| 'user_id' => array('ULINT', 0), | |
| 'topic_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'user_notifications' => array( | |
| 'item_id' => array('ULINT', 0), | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'user_group' => array( | |
| 'user_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'users' => array( | |
| 'user_id' => array('ULINT', null, 'auto_increment'), | |
| ), | |
| $this->table_prefix . 'warnings' => array( | |
| 'log_id' => array('ULINT', 0), | |
| 'user_id' => array('ULINT', 0), | |
| 'post_id' => array('ULINT', 0), | |
| ), | |
| $this->table_prefix . 'words' => array( | |
| 'word_id' => array('ULINT', null, 'auto_increment'), | |
| ), | |
| $this->table_prefix . 'zebra' => array( | |
| 'user_id' => array('ULINT', 0), | |
| 'zebra_id' => array('ULINT', 0), | |
| ), | |
| ), | |
| ); | |
| } | |
| public function revert_schema() | |
| { | |
| return array( | |
| 'change_columns' => array( | |
| $this->table_prefix . 'acl_users' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'attachments' => array( | |
| 'attach_id' => array('UINT', null, 'auto_increment'), | |
| 'post_msg_id' => array('UINT', 0), | |
| 'poster_id' => array('UINT', 0), | |
| 'topic_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'banlist' => array( | |
| 'ban_id' => array('UINT', null, 'auto_increment'), | |
| 'ban_userid' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'bookmarks' => array( | |
| 'topic_id' => array('UINT', 0), | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'bots' => array( | |
| 'bot_id' => array('UINT', null, 'auto_increment'), | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'drafts' => array( | |
| 'draft_id' => array('UINT', null, 'auto_increment'), | |
| 'user_id' => array('UINT', 0), | |
| 'topic_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'forums' => array( | |
| 'forum_last_post_id' => array('UINT', 0), | |
| 'forum_last_poster_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'forums_access' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'forums_track' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'forums_watch' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'log' => array( | |
| 'log_id' => array('UINT', null, 'auto_increment'), | |
| 'post_id' => array('UINT', 0), | |
| 'reportee_id' => array('UINT', 0), | |
| 'user_id' => array('UINT', 0), | |
| 'topic_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'login_attempts' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'moderator_cache' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'notifications' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'oauth_accounts' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'oauth_states' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'oauth_tokens' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'poll_options' => array( | |
| 'topic_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'poll_votes' => array( | |
| 'topic_id' => array('UINT', 0), | |
| 'vote_user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'posts' => array( | |
| 'post_id' => array('UINT', null, 'auto_increment'), | |
| 'poster_id' => array('UINT', 0), | |
| 'post_delete_user' => array('UINT', 0), | |
| 'post_edit_user' => array('UINT', 0), | |
| 'topic_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'privmsgs' => array( | |
| 'author_id' => array('UINT', 0), | |
| 'message_edit_user' => array('UINT', 0), | |
| 'msg_id' => array('UINT', null, 'auto_increment'), | |
| ), | |
| $this->table_prefix . 'privmsgs_folder' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'privmsgs_rules' => array( | |
| 'rule_user_id' => array('UINT', 0), | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'privmsgs_to' => array( | |
| 'author_id' => array('UINT', 0), | |
| 'msg_id' => array('UINT', 0), | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'profile_fields_data' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'reports' => array( | |
| 'report_id' => array('UINT', 0), | |
| 'pm_id' => array('UINT', 0), | |
| 'post_id' => array('UINT', 0), | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'search_wordlist' => array( | |
| 'word_id' => array('UINT', null, 'auto_increment'), | |
| ), | |
| $this->table_prefix . 'search_wordmatch' => array( | |
| 'post_id' => array('UINT', 0), | |
| 'word_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'sessions' => array( | |
| 'session_user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'sessions_keys' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'topics' => array( | |
| 'topic_id' => array('UINT', null, 'auto_increment'), | |
| 'topic_poster' => array('UINT', 0), | |
| 'topic_first_post_id' => array('UINT', 0), | |
| 'topic_last_post_id' => array('UINT', 0), | |
| 'topic_last_poster_id' => array('UINT', 0), | |
| 'topic_moved_id' => array('UINT', 0), | |
| 'topic_delete_user' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'topics_track' => array( | |
| 'user_id' => array('UINT', 0), | |
| 'topic_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'topics_posted' => array( | |
| 'user_id' => array('UINT', 0), | |
| 'topic_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'topics_watch' => array( | |
| 'user_id' => array('UINT', 0), | |
| 'topic_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'user_notifications' => array( | |
| 'item_id' => array('UINT', 0), | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'user_group' => array( | |
| 'user_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'users' => array( | |
| 'user_id' => array('UINT', null, 'auto_increment'), | |
| ), | |
| $this->table_prefix . 'warnings' => array( | |
| 'log_id' => array('UINT', 0), | |
| 'user_id' => array('UINT', 0), | |
| 'post_id' => array('UINT', 0), | |
| ), | |
| $this->table_prefix . 'words' => array( | |
| 'word_id' => array('UINT', null, 'auto_increment'), | |
| ), | |
| $this->table_prefix . 'zebra' => array( | |
| 'user_id' => array('UINT', 0), | |
| 'zebra_id' => array('UINT', 0), | |
| ), | |
| ), | |
| ); | |
| } | |
| } |