Mercurial > ~dholland > hg > swallowtail > index.cgi

diff database/schema/users.sql @ 31:12a4c9f88510

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
accidentally left "organization" out of usermail
author David A. Holland
date Mon, 27 May 2013 23:15:55 -0400 (2013-05-28)
parents cd36b49f4437
children 40f64a96481f
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
 ;