functional ajax implementations for all modules;minor sql updates