
ALTER TABLE `was_item_category`
ADD `short_desc` VARCHAR(255) NOT NULL AFTER `item_category_status`
, ADD `long_desc` TEXT NOT NULL AFTER `short_desc`;


UPDATE `was_item_category`
SET `item_category_name` = 'Search Engine Optimization'
  , `short_desc` = 'Speed up your search engine success with Google, Bing and Yahoo'
WHERE `item_category_id` = 2;

UPDATE `was_item_category`
SET `short_desc` = 'Become an expert at building beautiful looking Wordpress websites'
WHERE `item_category_id` = 4;

UPDATE `was_item_category`
SET `item_category_name` = 'Niche Research'
  , `short_desc` = 'Establish an authoritative brand by mastering your audience and niche'
WHERE `item_category_id` = 10;

UPDATE `was_item_category`
SET `item_category_name` = 'Pay-per-click Marketing'
  , `short_desc` = 'Learn how to build highly successful paid advertising campaigns'
WHERE `item_category_id` = 31;

UPDATE `was_item_category`
SET `short_desc` = 'Create a massive following with techniques direct from influential Youtubers'
WHERE `item_category_id` = 13;

UPDATE `was_item_category`
SET `short_desc` = 'Create high ranking, high converting, and captivating content'
WHERE `item_category_id` = 28;

UPDATE `was_item_category`
SET `short_desc` = 'Become a highly sought after Super Affiliate across any niche'
WHERE `item_category_id` = 30;

UPDATE `was_item_category`
SET `short_desc` = 'Leverage Facebook, Instagram, TikTok, Twitter, and Pinterest to expand your reach'
WHERE `item_category_id` = 1;

UPDATE `was_item_category`
SET `item_category_name` = 'Email & Funnel Marketing'
  , `short_desc` = 'Master captivating lead offers, build funnels, and create passive revenue'
WHERE `item_category_id` = 11;

UPDATE `was_item_category`
SET `short_desc` = 'Scale your business through outsourcing key components of your business'
WHERE `item_category_id` = 42;

