Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/logs.sql @ 29:cd36b49f4437
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; |