[api] fix structure.sql
[webui] fix spider test suite