--- a/database/schema/users.sql	Sun May 26 22:13:33 2013 -0400
+++ b/database/schema/users.sql	Sun May 26 23:24:45 2013 -0400
@@ -48,7 +48,7 @@
 	admin boolean		not null
 
 	-- responsible implies oldresponsible
-	check NOT (responsible AND NOT oldresponsible)
+	check (oldresponsible OR NOT responsible)
 )
 WITHOUT OIDS;
 
@@ -63,7 +63,7 @@
 WITHOUT OIDS;
 
 CREATE VIEW usermail AS
-   SELECT id, username, realname, email,
+   SELECT users.id AS id, username, realname, email,
           mailto, responsible, editpr, admin
    FROM users, mailaddresses
    WHERE users.id = mailaddresses.id AND mailaddresses.selected