This shows you the differences between two versions of the page.

Link to this comparison view

litespeed_wiki:cache:lscwp:v2-v3-upgrade-db [2020/04/27 23:45] (current)
qtwrk created
Line 1: Line 1:
 +Query to upgrade v2 image optimization database to v3 image optimization database.
 +<​code>​UPDATE `wp_litespeed_img_optm` SET optm_status='​3'​ WHERE optm_status='​requested';​
 +UPDATE `wp_litespeed_img_optm` SET optm_status='​6'​ WHERE optm_status='​notified';​
 +UPDATE `wp_litespeed_img_optm` SET optm_status='​9'​ WHERE optm_status='​pulled';​
 +UPDATE `wp_litespeed_img_optm` SET optm_status='​-1'​ WHERE optm_status='​failed';​
 +UPDATE `wp_litespeed_img_optm` SET optm_status='​-3'​ WHERE optm_status='​miss';​
 +UPDATE `wp_litespeed_img_optm` SET optm_status='​-9'​ WHERE optm_status='​err';​
 +UPDATE `wp_litespeed_img_optm` SET optm_status='​-5'​ WHERE optm_status='​err_fetch';​
 +UPDATE `wp_litespeed_img_optm` SET optm_status='​-7'​ WHERE optm_status='​err_optm';​
 +UPDATE `wp_litespeed_img_optm` SET optm_status='​-8'​ WHERE optm_status='​xmeta';​
 +ALTER TABLE `wp_litespeed_img_optm`
 + DROP INDEX `post_id_2`,​
 + DROP INDEX `root_id`,
 + DROP INDEX `src_md5`,
 + DROP INDEX `srcpath_md5`,​
 + DROP COLUMN `srcpath_md5`,​
 + DROP COLUMN `src_md5`,
 + DROP COLUMN `root_id`,
 + DROP COLUMN `target_saved`,​
 + DROP COLUMN `webp_saved`,​
 + DROP COLUMN `server_info`,​
 + MODIFY COLUMN `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,​
 + MODIFY COLUMN `optm_status` tinyint(4) NOT NULL DEFAULT 0,
 + MODIFY COLUMN `src` text COLLATE utf8mb4_unicode_ci NOT NULL;
  • Admin
  • Last modified: 2020/04/27 23:45
  • by qtwrk