SPECTRA INSTRUMENTS_

⚠ Tablas de usuario no creadas aún. Ejecuta este SQL en Supabase → SQL Editor:

-- Perfiles de usuario
CREATE TABLE user_profiles (
  id UUID PRIMARY KEY REFERENCES auth.users(id) ON DELETE CASCADE,
  nombre TEXT DEFAULT '',
  empresa TEXT DEFAULT '',
  rut TEXT DEFAULT '',
  telefono TEXT DEFAULT '',
  ciudad TEXT DEFAULT '',
  direccion TEXT DEFAULT '',
  created_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE user_profiles ENABLE ROW LEVEL SECURITY;
GRANT SELECT, INSERT, UPDATE ON user_profiles TO authenticated;
CREATE POLICY "Own profile" ON user_profiles FOR ALL USING (auth.uid() = id);

-- Favoritos
CREATE TABLE favoritos (
  id BIGSERIAL PRIMARY KEY,
  user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE,
  product_id TEXT NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  UNIQUE(user_id, product_id)
);
ALTER TABLE favoritos ENABLE ROW LEVEL SECURITY;
GRANT SELECT, INSERT, DELETE ON favoritos TO authenticated;
CREATE POLICY "Own favorites" ON favoritos FOR ALL USING (auth.uid() = user_id);

-- Vincular pedidos a usuarios
ALTER TABLE pedidos ADD COLUMN IF NOT EXISTS user_id UUID REFERENCES auth.users(id);
CREATE POLICY "User sees own orders" ON pedidos FOR SELECT TO authenticated USING (auth.uid() = user_id);