[3471] in Moira
Re: ttsp back online
daemon@ATHENA.MIT.EDU (Jonathon Weiss)
Sat Sep 10 17:58:00 2005
Message-Id: <200509102157.j8ALvrIJ001893@bearing-an-hourglass.mit.edu>
From: Jonathon Weiss <jweiss@MIT.EDU>
To: Garry Zacheiss <zacheiss@MIT.EDU>
cc: moira-admin@MIT.EDU, moiradev@MIT.EDU
In-reply-to: Your message of "Thu, 25 Aug 2005 17:28:32 EDT."
<200508252128.j7PLSXsf006114@sipb-office-escape-pod.mit.edu>
Date: Sat, 10 Sep 2005 17:57:52 -0400
> ttsp is back online. It's database looks like what I expect the
> production server's database to look like after the purge is complete.
>
> moira-admin: the procedure I followed is at
> /afs/ops/user/zacheiss/purge.sql,
I have a couple of questions:
In the "prep for grouper purge" section in the three select
statements, rather than comparing the listnames at the end of the
statement, why not just look for "l.list_id not in (select list_id
from grouperpurge)" Or am I confused about what you're trying to do
here?
I'm not sure exactly how the userhistory table will be used in the
future, but would it be useful to add a column that is a the timestamp
of when the row was added to the userhistory table?
Jonathon
