s4

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 diff
     1.1 --- a/s4-init.sh	Tue Aug 02 07:19:48 2016 +0859
     1.2 +++ b/s4-init.sh	Tue Aug 02 10:08:34 2016 +0859
     1.3 @@ -86,7 +86,9 @@
     1.4  	      	    WHERE g.gname=name AND key='gecos')
     1.5  	 end,
     1.6  	 name) gecos
     1.7 -FROM (SELECT rowid,name FROM user UNION ALL SELECT rowid,gname FROM grp) a;"
     1.8 +FROM (SELECT rowid,'user' type,name FROM user
     1.9 +UNION ALL
    1.10 +SELECT rowid,'group' type, gname FROM grp) a;"
    1.11  
    1.12  
    1.13  for f in $formdir/*def; do