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

comparison database/schema/users.sql @ 12:d4c3bd255653

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
"timestamp", not "date". from asau
author David A. Holland
date Thu, 19 Jul 2012 15:00:13 -0400
parents 68cc276ac118
children cd36b49f4437
comparison
equal deleted inserted replaced
11:d42c0db81e28 12:d4c3bd255653
56 id bigint not null references users (id), 56 id bigint not null references users (id),
57 selected boolean not null, 57 selected boolean not null,
58 email text not null, 58 email text not null,
59 organization text , 59 organization text ,
60 webpassword text , 60 webpassword text ,
61 lastheardfrom date 61 lastheardfrom timestamp
62 ) 62 )
63 WITHOUT OIDS; 63 WITHOUT OIDS;
64 64
65 CREATE VIEW usermail AS 65 CREATE VIEW usermail AS
66 SELECT id, username, realname, email, 66 SELECT id, username, realname, email,