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

[martin.von.loewis]

Author: martin.von.loewis
Date: Wed Nov 30 10:32:36 2011
New Revision: 996

Modified:
   trunk/pypi/tools/sql-migrate-20111130.sql
Log:
Support renaming users in cookies


Modified: trunk/pypi/tools/sql-migrate-20111130.sql
==============================================================================
--- trunk/pypi/tools/sql-migrate-20111130.sql	(original)
+++ trunk/pypi/tools/sql-migrate-20111130.sql	Wed Nov 30 10:32:36 2011
@@ -6,3 +6,7 @@
 alter table roles drop constraint "$1";
 alter table roles add foreign key (user_name) references users (name) on update cascade;
 end;
+begin;
+alter table cookies drop constraint cookies_name_fkey;
+alter table cookies add foreign key (name) references users (name) on update cascade;
+end;