Cocoon ▶ SWELL移行記

/* 確認：Cocoon descriptionがセット済みの記事・固定ページ一覧 */
SELECT 
     wp_posts.ID
    ,wp_posts.post_title
    ,wp_posts.post_excerpt
    ,wp_postmeta.meta_value
FROM wp_posts
INNER JOIN wp_postmeta on wp_posts.ID = wp_postmeta.post_id
WHERE
        wp_postmeta.meta_key = 'the_page_meta_description'
    and wp_posts.post_type in ('page', 'post')
ORDER BY wp_posts.ID

/* 移行：抜粋(excerpt) */
UPDATE
     wp_posts
    ,(
        SELECT post_id, meta_value
        FROM wp_postmeta
        WHERE meta_key = 'the_page_meta_description'
    ) AS meta
SET
    wp_posts.post_excerpt = meta.meta_value
WHERE
        wp_posts.ID = meta.post_id
    and wp_posts.post_type in ('page', 'post')

/* 移行：description */
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT 
     wp_posts.ID
    ,'ssp_meta_description'
    ,wp_posts.post_excerpt
FROM wp_posts
WHERE
        wp_posts.post_type in ('page', 'post')
	and wp_posts.post_excerpt <> ''
ORDER BY wp_posts.ID

/* 目次広告を隠す */
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT
     post_id
    ,'swell_meta_hide_before_index'
    ,meta_value
FROM wp_postmeta
WHERE meta_key = 'the_page_ads_novisible' and meta_value = 1

/* 自動広告を停止する */
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT
     post_id
    ,'swell_meta_hide_autoad'
    ,meta_value
FROM wp_postmeta
WHERE meta_key = 'the_page_ads_novisible' and meta_value = 1

/* チェック */
SELECT
     null
    ,post_id
    ,'swell_meta_hide_before_index'
    ,meta_value
FROM wp_postmeta
WHERE meta_key = 'the_page_ads_novisible' and meta_value = 1

/* 確認：noindex指定の記事一覧 */
SELECT *
FROM wp_postmeta
WHERE meta_key = 'the_page_noindex' AND meta_value = 1

/* 確認：nofollow指定の記事一覧 */
SELECT *
FROM wp_postmeta
WHERE meta_key = 'the_page_nofollow' AND meta_value = 1

/* 確認：noarchive指定の記事一覧 */
SELECT *
FROM wp_postmeta
WHERE meta_key = 'the_page_no_archive' AND meta_value = 1

/* noindex指定だけ移行 */
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT
     post_id
    ,'ssp_meta_robots'
    ,'noindex'
FROM wp_postmeta
WHERE meta_key = 'the_page_noindex' AND meta_value = 1

/* SEOタイトルが指定された記事の一覧 */
SELECT *
FROM wp_postmeta
WHERE meta_key = 'the_page_seo_title' AND meta_value <> ''

/* 移行 */
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT
     post_id
    ,'ssp_meta_title'
    ,meta_value
FROM wp_postmeta
WHERE meta_key = 'the_page_seo_title' AND meta_value <> ''

/* カノニカルURLが指定された記事の一覧 */
SELECT *
FROM wp_postmeta
WHERE meta_key = 'the_page_canonical_url' AND meta_value <> ''

/* 移行 */
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT
     post_id
    ,'ssp_meta_canonical'
    ,meta_value
FROM wp_postmeta
WHERE meta_key = 'the_page_canonical_url' AND meta_value <> ''

/* キーワードが指定された記事の一覧 */
SELECT *
FROM wp_postmeta
WHERE meta_key = 'the_page_meta_keywords' AND meta_value <> ''

INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT
     post_id
    ,'ssp_meta_keyword'
    ,meta_value
FROM wp_postmeta
WHERE meta_key = 'the_page_meta_keywords' AND meta_value <> ''

/* 目次非表示の設定がされた記事の一覧 */
SELECT *
FROM wp_postmeta
WHERE meta_key = 'the_page_toc_novisible' AND meta_value = 1

/* 移行 */
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT
     post_id
    ,'swell_meta_show_index'
    ,'hide'
FROM wp_postmeta
WHERE meta_key = 'the_page_canonical_url' AND meta_value = 1

/* Cfilteringプラグインのゴミ */
DELETE FROM wp_postmeta WHERE meta_key = 'cfiltering_jaccard';

