Mercurial > ~dholland > hg > swallowtail > index.cgi
view database/schema/logs.sql @ 14:dfd62aad74f4
note that the test environment hasn't been merged into this tree yet.
(from last Feb.)
author | David A. Holland |
---|---|
date | Mon, 03 Sep 2012 13:41:57 -0400 |
parents | d4c3bd255653 |
children | cd36b49f4437 |
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, when timestamp not null, comment text not null -- if a message was posted, this is the one msgid bigint null references messages (id), ) WITHOUT OIDS;