Mercurial > ~dholland > hg > swallowtail > index.cgi
view database/schema/logs.sql @ 41:81851564f552
The initial description, how_to_repeat, and fix go in the first message.
Storing them separately only creates a pile of special cases.
author | David A. Holland |
---|---|
date | Sun, 15 Jun 2014 17:55:56 -0400 |
parents | cd36b49f4437 |
children | 40f64a96481f |
line wrap: on
line source
-- log of administrative changes over time CREATE TABLE adminlog ( -- who (null means "swallowtail"), where, when, what, why who bigint null references users (id), pr bigint not null references PRs (id), change text not null, posttime timestamp not null, comment text not null, -- if a message was posted, this is the one msgid bigint null references messages (id) ) WITHOUT OIDS;