--- a/pgsql/create_tables-dovecot-1.2.x.pgsql	Mon Feb 07 21:50:44 2011 +0000
+++ b/pgsql/create_tables-dovecot-1.2.x.pgsql	Tue Feb 08 13:43:35 2011 +0000
@@ -119,7 +119,7 @@
     messages    integer NOT NULL DEFAULT 0,
     CONSTRAINT  pkey_userquota PRIMARY KEY (uid),
     CONSTRAINT  fkey_userquota_uid_users FOREIGN KEY (uid)
-        REFERENCES users (uid)
+        REFERENCES users (uid) ON DELETE CASCADE
 );
 
 CREATE TABLE alias (