
ALTER TABLE was_item_category
ADD COLUMN `is_starter_access` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean to determine if a category is accessible by starters' AFTER `is_community`,
ADD COLUMN `parent_item_category_id` int(11) unsigned NOT NULL DEFAULT 0 AFTER `item_category_id`;

UPDATE was_item_category
SET
  is_starter_access = 1
WHERE
  item_category_slug IN ('wordpress');


-- Set parent as the social media category
UPDATE was_item_category
SET
  parent_item_category_id = 1
WHERE
  item_category_slug IN ('facebook', 'instagram', 'pinterest');

