-- Migration: Add all Bambu Lab predefined colors
-- Date: 2025-06-20
-- Description: Import comprehensive Bambu Lab color palette

-- Insert all Bambu Lab colors
INSERT INTO colors (name, hex) VALUES
  -- Basic Colors
  ('Black', '#1A1A1A'),
  ('White', '#FFFFFF'),
  ('Red', '#E53935'),
  ('Blue', '#1E88E5'),
  ('Green', '#43A047'),
  ('Yellow', '#FDD835'),
  ('Orange', '#FB8C00'),
  ('Purple', '#8E24AA'),
  ('Pink', '#EC407A'),
  ('Grey', '#757575'),
  ('Brown', '#6D4C41'),
  ('Light Blue', '#64B5F6'),
  ('Light Green', '#81C784'),
  ('Mint Green', '#4DB6AC'),
  ('Lime Green', '#C0CA33'),
  ('Sky Blue', '#81D4FA'),
  ('Navy Blue', '#283593'),
  ('Magenta', '#E91E63'),
  ('Violet', '#7B1FA2'),
  ('Beige', '#F5DEB3'),
  ('Ivory', '#FFFFF0'),
  
  -- Matte Colors
  ('Matte Black', '#212121'),
  ('Matte White', '#FAFAFA'),
  ('Matte Red', '#C62828'),
  ('Matte Blue', '#1565C0'),
  ('Matte Green', '#2E7D32'),
  ('Matte Yellow', '#F9A825'),
  ('Matte Orange', '#EF6C00'),
  ('Matte Purple', '#6A1B9A'),
  ('Matte Pink', '#D81B60'),
  ('Matte Grey', '#616161'),
  ('Matte Brown', '#4E342E'),
  ('Matte Mint', '#26A69A'),
  ('Matte Lime', '#9E9D24'),
  ('Matte Navy', '#1A237E'),
  ('Matte Coral', '#FF5252'),
  
  -- Silk Colors
  ('Silk White', '#FEFEFE'),
  ('Silk Black', '#0A0A0A'),
  ('Silk Red', '#F44336'),
  ('Silk Blue', '#2196F3'),
  ('Silk Green', '#4CAF50'),
  ('Silk Gold', '#FFD54F'),
  ('Silk Silver', '#CFD8DC'),
  ('Silk Purple', '#9C27B0'),
  ('Silk Pink', '#F06292'),
  ('Silk Orange', '#FF9800'),
  ('Silk Bronze', '#A1887F'),
  ('Silk Copper', '#BF6F3F'),
  ('Silk Jade', '#00897B'),
  ('Silk Rose Gold', '#E8A09A'),
  ('Silk Pearl', '#F8F8FF'),
  ('Silk Ruby', '#E91E63'),
  ('Silk Sapphire', '#1976D2'),
  ('Silk Emerald', '#00695C'),
  
  -- Metal Colors
  ('Metal Grey', '#9E9E9E'),
  ('Metal Silver', '#B0BEC5'),
  ('Metal Gold', '#D4AF37'),
  ('Metal Copper', '#B87333'),
  ('Metal Bronze', '#CD7F32'),
  
  -- Sparkle Colors
  ('Sparkle Red', '#EF5350'),
  ('Sparkle Blue', '#42A5F5'),
  ('Sparkle Green', '#66BB6A'),
  ('Sparkle Purple', '#AB47BC'),
  ('Sparkle Gold', '#FFCA28'),
  ('Sparkle Silver', '#E0E0E0'),
  
  -- Glow Colors
  ('Glow in the Dark Green', '#C8E6C9'),
  ('Glow in the Dark Blue', '#BBDEFB'),
  
  -- Transparent Colors
  ('Clear', '#FFFFFF'),
  ('Transparent Red', '#EF5350'),
  ('Transparent Blue', '#42A5F5'),
  ('Transparent Green', '#66BB6A'),
  ('Transparent Yellow', '#FFEE58'),
  ('Transparent Orange', '#FFA726'),
  ('Transparent Purple', '#AB47BC'),
  
  -- Support Materials
  ('Natural', '#F5F5DC'),
  ('Support White', '#F5F5F5'),
  ('Support G', '#90CAF9')
ON CONFLICT (name) DO UPDATE SET hex = EXCLUDED.hex;