[Pypi-checkins] r786 - trunk/pypi/tools

[martin.von.loewis]

Author: martin.von.loewis
Date: Fri Jul 23 18:22:59 2010
New Revision: 786

Modified:
   trunk/pypi/tools/daily.sql
Log:
Delete openids of expired users.


Modified: trunk/pypi/tools/daily.sql
==============================================================================
--- trunk/pypi/tools/daily.sql	(original)
+++ trunk/pypi/tools/daily.sql	Fri Jul 23 18:22:59 2010
@@ -2,4 +2,5 @@
 delete from cookies where last_seen < now()-INTERVAL'1day';
 delete from openid_sessions where expires < now();
 delete from openid_nonces where created < now()-INTERVAL'1day'; 
-delete from users where name in (select name from rego_otk where date < now()-INTERVAL'7days');
\ No newline at end of file
+delete from openids where name in (select name from rego_otk where date < now()-INTERVAL'7days');
+delete from users where name in (select name from rego_otk where date < now()-INTERVAL'7days');