-- 1. Tabla de perfiles (extiende auth.users) CREATE TABLE IF NOT EXISTS profiles ( id uuid PRIMARY KEY REFERENCES auth.users(id) ON DELETE CASCADE, email text, name text, photo text, role text DEFAULT 'user', last_login timestamptz, disabled boolean DEFAULT false ); -- 2. Tabla de sesiones (log de accesos) CREATE TABLE IF NOT EXISTS sessions ( id uuid DEFAULT gen_random_uuid() PRIMARY KEY, user_id uuid REFERENCES auth.users(id) ON DELETE CASCADE, email text, name text, login_at timestamptz DEFAULT now(), user_agent text ); -- 3. Tabla de invitaciones pendientes CREATE TABLE IF NOT EXISTS pending_invites ( id uuid DEFAULT gen_random_uuid() PRIMARY KEY, email text, name text, role text DEFAULT 'user', invited_by text, invited_at timestamptz DEFAULT now(), status text DEFAULT 'pending' ); -- 4. Habilitar acceso para usuarios autenticados ALTER TABLE profiles ENABLE ROW LEVEL SECURITY; ALTER TABLE sessions ENABLE ROW LEVEL SECURITY; ALTER TABLE pending_invites ENABLE ROW LEVEL SECURITY; CREATE POLICY "auth_profiles" ON profiles FOR ALL TO authenticated USING (true) WITH CHECK (true); CREATE POLICY "auth_sessions" ON sessions FOR ALL TO authenticated USING (true) WITH CHECK (true); CREATE POLICY "auth_invites" ON pending_invites FOR ALL TO authenticated USING (true) WITH CHECK (true);