USE [% wp %];

-- 19798
ALTER TABLE `[% table_prefix %]_options` DROP COLUMN blog_id;
-- 19799
ALTER TABLE `[% table_prefix %]_comments` DROP INDEX comment_approved;
-- 20022
DELETE FROM `[% table_prefix %]_usermeta` WHERE meta_key = 'themes_last_view';
-- 20080
DELETE FROM `[% table_prefix %]_options` WHERE option_name = 'uninstall_plugins';
INSERT INTO `[% table_prefix %]_options` (`option_name`, `option_value`, `autoload`) VALUES ('uninstall_plugins', 'a:0:{}', 'no');

-- schema update
ALTER TABLE `[% table_prefix %]_posts` MODIFY `post_content_filtered` longtext NOT NULL;

UPDATE `[% table_prefix %]_usermeta` set `meta_value`='wp330_toolbar,wp330_media_uploader,wp330_saving_widgets,wp340_choose_image_from_library,wp340_customize_current_theme_link' where meta_key='dismissed_wp_pointers' limit 1;
UPDATE `[% table_prefix %]_options` SET option_value = '21115' WHERE option_name = 'db_version';

-- latest version is 21115, but need to be done by wordpress
