SCORE

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 ;