-- Run after schema.sql. Assumes categories from schema.sql already exist.
USE icon_foozera;

INSERT INTO icons (name, slug, category_id, svg_path, default_color) VALUES
    ('Heart', 'heart', (SELECT id FROM categories WHERE slug = 'social-media'), 'heart.svg', '#e8930b'),
    ('Shopping Cart', 'shopping-cart', (SELECT id FROM categories WHERE slug = 'e-commerce'), 'shopping-cart.svg', '#0f5c56'),
    ('Star', 'star', (SELECT id FROM categories WHERE slug = 'ui-ux'), 'star.svg', '#0b3d3a');

INSERT INTO tags (name) VALUES ('heart'), ('love'), ('favorite'), ('cart'), ('shopping'), ('buy'), ('star'), ('rating'), ('favorite-ui');

INSERT INTO icon_tags (icon_id, tag_id)
SELECT i.id, t.id FROM icons i, tags t
WHERE (i.slug = 'heart' AND t.name IN ('heart','love','favorite'))
   OR (i.slug = 'shopping-cart' AND t.name IN ('cart','shopping','buy'))
   OR (i.slug = 'star' AND t.name IN ('star','rating','favorite-ui'));