Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/logs.sql @ 8:68cc276ac118
SQL material from old tree, split up for accessibility.
author | David A. Holland |
---|---|
date | Sun, 19 Feb 2012 19:54:48 -0500 |
parents | |
children | d4c3bd255653 |
comparison
equal
deleted
inserted
replaced
7:c013fb703183 | 8:68cc276ac118 |
---|---|
1 -- log of administrative changes over time | |
2 CREATE TABLE adminlog ( | |
3 -- who (null means "swallowtail"), where, when, what, why | |
4 who bigint null references users (id), | |
5 pr bigint not null references PRs (id), | |
6 change text not null, | |
7 when date not null, | |
8 comment text not null | |
9 | |
10 -- if a message was posted, this is the one | |
11 msgid bigint null references messages (id), | |
12 ) | |
13 WITHOUT OIDS; |