changeset 277:cfbedd0686dd

Add `type' column to view:gecoses
author HIROSE Yuuji <yuuji@gentei.org>
date Tue, 02 Aug 2016 10:08:34 +0859
parents 1966552d05a9
children 2f1607d8b56b
files s4-init.sh
diffstat 1 files changed, 3 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/s4-init.sh	Tue Aug 02 07:19:48 2016 +0859
+++ b/s4-init.sh	Tue Aug 02 10:08:34 2016 +0859
@@ -86,7 +86,9 @@
 	      	    WHERE g.gname=name AND key='gecos')
 	 end,
 	 name) gecos
-FROM (SELECT rowid,name FROM user UNION ALL SELECT rowid,gname FROM grp) a;"
+FROM (SELECT rowid,'user' type,name FROM user
+UNION ALL
+SELECT rowid,'group' type, gname FROM grp) a;"
 
 
 for f in $formdir/*def; do

yatex.org