added user directory and various missing table indexes