Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 3 |
CRAP | |
0.00% |
0 / 83 |
default_data_type_ids | |
0.00% |
0 / 1 |
|
0.00% |
0 / 3 |
12.00 | |
0.00% |
0 / 83 |
depends_on | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 1 |
|||
update_schema | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 41 |
|||
revert_schema | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 41 |
<?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), | |
), | |
), | |
); | |
} | |
} |