# HG changeset patch
# User David A. Holland
# Date 1369710955 14400
# Node ID 12a4c9f885104be4bb77c256966efb897f9dbb82
# Parent  90ec9e3b0a6fe112fa4c4cdcd61a3e3d360780ab
accidentally left "organization" out of usermail

diff -r 90ec9e3b0a6f -r 12a4c9f88510 database/schema/users.sql
--- a/database/schema/users.sql	Mon May 27 23:15:31 2013 -0400
+++ b/database/schema/users.sql	Mon May 27 23:15:55 2013 -0400
@@ -63,8 +63,8 @@
 WITHOUT OIDS;
 
 CREATE VIEW usermail AS
-   SELECT users.id AS id, username, realname, email,
-          mailto, responsible, editpr, admin
+   SELECT users.id AS id, username, realname, email, organization,
+          mailto, oldresponsible, responsible, editpr, admin
    FROM users, mailaddresses
    WHERE users.id = mailaddresses.id AND mailaddresses.selected
 ;