Latest AS Changes

Dear Josh,

Here are the latest database oriented changes that I have.