#!/bin/sh
export PGPASSWORD=PYnuOIXNbkVOvdTL
P="psql -h 127.0.0.1 -U bgar1_delta_com -d bgar1_delta_com_ingredi"
echo "== membership schema"
$P -tA -c "select column_name from information_schema.columns where table_name='auth_object_membership' order by ordinal_position" | tr '\n' ' '; echo
echo "== teams"
$P -tA -c "select count(*) from support_desk_teams"
$P -tA -F' | ' -c "select id,name from support_desk_teams order by id" | head -30
echo "== groups (type 3)"
$P -tA -F' | ' -c "select id,name,provider_id from auth_object where type=3 order by name" | head -40
