#!/bin/zsh -f
repeat 23 x=$x'$RANDOM$RANDOM$(([##36]RANDOM))$(([##36]RANDOM))$(([##36]RANDOM))$(([##36]RANDOM)),'
x=$x'$RANDOM'
#echo x=$x
eval "echo $x"
for i in {3000..9999}; do
  uid=C12$i
  echo -n ${uid},
  eval "echo $x"
done > dummy.csv
cat <<EOF | sqlite3 -csv data.sq3
drop table d;
create table d(uid primary key, kname text, hname text, sex varchar(1),
	grade integer, stay integer, photo text, housing text, pref text,
	city text, street text, phone text, mobphone text, email text,
	hiscaddr text, hisc text, hiscdep text, hisccourse text,
	hiscgrad text, enttype text, trans_grade integer, trans_from text,
	trans_from_dep text, trans_from_major text, trans_date);
.import dummy.csv d
EOF