# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1554544223 -32400
# Node ID d63b9b287ae9e1017ad5742cb22c1b4a3f367af9
# Parent  ce6d0f04f520f25fa50cdf1a492722bf752a2c88
Define VIEW gecoses after all table construction

diff -r ce6d0f04f520 -r d63b9b287ae9 s4-init.sh
--- a/s4-init.sh	Sat Apr 06 18:46:10 2019 +0900
+++ b/s4-init.sh	Sat Apr 06 18:50:23 2019 +0900
@@ -88,6 +88,11 @@
 SELECT user, tbl, tblrowid, max(time) time FROM tblaccesses
 GROUP by user, tbl, tblrowid;"
 
+for f in $formdir/*def; do
+  echo -n Creating form of $f...
+  create_struct $f && echo Done || echo FAILED
+done
+
 create view gecoses "AS
 SELECT rowid,
        name,
@@ -102,9 +107,3 @@
 FROM (SELECT rowid,'user' type,name FROM user
 UNION ALL
 SELECT rowid,'group' type, gname FROM grp) a;"
-
-
-for f in $formdir/*def; do
-  echo -n Creating form of $f...
-  create_struct $f && echo Done || echo FAILED
-done