Performed a large re-factor by moving projects around and also added support for the hierarchy id. We no longer use recursive tables.