Nils-Johan Gynther
21 lines
748 B
SQL
21 lines
748 B
SQL
-- Lägg till L2: Kondis & fika under Bröd & Kakor
|
|
INSERT INTO `Category` (`name`, `parentId`)
|
|
SELECT 'Kondis & fika', c1.id
|
|
FROM `Category` c1
|
|
WHERE c1.name = 'Bröd & Kakor' AND c1.parentId IS NULL
|
|
AND NOT EXISTS (
|
|
SELECT 1 FROM `Category` c2
|
|
WHERE c2.name = 'Kondis & fika' AND c2.parentId = c1.id
|
|
);
|
|
|
|
-- Lägg till L3: Kaffebröd under Kondis & fika
|
|
INSERT INTO `Category` (`name`, `parentId`)
|
|
SELECT 'Kaffebröd', c2.id
|
|
FROM `Category` c1
|
|
JOIN `Category` c2 ON c2.parentId = c1.id AND c2.name = 'Kondis & fika'
|
|
WHERE c1.name = 'Bröd & Kakor' AND c1.parentId IS NULL
|
|
AND NOT EXISTS (
|
|
SELECT 1 FROM `Category` c3
|
|
WHERE c3.name = 'Kaffebröd' AND c3.parentId = c2.id
|
|
);
|