/**
* Create conversations table in Supabase
* Run this once to set up the cloud database schema
*/
require('dotenv').config();
const { createClient } = require('@supabase/supabase-js');
const fs = require('fs');
const path = require('path');
const supabase = createClient(
process.env.NEXT_PUBLIC_SUPABASE_URL,
process.env.SUPABASE_SERVICE_ROLE_KEY
);
async function createTable() {
console.log('š Creating conversations table in Supabase...\n');
console.log(`š” Connected to: ${process.env.NEXT_PUBLIC_SUPABASE_URL}\n`);
// Read SQL schema file
const sqlPath = path.join(__dirname, 'supabase', 'create_conversations_table.sql');
const sql = fs.readFileSync(sqlPath, 'utf8');
console.log('SQL Schema:');
console.log(sql);
console.log('\n---\n');
// Execute SQL via direct query
// Note: Supabase client doesn't have direct SQL execution
// Use Supabase SQL Editor or alternative method
console.log('ā ļø Note: Supabase JavaScript client doesn\'t support direct SQL execution');
console.log('\nš Please run the SQL schema manually:');
console.log(' 1. Go to https://supabase.com/dashboard');
console.log(' 2. Select your project');
console.log(' 3. Go to SQL Editor');
console.log(' 4. Copy and paste the SQL from: supabase/create_conversations_table.sql');
console.log(' 5. Click Run\n');
console.log('āØ Alternatively, use this SQL directly:\n');
console.log(sql);
}
createTable();
