User:Legoktm/Schema changes: Difference between revisions

From MusicBrainz Wiki
Jump to navigationJump to search
(...)
(-4)
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
<pre>
<pre>
// 1.20
// 1.20
array( 'addIndex', 'revision', 'page_user_timestamp', 'patch-revision-user-page-index.sql' ),
DONE array( 'addIndex', 'revision', 'page_user_timestamp', 'patch-revision-user-page-index.sql' ),
DONE array( 'addField', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id.sql' ),
DONE array( 'addField', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id.sql' ),
DONE array( 'addIndex', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id-index.sql' ),
DONE array( 'addIndex', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id-index.sql' ),
array( 'dropField', 'category', 'cat_hidden', 'patch-cat_hidden.sql' ),
array( 'dropField', 'category', 'cat_hidden', 'patch-cat_hidden.sql' ),
// 1.21
// 1.21
array( 'addField', 'revision', 'rev_content_format', 'patch-revision-rev_content_format.sql' ),
DONE array( 'addField', 'revision', 'rev_content_format', 'patch-revision-rev_content_format.sql' ),
array( 'addField', 'revision', 'rev_content_model', 'patch-revision-rev_content_model.sql' ),
DONE array( 'addField', 'revision', 'rev_content_model', 'patch-revision-rev_content_model.sql' ),
array( 'addField', 'archive', 'ar_content_format', 'patch-archive-ar_content_format.sql' ),
DONE array( 'addField', 'archive', 'ar_content_format', 'patch-archive-ar_content_format.sql' ),
array( 'addField', 'archive', 'ar_content_model', 'patch-archive-ar_content_model.sql' ),
DONE array( 'addField', 'archive', 'ar_content_model', 'patch-archive-ar_content_model.sql' ),
array( 'addField', 'page', 'page_content_model', 'patch-page-page_content_model.sql' ),
DONE array( 'addField', 'page', 'page_content_model', 'patch-page-page_content_model.sql' ),
array( 'enableContentHandlerUseDB' ),
array( 'enableContentHandlerUseDB' ),
array( 'dropField', 'site_stats', 'ss_admins', 'patch-drop-ss_admins.sql' ),
array( 'dropField', 'site_stats', 'ss_admins', 'patch-drop-ss_admins.sql' ),
Line 25: Line 25:
DONE array( 'addIndex', 'page_props', 'pp_propname_page',
DONE array( 'addIndex', 'page_props', 'pp_propname_page',
'patch-page_props-propname-page-index.sql' ),
'patch-page_props-propname-page-index.sql' ),
array( 'addIndex', 'image', 'img_media_mime', 'patch-img_media_mime-index.sql' ),
DONE array( 'addIndex', 'image', 'img_media_mime', 'patch-img_media_mime-index.sql' ),
// 1.22
// 1.22
array( 'doIwlinksIndexNonUnique' ),
array( 'doIwlinksIndexNonUnique' ),
array( 'addIndex', 'iwlinks', 'iwl_prefix_from_title',
array( 'addIndex', 'iwlinks', 'iwl_prefix_from_title',
'patch-iwlinks-from-title-index.sql' ),
'patch-iwlinks-from-title-index.sql' ),
array( 'addField', 'archive', 'ar_id', 'patch-archive-ar_id.sql' ),
DONE array( 'addField', 'archive', 'ar_id', 'patch-archive-ar_id.sql' ),
array( 'addField', 'externallinks', 'el_id', 'patch-externallinks-el_id.sql' ),
DONE array( 'addField', 'externallinks', 'el_id', 'patch-externallinks-el_id.sql' ),
// 1.23
// 1.23
array( 'addField', 'recentchanges', 'rc_source', 'patch-rc_source.sql' ),
DONE array( 'addField', 'recentchanges', 'rc_source', 'patch-rc_source.sql' ),
array( 'addIndex', 'logging', 'log_user_text_type_time',
DONE array( 'addIndex', 'logging', 'log_user_text_type_time',
'patch-logging_user_text_type_time_index.sql' ),
'patch-logging_user_text_type_time_index.sql' ),
array( 'addIndex', 'logging', 'log_user_text_time', 'patch-logging_user_text_time_index.sql' ),
DONE array( 'addIndex', 'logging', 'log_user_text_time', 'patch-logging_user_text_time_index.sql' ),
array( 'addField', 'page', 'page_links_updated', 'patch-page_links_updated.sql' ),
DONE array( 'addField', 'page', 'page_links_updated', 'patch-page_links_updated.sql' ),
array( 'addField', 'user', 'user_password_expires', 'patch-user_password_expire.sql' ),
DONE array( 'addField', 'user', 'user_password_expires', 'patch-user_password_expire.sql' ),
</pre>
</pre>


<pre>
<pre>
$ pt-online-schema-change -F /home/legoktm/.my.cnf --dry-run --alter "ADD page_content_model varbinary(32) DEFAULT NULL" D=mediawiki,t=page
$ pt-online-schema-change -F /home/legoktm/ptosc.cnf --dry-run --alter "ADD page_content_model varbinary(32) DEFAULT NULL" D=mediawiki,t=page
</pre>
</pre>

Latest revision as of 02:39, 17 October 2015

// 1.20
DONE array( 'addIndex', 'revision', 'page_user_timestamp', 'patch-revision-user-page-index.sql' ),
DONE array( 'addField', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id.sql' ),
DONE array( 'addIndex', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id-index.sql' ),
array( 'dropField', 'category', 'cat_hidden', 'patch-cat_hidden.sql' ),
// 1.21
DONE array( 'addField', 'revision', 'rev_content_format', 'patch-revision-rev_content_format.sql' ),
DONE array( 'addField', 'revision', 'rev_content_model', 'patch-revision-rev_content_model.sql' ),
DONE array( 'addField', 'archive', 'ar_content_format', 'patch-archive-ar_content_format.sql' ),
DONE array( 'addField', 'archive', 'ar_content_model', 'patch-archive-ar_content_model.sql' ),
DONE array( 'addField', 'page', 'page_content_model', 'patch-page-page_content_model.sql' ),
array( 'enableContentHandlerUseDB' ),
array( 'dropField', 'site_stats', 'ss_admins', 'patch-drop-ss_admins.sql' ),
array( 'dropField', 'recentchanges', 'rc_moved_to_title', 'patch-rc_moved.sql' ),
DONE array( 'addTable', 'sites', 'patch-sites.sql' ),
DONE array( 'addField', 'filearchive', 'fa_sha1', 'patch-fa_sha1.sql' ),
DONE array( 'addField', 'job', 'job_token', 'patch-job_token.sql' ),
DONE array( 'addField', 'job', 'job_attempts', 'patch-job_attempts.sql' ),
array( 'doEnableProfiling' ),
DONE array( 'addField', 'uploadstash', 'us_props', 'patch-uploadstash-us_props.sql' ),
DONE array( 'modifyField', 'user_groups', 'ug_group', 'patch-ug_group-length-increase-255.sql' ),
DONE array( 'modifyField', 'user_former_groups', 'ufg_group',
	'patch-ufg_group-length-increase-255.sql' ),
DONE array( 'addIndex', 'page_props', 'pp_propname_page',
	'patch-page_props-propname-page-index.sql' ),
DONE array( 'addIndex', 'image', 'img_media_mime', 'patch-img_media_mime-index.sql' ),
// 1.22
array( 'doIwlinksIndexNonUnique' ),
array( 'addIndex', 'iwlinks', 'iwl_prefix_from_title',
	'patch-iwlinks-from-title-index.sql' ),
DONE array( 'addField', 'archive', 'ar_id', 'patch-archive-ar_id.sql' ),
DONE array( 'addField', 'externallinks', 'el_id', 'patch-externallinks-el_id.sql' ),
// 1.23
DONE array( 'addField', 'recentchanges', 'rc_source', 'patch-rc_source.sql' ),
DONE array( 'addIndex', 'logging', 'log_user_text_type_time',
	'patch-logging_user_text_type_time_index.sql' ),
DONE array( 'addIndex', 'logging', 'log_user_text_time', 'patch-logging_user_text_time_index.sql' ),
DONE array( 'addField', 'page', 'page_links_updated', 'patch-page_links_updated.sql' ),
DONE array( 'addField', 'user', 'user_password_expires', 'patch-user_password_expire.sql' ),
$ pt-online-schema-change -F /home/legoktm/ptosc.cnf --dry-run --alter "ADD page_content_model varbinary(32) DEFAULT NULL" D=mediawiki,t=page