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

comparison database/schema/messages.sql @ 37:edf081d0b282

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Need to retain the mime-type of messages.
author David A. Holland
date Sun, 15 Jun 2014 17:13:50 -0400
parents cd36b49f4437
children 44c1509055c7
comparison
equal deleted inserted replaced
36:baf976e34f16 37:edf081d0b282
19 id bigint primary key default nextval('next_msgid'), 19 id bigint primary key default nextval('next_msgid'),
20 pr bigint not null references prs (id), 20 pr bigint not null references prs (id),
21 who bigint not null references users (id), 21 who bigint not null references users (id),
22 parent_id bigint null references messages (id), 22 parent_id bigint null references messages (id),
23 posttime timestamp not null, 23 posttime timestamp not null,
24 contenttype text not null,
24 body text not null, 25 body text not null,
25 26
26 -- we don't keep these directly, they go into an admin log entry 27 -- we don't keep these directly, they go into an admin log entry
27 --from_address text not null, 28 --from_address text not null,
28 --mail_subject text not null, 29 --mail_subject text not null,