-- Script pour initialiser le stock du deuxième lot en mode ADMIN (Stock Central)
-- Date: 02/07/2025 - 52 articles

-- Stock pour le Stock Central (store_id = 1, stock_type = 'admin')
-- Sets - Bras (14 articles)
INSERT INTO stock (product_id, store_id, quantity, stock_type, created_at) VALUES
-- Pure Motion Fit Turquoise M/L Bra
((SELECT id FROM products WHERE name = 'Pure Motion Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Turquoise') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- One Shoulder Ribbed Fit Turquoise M/L Bra
((SELECT id FROM products WHERE name = 'One Shoulder Ribbed Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Turquoise') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- One Shoulder Ribbed Fit Green Fluo M/L Bra
((SELECT id FROM products WHERE name = 'One Shoulder Ribbed Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Green Fluo') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Corail Fit S/M Bra
((SELECT id FROM products WHERE name = 'Corail Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Coral') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- Perfect Fit Brown Chocolate S/M Bra
((SELECT id FROM products WHERE name = 'Perfect Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Brown Chocolate') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- Perfect Fit Dark Grey M/L Bra
((SELECT id FROM products WHERE name = 'Perfect Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Dark Grey') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Perfect Fit Gardenia M/L Bra
((SELECT id FROM products WHERE name = 'Perfect Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Gardenia') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Fashion Fit Flare Beige M/L Bra
((SELECT id FROM products WHERE name = 'Fashion Fit Flare Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Flare Beige') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Fashion Fit Flare Black M/L Bra
((SELECT id FROM products WHERE name = 'Fashion Fit Flare Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Black') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Fashion Fit Army M/L Bra
((SELECT id FROM products WHERE name = 'Fashion Fit Army Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Army') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Align Fit Yellow S/M Bra
((SELECT id FROM products WHERE name = 'Align Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Yellow') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- The Ultimate Fit Black M/L Bra
((SELECT id FROM products WHERE name = 'The Ultimate Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Black') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Cross Fit Beige M/L Bra
((SELECT id FROM products WHERE name = 'Cross Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'Cross Beige') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Alive Fit Bra White M/L
((SELECT id FROM products WHERE name = 'Alive Fit Bra' AND color_id = (SELECT id FROM colors WHERE name = 'White') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW());

-- Sets - Leggings (14 articles)
INSERT INTO stock (product_id, store_id, quantity, stock_type, created_at) VALUES
-- Pure Motion Fit Turquoise M/L Legging
((SELECT id FROM products WHERE name = 'Pure Motion Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Turquoise') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- One Shoulder Ribbed Fit Turquoise M/L Legging
((SELECT id FROM products WHERE name = 'One Shoulder Ribbed Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Turquoise') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- One Shoulder Ribbed Fit Green Fluo M/L Legging
((SELECT id FROM products WHERE name = 'One Shoulder Ribbed Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Green Fluo') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Corail Fit S/M Legging
((SELECT id FROM products WHERE name = 'Corail Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Coral') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- Perfect Fit Brown Chocolate S/M Legging
((SELECT id FROM products WHERE name = 'Perfect Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Brown Chocolate') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- Perfect Fit Dark Grey M/L Legging
((SELECT id FROM products WHERE name = 'Perfect Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Dark Grey') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Perfect Fit Gardenia M/L Legging
((SELECT id FROM products WHERE name = 'Perfect Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Gardenia') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Fashion Fit Flare Beige M/L Legging
((SELECT id FROM products WHERE name = 'Fashion Fit Flare Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Flare Beige') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Fashion Fit Flare Black M/L Legging
((SELECT id FROM products WHERE name = 'Fashion Fit Flare Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Black') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Fashion Fit Army M/L Legging
((SELECT id FROM products WHERE name = 'Fashion Fit Army Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Army') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Align Fit Yellow XS/S Legging
((SELECT id FROM products WHERE name = 'Align Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Yellow') AND size_id = (SELECT id FROM sizes WHERE name = 'XS/S')), 1, 1, 'admin', NOW()),

-- The Ultimate Fit Black M/L Legging
((SELECT id FROM products WHERE name = 'The Ultimate Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Black') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Cross Fit Beige M/L Legging
((SELECT id FROM products WHERE name = 'Cross Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Cross Beige') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Streamline Fit Blue M/L Legging
((SELECT id FROM products WHERE name = 'Streamline Fit Legging' AND color_id = (SELECT id FROM colors WHERE name = 'Blue') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW());

-- Sets - Shorts (1 article)
INSERT INTO stock (product_id, store_id, quantity, stock_type, created_at) VALUES
-- Align Fit Yellow M/L Short
((SELECT id FROM products WHERE name = 'Align Fit Short' AND color_id = (SELECT id FROM colors WHERE name = 'Yellow') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW());

-- Tops & T-shirts (13 articles)
INSERT INTO stock (product_id, store_id, quantity, stock_type, created_at) VALUES
-- Relaxed Fit T-Shirt Black M/L
((SELECT id FROM products WHERE name = 'Relaxed Fit T-Shirt' AND color_id = (SELECT id FROM colors WHERE name = 'Black') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Relaxed Fit T-Shirt White M/L
((SELECT id FROM products WHERE name = 'Relaxed Fit T-Shirt' AND color_id = (SELECT id FROM colors WHERE name = 'White') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Relaxed Fit T-Shirt Dark Purple M/L (quantité 2)
((SELECT id FROM products WHERE name = 'Relaxed Fit T-Shirt' AND color_id = (SELECT id FROM colors WHERE name = 'Dark Purple') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 2, 'admin', NOW()),

-- Relaxed Fit T-Shirt Dark Purple S/M
((SELECT id FROM products WHERE name = 'Relaxed Fit T-Shirt' AND color_id = (SELECT id FROM colors WHERE name = 'Dark Purple') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- Jacket Fit Cape Comfort Blue S/M
((SELECT id FROM products WHERE name = 'Jacket Fit Cape Comfort' AND color_id = (SELECT id FROM colors WHERE name = 'Cape Blue') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- Oversized Twist Shirt White S/M
((SELECT id FROM products WHERE name = 'Oversized Twist Shirt' AND color_id = (SELECT id FROM colors WHERE name = 'White') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- Must Fit White Tank Top L/XL
((SELECT id FROM products WHERE name = 'Must Fit Tank Top' AND color_id = (SELECT id FROM colors WHERE name = 'White') AND size_id = (SELECT id FROM sizes WHERE name = 'L/XL')), 1, 1, 'admin', NOW()),

-- Must Fit Black Tank Top M/L
((SELECT id FROM products WHERE name = 'Must Fit Tank Top' AND color_id = (SELECT id FROM colors WHERE name = 'Black') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Must Fit Light Blue Tank Top L/XL
((SELECT id FROM products WHERE name = 'Must Fit Tank Top' AND color_id = (SELECT id FROM colors WHERE name = 'Light Blue') AND size_id = (SELECT id FROM sizes WHERE name = 'L/XL')), 1, 1, 'admin', NOW()),

-- Must Fit Midnight Blue Tank Top S/M
((SELECT id FROM products WHERE name = 'Must Fit Tank Top' AND color_id = (SELECT id FROM colors WHERE name = 'Midnight Blue') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- Must Fit Pink Tank Top M/L
((SELECT id FROM products WHERE name = 'Must Fit Tank Top' AND color_id = (SELECT id FROM colors WHERE name = 'Pink') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Must Fit Army Tank Top XS/S
((SELECT id FROM products WHERE name = 'Must Fit Tank Top' AND color_id = (SELECT id FROM colors WHERE name = 'Army') AND size_id = (SELECT id FROM sizes WHERE name = 'XS/S')), 1, 1, 'admin', NOW()),

-- Must Fit Light Purple Tank Top L/XL
((SELECT id FROM products WHERE name = 'Must Fit Tank Top' AND color_id = (SELECT id FROM colors WHERE name = 'Light Purple') AND size_id = (SELECT id FROM sizes WHERE name = 'L/XL')), 1, 1, 'admin', NOW());

-- Accessories - Socks (2 articles avec quantité 2 chacun)
INSERT INTO stock (product_id, store_id, quantity, stock_type, created_at) VALUES
-- Socks White (quantité 2)
((SELECT id FROM products WHERE name = 'Socks' AND color_id = (SELECT id FROM colors WHERE name = 'White') AND size_id = (SELECT id FROM sizes WHERE name = 'Free Size')), 1, 2, 'admin', NOW()),

-- Socks Black (quantité 2)
((SELECT id FROM products WHERE name = 'Socks' AND color_id = (SELECT id FROM colors WHERE name = 'Black') AND size_id = (SELECT id FROM sizes WHERE name = 'Free Size')), 1, 2, 'admin', NOW());

-- Swimwears (2 articles)
INSERT INTO stock (product_id, store_id, quantity, stock_type, created_at) VALUES
-- Swimwear Army S/M
((SELECT id FROM products WHERE name = 'Swimwear' AND color_id = (SELECT id FROM colors WHERE name = 'Army') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW()),

-- Swimwears Black Cream S/M
((SELECT id FROM products WHERE name = 'Swimwear' AND color_id = (SELECT id FROM colors WHERE name = 'Black Cream') AND size_id = (SELECT id FROM sizes WHERE name = 'S/M')), 1, 1, 'admin', NOW());

-- Jumpsuits (3 articles)
INSERT INTO stock (product_id, store_id, quantity, stock_type, created_at) VALUES
-- Jumpsuit Cut Out Red Cherry M/L
((SELECT id FROM products WHERE name = 'Jumpsuit Cut Out' AND color_id = (SELECT id FROM colors WHERE name = 'Red Cherry') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Faboulous Fit Amy M/L
((SELECT id FROM products WHERE name = 'Faboulous Fit' AND color_id = (SELECT id FROM colors WHERE name = 'Amy') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW()),

-- Faboulous Fit Purple M/L
((SELECT id FROM products WHERE name = 'Faboulous Fit' AND color_id = (SELECT id FROM colors WHERE name = 'Purple') AND size_id = (SELECT id FROM sizes WHERE name = 'M/L')), 1, 1, 'admin', NOW());