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

diff 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
line wrap: on
line diff
--- a/database/schema/admin.sql	Sat Apr 02 21:15:27 2022 -0400
+++ b/database/schema/admin.sql	Sun Apr 10 17:41:24 2022 -0400
@@ -13,7 +13,7 @@
 
 CREATE TABLE adminmailtypes (
 	type text		primary key,
-	desc text
+	description text	not null
 )
 WITHOUT OIDS;
 
@@ -30,6 +30,6 @@
 	rawmsg bigint		not null references rawmail,
 	type text		not null references adminmailtypes,
 	pr bigint		null references PRs,
-	user bigint		null references users
+	userid bigint		null references users
 )
 WITHOUT OIDS;