Index: user/des/fbce/db/notes
===================================================================
--- user/des/fbce/db/notes	(revision 299986)
+++ user/des/fbce/db/notes	(revision 299987)
@@ -1,78 +1,73 @@
 #!/bin/sh
 #
 # These are instructions for creating and populating the FBCE
 # database.  Note that although this is a syntactically correct shell
 # script, it will not (or at least should not) run unmodified.
 #
 # $FreeBSD$
 #
 
 # Initialize PostgreSQL
 sudo service postgresql initdb
 sudo service postgresql start
 
 # Create a superuser for myself
 sudo -u pgsql createuser -s des
 
 # Create a regular user and database for FBCE
 createuser -S -D -R fbce
 createdb -E utf8 -O fbce fbce
 
 # Create the schema
 psql -f db/fbce.sql fbce fbce
 
 # Regenerate the DBIC schema
 #
 # Note that this will not overwrite lib/FBCE/Model/FBCE.pm, but
 # instead create lib/FBCE/Model/FBCE.pm.new.  You may replace the old
 # file with the new, but you should remove the connect_info and place
 # it in fbce_local.conf instead (copy the <Model::FBCE> section from
 # fbce.conf and insert the correct host, user and password).
 #
 ./db/update.sh fbce
 
 # One-liner to set a user's password
 perl -Ilib -MFBCE -e 'FBCE->model("FBCE::Person")->find({ login => "kenneth36" })->set_password("4ltInn!?")'
 
 #
-# The list of users is extracted from fst3k:
+# The list of users is generated on freefall using scripts written for
+# that purpose by gjb:
 #
-# fst3k=# \t on
-# Showing only tuples.
-# fst3k=# \o users-20160518.txt
-# fst3k=# select login from persons where login != 'cvs2svn';
-# fst3k=# \o
-#
-# Real names are taken from freefall:
-#
+# des@freefall ~% ~gjb/bin/genuserlist.sh                          
+# des@freefall ~% sort users.txt >users-20160518.txt
 # des@freefall ~% getent passwd >gecos-20160518.txt
 #
 ./script/fbce_user.pl import users-20160518.txt
 ./script/fbce_user.pl gecos gecos-20160518.txt
-./script/fbce_user.pl smash
 
 #
 # The list of active committers is extracted from fst3k:
 #
 # fst3k=# \t on
 # Showing only tuples.
 # fst3k=# \o active-20160518.txt
 # fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '2015-05-18' group by p.login;
 # fst3k=# \o
 #
+./script/fbce_user.pl smash
 ./script/fbce_user.pl activate active-20160518.txt
 
 #
 # The list of incumbents is obtained from freefall:
 #
-# des@freefall ~% getent group core | cut -d: -f4 | tr , '\n' >core-20160518.txt
+# des@freefall ~% getent group core | grep -v matthew | cut -d: -f4 | tr , '\n' >core-20160518.txt
 #
 ./script/fbce_user.pl incumbent core-20160518.txt
 
 #
 # Finally, generate passwords
 #
 ./script/fbce_user.pl pwgen
 
 # Print the logins of active users who haven't voted
 perl -Ilib -MFBCE -e 'map { print $_->login, "\n" } grep { $_->active && $_->votes_voters->count == 0 } FBCE->model("FBCE::Person")->all'