Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/messages.sql @ 37:edf081d0b282
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, |