changeset 31:12a4c9f88510

accidentally left "organization" out of usermail
author David A. Holland
date Mon, 27 May 2013 23:15:55 -0400
parents 90ec9e3b0a6f
children 7458a278cb64
files database/schema/users.sql
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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
 ;