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

comparison database/schema/admin.sql @ 54:36d91dfe017f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
use valid sql syntax, mostly from yetoo on freenode
author David A. Holland
date Sun, 10 Apr 2022 17:41:24 -0400
parents 812c956dd0e9
children 40f64a96481f
comparison
equal deleted inserted replaced
53:62d82881799f 54:36d91dfe017f
11 -- out what it's about, which we sometimes can but often can't. 11 -- out what it's about, which we sometimes can but often can't.
12 -- 12 --
13 13
14 CREATE TABLE adminmailtypes ( 14 CREATE TABLE adminmailtypes (
15 type text primary key, 15 type text primary key,
16 desc text 16 description text not null
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
28 28
29 CREATE TABLE adminmailqueue ( 29 CREATE TABLE adminmailqueue (
30 rawmsg bigint not null references rawmail, 30 rawmsg bigint not null references rawmail,
31 type text not null references adminmailtypes, 31 type text not null references adminmailtypes,
32 pr bigint null references PRs, 32 pr bigint null references PRs,
33 user bigint null references users 33 userid bigint null references users
34 ) 34 )
35 WITHOUT OIDS; 35 WITHOUT OIDS;