Mercurial > ~dholland > hg > swallowtail > index.cgi

comparison database/schema/logs.sql @ 29:cd36b49f4437

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix. now loads into postgresql92
author David A. Holland
date Sun, 26 May 2013 23:24:45 -0400
parents d4c3bd255653
children 40f64a96481f
comparison
equal deleted inserted replaced
28:000519947282 29:cd36b49f4437
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 timestamp not null, 7 posttime 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 )
13 WITHOUT OIDS; 13 WITHOUT OIDS;