Mercurial > ~dholland > hg > swallowtail > index.cgi
annotate database/schema/logs.sql @ 44:812c956dd0e9
Add another admin queue type for comments on nonexistent PRs.
Also, correct stupid spelling mistake. Need to get the test harness
running again.
| author | David A. Holland |
|---|---|
| date | Mon, 16 Jun 2014 01:27:45 -0400 |
| parents | cd36b49f4437 |
| children | 40f64a96481f |
| 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 | 7 posttime timestamp not null, |
| 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 | 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; |