Twilioapp-admin/check-table.js

const { createClient } = require('@supabase/supabase-js');

const supabaseUrl = 'https://poxwjzdianersitpnvdy.supabase.co';
const supabaseKey = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InBveHdqemRpYW5lcnNpdHBudmR5Iiwicm9sZSI6ImFub24iLCJpYXQiOjE3NTExNjk4MjMsImV4cCI6MjA2Njc0NTgyM30.FkgCCSHK0_i8bNFIhhN3k6dEbP5PpE52IggcVJC4Aj8';

const supabase = createClient(supabaseUrl, supabaseKey);

async function checkTable() {
  try {
    console.log('检查users表结构...');
    
    // 尝试查询表中的所有数据
    const { data, error } = await supabase
      .from('users')
      .select('*')
      .limit(1);
    
    if (error) {
      console.error('查询错误:', error);
    } else {
      console.log('查询结果:', data);
      if (data && data.length > 0) {
        console.log('表列名:', Object.keys(data[0]));
      } else {
        console.log('表为空，尝试插入测试数据...');
        
        // 尝试插入一个简单的用户
        const { data: insertData, error: insertError } = await supabase
          .from('users')
          .insert([
            {
              email: 'admin@example.com',
              name: '系统管理员',
              phone: '13800138000',
              user_type: 'admin',
              status: 'active'
            }
          ])
          .select();
        
        if (insertError) {
          console.error('插入错误:', insertError);
        } else {
          console.log('插入成功:', insertData);
        }
      }
    }
    
  } catch (error) {
    console.error('操作失败:', error);
  }
}

checkTable();