source: trunk/_InstallationResources/omblog_migration_13860_14000.sql @ 1821

Revision 1821, 1.5 KB checked in by admin, 21 months ago (diff)

[trunk] fix sql syntax error

Line 
1-- Change width/height values. Added by zhongzhen on 2010-08-16
2-- UPDATE `wp_posts` SET `post_content` = replace( `post_content`, 'width="650"', '' );
3-- UPDATE `wp_posts` SET `post_content` = replace( `post_content`, 'width="700"', 'width="550"' );
4-- UPDATE `wp_posts` SET `post_content` = replace( `post_content`, 'height="70"', 'height="55"' );
5
6-- Change weekly begin value. Changed by zhongzhen on 2010-08-17
7UPDATE `wp_options` SET `option_value` = '0' WHERE `option_name`='start_of_week';
8
9-- Changed to add page navigation plugin by zhongzhen on 2010-08-19
10UPDATE `wp_options` SET `option_value` = 'a:6:{i:0;s:19:"akismet/akismet.php";i:1;s:23:"omcollab_sso_helper.php";i:2;s:28:"subscribe2/counterwidget.php";i:3;s:25:"subscribe2/subscribe2.php";i:4;s:20:"wikimedia_avatar.php";i:5;s:35:"wp-page-numbers/wp-page-numbers.php";}' WHERE `option_name`='active_plugins';
11
12-- Added to add page navigation plugin configuration value by zhongzhen on 2010-08-19
13INSERT INTO `wp_options` (`blog_id`, `option_name`, `option_value`, `autoload`) VALUES
14('0', 'wp_page_numbers_array', 'a:14:{s:20:"head_stylesheetsheet";s:2:"on";s:32:"head_stylesheetsheet_folder_name";s:0:"";s:12:"page_of_page";s:2:"no";s:17:"page_of_page_text";s:0:"";s:10:"page_of_of";s:0:"";s:14:"next_prev_text";s:2:"no";s:22:"show_start_end_numbers";s:2:"on";s:17:"show_page_numbers";s:2:"on";s:11:"limit_pages";s:1:"8";s:8:"nextpage";s:0:"";s:8:"prevpage";s:0:"";s:10:"startspace";s:0:"";s:8:"endspace";s:0:"";s:11:"style_theme";s:7:"default";}', 'yes');
Note: See TracBrowser for help on using the repository browser.