FfiiMembership

The membership data is stored in multiple tables within the database "ffii" on vic (postgresql):

asoc

asolack

??, no permissions

mail

padr

pnom

teln

pass

Some useful queries

Get member info from country BE:

psql ffii

ffii=# \o /home/dietvu/ffii.csv;

ffii=# select distinct * from mail left outer join teln on (teln.uid = mail.uid) inner join pnom on (pnom.uid = mail.uid) inner join padr on (padr.uid = mail.uid) left outer join asoc on ( asoc.uid = mail.uid) where "land" = 'be';

email only: ffii=# select distinct mailuser, mailhost from mail left outer join teln on (teln.uid = mail.uid) inner join pnom on (pnom.uid = mail.uid) inner join padr on (padr.uid = mail.uid) left outer join asoc on ( asoc.uid = mail.uid) where "land" = 'be';

Observations during manual correction

A lot of double records, only difference is organisation (nothing/ffii/ael) or norm/subs status for mailing lists.

FfiiMembership (last edited 2009-05-30 23:35:19 by localhost)