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

comparison database/schema/messages.sql @ 29:cd36b49f4437

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix. now loads into postgresql92
author David A. Holland
date Sun, 26 May 2013 23:24:45 -0400
parents 5bf0d6f732c1
children edf081d0b282
comparison
equal deleted inserted replaced
28:000519947282 29:cd36b49f4437
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 timestamp not null, 23 posttime 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,