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 )