Review PK, FK, Index names and rename to the proper naming convention.

[Jorriss]

Format is as follows:
Primary Keys: PK_TableName__ColumnName
Foreign Keys: FK_TableName__ColumnName__to__TableName__ColumnName
Foreign Keys: IX_TableName__ColumnName_ColumnName