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

comparison database/schema/admin.sql @ 44:812c956dd0e9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 debc55088b4f
children 36d91dfe017f
comparison
equal deleted inserted replaced
43:debc55088b4f 44:812c956dd0e9
17 ) 17 )
18 WITHOUT OIDS; 18 WITHOUT OIDS;
19 19
20 -- this is not configurable as the logic for recognizing these is open-coded 20 -- this is not configurable as the logic for recognizing these is open-coded
21 -- XXX should probably use an enum type for this instead 21 -- XXX should probably use an enum type for this instead
22 INSERT INTO adminmaintypes VALUES ('locked', 'Comments on locked PRs'); 22 INSERT INTO adminmailtypes VALUES ('locked', 'Comments on locked PRs');
23 INSERT INTO adminmaintypes VALUES ('fbounces', 'Feedback nag-mail bounces'); 23 INSERT INTO adminmailtypes VALUES ('nonexistent', 'Comments on nonexistent PRs');
24 INSERT INTO adminmaintypes VALUES ('rbounces', 'Responsible nag-mail bounces'); 24 INSERT INTO adminmailtypes VALUES ('fbounces', 'Feedback nag-mail bounces');
25 INSERT INTO adminmaintypes VALUES ('bounces', 'Other bounces'); 25 INSERT INTO adminmailtypes VALUES ('rbounces', 'Responsible nag-mail bounces');
26 INSERT INTO adminmaintypes VALUES ('junk', 'Unrecognized mail traffic'); 26 INSERT INTO adminmailtypes VALUES ('bounces', 'Other bounces');
27 INSERT INTO adminmailtypes VALUES ('junk', 'Unrecognized mail traffic');
27 28
28 CREATE TABLE adminmailqueue ( 29 CREATE TABLE adminmailqueue (
29 rawmsg bigint not null references rawmail, 30 rawmsg bigint not null references rawmail,
30 type text not null references adminmailtypes, 31 type text not null references adminmailtypes,
31 pr bigint null references PRs, 32 pr bigint null references PRs,