/* Jetpackプラグインのゴミ */
DELETE FROM wp_postmeta WHERE meta_key = 'sharing_disabled';

/* wpDiscuzプラグインのゴミ */
DELETE FROM wp_postmeta WHERE meta_key = 'wpd_form_custom_css';
DELETE FROM wp_postmeta WHERE meta_key = 'wpdiscuz_form_general_options';
DELETE FROM wp_postmeta WHERE meta_key = 'wpdiscuz_form_structure';
DELETE FROM wp_postmeta WHERE meta_key = 'wpdiscuz_form_fields';

/* SNS Count Cacheプラグインのゴミ */
DELETE FROM wp_postmeta WHERE meta_key = 'scc_share_count_twitter';
DELETE FROM wp_postmeta WHERE meta_key = 'scc_share_count_facebook';
DELETE FROM wp_postmeta WHERE meta_key = 'scc_share_count_google+';
DELETE FROM wp_postmeta WHERE meta_key = 'scc_share_count_pocket';
DELETE FROM wp_postmeta WHERE meta_key = 'scc_share_count_hatebu';
DELETE FROM wp_postmeta WHERE meta_key = 'scc_share_count_crawldate';
DELETE FROM wp_postmeta WHERE meta_key = 'scc_share_count_total';

/* AMP for WordPressプラグインのゴミ？ */
DELETE FROM wp_postmeta WHERE meta_key = 'amp_is_enabled';

/* Affinger用投稿メタ */
DELETE FROM wp_postmeta WHERE meta_key = 'stmeta_robots';
DELETE FROM wp_postmeta WHERE meta_key = 'st_keywords';
DELETE FROM wp_postmeta WHERE meta_key = 'st_description';
DELETE FROM wp_postmeta WHERE meta_key = 'su_slide_link';
DELETE FROM wp_postmeta WHERE meta_key = 'koukoku_set';

/* Cocoon用投稿メタ */
DELETE FROM wp_postmeta WHERE meta_key = 'comment_form_freeze_message';
DELETE FROM wp_postmeta WHERE meta_key = 'is_ads_removed_in_page';
DELETE FROM wp_postmeta WHERE meta_key = 'is_comment_form_freeze';
DELETE FROM wp_postmeta WHERE meta_key = 'is_nofollow';
DELETE FROM wp_postmeta WHERE meta_key = 'is_noindex';
DELETE FROM wp_postmeta WHERE meta_key = 'is_noamp';
DELETE FROM wp_postmeta WHERE meta_key = 'meta_description';
DELETE FROM wp_postmeta WHERE meta_key = 'meta_keywords';
DELETE FROM wp_postmeta WHERE meta_key = 'page_type';
DELETE FROM wp_postmeta WHERE meta_key = 'seo_title';
DELETE FROM wp_postmeta WHERE meta_key = 'update_level';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_noindex';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_nofollow';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_no_archive';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_seo_title';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_meta_description';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_canonical_url';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_ads_novisible';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_toc_novisible';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_no_amp';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_read_time_novisible';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_no_rss';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_meta_keywords';
DELETE FROM wp_postmeta WHERE meta_key = 'redirect_url';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_memo';
DELETE FROM wp_postmeta WHERE meta_key = 'sns_image_url';
DELETE FROM wp_postmeta WHERE meta_key = 'last_modified';
DELETE FROM wp_postmeta WHERE meta_key = 'the_review_enable';
DELETE FROM wp_postmeta WHERE meta_key = 'the_review_type';
DELETE FROM wp_postmeta WHERE meta_key = 'the_review_name';
DELETE FROM wp_postmeta WHERE meta_key = 'the_review_rate';
DELETE FROM wp_postmeta WHERE meta_key = 'the_page_main_category';

/* Cocoon風タグ（オレンジ） */
.swl-format-1 {
	padding: 2px 5px;
	/* SWELL▶Cocoon乗り換えプラグイン風は padding: 4px 6px; */
	color: #fff;
	font-size: var(--wp--preset--font-size--xs);
	background-color: #fc7a22;
	border-radius: 2px;
}

.swl-format-1 {
	margin: 0;
	padding: 1px 5px 0;
	color: #fff;
	font-size: var(--wp--preset--font-size--xs);
	background-color: #f39800;
	border-radius: 2px;
}