Henri Huisman blijonline

nr1q / qtranslate_cleanup.sql

Created August 8, 2017 22:55 — forked from frnhr/qtranslate_cleanup.sql

clean database after qTranslate uninstall

	# QTRANSLATE CLEANUP QUERIES

	# create temp column to separate post content on <!--more--> tag to simplify queries
	ALTER TABLE `wp_posts` ADD `tmp_excerpt` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;


	# split content

	## fill `tmp_exceprt` column
	UPDATE wp_posts SET tmp_excerpt =