Mercurial > ~dholland > hg > swallowtail > index.cgi
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 ;