Guest
Public paste!

refactor

By: a guest | Mar 20th, 2010 | Syntax: MySQL | Size: 0.51 KB | Hits: 179 | Expires: Never
This paste has a previous version, view the difference. Copy text to clipboard
  1. UPDATE {$wpdb->postmeta}
  2. SET meta_key = '_menu_item_type' WHERE meta_key = 'menu_item_type';
  3. SET meta_key = '_menu_item_append' WHERE meta_key = 'menu_item_append';
  4. SET meta_key = '_menu_item_object_id' WHERE meta_key = 'menu_item_object_id';
  5. SET meta_key = '_menu_item_target' WHERE meta_key = 'menu_item_target';
  6. SET meta_key = '_menu_item_classes' WHERE meta_key = 'menu_item_classes';
  7. SET meta_key = '_menu_item_xfn' WHERE meta_key = 'menu_item_xfn';
  8. SET meta_key = '_menu_item_url' WHERE meta_key = 'menu_item_url'