added indices on foreign keys, views are still slow at loading though. b...

...alls.
Also, migrate when you pull from the master of disaster.