use score;

ALTER TABLE learning_objectives ADD icon VARCHAR(255) after name;
ALTER TABLE themes ADD icon VARCHAR(255) after name;
ALTER TABLE formats ADD icon VARCHAR(255) after name;
ALTER TABLE sectors ADD icon VARCHAR(255) after name;
ALTER TABLE hashtags ADD icon VARCHAR(255) after type;
ALTER TABLE circular_strategies ADD icon VARCHAR(255) after name;

UPDATE  themes SET icon ='bookmark' where id > 0 ;
UPDATE  formats SET icon ='bookmark' where id > 0 ;
UPDATE  sectors SET icon ='bookmark' where id > 0 ;
UPDATE  hashtags SET icon ='hashtag' where id > 0 ;
UPDATE  circular_strategies SET icon  ='bookmark' where id > 0 ;