diff options
| author | hjpotter92 <hjpotter92@iitkgp.ac.in> | 2014-02-28 03:58:32 +0530 |
|---|---|---|
| committer | hjpotter92 <hjpotter92@iitkgp.ac.in> | 2014-02-28 03:58:32 +0530 |
| commit | 48fc908e6b0d1b18f679278297213738c0647bc1 (patch) | |
| tree | 65c1f2f040c814d58434b0fe1806bb314566f02b /phpBB/includes | |
| parent | f99cce0f440ad3d0176d6317092707383bfd456c (diff) | |
| download | forums-48fc908e6b0d1b18f679278297213738c0647bc1.tar forums-48fc908e6b0d1b18f679278297213738c0647bc1.tar.gz forums-48fc908e6b0d1b18f679278297213738c0647bc1.tar.bz2 forums-48fc908e6b0d1b18f679278297213738c0647bc1.tar.xz forums-48fc908e6b0d1b18f679278297213738c0647bc1.zip | |
[ticket/11875] Upgrade default data type from MEDIUMINT to INT
Use 4-byte data type INT(10) for user_id, post_id and topic_id across
all tables instead of previously used 3-byte MEDIUMINT(8)
PHPBB3-11875
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/db/schema_data.php | 84 |
1 files changed, 42 insertions, 42 deletions
diff --git a/phpBB/includes/db/schema_data.php b/phpBB/includes/db/schema_data.php index 0447895433..72e8035821 100644 --- a/phpBB/includes/db/schema_data.php +++ b/phpBB/includes/db/schema_data.php @@ -53,7 +53,7 @@ $schema_data['phpbb_attachments'] = array( 'COLUMNS' => array( 'attach_id' => array('UINT', NULL, 'auto_increment'), 'post_msg_id' => array('UINT', 0), - 'topic_id' => array('UINT', 0), + 'topic_id' => array('UINT:10', 0), 'in_message' => array('BOOL', 0), 'poster_id' => array('UINT', 0), 'is_orphan' => array('BOOL', 1), @@ -135,7 +135,7 @@ $schema_data['phpbb_acl_roles_data'] = array( $schema_data['phpbb_acl_users'] = array( 'COLUMNS' => array( - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'forum_id' => array('UINT', 0), 'auth_option_id' => array('UINT', 0), 'auth_role_id' => array('UINT', 0), @@ -190,8 +190,8 @@ $schema_data['phpbb_bbcodes'] = array( $schema_data['phpbb_bookmarks'] = array( 'COLUMNS' => array( - 'topic_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'topic_id' => array('UINT:10', 0), + 'user_id' => array('UINT:10', 0), ), 'PRIMARY_KEY' => array('topic_id', 'user_id'), ); @@ -201,7 +201,7 @@ $schema_data['phpbb_bots'] = array( 'bot_id' => array('UINT', NULL, 'auto_increment'), 'bot_active' => array('BOOL', 1), 'bot_name' => array('STEXT_UNI', ''), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'bot_agent' => array('VCHAR', ''), 'bot_ip' => array('VCHAR', ''), ), @@ -257,8 +257,8 @@ $schema_data['phpbb_disallow'] = array( $schema_data['phpbb_drafts'] = array( 'COLUMNS' => array( 'draft_id' => array('UINT', NULL, 'auto_increment'), - 'user_id' => array('UINT', 0), - 'topic_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), + 'topic_id' => array('UINT:10', 0), 'forum_id' => array('UINT', 0), 'save_time' => array('TIMESTAMP', 0), 'draft_subject' => array('STEXT_UNI', ''), @@ -363,7 +363,7 @@ $schema_data['phpbb_forums'] = array( $schema_data['phpbb_forums_access'] = array( 'COLUMNS' => array( 'forum_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'session_id' => array('CHAR:32', ''), ), 'PRIMARY_KEY' => array('forum_id', 'user_id', 'session_id'), @@ -371,7 +371,7 @@ $schema_data['phpbb_forums_access'] = array( $schema_data['phpbb_forums_track'] = array( 'COLUMNS' => array( - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'forum_id' => array('UINT', 0), 'mark_time' => array('TIMESTAMP', 0), ), @@ -381,7 +381,7 @@ $schema_data['phpbb_forums_track'] = array( $schema_data['phpbb_forums_watch'] = array( 'COLUMNS' => array( 'forum_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'notify_status' => array('BOOL', 0), ), 'KEYS' => array( @@ -455,9 +455,9 @@ $schema_data['phpbb_log'] = array( 'COLUMNS' => array( 'log_id' => array('UINT', NULL, 'auto_increment'), 'log_type' => array('TINT:4', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'forum_id' => array('UINT', 0), - 'topic_id' => array('UINT', 0), + 'topic_id' => array('UINT:10', 0), 'reportee_id' => array('UINT', 0), 'log_ip' => array('VCHAR:40', ''), 'log_time' => array('TIMESTAMP', 0), @@ -481,7 +481,7 @@ $schema_data['phpbb_login_attempts'] = array( 'attempt_browser' => array('VCHAR:150', ''), 'attempt_forwarded_for' => array('VCHAR:255', ''), 'attempt_time' => array('TIMESTAMP', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'username' => array('VCHAR_UNI:255', 0), 'username_clean' => array('VCHAR_CI', 0), ), @@ -496,7 +496,7 @@ $schema_data['phpbb_login_attempts'] = array( $schema_data['phpbb_moderator_cache'] = array( 'COLUMNS' => array( 'forum_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'username' => array('VCHAR_UNI:255', ''), 'group_id' => array('UINT', 0), 'group_name' => array('VCHAR_UNI', ''), @@ -561,7 +561,7 @@ $schema_data['phpbb_notifications'] = array( 'notification_type_id' => array('USINT', 0), 'item_id' => array('UINT', 0), 'item_parent_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'notification_read' => array('BOOL', 0), 'notification_time' => array('TIMESTAMP', 1), 'notification_data' => array('TEXT_UNI', ''), @@ -575,7 +575,7 @@ $schema_data['phpbb_notifications'] = array( $schema_data['phpbb_oauth_accounts'] = array( 'COLUMNS' => array( - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'provider' => array('VCHAR', ''), 'oauth_provider_id' => array('TEXT_UNI', ''), ), @@ -587,7 +587,7 @@ $schema_data['phpbb_oauth_accounts'] = array( $schema_data['phpbb_oauth_tokens'] = array( 'COLUMNS' => array( - 'user_id' => array('UINT', 0), // phpbb_users.user_id + 'user_id' => array('UINT:10', 0), // phpbb_users.user_id 'session_id' => array('CHAR:32', ''), // phpbb_sessions.session_id used only when user_id not set 'provider' => array('VCHAR', ''), // Name of the OAuth provider 'oauth_token' => array('MTEXT', ''), // Serialized token @@ -601,7 +601,7 @@ $schema_data['phpbb_oauth_tokens'] = array( $schema_data['phpbb_poll_options'] = array( 'COLUMNS' => array( 'poll_option_id' => array('TINT:4', 0), - 'topic_id' => array('UINT', 0), + 'topic_id' => array('UINT:10', 0), 'poll_option_text' => array('TEXT_UNI', ''), 'poll_option_total' => array('UINT', 0), ), @@ -613,7 +613,7 @@ $schema_data['phpbb_poll_options'] = array( $schema_data['phpbb_poll_votes'] = array( 'COLUMNS' => array( - 'topic_id' => array('UINT', 0), + 'topic_id' => array('UINT:10', 0), 'poll_option_id' => array('TINT:4', 0), 'vote_user_id' => array('UINT', 0), 'vote_user_ip' => array('VCHAR:40', ''), @@ -627,8 +627,8 @@ $schema_data['phpbb_poll_votes'] = array( $schema_data['phpbb_posts'] = array( 'COLUMNS' => array( - 'post_id' => array('UINT', NULL, 'auto_increment'), - 'topic_id' => array('UINT', 0), + 'post_id' => array('UINT:10', NULL, 'auto_increment'), + 'topic_id' => array('UINT:10', 0), 'forum_id' => array('UINT', 0), 'poster_id' => array('UINT', 0), 'icon_id' => array('UINT', 0), @@ -706,7 +706,7 @@ $schema_data['phpbb_privmsgs'] = array( $schema_data['phpbb_privmsgs_folder'] = array( 'COLUMNS' => array( 'folder_id' => array('UINT', NULL, 'auto_increment'), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'folder_name' => array('VCHAR_UNI', ''), 'pm_count' => array('UINT', 0), ), @@ -719,7 +719,7 @@ $schema_data['phpbb_privmsgs_folder'] = array( $schema_data['phpbb_privmsgs_rules'] = array( 'COLUMNS' => array( 'rule_id' => array('UINT', NULL, 'auto_increment'), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'rule_check' => array('UINT', 0), 'rule_connection' => array('UINT', 0), 'rule_string' => array('VCHAR_UNI', ''), @@ -737,7 +737,7 @@ $schema_data['phpbb_privmsgs_rules'] = array( $schema_data['phpbb_privmsgs_to'] = array( 'COLUMNS' => array( 'msg_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'author_id' => array('UINT', 0), 'pm_deleted' => array('BOOL', 0), 'pm_new' => array('BOOL', 1), @@ -787,7 +787,7 @@ $schema_data['phpbb_profile_fields'] = array( $schema_data['phpbb_profile_fields_data'] = array( 'COLUMNS' => array( - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'pf_phpbb_location' => array('VCHAR', ''), 'pf_phpbb_interests' => array('TEXT_UNI', ''), 'pf_phpbb_occupation' => array('TEXT_UNI', ''), @@ -832,9 +832,9 @@ $schema_data['phpbb_reports'] = array( 'COLUMNS' => array( 'report_id' => array('UINT', NULL, 'auto_increment'), 'reason_id' => array('USINT', 0), - 'post_id' => array('UINT', 0), + 'post_id' => array('UINT:10', 0), 'pm_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'user_notify' => array('BOOL', 0), 'report_closed' => array('BOOL', 0), 'report_time' => array('TIMESTAMP', 0), @@ -889,7 +889,7 @@ $schema_data['phpbb_search_wordlist'] = array( $schema_data['phpbb_search_wordmatch'] = array( 'COLUMNS' => array( - 'post_id' => array('UINT', 0), + 'post_id' => array('UINT:10', 0), 'word_id' => array('UINT', 0), 'title_match' => array('BOOL', 0), ), @@ -927,7 +927,7 @@ $schema_data['phpbb_sessions'] = array( $schema_data['phpbb_sessions_keys'] = array( 'COLUMNS' => array( 'key_id' => array('CHAR:32', ''), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'last_ip' => array('VCHAR:40', ''), 'last_login' => array('TIMESTAMP', 0), ), @@ -995,7 +995,7 @@ $schema_data['phpbb_teampage'] = array( $schema_data['phpbb_topics'] = array( 'COLUMNS' => array( - 'topic_id' => array('UINT', NULL, 'auto_increment'), + 'topic_id' => array('UINT:10', NULL, 'auto_increment'), 'forum_id' => array('UINT', 0), 'icon_id' => array('UINT', 0), 'topic_attachment' => array('BOOL', 0), @@ -1047,8 +1047,8 @@ $schema_data['phpbb_topics'] = array( $schema_data['phpbb_topics_track'] = array( 'COLUMNS' => array( - 'user_id' => array('UINT', 0), - 'topic_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), + 'topic_id' => array('UINT:10', 0), 'forum_id' => array('UINT', 0), 'mark_time' => array('TIMESTAMP', 0), ), @@ -1061,8 +1061,8 @@ $schema_data['phpbb_topics_track'] = array( $schema_data['phpbb_topics_posted'] = array( 'COLUMNS' => array( - 'user_id' => array('UINT', 0), - 'topic_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), + 'topic_id' => array('UINT:10', 0), 'topic_posted' => array('BOOL', 0), ), 'PRIMARY_KEY' => array('user_id', 'topic_id'), @@ -1070,8 +1070,8 @@ $schema_data['phpbb_topics_posted'] = array( $schema_data['phpbb_topics_watch'] = array( 'COLUMNS' => array( - 'topic_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'topic_id' => array('UINT:10', 0), + 'user_id' => array('UINT:10', 0), 'notify_status' => array('BOOL', 0), ), 'KEYS' => array( @@ -1085,7 +1085,7 @@ $schema_data['phpbb_user_notifications'] = array( 'COLUMNS' => array( 'item_type' => array('VCHAR:255', ''), 'item_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'method' => array('VCHAR:255', ''), 'notify' => array('BOOL', 1), ), @@ -1094,7 +1094,7 @@ $schema_data['phpbb_user_notifications'] = array( $schema_data['phpbb_user_group'] = array( 'COLUMNS' => array( 'group_id' => array('UINT', 0), - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'group_leader' => array('BOOL', 0), 'user_pending' => array('BOOL', 1), ), @@ -1107,7 +1107,7 @@ $schema_data['phpbb_user_group'] = array( $schema_data['phpbb_users'] = array( 'COLUMNS' => array( - 'user_id' => array('UINT', NULL, 'auto_increment'), + 'user_id' => array('UINT:10', NULL, 'auto_increment'), 'user_type' => array('TINT:2', 0), 'group_id' => array('UINT', 3), 'user_permissions' => array('MTEXT', ''), @@ -1192,8 +1192,8 @@ $schema_data['phpbb_users'] = array( $schema_data['phpbb_warnings'] = array( 'COLUMNS' => array( 'warning_id' => array('UINT', NULL, 'auto_increment'), - 'user_id' => array('UINT', 0), - 'post_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), + 'post_id' => array('UINT:10', 0), 'log_id' => array('UINT', 0), 'warning_time' => array('TIMESTAMP', 0), ), @@ -1211,7 +1211,7 @@ $schema_data['phpbb_words'] = array( $schema_data['phpbb_zebra'] = array( 'COLUMNS' => array( - 'user_id' => array('UINT', 0), + 'user_id' => array('UINT:10', 0), 'zebra_id' => array('UINT', 0), 'friend' => array('BOOL', 0), 'foe' => array('BOOL', 0), |