-- Script pour ajouter les produits du deuxième lot (52 articles)
-- Date: 02/07/2025 - Shyva Agadir

-- Sets - Bras
INSERT INTO products (name, description, category_id, color_id, size_id, retail_price, created_at) VALUES
-- Pure Motion Fit Turquoise M/L
((SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Turquoise'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW()),

-- One Shoulder Ribbed Fit Turquoise M/L  
('One Shoulder Ribbed Fit Bra', 'Bra sport avec design asymétrique', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Turquoise'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW()),

-- One Shoulder Ribbed Fit Green Fluo M/L
('One Shoulder Ribbed Fit Bra', 'Bra sport avec design asymétrique', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Green Fluo'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW()),

-- Corail Fit S/M
('Corail Fit Bra', 'Bra sport couleur corail', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Coral'), (SELECT id FROM sizes WHERE name = 'S/M'), 389, NOW()),

-- Perfect Fit Brown Chocolate S/M
('Perfect Fit Bra', 'Bra sport coupe parfaite', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Brown Chocolate'), (SELECT id FROM sizes WHERE name = 'S/M'), 389, NOW()),

-- Perfect Fit Dark Grey M/L
('Perfect Fit Bra', 'Bra sport coupe parfaite', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Dark Grey'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW()),

-- Perfect Fit Gardenia M/L
('Perfect Fit Bra', 'Bra sport coupe parfaite', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Gardenia'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW()),

-- Fashion Fit Flare Beige M/L
('Fashion Fit Flare Bra', 'Bra sport style fashion', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Flare Beige'), (SELECT id FROM sizes WHERE name = 'M/L'), 399, NOW()),

-- Fashion Fit Flare Black M/L
('Fashion Fit Flare Bra', 'Bra sport style fashion', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Black'), (SELECT id FROM sizes WHERE name = 'M/L'), 399, NOW()),

-- Fashion Fit Army M/L
('Fashion Fit Army Bra', 'Bra sport couleur army', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Army'), (SELECT id FROM sizes WHERE name = 'M/L'), 399, NOW()),

-- Align Fit Yellow S/M
('Align Fit Bra', 'Bra sport alignement parfait', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Yellow'), (SELECT id FROM sizes WHERE name = 'S/M'), 389, NOW()),

-- The Ultimate Fit Black M/L
('The Ultimate Fit Bra', 'Bra sport ultime confort', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Black'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW()),

-- Cross Fit Beige M/L
('Cross Fit Bra', 'Bra sport cross training', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Cross Beige'), (SELECT id FROM sizes WHERE name = 'M/L'), 399, NOW()),

-- Alive Fit Bra White M/L
('Alive Fit Bra', 'Bra sport dynamique', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'White'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW());

-- Sets - Leggings
INSERT INTO products (name, description, category_id, color_id, size_id, retail_price, created_at) VALUES
-- Pure Motion Fit Turquoise M/L
('Pure Motion Fit Legging', 'Legging haute performance', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Turquoise'), (SELECT id FROM sizes WHERE name = 'M/L'), 499, NOW()),

-- One Shoulder Ribbed Fit Turquoise M/L
('One Shoulder Ribbed Fit Legging', 'Legging avec texture côtelée', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Turquoise'), (SELECT id FROM sizes WHERE name = 'M/L'), 499, NOW()),

-- One Shoulder Ribbed Fit Green Fluo M/L
('One Shoulder Ribbed Fit Legging', 'Legging avec texture côtelée', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Green Fluo'), (SELECT id FROM sizes WHERE name = 'M/L'), 499, NOW()),

-- Corail Fit S/M
('Corail Fit Legging', 'Legging couleur corail', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Coral'), (SELECT id FROM sizes WHERE name = 'S/M'), 499, NOW()),

-- Perfect Fit Brown Chocolate S/M
('Perfect Fit Legging', 'Legging coupe parfaite', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Brown Chocolate'), (SELECT id FROM sizes WHERE name = 'S/M'), 499, NOW()),

-- Perfect Fit Dark Grey M/L
('Perfect Fit Legging', 'Legging coupe parfaite', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Dark Grey'), (SELECT id FROM sizes WHERE name = 'M/L'), 499, NOW()),

-- Perfect Fit Gardenia M/L
('Perfect Fit Legging', 'Legging coupe parfaite', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Gardenia'), (SELECT id FROM sizes WHERE name = 'M/L'), 499, NOW()),

-- Fashion Fit Flare Beige M/L
('Fashion Fit Flare Legging', 'Legging style fashion évasé', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Flare Beige'), (SELECT id FROM sizes WHERE name = 'M/L'), 525, NOW()),

-- Fashion Fit Flare Black M/L
('Fashion Fit Flare Legging', 'Legging style fashion évasé', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Black'), (SELECT id FROM sizes WHERE name = 'M/L'), 525, NOW()),

-- Fashion Fit Army M/L
('Fashion Fit Army Legging', 'Legging couleur army', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Army'), (SELECT id FROM sizes WHERE name = 'M/L'), 499, NOW()),

-- Align Fit Yellow XS/S
('Align Fit Legging', 'Legging alignement parfait', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Yellow'), (SELECT id FROM sizes WHERE name = 'XS/S'), 499, NOW()),

-- The Ultimate Fit Black M/L
('The Ultimate Fit Legging', 'Legging ultime confort', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Black'), (SELECT id FROM sizes WHERE name = 'M/L'), 499, NOW()),

-- Cross Fit Beige M/L
('Cross Fit Legging', 'Legging cross training', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Cross Beige'), (SELECT id FROM sizes WHERE name = 'M/L'), 499, NOW()),

-- Streamline Fit Blue M/L
('Streamline Fit Legging', 'Legging design streamline', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Blue'), (SELECT id FROM sizes WHERE name = 'M/L'), 499, NOW());

-- Sets - Shorts
INSERT INTO products (name, description, category_id, color_id, size_id, retail_price, created_at) VALUES
-- Align Fit Yellow M/L
('Align Fit Short', 'Short sport alignement parfait', (SELECT id FROM categories WHERE name = 'Sets'), (SELECT id FROM colors WHERE name = 'Yellow'), (SELECT id FROM sizes WHERE name = 'M/L'), 399, NOW());

-- Tops & T-shirts
INSERT INTO products (name, description, category_id, color_id, size_id, retail_price, created_at) VALUES
-- Relaxed Fit T-Shirt Black M/L
('Relaxed Fit T-Shirt', 'T-shirt coupe décontractée', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'Black'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW()),

-- Relaxed Fit T-Shirt White M/L
('Relaxed Fit T-Shirt', 'T-shirt coupe décontractée', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'White'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW()),

-- Relaxed Fit T-Shirt Dark Purple M/L
('Relaxed Fit T-Shirt', 'T-shirt coupe décontractée', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'Dark Purple'), (SELECT id FROM sizes WHERE name = 'M/L'), 389, NOW()),

-- Relaxed Fit T-Shirt Dark Purple S/M
('Relaxed Fit T-Shirt', 'T-shirt coupe décontractée', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'Dark Purple'), (SELECT id FROM sizes WHERE name = 'S/M'), 389, NOW()),

-- Jacket Fit Cape Comfort Blue S/M
('Jacket Fit Cape Comfort', 'Veste sport confort cape', (SELECT id FROM categories WHERE name = 'Jackets'), (SELECT id FROM colors WHERE name = 'Cape Blue'), (SELECT id FROM sizes WHERE name = 'S/M'), 499, NOW()),

-- Oversized Twist Shirt White S/M
('Oversized Twist Shirt', 'Chemise oversize avec twist', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'White'), (SELECT id FROM sizes WHERE name = 'S/M'), 599, NOW()),

-- Must Fit White Tank Top L/XL
('Must Fit Tank Top', 'Débardeur sport essentiel', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'White'), (SELECT id FROM sizes WHERE name = 'L/XL'), 349, NOW()),

-- Must Fit Black Tank Top M/L
('Must Fit Tank Top', 'Débardeur sport essentiel', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'Black'), (SELECT id FROM sizes WHERE name = 'M/L'), 349, NOW()),

-- Must Fit Light Blue Tank Top L/XL
('Must Fit Tank Top', 'Débardeur sport essentiel', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'Light Blue'), (SELECT id FROM sizes WHERE name = 'L/XL'), 349, NOW()),

-- Must Fit Midnight Blue Tank Top S/M
('Must Fit Tank Top', 'Débardeur sport essentiel', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'Midnight Blue'), (SELECT id FROM sizes WHERE name = 'S/M'), 349, NOW()),

-- Must Fit Pink Tank Top M/L
('Must Fit Tank Top', 'Débardeur sport essentiel', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'Pink'), (SELECT id FROM sizes WHERE name = 'M/L'), 349, NOW()),

-- Must Fit Army Tank Top XS/S
('Must Fit Tank Top', 'Débardeur sport essentiel', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'Army'), (SELECT id FROM sizes WHERE name = 'XS/S'), 349, NOW()),

-- Must Fit Light Purple Tank Top L/XL
('Must Fit Tank Top', 'Débardeur sport essentiel', (SELECT id FROM categories WHERE name = 'Tops & T-shirts'), (SELECT id FROM colors WHERE name = 'Light Purple'), (SELECT id FROM sizes WHERE name = 'L/XL'), 349, NOW());

-- Accessories - Socks
INSERT INTO products (name, description, category_id, color_id, size_id, retail_price, created_at) VALUES
-- Socks White
('Socks', 'Chaussettes sport', (SELECT id FROM categories WHERE name = 'Accessories'), (SELECT id FROM colors WHERE name = 'White'), (SELECT id FROM sizes WHERE name = 'Free Size'), 129, NOW()),

-- Socks Black
('Socks', 'Chaussettes sport', (SELECT id FROM categories WHERE name = 'Accessories'), (SELECT id FROM colors WHERE name = 'Black'), (SELECT id FROM sizes WHERE name = 'Free Size'), 129, NOW());

-- Swimwears
INSERT INTO products (name, description, category_id, color_id, size_id, retail_price, created_at) VALUES
-- Swimwear Army S/M
('Swimwear', 'Maillot de bain sport', (SELECT id FROM categories WHERE name = 'Swimwears'), (SELECT id FROM colors WHERE name = 'Army'), (SELECT id FROM sizes WHERE name = 'S/M'), 849, NOW()),

-- Swimwears Black Cream S/M
('Swimwear', 'Maillot de bain sport', (SELECT id FROM categories WHERE name = 'Swimwears'), (SELECT id FROM colors WHERE name = 'Black Cream'), (SELECT id FROM sizes WHERE name = 'S/M'), 849, NOW());

-- Jumpsuits
INSERT INTO products (name, description, category_id, color_id, size_id, retail_price, created_at) VALUES
-- Jumpsuit Cut Out Red Cherry M/L
('Jumpsuit Cut Out', 'Combinaison avec découpes', (SELECT id FROM categories WHERE name = 'Jumpsuits'), (SELECT id FROM colors WHERE name = 'Red Cherry'), (SELECT id FROM sizes WHERE name = 'M/L'), 699, NOW()),

-- Faboulous Fit Amy M/L
('Faboulous Fit', 'Combinaison coupe fabuleuse', (SELECT id FROM categories WHERE name = 'Jumpsuits'), (SELECT id FROM colors WHERE name = 'Amy'), (SELECT id FROM sizes WHERE name = 'M/L'), 699, NOW()),

-- Faboulous Fit Purple M/L
('Faboulous Fit', 'Combinaison coupe fabuleuse', (SELECT id FROM categories WHERE name = 'Jumpsuits'), (SELECT id FROM colors WHERE name = 'Purple'), (SELECT id FROM sizes WHERE name = 'M/L'), 699, NOW());
