Migration Fixes

-- BROKEN: These tables don't exist
author_workspace_id UUID REFERENCES workspaces(id)
author_user_id UUID REFERENCES auth.users(id)
workspace_id UUID NOT NULL REFERENCES workspaces(id)
user_id UUID REFERENCES auth.users(id)

author_workspace_id UUID REFERENCES workspaces(id) ON DELETE SET NULL

author_workspace_id UUID  -- Stored as UUID without FK constraint

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

-- Commented out for initial deployment - requires auth setup
-- CREATE POLICY "Users can view their own usage"
--   ON template_usage FOR SELECT
--   USING (user_id = auth.uid());

// Before:
const { data: workspace } = await supabaseAdmin
  .from("workspaces")
  .select("id")
  .eq("owner_id", session.user.id)
  .single();

// After:
const workspaceId = customizations?.workspaceId || session.user.id; // Use user ID as fallback

// Also commented out workspace_id in form insert:
// formInsert.workspace_id = workspaceId;  // Uncomment when workspaces table exists

# If using Supabase CLI
supabase db push --file migrations/082_form_templates.sql
supabase db push --file migrations/083_seed_government_templates.sql

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public'
AND table_name IN ('template_categories', 'form_templates', 'template_usage', 'template_reviews');

SELECT name, slug FROM template_categories;
-- Should show 8 categories: Government, Nonprofit, Business, etc.

SELECT name, slug, is_featured FROM form_templates WHERE is_published = true;
-- Should show 5 government form templates

SELECT auth.uid();
-- Should return your user ID

-- Form Templates: Authors can view their own private templates
CREATE POLICY "Authors can view their own templates"
  ON form_templates FOR SELECT
  USING (author_user_id = auth.uid());

-- Template Usage: Users can view their own usage
CREATE POLICY "Users can view their own template usage"
  ON template_usage FOR SELECT
  USING (user_id = auth.uid());

-- Template Usage: Users can track their own usage
CREATE POLICY "Users can track their own template usage"
  ON template_usage FOR INSERT
  WITH CHECK (user_id = auth.uid());

-- Template Reviews: Users can manage their own reviews
CREATE POLICY "Users can manage their own reviews"
  ON template_reviews FOR ALL
  USING (user_id = auth.uid());

// 1. Get template categories
const { data } = await getTemplateCategories();
console.log(data); // Should show 8 categories

// 2. Get all templates
const { data: templates } = await getTemplates({});
console.log(templates); // Should show 5 government templates

// 3. Get featured templates
const { data: featured } = await getFeaturedTemplates(6);
console.log(featured); // Should show featured templates

// 4. Get template by slug
const { data: template } = await getTemplateBySlug('building-permit-application');
console.log(template); // Should show building permit template details

// 5. Create form from template (requires auth)
const { data: form } = await createFormFromTemplate(template.id);
console.log(form); // Should return { formId: '...' }

SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';