Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/logs.sql @ 12:d4c3bd255653
"timestamp", not "date". from asau
author | David A. Holland |
---|---|
date | Thu, 19 Jul 2012 15:00:13 -0400 |
parents | 68cc276ac118 |
children | cd36b49f4437 |
comparison
equal
deleted
inserted
replaced
11:d42c0db81e28 | 12:d4c3bd255653 |
---|---|
2 CREATE TABLE adminlog ( | 2 CREATE TABLE adminlog ( |
3 -- who (null means "swallowtail"), where, when, what, why | 3 -- who (null means "swallowtail"), where, when, what, why |
4 who bigint null references users (id), | 4 who bigint null references users (id), |
5 pr bigint not null references PRs (id), | 5 pr bigint not null references PRs (id), |
6 change text not null, | 6 change text not null, |
7 when date not null, | 7 when timestamp not null, |
8 comment text not null | 8 comment text not null |
9 | 9 |
10 -- if a message was posted, this is the one | 10 -- if a message was posted, this is the one |
11 msgid bigint null references messages (id), | 11 msgid bigint null references messages (id), |
12 ) | 12 ) |