diff --git a/jtserv/inittbl.sh b/jtserv/inittbl.sh index 8ec7087..c5efbcd 100755 --- a/jtserv/inittbl.sh +++ b/jtserv/inittbl.sh @@ -13,7 +13,7 @@ CREATE TEMPORARY TABLE teamcsv(teamno,teamname,user,name); .import $CSV teamcsv - DELETE FROM teamcsv WHERE name LIKE 'name'; + DELETE FROM teamcsv WHERE name LIKE 'name' OR name LIKE 'gecos'; INSERT INTO teams SELECT distinct teamname FROM teamcsv WHERE teamname NOT IN (SELECT team FROM teams); INSERT INTO users SELECT user, name, user||'@itl.koeki-u.ac.jp', teamname