[Pypi-checkins] r884 - in trunk/pypi: . tools

[martin.von.loewis]

Author: martin.von.loewis
Date: Sun Feb 20 23:33:49 2011
New Revision: 884

Added:
   trunk/pypi/tools/sql-migrate-20110220.sql   (contents, props changed)
Modified:
   trunk/pypi/pkgbase_schema.sql
Log:
Cascade renamed into comments_journal.


Modified: trunk/pypi/pkgbase_schema.sql
==============================================================================
--- trunk/pypi/pkgbase_schema.sql	(original)
+++ trunk/pypi/pkgbase_schema.sql	Sun Feb 20 23:33:49 2011
@@ -274,7 +274,7 @@
   submitted_by TEXT REFERENCES users ON DELETE CASCADE,
   date TIMESTAMP,
   action TEXT,
-  FOREIGN KEY (name, version) REFERENCES releases (name, version) ON DELETE CASCADE
+  FOREIGN KEY (name, version) REFERENCES releases ON UPDATE CASCADE ON DELETE CASCADE
 );
 
 commit;

Added: trunk/pypi/tools/sql-migrate-20110220.sql
==============================================================================
--- (empty file)
+++ trunk/pypi/tools/sql-migrate-20110220.sql	Sun Feb 20 23:33:49 2011
@@ -0,0 +1,6 @@
+begin;
+alter table comments_journal drop constraint comments_journal_name_fkey;
+alter table comments_journal 
+  add foreign key (name, version) references releases 
+  on update cascade on delete cascade;
+end;