sql updates; adding foundation; resolving paths