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

comparison database/schema/messages.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 5bf0d6f732c1
comparison
equal deleted inserted replaced
11:d42c0db81e28 12:d4c3bd255653
18 CREATE TABLE messages ( 18 CREATE TABLE messages (
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 when date not null, 23 when timestamp not null,
24 body text not null, 24 body text not null,
25 25
26 -- we don't keep these directly, they go into an admin log entry 26 -- we don't keep these directly, they go into an admin log entry
27 --from_address text not null, 27 --from_address text not null,
28 --mail_subject text not null, 28 --mail_subject text not null,