User:Legoktm/Schema changes: Difference between revisions
From MusicBrainz Wiki
Jump to navigationJump to search
(-1) |
(-4) |
||
Line 8: | Line 8: | ||
DONE 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' ), |
||
DONE 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' ), |
||
DONE 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' ), |
||
Line 30: | Line 30: | ||
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 |
||
DONE array( 'addField', 'recentchanges', 'rc_source', 'patch-rc_source.sql' ), |
DONE array( 'addField', 'recentchanges', 'rc_source', 'patch-rc_source.sql' ), |
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