Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/admin.sql @ 54:36d91dfe017f
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; |