seed-data.sql

-- Seed data for ClearPix Enhancement Categories and Prompts

-- Insert Enhancement Categories
INSERT INTO enhancement_categories (slug, name, icon, sort_order, is_active) VALUES
('artistic', 'Artistic Styles', '🎨', 1, true),
('portraits', 'Portraits & Headshots', '👤', 2, true),
('photography', 'Photography', '📸', 3, true),
('restoration', 'Restoration', '🔧', 4, true),
('creative', 'Creative Effects', '✨', 5, true);

-- Get category IDs for reference (you'll need to update these after running the insert)
-- For now, we'll use the slugs and you'll need to match them

-- Insert Enhancement Prompts for Artistic Styles
INSERT INTO enhancement_prompts (
  slug, name, description, prompt, credits, category_id,
  is_featured, is_active, is_new, max_images,
  requires_image_upload, requires_face_preservation, preferred_model,
  custom_fields
) VALUES
(
  'oil-painting',
  'Oil Painting',
  'Transform your photo into a classic oil painting with rich textures and vibrant colors',
  'Convert this image into a beautiful oil painting style with visible brush strokes, rich colors, and artistic texture',
  2,
  (SELECT id FROM enhancement_categories WHERE slug = 'artistic'),
  true,
  true,
  false,
  3,
  true,
  false,
  'claude-3-opus',
  '[]'
),
(
  'watercolor',
  'Watercolor Art',
  'Create a soft, flowing watercolor painting effect with delicate color blends',
  'Transform this image into a watercolor painting with soft edges, flowing colors, and artistic paper texture',
  2,
  (SELECT id FROM enhancement_categories WHERE slug = 'artistic'),
  true,
  true,
  true,
  3,
  true,
  false,
  'claude-3-opus',
  '[{"name":"intensity","label":"Effect Intensity","type":"select","options":["Light","Medium","Heavy"],"defaultValue":"Medium","required":false}]'
),
(
  'anime-style',
  'Anime Style',
  'Convert your photo into stunning anime/manga artwork',
  'Transform this photo into anime/manga style art with characteristic features, vibrant colors, and cel-shaded appearance',
  3,
  (SELECT id FROM enhancement_categories WHERE slug = 'artistic'),
  true,
  true,
  true,
  2,
  true,
  true,
  'claude-3-opus',
  '[]'
);

-- Insert Enhancement Prompts for Portraits
INSERT INTO enhancement_prompts (
  slug, name, description, prompt, credits, category_id,
  is_featured, is_active, is_new, max_images,
  requires_image_upload, requires_face_preservation, preferred_model,
  custom_fields
) VALUES
(
  'professional-headshot',
  'Professional Headshot',
  'Create a polished professional headshot perfect for LinkedIn and resumes',
  'Enhance this photo into a professional business headshot with proper lighting, clean background, and professional appearance',
  2,
  (SELECT id FROM enhancement_categories WHERE slug = 'portraits'),
  true,
  true,
  false,
  1,
  true,
  true,
  'claude-3-opus',
  '[{"name":"background","label":"Background Style","type":"select","options":["Office","Studio Gray","Studio White","Blur"],"defaultValue":"Studio Gray","required":true}]'
),
(
  'glamour-shot',
  'Glamour Portrait',
  'Enhance portraits with professional retouching and lighting',
  'Create a glamorous portrait with professional retouching, soft lighting, and enhanced features while maintaining natural appearance',
  2,
  (SELECT id FROM enhancement_categories WHERE slug = 'portraits'),
  true,
  true,
  false,
  5,
  true,
  true,
  'claude-3-opus',
  '[]'
),
(
  'age-progression',
  'Age Progression',
  'See what you might look like older or younger',
  'Apply age progression or regression to show how the person might look at a different age',
  4,
  (SELECT id FROM enhancement_categories WHERE slug = 'portraits'),
  false,
  true,
  true,
  1,
  true,
  true,
  'claude-3-opus',
  '[{"name":"target_age","label":"Target Age","type":"text","placeholder":"e.g., 60 years old","required":true}]'
);

-- Insert Enhancement Prompts for Photography
INSERT INTO enhancement_prompts (
  slug, name, description, prompt, credits, category_id,
  is_featured, is_active, is_new, max_images,
  requires_image_upload, requires_face_preservation, preferred_model,
  custom_fields
) VALUES
(
  'hdr-enhancement',
  'HDR Enhancement',
  'Bring out details in shadows and highlights for stunning dynamic range',
  'Apply HDR enhancement to bring out details in both shadows and highlights, create vibrant colors and improved dynamic range',
  1,
  (SELECT id FROM enhancement_categories WHERE slug = 'photography'),
  true,
  true,
  false,
  5,
  true,
  false,
  'claude-3-sonnet',
  '[]'
),
(
  'color-grading',
  'Cinematic Color Grading',
  'Apply professional color grading for a cinematic look',
  'Apply cinematic color grading with professional color correction, mood enhancement, and film-like appearance',
  2,
  (SELECT id FROM enhancement_categories WHERE slug = 'photography'),
  true,
  true,
  false,
  5,
  true,
  false,
  'claude-3-opus',
  '[{"name":"style","label":"Grading Style","type":"select","options":["Warm Sunset","Cool Blue","Vintage Film","Moody Dark","Bright & Airy"],"defaultValue":"Warm Sunset","required":true}]'
),
(
  'background-blur',
  'Background Blur (Bokeh)',
  'Create beautiful depth-of-field with professional background blur',
  'Apply professional bokeh effect to blur the background while keeping the subject sharp, simulating shallow depth of field',
  1,
  (SELECT id FROM enhancement_categories WHERE slug = 'photography'),
  false,
  true,
  false,
  5,
  true,
  false,
  'claude-3-sonnet',
  '[]'
);

-- Insert Enhancement Prompts for Restoration
INSERT INTO enhancement_prompts (
  slug, name, description, prompt, credits, category_id,
  is_featured, is_active, is_new, max_images,
  requires_image_upload, requires_face_preservation, preferred_model,
  custom_fields
) VALUES
(
  'photo-restoration',
  'Photo Restoration',
  'Restore old or damaged photos by removing scratches, stains, and tears',
  'Restore this old or damaged photo by removing scratches, tears, stains, and imperfections while preserving the original appearance',
  3,
  (SELECT id FROM enhancement_categories WHERE slug = 'restoration'),
  true,
  true,
  false,
  3,
  true,
  true,
  'claude-3-opus',
  '[]'
),
(
  'colorize-photo',
  'Colorize Black & White',
  'Add realistic colors to black and white photos',
  'Colorize this black and white photo with realistic, historically accurate colors',
  3,
  (SELECT id FROM enhancement_categories WHERE slug = 'restoration'),
  true,
  true,
  false,
  3,
  true,
  false,
  'claude-3-opus',
  '[]'
),
(
  'upscale-enhance',
  'Upscale & Enhance',
  'Increase resolution and enhance image quality',
  'Upscale and enhance this image to higher resolution while improving sharpness, clarity, and detail',
  2,
  (SELECT id FROM enhancement_categories WHERE slug = 'restoration'),
  false,
  true,
  false,
  5,
  true,
  false,
  'claude-3-opus',
  '[]'
);

-- Insert Enhancement Prompts for Creative Effects
INSERT INTO enhancement_prompts (
  slug, name, description, prompt, credits, category_id,
  is_featured, is_active, is_new, max_images,
  requires_image_upload, requires_face_preservation, preferred_model,
  custom_fields
) VALUES
(
  'fantasy-portrait',
  'Fantasy Portrait',
  'Transform yourself into a fantasy character or scene',
  'Transform this portrait into a fantasy character with magical elements, ethereal lighting, and fantastical setting',
  4,
  (SELECT id FROM enhancement_categories WHERE slug = 'creative'),
  true,
  true,
  true,
  2,
  true,
  true,
  'claude-3-opus',
  '[{"name":"theme","label":"Fantasy Theme","type":"select","options":["Elf","Warrior","Wizard","Angel","Vampire","Dragon Rider"],"defaultValue":"Elf","required":true}]'
),
(
  'season-change',
  'Season Transformation',
  'Change the season in your landscape photos',
  'Transform the season in this landscape photo to show it in a different time of year',
  2,
  (SELECT id FROM enhancement_categories WHERE slug = 'creative'),
  false,
  true,
  false,
  5,
  true,
  false,
  'claude-3-opus',
  '[{"name":"season","label":"Target Season","type":"select","options":["Spring","Summer","Fall","Winter"],"required":true}]'
),
(
  'time-of-day',
  'Time of Day Change',
  'Change your photo from day to night or vice versa',
  'Transform the time of day in this photo with realistic lighting, sky, and atmospheric changes',
  3,
  (SELECT id FROM enhancement_categories WHERE slug = 'creative'),
  false,
  true,
  true,
  5,
  true,
  false,
  'claude-3-opus',
  '[{"name":"time","label":"Target Time","type":"select","options":["Sunrise","Midday","Golden Hour","Sunset","Twilight","Night"],"required":true}]'
);