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

annotate database/schema/logs.sql @ 32:7458a278cb64

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
forgot modified_date
author David A. Holland
date Mon, 27 May 2013 23:16:12 -0400
parents cd36b49f4437
children 40f64a96481f
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
1 -- log of administrative changes over time
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
2 CREATE TABLE adminlog (
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
3 -- who (null means "swallowtail"), where, when, what, why
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
4 who bigint null references users (id),
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
5 pr bigint not null references PRs (id),
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
6 change text not null,
29
David A. Holland
parents: 12
diff changeset
7 posttime timestamp not null,
David A. Holland
parents: 12
diff changeset
8 comment text not null,
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
9
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
10 -- if a message was posted, this is the one
29
David A. Holland
parents: 12
diff changeset
11 msgid bigint null references messages (id)
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
12 )
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
13 WITHOUT OIDS;