Mercurial > ~dholland > hg > swallowtail > index.cgi
view database/schema/logs.sql @ 10:1720f45dd495
Replace insane handling of states with something more likely workable.
author | David A. Holland |
---|---|
date | Sun, 19 Feb 2012 20:21:51 -0500 |
parents | 68cc276ac118 |
children | d4c3bd255653 |
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 date not null, comment text not null -- if a message was posted, this is the one msgid bigint null references messages (id), ) WITHOUT OIDS;