Prompt Management

// 1. Insert into prompts table (HEAD state)
const { data: promptData } = await supabase
  .from('prompts')
  .insert({
    title,
    description,
    user_id: user.id,
  })
  .select('id')
  .single();

// 2. Insert into prompt_versions table (immutable history)
const { error: versionError } = await supabase
  .from('prompt_versions')
  .insert({
    prompt_id: promptData.id,
    version_number: 1,
    content,
    version_note,
  });

await updatePromptMetadata(promptId, {
  title: 'Updated Title',
  description: 'Updated description',
});

await archivePrompt(promptId);

await restorePrompt(promptId);

await deletePrompt(promptId);

CREATE TABLE prompts (
  id UUID PRIMARY KEY,
  user_id UUID REFERENCES profiles(id),
  title TEXT NOT NULL,
  description TEXT,
  archived_at TIMESTAMP,
  is_public BOOLEAN DEFAULT false,
  created_at TIMESTAMP,
  updated_at TIMESTAMP,
  search_tokens tsvector  -- For full-text search
);

CREATE TABLE prompt_versions (
  id UUID PRIMARY KEY,
  prompt_id UUID REFERENCES prompts(id) ON DELETE CASCADE,
  version_number INT NOT NULL,
  content TEXT NOT NULL,
  version_note TEXT,
  created_at TIMESTAMP,
  UNIQUE(prompt_id, version_number)
);

-- Users can only view their own prompts
CREATE POLICY "Users can view their own prompts" 
  ON prompts FOR SELECT 
  USING (auth.uid() = user_id);

-- Users can only modify their own prompts
CREATE POLICY "Users can update their own prompts" 
  ON prompts FOR UPDATE 
  USING (auth.uid() = user_id);